XIRR: the return on money invested on many dates
When money goes in on many different dates, a single return figure only makes sense if it accounts for the timing. XIRR is the measure that does that.
XIRR — extended internal rate of return — is the way to express a single annualised return when money went in (and perhaps came out) on many different dates. That is exactly the situation a SIP creates, which is why XIRR is the honest return figure for one.
The problem a simple return cannot handle
A plain CAGR assumes one amount went in at the start and grew to the end. But with a SIP, each instalment went in on its own date and has been invested for a different length of time — the first for years, the last for weeks. Averaging that as if it were a single lump sum would misstate the return, because it ignores when each rupee actually started working.
What XIRR does
XIRR takes every cashflow with its date — each instalment paid in, and the final value at the end — and finds the single annual rate that ties them all together consistently. In effect it asks: what one steady yearly rate, applied to each amount for exactly the time it was invested, would produce the value you ended up with? That rate is the XIRR.
XIRR versus CAGR
The distinction is simple. Use CAGR for a single investment made once and measured start to end. Use XIRR when money moved in or out on multiple dates — a SIP, a series of top-ups, a withdrawal plan, or any mix. XIRR is the more general tool; CAGR is the special case where there was only one cashflow in and one out.
When you need it
Any time you want the true return on a staggered set of investments, XIRR is the figure to look for — and it is what a proper account statement uses to report the return on an SIP. If you see a single percentage attached to an SIP that was not computed as an XIRR, treat it with caution, because a simpler average will usually misrepresent it.
What it does not change
XIRR is a more accurate way to measure a past return, not a way to predict a future one. It is still history, and past performance is not a promise. When you use our calculators, the rate you enter is a forward assumption of the same annualised kind — a figure you are choosing, not one anyone is offering. XIRR just makes sure that, looking backward, the timing of your money is counted honestly.
This is education, not advice
This article explains categories and mechanics. It does not name a scheme, does not rank anything and does not tell you what to buy. H2 Investment is an AMFI-registered mutual fund distributor (ARN-200996), not a SEBI-registered investment adviser. For a personal financial plan, talk to a SEBI-registered investment adviser. Tax treatment depends on your own circumstances and the rules change — confirm your position with a qualified tax adviser.