Credit and restructuring models

Credit and restructuring modelling asks what a sponsor’s model does not: how much can be lent against a business, whether it still pays when the plan misses, how much room the covenants leave, how many weeks of cash it has when it does not, and what each creditor recovers if it fails. Three workbooks cover that arc in order: the lender’s credit model that sizes and monitors the debt, the 13-week cash flow a stressed borrower lives by, and the recovery waterfall that divides the company when it is restructured. The leveraged buyout that usually creates the debt sits with the M&A and private equity models.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: credit and restructuring.Updated 1 October 2026

The models

Preview the Recovery waterfall model workbook
Advanced7 sheets~40 minIBER/HFPE

Recovery waterfall model

Distribute a restructured company’s value by an assumed priority ranking across a range of enterprise values, identify the fulcrum security in each, and calculate the return on each traded class at an assumed purchase price.

Preview the CLO cash flow and waterfall model workbook
Advanced11 sheets~50 minER/HFPEIB

CLO cash flow and waterfall model

Build a CLO quarter by quarter: a loan portfolio that defaults, prepays and recovers with a lag, reinvested for three years; the interest waterfall with overcollateralisation and interest coverage tests, the closed-form cure that diverts interest to the senior notes and the deferral of unpaid mezzanine interest; the sequential principal waterfall; and the equity IRR and each tranche’s loss under a base, a stress and a severe case, with grids of the equity return and the interest diverted by default rate and recovery.

Other areas: Core modelling · M&A and private equity · Real estate · Infrastructure and project finance · Healthcare · Technology · Financial institutions · All 57 models

How to work through it

Read the credit and covenant guide first, then size a structure in the capital stack lab. Open the credit model and switch it to the downside case to see which covenant breaks first. The 13-week model shows the same company weekly once cash is short, and the recovery waterfall shows who owns it afterwards. The CLO model looks at credit from the other side of a securitisation: a pool of loans against a stack of notes, where coverage tests divert interest to the senior notes as defaults mount. Each model has a starter workbook that leaves one schedule for you to build.

The mechanics they share

Each schedule is one reusable calculation, explained on its own page with the rows it occupies in every model that uses it.

Financing schedules

Debt capacity

How much a borrower can borrow, and which test binds

Financing schedules

Debt schedule

Tranches, interest, amortisation and the sweep

Financing schedules

Covenant compliance and headroom

Leverage, interest cover, fixed charge cover, EBITDA cushion

Financing schedules

Maturity profile and refinancing

What falls due when, and whether it can be refinanced

Restructuring schedules

Absolute priority distribution

Value paid out by seniority, collateral first

Restructuring schedules

Cash receipts and the collections curve

Sales to cash, week by week

Restructuring schedules

Cash disbursements by calendar

What is paid, and on which Friday

Restructuring schedules

Borrowing base and availability

What the revolver will actually lend this week

Restructuring schedules

Liquidity forecast and covenant headroom

Cash, availability, headroom, shortfall

Restructuring schedules

Claims by class

The claims register a recovery is built on

Restructuring schedules

Fulcrum analysis and implied returns

Which class is the fulcrum, and what it returns

Financing schedules

CLO collateral roll-forward: defaults, recoveries and reinvestment

Performing par, defaults, a recovery lag, reinvestment

Financing schedules

CLO coverage tests: OC and IC ratios and the cure

OC and IC tests by class and the interest they divert

Financing schedules

CLO interest waterfall: costs, notes, cures and equity

Costs, five classes of interest, deferral, the residual

Financing schedules

CLO principal waterfall: sequential paydown and the call

Diverted interest, sequential principal, class balances

Valuation and returns

Sensitivity tables

Two assumptions at once, without a data table

Practise first

Where this work is done

Investment Banking

Advise on M&A and capital raising. The training ground the rest of the map feeds off.

How to get in and prepare
Debt Capital Markets

Price and place bonds and loans. Closest thing in banking to a markets seat with banking hours.

Restructuring

The same tools pointed at companies in distress. Countercyclical, and technically the hardest advisory seat.

Private Credit

Lend to the same companies PE buys. Downside-focused: you get paid back or you do not.

Distressed & Special Situations

Debt of companies in trouble. Legal structure matters as much as the financials.

Private Equity

Buy control of established companies using debt, improve them, sell them.

How to get in and prepare

Read

The vocabulary

Questions

What is the difference between a credit model and an LBO model?

They describe the same transaction from opposite sides. The LBO model is built for the sponsor and ends in an equity return; it sits with the M&A and private equity models. The credit model is built for the lender and ends in debt capacity, covenant headroom, a refinancing test and a recovery. They share the debt schedule, which is why reading one beside the other is worth the time.

Where does a restructuring model start?

With liquidity, not value. The 13-week cash flow says how long the company can run and how much new money it needs; that sizes the DIP facility. The recovery waterfall then distributes the restructured company’s value among the creditors and names the fulcrum security, the class that will own it.

Which of these do interviews test?

Leveraged finance and credit interviews test debt capacity, covenants and the debt schedule; restructuring interviews test the recovery waterfall, the fulcrum and liquidity. The restructuring interview guide works through the questions, and each model page lists the mistakes a reviewer looks for.