What Is XIRR? The Return Metric That Actually Understands Your SIP

XIRR, or Extended Internal Rate of Return, is a method for calculating the annualized return of an investment where money went in (or came out) at multiple, irregular points in time, rather than as a single lump sum invested once. It’s the correct return metric for anyone investing through a SIP, or making any series of investments and withdrawals on different dates, situations where a simple CAGR calculation, designed for a single beginning and ending value, doesn’t actually apply.

If you’ve ever looked at a mutual fund SIP investment on a platform and seen a return percentage next to it, that figure is very likely XIRR, precisely because a SIP involves many separate cash flows on many separate dates.

Why CAGR breaks down for a SIP

CAGR assumes a single lump sum invested at one point in time and held until a single ending point. A SIP doesn’t fit this shape at all: money goes in every month, each instalment buying units at that month’s NAV, meaning each instalment has effectively been invested for a different length of time by the time you check your returns. There’s no single “beginning value” to plug into the CAGR formula. XIRR solves this by accounting for every individual cash flow, its amount and its exact date, and calculating the single annualized rate of return that would explain how all those cash flows collectively grew (or shrank) into the current value.

How XIRR actually works, conceptually

XIRR essentially asks: “What single annual growth rate, applied to each individual investment from the day it was made until today, would explain the current total value of the portfolio?” Because a SIP’s earliest instalments have had more time to grow than its most recent ones, XIRR weighs each cash flow according to how long it’s actually been invested, giving a more accurate picture of your true annualized return than any simple average or point-to-point calculation could.

Calculating XIRR by hand involves solving an equation that doesn’t have a simple algebraic solution; it’s typically calculated using the XIRR function in a spreadsheet program like Excel or Google Sheets, where you list each cash flow (SIP instalments as negative values, since money left your account, and the current value as a positive value, since it’s now what you’d receive) alongside its exact date, and the function computes the annualized rate.

XIRR versus CAGR, when to use which

Use CAGR when you have a genuine single lump sum invested at one point and want to know its annualized growth to a single ending point. Use XIRR when there are multiple cash flows at different dates, a SIP, a series of lump-sum top-ups, or partial withdrawals along the way, since XIRR correctly accounts for the differing time each amount has actually been invested, while CAGR would need to be forced into an inaccurate approximation to handle the same situation.

What XIRR does not tell you

Like CAGR, XIRR is a single summary number and doesn’t reveal the volatility or the actual path the investment took to get there. It also depends heavily on accurate cash flow dates and amounts; a single incorrect entry (a missed SIP instalment, a wrong date) can distort the calculated XIRR meaningfully, so when checking XIRR manually rather than relying on a platform’s automatically calculated figure, it’s worth double-checking the underlying transaction data first.

Bottom Line

XIRR is the return metric built specifically for investments made across multiple dates, like a SIP, correctly accounting for how long each individual instalment has actually been invested rather than treating the whole series as a single lump sum. If you’re checking your SIP’s actual performance, XIRR, not a simple average return or a CAGR calculation, is the number that genuinely reflects what your money has done.

This article is for general information and isn’t personalized investment advice.

Sources

• SEBI – Investor Education, Understanding Fund Performance Metrics