Tools
XIRR
The result is a learning example from the dates and amounts you type.
The year is the actual number of days between your dates, divided by 365. If that span includes February 29, the rate shifts slightly.
YYYY-MM-DD
Date of the first cash flow. An investment is a negative amount.
Example: 2025-01-01
$
Negative for money you pay in. Positive for money you receive.
Example: -$10,000 Valid range -1000000000000 to 1000000000000.
YYYY-MM-DD
Date of the second cash flow.
Example: 2026-01-01
$
Negative for money you pay in. Positive for money you receive.
Example: $11,000 Valid range -1000000000000 to 1000000000000.
YYYY-MM-DD
Leave blank, with a blank amount, to skip this flow.
Example:
$
Leave blank when this flow is unused.
Example: Valid range -1000000000000 to 1000000000000.
YYYY-MM-DD
Leave blank, with a blank amount, to skip this flow.
Example:
$
Leave blank when this flow is unused.
Example: Valid range -1000000000000 to 1000000000000.
Annual rate
10%
The year is the actual number of days between your dates, divided by 365. If that span includes February 29, the rate shifts slightly.
Flows used
2
Show numerical table
| Measure | Result |
|---|---|
| Annual rate | 10% |
| Flows used | 2 |
Theory and worked example
Teaching case: −$10,000 on 2025-01-01 and $11,000 on 2026-01-01 covers 365 days, so the yearly rate is 10%. That rate comes only from those two cash flows.
