Using the XIRR Calculator
Enter one date and signed amount per line. Investments are negative and receipts are positive. Include the final portfolio value as a positive receipt on the valuation date for an investment you still hold.
Worked example
Use the example inputs below to reproduce this result. These are the form's starting values, not recommended targets. Changing your inputs updates your result above; this worked example stays fixed for comparison. Results are rounded for display.
Example inputs
- Cash flows: YYYY-MM-DD,amount
- 2023-01-01,-10000 2024-01-01,11000
Example result
- Annualized XIRR (%)
- 10
- Total invested
- 10,000
- Total received
- 11,000
- Net cash gain/loss
- 1,000
- Span (days)
- 365
Method and assumptions
Solves sum(cash flow / (1+r)^(days/365)) = 0 using actual UTC calendar days and a fixed 365-day year. Same-date flows are combined. Only conventional flows (investments followed by receipts) are accepted to avoid multiple-return ambiguity. Taxes/fees are included only if entered as cash flows.
Reference: support.microsoft.com — method and further reading
Separate contributions from growth
An ending balance can grow because you put more money in, because the assumed return is higher, or because the money has more time to compound. Those are different effects. Keep the contribution schedule consistent when comparing rates, and distinguish a mathematical projection from a return that is contractually guaranteed. Fees and taxes need their own assumptions.
Common question
How is XIRR different from a simple percentage return?
A simple return compares the total gain with the money invested. XIRR also accounts for when each cash flow occurred, annualizing the return on a fixed 365-day basis. It can differ from a fund’s published time-weighted return.