CAGR Calculator

What is Compound Annual Growth Rate (CAGR) and Why Does It Matter?

When assessing investment performance across stocks, mutual funds, real estate, or gold, raw gains alone can be misleading. A portfolio that grows by 100% over 3 years is substantially more profitable than one that takes 10 years to achieve the same 100% return.

Compound Annual Growth Rate (CAGR) solves this comparison dilemma by representing the constant annual rate of return that would take an investment from its initial purchase value to its final maturity value, under the assumption that all generated gains are reinvested at the end of every annual compounding period.

In the real world, investments do not grow in a straight, linear path. A stock portfolio might gain +30% in year one, plunge -15% in year two, and recover +25% in year three. CAGR acts as a geometric smoothing mechanism: it cuts through erratic year-to-year market volatility to provide a single, standardized annualized percentage figure that lets you evaluate and benchmark distinct investments side by side.

Key Takeaway: CAGR is the global benchmark metric used by portfolio managers, equity research analysts, and private equity investors because it accounts for the exponential power of compound growth rather than simple linear averages.

The Mathematical Formula for Calculating CAGR

Calculating CAGR requires three essential variables: the initial investment value (beginning worth), the final portfolio value (ending worth), and the holding tenure expressed in years.

CAGR = [ ( Ending Value ÷ Beginning Value ) ^{( 1 ÷ n )} − 1 ] × 100

Where:

Beginning Value (BV): The total capital or purchase price initially invested.
Ending Value (EV): The current market value, redemption proceeds, or final sale price.
n: The total duration of the investment expressed in years. If duration is in months, n = Months ÷ 12. If in days, n = Days ÷ 365.

Real-World Case Study 1: Long-Term Equity Wealth Creation (₹10 Lakh to ₹50 Lakh in 10 Years)

Suppose an investor purchased a diversified portfolio of Indian equity mutual funds for ₹10,00,000 on April 1, 2016. On April 1, 2026, the portfolio value stands at ₹50,00,000. Here is how the annual return is calculated step-by-step:

Compute the Wealth Multiplier: ₹50,00,000 ÷ ₹10,00,000 = 5.00 (5x growth).
Determine the Annual Exponent: 1 ÷ 10 = 0.10.
Calculate the Growth Factor: 5.00^0.10 = 1.17462.
Convert to Annual Percentage: (1.17462 − 1) × 100 = 17.46% CAGR p.a.

While the portfolio generated a +400% Absolute Return over the entire decade, its true annualized compounding velocity was 17.46% per year.

Real-World Case Study 2: Calculating Negative CAGR (Market Downside)

CAGR equally measures annualized capital erosion during bear markets. If an investment of ₹5,00,000 declines to ₹3,50,000 over 3 years:

CAGR = [ ( ₹3,50,000 ÷ ₹5,00,000 ) ^{( 1 ÷ 3 )} − 1 ] × 100 = [ 0.70 ^0.3333 − 1 ] × 100 = −11.19% p.a.

This indicates that the investment suffered an annualized compound loss of -11.19% per year, resulting in a total absolute loss of -30.00%.

How to Calculate CAGR in Microsoft Excel and Google Sheets

If you are analyzing investment data in spreadsheets, you can compute CAGR using three formulas:

Spreadsheet Method	Formula Syntax	When to Use
1. Basic Math Formula	`=((Ending_Cell / Beginning_Cell) ^ (1 / Years_Cell)) - 1`	Works universally across Excel, Google Sheets, LibreOffice, and Numbers.
2. The RRI Function	`=RRI(nper, pv, fv)`	Native Excel/Google Sheets formula (nper = years, pv = initial, fv = final).
3. The RATE Function	`=RATE(nper, 0, -pv, fv)`	Standard financial function (ensure pv is entered as a negative number).

CAGR vs Absolute Return vs IRR vs XIRR: Detailed Breakdown

One of the most common investor errors is using the wrong return metric for a given investment structure. Here is how each metric functions:

Metric	Mathematical Definition	Best Applied To	Core Limitation
CAGR	((EV ÷ BV)^{(1 / n)}) − 1	Single lump-sum deposits held for > 1 year (Mutual Funds, Stocks, Gold, Property).	Cannot calculate returns for periodic cash inflows (like SIPs) or partial redemptions.
Absolute Return	((EV − BV) ÷ BV) × 100	Short-term trades (< 1 year) and calculating total lifetime cash profit percentage.	Completely ignores time. A 40% gain in 6 months is exceptional; 40% over 10 years is subpar.
XIRR	Extended Internal Rate of Return with exact calendar cash flow dates.	Systematic Investment Plans (SIPs), recurring deposits, and multi-tranche withdrawals.	Requires the exact date and amount for every single inflow and outflow transaction.
IRR	Internal Rate of Return assuming uniform, equal time intervals.	Project finance, annual venture capital cash flows, and structured private debt.	Assumes identical time spacing (e.g. exactly 365 days) between successive cash flows.

