Companion files · The Private Markets Career Guides
How IPOs, Follow-Ons, Blocks and Convertibles Are Won, Valued, Priced and Allocated: The Book, the Greenshoe, the Lock-Up and the Career on an ECM Desk.
These are the companion files of the book. One workbook rebuilds the Telvara case: the shares sold and the money raised, the greenshoe, the free float and the market value, fair value and the IPO discount, the book and the first day, the fees, and the block its private equity owner sold six months later. 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 6 to 10 and 13
One Inputs sheet holds every assumption: share counts, proceeds, the range and the offer price, the greenshoe, the gross spread, earnings and the peer multiple, the book, the first day and the block. One sheet per analysis, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook15 KBAppendix B
Pitch book checklist, IPO timetable template, equity story checklist, valuation and range template, roadshow schedule template, book and allocation template, pricing call checklist, greenshoe and stabilization checklist and block trade 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-me2 KB| Offering | 35.0 million shares at $20.00, $700.0 million, plus a 5.25 million share greenshoe; a market value of $4,000.0 million and a free float of 17.5 percent |
| Pricing | Peers imply $22.00, a 9.1 percent IPO discount; a book nine times covered; a first day at $23.40, 17.0 percent up |
| Block | 20.0 million shares sold overnight at $24.70, a 5.0 percent discount: $494.0 million |
The files are provided as they are, without warranty of any kind. The models are illustrative: Marlowe Brothers, Telvara Systems and the other names are fictional, the models are simplified, and the figures are the book’s assumptions, not prices, recommendations or market benchmarks. Nothing here is investment, legal or tax 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.
Also available as a standalone free template: IPO pricing model.