XIRR Calculator
About the XIRR Calculator
XIRR (Extended Internal Rate of Return) is the true annualised return on a series of cash flows that happen on irregular dates — exactly the case with SIPs, top-ups and partial withdrawals. Unlike CAGR, it accounts for both the amount and the timing of every cash flow.
Enter each investment as a negative amount and each redemption (or the current value) as a positive amount, with its date, and the calculator solves for the annualised rate that makes them balance.
Frequently asked questions
What is XIRR and how is it calculated?
XIRR is the single annual rate r at which the present value of all your dated cash flows nets to zero: Σ cashflow ÷ (1 + r)^(days ÷ 365) = 0. There is no closed formula, so it is solved iteratively (Newton-Raphson).
When should I use XIRR instead of CAGR?
Use XIRR whenever money goes in or out on different dates — SIPs, extra purchases, partial redemptions. CAGR only works for a single lumpsum with one start and one end value; XIRR handles the irregular timing CAGR cannot.
How do I enter cash flows for XIRR?
Money you invest is a negative (outflow); money you receive or your current portfolio value is a positive (inflow). Each needs its actual date. You need at least one negative and one positive to get a result.
What is a good XIRR?
It depends on the asset and the period — there is no fixed benchmark. Compare your XIRR against a relevant index or alternative over the same dates, and remember that past returns do not predict future ones.
Why is my XIRR different from the absolute return?
Because XIRR annualises and weights by timing. Money invested recently has had little time to grow, while early investments compounded longer — XIRR reflects that, so it usually differs from a simple total-return percentage.