Companion files · The Private Markets Career Guides

The Equity Capital Markets Banker

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

Offering35.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
PricingPeers imply $22.00, a 9.1 percent IPO discount; a book nine times covered; a first day at $23.40, 17.0 percent up
Block20.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.

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.

Also available as a standalone free template: IPO pricing model.