Distressed Debt Analysis
Credit Financial Model (Free Excel Download)
Analyse distressed debt purchases, recoveries, restructuring paths, liquidity, and exit proceeds to compare workout, turnaround, and liquidation outcomes.
professionals from Deloitte
Used by professionals from
About this model
Distressed debt analysis values bonds or loans of companies in financial distress by projecting recovery under various restructuring scenarios. The model maps the current capital structure (secured debt, unsecured bonds, equity) and calculates how much each class recovers under a base-case enterprise value scenario, a stress case (lower exit value), and an upside case. The recovery waterfall follows strict lien priority: secured assets are distributed first, operational improvements or asset sales generate additional proceeds, and remaining recovery is allocated down through the stack to junior creditors and equity.
The model assigns probability weights to each scenario (e.g., 40% base, 35% stress, 25% upside) and computes expected recovery per dollar of investment. Investor returns are expressed as IRR on the path from current market price to restructured exit value, typically over a 2–4 year resolution horizon. Key inputs include current debt price (often traded at steep discounts), assumed exit enterprise value, and recovery timing. The workbook flags situations where junior creditors receive zero recovery, allowing you to eliminate false-hope investments.
This template is suitable for credit funds, hedge funds, and restructuring advisors analyzing investment opportunities in broken companies or sectors experiencing temporary distress.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Distressed Debt Analysis
- Current capital structure and debt hierarchy
- Enterprise value scenarios: base, upside, and downside
- Recovery waterfall: secured assets, operational improvements, and refinancing
- Probability weighting of outcomes and expected recovery by tranche
- Total return and IRR to equity and debt holders with stress scenarios
- Stress scenarios and exit timing sensitivity
Distressed Debt Model: Recoveries, Fulcrum Security and Fund Returns
This distressed debt model works through a single obligor's capital structure, identifies the fulcrum security and derives recovery rates rather than assuming them. It blends enterprise value methods, cascades value down a priority waterfall, weights five scenarios and then applies a European GP/LP waterfall to show investor-level outcomes.
What drives value and recovery in the model
The model is built around one obligor with a canonical eight-class capital structure in strict priority order, starting with the revolver and running down through term loans, secured notes, unsecured and subordinated notes, trade claims and common equity.
- Each tranche is described with face value, coupon and coupon type, maturity, purchase price and a flag for whether the fund holds it.
- This structure matters because recovery is a residual calculation: value available after senior claims is what determines whether a junior class or the equity is in the money.
How enterprise value and the waterfall interact
Enterprise value is produced three ways: a discounted cash flow that flexes the terminal multiple, trading comparables that apply distressed-adjusted peer multiples to LTM EBITDA, and a sum-of-parts that values business segments separately and then applies a forced-sale haircut.
- The three are averaged into a blended base figure, which is then multiplied up or down according to the selected scenario.
- Professional fees, DIP repayment and adequate-protection payments are deducted to arrive at distributable enterprise value for the waterfall.
Identifying the fulcrum security through the priority stack
The claims waterfall cascades distributable value down the priority stack, with each tranche absorbing the lower of the remaining value and its claim.
- The class in which recovery first falls between zero and one hundred percent is flagged as the fulcrum security, the tranche that would typically end up owning reorganisation equity.
- The model picks that tranche name automatically, so changing enterprise value or DIP size can shift the fulcrum from the second-lien notes to another class without the user having to relabel anything.
Scenario weighting and investor-level outcomes
Five weighted scenarios drive the analysis: liquidation, going-concern low, base, high and stress. Each applies a different percentage of going-concern enterprise value, and the scenario summary shows per-tranche recovery percentages alongside a probability-weighted blended recovery.
- The fund-level section then applies European waterfall terms to a single trade rather than a full fund, including management fee, fund expenses, hurdle, carry and a four-tier waterfall with catch-up.
- Sensitivity grids show how recovery for a given tranche moves with enterprise value, exit year and DIP size, while ten structural checks verify priority ordering, waterfall integrity, fulcrum identification and the tie-out between sources and uses.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is distressed debt analysis?+
It is the process of valuing bonds or loans trading at a significant discount by modeling the likely recovery in a restructuring or bankruptcy relative to the purchase price.
What is recovery in distressed debt?+
Recovery is the percentage of original principal received by a creditor in a restructuring or bankruptcy, determined by lien position and enterprise value available for distribution.
What is an absolute priority waterfall?+
A waterfall distributes enterprise value to tranches in order of seniority: secured lenders recover first, then unsecured creditors, then subordinated debt, then equity.
How do I estimate turnaround value?+
Forecast EBITDA under new management, asset sales, or cost reduction plans, then apply a sector multiple to derive stand-alone enterprise value or support for refinancing.
Who uses distressed debt models?+
Distressed investors, restructuring advisors, credit traders, and turnaround specialists use them for investment decisions, exchange offer evaluations, and Chapter 11 plan support.
Have more financial modelling questions? Contact us
Related templates
Loan Portfolio CDR Model
Credit default risk model for loan portfolios with cumulative default rates and loss severity analysis.
Mezzanine Debt Funding Model
Mezzanine financing structure with subordinated debt, equity kickers, and sponsor return analysis.
Exit Waterfall Model
Waterfall analysis for M&A, IPO, or sale with proceeds distributed to shareholders and securities holders.
Auto Loan Portfolio Model
Automotive loan securitization and portfolio analysis.
