XIRR calculator: Find your annual return with deposits and withdrawals
When you invest several times along the way, the difference between the starting amount and the final amount does not tell the whole story. XIRR also takes the dates of the amounts into account and calculates an annual money-weighted return.
Worked example
- Payment 1: Date 2024-01-01 · Amount -110.00 GBP
- Payment 2: Date 2024-07-01 · Amount -110.00 GBP
- Payment 3: Date 2025-01-01 · Amount 250.00 GBP
Annual money-weighted return (XIRR)
18.35 %
Actual days divided by 365. XIRR is not the same as a fund's time-weighted return.
Enter the cash flows from your perspective
Money you put into the investment is entered as negative amounts. Money you receive is entered as positive. The final value must be included as a positive cash flow on the date you value the investment.
Dividends are treated according to whether they are paid out or stay in the investment. They must not both be counted as cash received and at the same time be included extra in the final value. Fees must be treated consistently throughout the calculation.
Guide to a correct XIRR calculation
Use the actual dates
A large deposit just before a price rise affects your personal return differently from a deposit after the rise. That is exactly one of the differences XIRR can describe.
Example with a one-year investment
If you deposit 10,000 and receive 11,000 exactly 365 days later, the annual return is 10 percent in this day-count convention. More amounts and other time intervals require the full calculation.
XIRR is not the same as a fund's time-weighted return. It describes the return on your dated cash flows. Some sequences have no unique solution, and in that case the calculator must explain the problem. If you only have a starting value and a final value without ongoing deposits, the CAGR calculator can be a simpler way in.