CHAOSLESS · MAGAZINE

Finance without the noise.
Capital. People. Decisions.

MarketsDelayed
US DOLLAR INDEX—S&P 500 · SPY—NASDAQ 100 · QQQ—GOLD—BITCOIN—EUR/USD—
Architectural detail in warm light
TERM

What is CAGR, and how do you calculate it?

Returns jump around from year to year. CAGR turns them into one honest yearly number.

READING / TERM
Quick answer

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%
CAGR10.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.

Continue reading

The next chapter

01 / 04
AOS Guides · 4 minutes

How do you keep an investment journal? Template and examples

What to record before every trade, how to review it and why investors lose returns to timing.

Open the story ↗︎
An independent view on money
CHAOSLESS / GLOSSARY

Keep questioning what's possible.

MORE: GLOSSARY ↗︎