CAGR Vs Absolute Return Vs XIRR: What's the Difference?

Absolute Return: The Simplest Measure

Absolute return simply measures the total percentage gain or loss on your investment, without accounting for how long you held it. The formula is: (Final Value − Initial Value) ÷ Initial Value × 100. If you invested Rs. 1,00,000 and it grew to Rs. 1,50,000, your absolute return is 50% — whether that happened in 1 year or 10 years. This is exactly why absolute return alone can be misleading for comparing investments held over different time periods.

CAGR: Return Per Year, Annualized

CAGR, or Compound Annual Growth Rate, expresses the return as a single annualized percentage, assuming the growth compounded steadily every year. The formula is: CAGR = (Final Value ÷ Initial Value)^{(1/number of years)} − 1. Using the same example, if that 50% absolute return happened over 5 years, the CAGR would be about 8.45% per year — a much more useful, comparable figure. CAGR is ideal for lumpsum investments with a single entry and exit point.

XIRR: For Investments with Multiple Cash Flows

XIRR, or Extended Internal Rate of Return, is used when you've invested at multiple different points in time — exactly the situation with a SIP, where you invest a fixed amount every month. CAGR can't handle this properly since it assumes a single lumpsum investment and exit. XIRR calculates the single annualized rate of return that would explain all your individual cash flows (each month's investment) reaching your current final value. This is why SIP returns are almost always expressed as XIRR rather than CAGR.

Getting comfortable with CAGR vs XIRR calculations pays off the moment you start tracking your own SIP or lumpsum performance accurately. Most spreadsheet tools like Microsoft Excel and Google Sheets have a built-in XIRR function, documented on Microsoft's support site, that can calculate this for you directly.

Can XIRR Be Negative?

Yes, XIRR can be negative, and this simply means your investment has lost value over the period measured, after accounting for the timing of each contribution. A negative XIRR is common during or shortly after a market downturn, especially for SIPs that started recently and haven't had enough time for later, lower-priced units to offset earlier losses. It's worth remembering that a negative XIRR over a short window doesn't necessarily indicate a bad investment decision — equity investments are expected to fluctuate, and short-term negative XIRR figures are a normal part of long-term investing, not a reason to panic or exit prematurely. What matters more is the trend over a genuinely long horizon, such as 5 or more years, rather than any single point-in-time XIRR snapshot.