XIRR Calculator
Calculate the annualized Extended Internal Rate of Return for irregularly spaced cash flows
📋 Cash Flow Inputs
💡 Instructions: The first row is typically the initial investment (negative = outflow). Subsequent rows represent dividends/contributions/withdrawals (positive = inflow, negative = outflow). Dates can be at any interval. XIRR iteratively computes the annualized return, matching Excel's XIRR function.
📌 Excel Reference: Excel formula
=XIRR(values, dates, guess). This tool uses the Newton-Raphson method. If convergence fails, check that cash flows have both positive and negative signs.