Companion files
Inside the World of Private Wealth, Governance and Family Capital
These are the companion files of The Family Office Professional by Julian R. Sterling.The book on Amazon →
One Excel workbook that answers the question the book leaves as an adjective. Around it, a blank version for your own office, four working documents to print, forty questions that mark themselves, and three cases the book does not work. All free. Nothing is gated behind a sign-up, and no email address is asked for.
Six workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
Chapter 2, and the appendix
Chapter 2 says a single-family office is expensive relative to the assets it manages and viable only above a substantial threshold. That is the most consequential sentence in the book for a family deciding what to build, and it deserves a number. The number is 567 million. At that level of wealth a staffed office and a competitive multi-family office both cost about 2.44 million a year, or 43 basis points.
The two curves cross because one cost is fixed and the other is not. A five-person office costs the same 2,442,000 whether it oversees 100 million or two billion, so its weight falls from 244 basis points to 12. A tiered multi-family schedule falls too, but only from 65 to 30. One curve plunges, the other sags, and they meet exactly once.
The more useful sheet reframes cost as a hurdle: how much better must the office perform, net, to be worth its extra expense? At 250 million, 42 basis points a year — every year, through the cycle, from a five-person team. At 500 million, three. Above the crossover the hurdle is negative and the office pays for itself before adding any value at all.
Download the workbook19 KBAdd a second analyst on the budget sheet. The crossover moves out to 666 million — a shift of 99, not the 64 the salary alone suggests, because employer costs and the bonus pool apply to that salary like any other. Then cut ten basis points off the multi-family office’s top tier and it moves out again, to 777 million. The threshold is not a property of the industry — it is a property of two schedules, and it is more sensitive to the fee you can negotiate than to the salary you pay. Useful to know before a negotiation, and uncomfortable to discover after one.
Confidentiality has a value that does not appear in a fee schedule. So does control over hiring, over what gets reported and to whom, and over the ability to act on a Friday afternoon without a committee. The point of computing the threshold is not to overrule those reasons — it is to price them. A family building an office at 300 million is choosing to pay about 29 basis points a year, roughly 870,000, for control, confidentiality and continuity. That may be excellent value. It is a different decision from believing the office is free, and only one of the two can be defended to the next generation.
The appendix model with every figure emptied. Type in your own office and the schedule you have been quoted; the checks sheet counts what is still missing and tests that the model holds together.
Chapter 2 and the appendix
Up to eight people and eight running lines, employer costs and the bonus pool, and a four-tier multi-family schedule whose bounds you set. The crossover is solved in whichever tier it falls, not only above 500 million, and the hurdle is computed at the family’s own level of wealth and across a grid you can change.
The book’s office and schedule are listed in a text file inside the archive. Type them back in and the file returns 2,442,000, 244 basis points at 100 million and a crossover of 567 million.
Download the blank set18 KBFour pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Appendices A, C and D · the cost appendix
The questions of Appendix A that place any office on the spectrum, with the three numbers a professional should know about their own. The functions checklist of Appendix C, in house, outside or not done. The cost appendix as a worksheet, down to the crossover and the hurdle. And the self-assessment of Appendix D, scored line by line.
Download the PDF13 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Six on the institution and its roles, six on investing, six on governance, structuring, risk and reporting, five on the family and the career, ten on the cost appendix and seven on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book19 KBNew material, not a restatement. Three situations the chapters name in passing and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapter 8 · Case one
A family holds 70 per cent of 600 million in the company it built. Selling down to 10 per cent costs 87.6 million of tax. It also cuts the chance of ending ten years below half the wealth from 10.4 per cent to 0.5. And the median outcome barely moves, 863 million against 860: volatility drag earns the tax back in about ten years.
Chapters 4 and 5 · Case two
A 30 per cent target in private funds, pursued by committing 50 million a year for six years. Without any shock the share peaks at 39.5 per cent. With a 25 per cent market fall in year five it reaches 48.3 per cent. The family never runs short of cash; what it loses is the allocation it chose. Holding the peak at 30 needs about 37 million a year, or 30 with the fall.
Chapters 8 and 11, and the appendix · Case three
A founder with 1.5 billion runs the appendix office. Three children a generation and a 15 per cent transfer cost take each branch to 861 million, then 481, then 256. By generation three every branch sits below the 567 million crossover. Separate offices cost the family about a billion by generation four; staying in one office avoids it.
Download the three cases38 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | ten controls, each stating its own verdict |
Every figure is illustrative, as everything in the book is. What is not illustrative is the shape of the result, which holds for any plausible set of inputs. The workbook prices the office, not the portfolio: no investment management fees, no fund expenses, no performance compensation on direct deals.
The workbook opens in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. It uses no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 22 Sep 2026 | A blank version of the cost model, four working documents on four pages, forty questions that mark themselves and three new cases. The book’s workbook can now also be downloaded on its own. One sentence of its read-me is corrected: a second analyst moves the crossover by 99 million, not “roughly 60”; the model has not changed. |
9 of the calculations in this workbook, worked out in full. All articles.
More in private equity and funds, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: family office cost calculator.
The Family Office Professional develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on AmazonAlso as an ebook on Apple Books · Google Play · DRM-free PDF edition ($19.99).
These files accompany The Family Office Professional. The book is on Amazon.
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.