Compound annual growth rate (CAGR) is the steady yearly rate that would take a value from its starting level to its ending level over a given number of years. Use it to compare investments, revenue or any quantity measured over different time spans on a like-for-like basis.
How to use the CAGR calculator
- Enter the Starting value, which must be greater than zero.
- Enter the Ending value. Zero is allowed and gives −100%.
- Enter the number of Years between the two values. Fractions are fine, such as 2.5 for two and a half years.
- Read the CAGR as a percentage per year.
How the cagr calculation works
CAGR versus the average annual return
CAGR = ((end ÷ start)^(1 ÷ years) − 1) × 100. It describes the smooth path between two points and ignores what happened in between. An investment that rises 50% and then falls 50% has an arithmetic average return of 0%, yet it ends at 75% of where it started, a CAGR of about −13.4%. CAGR is the figure that matches the actual outcome.
That makes CAGR good for comparing results, and poor at describing risk. Two funds with the same CAGR can have very different ups and downs along the way.
When CAGR misleads
The formula assumes no money went in or out between the start and end. If you added contributions, the ending value includes your own deposits and the CAGR overstates the return. For an account with regular deposits, a money-weighted measure such as the internal rate of return is the better choice.
Choose the period carefully. A start date at a market low or an end date at a peak can make almost any asset look strong. Comparing several periods, or using the same dates for every investment you compare, keeps the figure honest. For a simple total percentage gain without annualizing, use the ROI Calculator.
Worked example
Starting value: 10000 · Ending value: 18000 · Years: 6
- Growth multiple = 18,000 ÷ 10,000 = 1.8.
- Take the sixth root: 1.8^(1/6) ≈ 1.102924.
- Subtract 1 and multiply by 100: ≈ 10.292357%.
- Check: 10,000 × 1.102924^6 ≈ 18,000.
Result: 10.292357 %
Assumptions and limits
No intermediate cash flows; a zero ending balance corresponds to −100%.
Formula and worked examples last checked November 20, 2026. Spotted a problem? Report an error.
Frequently asked questions
How do you calculate CAGR in Excel?
Use =(end/start)^(1/years)-1 and format the cell as a percentage. For 10,000 to 18,000 over 6 years, =(18000/10000)^(1/6)-1 returns about 10.29%, matching this calculator. The RRI function gives the same answer.
Can CAGR be negative?
Yes. If the ending value is below the starting value, CAGR is negative. An ending value of zero gives −100%. A starting value of zero or less is rejected because growth from nothing cannot be expressed as a rate.
Is CAGR the same as annualized return?
For a single lump sum with no deposits or withdrawals, yes. When money moves in and out, CAGR on the account balance mixes your contributions with growth, and a money-weighted return is more accurate.
What is a good CAGR?
It depends entirely on what you are measuring and the risk involved. Compare a stock's CAGR with a relevant index over the same dates, or a company's revenue CAGR with competitors in its industry, rather than with a fixed benchmark.