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
- Worked examples
- How to calculate CAGR in Excel or Google Sheets
- CAGR vs absolute return vs XIRR
- Rule of 72: quick CAGR maths
- How ₹1 lakh grows at different CAGRs
- Using CAGR to plan a goal
- Real CAGR: adjusting for inflation
- CAGR in business and stock analysis
- Limitations of CAGR
- Frequently asked questions
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
| Measure | What it shows | Best used for |
|---|---|---|
| Absolute return | Total % change, ignoring time | Holding periods under one year |
| CAGR | Smoothed yearly growth between two points | A single lump-sum investment held for over a year |
| XIRR | Annualised return with multiple cash flows on different dates | SIPs, top-ups, partial withdrawals |
| Average annual return | Simple mean of yearly returns | Rarely 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
| CAGR | After 10 years | After 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
- AMFI — mutual fund return disclosures
- SEBI Investor website — investor education on returns
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.