XIRR calculator
Work out the yearly return on money put in and taken out on different dates, such as a SIP or top-ups along the way.
What XIRR is
XIRR is a yearly rate of return that allows for when each amount went in or came out. Money invested five years ago has had longer to grow than money invested last month, and XIRR gives each its due. It is the usual way to state the return on a SIP.
How to use it
Choose Regular for a fixed amount at a fixed interval, such as a monthly SIP. Choose Your own dates to enter each amount separately, including money you took out. Then enter what the investment was worth on a given date.
Common questions
How is XIRR different from CAGR?
CAGR suits a single amount invested once. XIRR works with many amounts on different dates; for a single amount, the two are the same.
Why can XIRR look very high or very low?
Over short periods, small changes in value are stretched into a yearly rate: a 5% gain in three months works out to over 21% a year. XIRR means more over longer periods.
Is it the same as a spreadsheet's XIRR?
Yes. It counts the days between dates over a 365-day year, as the XIRR function in Excel and Google Sheets does, so the same figures give the same answer.
What should I enter for money taken out?
Add a row for each withdrawal and mark it Taken out. Dividends paid out to you count as money taken out too.
Does a good past return mean the fund will do well next?
No. Past performance may or may not be sustained in future. What a fund earned in one period says little about the next.