A free fund formation model in Excel: fees, equalization and the management company
A real estate fund's launch in numbers: closes and vehicles, the organizational expense budget and cap, management fees by close and by year, what a second-close investor pays in equalization, ten years of the management company's P&L and the carry.
A $420 million fund pays $8.04 million a year of management fees in its investment period. A second-close investor owes $18.62 million at closing: equalization of $17.32 million, interest and a fee catch-up. Without a second fund, the management company ends 2035 with a cumulative loss of $6.26 million.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Fund_Formation_Model.xlsx (22 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This model goes with The Fund Formation Handbook, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
7 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
Inputs
Closes, vehicles, terms, launch budget lines, management company costs, Fund II switch.
Launch Budget
Organizational and offering expenses, the cap and the excess borne by the manager.
Fees
Annual fee in the investment period; fee received by the manager by year, catch-ups counted when paid.
Manco P&L
Ten years of the management company, Fund I only or with Fund II (switch on Inputs).
Equalization
What a second-close investor pays, interest by call, fee catch-up, vehicle rebalancing.
Waterfall Summary
An annual European waterfall on the case's illustrative 2.4x gross assumption; total carry.
Checks
The figures printed in the book beside the formulas that produce them. ALL CHECKS OK on the default inputs.
What the worked case returns
Measure
Value
Fund size ($m)
420
Annual fee, investment period ($m)
8.04
Organizational expenses incurred ($m)
2.06
Excess borne by the manager ($m)
0.31
Equalization contribution, second close ($m)
17.32
Equalization interest ($m)
0.30
Fee catch-up ($m)
1.00
Total due from second-close investors ($m)
18.62
Manager's result, first year ($m)
-2.14
Manager's cumulative result, end 2030 ($m)
11.46
Total carry ($m)
89.9
Net multiple to investors
1.84x
Fees start at first close, costs start before it. The management company is in the red in its first year and only stays profitable over ten years if a second fund follows: switch Fund II on in Inputs and watch the P&L change.
How to use it on your own case
Enter the closes, commitments by vehicle and the fee terms on Inputs.
Enter the launch budget lines and the organizational expense cap.
Read the fees by year and the equalization a second-close investor pays.
Read ten years of the management company's P&L, with and without a second fund.
Questions people ask about it
What is equalization in a private fund?
Investors who join at a later close pay their share of capital already called, plus interest, so that they end up in the same position as first-close investors.
Who pays a fund's formation costs?
The fund, up to a cap set in the agreement. Expenses above the cap are borne by the manager, and the file computes that excess.
Is a first fund profitable for the manager?
Often not on its own. Fees rarely cover the platform's costs for long, which is why the file shows the management company with and without a second fund.
Is this template really free?
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Go further
The free workbooks of The Fund Formation Handbook go further: the full companion set, blank models and the worked cases of the book.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.