Companion files · The Private Markets Career Guides
How to Advise Wealthy Families: Investment Policy, Portfolio Construction, Lending Against Portfolios, Trusts and Estates, Liquidity Events and the Career in Wealth Management.
These are the companion files of the book. One workbook rebuilds the three fictional files of the Ardmore Private Bank relationship team: the Pelham founder's $120.0 million portfolio with its allocation, tiered fee and drawdown test; the Ellery family's securities-based loan with its lending value, cushion and margin call scenarios; and the revenue of the team's book. A toolkit holds the checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 6 to 10 and 15
One Inputs sheet holds every assumption: weights, return assumptions, shocks, fee tiers, pledged assets, advance rates, the loan, and the book's margins. One sheet per analysis, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook18 KBAppendix B
Discovery questionnaire, investment policy statement outline, proposal pack contents, annual review agenda, credit request outline, margin call procedure, liquidity event checklist and onboarding file checklist.
Download the toolkit39 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| Portfolio | The Pelham allocation expects 6.02 percent a year before fees and 5.41 percent after a fee of $0.73 million |
| Drawdown | An equity fall of 30 percent costs the portfolio $17.0 million, 14.2 percent, while three years of spending stay untouched |
| Lending | Equities alone would have to fall 66.4 percent before the Ellery loan triggers a margin call |
The files are provided as they are, without warranty of any kind. The models are illustrative: Ardmore Private Bank, the Pelham and Ellery families and Pelham Robotics are fictional, the models are simplified, and the figures are the book’s assumptions, not market terms, ratings or forecasts. Nothing here is investment, legal, tax or accounting advice.
More in credit and debt, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.