XIRR Calculator
Key takeaways
- 3 dated flows span 517 days: ₹2.00 L paid in and ₹2.30 L received back.
- The 12.68% XIRR is the annual rate at which every flow, discounted by its own date, sums to zero.
- Ignoring the dates, the same amounts are an absolute 15% over 1.4 years; XIRR differs because it weighs each flow by how long that money was actually invested.
Cash flows over time
The chart updates as you edit the table above.
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 first, then a bracketed search if that does not settle on a rate that actually balances the flows. When no rate does (every flow on one day, say), the page says there is no solution rather than showing a number.
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.
Disclaimer: This calculator is for information and education only. It is not investment advice and not a recommendation to buy, sell or hold any investment. Where a rate of return, inflation or growth is an input, it is an assumption: actual returns vary and are not guaranteed, and past performance may or may not be sustained in future. It does not take your personal circumstances into account. Every figure is computed solely by applying the formula and assumptions stated above to the inputs you entered.