Understanding xirr calculator
Record investments as negative cash flows and money received as positive cash flows. Include the current portfolio value as a positive terminal flow on its valuation date when measuring an ongoing investment. Dates matter because the same gain can imply different annualized returns over different holding periods.
Formula and calculation method
XIRR solves sum[cash flow / (1+r)^((date−first date)/365)] = 0. Dates use an actual-day/365 convention.
Dated cash-flow annualization with a fixed 365-day denominator, including leap-year dates. Multiple sign changes may produce multiple roots; the first bracketed root is reported, not a guarantee of uniqueness. Supported search range is −99.9% to 10,000%.
How to use xirr calculator
- Set Cash flows (investments negative; receipts positive). The example below uses -10000, 11000.
- Set Corresponding dates (YYYY-MM-DD). The example below uses 2025-01-01, 2026-01-01.
- Select Calculate to update the result. Reset restores the illustrated inputs. Copy, print or download your own result if you need a record.
Worked example
Example inputs
- Cash flows (investments negative; receipts positive)
- -10000, 11000
- Corresponding dates (YYYY-MM-DD)
- 2025-01-01, 2026-01-01
- Annualized XIRR (%)
- 10
- Net cash flow
- 1000
- Cash-flow count
- 2
Factors affecting your result
Dated cash-flow annualization with a fixed 365-day denominator, including leap-year dates. Multiple sign changes may produce multiple roots; the first bracketed root is reported, not a guarantee of uniqueness. Supported search range is −99.9% to 10,000%.
Changing cash flows (investments negative; receipts positive) changes the scenario being evaluated. Adjust one input at a time when comparing results, keep a copy of the assumptions, and compare values using the same unit and period. A precise arithmetic result does not make an uncertain assumption precise.
Frequently asked questions
How does the xirr calculator work?
XIRR solves sum[cash flow / (1+r)^((date−first date)/365)] = 0. Dates use an actual-day/365 convention.
What inputs does XIRR Calculator need?
Enter cash flows (investments negative; receipts positive), corresponding dates (yyyy-mm-dd). Choose values that correspond to the same situation and measurement convention.
How should I interpret the xirr calculator result?
Dated cash-flow annualization with a fixed 365-day denominator, including leap-year dates. Multiple sign changes may produce multiple roots; the first bracketed root is reported, not a guarantee of uniqueness. Supported search range is −99.9% to 10,000%.
Are my xirr calculator inputs uploaded?
No. The calculation runs in this browser. Favorites, recent tool names, theme and formatting preferences may be saved locally, but calculation inputs are not sent to a calculation server or stored by this website. Shared links do not include entered values.
Maintained by Calculators.buzz Editorial Team. Implementation date: . No professional credentials or clinical review are claimed. Read our methodology policy.