Skip to content
Bulk Verify
GST Guides

CAGR Full Form: Compound Annual Growth Rate — Formula, Calculation and Examples

· GST Search Team · 4 min read

CAGR full form is Compound Annual Growth Rate. CAGR is the constant yearly rate at which a value would have to grow, with compounding, to go from its starting value to its ending value over a given number of years. Investors use CAGR to compare mutual funds, stocks and fixed deposits; businesses use it to describe growth in revenue, profit or customers over several years.

In this article

CAGR formula

CAGR = (Ending value ÷ Beginning value)1/n − 1

where n is the number of years. Multiply the result by 100 to express it as a percentage.

Worked examples

Example 1: Investment doubling in 5 years

₹1,00,000 grows to ₹2,00,000 in 5 years.
CAGR = (2,00,000 ÷ 1,00,000)1/5 − 1 = 20.2 − 1 = 1.1487 − 1 = 14.87%.

Example 2: Company revenue

Revenue rises from ₹40 crore to ₹70 crore in 4 years.
CAGR = (70 ÷ 40)1/4 − 1 = 1.750.25 − 1 = 1.1502 − 1 = 15.02%.

Example 3: Volatile returns

₹1,00,000 gains 50% in year 1 (₹1,50,000) and falls 50% in year 2 (₹75,000). The simple average return is 0%, but the CAGR is (75,000 ÷ 1,00,000)1/2 − 1 = −13.4%. CAGR tells the truth about what actually happened to your money.

How to calculate CAGR in Excel or Google Sheets

  • Formula method: =(B2/A2)^(1/C2)-1, where A2 is the start value, B2 the end value and C2 the number of years.
  • RRI function: =RRI(C2, A2, B2) returns the same result.
  • Format the cell as a percentage.

For partial years, use the exact number of days ÷ 365 as n — for example 2 years and 6 months is n = 2.5.

CAGR vs absolute return vs XIRR

MeasureWhat it showsBest used for
Absolute returnTotal % change, ignoring timeHolding periods under one year
CAGRSmoothed yearly growth between two pointsA single lump-sum investment held for over a year
XIRRAnnualised return with multiple cash flows on different datesSIPs, top-ups, partial withdrawals
Average annual returnSimple mean of yearly returnsRarely useful; overstates volatile returns

Mutual fund factsheets show returns of more than one year as CAGR, and SIP returns as XIRR.

Rule of 72: quick CAGR maths

Divide 72 by the annual growth rate to estimate the years needed to double money. At 12% CAGR, money doubles in about 72 ÷ 12 = 6 years; at 7.1% (the current PPF rate), in about 10 years. Reverse it to find the rate: money that doubled in 8 years grew at roughly 72 ÷ 8 = 9% CAGR.

How ₹1 lakh grows at different CAGRs

CAGRAfter 10 yearsAfter 20 years
8%₹2.16 lakh₹4.66 lakh
10%₹2.59 lakh₹6.73 lakh
12%₹3.11 lakh₹9.65 lakh
15%₹4.05 lakh₹16.37 lakh

The gap between 8% and 15% looks small in one year but becomes more than three times the final amount over 20 years. This is why even a 1% difference in fund expenses or returns matters for long-term goals.

Using CAGR to plan a goal

You can rearrange the formula to find the growth rate a goal needs. Suppose you have ₹10 lakh today and want ₹50 lakh in 15 years:

Required CAGR = (50 ÷ 10)1/15 − 1 = 50.0667 − 1 ≈ 11.3%.

If that rate is higher than what your chosen asset mix can reasonably deliver, either invest more each year, extend the timeline or adjust the goal.

Real CAGR: adjusting for inflation

A nominal CAGR includes inflation. To see real growth in purchasing power:

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

With a 12% nominal CAGR and 5% inflation, real CAGR = 1.12 ÷ 1.05 − 1 ≈ 6.7%. A fixed deposit earning 7% before tax may give close to zero real growth after tax and inflation for someone in a high tax bracket.

CAGR in business and stock analysis

Analysts quote revenue CAGR, profit CAGR and EPS CAGR over three, five or ten years. When reading these figures:

  • Check the start year — a CAGR measured from a very weak year (such as a pandemic-hit year) looks unusually high.
  • Compare revenue CAGR with profit CAGR; profits growing slower than revenue suggests shrinking margins.
  • Look at the yearly numbers too; CAGR hides how bumpy the path was.
  • For market sizing reports, check the source and assumptions behind any projected CAGR.

Limitations of CAGR

  • Ignores volatility — two investments with the same CAGR can carry very different risk.
  • Only two points — it uses the start and end values and ignores what happened in between.
  • Not for multiple cash flows — use XIRR for SIPs or irregular investments.
  • Past CAGR does not predict future returns, especially for equity.

Frequently asked questions

What is the full form of CAGR?

CAGR stands for Compound Annual Growth Rate.

What is the CAGR formula?

CAGR = (Ending value ÷ Beginning value)^(1/n) − 1, where n is the number of years.

What is a good CAGR?

It depends on the asset and risk. Compare CAGR with the right benchmark — an equity fund with its index, a debt fund with similar debt funds — and with inflation.

Is CAGR the same as XIRR?

No. CAGR assumes one investment at the start; XIRR handles multiple investments and withdrawals at different dates.

Can CAGR be negative?

Yes. If the ending value is lower than the starting value, CAGR is negative.

Official sources

This article is general information, not tax, legal or investment advice. Rules and rates change — check the official portal or consult a qualified chartered accountant before acting.