A quarterly fund model built from the controller's chair: capital calls partner by partner with equalization, the management fee and its offsets, a subscription line and a NAV facility, the European and the American waterfalls with accrued carry and clawback, capital accounts, and net and gross returns with a PME, with 38 built-in checks.
Private Fund Finance & Controllership includes the Private Equity Fund Model, Pro Edition, plus a 32-page Course Book, an Excel workbook that checks your answers and a 160-question quiz with a final exam. For $70 more than the model alone, you learn the whole controller's job behind it.
Enter the fund terms, six partners and ten investments. The workbook calls capital quarter by quarter, equalizes the second closing, charges the fee on commitments then on net invested capital with offsets, runs the subscription line and a NAV facility, distributes exit proceeds through both waterfalls, accrues the carry in the NAV, sizes the clawback, builds every partner's capital account at the date you choose and reports DPI, RVPI, TVPI, net and gross IRR, the IRR without the line and a Kaplan-Schoar PME.
One zip file: the model with a worked example, a blank copy and a 16-page PDF user guide. Single-user license. Invoice in your company's name at checkout.
Secure checkout by Stripe. The free private equity fund cash flow model stays free.

Blue text on a pale yellow fill marks an input; every other cell is a formula.


Northmoor Capital Partners III, L.P., a fictional $500m buyout fund with a $10m GP commitment. Amounts in $ millions:
| Measure | Value |
|---|---|
| Capital called / invested / exit proceeds | 479.1 / 410 / 723.5 |
| Management fees before offsets / net | 59.66 / 47.72 |
| Equalization capital at the second closing | 11.63 |
| Carry: European / American / American clawback | 47.46 / 56.97 / 9.69 |
| Net IRR / TVPI (with the line) | 15.95% / 1.40x |
| Net IRR without the line | 14.18% |
| Gross IRR / multiple | 21.32% / 1.76x |
| KS-PME / direct alpha | 1.25 / 10.93% |

No. Interest on both facilities is charged on opening balances, the subscription line repays drawings made a fixed number of quarters earlier and the waterfalls are cumulative: the sheet calculates in one pass, with no iterative calculation, macro or data table.
The Real Estate Fund Model projects properties (NOI, debt, refinancing, sale) and rolls them up to a fund. This model works from the fund controller's chair: investor by investor, equalization, the fee basis and offsets, both waterfalls with accrued carry and clawback, the subscription line, a NAV facility, capital accounts and a PME.
The free model works one LP's commitment with calls and distributions as inputs. The Pro edition builds those flows from the fund terms and the portfolio, for every partner, and adds fees, waterfalls, facilities, capital accounts and 38 checks. The free model stays free.
Yes. It uses standard functions only and was recalculated and verified cell by cell in LibreOffice. Charts may look slightly different outside Excel.
Six partners on identical terms (no fee classes), ten investments with one exit each, no recycling, no fund-level taxes, no carry escrow. The guide lists every simplification.
Yes: Private Fund Finance & Controllership ($199) teaches the whole controller's job on the same fund and includes this model.