← Finance

XIRR Calculator (Irregular Cash Flows)

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

Other languages ja | en | es

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.

Related calculators