Investing & portfolio
What is CAGR? How to calculate it with examples
Advertisement
What is CAGR?
CAGR (compound annual growth rate) is the steady yearly rate that would take an investment from its starting value to its ending value. It smooths out the ups and downs, so you can compare investments held for different periods.
What is the CAGR formula?
CAGR = (Ending value ÷ Starting value)^(1 ÷ years) − 1.
In Excel or Google Sheets, use =(End/Start)^(1/Years)-1, or =RRI(Years, Start, End).
