CAGR Calculator India 2026: 4-Mode Tool + Reverse CAGR + Real Return

Written by Mithun Srivastava · B.Tech + MBA · Investing in Indian markets since 2010

Educator, not a SEBI-registered investment advisor · Educational only — not advisory

The CAGR calculator below answers four questions that every Indian investor needs answered: what is my real return, what will my money grow to, how long until I hit a target, and how does this investment compare against another. It uses the standard compound annual growth rate formula, with built-in benchmarks for Nifty 50, Sensex, gold, FDs, and real estate, plus optional adjustments for inflation and tax. For official rules on what counts as a “return”, see the regulator notes at SEBI and the industry definitions at AMFI.

Last updated: May 2026. This is an educational tool, not investment advice.

CAGR Calculator — Compound Annual Growth Rate

Four modes, one tool. Pick what you want to find out.

Historical CAGR benchmarks (India, 20-year average, approx). Nifty 50: 12.5%. Sensex: 12.0%. Gold (INR): 9.5%. Real estate (residential): 8.0%. Bank FD: 6.5%. Inflation (CPI): 6.0%. Use these to sanity-check your own numbers — anything above 18% over a decade is exceptional and rarely repeatable.

Key Takeaways

CAGR (Compound Annual Growth Rate) is the smoothed annual return that converts an absolute gain into a single comparable number — the only honest way to compare investments held for different periods.
The formula is one line: CAGR = (Ending ÷ Beginning)^(1 ÷ Years) − 1. Everything else in this guide is just nuance.
Long-term Indian benchmarks: Nifty 50 ~12.5%, Sensex ~12.0%, gold ~9.5%, real estate ~8.0%, bank FD ~6.5%, CPI inflation ~6.0%. Anything materially above these over a decade is exceptional.
Real CAGR (after inflation) is the number that actually matters. A 12% nominal CAGR with 6% inflation is only 5.66% real — that is your true wealth growth.
CAGR hides volatility. Two funds with the same CAGR can have wildly different risk profiles — always check the standard deviation or maximum drawdown alongside.

What Is CAGR? Compound Annual Growth Rate Explained

The compound annual growth rate is the constant annual rate at which an investment would have grown if it had compounded smoothly every year, regardless of how bumpy the actual path was. CAGR is not a real return — it is a mathematical fiction that lets you compare two investments fairly. If a fund quadruples in 8 years, its CAGR is about 18.92%. If a different fund triples in 5 years, its CAGR is about 24.57%. Both look great in absolute terms; only CAGR tells you which one grew faster.

For Indian investors, CAGR matters in three places: when you compare two mutual funds with different start dates, when you size your SIP against a long-term goal, and when you decide whether a property or a stock actually outpaced inflation. Every other metric — absolute return, point-to-point return, last 1-year return — is just a snapshot and can be cherry-picked.

CAGR vs Absolute Return — The Most Common Mistake

Absolute return is the total percentage gain, ignoring time. If your ₹1 lakh became ₹3 lakh, the absolute return is 200%. That number is correct but useless for comparison, because it does not tell you whether it happened in 3 years or 30. CAGR fixes this by spreading the gain evenly across the holding period — making time the great equaliser.

The CAGR Formula — and Where It Comes From

The compound annual growth rate formula:

CAGR = (Ending Value ÷ Beginning Value)^{(1 ÷ Number of Years)} − 1

To see why this works, start from the compound interest identity. If a sum P grows at a constant rate r every year, after n years it becomes P × (1+r)ⁿ. Solve for r by dividing by P and taking the nth root: r = (Final ÷ P)^1/n − 1. That is the CAGR formula. In Excel or Google Sheets, the same calculation is =(B2/A2)^(1/C2)-1, formatted as a percentage.

A Quick Mental Shortcut: The Rule of 72

Need to estimate doubling time without a calculator? Divide 72 by the CAGR in percentage form. At a 12% CAGR, money doubles roughly every 72 ÷ 12 = 6 years. At an 8% CAGR, it takes about 9 years. This shortcut is accurate within 1% for rates between 6% and 15%, which covers most realistic Indian asset returns.

Worked Examples — CAGR Calculation in Practice

Example 1: Mutual Fund SIP Returns

You invested ₹5 lakh as a lump sum in a flexicap fund seven years ago. The current value is ₹12.5 lakh. What is the CAGR?

CAGR = (12,50,000 ÷ 5,00,000)^(1/7) − 1 = (2.5)^0.1429 − 1 ≈ 0.1396, or 13.96% per year. Use the calculator above with start = 500000, end = 1250000, years = 7 to verify.

Example 2: Direct Stock Investment

You bought 100 shares of a private bank in May 2018 at ₹2,100 per share. In May 2026 they are worth ₹4,200 per share. Your investment grew from ₹2.1 lakh to ₹4.2 lakh — a clean doubling.

CAGR = (4,20,000 ÷ 2,10,000)^(1/8) − 1 = 2^0.125 − 1 ≈ 0.0905, or 9.05% per year. Despite the absolute 100% return sounding impressive, the actual annualised growth is below the Nifty 50 long-term average. This is precisely why CAGR matters more than absolute return.

