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.
| Result | Value |
|---|---|
| Cash flows read | 8 |
| XIRR | 11.33% |
| Total paid in | 60.00 |
| Total received | 95.00 |
| Multiple (received / paid in) | 1.583x |
Runs in your browser: nothing you type is sent anywhere.
XIRR: find r such that Σ CFi / (1 + r)(di − d0) / 365 = 0
In Excel: =XIRR(B2:B9,A2:A9)
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.
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.
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.
Yes. It is an effective annual rate on a 365-day year, whatever the spacing of the flows.
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 →