What is CAGR? How to Calculate Compound Annual Growth Rate (2026)

Last updated: June 2026 · 8 min read · Finance & Investment

When a mutual fund advertises "20% returns," do they mean last year? Over five years? Since inception? CAGR — Compound Annual Growth Rate — is the one number that makes investment comparisons honest. Here is everything you need to know.

What is CAGR?

CAGR is the rate at which an investment would have grown each year if it grew at a steady rate — as if compounding happened smoothly year over year. Real investments are volatile; CAGR smooths that volatility into a single, comparable annual growth number.

It answers the question: "If my investment grew at the same rate every year, what would that annual rate be?"

The CAGR Formula

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

Expressed as a percentage by multiplying by 100.

Worked Example 1: Mutual Fund

You invested ₹1,00,000 in a mutual fund in 2021. In 2026 (5 years later) it is worth ₹2,10,000.

CAGR = (2,10,000 ÷ 1,00,000)^(1/5) − 1
= (2.10)^(0.2) − 1
= 1.1598 − 1
= 15.98% per year

Worked Example 2: Comparing Two Funds

FundInvestedValue (5 yr)CAGR
Fund A₹1,00,000₹2,10,00016.0%
Fund B₹1,00,000₹1,95,00014.3%
Fund C₹1,00,000₹2,30,00018.1%

Fund C wins even though all three had the same starting amount. Without CAGR you would need to calculate each manually.

👉 Calculate CAGR instantly — enter your start value, end value, and number of years.

CAGR vs Absolute Returns vs XIRR

MetricWhat it showsBest used for
Absolute ReturnTotal % gain over entire periodQuick glance; not time-adjusted
CAGRAnnual growth rate (lump sum)Comparing lump sum investments
XIRRAnnual return for irregular cash flowsSIPs, multiple investments/withdrawals

Important: CAGR only works for lump sum investments. If you invested through monthly SIPs, use XIRR instead — CAGR will overstate your actual returns.

What is a Good CAGR in India?

Asset ClassTypical 10-Year CAGR (India)
Fixed Deposit (FD)6–7%
PPF7–7.5%
Gold9–11%
Nifty 50 Index Fund12–14%
Large-Cap Mutual Fund13–16%
Mid-Cap Mutual Fund16–20%
Small-Cap Mutual Fund18–24% (high volatility)

A CAGR beating inflation (currently ~5–6% in India) is the minimum bar. Beating FD rates (6–7%) means your money is genuinely growing in real terms.

CAGR Limitations You Must Know

How to Use CAGR for Your Financial Goals

You can reverse the CAGR formula to find out how much you need to invest to reach a goal.

Formula: Required Investment = Goal Amount ÷ (1 + CAGR)^Years

Example: You want ₹50 lakhs in 10 years. You expect a CAGR of 12%.
Required lump sum = 50,00,000 ÷ (1.12)^10 = 50,00,000 ÷ 3.1058 = ₹16.1 lakhs today

Frequently Asked Questions

Is CAGR the same as annual return?

Not exactly. Annual return is the actual return in a specific year. CAGR is the smoothed average growth rate across multiple years. A fund can have -10% in year 1 and +40% in year 2, but still show a CAGR of around 13%.

Can CAGR be negative?

Yes. If your ending value is less than your starting value, CAGR will be negative. This simply means the investment lost value over that period on an annualised basis.

How do I calculate CAGR in Excel?

Use: =(End_Value/Start_Value)^(1/Years)-1. Format the cell as a percentage.

Also see: SIP vs Lumpsum | What is Compound Interest? | PPF vs FD