XIRR Calculator (Returns on Irregular Cashflows)
Calculate the annualised XIRR for investments with cashflows on different dates — ideal for SIPs, lumpsums and partial withdrawals.
Enter one cashflow per line as date, amount. Use a negative amount for money invested and positive for money received.
What Is XIRR?
XIRR stands for Extended Internal Rate of Return. It is the annualised return on a series of cashflows that happen on different dates and in different amounts. Indian investors rely on XIRR to judge real returns from mutual fund SIPs, lumpsum investments, partial withdrawals and any mix of these, because the money moves in and out at irregular times.
Unlike a simple return, XIRR accounts for exactly when each rupee was invested or received. Money invested earlier has more time to grow, so timing changes the true return. XIRR captures this by giving you a single annual percentage that reflects both the size and the date of every cashflow.
How XIRR Works
XIRR is the discount rate that makes the net present value of all dated cashflows equal to zero. There is no neat closed formula, so the calculator solves it iteratively using the Newton-Raphson method until the value converges.
- Negative amounts are money you invest, treated as outflows
- Positive amounts are money you receive, treated as inflows
- Each cashflow carries its own date, and the gap between dates drives the result
You enter each cashflow with its amount and date, mark investments as negative and receipts as positive, and the tool returns the annualised XIRR as a percentage.
Worked Example
Suppose you invest ₹1,00,000 on 1 January 2023 and another ₹50,000 on 1 January 2024, both as outflows. On 30 June 2025 you redeem the whole holding and receive ₹1,80,000 as an inflow. Entering these three dated cashflows, the calculator finds the rate that makes their net present value zero. The XIRR comes out to about 8.76 percent per year. This single figure fairly reflects that the two investments were made at different times.
XIRR Versus CAGR
CAGR works well only for a single investment with one start and one end value. The moment you have multiple investments, top-ups or withdrawals on different dates, CAGR cannot represent them correctly. XIRR is built exactly for this situation. A monthly SIP, for example, is a fresh investment every month, so its true return can only be measured with XIRR. Use CAGR for a one-shot lumpsum, and reach for XIRR whenever cashflows are multiple or irregular.
Frequently Asked Questions
CAGR measures the growth of a single investment between one start and one end date. XIRR handles many cashflows on different dates, which makes it the right choice for SIPs, top-ups and withdrawals.
By convention, money you invest is an outflow and is entered as a negative number, while money you receive is an inflow and is positive. This sign rule lets the calculation balance to a net present value of zero.
Yes. XIRR is always expressed as an annualised percentage, so you can compare it directly with fixed deposit rates or a CAGR figure regardless of how long the investment ran.
Absolutely. A SIP is a separate investment every month on a different date, so XIRR is the standard and correct measure of its return.
It is found iteratively. The calculator searches for the discount rate that makes the net present value of all dated cashflows zero, using the Newton-Raphson method to converge on the answer.
Yes, strongly. Money invested earlier has more time to compound, so changing dates changes the XIRR even if the amounts stay the same.