Robince Studio
Finance Calculators

CAGR vs average return: why the simple average can mislead you

Two investments can both advertise a "10% average return" and leave you with very different amounts. CAGR, the compound annual growth rate, is the number that links your starting value to your ending value. This guide explains the difference with examples you can check by hand.

3 min read Reviewed Published by Abdul Gani, Robince Studio

On this page
  1. The CAGR formula
  2. Why a simple average fails
  3. A year-by-year example
  4. When to use which
  5. Limits of CAGR
  6. Comparing two investments fairly
  7. Calculating CAGR in a spreadsheet
  8. Frequently asked questions
  9. Try these tools

The CAGR formula

CAGR answers: what single steady yearly growth rate would take me from the starting value to the ending value over this many years? The formula is:

CAGR = (Ending value ÷ Starting value)^(1 ÷ years) − 1

Example: ₹1,00,000 grows to ₹2,00,000 in 5 years. The ratio is 2. The fifth root of 2 is about 1.1487, so CAGR is about 14.87% a year. Check it: 1,00,000 × 1.1487⁵ ≈ 2,00,000.

Why a simple average fails

Imagine an investment of ₹100 that rises 50% in year one and falls 50% in year two. The simple average of +50% and −50% is 0%, which sounds like break-even. But ₹100 rises to ₹150, then falls by half to ₹75. You lost 25%.

The problem is that percentage changes apply to different bases. A fall from a larger number takes away more than the same percentage gain added. Compounding makes returns multiply, not add, so the right average of growth rates is a geometric one, which is exactly what CAGR is.

Volatility drags on returns. For the same simple average, the more an investment swings, the lower its CAGR.

A year-by-year example

An investment goes 100 → 150 → 120 → 180 over three years. The yearly changes are +50%, −20% and +50%, and the simple average is 26.7%. The CAGR over the three years is (180 ÷ 100)^(1/3) − 1 ≈ 21.64%.

The 21.64% figure is the honest one: growing at a steady 21.64% a year for three years takes 100 to 180. The simple average of 26.7% would overstate the outcome, because 100 growing at 26.7% for three years would reach about 203.

When to use which

QuestionBest measure
How fast did my money actually grow over a long period?CAGR
How did one specific year perform?That year's return
Which of two funds did better over 5 years?CAGR over the same period
I added money at different times (SIPs, withdrawals)XIRR, which accounts for the timing of each cash flow

Limits of CAGR

  • It hides the path. Two investments can have the same CAGR but very different bumps along the way. Look at the worst year as well.
  • It depends on the start and end dates. Choosing a start just after a crash or an end just after a peak flatters the number. Compare several periods.
  • It works for a single starting amount. If you invested monthly, use XIRR, because CAGR assumes all the money was in from day one.
  • It is backward-looking. A past CAGR does not predict a future one.

When you see "average annual return" in an advertisement, check whether it is a simple average or CAGR. The difference can be several percentage points.

Comparing two investments fairly

Fund A grows from 100 to 160 in four years. Fund B grows from 100 to 170 in five years. B ended higher, but it also took longer. CAGR puts them on the same footing: A is (160 ÷ 100)^(1/4) − 1 ≈ 12.47% a year, while B is (170 ÷ 100)^(1/5) − 1 ≈ 11.20% a year. Fund A grew faster per year even though its final number is lower.

Always compare CAGR over the same period for a fair result. A fund that did well over five years may look different over ten, so look at several time frames.

Calculating CAGR in a spreadsheet

  • Formula for the rate: =(End/Start)^(1/Years)-1, then format the cell as a percentage.
  • Excel and Google Sheets also have RRI: =RRI(Years, Start, End), which returns the same rate.
  • For uneven cash flows, such as a SIP, use XIRR with the dates and amounts instead.
  • Years need not be whole. For 30 months, use 2.5 years, and for a precise number use the actual number of days divided by 365.

Frequently asked questions

Can CAGR be negative?

Yes. If the ending value is lower than the starting value, the ratio is below 1 and the CAGR is negative, showing the steady yearly loss that would produce the same result.

What is a good CAGR?

It depends on the asset, the period and the risk. Compare with a relevant benchmark and with inflation instead of looking for a universal "good" number.

Is CAGR the same as XIRR?

No. CAGR assumes one starting amount and one ending value. XIRR handles multiple investments and withdrawals at different dates, which suits SIPs.

Try these tools

Keep reading