Example 3: Gold Investment

Gold was around ₹26,000 per 10 grams in May 2016. By May 2026 it is roughly ₹71,000 per 10 grams. For a ₹1 lakh investment held for 10 years:

CAGR = (71,000 ÷ 26,000)^(1/10) − 1 = (2.73)^0.1 − 1 ≈ 0.1057, or 10.57% per year. Above the long-run gold average of ~9.5%, reflecting the post-pandemic price surge in INR terms.

Example 4: Bank Fixed Deposit

A ₹10 lakh fixed deposit at 7% per annum, compounded annually, for 5 years grows to ₹14.03 lakh. CAGR = (14,03,000 ÷ 10,00,000)^(1/5) − 1 = 7.00%, which matches the quoted rate. For FDs, CAGR equals the nominal interest rate when compounding is annual.

Historical CAGR of Major Indian Assets (Approximate, 20-Year)

These long-term averages are the lens through which to evaluate your own CAGR. A 15% CAGR in equity over a decade looks ordinary in a bull market and exceptional in a bear-heavy one. Sourcing: NSE/BSE indices, World Gold Council, RBI inflation data, NHB price index. Numbers rounded for clarity.

Asset class	20-year CAGR (approx)	10-year CAGR (approx)	Risk / volatility
Nifty 50 (TRI)	~12.5%	~13.5%	High (SD ~20%)
BSE Sensex (TRI)	~12.0%	~13.0%	High (SD ~20%)
Nifty Midcap 150	~14.0%	~17.0%	Very high (SD ~25%)
Gold (INR)	~9.5%	~10.5%	Medium (SD ~14%)
Residential real estate	~8.0%	~5.5%	Low daily, illiquid
Bank FD (5-year)	~6.5%	~6.5%	Near-zero (insured to ₹5L)
PPF	~7.5%	~7.5%	Near-zero (sovereign)
EPF	~8.5%	~8.3%	Near-zero (sovereign)
CPI inflation	~6.0%	~5.5%	n/a (cost benchmark)

The numbers above are indicative averages, not guarantees. Equity returns are TRI (Total Return Index, including dividends). Real estate is national average — top metros have done much better, smaller cities much worse. Always check the actual scheme or index you are evaluating.

CAGR vs XIRR vs Absolute Return — Which Should You Use?

Three return metrics, three different jobs. Using the wrong one is the single biggest reason DIY investors compare apples with oranges.

Absolute return — total percentage gain, ignoring time. Useful only for single-shot purchases held for less than a year, where time is too short to annualise meaningfully.
CAGR — the right metric for a single lump-sum investment with one entry and one exit date. Smoothes out year-to-year volatility into a single comparable rate.
XIRR (Extended Internal Rate of Return) — the right metric for an SIP or any series of investments with different amounts on different dates. CAGR cannot handle multiple cash flows; XIRR is built for it. In Excel, the formula is =XIRR(values_range, dates_range).

Common misuse: investors compare their SIP’s “average return” (calculated as CAGR) to a Nifty index CAGR. That comparison is structurally wrong — SIP returns must be calculated as XIRR, then compared against the index XIRR over the same monthly cash flow schedule. The CAGR-vs-CAGR comparison can mislead by several percentage points.

Real CAGR — The Number That Actually Matters

Nominal CAGR is what the fund factsheet quotes. Real CAGR is nominal CAGR minus inflation — and it is the only number that tells you whether your purchasing power actually grew.

The exact formula uses the Fisher equation:

Real CAGR = (1 + nominal CAGR) ÷ (1 + inflation) − 1

For quick mental math, the approximation Real ≈ Nominal − Inflation is fine for low rates, but breaks down above 10%. Worked: a 12% nominal CAGR with 6% inflation gives a real CAGR of (1.12 ÷ 1.06) − 1 = 5.66%, not 6%. Over 30 years that 0.34% gap compounds to a meaningful difference. Use the calculator’s “Find CAGR” mode and set the inflation field to see your real number side by side.

Post-Tax CAGR — What You Actually Take Home

Indian tax on investment gains varies by asset and holding period. Post-tax CAGR adjusts the ending value by the applicable tax, then recomputes CAGR. The drag is bigger than most people assume — over a 20-year horizon, even the 12.5% long-term equity rate erodes ~0.4% of CAGR.

Equity (held > 1 year) — LTCG at 12.5% on gains above ₹1.25 lakh per year.
Equity (held ≤ 1 year) — STCG at 20% (FY2026 rate).
Debt mutual funds (post April 2023) — slab rate, regardless of holding period.
Gold (physical / digital, held > 2 years) — 12.5% with indexation removed (post Budget 2024 simplification).
FD interest — slab rate, in full, taxed every year (not at maturity).
PPF, EPF, SSY — exempt (EEE category).

The post-tax adjustment can change which asset class wins. A 7% FD (your slab is 30%) gives a post-tax CAGR of just 4.9%, lower than a 9.5% gold investment after its 12.5% tax. Always compare on a post-tax, real basis if you want the honest answer. Our stock market taxation guide walks through every category.

