← Finance

XIRR Calculator (Irregular Cash Flows)

Calculate annual IRR from dated cash flows and check convergence status.

Other languages 日本語 | English | Español | Français

How To Use

  1. Enter dated cash flows (CSV/TSV paste supported).
  2. Adjust guess and day count basis if needed.
  3. Review XIRR value, status, and warnings.

Sign convention: investment outflow is negative, inflow is positive.

Inputs

Cash-flow rows

Bulk paste (CSV/TSV)

Result

Discounted cash-flow table (reference)

Date Amount Discounted amount Note

FAQ

What if all cash flows are same sign?

IRR is undefined. You need at least one negative and one positive cash flow.

How is multiple-solution risk detected?

The calculator warns when cash-flow signs change two or more times.

What if results differ from spreadsheets?

Check day count basis, date parsing, sign convention, and initial guess.

What should I do first on this page?

Start with the minimum required inputs or the first action shown near the primary button. Keep optional settings at defaults for a baseline run, then change one setting at a time so you can explain what caused each output change.

Why does this page differ from another tool?

Different pages often use different defaults, units, rounding rules, or assumptions. Align those settings before comparing outputs. If differences remain, compare each intermediate step rather than only the final number.