XIRR calculator
XIRR is the yearly return on money that went in and came out on different days: SIP instalments, top-ups, redemptions. It is the return a mutual fund statement quotes.
The yearly return on investments made and withdrawn on different dates
Enter what your investment is worth today as money received on today’s date.
Add a monthly SIP in one go
- Invested
- ₹60,000
- Received and value today
- ₹66,500
- Gain
- ₹6,500
Your money in and out, by date
- Invested
- Received and value today
How it is worked out
XIRR is the yearly rate at which every amount, brought to the first date at that rate over the days between, adds to nothing. Money invested counts as negative, money received and today's value as positive; a year is 365 days.
There is no formula to solve directly, so the rate is found by narrowing in on it until the amounts balance to the paisa.
In Excel or Google Sheets: list each amount in one column, money invested as negative and today's value as positive, with its date beside it, then =XIRR(amounts, dates).
About XIRR calculator
XIRR is the yearly rate of return on money put in and taken out on different dates. The calculator finds the single annual rate at which dated cash flows balance. It is the figure a mutual fund statement quotes for SIPs.
What XIRR measures
XIRR means extended internal rate of return. A plain annual return assumes one amount invested on one day. An SIP, a top-up or a part withdrawal breaks that, because each rupee stays invested for a different time. XIRR weighs every flow by how long it was invested.
How the calculator works
Money invested counts as negative and money received counts as positive; today's value is entered as a received line dated today. Each amount is moved to the first date at a trial rate, using the days between the dates divided by 365, and the rate is the one that makes the total zero. In symbols: the sum of each amount divided by (1 + rate) to the power of days since the first date over 365 equals zero.
No direct formula exists for this, so the page narrows in on the rate until the amounts balance to the paisa. The page opens with 13 lines and more can be added; a monthly SIP helper fills in a run of instalments from an amount, a first date and a number of months.
A worked example
Take ₹1,00,000 invested on 1 Jan 2025 and ₹1,21,000 received on 1 Jan 2027. The gap is 730 days, which is two years of 365 days. The rate r solves 1,00,000 = 1,21,000 divided by (1 + r) to the power of 2, so (1 + r) squared is 1.21 and r is 10%. With a single investment and a single receipt, XIRR equals the compound annual growth rate (CAGR). They differ with several flows.
XIRR in Excel and Google Sheets
The spreadsheet function is XIRR(values, dates, guess). Values need at least one negative and one positive amount, dates are real dates, and the first date is the start. The guess is optional and defaults to 10%. It uses the same 365-day year as this page.
What XIRR leaves out
XIRR assumes every flow earns the same rate for the whole period, so it summarises the path of the money and does not predict it. Taxes, exit loads and any amount not entered are not in the result. A short period gives an extrapolated yearly figure that can look very large or small.