Why CAGR fails for SIPs: In a 5-year Monthly SIP (60 instalments), your first instalment stays invested for 60 months, but your 60th instalment is invested for only 1 month. Applying CAGR to the total invested amount produces an artificially depressed return. Always use XIRR for SIP performance.

Nominal CAGR vs Real (Inflation-Adjusted) CAGR

A high nominal CAGR can be deceptive if high inflation is eroding the real purchasing power of your money. Real CAGR calculates your capital growth after stripping out the impact of consumer price inflation using the Fisher Equation:

Real CAGR = [ ( 1 + Nominal CAGR ) ÷ ( 1 + Annual Inflation Rate ) ] − 1

Consider an investor who achieves a 12.00% Nominal CAGR in an economy experiencing 6.00% annual inflation:

Real CAGR = [ ( 1 + 0.12 ) ÷ ( 1 + 0.06 ) ] − 1 = [ 1.12 ÷ 1.06 ] − 1 = 5.66% p.a.

This reveals that the investor's actual basket of goods and services purchasing power expanded at 5.66% per year, rather than the raw 12.00%.

The Impact of Taxation on Post-Tax CAGR in India

Taxes further reduce net annualized returns. Under current Indian tax laws:

Equity Mutual Funds / Direct Stocks: Long-Term Capital Gains (LTCG) above ₹1.25 Lakh per financial year are taxed at 12.50% (without indexation).
Bank Fixed Deposits & Debt Funds: Interest gains are added to taxable income and taxed at your marginal slab rate (up to 30% + cess).
Sovereign Gold Bonds (SGB) & PPF: 100% tax-free capital gains at maturity under Section 47(viic) and Section 10(11).

Mental Math Shortcuts: The Rule of 72, 114, and 144

You can estimate wealth milestones in seconds without opening a calculator by dividing these mathematical constants by your expected CAGR:

Rule of 72 — Doubling (2x Growth)

Years to Double = 72 ÷ CAGR (%)
At 12% CAGR: 72 ÷ 12 = 6.0 Years
At 15% CAGR: 72 ÷ 15 = 4.8 Years

Rule of 114 — Tripling (3x Growth)

Years to Triple = 114 ÷ CAGR (%)
At 12% CAGR: 114 ÷ 12 = 9.5 Years
At 15% CAGR: 114 ÷ 15 = 7.6 Years

Rule of 144 — Quadrupling (4x Growth)

Years to Quadruple = 144 ÷ CAGR (%)
At 12% CAGR: 144 ÷ 12 = 12.0 Years
At 15% CAGR: 144 ÷ 15 = 9.6 Years

Annualized CAGR Rate	Time to Double (2x)	Time to Triple (3x)	Time to Quadruple (4x)
7.0% (FD / PPF)	~10.3 Years	~16.3 Years	~20.6 Years
10.0% (Gold / SGB)	~7.2 Years	~11.4 Years	~14.4 Years
12.0% (Nifty 50 Index)	~6.0 Years	~9.5 Years	~12.0 Years
15.0% (Active Equity Funds)	~4.8 Years	~7.6 Years	~9.6 Years
18.0% (High-Growth Equities)	~4.0 Years	~6.3 Years	~8.0 Years

Historical Long-Term CAGR Benchmarks in India (15-to-20 Year Horizons)

To evaluate whether an investment's CAGR is competitive, compare it against historical benchmarks across major asset classes in India:

Asset Class	Historical CAGR	Risk & Volatility	Tax Treatment
Nifty 50 Index (Large Cap)	11.5% – 13.0%	Moderate to High Market Risk	12.5% LTCG above ₹1.25 Lakh exemption
Nifty Midcap 150 Index	14.5% – 17.5%	High Volatility & Drawdowns	12.5% LTCG above ₹1.25 Lakh exemption
Sovereign Gold Bonds (SGB)	10.0% – 12.5%	Low to Moderate (Gold Price)	100% Tax-Free capital gains at 8-yr maturity
Public Provident Fund (PPF)	7.10% (Govt Fixed)	Zero Risk (Sovereign Guarantee)	100% Tax-Free under EEE regime
Bank Fixed Deposits (FD)	6.5% – 7.5%	Very Low (DICGC ₹5 Lakh cover)	Taxed at slab rates (TDS applicable)
Tier-1 Residential Real Estate	7.5% – 10.0%	Illiquid, High Transaction Costs	12.5% LTCG without indexation

