XIRR Calculator

Calculate annualized return for investments with irregular cash flows using dated transactions.

Calculator

Enter one amount and date per row. Investments are normally negative; receipts are positive.

Results

XIRR
โ€”
Net cash flow
โ€”
Add at least two dated cash flows.

XIRR Calculator โ€” Irregular Cash Flows

XIRR is designed for situations where investment and withdrawal amounts occur on different dates. Each cash flow is paired with its date and the calculator estimates the annualized return.

Cash flow sign convention

For a typical investment, money paid into the investment is entered as a negative amount and money received back is entered as a positive amount.