CAGR Calculator

By Vishal Jethwani · Last reviewed · How we check our numbers

CAGR (compound annual growth rate) tells you the steady yearly return that would turn your starting amount into the final amount. Enter what you invested, what it is worth now and how many years it took. The worked example shows ₹1 lakh growing to ₹2.5 lakh in 7 years, a CAGR of 13.99%.

Interactive Sandbox

Decimals allowed: 2.5 = 2 years 6 months

CAGR

0%

Absolute return

0%

Money multiplied

0x

How your money grew at this CAGR

YearValue at year endGain that year

Advertisement

Worked example

An investment of ₹1,00,000 that grew to ₹2,50,000 in 7 years:

CAGR
13.99%
Absolute return
150%
Money multiplied
2.50x
Value each year at a steady CAGR
YearValue
Year 1₹1,13,985
Year 2₹1,29,926
Year 3₹1,48,097
Year 4₹1,68,808
Year 5₹1,92,417
Year 6₹2,19,327
Year 7₹2,50,000

Change any input in the calculator above to run your own numbers.

Advertisement

CAGR formula

CAGR = (Final value ÷ Initial value)^(1 ÷ Years) − 1

For ₹1,00,000 that grew to ₹2,50,000 in 7 years:

  1. Final ÷ initial = 2,50,000 ÷ 1,00,000 = 2.5
  2. 1 ÷ years = 1 ÷ 7 = 0.142857
  3. 2.5^0.142857 = 1.1399
  4. 1.1399 − 1 = 0.1399, or 13.99% a year

The absolute return is 150%, but that number ignores time. Earning 150% in 7 years and 150% in 15 years are very different results. CAGR puts them on the same yearly scale: 13.99% versus 6.30%.

Why CAGR is better than average return

Suppose a fund rises 50% in year one and falls 50% in year two. The "average" return is 0%, but ₹1 lakh became ₹1.5 lakh and then ₹75,000, a real loss. CAGR captures that: (75,000 ÷ 1,00,000)^(1/2) − 1 = −13.4% a year. Fund factsheets report CAGR for 1, 3, 5 and 10 years for exactly this reason.

CAGR examples

InvestmentStartEndYearsCAGR
Mutual fund holding₹1,00,000₹2,50,000713.99%
Flat bought in 2016, sold in 2026₹40 lakh₹70 lakh105.76%
Sovereign Gold Bond 2021-22 Series VII (gold price only)₹4,765/g₹14,167/g524.35%

The flat looks like a big win (₹30 lakh profit), but 5.76% a year is roughly what a bank FD paid over that decade — and that is before stamp duty, brokerage and maintenance. CAGR makes that comparison honest.

How long money takes to double

At a steady CAGR, money doubles in about 72 ÷ CAGR years (the "rule of 72"). Exact figures:

CAGRYears to double
7% (around PPF)10.2
10%7.3
12%6.1
15%5.0

When not to use CAGR

CAGR works for a single lump sum. For a SIP, each instalment is invested for a different length of time, so dividing the total gain by the years gives the wrong answer. Use the XIRR calculator for SIPs or any investment with several deposits and withdrawals. To project a lump sum forward at an assumed CAGR, use the lumpsum calculator or the future value calculator.

Also remember that CAGR is a smoothed number. A fund with a 12% CAGR may have had years of −20% and +40% along the way; CAGR says nothing about that volatility.

CAGR in Excel or Google Sheets

Use =(End/Start)^(1/Years)-1, or =RRI(Years, Start, End). For ₹1 lakh to ₹2.5 lakh in 7 years, =RRI(7,100000,250000) returns 13.99%.

Frequently asked questions

What is a good CAGR?

It depends on the risk. Bank FDs and PPF give about 6.5%–7.1% a year with no risk to capital. Diversified equity funds have historically delivered around 10%–13% over long periods, with large swings in between. Compare any CAGR with inflation (5.54% in September 2026) to see your real growth.

Can CAGR be negative?

Yes. If the final value is below the starting value, CAGR is negative and shows the average yearly loss.

How do I calculate CAGR for months instead of years?

Convert the period to years: 30 months is 2.5 years. The calculator accepts decimals.

What is the difference between CAGR and XIRR?

CAGR is for one investment made once. XIRR handles many cash flows on different dates, such as SIP instalments, top-ups and withdrawals. For a single lump sum with no other cash flows, both give the same answer.

Does CAGR include dividends?

Only if the final value includes them. For mutual funds, use the growth option's NAV or your statement's current value, which already reflects reinvested income.

Share:
Disclaimer: This calculator gives estimates from the inputs you enter. Your actual result depends on the rules applied by your bank, employer or the government on the day. sbicalculator.com is an independent site and is not affiliated with State Bank of India. Spotted an error? Tell us and we will correct it.

Advertisement

Advertisement