XIRR Calculator for Dated Cash Flows
Calculate a return when payment dates are irregular.
Calculate a return per cash-flow period, then see its annual equivalent at your selected frequency. Use XIRR for actual dates, and review any warning about absent or multiple roots.
IRR finds a return per equal cash-flow interval. The calculator also offers an annuity mode for a purchase followed by equal end-of-period receipts, keeping the periodic rate separate from its annual compound equivalent.
General mode uses successive equal intervals; annuity mode places the initial purchase first and each receipt at a period end.
Discount each later flow back to time zero and find the rate that makes the sum balance. Mixed-sign patterns can produce multiple roots, which are disclosed instead of reduced to one unexplained number.
Raise one plus the periodic rate to the number of periods per year, then subtract one. Multiplying the rate by frequency would give a different convention.
Sample inputs demonstrate the method. They are not a forecast or product offer.
The first example is an initial outflow of 1,000 followed by 1,100 one period later. The balancing periodic rate is 10%; with one period per year, the annual equivalent is also 10%.
Sample inputs demonstrate the method. They are not a forecast or product offer.
The periodic IRR is only annual when one period is a year. A monthly cash-flow list requires a frequency of twelve for its annual effective equivalent.
Actual payment dates that do not fit equal intervals belong in XIRR. IRR does not read calendar gaps from the number of rows or from descriptive labels.
Find the internal return per equal cash-flow period, and annualise it only with a declared frequency.
Up to 60 individual flows or 1,200 equal end-of-period annuity receipts; per-period search range −99.9999% to 99,999,900%. Use XIRR for actual dates.
Read our calculation and testing approach.