How To Use
- Enter dated cash flows (CSV/TSV paste supported).
- Adjust guess and day count basis if needed.
- Review XIRR value, status, and warnings.
Sign convention: investment outflow is negative, inflow is positive.
Inputs
Result
Worked example: five irregular cash flows
Use this sample as a initial render check before the solver status and discounted cash-flow table update. With the default ACT/365 basis, the annualized XIRR is about 8.00%.
| Date | Amount | Note |
|---|---|---|
| 2020-01-01 | -10,000 | Initial investment |
| 2020-07-01 | 2,750 | Cash flow 1 |
| 2021-01-01 | 2,750 | Cash flow 2 |
| 2021-07-01 | 2,750 | Cash flow 3 |
| 2022-01-01 | 2,750 | Cash flow 4 |
After you calculate, compare the displayed XIRR, convergence message, and discounted cash-flow table against this reference pattern.
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 enter first for XIRR?
Enter dated cash flows with the correct sign convention first. Include the initial investment and final value or redemption cash flow before interpreting the annualized return.
Why can XIRR results differ from nearby tools?
Differences usually come from cash-flow signs, dates, initial guess, and terminal value. Match those assumptions before comparing this result with another CalcBE page, spreadsheet, or external tool.