How to Calculate CAGR in India — Formula, Examples, and Use Cases

CAGR (Compound Annual Growth Rate) is the most important investment return metric for Indian investors — it expresses returns as a smoothed annual rate, enabling comparison across investments with different time periods. The formula: CAGR = (Final Value / Initial Value)^(1/Number of Years) - 1. For an investment growing from ₹1 lakh to ₹3 lakh over 7 years: CAGR = (3/1)^(1/7) - 1 = 17%. CAGR's strength: single number captures compounded return without confusion from absolute returns (which don't account for time). CAGR's limitation: assumes single lump sum + single final value — doesn't account for additional investments along the way (use XIRR for SIPs). For Indian investors evaluating mutual funds, stocks, real estate, or even FDs, CAGR is the standard return benchmark. Mutual fund factsheets, stock performance pages, and even property listings all use CAGR (sometimes as "annualized return"). Understanding the formula enables independent verification of marketing claims. Freedomwise's SIP Return Calculator uses CAGR for comparing mutual fund performance.

What is the CAGR formula?

Mathematical structure:

Formula:

CAGR = (FV / IV)^(1/n) - 1

Where:

• FV = Final Value
• IV = Initial Value
• n = Number of years

Step-by-step calculation:

Example: ₹50,000 invested grows to ₹1,50,000 in 6 years

1. FV / IV = 1,50,000 / 50,000 = 3
2. 1/n = 1/6 = 0.1667
3. 3^0.1667 = 1.2009
4. 1.2009 - 1 = 0.2009 = 20.09% CAGR

Verification: ₹50,000 × (1.2009)^6 = ₹50,000 × 3.00 = ₹1,50,000 ✓

What are common CAGR calculations for Indian investments?

Worked examples by asset class:

Equity mutual fund:

• Initial: ₹2,00,000 (Jan 2020)
• Final: ₹4,80,000 (Jan 2026)
• Years: 6
• CAGR = (4.80/2)^(1/6) - 1 = (2.4)^0.1667 - 1 = 1.1574 - 1 = 15.74%

Real estate:

• Initial: ₹40 lakh (2015)
• Final: ₹75 lakh (2026)
• Years: 11
• CAGR = (75/40)^(1/11) - 1 = (1.875)^0.0909 - 1 = 1.0588 - 1 = 5.88%

Gold:

• Initial: ₹35,000/10g (2018)
• Final: ₹78,000/10g (2026)
• Years: 8
• CAGR = (78/35)^(1/8) - 1 = (2.229)^0.125 - 1 = 1.1054 - 1 = 10.54%

Fixed deposit (with reinvestment):

• Initial: ₹1 lakh at 6.5% interest
• After 10 years: ~₹1.88 lakh
• CAGR = 6.5% (matches interest rate as expected)

Sensex (long-term):

• Initial: 30,000 (Jan 2017)
• Final: 80,000 (Jan 2027)
• Years: 10
• CAGR = (80/30)^(1/10) - 1 = (2.667)^0.1 - 1 = 1.1017 - 1 = 10.17%

When should I use CAGR vs other return metrics?

Return metric comparison:

Metric	Use case	Limitation
Absolute return	Total period gain	Doesn't account for time
CAGR	Smoothed annual return (lump sum, fixed period)	Doesn't handle SIPs
XIRR	SIP returns with variable cash flows	More complex calculation
Annualized return	Period <1 year converted to annual	Not compounded
Real return	After-inflation purchasing power	Requires inflation data

Use CAGR when:

• Single lump sum investment with single final value
• Comparing different investments over different time periods
• Standard mutual fund / stock performance comparison
• Long-term wealth building analysis

Don't use CAGR when:

• SIP investments (multiple cash flows) → use XIRR
• Less than 1 year → use absolute or annualized
• Variable contribution patterns → use XIRR

How do I calculate CAGR in Excel/spreadsheet?

Excel formulas:

Method 1: Direct formula

=POWER(FV/IV, 1/years) - 1

Example: =POWER(150000/50000, 1/6) - 1 = 20.09%

Method 2: RATE function

=RATE(years, 0, -IV, FV)

Example: =RATE(6, 0, -50000, 150000) = 20.09%

(Note: IV is negative to indicate outflow)

Method 3: XIRR function (when there are specific dates)

=XIRR(values, dates)

Formatting: Multiply by 100 and add % for display: 0.2009 → 20.09%

What is the difference between CAGR and simple average return?

Critical distinction:

Simple average return:

• (Year 1 return + Year 2 return + ... + Year n return) / n
• Doesn't account for compounding
• Higher number, mathematically misleading

CAGR:

• Smoothed compound return
• Lower than simple average for volatile investments
• Mathematically accurate

Worked example:

Year	Return	End value (from ₹100)
1	+50%	₹150
2	-30%	₹105
3	+20%	₹126

• Simple average return: (50% + -30% + 20%) / 3 = 13.33%
• CAGR: (126/100)^(1/3) - 1 = 8.01%

The actual investor experience matches CAGR (8.01%), not the simple average (13.33%). The 13.33% is mathematically meaningless for compounding investments.

This is why fund factsheets show CAGR — the only honest measure.

What are CAGR pitfalls to watch for?

Five common errors:

1. Using CAGR for SIPs.

• SIP has multiple cash flows
• CAGR assumes single investment
• Result: misleading return number
• Solution: Use XIRR for SIP returns

2. Short time periods.

• 1-3 year CAGR can be misleading for volatile investments
• Long-term (5-10 year) CAGR is meaningful
• Be skeptical of "1-year CAGR" claims

3. Not accounting for fees/taxes.

• Gross CAGR vs Net CAGR
• Net = after fees, taxes
• Investment marketing often shows gross CAGR
• Always understand which is being shown

4. Cherry-picked time periods.

• "5-year CAGR from 2020 bottom" looks great
• Same fund's 5-year CAGR from 2018 peak looks terrible
• Verify multiple time periods

5. Survivorship bias.

• "Top 10 funds had 18% CAGR"
• Doesn't include funds that closed/merged
• Survivorship bias inflates apparent returns
• Look at category averages, not just survivors

How does CAGR compare to other Indian investments?

Long-term CAGR benchmarks (2005-2025, approximately):

Asset class	Long-term CAGR	Notes
Nifty 50	12-13%	Broad market equity
Mid-cap funds	13-15%	Higher volatility
Small-cap funds	14-16%	Highest volatility
Debt funds (medium duration)	7-8%	Lower volatility
FD (10-year)	6.5-7.5%	Guaranteed
Real estate (residential)	5-8%	Highly location-variable
Gold	9-11%	Decade variable
EPF	8-8.5%	Guaranteed
PPF	7-8%	Guaranteed

Use these benchmarks to evaluate investment claims. Returns substantially above category benchmarks should be questioned for risk, time period, or sample selection bias.

Use this on Freedomwise

• SIP Return Calculator — calculator-based returns
• Lumpsum Return Calculator — CAGR calculation
• Financial Jargon Explained — terminology
• Rule of 72 Explained India — quick estimation
• General pillar — broader financial literacy