What CAGR measures
The compound annual growth rate (CAGR) answers one question: what steady yearly rate would take this starting value to this ending value in this much time? Real growth is bumpy. A portfolio might gain 20% one year and lose 8% the next; a company’s sales might jump, stall and jump again. CAGR replaces that bumpy path with one smooth rate, so you can compare an investment, a business or any other figure across periods of different lengths.
Which calculator do I need?
- What did an investment earn? The ROI calculator: the total ROI and the annualized ROI, with up to three investments side by side.
- What yearly rate took a value from A to B? This calculator: the compound annual growth rate, or the end value, start value or years from a rate.
- What will regular contributions grow to? The investment calculator: the future value with monthly or yearly additions, or the return you need to reach a target.
The CAGR formula
Multiply the result by 100 to get a percentage. The same relationship can be turned around to find any of the other numbers:
Beginning value = ending value ÷ (1 + CAGR)^years
Years = ln(ending ÷ beginning) ÷ ln(1 + CAGR)
The calculator does all four. Choose CAGR, Ending value, Beginning value or Years needed at the top, then fill in the rest. Decimals are fine for years (2.5 means 2 years and 6 months). If you know the exact dates, switch to From dates: the calculator counts the days and divides by 365.25, the average length of a year including leap years.
Worked example 1: an investment
You put $10,000 into a fund and it is worth $25,000 five years later.
- Ending ÷ beginning = 25,000 ÷ 10,000 = 2.5
- 1 ÷ years = 1 ÷ 5 = 0.2
- 2.5^0.2 = 1.2011, so CAGR = 1.2011 − 1 = 20.11% a year
Check it: $10,000 × 1.2011⁵ ≈ $25,000. The absolute return over the whole period is 150%, and the money multiplied 2.5 times.
Worked example 2: business revenue
Revenue grew from $2.4 million to $3.9 million between 2021 and 2025. That is four years of growth (2021 to 2022, 2022 to 2023, 2023 to 2024 and 2024 to 2025), not five.
- (3.9 ÷ 2.4)^(1/4) − 1 = 1.625^0.25 − 1 = 12.91% a year
Counting the years correctly is the most common CAGR mistake. Count the gaps between the first and last value, not the number of values.
To see each year’s change on its own as well, work out the year-over-year growth: how to calculate year-over-year growth shows the YoY formula, the Excel version and how it differs from CAGR.
Worked example 3: a falling value
A share bought at $50 is worth $38 four years later.
- (38 ÷ 50)^(1/4) − 1 = 0.76^0.25 − 1 = −6.63% a year
A negative CAGR means the value shrank on average each year. If it falls all the way to zero, the CAGR is −100%.
Working backwards from a growth rate
The reverse modes answer planning questions:
| Question | Inputs | Answer |
|---|---|---|
| What will it grow to? | $10,000 at 10% a year for 5 years | $10,000 × 1.1⁵ = $16,105.10 |
| How much do I need now? | $25,000 target in 5 years at 10% a year | $25,000 ÷ 1.1⁵ = $15,523.03 |
| How long will it take? | $10,000 to $25,000 at 10% a year | ln(2.5) ÷ ln(1.1) = 9.61 years (about 9 years 7 months) |
These assume the rate holds steady every year, which real investments rarely do. Treat the answers as a guide, not a promise.
CAGR vs average annual return vs absolute return
Three numbers are often mixed up:
- Absolute return is the total change from start to end: (ending − beginning) ÷ beginning. It ignores time.
- Average annual return is the plain average of each year’s return. It ignores compounding.
- CAGR is the steady compounded rate that links the start to the end. It is the only one of the three you can plug back into “start × (1 + rate)^years” and get the right answer.
Take an investment of $1,000 that returns +10%, then −5%, then +20%:
| Measure | Working | Result |
|---|---|---|
| Ending value | 1,000 × 1.10 × 0.95 × 1.20 | $1,254 |
| Absolute return | (1,254 − 1,000) ÷ 1,000 | 25.40% |
| Average annual return | (10% − 5% + 20%) ÷ 3 | 8.33% a year |
| CAGR | (1,254 ÷ 1,000)^(1/3) − 1 | 7.84% a year |
The average annual return is higher than the CAGR, and that is always the case when returns vary from year to year. The extreme example makes the point: gain 100% and then lose 50%, and the average is 25% a year, yet you are back to exactly where you started. The CAGR is 0%.
The calculator also shows a simple yearly average (absolute return ÷ years). It is a quick figure some people quote, but it overstates growth for the same reason: it leaves out compounding. For $10,000 to $25,000 in 5 years it gives 30% a year, against a true CAGR of 20.11%.
How fast does money have to grow?
The table shows the CAGR needed to double or triple a value over different periods.
| Years | CAGR to double (2×) | CAGR to triple (3×) |
|---|---|---|
| 1 | 100.00% | 200.00% |
| 2 | 41.42% | 73.21% |
| 3 | 25.99% | 44.22% |
| 5 | 14.87% | 24.57% |
| 10 | 7.18% | 11.61% |
| 20 | 3.53% | 5.65% |
The rule of 72 is a quick reverse check: divide 72 by the yearly rate to estimate the years needed to double. At 8% a year it gives 9 years; the exact figure is 9.01 years. The calculator shows both the exact doubling time and the rule-of-72 estimate.
Adjusting for inflation
A 20% yearly gain is less impressive if prices rose fast over the same years. Open Adjust for inflation and enter the average inflation rate to get the real CAGR:
With a 20.11% CAGR and 3% inflation, the real CAGR is 1.2011 ÷ 1.03 − 1 = 16.61% a year. Simply subtracting (20.11 − 3 = 17.11%) is close for low rates but slightly overstates the result. For past inflation rates, use the official consumer price index for your country, such as the US Bureau of Labor Statistics CPI, or the inflation calculator.
CAGR in Excel and Google Sheets
With the beginning value in A2, the ending value in B2 and the number of years in C2:
=(B2/A2)^(1/C2)-1- or
=RRI(C2, A2, B2), which returns the same rate
Format the cell as a percentage. For exact dates, work out the years first with =(end_date-start_date)/365.25.
When CAGR is the wrong tool
- Money added or taken out along the way. CAGR only sees the first and last values. If you invested monthly, a $25,000 balance may be mostly your own deposits. Use a money-weighted return such as XIRR, or model the contributions with the investment calculator or the SIP calculator.
- Risk and volatility. Two investments can share a 7% CAGR while one moved smoothly and the other swung wildly. CAGR does not show the swings.
- Very short periods. Annualising a few months assumes the pace continues for a whole year. A 30% gain in 6 months becomes a 69% CAGR. The calculator warns you when the period is under a year.
- Cherry-picked start and end dates. Starting at a market low or ending at a peak can make any CAGR look good. Try a few different periods.
Tips for honest numbers
- Include income. For shares or funds, add reinvested dividends to the ending value, or use a total-return figure.
- Include costs. Add fees and commissions to the beginning value. Investor.gov, from the US SEC, explains how ongoing fees reduce returns over time.
- Compare like with like. Compare a CAGR with a benchmark, such as a broad index fund or a savings rate, over the same dates.
Related calculators
To compare up to three investments by total and annualised return, use the ROI calculator. To see how a fixed rate compounds with regular deposits, try the compound interest calculator. For a one-off percentage change between two numbers, the percentage increase calculator is quicker.
This calculator is for education. It is not investment or tax advice, and past growth does not predict future returns.