Companion files · The Corporate Restructuring Handbook

The Corporate Restructuring Handbook

Liquidity, Liability Management and Chapter 11 by the Numbers. The 13-Week Cash Flow, Uptiers and Drop-Downs, Valuation and the Plan, With the Models Supplied.

These are the companion files of The Corporate Restructuring Handbook by Julian R. Sterling.The book on Amazon →

Also as an ebook on Apple Books · Google Play.

These are the companion files of the book. Three workbooks follow Brantwell Coatings Group, the book's one company, from the Monday its board sees $145 million of liquidity on paper and $22.5 million it can use, through the out-of-court transactions, to the plan, and they reproduce every figure the book prints. Around them sit a blank 13-week cash flow and waterfall for your own company, six working forms, forty questions and three worked cases. No sign-up, no email is asked for, nothing is locked. Amounts are in millions of US dollars; blue type is an input, black type is a formula.

All the companion files and the read-me, in one archive381 KB

The archive holds the eight files below, with 00_START_HERE.md at its root. No macros, no circular references, no external links in any workbook. They recalculate in Excel, LibreOffice or Google Sheets.

Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample

Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →

Get an email if these files are corrected

Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.

Join the reader list

Run by MailerLite, off this site. How your address is used.

The files

Three numbers to reproduce first

13-week forecastEnding cash of $19.89 million in week 13, a trough of $19.88 million in week 12, against a $25 million minimum
The DIPA need of $62.06 million, a facility of $65 million
At the plan valueAt $975 million: first lien $852.0 million, 88.7 percent; unsecured pool $53.2 million, 10.6 percent

Three cases

The files are provided as they are, without warranty of any kind. The models are illustrative: Brantwell Coatings Group and every party in the cases are fictional, and the figures are the book's assumptions, not market statistics. Nothing here is legal, tax, accounting or investment advice; the documents of each company, its counsel and its advisers decide.

Explore the full companion library

Discover more of Julian R. Sterling's practical library of models, checklists and worked cases.

Browse Julian R. Sterling's books Browse all companion files

Also available as a standalone free template: 13-week cash flow model.

Also by Julian R. Sterling

More in credit and debt, with free companion files. The full list of titles is on the author page.

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.