Free calculators

XIRR calculator

The internal rate of return of cash flows on irregular dates, computed as Excel’s XIRR does: paste one date and amount per line. Free, in the browser, nothing is sent anywhere.

XIRR is the annual rate at which the present value of dated cash flows is zero, each flow discounted by its days from the first date over 365. With the defaults below, an investor’s calls, distributions and remaining NAV in a private equity fund give an XIRR of 11.33 per cent; summing the same flows by calendar year and running IRR gives 12.43 per cent, because it moves cash to the wrong dates.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
Cash flows read8
XIRR11.33%
Total paid in60.00
Total received95.00
Multiple (received / paid in)1.583x

Runs in your browser: nothing you type is sent anywhere.

Using this for a real deal?

The formula

XIRR: find r such that Σ CFi / (1 + r)(di − d0) / 365 = 0

In Excel: =XIRR(B2:B9,A2:A9)

How it works

Enter money paid in as negative and money received as positive, with at least one of each. For an interim return on a fund, treat the latest NAV as a final inflow on the valuation date. The calculator solves by bisection between −99 and 1,000 per cent, so it returns one answer even where flows change sign several times; with several sign changes there can be more than one rate that solves the equation, as with Excel.

IRR on periodic rows assumes every flow is exactly one period apart. For fund cash flows on real dates, use XIRR; the free Excel template shows XIRR, IRR and NPV side by side.

Go further with the worked example, step by step, the free Excel template and the companion files for The Private Equity Fund Controller Playbook.

Embed this calculator

Free to embed on your website, blog or intranet, with no sign-up and no tracking. Copy the code below and paste it into any HTML block; the calculator resizes itself to fit.

Preview the embedded version

Questions people ask

What is the difference between IRR and XIRR?

IRR assumes every cash flow is exactly one period apart; XIRR uses the actual dates. On the default fund flows, XIRR gives 11.33 per cent and IRR on calendar-year sums gives 12.43 per cent.

How do I enter cash flows?

One line per flow: a date as YYYY-MM-DD, a comma, then the amount, negative for money paid in and positive for money received.

Is XIRR an annual rate?

Yes. It is an effective annual rate on a 365-day year, whatever the spacing of the flows.

The book behind this calculator

This calculator comes from The Private Equity Fund Controller Playbook by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.

Get the book on Amazon → DRM-free PDF edition, $19.99

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

All free calculators → · Free Excel templates →