What is CAGR? How to Calculate and Use Compound Annual Growth Rate
When a mutual fund says "15% CAGR over 10 years" or a startup claims "200% CAGR in 3 years", what does that actually mean? CAGR (Compound Annual Growth Rate) is the single most important metric for evaluating investment performance. This guide explains it in plain language with practical examples.
CAGR Definition and Formula
CAGR is the rate at which an investment would have grown if it grew at a steady annual rate, from its beginning value to its ending value, over a specified time period.
Formula: CAGR = (Ending Value / Beginning Value)^(1/n) − 1, where n = number of years.
Example: You invested ₹1,00,000 in a mutual fund in 2015. In 2025 (10 years), the value is ₹3,10,585. CAGR = (3,10,585 / 1,00,000)^(1/10) − 1 = 3.10585^0.1 − 1 = 1.12 − 1 = 12%.
This means the fund grew as if it earned exactly 12% every single year — even though actual yearly returns varied wildly (maybe +25% in 2017, −10% in 2018, +18% in 2019).
CAGR smooths out volatility. A fund with 12% CAGR and one with perfectly stable 12% annual returns have the same ending value — but the CAGR fund may have been far more volatile along the way.
CAGR vs Absolute Return vs XIRR
Absolute return: (Ending − Beginning) / Beginning × 100. ₹1L → ₹2L = 100% absolute. Does not account for time. Misleading across different time periods.
CAGR: Annualizes the absolute return. ₹1L → ₹2L over 5 years = 14.9% CAGR. Over 10 years = 7.2% CAGR. Same return, very different CAGR — time matters enormously.
XIRR: Used for SIP (multiple cash flows). Each monthly SIP installment happens on a different date. XIRR accounts for the exact dates and amounts of each cash flow to give true annualized return. Always use XIRR for evaluating SIP performance, not CAGR.
What CAGR Figures Mean in Practice
Nifty 50 index (last 20 years): ~13-14% CAGR. This is the benchmark most equity funds try to beat.
Inflation in India (last 10 years): ~5-6% CAGR. Real return = CAGR − Inflation. A 7% CAGR bank FD during 6% inflation gives ~1% real return.
Rule of 72: Divide 72 by CAGR to get years to double. 12% CAGR → doubles in 6 years. 8% CAGR → 9 years. 6% CAGR → 12 years.
Large-cap equity funds: 10-14% CAGR historically (5-10 year window). Mid-cap: 13-17%. Small-cap: 15-20% but with much higher volatility.
Limitations of CAGR
CAGR ignores volatility: Two funds with same CAGR can have very different risk levels. Use CAGR alongside Sharpe Ratio and standard deviation for complete picture.
CAGR is backward-looking: Past CAGR does not guarantee future returns. Fund manager change, AUM growth, market cycle change all affect future performance.
CAGR does not account for dividends: For dividend-paying instruments, check Total Return CAGR (price appreciation + dividend reinvested) for fair comparison.
Misleading for short periods: A startup growing from ₹1L to ₹5L revenue in 1 year shows 400% CAGR. Mathematically correct, practically meaningless for projecting the next 5 years.
Using the CAGR Calculator
Use case 1 — Evaluate past investment: Enter initial value, final value, years → get the CAGR. Compare against benchmark (Nifty 50 CAGR for that period).
Use case 2 — Goal planning: You need ₹50L in 10 years, have ₹10L today. What CAGR do you need? Enter beginning value ₹10L, ending value ₹50L, years 10 → CAGR = 17.5%. Now find assets that can realistically deliver 17.5%.
Use case 3 — Compare funds: Fund A grew from ₹10L to ₹31L over 10 years (12% CAGR). Fund B grew to ₹28L (10.8% CAGR). The 1.2% difference compounding over 10 years is ₹3L on a ₹10L investment — significant.
Related Calculators
Frequently Asked Questions
Is 15% CAGR good for a mutual fund?
15% CAGR over 10 years is excellent — it beats the Nifty 50 benchmark of ~13-14% CAGR. However, compare the fund's CAGR to its category average and Nifty for the same period to assess true alpha.
How do I calculate CAGR in Excel?
Formula: =(End_Value/Start_Value)^(1/Years)-1. Example: =(B2/A2)^(1/10)-1. Format the cell as percentage to read correctly.
What is a good CAGR for an investment portfolio?
A balanced portfolio (60% equity, 40% debt) historically delivers 10-12% CAGR in India. Pure equity: 12-15%. This comfortably beats 6% inflation and FD returns of 7-8%.
Can CAGR be negative?
Yes. If ending value is below beginning value (investment loss), CAGR is negative. A ₹1L investment worth ₹70,000 after 3 years has CAGR = (0.7)^(1/3) − 1 = −11%.