If you invest through SIPs, your mutual fund app shows you a return number — but is it the right one? CAGR and "absolute return" can both be misleading when your money went in on different dates and in different amounts. XIRR is the one metric built specifically for this. Here's exactly how it works.
XIRR (Extended Internal Rate of Return) is a method for calculating the annualised return on an investment that has multiple cashflows happening on different dates, in different amounts. This is exactly the situation every SIP investor is in — you don't put in one lumpsum on one day; you invest a little every month, sometimes with top-ups, sometimes with a partial withdrawal in between.
A simple "total gain ÷ total invested" calculation ignores time entirely. ₹10,000 invested 5 years ago and ₹10,000 invested 5 days ago are treated identically — which is clearly wrong, since the first amount has had years to compound and the second has had almost none. XIRR fixes this by discounting every cashflow back to a common point in time based on exactly how many days it has been invested.
CAGR (Compound Annual Growth Rate) assumes a single investment made on one date and withdrawn on another. It is the right tool for a lumpsum FD or a one-time mutual fund purchase — but it cannot meaningfully describe a SIP, because a SIP has no single "investment date" to anchor the calculation to.
| Factor | CAGR | XIRR |
|---|---|---|
| Works for | Single lumpsum, one entry & one exit | Multiple cashflows on different dates |
| SIP-friendly | No | Yes |
| Accounts for top-ups / withdrawals | No | Yes |
| Calculation method | Direct algebraic formula | Iterative (Newton-Raphson) |
| Result for a pure lumpsum | Same as XIRR | Same as CAGR |
Quick rule of thumb: If you ever made more than one investment on more than one date in the same fund, CAGR cannot accurately describe your return — only XIRR can.
XIRR finds the single discount rate r that makes the Net Present Value (NPV) of every cashflow — investments as negative, redemptions as positive — equal to exactly zero:
Here, CFi is each individual cashflow and di is the number of days between that cashflow's date and the first cashflow date. There is no direct algebraic way to solve for r — it has to be found through trial and error using an iterative numerical method, typically Newton-Raphson, which is exactly what Excel's XIRR function and ToolLoom's calculator do under the hood.
You don't need to do this by hand. The formula matters for understanding what the number represents — actually solving it requires software. ToolLoom's XIRR calculator runs the same Newton-Raphson method Excel uses, so the results will match exactly.
Here's a realistic example with three cashflows — exactly the kind of mixed-date scenario where CAGR breaks down and XIRR is needed.
₹50,000 invested 2 years ago. ₹30,000 invested 1 year ago. Current value today: ₹1,00,000. Investments are negative cashflows; the current value is a positive cashflow.
−50,000 − 30,000 ÷ (1+r)¹ + 1,00,000 ÷ (1+r)² = 0 — solving for the rate r that balances this equation.
Working through the iteration gives r ≈ 14.57%. Total invested was ₹80,000, current value ₹1,00,000 — a gain of ₹20,000, achieved at an annualised XIRR of roughly 14.6%.
| Date | Cashflow | Type |
|---|---|---|
| 2 years ago | −₹50,000 | Investment (outflow) |
| 1 year ago | −₹30,000 | Investment (outflow) |
| Today | +₹1,00,000 | Current value (inflow) |
Notice what XIRR captures here: the ₹50,000 had two full years to compound while the ₹30,000 had only one — XIRR weighs these correctly, while a naive "total gain ÷ total invested" calculation (25%, not annualised) would badly overstate the real annual return.
If you'd rather build your own tracking sheet, Excel and Google Sheets both have a native XIRR function:
Common Excel error: forgetting to make investment amounts negative. If all your cashflows are positive, Excel's XIRR function will return a #NUM! error or a nonsensical result.
XIRR is only meaningful when compared against a relevant benchmark and time horizon. A short window — under a year — can show an alarmingly high or low XIRR purely due to market timing, not the quality of the investment.
| Fund Category | Typical 5+ Year XIRR | Risk Level |
|---|---|---|
| Large-cap / Index funds | 10% – 12% | Lower |
| Diversified / Flexi-cap equity | 12% – 15% | Moderate |
| Mid-cap / Small-cap equity | 14% – 18% | Higher |
| Debt funds | 6% – 8% | Lower |
Never judge XIRR over short windows. A fund showing 25% XIRR over 8 months or −10% over 6 months tells you almost nothing about its long-term quality — both are dominated by short-term market noise, not the fund's actual performance.
| Mistake | Why It's Wrong |
|---|---|
| Comparing XIRR directly to FD rates | Equity XIRR carries market risk that a fixed deposit does not — they aren't comparable on rate alone. |
| Using a CAGR formula for SIP returns | CAGR assumes one entry date; applied to a SIP it produces a meaningless, often inflated number. |
| Getting cashflow signs wrong | Investments must be negative and the final value positive — flipping these gives a nonsensical or error result. |
| Judging XIRR over less than a year | Annualising a few months of returns massively exaggerates both gains and losses. |
| Leaving out a top-up or withdrawal | Every cashflow must be included — missing even one date/amount skews the entire result. |