CAGR vs XIRR vs Absolute Return: Which to Use and When

Use absolute return for the total gain over a short period, CAGR for a single lumpsum held for more than a year, and XIRR whenever money goes in or comes out on several dates, such as a SIP. The three can give very different numbers for the same investment, so the right choice depends on how the money was invested. All the figures below are worked examples to show the maths, not indications of what any investment will earn.

The three measures at a glance

Absolute return

Absolute return ignores time. It simply compares what you have with what you put in.

Example: you invest ₹1,00,000 and it is worth ₹1,80,000 five years later.

Absolute return = (₹1,80,000 − ₹1,00,000) ÷ ₹1,00,000 = 80%

That 80% sounds impressive, but it does not say whether it took 2 years or 20. That is why absolute return is meaningful mainly for short periods.

A common mistake is dividing absolute return by years: 80% ÷ 5 = 16% a year. This "simple annual" figure overstates the true yearly growth because it ignores compounding.

Periods under one year

The reverse mistake happens with short periods. If ₹1,00,000 becomes ₹1,05,000 in six months, the absolute return is 5%. Annualising it to about 10% assumes the next six months will be just as good, which may not happen. As of October 2026, SEBI's rules on how mutual funds present performance require returns for periods under one year to be shown as absolute (simple) returns, and returns for one year and above as CAGR.

CAGR: compound annual growth rate

CAGR is the constant yearly rate at which a single investment would have grown from its starting value to its ending value.

CAGR = (End value ÷ Start value)^(1 ÷ years) − 1

Same example: ₹1,00,000 to ₹1,80,000 in 5 years.

• 1,80,000 ÷ 1,00,000 = 1.8
• 1.8^(1/5) = 1.12475
• CAGR = 12.47% a year

Check: ₹1,00,000 × (1.1247)^5 ≈ ₹1,79,963, which rounds back to ₹1,80,000. Compare this with the misleading 16% "simple annual" figure.

You can calculate this with the CAGR calculator or in Excel with =(B2/B1)^(1/B3)-1.

Where CAGR falls short

• It hides volatility. A fund that rose 50% one year and fell 30% the next has a 2-year CAGR of about 2.5%, the same as a fund that rose 2.5% steadily each year. The ride was very different.
• It works only for one starting amount. If you added money along the way, CAGR on the total invested is wrong, as the next example shows.
• It is point-to-point. A CAGR measured from a market peak looks very different from one measured from a trough. Rolling returns, which average many start dates, give a fairer picture of a fund's history.

XIRR: extended internal rate of return

XIRR finds the single annual rate that, applied to every cash flow from its own date, makes all your investments grow to exactly the current value. It is the right measure for SIPs, irregular top-ups and partial withdrawals.

Worked example with irregular investments

Investments are entered as negative and the current value or withdrawal as positive.

Absolute return = (₹1,60,000 − ₹1,30,000) ÷ ₹1,30,000 = 23.08%.

Wrong CAGR, treating all ₹1,30,000 as invested on day one for 3 years: (1,60,000 ÷ 1,30,000)^(1/3) − 1 = 7.17%. This understates performance because two-thirds of the money was invested later.

XIRR = 10.47% a year. You can verify it by growing each investment at 10.47% to 1 January 2026:

Each value is the amount × (1.1047)^(days ÷ 365). The three add up to the actual ₹1,60,000, which confirms 10.47% is the rate that fits all the dates.

How to calculate XIRR in Excel or Google Sheets

1. Put dates in one column and cash flows in the next, with investments negative.
2. Add today's date and the current value (positive) as the last row.
3. Use =XIRR(B2:B5, A2:A5).

Most mutual fund apps, registrar statements from CAMS and KFintech, and MF Central show XIRR for your SIP portfolio automatically.

Applying this to SIPs

A SIP is the classic XIRR case: each instalment has a different holding period. Suppose a ₹10,000 monthly SIP for 20 years is worth ₹99,91,479. The absolute return on ₹24 lakh invested is 316.3%, but the money that produced it was invested gradually. That value comes from an illustrative 12% a year assumption compounded monthly at 1% a month, which is 12.68% a year in effective terms (1.01^12 − 1), so the SIP's XIRR works out to about 12.7%. Our SIP of ₹5,000 or ₹10,000 a month guide shows how these illustrative SIP values are computed, and you can try your own in the SIP calculator.

When comparing a SIP with a lumpsum, compare the SIP's XIRR with the lumpsum's CAGR, not absolute returns. Our SIP vs lumpsum article explains why the two often differ.

Which number to look at, by situation

Common mistakes

• Comparing different measures. A fund's 5-year CAGR and your own portfolio's XIRR are not directly comparable unless the cash flows match.
• Annualising very short periods. A 3% gain in one month is not a 42% annual return.
• Ignoring taxes and costs. Returns shown by funds are after expense ratio but before your tax. Compare post-tax figures for FDs and funds alike.
• Using CAGR from a lucky start date. Check several periods or rolling returns before drawing conclusions.
• Treating past CAGR as a forecast. A fund's past 12% CAGR does not mean it will earn 12% next. Mutual fund documents carry this warning for a reason.

Key takeaways

• Absolute return shows total gain and suits periods under a year; SEBI requires sub-one-year fund returns to be shown this way.
• CAGR is the right annual rate for a single lumpsum: ₹1 lakh to ₹1.8 lakh in 5 years is 12.47% a year, not 16%.
• XIRR handles multiple dated cash flows, so it is the correct measure for SIPs and portfolios with top-ups or withdrawals.
• In the worked example, the same portfolio shows 23.08% absolute, a misleading 7.17% simple CAGR, and a correct 10.47% XIRR.
• Past returns, however measured, do not predict future returns.