# Distressed Debt Analysis Analyze distressed debt recovery with enterprise value scenarios, lien waterfall, and investor returns without guessing restructuring outcomes. Model probability-weighted recovery across base, upside, and downside cases to evaluate whether a discounted position offers an asymmetric return profile. - Canonical: https://finamodel.com/templates/distressed-debt-model - Excel download: https://finamodel.com/templates/distressed-debt.xlsx - Category: Credit - Model type: Underwriting - Difficulty: Advanced - Audiences: Credit & risk, Bankers & advisors, Distressed investors, Restructuring advisors, Credit traders, Turnaround specialists - Tags: distressed, restructuring, recovery, waterfall, bankruptcy ## Overview 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's included - 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 - Enterprise value scenarios: base, upside, downside - Recovery waterfall: secured assets, operational improvements, refinancing - Probability weighting of outcomes and expected recovery - Total return and IRR to equity and debt holders - 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. ## Lien waterfall and recovery by tranche Map each debt tranche priority, lien type, and collateral to derive recovery at each enterprise value scenario with full seniority transparency. ## Probability-weighted scenario analysis Test base, upside, and downside cases and weight by probability to derive expected recovery per tranche and position-level return. ## Turnaround EBITDA and value creation path Model EBITDA upside from cost cuts, revenue growth, or asset sales to quantify the enterprise value recovery path that supports refinancing or exit. ## Lien waterfall and recovery by tranche Map each debt tranche priority, lien type, and collateral to derive recovery at each enterprise value scenario with full seniority transparency. ## Probability-weighted scenario analysis Test base, upside, and downside cases and weight by probability to derive expected recovery per tranche and position-level return. ## Turnaround EBITDA and value creation path Model EBITDA upside from cost cuts, revenue growth, or asset sales to quantify the enterprise value recovery path that supports refinancing or exit. ## Features - **Lien waterfall clarity:** Map each debt tranche's priority, lien type, and collateral to derive recovery at each EV scenario. - **Scenario probability weighting:** Test base, upside, and downside cases, then weight by probability to derive expected recovery per tranche. - **Turnaround operating improvements:** Model EBITDA upside from cost cuts, revenue growth, or asset sales to support EV recovery path. ## Use cases - **Distressed investment decision-making:** Evaluate whether a discounted debt or equity position offers asymmetric return profile vs. recovery risk. - **Restructuring exchange offer evaluation:** Compare recovery under exchange offers, debt-for-equity swaps, or stay-put scenarios. - **Chapter 11 plan support:** Quantify recoveries for disclosure statements and absolute priority or cramdown analyses. ## Frequently asked questions ### 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. ## Related templates - [Loan Portfolio CDR Model](https://finamodel.com/templates/loan-portfolio-cdr-model) - [Mezzanine Debt Funding Model](https://finamodel.com/templates/mezzanine-debt-model) - [Exit Waterfall Model](https://finamodel.com/templates/exit-waterfall-model)