5 Common CAGR Mistakes — and How to Avoid Them

Hiding volatility. Two funds with the same 12% CAGR can have wildly different paths — one might be a smooth ride, the other a roller coaster with a 50% drawdown midway. Always look at the standard deviation or maximum drawdown alongside CAGR.
Cherry-picking the start date. A fund quoting “15% CAGR since 2003” may have done that on the back of one extraordinary year. Look at rolling 5-year CAGR windows instead of point-to-point.
Using CAGR on an SIP. CAGR assumes a single entry. For monthly SIPs, use XIRR — the difference can be 1–3 percentage points and changes the winner.
Forgetting inflation. A 9% CAGR sounds great until you realise inflation was 7% for the same period. Real CAGR is the only fair benchmark.
Comparing pre-tax to post-tax. Equity mutual fund CAGR is usually quoted pre-tax. PF/PPF returns are post-tax. Comparing them without adjusting is structurally wrong.

How to Use CAGR for Goal-Based Planning

Goal-based planning has three inputs: where you are, where you want to go, and how long you have. CAGR is the dial that connects them. The “Time to target” mode of the calculator above answers: “If I expect a CAGR of X%, how long until my ₹A becomes ₹B?” The “Future value” mode asks the inverse: “If I let my ₹A grow at X% for Y years, what does it become?”

For lump-sum corpus building, that is the entire toolkit. For SIPs, pair this with our crorepati calculator (target a ₹1 crore goal) or FIRE calculator India (full financial independence corpus). For the SIP-versus-lump-sum trade-off, see our breakdown at SIP vs lump sum.

CAGR Calculator: Frequently Asked Questions

What is a good CAGR for a mutual fund in India?

For equity mutual funds over a 10-year+ horizon, a CAGR of 12–15% is considered good and consistent with long-term Indian market averages. Anything above 18% over a decade is exceptional and often comes with very high volatility. For debt funds, 6–8% is a reasonable expectation. Always compare against the appropriate index benchmark for the fund category, not against absolute “good or bad” numbers.

How do I calculate CAGR in Excel or Google Sheets?

The formula is =(End_Value/Begin_Value)^(1/Years)-1. Format the cell as a percentage. For example, if A2 is the start, B2 is the end, and C2 is the number of years, the formula =(B2/A2)^(1/C2)-1 gives the CAGR. Both Excel and Google Sheets compute this identically.

What is reverse CAGR?

Reverse CAGR works the formula backwards. You know the starting amount, the expected CAGR, and the years — and you want to find the ending value. The formula is Future Value = Beginning × (1 + CAGR)^Years. Use the “Project future value” mode of the calculator above to do this in one click.

Is CAGR the same as the annualised return?

Yes. CAGR is the formal name for the annualised return on a single lump-sum investment with one entry and one exit. Other annualisation methods exist (geometric mean, time-weighted return), but for the simple case of one lump sum, they all collapse to the same number.

Can CAGR be negative?

Yes. If your ending value is less than your beginning value, the CAGR is negative — your investment has lost value at that annualised rate. A loss from ₹1 lakh to ₹80,000 over 4 years gives a CAGR of (0.8)^0.25 − 1 ≈ −5.43% per year.

How is CAGR different from absolute return?

Absolute return is the total percentage gain, ignoring time. CAGR is the annualised rate that, compounded over the same period, produces that absolute return. A ₹1 lakh to ₹2 lakh growth is 100% absolute, but the CAGR could be 7.18% over 10 years or 25.99% over 3 years — same absolute, very different annualised.

What is XIRR and when should I use it instead of CAGR?

XIRR is the right return metric for SIPs and any series of investments made on different dates. CAGR cannot handle multiple cash flows; XIRR is mathematically designed for it. For a SIP that ran for 5 years, your platform will report XIRR — not CAGR — and that is the correct number to compare against an index’s SIP-mode XIRR.

What is real CAGR?

Real CAGR is the inflation-adjusted CAGR — the actual growth in purchasing power. Formula: Real = (1 + Nominal) ÷ (1 + Inflation) − 1. If your nominal CAGR is 12% and inflation is 6%, your real CAGR is 5.66%. This is the only number that tells you whether you are actually getting wealthier.

How long does it take for money to double at a given CAGR?

Use the Rule of 72: doubling time ≈ 72 ÷ CAGR%. At 12% CAGR, money doubles every 6 years. At 8%, every 9 years. At 6%, every 12 years. For exact answers, the calculator’s “Time to target” mode uses the precise formula years = ln(target ÷ start) ÷ ln(1 + CAGR).

Does the CAGR formula account for dividends?

Only if you include them in the ending value. The standard CAGR formula uses whatever values you give it. For Indian equity index CAGRs, always check whether the figure is a Price Return Index (excludes dividends) or a Total Return Index (TRI, includes dividends). The TRI version is typically 1.5–2% higher per year and is the fair comparison for dividend-paying funds.