# The Leveraged Finance Banker: companion files

Julian R. Sterling

## What is here

- **Leveraged_Finance_Model.xlsx**: the workbook that rebuilds the three case deals and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Sources and Uses, Projections, Flex, Recovery, Linwood, Corvane, Checks.
- **Leveraged_Finance_Toolkit.docx**: the checklists of Appendix B (first-day company checklist, add-back questions, credit approval memo outline, commitment papers, syndication day, covenant comparison, quarterly monitoring, early warning signs of a liability management exercise), in editable form.

## Which sheet answers which chapter

- Chapters 3 to 5: Sources and Uses (Kestrel at closing: adjusted EBITDA, leverage, interest coverage, fees)
- Chapter 6: Projections (base case and downside, switched on the first line of Inputs; sweep, revolver, springing covenant)
- Chapter 7: Recovery (the default-case waterfall)
- Chapters 8 and 10: Flex (final terms and the two what-if markets)
- Chapter 14: Linwood (syndicated loan against unitranche)
- Chapter 15: Corvane (the uptier exchange, before and after)

## Two inputs to change first

1. On Inputs, set the case to 2 and lower the year 1 downside margin to 10.0 percent: see whether the revolver is drawn and the springing covenant tested.
2. On Inputs, set the What-if 1 loan clearing price to 96.00: read what is left of the banks' fee on the Flex sheet. 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.

Ashcombe Bank, Thornfield Capital Partners, Kestrel Packaging, Linwood Veterinary Group, Ardent Credit Partners and Corvane Logistics are fictional; the models are simplified teaching models; all case figures are illustrative assumptions, not market terms, ratings or forecasts. Provided as is, without warranty. Not investment, legal, tax or accounting advice.
