Articles

How to learn private equity fund finance and controllership

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

The eight skills

1. Read the LPA for its numbers

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.

2. Call capital and equalize

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.

3. Compute fees and offsets

Switch the basis at the end of the investment period and apply offsets. Test: 2.450 a quarter falling to 1.011 before offsets.

4. Run the waterfall

Capital, pref, catch-up, split, European and American; accrued carry; clawback. Test: a 9.69 American clawback.

All eight on one fund: the course

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).

Read module 4 and try ten quiz questions, free →

5. Close the quarter

Roll the NAV, tie capital accounts to it. Test: closing NAV of 288.07 by both methods.

6. Measure performance

Net and gross IRR, DPI, RVPI, TVPI, PME. Test: 15.95% net IRR, 1.40x TVPI, KS-PME 1.25.

7. Use and report fund financing

Subscription line and NAV facility, their cost and effect. Test: 1.77% of IRR from the line.

8. Report to LPs and pass the audit

ILPA fee, expense and carry lines; controls with evidence; audit areas. Test: gross fee, offsets and net fee to date on one page.

Where to practise

Free Excel template: private equity fund cash flow model.

Sources

  1. Julian R. Sterling, Private Fund Finance & Controllership (course, 2026): running case Northmoor Capital Partners III
  2. Julian R. Sterling, The Private Equity Fund Controller Playbook
  3. ILPA, Principles 3.0 (2019) and updated Reporting Template (January 2025)

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.

Learn the whole method: Private Fund Finance & Controllership

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).

Read module 4 and try ten quiz questions, free →

Questions readers ask

What does a private equity fund controller do?

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.

Do I need to know Excel?

Yes, everyday Excel: SUMPRODUCT, IRR, INDEX and a clean layout. Every skill here is a calculation.

Which standards should a fund controller know?

ASC 946 and ASC 820 (or IFRS 13), the IPEV Valuation Guidelines and the ILPA Principles and Reporting Template.

How long does it take to learn?

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.

Read the whole case

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

Also on this site

All 1908 articles →

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.