XIRR is the yearly return on money that goes in on different dates, such as SIP instalments.
A simple return treats all your money as if it went in on day one. XIRR counts how long each instalment was invested, which is why funds and apps show it for SIPs.
It is the one yearly rate at which every instalment, growing from its own date, adds up to today’s value. There is no simple formula: a spreadsheet finds the rate by trying values until one fits.
₹10,000 a month for 12 months is ₹1.2 lakh put in. If it is worth ₹1.3 lakh at the end of the year, the simple gain is 8.3%, but the XIRR is about 15.7%, because the average rupee was invested for only about half the year.
Good to know
- For a single amount invested once, XIRR and CAGR are the same number.
- XIRR is always a yearly rate. Over a few months it can look very large or very small, so read it with care.
- Withdrawals count too: money put in is entered as a minus figure, and money taken out and today’s value as plus figures.
Common questions
What is the difference between XIRR and CAGR?
CAGR fits one amount invested once. XIRR fits several payments on different dates, such as a SIP, top-ups or withdrawals.
How do I work out XIRR in Excel or Google Sheets?
List each payment as a minus number with its date. Add today’s value as a plus number with today’s date. Then use =XIRR(amounts, dates).
Why is my return different from the fund’s factsheet?
The factsheet shows the fund’s return for one amount held from one date to another. Your XIRR depends on when your own money went in.