What a single-family office costs, line by line, in dollars and in basis points of the assets it oversees, against a multi-family office's tiered fee, with the crossover solved and the performance hurdle at each level of wealth.
A five-person single-family office costs $2,442,000 a year: $1,767,000 of people and $675,000 of running costs. That is 244 basis points at 100 million and 12 at two billion. Against a multi-family office's tiered fee, the two cost the same at 567 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.
Family_Office_Cost_Calculator.xlsx (19 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 Family Office Professional, 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
6 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
The office
Five salaries and six running costs. Amber cells are yours.
Cost in basis points
The same office across six levels of wealth.
The alternative
A tiered multi-family office schedule, priced.
The crossover
The two curves, and where they meet.
The hurdle
What the office must earn to justify itself.
Checks
Ten controls that test themselves and say so.
What the worked case returns
Measure
Value
Salaries
$1,140,000
People cost, with employer costs and bonus
$1,767,000
Running cost
$675,000
Total annual cost
$2,442,000
Single-family office at 100 million (bps)
244.2
Single-family office at 500 million (bps)
48.8
Multi-family office fee at 500 million
$2,275,000
Crossover ($ millions)
566.8
Cost at the crossover (bps)
43.1
Hurdle at 250 million (bps)
41.7
Hurdle at 500 million (bps)
3.3
Below the crossover the single-family office has to outperform to earn its extra cost: 42 basis points a year at 250 million, every year. Above it the hurdle turns negative and the office pays for itself before it adds any value.
How to use it on your own case
Enter the team's salaries, employer costs and bonus pool on The office, then the running costs.
Enter the multi-family office's fee schedule on The alternative.
Read the cost of each in basis points and the crossover level of wealth on The crossover.
Read the hurdle: the net outperformance the single-family office must deliver to be worth its extra cost.
Questions people ask about it
How much does a single-family office cost?
It depends on the team and the platform. The file builds the cost line by line, from salaries, employer costs and bonus to premises, technology, audit and custody, and shows it in basis points of the assets overseen.
At what level of wealth does a single-family office make sense?
On cost alone, where its fixed cost falls below what a multi-family office would charge on the same assets. The file solves that crossover, and it moves with every input, above all with the fee you can negotiate.
Does the calculator include investment fees?
No. It prices the office, not the portfolio: no fund fees, no performance compensation and no tax.
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 Family Office Professional 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.
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 template stays free either way.