CAGR calculator
The one yearly growth rate that turns your start value into your end value.
Compound annual growth rate
12.47%
- Total return
- 80.00%
- Gain
- $8,000
- Growth multiple
- 1.80x
- Doubling time
- 5.9 yrs
Year by year
| Year | Value | Year growth | Cumulative return |
|---|
How CAGR works
CAGR smooths an investment's ups and downs into one steady yearly rate, so you can compare holdings over different periods.
CAGR = (End value / Start value)1 / Years - 1
An example
$10,000 grows to $18,000 in 5 years: (18,000 / 10,000)1/5 - 1 = 12.47% a year. Compounding at 12.47% for 5 years gives the same $18,000, however bumpy the real path was.
Questions
What is a good CAGR?
It depends on the asset and the period. The S&P 500 has returned roughly 10% a year over the long run before inflation, so many investors use that as a yardstick for stocks.
What is the difference between CAGR and average return?
The average return adds up each year's return and divides by the years, which ignores compounding. CAGR is the one steady yearly rate that turns the start value into the end value. A gain of 50% followed by a loss of 50% averages 0%, while its CAGR is about -13.4%.
How do I calculate CAGR in Excel?
Use =(End/Start)^(1/Years)-1, or =RRI(Years, Start, End).
What does CAGR leave out?
It smooths the path: two investments with the same CAGR can have had very different swings. It also ignores money added or taken out along the way, and it looks only backwards.
Related tools
For education only, not financial advice. Results depend on the numbers you enter.