XIRR Calculator

Compute XIRR from dated cash flows. Negative amounts are investments; positive amounts are returns.

The solver uses Newton-Raphson on NPV = 0 with a 365-day year fraction, the same day-count Excel’s XIRR uses. Add or remove rows as needed. Everything stays in this tab.

Date Amount

Negative = money out (invest). Positive = money in (return). At least one of each sign is required.

—