Companion files · The Private Markets Career Guides

The Private Banker

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 workbook, the toolkit and the read-me, in one archive55 KB

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.

The files

Three numbers to reproduce first

PortfolioThe Pelham allocation expects 6.02 percent a year before fees and 5.41 percent after a fee of $0.73 million
DrawdownAn equity fall of 30 percent costs the portfolio $17.0 million, 14.2 percent, while three years of spending stay untouched
LendingEquities 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.

Also by Julian R. Sterling

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.