What Is CAGR in Investing? The Only Return Metric That Matters for Lump Sums
An investment that "doubled in 5 years" sounds great — CAGR tells you whether it actually was.
When a mutual fund advertisement says "₹1 lakh invested 10 years ago is now ₹4.5 lakh," most people react with wonder. But is that good? To answer that question, you need CAGR — Compound Annual Growth Rate. It is the single most useful metric for comparing the performance of any lump-sum investment across different time periods and asset classes.
What Is CAGR?
CAGR is the rate at which an investment would have grown if it grew at a steady annual rate, reinvesting all gains. It smooths out year-to-year volatility to give one comparable number.
It does not mean the investment grew at this rate every year — equities can swing 40% up and 30% down in consecutive years. CAGR strips all that volatility away and says: "Ignoring the bumpy path, what was the effective annual growth rate from start to finish?"
The CAGR Formula
CAGR = (Ending Value / Beginning Value) ^ (1 / Number of Years) − 1
Where:
Ending Value = Current or final value of investment
Beginning Value = Original investment amount
Number of Years = Holding period in years (can be fractional)
Example 1: ₹1 lakh invested in a mutual fund, now worth ₹4.5 lakh after 10 years.
CAGR = (4,50,000 / 1,00,000) ^ (1/10) − 1
= (4.5) ^ (0.10) − 1
= 1.1623 − 1
= 16.23%
Example 2: ₹2 lakh invested in gold, now worth ₹3.1 lakh after 4 years.
CAGR = (3,10,000 / 2,00,000) ^ (1/4) − 1
= (1.55) ^ (0.25) − 1
= 1.1162 − 1
= 11.62%
CAGR vs Absolute Return vs Simple Interest
| Metric | Formula | Use case |
|---|---|---|
| Absolute Return | (End − Start) / Start × 100 | Quick check, ignores time |
| Simple Annual Return | Absolute return / Years | Underestimates due to no compounding |
| CAGR | (End/Start)^(1/n) − 1 | Lump sum, any time period |
| XIRR | IRR with actual dates | SIPs and irregular cash flows |
The "₹1 lakh → ₹4.5 lakh in 10 years" example: absolute return is 350%, simple annual return is 35%/year — wildly overstated. CAGR of 16.23% is the accurate annualised figure.
CAGR of Common Indian Asset Classes (Illustrative, Long-Term)
These are illustrative round numbers for educational context — not forward-looking projections:
| Asset class | Approximate 15-year CAGR |
|---|---|
| Nifty 50 (equity) | ~12–14% |
| Nifty Midcap 150 | ~14–16% |
| Gold (INR) | ~10–12% |
| Real estate (metro cities) | ~8–10% |
| Fixed deposits (SBI) | ~6–7% |
| PPF | ~7–7.5% |
| Inflation (CPI) | ~5–6% |
Real return = CAGR − Inflation. An FD at 7% CAGR in a 6% inflation environment gives a real return of ~1% — barely preserving purchasing power.
How to Use CAGR to Reverse-Engineer a Target
CAGR works in reverse too: given a target corpus, how much do you need to invest today?
Required investment = Target Value / (1 + CAGR) ^ Years
Example: Want ₹50 lakh in 15 years, expected CAGR = 12%
Required lump sum = 50,00,000 / (1.12) ^ 15
= 50,00,000 / 5.4736
≈ ₹9.13 lakh
So ₹9.13 lakh invested today at 12% CAGR grows to ₹50 lakh in 15 years. Use our Compound Interest Calculator to run these projections instantly.
When CAGR Can Mislead You
It hides volatility. A fund that went +50%, -30%, +50% over 3 years feels terrifying to hold. Its CAGR might look respectable, but the emotional experience — and the damage to investors who panicked and sold at the -30% point — is not captured.
It is wrong for SIPs. CAGR assumes a single lump sum at the start. For monthly SIPs, always use XIRR. Many investors mistakenly apply CAGR to SIP portfolios and get an inflated number.
Short periods are noisy. A 2-year CAGR of 35% may reflect a post-crash recovery or a bull-run coincidence. Evaluate funds over at least one full market cycle (7–10 years) for meaningful CAGR.
It excludes taxes and costs. Fund advertisements show pre-cost, pre-tax CAGR. Your net CAGR after expense ratio, exit load, and LTCG tax will be lower — compute it before comparing to FD rates.
For retirement planning, the Retirement Calculator lets you input an expected CAGR and see the corpus you will accumulate.
These figures are estimates for educational purposes. Consult a SEBI-registered advisor for personalised advice.
Frequently asked questions
Is CAGR the same as annualised return?+
Yes, CAGR and annualised return are effectively the same concept when computed using the compounding formula. Some sources use "annualised return" loosely to mean simple return divided by years, which is different. Always confirm which formula is being used.
Can I calculate CAGR for my SIP investments?+
You can, but it will give an incorrect result. CAGR assumes one lump sum at the beginning. For SIPs with multiple instalments, use XIRR — it accounts for the exact dates and amounts of each cash flow.
What CAGR should I assume for retirement planning in India?+
Conservative planners use 10–11% for a diversified equity portfolio over 20+ years. Aggressive planners use 12–14%. Given uncertainty, it is wise to plan at 10% and treat anything above as a bonus. For debt or hybrid portfolios, use 7–9%.
How do I calculate CAGR in Excel?+
Use: =(ending_value/beginning_value)^(1/years)-1. For example, if B1=100000, B2=450000, and n=10 years: =(B2/B1)^(1/10)-1. Format the result as a percentage.
Why do two funds with the same CAGR feel different to hold?+
Standard deviation and maximum drawdown differ. Two funds can have the same 5-year CAGR but one may have dropped 40% in year 2 (causing investors to sell in panic) while the other was relatively smooth. CAGR only measures start and end points — not the journey.
Try the calculators
Keep reading
- What Is XIRR in Mutual Funds? How to Measure Your Real SIP Returns
Your fund app shows 18% returns — but your XIRR might tell a very different story about what you actually earned.
- What Is Compound Interest? (The 8th Wonder of the World)
Compound interest is what happens when your money starts earning money of its own — and given enough time, that snowball gets surprisingly large.
- The Rule of 72: How Fast Does Your Money Double?
Divide 72 by your interest rate and you get a startlingly good estimate of how many years it takes your money to double — no calculator required.
Maya has spent the last decade turning confusing money topics into plain English. She’s happiest when a reader tells her a guide finally made compound interest click.