XIRR Calculator
XIRR calculator: find the annualized return of up to three cash flows made on different dates, solved by Newton's method.
Editorial review: Farrow (pseudonym; identity and professional credentials are not disclosed). This page is for educational purposes, not professional advice.
Your inputs
Results update as you type. Nothing you enter leaves your device.
Results
Example with the starting values
These results use the calculator's initial inputs. Change the values above to calculate your own estimate.
Inputs
- Cash flow 1 on day 0 (negative = invested)
- -10000 $
- Days after date 1
- 180 days
- Cash flow 2
- 2000 $
- Days after date 1
- 365 days
- Cash flow 3
- 11000 $
Results
- XIRR
- 33.12%
How does the XIRR Calculator work?
XIRR finds the single annual rate r that makes the present value of all cash flows (negative for money out, positive for money in) sum to zero: Σ CFᵢ / (1+r)^((dᵢ−d₀)/365) = 0.
Unlike a simple IRR, XIRR allows cash flows on any dates, which fits real investments and withdrawals. This calculator solves for r using Newton's method.
For example, investing $10,000, getting back $2,000 after 180 days and $11,000 after 365 days gives an XIRR of about 33.12% a year.
Frequently asked questions
What is XIRR?
The annualized return of a series of cash flows that happen on irregular, specific dates, as opposed to IRR which assumes even periods.
Is this an irr calculator for irregular cash flows?
Yes, that is exactly what XIRR is for: an annualized return calculator built to handle cash flows that don't arrive on a fixed schedule.
Why is my first cash flow negative?
It represents money invested (an outflow). Later inflows, like a sale or withdrawal, are entered as positive.
What if the calculator shows no result?
Newton's method can fail to converge for cash flows that never cross zero (all same sign). Check that you have at least one outflow and one inflow.
How is XIRR different from a simple annual return?
A simple return assumes one lump sum over one period; XIRR correctly weights multiple cash flows by exactly how many days apart they occurred.