"My investment doubled in 5 years!" Sounds impressive — until someone else says theirs doubled in 3. To compare them fairly, you need one common yardstick: CAGR — Compound Annual Growth Rate. It tells you the smooth yearly growth rate an investment actually delivered between two points in time.
The idea in one sentence
CAGR answers: if this investment had grown at a steady rate every year, what would that rate be? Real markets jump around; CAGR flattens that journey into one comparable annual number.
Multiply by 100 for a percentage.
A worked example
You invested ₹1,00,000 and after 5 years it became ₹1,80,000.
- 1,80,000 ÷ 1,00,000 = 1.8
- 1.8 raised to the power (1 ÷ 5) = 1.1247
- CAGR = 12.47% per year
So "I made 80% total" and "I made ~12.5% a year" are the same fact — but only the second lets you compare against a fund that grew 65% in 4 years. That one works out to a 13.3% CAGR, so it was actually the better investment.
Why total return misleads
| Investment | Total return | Period | CAGR |
|---|---|---|---|
| Option A | 80% | 5 years | 12.5% |
| Option B | 65% | 4 years | 13.3% |
| Option C | 100% | 10 years | 7.2% |
Same three investments, two different winners
Total return ignores time. CAGR puts every option on the same yearly scale.
By total return, C looks like the winner. By CAGR — the honest yardstick — it's the slowest. Advertisements love total returns; smart investors check CAGR.
Three honest limits of CAGR
- It ignores the journey. A fund that fell 40% and then recovered can show the same CAGR as a smooth one — same number, very different sleepless nights.
- It says nothing about future returns. A 5-star past CAGR is not a promise.
- It doesn't apply to money added in pieces. For SIPs (money going in every month), the right measure is called XIRR — CAGR only fits single lump-sum investments.
Want your fund's CAGR checked?
Send the fund name, amount and dates on WhatsApp — questions on any topic covered on this site are answered free.
Message IFI on WhatsApp →Quick recap
- CAGR = the steady yearly growth rate between two points in time.
- Always compare investments by CAGR, never by total return.
- For SIPs ask for XIRR instead.
- Past CAGR is history, not a forecast.
Frequently asked questions
What is the difference between CAGR and absolute return?
Absolute return is the total percentage gain, with no time attached — for example 80%. CAGR converts that into a yearly rate — 80% over 5 years is about 12.5% a year — so investments held for different periods can be compared fairly.
What is the difference between CAGR and XIRR?
CAGR works for one investment made once. XIRR handles many investments made on different dates, like monthly SIP instalments, so it is the right measure for SIP returns.
What is a good CAGR for a mutual fund?
There is no single number. Compare a fund's CAGR with its benchmark index and with similar funds over the same period, and check that it beats inflation over the long term. A high CAGR over a short period can simply be luck.
How do I calculate CAGR in Excel?
Use =(Final/Initial)^(1/Years)-1. For example, =(180000/100000)^(1/5)-1 gives 12.47%.