CAGR, short for Compound Annual Growth Rate, is the single most useful number for comparing investments across different instruments, holding periods, and starting amounts. It tells you the constant annual rate an investment would have needed to grow at to reach its ending value from its beginning value. It doesn't tell you what actually happened year by year. It gives you a smooth, equivalent rate that summarises the whole journey in one figure.
This guide walks through the formula step by step, works a concrete example, covers Excel and spreadsheet implementation, and flags the common errors that lead investors astray when reading CAGR figures in fund performance tables and financial ads.
What You Need
- Beginning value: the starting amount (initial investment)
- Ending value: the investment's final value at the measurement date
- Number of years: the holding period in years (can be fractional)
- A calculator, spreadsheet, or the CAGR Calculator for instant results
For total return CAGR, which includes dividends, the ending value should include the reinvested dividend corpus, not just price appreciation.
Steps
Step 1: Understand What CAGR Measures
CAGR looks backward. It describes what an investment did, not what it will do. More precisely, it's the hypothetical constant rate of return that would have produced the same ending value from the same beginning value over the same time period, assuming annual compounding.
What it doesn't capture is volatility. An investment that earned +40%, −20%, +35%, −10%, and +20% over five years has the same CAGR as one that earned exactly 10.9% every single year, yet the two experiences are nothing alike. The first investor rides through deep drawdowns and uncertainty. The second sees steady, monotonic growth. CAGR is great for comparing outcomes, but it tells you nothing about the ride.
It also ignores ongoing contributions. Invest ₹1,00,000 once and add ₹10,000 every year after, and CAGR can't meaningfully represent that portfolio's return, since there's no single starting amount to anchor it. XIRR is the right metric there. CAGR is built for one thing: a single beginning investment, held without additions or withdrawals, over a defined period.
Use CAGR to answer "If I'd invested ₹X at time zero and done nothing since, what annualised return did I earn?" The Lumpsum Calculator shows how a given CAGR translates into a final corpus for any starting amount and time horizon.
Step 2: Gather the Inputs
Three numbers, and that's it.
Beginning Value (BV): the amount invested at the start, or the investment's value at the beginning of the measurement period. For a mutual fund, multiply the NAV at purchase by units bought. For a stock, multiply purchase price per share by shares held.
Ending Value (EV): the current market value, or the value at the end of the measurement period. For a mutual fund, multiply current NAV by units held. Leave out unrealised tax liability for a pre-tax CAGR.
Number of years (n): the holding period in years. Held from January 2019 to June 2026, that's 7 years and 6 months, so n = 7.5. Rounding to full years distorts the result for shorter holding periods.
Example values:
- Beginning value: ₹1,00,000
- Ending value: ₹1,61,051
- Holding period: 5 years
Step 3: Apply the CAGR Formula
The formula:
CAGR = (EV ÷ BV)^(1/n) − 1
Where:
- EV = Ending Value
- BV = Beginning Value
- n = number of years
Working through the example:
- Calculate the ratio: ₹1,61,051 ÷ ₹1,00,000 = 1.61051
- Raise to the power of (1/n) = (1/5) = 0.2: 1.61051^0.2
- 1.61051^0.2 = 1.10 (the fifth root of 1.61051)
- Subtract 1: 1.10 − 1 = 0.10
- Express as a percentage: 0.10 × 100 = 10% per annum
Check it: ₹1,00,000 × (1.10)^5 = ₹1,00,000 × 1.61051 = ₹1,61,051. That matches.
The fifth-root step (raising to the power 0.2) is where most manual calculations fall apart. Use the ^ operator in a spreadsheet or the exponent key on a scientific calculator. The CAGR Calculator handles it instantly for any beginning value, ending value, and time period you enter.
Derivation of the formula
The compounding formula is EV = BV × (1 + r)^n, where r is the annual rate. Solve for r:
- EV/BV = (1 + r)^n
- (EV/BV)^(1/n) = 1 + r
- r = (EV/BV)^(1/n) − 1
CAGR is just r, the annual rate satisfying that compounding equation.
Step 4: Interpret the Result
A raw CAGR number only means something next to a benchmark. For India:
| Benchmark | CAGR (approximate) |
|---|---|
| Indian CPI inflation | 5–6% per year (10-year average) |
| Post office savings | 4–7.5% depending on product |
| Bank FD (3–5 year) | 6.5–7.5% per year |
| PPF | 7.1% per year (current) |
| NPS (balanced allocation) | 9–11% per year (historical) |
| Gold | 8–10% per year (10-year) |
| Nifty 50 (15-year rolling) | 12–13% per year |
| Real estate (metro cities) | 6–10% per year |
Any CAGR below 6%, roughly the inflation rate, means the investment lost purchasing power in real terms even as the nominal value climbed. The Inflation Calculator shows the real value of a given CAGR after inflation.
When CAGR misleads
Financial marketing bends CAGR two ways. First, by cherry-picking the measurement period: a fund at ₹10 NAV at a market bottom and ₹25 NAV at a recent peak shows 20%+ CAGR over that window, far higher than its performance from a neutral start date would show. Second, by point-to-point selection: quoting the 1-year CAGR of an investment that just had a spectacular year overstates its long-term track record.
The fix is to check rolling-period CAGR, the average CAGR starting from every month over the past 10 years rather than one chosen start date. Financial data providers publish rolling CAGRs for most mutual funds and ETFs.
Step 5: Calculate CAGR in Excel or Google Sheets
Method 1: POWER function (recommended)
=POWER(ending_value/beginning_value, 1/years) - 1
Example: =POWER(161051/100000, 1/5) - 1 returns 0.10. Format the cell as Percentage to see 10.00%.
Method 2: Caret exponent operator
=(ending_value/beginning_value)^(1/years) - 1
Example: =(161051/100000)^(1/5) - 1 returns the same result.
Method 3: RATE function (time value of money approach)
=RATE(years, 0, -beginning_value, ending_value)
RATE wants the beginning value entered as a negative number (an outflow) and the ending value as positive (an inflow). =RATE(5, 0, -100000, 161051) returns 0.10, or 10%. Reach for this one if you're already working in a PV/FV modelling context.
Common spreadsheet errors
- Forgetting to subtract 1:
=POWER(161051/100000, 1/5)returns 1.10, not 0.10. CAGR is the result minus 1. - Using the wrong n: an investment running from Jan 2021 to June 2026 needs n = 5.5, not 5.
- Skipping the percentage format: the raw result 0.10 reads like a much smaller number than 10%.
For anything involving more than two scenarios, the CAGR Calculator eliminates formula errors and gives you results instantly. Pair it with the Fixed Deposit Calculator to see what the same starting amount would have grown to in a bank FD over the same period.
Common Mistakes to Avoid
Comparing CAGR with simple annualised return. Ads sometimes quote "annualised return" as total gain divided by years. For a 61% total return over 5 years, that gives 12.2% "annualised," well above the true CAGR of 10%. The simple figure isn't compounded, and it always overstates performance for positive returns.
Skipping dividends. A stock paying ₹5 per share annually over 5 years, with price rising from ₹100 to ₹130, shows a price-only CAGR of 5.4%, understating the real return. Add the ₹25 total dividends per share for an ending value of ₹155, and CAGR jumps to 9.2%, nearly double the price-only number.
Using CAGR for SIP returns. A systematic investment plan involves multiple cash flows at different times. Treating the first SIP instalment as beginning value and the current portfolio as ending value produces a meaningless number. XIRR is the right tool for SIP returns. The SIP Calculator shows both the total corpus and the implied XIRR automatically.
Applying CAGR to absolute return products. Fixed deposits, PPF, and government savings schemes quote interest rates, not CAGR, but those rates already compound annually. For FDs compounding quarterly, the effective annual rate runs slightly higher than the stated rate, and that's the number to use as the CAGR equivalent for comparison.
Formula & Methodology
Core formula: CAGR = (Ending Value ÷ Beginning Value)^(1/n) − 1
Derivation: From the compound interest equation EV = BV × (1 + r)^n, solving for r gives CAGR.
Worked example (₹1,00,000 to ₹1,61,051 in 5 years):
- Ratio: 1,61,051 ÷ 1,00,000 = 1.61051
- Fifth root: 1.61051^(1/5) = 1.61051^0.2 = 1.1000
- CAGR: 1.1000 − 1 = 0.10 = 10.00% per annum
With fractional years (e.g., 5 years and 6 months = 5.5 years): CAGR = (EV/BV)^(1/5.5) − 1
Real CAGR (inflation-adjusted): Real CAGR ≈ Nominal CAGR − Inflation rate. At 10% nominal CAGR and 6% inflation, the approximate real CAGR is 4% (the precise formula, (1 + nominal)/(1 + inflation) − 1 = 1.10/1.06 − 1, gives 3.77%).
Rule of 72: Years to double ≈ 72 ÷ CAGR%. At 10% CAGR, money doubles in about 7.2 years. Check: ₹1,00,000 × (1.10)^7.2 ≈ ₹1,99,372, close enough to double.