Companion files · The Private Markets Career Guides
How a Cash Equities Desk Really Works: Covering Institutional Clients, Sales-Trading and Algorithms, Risk Trades, Blocks and Program Trades, Commissions and Broker Votes, US Market Structure, Best Execution and the Career.
These are the companion files of the book. One workbook rebuilds the Halvard Crane case: the Varrick Hollow account, its CSA and wallet share, the Corvane Industrial order and its implementation shortfall against the declined risk price, the Tarrowmere Logistics block with its hedge and grid of exits, the pension client’s program trade with and without its futures hedge, a six-order TCA report and the desk’s 2025 P&L. A toolkit holds the fourteen 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 4 to 16
One Inputs sheet holds every case assumption: the account’s commission rates and vote share, the order’s prices and fill, the risk price, the block bid, re-offer and hedge ratio, the program bids and hedge, the desk’s revenue and cost lines, and the six TCA orders. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook34 KBAppendix B
Account coverage plan, morning call checklist, corporate access event checklist, csa reconciliation checklist, broker vote review, order intake checklist, algorithm selection checklist, risk price request checklist, block trade checklist, program trade bid checklist, tca review checklist, best execution committee checklist, conduct and information barrier checklist and end-of-day checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| Corvane Industrial order | 540,000 of 600,000 shares filled at $50.31 against an interval VWAP of $50.27: an implementation shortfall of $272,660 (91.1 bps), against $180,000 (60.1 bps) had the risk price of $50.20 been accepted |
| Tarrowmere Logistics block | 2,000,000 shares bought at $38.80 for $77.6 million, 1,500,000 placed at $39.00 before the open, 500,000 hedged with a sector fund: a desk P&L of $357,800 |
| The desk in 2025 | $192.0 million of revenue, $156.0 million of costs, $36.0 million before tax and a pre-tax return of 15.0 percent on $240.0 million of allocated equity |
The files are provided as they are, without warranty of any kind. The model is illustrative: Halvard Crane Securities and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is investment, legal or tax advice.
More in corporate finance, markets and banking, 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.