CAGR Meaning: Formula, Example, and How to Use It
In one line
CAGR stands for Compound Annual Growth Rate, the average yearly growth rate of an investment over a period.
- Reading time
- 7 min
- 1,550 words
- Sections
- 9
- longest: Frequently Asked Questions
- Shelf
- Investing basics
- 25 explainers there
- First published
- Nov 2026
- updated 11 Nov
- 1What CAGR Really Means170
- 2The CAGR Formula and a Worked Example117
- 3Why CAGR Is Useful and Where It Is Used179
- 4Common Mistakes and Misunderstandings167
- 5CAGR vs. Other Growth Measures133
- 6How to Calculate CAGR in Excel or Google Sheets106
- 7Limitations of CAGR131
- 8Frequently Asked Questions360
- 9Related24
Counted from this page's own text. Each row links to its section.
CAGR, short for Compound Annual Growth Rate, is one of the most used numbers in finance. If you have ever seen a mutual fund fact sheet, a stock chart, or a business report, you have likely seen CAGR mentioned. It tries to answer a simple question: at what steady yearly rate did this amount grow from its starting value to its ending value over a given period?
Unlike simple average returns, CAGR smooths out the ups and downs. It gives you one single percentage that represents the annual growth as if the investment grew at a constant rate every year. This makes it useful for comparing different investments or for checking how a business has expanded over time.
What CAGR Really Means
CAGR is not an actual return you receive each year. It is a geometric average that tells you the rate at which an investment would have grown if it had compounded at a steady pace. In reality, investments rarely grow at a constant rate. Some years they go up 20%, other years they fall 10%. CAGR takes that uneven path and compresses it into one smooth annual figure.
For example, suppose you invest Rs 1,00,000. After three years, the value is Rs 1,60,000. The total growth is 60% over three years. But the CAGR is not 20% (60 divided by 3). Because of compounding, the actual CAGR is about 17%. That is the rate that, if applied each year, would turn Rs 1,00,000 into Rs 1,60,000 in three years.
The word “compound” is the key. Compounding means your returns earn returns. In the first year, you earn on the original amount. In the second year, you earn on the original plus the first year’s gain. CAGR accounts for that effect, which is why it is different from a simple average.
The CAGR Formula and a Worked Example
The formula for CAGR is:
CAGR = (Ending Value / Beginning Value) ^ (1 / Number of Years) – 1
Let us use a realistic example. Suppose you invested Rs 5,00,000 in a fund on 1 April 2020. By 31 March 2023, the value is Rs 7,00,000. That is three years.
Step by step:
- Divide ending value by beginning value: 7,00,000 / 5,00,000 = 1.4
- Raise 1.4 to the power of 1/3 (which is the cube root). 1.4 ^ 0.3333 ≈ 1.1187
- Subtract 1: 1.1187 – 1 = 0.1187
- Convert to percentage: 11.87%
So the CAGR is about 11.9% per year. That means the investment grew at an average annual rate of roughly 12%, compounded, over those three years.
If the period is not a whole number of years, you use the exact number of days divided by 365. For instance, if the holding period is 2 years and 6 months, the exponent is 2.5.
Why CAGR Is Useful and Where It Is Used
CAGR is widely used in India and globally for several purposes:
- Mutual fund returns: Fund houses and rating agencies report trailing returns as CAGR for 1, 3, 5, and 10 years. SEBI (Securities and Exchange Board of India) mandates that mutual funds show past performance using CAGR for periods longer than one year.
- Business revenue growth: Companies report their revenue CAGR over the past five years in annual reports and investor presentations.
- Comparing investments: If you want to compare a fixed deposit with a mutual fund over the same period, CAGR gives a common scale. (But remember, fixed deposits have guaranteed returns, while mutual funds do not.)
- Personal finance planning: You can calculate the CAGR of your own portfolio to see how your money has grown over time.
One important point: CAGR does not tell you about risk. A fund that grew 20% one year and fell 10% the next may have the same CAGR as a fund that grew steadily at 5% each year. CAGR hides the volatility. So always look at other measures like standard deviation or maximum drawdown if you care about risk.
Common Mistakes and Misunderstandings
People often make errors when using CAGR. Here are the most common ones:
- Confusing CAGR with total return: Total return is the overall percentage gain over the whole period. CAGR is the annualized figure. A 60% total return over three years is not a 20% CAGR; it is about 17%.
- Using simple average instead of geometric: If an investment returned 10%, 20%, and 30% over three years, the simple average is 20%. But the CAGR is lower because of the compounding effect. The actual CAGR is about 19.7%.
- Ignoring the time period: CAGR depends heavily on the start and end dates. A fund may show a high 5-year CAGR but a low 1-year CAGR. Always check the period.
- Applying CAGR to negative values: If the beginning value is negative (like a company with negative equity), the formula breaks down. CAGR works only when both beginning and ending values are positive.
- Assuming CAGR is a guarantee: CAGR is a historical calculation. It does not predict the future. Past performance is not an indicator of future returns.
CAGR vs. Other Growth Measures
CAGR is not the only way to measure growth. Here is a quick comparison:
| Measure | What It Does | When to Use |
|---|---|---|
| CAGR | Annualized growth rate assuming steady compounding | Comparing returns over different periods |
| Simple Average Return | Adds yearly returns and divides by number of years | When you want an arithmetic mean, but it ignores compounding |
| Total Return | Overall percentage gain over the whole period | When you want the actual profit made |
| XIRR | Annualized return when money is invested in multiple installments | For SIPs or lump sums with irregular cash flows |
For a Systematic Investment Plan (SIP), where you invest every month, CAGR is not the right tool. XIRR (Extended Internal Rate of Return) is used because it accounts for the timing of each investment. For a one-time lump sum investment, CAGR works fine.
How to Calculate CAGR in Excel or Google Sheets
You do not need to do the math by hand. Spreadsheet software has built-in functions.
- In Excel or Google Sheets, use the RRI function:
=RRI(nper, pv, fv). For example,=RRI(3, 500000, 700000)gives 0.1187, which is 11.87%. - Alternatively, use the POWER function:
=POWER(700000/500000, 1/3)-1. - For SIPs, use the XIRR function. You list the dates and amounts (negative for investments, positive for current value) and Excel calculates the annualized return.
If you are using a mobile app or online calculator, make sure it asks for the beginning value, ending value, and the number of years. Some calculators ask for the number of months; convert months to years by dividing by 12.
Limitations of CAGR
CAGR is a useful summary, but it has limits:
- It ignores volatility: Two investments with the same CAGR can have completely different risk profiles.
- It assumes reinvestment: CAGR assumes that all gains are reinvested and that you earn the same rate each year. In reality, dividends may be paid out, and returns vary.
- It is sensitive to the start and end points: A small change in the beginning or ending value can change the CAGR significantly.
- It does not account for taxes or inflation: CAGR is a pre-tax, nominal figure. To get a real return, you need to subtract inflation or taxes.
For example, if your CAGR is 10% but inflation is 6%, your real return is only about 4%. Similarly, if you pay tax on capital gains, the after-tax CAGR will be lower.
Frequently Asked Questions
What is the difference between CAGR and absolute return?
Absolute return is the total percentage gain over the entire period. For example, if you invest Rs 1,00,000 and it becomes Rs 1,50,000 in 5 years, the absolute return is 50%. CAGR annualizes that growth: (1.5)^(1/5) – 1 ≈ 8.45% per year. Absolute return does not consider time; CAGR does.
Can CAGR be negative?
Yes. If the ending value is less than the beginning value, the CAGR will be negative. For example, if you invest Rs 1,00,000 and after 2 years it is Rs 80,000, the CAGR is about -10.56%. Negative CAGR means the investment lost value on average each year.
Is CAGR the same as annualized return?
Yes, in most contexts, CAGR and annualized return are used interchangeably. Both refer to the geometric average annual return over a period. SEBI uses the term “annualized” in mutual fund disclosures, but the calculation is the same.
Why is CAGR not used for SIP returns?
Because SIP involves multiple investments at different times. CAGR assumes a single lump sum at the start. For SIP, the correct measure is XIRR, which takes into account the timing and amount of each installment. XIRR gives the annualized return for irregular cash flows.
What is a good CAGR for a mutual fund?
There is no fixed number. A “good” CAGR depends on the type of fund, the market conditions, and the time period. Historically, equity funds in India have delivered around 12-15% CAGR over long periods, but past performance is not a guarantee. Always compare a fund’s CAGR with its benchmark and category average over the same period.
Does CAGR include dividends?
It depends on how you calculate it. If you use the total return (including reinvested dividends) as the ending value, then yes. If you use only the price appreciation, then no. Mutual fund fact sheets usually show CAGR based on the NAV, which includes dividends reinvested if you opt for growth option. Always check the assumption.
In short, CAGR is a powerful, simple number that helps you understand growth over time. But it is not the whole story. Use it alongside other metrics like total return, volatility, and XIRR for a complete picture of your investments.
Related
Rules referred to on this page come from their publishers: the Reserve Bank of India (banking, payments), SEBI (markets, mutual funds), NPCI (UPI), the Income Tax Department (tax). Rates and fees change; check the provider's own page. General information, not financial advice. Sources and method
Spotted an error? Tell us and we will correct it (corrections).