Use dated cash flows when transactions do not occur at equal periodic intervals.
Calculate with the XIRR Calculator
Enter the details below. Required values are validated before results are shown.
XIRR Calculator results
How to use the XIRR Calculator
- Choose the display currency and any calculation mode or frequency.
- Enter each required value using a consistent currency and time basis.
- Select Calculate or press Enter.
- Review the result explanation, assumptions, and any schedule before relying on the estimate.
Worked example
An initial outflow followed by irregular distributions can be compared on an Actual/365 annualized basis.
Understanding the results
The summary separates the most important output from supporting values. Currency selection changes formatting only; it does not convert exchange rates or alter a currency-independent formula.
Frequently asked questions
How is XIRR different from periodic IRR?
Rows are sorted by date for calculation but remain in entered order in the form. The bounded solver uses 1e-8 tolerance and 200 iterations. The result depends on the values and assumptions entered, so compare it with the applicable provider or official rule.
Can I use decimal values in the XIRR Calculator?
Yes. Decimal values are supported. Results are calculated at full JavaScript numeric precision and formatted for readability.
Are the XIRR Calculator results guaranteed?
No. The calculator provides an estimate based on the entered assumptions and is not financial, tax, investment, lending, payroll, or legal advice.