Pro models

Private Equity Fund Model Excel Template, Pro Edition

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.

Get this model inside the course: $199 instead of $129

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.

Get the course with the model, $199 → · Try a module free

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.

Private Equity Fund Model, Pro Edition: $129

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.

Buy now, $129 →

Secure checkout by Stripe. The free private equity fund cash flow model stays free.

Dashboard of the Private Equity Fund Model, Pro Edition: master check, fund totals, net and gross returns, reporting-quarter metrics and carry
The Dashboard: master check, fund totals, returns at the end and at the reporting quarter, carry under both waterfalls.

What the model does, tab by tab

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

Dashboard
Master check, fund totals, net and gross returns, reporting-quarter DPI, RVPI, TVPI and IRR, accrued carry, both carries and the clawback, two charts.
Inputs
Fund terms, second closing and equalization rate, fees and offsets, expenses and the organizational cap, waterfall, subscription line, NAV facility, reporting quarter, six partners, ten investments, a public index.
Deals
Value of each investment at each quarter end and a deal summary with gross multiple and IRR.
Fund
Forty quarters: investments, exits, fees and offsets, expenses, the line, calls, the NAV facility, distributions, NAV, the European and American waterfalls, accrued carry, clawback.
LPs
Each partner's calls as if admitted at the first closing, cash actually paid with equalization, distributions, net IRR and multiple.
Capital Accounts
Every partner's account at the reporting quarter, tied to the NAV with the accrued carry, and the NAV roll-forward of the quarter.
Returns
Net and gross IRR, DPI, RVPI, TVPI, the IRR without the line, KS-PME and direct alpha, at the reporting quarter and at the end; carry and GP economics.
Checks
38 integrity controls and a master check.
LPs sheet: each partner's commitment, equalization capital and interest, paid in, received, net multiple and IRR
The LPs sheet: equalization of the second closing and each partner's net return.
Capital Accounts sheet: contributions, distributions, fees, expenses, gains, carry and ending capital of each partner
Capital accounts at the reporting quarter, tied to the NAV.

The worked example

Northmoor Capital Partners III, L.P., a fictional $500m buyout fund with a $10m GP commitment. Amounts in $ millions:

MeasureValue
Capital called / invested / exit proceeds479.1 / 410 / 723.5
Management fees before offsets / net59.66 / 47.72
Equalization capital at the second closing11.63
Carry: European / American / American clawback47.46 / 56.97 / 9.69
Net IRR / TVPI (with the line)15.95% / 1.40x
Net IRR without the line14.18%
Gross IRR / multiple21.32% / 1.76x
KS-PME / direct alpha1.25 / 10.93%
Checks sheet of the Private Equity Fund Model, Pro Edition
The Checks sheet: 38 integrity controls and a master check.

Technical notes

Questions people ask about it

Does the model use macros or circular references?

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.

How is it different from the Real Estate Fund Model, Pro Edition?

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.

How is it different from the free private equity fund cash flow model?

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.

Does it work in Google Sheets and LibreOffice?

Yes. It uses standard functions only and was recalculated and verified cell by cell in LibreOffice. Charts may look slightly different outside Excel.

What does it leave out?

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.

Is there a course that uses it?

Yes: Private Fund Finance & Controllership ($199) teaches the whole controller's job on the same fund and includes this model.

Private Equity Fund Model, Pro Edition: $129

Buy now, $129 →