Companion files · The Private Markets Career Guides
How to Find, Value, Pitch and Size Long and Short Equity Ideas: Variant Views, Scenarios, Catalysts, Risk, Portfolio Construction and the Career at a Fund or a Platform.
These are the companion files of the book. One workbook rebuilds the Ostrander Capital case: the Brayford Industries long with its valuation, scenarios, expected value and position size, the Velmont Home short with its borrow cost and crowding, and the third-quarter attribution from gross return to beta, alpha, fees and the net return to investors. A toolkit holds the checklists and templates 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 3 and 5 to 11
One Inputs sheet holds every assumption: prices, share count, net debt, EBITDA, multiple, scenarios and probabilities, loss budgets, borrow cost, exposures, returns and fees. One sheet per analysis, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook16 KBAppendix B
Idea screen, first-week research plan, model checklist, one-page pitch template, short checklist, position review template, earnings preview template and compliance checklist for expert calls.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| Long | Brayford at $48.00 is worth $56.25 on 11.5 times our EBITDA; a $38.00 bear case and a 0.6% loss budget size it at 2.88% of NAV, $69.1 million |
| Short | Velmont at $32.00 has an expected value of $26.10: 15.9% expected after a 2.5% borrow cost, sized at 1.33% of NAV, $32.0 million |
| Quarter | A 5.2% gross return, of which 3.6% alpha, becomes 3.860% net to investors after fees, $92.6 million |
The files are provided as they are, without warranty of any kind. The models are illustrative: Ostrander Capital, Brayford Industries and Velmont Home are fictional, the models are simplified, and the figures are the book’s assumptions, not prices, recommendations or forecasts. Nothing here is investment, legal or tax advice.
More in fund operations, 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.