Companion files · The Private Markets Career Guides
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 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.
Chapters 3 to 8, 10, 14 and 15
One Inputs sheet holds every assumption: EBITDA and add-backs, debt sizes, spreads, flex, the projection vectors, the recovery case, the Linwood offers and the Corvane exchange. One sheet per analysis, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook26 KBAppendix B
First-day company checklist, add-back questions, credit approval memo outline, commitment papers checklist, syndication day checklist, covenant comparison, quarterly monitoring and early warning signs of a liability management exercise.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| Kestrel at closing | Total leverage 5.50x on adjusted EBITDA of $120.0 million, 6.11x on reported EBITDA; interest coverage 2.32x |
| Underwriting risk | If the loan clears at 94.00, the three banks lose $10.2 million instead of earning their $16.5 million fee |
| Uptier exchange | Corvane'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.
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.