Eight skills, in the order a fund controller uses them, each with the one number that shows you have it.
Fund finance is learned by doing the calculations, in the order the job asks for them. Start with the LPA, then capital calls and equalization, fees and offsets, the waterfall, the quarterly close, performance, fund financing and finally LP reporting and the audit. Each skill below comes with a test on the same fictional fund, so you can tell when you have it.
The case comes from The Private Equity Fund Controller Playbook and the Private Fund Finance & Controllership course by Julian R. Sterling.Get the DRM-free PDF, $19.99 →or see it on Amazon
Commitments, closings, the fee clause, the waterfall, borrowing limits. Test: split 500.0 of commitments into the 490.0 that pay fees and the 10.0 GP commitment that does not.
Allocate a call by purpose and partner; equalize a late closing. Test: 6.784 of capital and 0.148 of interest for a 70.0 second-closing commitment.
Switch the basis at the end of the investment period and apply offsets. Test: 2.450 a quarter falling to 1.011 before offsets.
Capital, pref, catch-up, split, European and American; accrued carry; clawback. Test: a 9.69 American clawback.
A course built on one private equity fund, from capital calls and equalization to the waterfall, the NAV, IRR and PME, subscription lines and ILPA reporting, with Excel exercises, a 160-question quiz and the Private Equity Fund Model, Pro Edition included ($199).
Roll the NAV, tie capital accounts to it. Test: closing NAV of 288.07 by both methods.
Net and gross IRR, DPI, RVPI, TVPI, PME. Test: 15.95% net IRR, 1.40x TVPI, KS-PME 1.25.
Subscription line and NAV facility, their cost and effect. Test: 1.77% of IRR from the line.
ILPA fee, expense and carry lines; controls with evidence; audit areas. Test: gross fee, offsets and net fee to date on one page.
Free Excel template: private equity fund cash flow model.
Every figure is computed by script from the course's running case, Northmoor Capital Partners III, a fictional fund, and checked on 17 November 2026. For education, not investment, legal or accounting advice.
A course built on one private equity fund, from capital calls and equalization to the waterfall, the NAV, IRR and PME, subscription lines and ILPA reporting, with Excel exercises, a 160-question quiz and the Private Equity Fund Model, Pro Edition included ($199).
Keeps the fund's books: capital calls and distributions, fees and expenses, the waterfall and carry, the quarterly NAV and capital accounts, investor reporting and the audit.
Yes, everyday Excel: SUMPRODUCT, IRR, INDEX and a clean layout. Every skill here is a calculation.
ASC 946 and ASC 820 (or IFRS 13), the IPEV Valuation Guidelines and the ILPA Principles and Reporting Template.
The mechanics can be learned in a few weeks of practice on a full case; judgement on LPAs and valuations comes with years of closes.
This article is one calculation from The Private Equity Fund Controller Playbook. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
Get the book on Amazon →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Prefer a PDF? The same book is sold as a DRM-free PDF edition, searchable and printable. Get the 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. The workbook stays free either way.