CAGR formula
CAGR = (Final value ÷ Initial value)^(1 ÷ Years) − 1
For ₹1,00,000 that grew to ₹2,50,000 in 7 years:
- Final ÷ initial = 2,50,000 ÷ 1,00,000 = 2.5
- 1 ÷ years = 1 ÷ 7 = 0.142857
- 2.5^0.142857 = 1.1399
- 1.1399 − 1 = 0.1399, or 13.99% a year
The absolute return is 150%, but that number ignores time. Earning 150% in 7 years and 150% in 15 years are very different results. CAGR puts them on the same yearly scale: 13.99% versus 6.30%.
Why CAGR is better than average return
Suppose a fund rises 50% in year one and falls 50% in year two. The "average" return is 0%, but ₹1 lakh became ₹1.5 lakh and then ₹75,000, a real loss. CAGR captures that: (75,000 ÷ 1,00,000)^(1/2) − 1 = −13.4% a year. Fund factsheets report CAGR for 1, 3, 5 and 10 years for exactly this reason.
CAGR examples
| Investment | Start | End | Years | CAGR |
|---|---|---|---|---|
| Mutual fund holding | ₹1,00,000 | ₹2,50,000 | 7 | 13.99% |
| Flat bought in 2016, sold in 2026 | ₹40 lakh | ₹70 lakh | 10 | 5.76% |
| Sovereign Gold Bond 2021-22 Series VII (gold price only) | ₹4,765/g | ₹14,167/g | 5 | 24.35% |
The flat looks like a big win (₹30 lakh profit), but 5.76% a year is roughly what a bank FD paid over that decade — and that is before stamp duty, brokerage and maintenance. CAGR makes that comparison honest.
How long money takes to double
At a steady CAGR, money doubles in about 72 ÷ CAGR years (the "rule of 72"). Exact figures:
| CAGR | Years to double |
|---|---|
| 7% (around PPF) | 10.2 |
| 10% | 7.3 |
| 12% | 6.1 |
| 15% | 5.0 |
When not to use CAGR
CAGR works for a single lump sum. For a SIP, each instalment is invested for a different length of time, so dividing the total gain by the years gives the wrong answer. Use the XIRR calculator for SIPs or any investment with several deposits and withdrawals. To project a lump sum forward at an assumed CAGR, use the lumpsum calculator or the future value calculator.
Also remember that CAGR is a smoothed number. A fund with a 12% CAGR may have had years of −20% and +40% along the way; CAGR says nothing about that volatility.
CAGR in Excel or Google Sheets
Use =(End/Start)^(1/Years)-1, or =RRI(Years, Start, End). For ₹1 lakh to ₹2.5 lakh in 7 years, =RRI(7,100000,250000) returns 13.99%.