The Limitations & Traps of Relying on CAGR Alone

While CAGR is a widely used financial metric, relying on it in isolation can lead to misjudging investment risk:

1. The Volatility Smoothing Trap: CAGR assumes an unvarying, constant growth rate every single year. In reality, an investment with a 15% CAGR over 5 years might experience an alarming 40% mid-period market crash. Investors who panic-sell during downturns never achieve the quoted CAGR.
2. Endpoint Sensitivity Bias: CAGR is highly sensitive to the exact start and end dates chosen. Measuring returns from a bear market trough to a bull market peak exaggerates performance, while measuring to a market bottom sharply depresses the calculated rate.
3. Reinvestment Assumption: The formula inherently assumes that all interim dividends, interest payouts, and cash yields are continually reinvested back into the asset at the same compounding rate.
4. Neglect of Intermittent Cash Inflows/Outflows: CAGR cannot evaluate accounts where capital was added or withdrawn over time.

Frequently Asked Questions

What is Compound Annual Growth Rate (CAGR) and why is it superior to Absolute Return?

Compound Annual Growth Rate (CAGR) measures the steady, annualized rate at which an investment grows over multiple years, assuming all earnings are reinvested at the end of each year. Unlike Absolute Return—which only shows total percentage gain regardless of whether it took 1 year or 10 years—CAGR normalizes performance over time. This makes it possible to accurately compare investments across different asset classes and holding periods.

What is the exact mathematical formula used to calculate CAGR?

The mathematical formula for CAGR is: CAGR = ((Ending Value / Beginning Value) ^ (1 / n)) - 1. In this formula, 'Ending Value' is the final portfolio worth, 'Beginning Value' is the initial capital invested, and 'n' is the total duration expressed in years (or total months divided by 12). Multiplying the result by 100 converts the decimal into an annual percentage rate.

Why should you use XIRR instead of CAGR for Mutual Fund SIPs?

CAGR is designed specifically for point-to-point lump-sum investments with a single upfront deposit and a single final value. For Systematic Investment Plans (SIPs), recurring deposits, or portfolios with multiple inflows and withdrawals, CAGR produces inaccurate figures because each instalment is invested for a different duration. In these cases, XIRR (Extended Internal Rate of Return) must be used to calculate the annualized return based on the exact transaction date of every cash flow.

What is a good CAGR benchmark for investments in India?

In the Indian financial market, a 'good' CAGR depends on the asset class and risk profile. Historically over 10-to-20 year horizons: Sovereign fixed-income instruments like PPF and Fixed Deposits generate 6.5% to 7.5% CAGR; Gold and Sovereign Gold Bonds (SGB) deliver 9% to 12% CAGR; Broad-market equity indices like the Nifty 50 compound at 11% to 13% CAGR; and actively managed Mid/Small-cap mutual funds target 14% to 17% CAGR.

How do you calculate Real Inflation-Adjusted CAGR?

Nominal CAGR only measures the rupee growth of your capital without considering the loss of purchasing power over time. To calculate the Real CAGR, use the Fisher equation: Real CAGR = ((1 + Nominal CAGR) / (1 + Inflation Rate)) - 1. For instance, if an equity portfolio generates a 12% nominal CAGR in an economy with 6% annual inflation, the true real growth in purchasing power is ((1 + 0.12) / (1 + 0.06)) - 1 = 5.66% per annum.

How can you calculate CAGR in Microsoft Excel or Google Sheets?

In Excel or Google Sheets, you can calculate CAGR using three methods: (1) The standard arithmetic formula: =(Ending_Cell / Beginning_Cell) ^ (1 / Years_Cell) - 1. (2) The native RRI function: =RRI(nper, pv, fv), where nper is the number of periods, pv is the present value, and fv is the future value. (3) The RATE function: =RATE(nper, 0, -pv, fv).

How does the Rule of 72 help you estimate CAGR in your head?

The Rule of 72 is a mental math shortcut that calculates how many years it takes to double an investment at a given compound rate. Dividing 72 by the expected CAGR gives the approximate doubling time in years (e.g., at a 12% CAGR, an investment doubles in roughly 72 / 12 = 6 years). Conversely, if an investment doubled in 8 years, its CAGR was approximately 72 / 8 = 9% per annum.

What are the major limitations and risks of relying solely on CAGR?

The main limitation of CAGR is that it completely conceals market volatility and interim drawdown risks by assuming a perfectly smooth annual growth trajectory. It does not account for severe bear markets during the holding period, is heavily sensitive to the chosen start and end dates (endpoint bias), and ignores ongoing cash flows such as dividend payouts, capital gains taxes, and management expense ratios.

Year-by-Year Growth Table