CAGR — 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 at which an investment would have had to grow to reach its ending value from its beginning value. Importantly, it does not tell you what actually happened year by year — it gives you a smooth, equivalent rate that summarises the overall journey.
This guide walks through the formula step by step, demonstrates the calculation with a concrete example, covers Excel and spreadsheet implementation, and explains the common errors that lead investors to misread CAGR figures they encounter in fund performance tables and financial advertisements.
What You Need
- Beginning value: the starting amount (initial investment)
- Ending value: the final value of the investment 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 the price appreciation.
Steps
Step 1: Understand What CAGR Measures
CAGR is a retrospective metric — it describes what an investment did, not what it will do. More precisely, it is 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 returns compounded annually.
What CAGR does not capture: 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 experiences are radically different. The first investor endures deep drawdowns and uncertainty; the second experiences monotonic growth. CAGR is useful for comparing outcomes but tells you nothing about the ride.
CAGR also ignores ongoing contributions. If you invest ₹1,00,000 once and add ₹10,000 each year, CAGR cannot meaningfully represent the return on this portfolio — the right metric for ongoing contributions is XIRR. CAGR is specifically for: a single beginning investment, held without additions or withdrawals, for a defined period.
Use CAGR to answer: "If I had invested ₹X at time zero and done nothing, what annualised return did I earn?" Use the Lumpsum Calculator to see how a given CAGR translates to a final corpus for any starting amount and time horizon.
Step 2: Gather the Inputs
Three numbers are required:
Beginning Value (BV): The amount invested at the start, or the value of the investment at the beginning of the measurement period. For a mutual fund, use the NAV at which units were purchased multiplied by the number of units. For a stock, use the purchase price per share multiplied 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 the current NAV by the number of units held. Do not include unrealised tax liability in the ending value for pre-tax CAGR.
Number of years (n): The holding period in years. If the investment was held from January 2019 to June 2026 — 7 years and 6 months — use n = 7.5. Using full years only will distort the result slightly for short 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
Verification: ₹1,00,000 × (1.10)^5 = ₹1,00,000 × 1.61051 = ₹1,61,051. Correct.
The fifth root step (raising to the power 0.2) is where most manual calculations go wrong. Use the ^ operator in a spreadsheet or the exponent key on a scientific calculator. The CAGR Calculator handles this instantly with 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. Solving for r:
- EV/BV = (1 + r)^n
- (EV/BV)^(1/n) = 1 + r
- r = (EV/BV)^(1/n) − 1
CAGR is simply r — the annual rate that satisfies the compounding equation.
Step 4: Interpret the Result
A raw CAGR number is only useful when placed alongside benchmarks. For investments in 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% — the approximate inflation rate — means the investment lost purchasing power in real terms, even if the nominal value increased. Use the Inflation Calculator to see the real value of a given CAGR after inflation.
When CAGR misleads
CAGR is manipulated in financial marketing through two techniques. First, cherry-picking the measurement period: a fund that was ₹10 NAV at a market bottom and ₹25 NAV at a recent peak shows 20%+ CAGR over that window, which is far higher than its performance over a neutral start date. Second, point-to-point selection: a 1-year CAGR of an investment that had a spectacular recent year overstates long-term performance.
The defence is to always check rolling period CAGR — the average CAGR calculated starting from every month over the past 10 years, not just from one chosen start date. Rolling CAGRs are published by financial data providers for 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 display 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 (for time value of money approach)
=RATE(years, 0, -beginning_value, ending_value)
The RATE function requires the beginning value to be entered as a negative number (representing an outflow) and the ending value as positive (an inflow). For =RATE(5, 0, -100000, 161051), it returns 0.10 or 10%. This approach is useful if you are already working in a financial modelling context with PV/FV conventions.
Common spreadsheet errors
- Forgetting to subtract 1:
=POWER(161051/100000, 1/5)returns 1.10, not 0.10. The CAGR is the result minus 1. - Using the wrong n: if the investment ran from Jan 2021 to June 2026, n = 5.5, not 5.
- Not formatting as percentage: the raw result 0.10 looks like a much smaller number than 10%.
For any investment comparison involving more than two scenarios, the CAGR Calculator eliminates formula errors and produces results instantly. Use the Fixed Deposit Calculator alongside the CAGR result to compare what the same beginning amount would have grown to in a bank FD over the same period.
Common Mistakes to Avoid
Comparing CAGR with simple annualised return: Advertisements sometimes quote "annualised return" as total gain divided by years — for a 61% total return over 5 years, this gives 12.2% "annualised" rather than the true CAGR of 10%. The simple annualised figure is not compounded and always overstates performance for positive returns.
Not accounting for dividends: If a stock paid ₹5 per share annually in dividends over 5 years and the price rose from ₹100 to ₹130, a price-only CAGR of 5.4% understates the total return. Including dividends (₹25 total per share) gives a total return ending value of ₹155, with a CAGR of 9.2% — nearly double the price-only number.
Using CAGR for SIP returns: A systematic investment plan involves multiple cash flows at different times. Calculating CAGR by using the first SIP instalment as beginning value and the portfolio value as ending value produces a meaningless number. XIRR is the correct tool for SIP return calculation. 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 these rates already represent compounding annually. For FDs compounding quarterly, the effective annual rate is slightly higher than the stated rate and should be used as the CAGR equivalent for comparison purposes.
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: approximate real CAGR = 4% (precise formula: (1 + nominal)/(1 + inflation) − 1 = 1.10/1.06 − 1 = 3.77%)
Rule of 72: Years to double ≈ 72 ÷ CAGR%. At 10% CAGR, money doubles in approximately 7.2 years. Verification: ₹1,00,000 × (1.10)^7.2 ≈ ₹1,99,372 ≈ double. ✓