Extended Internal Rate of Return (XIRR) Calculator
Calculate the annualized rate of return for a schedule of irregular cash flows (investments and returns on arbitrary dates). Supports custom currencies, presets, and interactive cash flow graphing.
Enter your cash flows on the left and click calculate.
Understanding XIRR (Extended Internal Rate of Return)
Unlike standard Internal Rate of Return (IRR) which assumes that cash flows occur at equal time intervals (monthly, yearly), XIRR accommodates transactions occurring on completely arbitrary dates. It is the industry standard for calculating annualized rates of return on mutual fund SIP portfolios, stock trading schedules, and personal portfolios containing random capital additions and withdrawals.
The Mathematical Formula
The XIRR solver calculates the annualized interest rate r for which the Net Present Value (NPV) of all cash flows equals zero:
Where:
- Ci = The transaction amount of the i-th cash flow (Negative for outflows/investments, Positive for inflows/returns).
- di = The date of the i-th cash flow.
- d1 = The date of the first cash flow (the starting reference point).
- r = The annualized Extended Internal Rate of Return (XIRR).
Worked Example
Scenario: Simple SIP Return
| Date | Transaction | Amount ($) | Description |
|---|---|---|---|
| 2025-01-01 | Outflow (-) | -10,000 | Initial Purchase of Mutual Fund units. |
| 2025-06-01 | Outflow (-) | -5,000 | Secondary SIP addition. |
| 2026-01-01 | Inflow (+) | +18,000 | Selling all units at final portfolio evaluation. |
Using our numerical engine, the equation resolves to (r = 23.36%). This means your irregular investments grew at a compounded equivalent rate of **23.36% per annum**.