Calculate Extended Internal Rate of Return for irregular cash flows.
Enter cash flows with their corresponding dates. Negative values represent outflows (investments), positive values represent inflows (returns).
XIRR (Annual Rate)
Total Investment
Total Returns
| Date | Cash Flow | Type |
|---|---|---|
XIRR (Extended Internal Rate of Return) calculates the annualized return rate for irregular cash flows occurring at different time periods. Unlike IRR, XIRR can handle cash flows that don't occur at regular intervals.
XIRR uses the Newton-Raphson method to find the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero:
Where CFᵢ is the cash flow, r is the XIRR rate, and (dᵢ - d₀) is days between dates.
Save your calculations and get detailed breakdowns