Work out the true annualised return when money went in and out on different dates. Matches Excel XIRR exactly. Built for SIPs, top-ups, and partial redemptions.
When should I use XIRR instead of CAGR?
Whenever the money did not all go in on the same day. A SIP, a top-up, a partial redemption, or a dividend payout all break CAGR. With exactly one investment and one exit, XIRR and CAGR give the identical answer.
Why is my XIRR higher than my absolute return?
Because absolute return ignores time. Making 50% over two years and making 50% over ten years are very different, and only one of them is good. XIRR converts the gain into a per-year rate so you can compare it against an FD or an index.
How do I enter my SIP?
One row per instalment, each as a negative amount on the date it was debited, then one final positive row for the current value or the redemption amount on that date. Your fund house statement or CAS lists every transaction with its date.
Does this match Excel?
Yes. It uses the same 365 day year Excel does, so it returns Excel’s published example of 37.34% on the exact flows Microsoft documents. Google Sheets XIRR agrees too.
What is a good XIRR for a mutual fund?
For an equity fund held over ten years or more, 11% to 14% is a solid long-term outcome. Compare it against a broad index over the same dates, not against a friend’s number from a different period. Short-term XIRR on a young SIP swings wildly and means very little.
Why does a short SIP show a strange XIRR?
Annualising a few months exaggerates everything. A 5% gain in two months annualises to over 30%, and a 5% fall annualises to a similar loss. Treat any XIRR over a period under a year as noise.
Can XIRR be negative?
Yes, and it should be when you lost money. This calculator handles losses right down to a near total wipeout, where the rate approaches but never reaches -100%.