Investments & Growth 6 min read

What CAGR Means and Why Average Returns Mislead

Why the compound annual growth rate is the honest way to measure a multi-year investment, with worked examples in rupees.

By TrueFunds Editorial Team Published Updated

The trap of simple averages

Suppose ₹1 lakh rises 50% in the first year to ₹1.5 lakh and then falls 50% in the second year to ₹75,000. The average of +50% and −50% is 0%, which suggests you broke even. In reality you lost ₹25,000.

The compound annual growth rate (CAGR) captures this correctly: the investment shrank at about −13.4% a year over the two years.

The gap grows with volatility. Here is a more ordinary five-year run:

₹1 lakh over five uneven years
YearReturnValue at year end
1+25%₹1,25,000
2−10%₹1,12,500
3+18%₹1,32,750
4+4%₹1,38,060
5−6%₹1,29,776

The returns average 6.2% a year, but the money actually grew at a CAGR of 5.35%. Two years of +40% and two of −30% average +5% a year, yet ₹1 lakh would fall to ₹96,040.

How CAGR is calculated

CAGR = (ending value ÷ starting value)^(1 ÷ number of years) − 1. It is the steady yearly rate that would take the starting value to the ending value over the same period.

If ₹1 lakh grows to ₹2.5 lakh in 7 years:

  • Divide the ending value by the starting value: ₹2.5 lakh ÷ ₹1 lakh = 2.5.
  • Raise the result to the power of 1 ÷ 7: 2.5^(1/7) ≈ 1.1399.
  • Subtract 1 and express it as a percentage: a CAGR of about 14% a year.

That holds even if the actual yearly returns jumped around along the way.

CAGR versus absolute return

Absolute return is the total percentage gain, without regard to time. Doubling your money is a 100% absolute return whether it takes 5 years or 10, but the CAGR is about 14.9% over 5 years and only about 7.2% over 10.

Growth of ₹1 lakh
Ending valueYearsAbsolute returnCAGR
₹2 lakh5100%14.87%
₹2 lakh10100%7.18%
₹2.5 lakh7150%13.99%
₹3 lakh10200%11.61%

Convert absolute returns to CAGR before comparing an investment with an FD rate, with inflation or with another investment held for a different period.

Using CAGR to compare different investments

CAGR puts very different investments on the same footing. A flat bought for ₹50 lakh and sold for ₹80 lakh eight years later sounds like a big gain, but the CAGR is about 6.05% a year, before stamp duty, brokerage, maintenance and tax, and before counting any rent received. A 7% FD that compounds quarterly grows at about 7.19% a year.

The same idea works outside investing. If a company’s revenue grows from ₹200 crore to ₹350 crore in four years, its revenue CAGR is about 15% a year, which is how annual reports and analysts usually describe growth.

When to use CAGR and when not to

CAGR works for a single lump-sum investment held over a period, such as a stock bought once or a fund’s performance between two dates. Mutual fund factsheets report returns for periods of more than a year as CAGR.

For SIPs or any investment with several deposits or withdrawals, CAGR is the wrong tool because each instalment was invested for a different length of time. Use XIRR, which accounts for the date of every cash flow.

XIRR for SIPs

XIRR finds the single yearly rate that makes all your cash flows, every instalment and the final value, add up, taking the date of each into account. Spreadsheet programs have an XIRR function, and most mutual fund statements show it.

Suppose you invest ₹10,000 at the start of every month for three years, ₹3.6 lakh in all, and the holding is worth ₹4.5 lakh at the end. The absolute gain is 25%. Treating the ₹3.6 lakh as if it had all been invested on day one gives a CAGR of about 7.7%, which badly understates the result. The XIRR, which allows for each instalment’s shorter time in the market, is about 15% a year.

Real CAGR: growth after inflation

A CAGR tells you how fast your money grew, not how much more it can buy. To find the real growth rate, divide (1 + CAGR) by (1 + inflation) and subtract 1.

A 12% CAGR with 6% inflation is a real return of about 5.7% a year, slightly less than the 6% you get by simply subtracting. Over long periods, the real CAGR is the number that tells you whether your savings are growing in purchasing power.

Tax matters in the same way. Gains on an equity fund held for many years are taxed only when you sell, while FD interest is taxed every year, so compare CAGRs after tax when choosing between them.

Reading fund returns

Mutual fund factsheets show trailing returns: the CAGR from a date one, three, five or ten years ago to today. These depend heavily on the start and end dates, and a fund measured from a market low looks far better than the same fund measured from a peak.

Rolling returns reduce this effect. They calculate, say, every three-year CAGR over a long period and show the average, best and worst, which tells you how consistent a fund has been. Past returns, however they are measured, do not guarantee future ones.

What CAGR hides

CAGR shows only the start and end points. Two funds with the same 12% CAGR could have had very different journeys, one steady and one with deep falls along the way. Check year-by-year returns and how much a fund fell in bad years before you invest, and ask yourself whether you could have held on through those falls.

Frequently asked questions

What is a good CAGR?

It depends on the asset and the risk. Compare a CAGR with an alternative of similar risk: a bank FD rate for safe money, a fund’s benchmark index for equity, and inflation for any long-term goal.

Can CAGR be negative?

Yes. If the ending value is below the starting value, the CAGR is negative. ₹1 lakh that falls to ₹75,000 over two years has a CAGR of about −13.4%.

Is CAGR the same as annualised return?

For a single investment between two dates, yes: annualised return usually means CAGR. For investments with several cash flows, such as a SIP, the annualised return is calculated as XIRR.

How is CAGR different from the average annual return?

The average simply adds the yearly returns and divides by the number of years. CAGR compounds them, so it reflects what actually happened to your money, and it is never higher than the average.

How do I calculate CAGR in Excel or Google Sheets?

Use =(ending value/starting value)^(1/years)-1, or the RRI function: =RRI(years, starting value, ending value). For investments with several cash flows, list the dates and amounts and use the XIRR function.

Why do two websites show different CAGRs for the same fund?

Usually because they use different start or end dates, or different plans of the fund. The direct and regular plans of a fund have different returns, and a CAGR measured from a market low or high can differ by several percentage points.

Should I pick the fund with the highest CAGR?

Not on that alone. A high CAGR over a short period may reflect one exceptional year. Look at returns over several periods, rolling returns, how far the fund fell in bad years, its costs and whether its strategy suits your goal.

Sources

Note: This educational guide is designed to clarify mathematical concepts and general market conventions. Figures and worked calculations are hypothetical examples and do not constitute individual advisory recommendations.