What is CAGR? The Most Important Metric for Evaluating Investments
CAGR (Compound Annual Growth Rate) is the single most useful number for comparing investment performance. It represents the smoothed annual growth rate of an investment over a given period - expressed as if the investment grew at a steady rate every year, even though actual year-to-year growth was almost certainly uneven. Because CAGR accounts for both the total gain and the time taken to achieve it, it enables apples-to-apples comparison between investments held for different durations, in different asset classes, or with different starting values.
Every serious investment metric in India - SEBI-mandated mutual fund factsheets, stock screener return tables, and financial planning software - uses CAGR as the standard measure for periods of one year and above. Understanding how to read, calculate, and critically evaluate CAGR is a foundational skill for any investor.
This guide covers the CAGR formula and step-by-step calculation, why CAGR is superior to absolute return, the Rule of 72 mental shortcut, CAGR vs XIRR for SIP investors, real-world CAGR benchmarks for every major Indian asset class, how to use CAGR for retirement planning, and the detailed mathematics of why small CAGR differences compound into enormous wealth gaps over decades.
CAGR formula - step-by-step with worked examples
The CAGR formula has three components: initial value, final value, and number of years. It uses the geometric mean - the compounding-correct way to average growth rates - rather than the arithmetic mean.
In Excel / Google Sheets: =(B2/B1)^(1/B3)-1 where B1 = initial value, B2 = final value, B3 = years. Format cell as percentage. For SIP or irregular cash flows: use =XIRR(values_range, dates_range) instead.
CAGR vs absolute return - why time changes everything
Absolute return measures total gain as a percentage of initial investment, ignoring how long the investment was held. This makes it useless for comparing investments with different holding periods. CAGR solves this by converting total return into an annual rate - making a 3-year investment directly comparable to a 10-year one.
Investment
Initial
Final
Absolute return
Years held
CAGR
Which grew faster?
Fund A
₹1,00,000
₹2,00,000
100%
5 yrs
14.87%
✓ Best CAGR
Fund B
₹1,00,000
₹3,00,000
200%
10 yrs
11.61%
-
Fund C
₹1,00,000
₹1,50,000
50%
3 yrs
14.47%
-
Fund D
₹1,00,000
₹5,00,000
400%
15 yrs
11.59%
-
FD
₹1,00,000
₹2,00,000
100%
10 yrs
7.18%
-
Fund B looks best with a 200% absolute return. Fund D looks even more impressive at 400%. But CAGR reveals the truth: Fund A grew the fastest at 14.87% per year - delivering the best compounding rate even though it ran for only 5 years. The FD that doubled in 10 years looks impressive in absolute terms but its 7.18% CAGR barely beat inflation. Always compare CAGR, never absolute return, when evaluating investments held for different durations.
The Rule of 72 - the most useful mental shortcut in investing
The Rule of 72 states: divide 72 by the annual CAGR to get the approximate number of years for an investment to double. It works because of the mathematical relationship between logarithms and the compounding formula - the approximation is accurate within 1–2% for rates between 6% and 20%.
The Rule of 72 has a powerful second use: it makes the cost of low returns viscerally clear. Money in a savings account at 3.5% doubles every 20.6 years. In PPF at 7.1%, it doubles every 10.1 years. In a Nifty 50 index fund at 13.5% CAGR, it doubles every 5.3 years. Over 30 years, the savings account gives a ~4.4× return; the Nifty 50 index gives a ~48× return - on the same starting amount.
CAGR
Years to double (Rule of 72)
Years to double (exact)
₹1L becomes in 30 years
₹1L becomes in 20 years
3.5% (Savings account)
20.6 yrs
20.1 yrs
₹2.81L
₹1.99L
6% (FD (post-tax ~30% bracket))
12.0 yrs
11.9 yrs
₹5.74L
₹3.21L
7.1% (PPF (tax-free))
10.1 yrs
10.1 yrs
₹7.64L
₹3.95L
8.25% (EPF)
8.7 yrs
8.7 yrs
₹10.93L
₹5.00L
10% (Conservative equity)
7.2 yrs
7.3 yrs
₹17.45L
₹6.73L
12% (Nifty 50 / large-cap)
6.0 yrs
6.1 yrs
₹29.96L
₹9.65L
15% (Mid-cap equity)
4.8 yrs
4.9 yrs
₹66.21L
₹16.37L
18% (Small-cap / aggressive)
4.0 yrs
4.2 yrs
₹1.43 Cr
₹27.39L
How many years to grow your investment 2×, 5×, 10× or 50× at different CAGRs?
This reference table answers the common question: "If I invest ₹10 lakh today and expect a 12% CAGR, how many years until it becomes ₹1 crore (10×)?" Use the multiplier column to look up the answer instantly.
Target multiplier
6% CAGR
8% CAGR
10% CAGR
12% CAGR
15% CAGR
18% CAGR
2× (double)
12.0 yrs
9.0 yrs
7.3 yrs
6.1 yrs
4.9 yrs
4.2 yrs
3× (triple)
18.9 yrs
14.3 yrs
11.6 yrs
9.7 yrs
7.9 yrs
6.6 yrs
5×
27.6 yrs
20.9 yrs
16.9 yrs
14.2 yrs
11.5 yrs
9.7 yrs
10×
39.5 yrs
29.9 yrs
24.2 yrs
20.3 yrs
16.5 yrs
13.9 yrs
20×
51.4 yrs
38.9 yrs
31.5 yrs
26.5 yrs
21.5 yrs
18.1 yrs
50×
66.8 yrs
50.5 yrs
40.9 yrs
34.5 yrs
27.9 yrs
23.5 yrs
CAGR vs XIRR - which measure to use for your investments
This is one of the most common sources of confusion for Indian mutual fund investors. Both CAGR and XIRR express annualised returns, but they apply to different investment structures. Using the wrong one can give you a misleading picture of your actual returns.
Feature
CAGR
XIRR
Full name
Compound Annual Growth Rate
Extended Internal Rate of Return
Applicable to
Single lump-sum investment; one start date, one end date
Multiple investments at different dates; SIP, partial withdrawals, irregular cash flows
Formula basis
Geometric mean: (FV/IV)^(1/n) − 1
Discount rate that makes Net Present Value of all cash flows = 0 (solved iteratively)
For SIP returns
Incorrect - each instalment has a different holding period
Correct - weights each cash flow by exact calendar date
For lumpsum
Correct and simple
Gives identical result to CAGR for single cash in + cash out
Excel function
=(FV/IV)^(1/n)-1
=XIRR(values_range, dates_range)
Where you see it
Mutual fund factsheets (SEBI mandated), stock screeners, FD maturity calculators
Yes - each payout is a dated cash flow in the calculation
Historical CAGR of major Indian asset classes - complete reference
The table below shows approximate historical CAGR for major Indian asset classes across 5, 10, and 20-year periods. Use these as benchmarks when evaluating your own investments or planning future allocations. All figures are approximate and based on historical data - they are not guarantees of future performance.
Asset class
5-yr CAGR
10-yr CAGR
20-yr CAGR
Risk
Notes
Nifty 50 (Total Return Index)
15–18%
13–14%
14–15%
High
Benchmark for large-cap equity
Nifty Midcap 150
18–22%
16–18%
15–16%
High
Higher volatility, higher long-run return
Nifty Smallcap 250
20–30%
14–18%
13–15%
Very High
Very high volatility; large peak-to-trough swings
Gold (INR, MCX)
12–14%
8–9%
10–11%
Low-Mod
Partly driven by INR depreciation
Real estate - Mumbai Metro
5–8%
6–8%
8–10%
Moderate
Excludes rental yield; illiquid
Real estate - tier-2 cities
6–10%
7–9%
9–11%
Moderate
Higher growth potential, lower liquidity
PPF
7.1%
7.2%
7.5%
Zero
Government rate; changed rarely
EPF
8.25%
8.3%
8.5%
Zero
Declared annually by EPFO
Bank FD (large banks)
6.5–7%
7–7.5%
7–8%
Zero
Pre-tax; after-tax return ~4.9–5.3% at 30%
Savings account
3–4%
3–4%
3–4%
Zero
Lowest return; only for emergency funds
REITs (Embassy, Mindspace)
8–11%
N/A
N/A
Moderate
Listed since 2019; includes 8% yield
USD/INR (currency appreciation)
2–3%
3–4%
3–4%
Moderate
Structural INR depreciation trend
*All figures are approximate historical averages. Past CAGR is not a predictor of future returns. Equity CAGRs show high variability across different 5/10-year windows depending on start and end market levels. Real estate figures exclude transaction costs, maintenance, and rental yield. Gold figures are in INR terms.
Using CAGR to plan your retirement corpus - a practical framework
CAGR is most powerful when used in reverse - to determine what return rate your portfolio must achieve to reach a given target. This required CAGR calculation is a reality check that many investors skip, leading to either over-aggressive or under-invested portfolios.
Required CAGR formula
Required CAGR = (Target Corpus ÷ Current Portfolio)^(1 ÷ Years remaining) − 1
Example: You are 35, have ₹15 lakh invested, want ₹5 crore by 60 (25 years). Required CAGR = (5,00,00,000 / 15,00,000)^(1/25) − 1 = 33.33^(0.04) − 1 = 14.89% per year. This requires a predominantly equity portfolio. If this feels too risky, either invest more now, extend the timeline, or adjust the target corpus downward.
Current age
Current corpus
Target at 60
Years left
Required CAGR
Feasibility
25
₹2L
₹5 Cr
35 yrs
13.74%
Achievable with equity SIP
30
₹5L
₹5 Cr
30 yrs
16.24%
Needs aggressive equity allocation
30
₹10L
₹5 Cr
30 yrs
13.23%
Achievable with diversified equity
35
₹20L
₹5 Cr
25 yrs
13.70%
Achievable with equity + NPS
35
₹5L
₹5 Cr
25 yrs
23.00%
Very high - increase investment or reduce target
40
₹50L
₹5 Cr
20 yrs
12.20%
Achievable with Nifty 50 index funds
40
₹10L
₹5 Cr
20 yrs
20.18%
Very aggressive - increase SIP significantly
45
₹1 Cr
₹5 Cr
15 yrs
11.59%
Achievable with balanced equity portfolio
How to calculate CAGR for your mutual fund portfolio - step by step
1
Identify the correct initial and final values
For a single lump-sum investment: initial value = purchase amount (or NAV × units purchased); final value = current value (current NAV × units held). Do not include dividends received separately - if the fund distributed dividends, add them to the final value (or use the dividend-reinvestment option NAV if available). For a stock: initial value = total purchase cost including brokerage; final value = current market price × shares held.
2
Determine the exact number of years (including fractions)
Use the exact number of years including fractions for accuracy. If you invested on April 5, 2020 and are calculating on October 5, 2024, that is 4.5 years (not 4). For the formula: 4.5 years → use (1/4.5) as the exponent. An error of even 6 months in the time period can shift the CAGR result by 1–2 percentage points on a high-growth investment.
3
Apply the CAGR formula or use this calculator
Manually: CAGR = (Final/Initial)^(1/Years) − 1. In Excel: =(final_cell/initial_cell)^(1/years_cell)-1, formatted as a percentage. On this page: enter your initial value, final value, and years in the 'Find CAGR' tab - the result updates instantly. For SIP investments with multiple purchase dates, use the XIRR function in Excel or the XIRR figure shown in your fund house's consolidated account statement.
4
Compare against the right benchmark
A CAGR in isolation tells you nothing - it must be compared against a benchmark. For large-cap equity funds: compare against Nifty 50 TRI CAGR for the same period. For mid-cap funds: compare against Nifty Midcap 150 TRI. For debt funds: compare against CRISIL Short Term Bond Fund Index. For real estate: compare against Nifty 50 or gold for the same holding period. If your investment's CAGR is below the benchmark's CAGR for the same period, consider whether the additional risk or illiquidity was worthwhile.
5
Adjust for inflation to get real CAGR
Nominal CAGR includes inflation. Real CAGR = (1 + Nominal CAGR) ÷ (1 + Inflation rate) − 1. At 12% nominal CAGR and 6% inflation: Real CAGR = (1.12/1.06) − 1 = 5.66%. Real CAGR is what matters for comparing to your cost of living and retirement needs. A 7% CAGR in a high-inflation environment of 7% means zero real wealth creation - your purchasing power did not increase at all despite positive nominal returns.
Calculate SIP returns at a given CAGR
See how monthly SIP investments compound over time using a specific growth rate
What is CAGR and why is it more useful than absolute return?▼
CAGR (Compound Annual Growth Rate) is the annualised rate at which an investment grew from its initial to final value, assuming compounding. Unlike absolute return (which simply shows total gain as a percentage), CAGR normalises for time - making it possible to compare investments held for different durations on equal terms. Example: Fund A doubled your money (100% absolute return) in 3 years; Fund B doubled your money in 8 years. Both show 100% absolute return, but Fund A's CAGR is 26% while Fund B's is 9.05%. CAGR instantly tells you Fund A performed nearly 3× better per year. This is why all serious investment comparisons, mutual fund performance ratings, and financial plans use CAGR rather than absolute return.
What is the formula for CAGR and how do I calculate it manually?▼
CAGR = (Final Value ÷ Initial Value)^(1 ÷ Years) − 1. Step by step: (1) Divide final value by initial value to get the growth multiple. (2) Raise that multiple to the power of (1 ÷ number of years). (3) Subtract 1 from the result. (4) Multiply by 100 to express as a percentage. Example: ₹1 lakh grows to ₹3.2 lakh in 8 years. CAGR = (3.2/1)^(1/8) − 1 = 3.2^0.125 − 1 = 1.1575 − 1 = 0.1575 = 15.75% per year. In Excel: =(3.2)^(1/8)-1, formatted as percentage, gives 15.75%.
What is the difference between CAGR and XIRR? Which should I use for my mutual fund?▼
CAGR applies to a single lump-sum investment with one start date and one end date. It gives the correct annualised return for that specific scenario. XIRR (Extended Internal Rate of Return) handles multiple cash flows at different dates - which is exactly what happens in a SIP. In a 5-year SIP, you have 60 separate investments made on 60 different dates, each earning returns for a different duration. Using CAGR on an SIP portfolio would be mathematically incorrect. XIRR correctly weights each cash flow by its exact holding period. All AMC apps, CAMS, and platforms like Zerodha Coin show XIRR for SIP portfolios. For a lump-sum investment (one purchase, one redemption), CAGR and XIRR give identical results. Rule: lump-sum → CAGR; SIP or irregular cash flows → XIRR.
What is the historical CAGR of the Nifty 50 in India?▼
The Nifty 50 Total Return Index (which includes dividends) has delivered approximately 14–15% CAGR since its base year. On a price-only basis (excluding dividends), the CAGR is approximately 12–13%. However, rolling returns vary significantly: 10-year periods ending during market peaks (2007, 2017, 2024) show CAGRs of 14–18%, while 10-year periods ending during crashes (2009, 2020) show CAGRs of 6–9%. The key lesson: for equity investments, you need at least 10–15 years to be reasonably confident of achieving the long-run average CAGR. Short-term CAGRs (1–3 years) are heavily influenced by market timing and are not representative of expected long-run performance.
What is a good CAGR for a mutual fund in India in 2026?▼
Benchmarks for Indian equity mutual funds over 10-year periods: below 10% CAGR - poor (barely exceeded FD rates; equity risk not rewarded); 10–12% CAGR - adequate (matches or slightly beats Nifty 50); 12–15% CAGR - good (outperforms benchmark consistently); 15–18% CAGR - excellent (top-quartile fund); above 18% CAGR - exceptional (rare and rarely sustained over 15+ years). For debt mutual funds and liquid funds: 6.5–7.5% CAGR is reasonable; above 8% over 5 years may indicate duration risk. For real estate: 6–9% CAGR (price appreciation only, excluding rental yield) is typical in metro India, with tier-2 cities occasionally achieving 9–11% over 10-year periods.
Why does a small difference in CAGR matter so much over long periods?▼
The difference between 10% and 14% CAGR seems small - just 4 percentage points. But over 25 years: ₹10 lakh at 10% grows to ₹1.08 crore; at 14%, it grows to ₹2.67 crore - a difference of ₹1.59 crore from the same initial investment. Over 30 years: at 10% → ₹1.74 crore; at 14% → ₹5.09 crore - nearly 3× more. This is the compounding effect: higher CAGR does not just add a fixed amount each year - it multiplies the already-growing base. This is why expense ratio matters so much in mutual funds: a 1.5% expense ratio on an active fund versus a 0.1% index fund represents a 1.4% annual CAGR drag that compounds into lakhs of rupees difference over 20+ years.
Can I use CAGR to evaluate real estate investments in India?▼
Yes, and it is actually the most useful tool for comparing real estate returns with other assets. To calculate real estate CAGR: use purchase price as initial value, current market value as final value, and number of years held. Example: bought a flat in Pune for ₹45 lakh in 2014, now worth ₹85 lakh in 2024 → CAGR = (85/45)^(1/10) − 1 = 1.889^0.1 − 1 = 6.56% per year. Add rental yield (typically 2–3% gross in metro India) to get total return CAGR. Important caveats: real estate CAGR calculation should also factor in stamp duty/registration (5–7% upfront), maintenance costs (0.5–1% annually), and the opportunity cost of the large down payment. After adjusting for these, metro real estate's effective CAGR is often 4–6% - significantly below the headline price appreciation CAGR.
How is CAGR used to evaluate mutual fund performance in India?▼
SEBI mandates that mutual funds in India display returns on their factsheets and websites using CAGR for periods of 1 year and above. For periods below 1 year, absolute return is used. When evaluating a fund: (1) Compare the fund's CAGR against its benchmark (e.g., a Nifty 50 index fund should be benchmarked against Nifty 50 TRI, not Nifty 50 Price Return). (2) Compare across multiple time periods - 1, 3, 5, 7, and 10 year CAGR. A consistently outperforming fund across multiple periods is more reliable than one that tops charts in a single year. (3) Calculate rolling CAGR (the 3-year CAGR measured at every month over the fund's history) to understand consistency. (4) Compare peer funds in the same SEBI category (large-cap vs large-cap, not large-cap vs mid-cap).
What is CAGR vs IRR - are they the same?▼
CAGR and IRR (Internal Rate of Return) are related but not identical. CAGR measures the annualised growth rate between exactly two values (initial and final) over a fixed period - it's a simple, two-point calculation. IRR is the discount rate that makes the Net Present Value of all cash flows equal to zero - it handles any number of cash flows at any time intervals. For a simple lump-sum investment with no intermediate cash flows, CAGR equals IRR. For investments with intermediate payouts (dividends, coupon payments, partial withdrawals), IRR accounts for the timing and size of those cash flows while CAGR ignores them. In Indian finance, XIRR is the most commonly used IRR variant because it works with actual calendar dates rather than fixed periods.
How do I use CAGR to plan my retirement corpus in India?▼
Use CAGR in reverse to plan: (1) Decide your target retirement corpus (e.g., ₹5 crore at age 60). (2) Determine your current investment portfolio value (e.g., ₹20 lakh at age 35). (3) Calculate the required CAGR to reach the target in 25 years: (5,00,00,000 / 20,00,000)^(1/25) − 1 = 25^(0.04) − 1 = 13.7% CAGR needed. (4) Compare this with realistic expected CAGRs from your asset allocation. If 13.7% seems high (requires heavy equity allocation), either increase current investment, extend timeline, or reduce target corpus. The CAGR required calculation is a powerful reality check that helps you set realistic financial goals rather than aspirational ones.
