XIRR vs CAGR vs Absolute Returns: Which Metric Should You Trust?

You check your mutual fund portfolio and see three different return numbers: your app shows 18% XIRR on your SIP, the fund factsheet reports 14% CAGR, and the absolute return section says 52%. All three are technically correct — but they measure very different things. Using the wrong metric leads to wrong conclusions about your investments.

The core issue: return metrics are not interchangeable. XIRR is designed for multiple cashflows (like SIPs), CAGR is designed for single lumpsum investments, and absolute return is a simple percentage change with no time dimension. Use the CAGR calculator to quickly compute the compound annual growth rate for any investment.

This guide explains each metric with real-world examples, shows you how fund platforms can cherry-pick the most flattering number, and gives you a simple framework: XIRR for SIPs, CAGR for lumpsum, absolute for short-term. Master these three and you will never be confused by return numbers again. For SIP return modelling, see the SIP calculator guide.

Absolute Returns: Simple but Misleading

The formula

Absolute Return = ((Current Value - Total Investment) / Total Investment) x 100

When to use it

Absolute returns make sense only for periods under 1 year. A 6% return in 3 months is useful information. But a 50% return over 5 years sounds impressive until you realise it is only 8.4% CAGR per year — barely beating inflation.

Why it misleads

Absolute return ignores time entirely. A 100% return in 2 years (CAGR: 41.4%) is dramatically different from a 100% return in 10 years (CAGR: 7.2%). Yet both show the same absolute return of 100%. SEBI recognises this problem and mandates that funds show absolute returns only for periods under 1 year and annualised CAGR for longer periods.

CAGR: The Right Metric for Lumpsum Investments

The formula

CAGR = ((Final Value / Initial Investment) ^ (1 / Number of Years)) - 1

What CAGR tells you

CAGR gives you the smoothed annual rate at which your investment grew, assuming profits were reinvested each year. It eliminates year-to-year volatility and gives a single number that represents the compound growth. A ₹1 lakh lumpsum that became ₹3 lakh in 10 years has a CAGR of 11.6%.

CAGR vs average annual return

These are not the same and confusing them is one of the most common investor mistakes. Consider a fund that returns +40% in year 1 and -20% in year 2. The average annual return is (+40-20)/2 = +10%. But ₹1 lakh becomes ₹1.40 lakh (year 1) then ₹1.12 lakh (year 2), giving a CAGR of only 5.8%. The arithmetic average always overstates the actual return because it ignores the volatility drag. CAGR captures this drag and gives the true growth rate.

Limitation of CAGR for SIPs

CAGR assumes a single investment at the start. If you invest via SIP (monthly contributions), CAGR does not accurately reflect your returns because each instalment has a different holding period. Your first SIP instalment may have compounded for 5 years while your latest instalment has compounded for only 1 month. For SIP investments, you need XIRR.

XIRR: The Right Metric for SIPs and Irregular Cashflows

How XIRR works

XIRR (Extended Internal Rate of Return) calculates the annualised return for a series of cashflows occurring on specific dates. It solves for the discount rate that makes the Net Present Value (NPV) of all cashflows equal to zero. In simpler terms: XIRR finds the single annual return that, if applied to each of your SIP instalments individually, would produce your current portfolio value.

Why XIRR is necessary for SIPs

In a ₹10,000/month SIP running for 3 years, you have 36 individual investments, each with a different holding period (36 months for the first, 1 month for the last). CAGR would assume the entire ₹3.6 lakh was invested on day one, which is factually wrong. XIRR correctly weights each instalment by the time it was actually invested.

XIRR calculation example

Suppose you invested ₹10,000/month for 24 months (total: ₹2,40,000) and the current value is ₹2,95,000. The CAGR approach would say: (2,95,000/2,40,000)^(1/2) - 1 = 10.8%. But this is wrong because most of the ₹2,40,000 was invested less than 2 years ago. The correct XIRR considering the actual investment dates would be approximately 18.2% — significantly higher because your earlier instalments have had more time to compound. You can verify this in Excel or Google Sheets using the XIRR function.

Quick Reference: When to Use Each Metric

How Fund Platforms Cherry-Pick the Best Number

Mutual fund platforms and distributors have an incentive to show the most impressive return figure. Here are common tactics to watch for:

Showing absolute returns for multi-year periods: A fund that returned 85% over 5 years sounds better than 13% CAGR, even though they are the same thing. Some platforms display the absolute number prominently.

Annualising short-term performance: A fund that returned 5% in 2 months might be shown as “30% annualised return.” This extrapolation is misleading because short-term performance rarely sustains. SEBI prohibits annualising returns for periods under 1 year, but not all platforms comply consistently.

Cherry-picking the start date: If a fund dropped 40% in March 2020 (COVID crash) and recovered, showing the return “since March 2020” gives a phenomenal CAGR. Always check the period and compare against the benchmark for the same period.

How to Calculate XIRR in Excel or Google Sheets

Computing XIRR for your SIP is straightforward in Excel or Google Sheets. List all your SIP dates in column A and the corresponding amounts as negative numbers (outflows) in column B. In the last row, enter today's date and the current portfolio value as a positive number (inflow). Then use the formula: =XIRR(B1:Bn, A1:An).

For example: A1 = 01/01/2024, B1 = -10000; A2 = 01/02/2024, B2 = -10000; ... A25 = 14/02/2026, B25 = 295000. The XIRR function will return the annualised return as a decimal (e.g., 0.182 = 18.2%).

Most mutual fund tracking apps (Kuvera, Groww, INDmoney) calculate XIRR automatically for your portfolio. However, they may use slightly different methods for ongoing SIPs (some use the latest NAV, others use the previous day's NAV), so numbers may vary by 0.1-0.3% between platforms.