# The Equity Capital Markets Banker: companion files

Julian R. Sterling

## What is here

- **ECM_Model.xlsx**: the workbook that rebuilds the Telvara case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Offering, Pricing, Block, Checks.
- **ECM_Toolkit.docx**: the checklists and templates of Appendix B (pitch book, IPO timetable, equity story, valuation and range, roadshow schedule, book and allocation, pricing call, greenshoe and stabilization, block trade), in editable form.

## Which sheet answers which chapter

- Chapters 6 to 9: Pricing (fair value, IPO discount, book, first day)
- Chapters 8 to 10: Offering (shares, greenshoe, float, market value, fees)
- Chapter 13: Block (the Kestrel block)

## Two inputs to change first

1. On Inputs, set the offer price to 22.00, the fair value: see the discount fall to zero, the base deal grow and the first-day return shrink.
2. On Inputs, raise the block discount from 5.0% to 8.0%: watch the block price and the proceeds fall. 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.

Marlowe Brothers, Ashby Grant, Telvara Systems and Kestrel Equity are fictional; the models are simplified teaching models; all case figures are illustrative assumptions, not prices, recommendations or market benchmarks. Provided as is, without warranty. Not investment, legal or tax advice.
