Unlike CAGR, which needs just a start and end value, XIRR handles real-world investing where you add or withdraw money on different, irregular dates. This calculator lets you enter multiple dated cash flows and computes the single annualised rate that reconciles them.
How to Use This Calculator
- Add each cash flow as a date and amount (investments as negative, withdrawals/maturity value as positive).
- Add as many rows as needed for your actual transaction history.
- Click Calculate XIRR to see the annualised return.
How the Calculation Works
XIRR solves for the rate r such that: Σ [CFᵢ / (1 + r)^(dᵢ / 365)] = 0, where CFᵢ is each cash flow and dᵢ is the number of days from the first cash flow date. This is solved iteratively (e.g. Newton-Raphson) since there is no direct algebraic formula.
Worked Example
Enter your actual investment and withdrawal dates and amounts in the calculator above — because XIRR depends on the specific dates and amounts you provide, there is no single representative example.
Who Should Use This
Investors who have made multiple SIP instalments, top-ups, partial withdrawals, or lumpsum additions at different times and want a true annualised return figure that accounts for the timing of each cash flow.
Important Considerations
XIRR requires at least one negative (investment) and one positive (withdrawal/current value) cash flow to solve correctly. Extremely irregular or sparse cash flow patterns can occasionally produce results that are mathematically valid but hard to interpret intuitively.
Common Mistakes
Forgetting to include the current market value as a final "positive" cash flow (as if withdrawing today) is a common error that makes the XIRR calculation incomplete.
References
See also the CAGR Calculator for a simpler start/end value comparison.