CAGR Calculator
Enter what an investment, a revenue figure or an audience was worth at the start and at the end, and how long it took. You get the compound annual growth rate, the total return, the growth multiple and a year-by-year table. A second mode starts from a rate and gives the ending value.
Compound annual growth rate
12.14% a year
Over 8 years
CAGR
12.1353%Total return
150%Growth multiple
2.5xGain
15,000At this rate the value doubles in about 6.05 years.
| Year | Value |
|---|---|
| 1 | 11,213.53 |
| 2 | 12,574.33 |
| 3 | 14,100.27 |
| 4 | 15,811.39 |
| 5 | 17,730.15 |
| 6 | 19,881.77 |
| 7 | 22,294.49 |
| 8 | 25,000 |
How it works
- Pick how you know the period: a number of years, two dates, or a growth rate to project forward.
- Enter the starting value and the ending value (or the rate), both above zero.
- Enter the years, or the start and end dates.
- Read the CAGR, the total return and the table, then copy the summary.
What people use it for
Judging an investment
Turn 10,000 that became 25,000 in 8 years into one yearly rate you can compare with a fund or a savings rate.
Business growth
Compare revenue, users or subscribers between two years on a smoothed yearly basis.
Setting a target
Work out where a yearly growth target of 7% takes a balance in 20 years.
Questions
- What is the formula?
- CAGR = (ending value ÷ starting value)^(1 ÷ years) − 1. Total return is ending ÷ starting − 1. The reverse mode uses ending value = starting value × (1 + rate)^years. The table applies the same yearly rate every year.
- How are two dates turned into years?
- As the real number of days between them divided by 365, the same convention as the XIRR function in spreadsheets. A span of exactly one non-leap year gives 1.0 years, and a span that includes 29 February gives slightly more.
- Why are zero and negative values refused?
- The formula takes a power of the ratio ending ÷ starting, which does not exist for a negative number and is meaningless for zero. If an amount went to zero or below, CAGR cannot describe it. Values are limited to 1,000,000,000,000,000 and periods to 1,000 years.
- Does CAGR show the real path of the investment?
- No. It is a smoothed rate: the value may have swung up and down along the way, and the table shows a steady path, not what happened. It ignores deposits, withdrawals, fees, taxes and inflation, so use it to compare two end points, not to predict.