# The Equity Sales and Trading Professional: companion files

Julian R. Sterling

## What is here

- **Equity_Sales_Trading_Model.xlsx**: the workbook that rebuilds the Halvard Crane case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Account and CSA, Algo Order and Shortfall, Risk Trade, Block, Program Trade, TCA Report, Desk P&L, Checks.
- **Equity_Desk_Toolkit.docx**: the fourteen checklists of Appendix 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, end-of-day checklist), in editable form.

## Which sheet answers which chapter

- Chapters 4, 6 and 7: Account and CSA (Varrick Hollow's $36.0 million wallet, the CSA split of 5.0 bps into 3.5 bps for research and 1.5 bps for execution, $1.52 million of revenue credited and a wallet share of 4.2 percent)
- Chapters 8, 9 and 13: Algo Order and Shortfall (the Corvane Industrial order against decision, arrival and interval VWAP, and the implementation shortfall of $272,660 split into delay, trading, opportunity and commission)
- Chapter 10: Risk Trade (the declined risk price of $50.20, what the client would have paid, what the desk would have made or lost, and the break-even price)
- Chapter 11: Block (the Tarrowmere Logistics bid at $38.80, the placement at $39.00, the sector hedge, the $357,800 desk P&L and the grid of other exits)
- Chapter 12: Program Trade (the pension client's $400.0 million basket bid at 16.0 bps, hedged with index futures, with and without the hedge)
- Chapter 13: TCA Report (six orders against arrival and interval VWAP, notional-weighted and equal-weighted)
- Chapter 16: Desk P&L ($192.0 million of revenue, $156.0 million of costs, $36.0 million before tax and 15.0 percent on allocated equity)

## Two inputs to change first

1. On Inputs, set the assumed buyback average below the risk price of $50.20, as on a day when the stock fell: watch the desk result turn positive on Risk Trade while the client comparison stays the same.
2. On Inputs, set the block hedge ratio to zero: watch the grid of exits on Block swing with the sector move. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Halvard Crane Securities, Varrick Hollow, Orrindale, Corvane Industrial, Tarrowmere Logistics and the pension client are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case figures are illustrative assumptions, not benchmarks. Provided as is, without warranty. Not investment, legal or tax advice.
