XIRR Calculator

Annualized internal rate of return for dated, irregular cash flows (Actual/365).

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

Educational estimate only — not investment, lending, or financial advice. Confirm figures with statements or a qualified professional before you act.

About this tool

Enter each cash flow with its date and get an annualised return that reflects the real gaps between them. It matches the spreadsheet XIRR approach and suits irregular investments and withdrawals.

How to use

1
Step 1
Add each cash flow with its date. Money you pay in is negative.
2
Step 2
Leave the starting guess at 10% unless the result looks wrong.
3
Step 3
Press Calculate to see the annualised rate.

How it works

XIRR discounts each flow by the number of days since the first date divided by 365, then finds the annual rate that makes the total zero. Because it uses an actual-day count over 365, a one-year gap in a leap year is 366 days and slightly lowers the rate. At least one flow must be negative and one positive.

find r such that Σ CFᵢ ÷ (1 + r)^((dateᵢ − date₀) ÷ 365) = 0

Worked example

A one-year investment spanning a leap day

Input
−10,000 on 2024-01-01; +11,000 on 2025-01-01
Output
XIRR 9.9714%
Walkthrough
11,000 ÷ 10,000 is a 10% gain, but the gap is 366 days, so the annualised rate is 1.1^(365/366) − 1 = 9.9714%. The built-in sample of five flows through 2024 gives 66.4886%, because the money comes back within a single year.

Limitations

  • Needs a negative and a positive flow.
  • Uses an actual/365 day count.
  • Several sign changes can give more than one rate; the tool warns when this happens.

Questions

What is the difference between IRR and XIRR?
IRR assumes equal gaps between flows. XIRR uses the actual dates, so it suits irregular deposits and withdrawals.
Why isn't a 10% gain exactly 10%?
The day count: 366 days across a leap year gives 9.9714% annualised, since the money earned its 10% a little more slowly.
How do I enter dates?
Add each amount together with its date; the first date is the starting point for discounting.
Can XIRR be used for a portfolio?
Yes, list every contribution as negative, every withdrawal as positive, and the current value as a final positive flow on today's date.

Features

  • Dated cash flows
  • Actual/365 day count
  • Runs in your browser

Guides

Related resources

Guides and videos from around the web—opens on YouTube or the publisher’s site.

  • Calculating simple and compound interest

    Khan Academy

    Worked examples to compare with calculator output.

    Watch on YouTube

  • Amortization

    Khan Academy

    Principal vs interest breakdown for schedules.

    Watch on YouTube

More Finance tools

See all ›
IRR Calculator
Internal rate of return that zeroes the NPV of a cash-flow series.
NPV Calculator
Net present value of a cash-flow series at a chosen discount rate.
CAGR Calculator
Compound annual growth rate between a beginning and ending value.