# The Private Banker: companion files

Julian R. Sterling

## What is here

- **Private_Banker_Model.xlsx**: the workbook that rebuilds the three case files and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Allocation, Drawdown, Lombard, Book, Checks.
- **Private_Banker_Toolkit.docx**: the checklists of Appendix B (discovery questionnaire, investment policy statement outline, proposal pack, annual review agenda, credit request, margin call procedure, liquidity event checklist, onboarding file), in editable form.

## Which sheet answers which chapter

- Chapters 6 and 7: Allocation (Pelham: weights, expected return, tiered fee, return after fees)
- Chapter 8: Drawdown (shock by asset class)
- Chapters 9 and 10: Lombard (Ellery: advance rates, lending value, cushion, scenarios, the equity fall that triggers a call)
- Chapter 15: Book (revenue lines, net new money)

## Two inputs to change first

1. On Inputs, set the advance rate on equities to 40 percent: watch the Ellery cushion and which scenario now triggers a margin call.
2. On Inputs, move 10 points of weight from core bonds to global equities: see what happens to the expected return and to the drawdown. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light yellow background is an input, black type a formula. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Ardmore Private Bank, the Pelham and Ellery families and Pelham Robotics are fictional; the models are simplified teaching models; all case figures are illustrative assumptions, not market terms, ratings or forecasts. Provided as is, without warranty. Not investment, legal, tax or accounting advice.
