Companion files · The Private Markets Career Guides

The Leveraged Finance Banker

How to Structure, Underwrite and Syndicate LBO Debt: Leveraged Loans, High Yield Bonds, Credit Analysis, Covenants, Market Flex, Liability Management and the Career.

These are the companion files of the book. One workbook rebuilds the three fictional deals of the Ashcombe Bank leveraged finance desk: Kestrel Packaging, a 2025 leveraged buyout with its sources and uses, five-year projection, downside, flex arithmetic and recovery waterfall; Linwood Veterinary Group, a 2026 refinancing where a syndicated loan beats a unitranche; and Corvane Logistics, a 2026 uptier exchange that splits the lenders. A toolkit holds the checklists of Appendix B in an editable form.

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

Kestrel at closingTotal leverage 5.50x on adjusted EBITDA of $120.0 million, 6.11x on reported EBITDA; interest coverage 2.32x
Underwriting riskIf the loan clears at 94.00, the three banks lose $10.2 million instead of earning their $16.5 million fee
Uptier exchangeCorvane's non-participating lenders recover 69.4 percent before the exchange and 19.3 percent after it

The files are provided as they are, without warranty of any kind. The models are illustrative: Ashcombe Bank, Thornfield Capital Partners, Kestrel Packaging, Linwood Veterinary Group, Ardent Credit Partners and Corvane Logistics are fictional, the models are simplified, and the figures are the book’s assumptions, not market terms, ratings or forecasts. Nothing here is investment, legal, tax or accounting 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.