XIRR Calculator
Calculate xirr from your own entered figures.
Loading calculator…
Currency: Amounts are calculated in the currency you select; this site does not convert between currencies and does not use live exchange rates.
What this tool does
Calculate xirr from your own entered figures. Day count is actual/365 from the first cash flow's date; flows must include at least one negative and one positive amount.
How to use the XIRR Calculator
- Enter or select dated cash flows (one per line: yyyy-mm-dd,amount).
- Read the calculated result; change any measurement to compare alternatives.
Formula
XIRR solves Σ CFi/(1+r)^((datei − date0)/365) = 0 for r, found by bisection between −99% and +1000%
- dated
- Dated cash flows (one per line: YYYY-MM-DD,amount)
Day count is actual/365 from the first cash flow's date; flows must include at least one negative and one positive amount.
Worked example
For xirr calculator, the following measurements illustrate the exact method: Dated cash flows (one per line: YYYY-MM-DD,amount): 2024-01-01,-1000 2025-01-01,600 2026-01-01,600.
Inputs
- Dated cash flows (one per line: YYYY-MM-DD,amount)2024-01-01,-1000 2025-01-01,600 2026-01-01,600
Result
- XIRR (annualised return)13.04%
- Net cash flow (undiscounted)$200.00
Results explained
- XIRR (annualised return)
- XIRR (annualised return) from the formula above. Day count is actual/365 from the first cash flow's date; flows must include at least one negative and one positive amount.
- Net cash flow (undiscounted)
- Net cash flow (undiscounted) from the formula above. Day count is actual/365 from the first cash flow's date; flows must include at least one negative and one positive amount.
Frequently asked questions
XIRR solves Σ CFi/(1+r)^((datei − date0)/365) = 0 for r, found by bisection between −99% and +1000%
Day count is actual/365 from the first cash flow's date; flows must include at least one negative and one positive amount.
No. All numbers are entered by you or come from the dated reference table shown on this page; calculations run locally.
This is an estimate, not financial, tax or legal advice. Verify the inputs and output with official sources and a qualified professional.
Check period consistency, currency, percentage inputs and the assumptions: Day count is actual/365 from the first cash flow's date; flows must include at least one negative and one positive amount.