Compound annual growth rate (CAGR) is the constant yearly rate at which an investment would have grown from its starting value to its ending value, assuming gains were reinvested. $10,000 that grows to $16,105 in five years has a CAGR of 10%. Unlike a simple average of yearly returns, CAGR accounts for compounding and for bad years, so it is the fairer way to compare investments over different periods.
What it means
If one year is +30% and the next is −20%, the average is +5% — but you actually gained only 4% in total, about 2% a year. CAGR shows the real yearly pace.
How to calculate it
CAGR = (ending value ÷ starting value)^(1 ÷ years) − 1
An example
| Amount | |
|---|---|
| Starting value | $10,000 |
| Value after 5 years | $16,105 |
| Total gain (ROI) | 61% |
| CAGR | 10.0% a year |
Why it matters to you
CAGR lets you compare a 3-year investment with a 10-year one, or your portfolio with an index. Subtract inflation to see your real return.
What you can do
- Use CAGR, not average returns, when comparing funds or your own results.
- Include deposits and withdrawals carefully — CAGR assumes a single starting amount.
- Set realistic goals with a conservative growth rate: Financial goals.
FAQ
Does CAGR show risk?
No. Two investments with the same CAGR can have very different ups and downs.
What if I added money along the way?
Use a money-weighted return (IRR) instead; CAGR fits a single lump sum.
How do you calculate CAGR in Excel?
Use =(End/Start)^(1/Years)-1, for example =(B2/B1)^(1/5)-1 for five years, and format the cell as a percentage. Excel's built-in =RRI(years, start, end) gives the same result. For money added along the way, use XIRR instead. Compare it against inflation with the real return.
This article is for information only and is not investment, tax or legal advice. Figures are given with their source and date.
