XIRR Calculator · Calculation guide

Measure an annual return using the actual dates of payments and receipts.

Calculation guide

For people exploring investment contributions, withdrawals or returns.

Returns are effective annual assumptions. Monthly growth uses (1+r)^(1/12), multiplied by the annual fee factor's monthly equivalent when a separate fee is entered. Start/end timing determines whether the contribution precedes growth. Annual contribution increases apply after each 12 payments. Inflation changes purchasing power, not the nominal account balance. No return is guaranteed. Negative cash flows represent money paid out; positive flows represent money received. Include the final valuation as a positive flow if relevant. IRR uses equal periods; XIRR discounts actual calendar-day differences using ACT/365F. Nonconventional sign-change patterns are reported as potentially ambiguous instead of silently choosing one root. NPV uses the entered discount rate.

Σ CF_t/(1+r)^((date_t−date₀)/365) = 0

Inputs

Date

Date on which this payment or receipt occurs, entered as YYYY-MM-DD.

Amount

Amount for this calculation or dated cash flow. Where negative amounts are allowed, negative means paid out and positive means received.

Worked example

Cash flows

DateAmount
2026-01-01-100,000
2027-01-01110,000

Formula:

Σ CF_t/(1+r)^((date_t−date₀)/365) = 0

Annualized return = 9.99999999999424%

ResultValue
Annualized return10%
Net cash flow10,000

Interpreting the result

Equivalent full-year return after compounding. It differs from a nominal annual rate.

Sum of signed receipts and payments without discounting.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Date (row 1)2026-01-012026-01-02Annualized return10%10.028806%
Amount (row 1)-100,000-90,000Annualized return10%22.222222%
XIRR Calculator →