Active Distressed Investing Strategy Analysis
Analyze distressed debt and equity opportunities with Sourcetable AI. Calculate recovery rates, enterprise valuations, and restructuring scenarios automatically—no complex financial models required.
Andrew Grosser
February 16, 2026 • 15 min read
March 2020: Hertz files Chapter 11 bankruptcy, unsecured bonds trading at 18 cents on the dollar. Distressed investors buy $100M face value for $18M. October 2021: Hertz emerges from bankruptcy, bondholders receive 100% recovery plus accrued interest—$112M total. Return: 522% in 19 months. This is active distressed investing: buying securities of financially troubled companies at steep discounts, profiting when restructuring delivers higher recovery than market expectations.
Excel makes this impossible: building waterfall models with creditor priorities, calculating recovery rates across liquidation vs reorganization scenarios, modeling enterprise value under multiple plans, tracking accrued interest and fees—one deal requires 200+ formulas across 8 tabs. Sourcetable eliminates this. Upload debt schedules and asset values, ask "What do unsecured bondholders recover if EV is $280M?", get instant waterfall analysis with recovery percentages. Start analyzing distressed deals for free at sign up free.
The Waterfall Calculation Problem That Breaks Excel Distressed Models
Why does calculating creditor recovery require waterfall analysis instead of simple division?
Because bankruptcy law establishes strict priority—secured creditors get paid first from asset proceeds, then unsecured creditors, then equity holders. If enterprise value is $280M with $200M secured debt, $150M unsecured bonds, and $50M subordinated notes, you can't just divide $280M by $400M total claims (70% recovery). The waterfall: secured creditors get full $200M, leaving $80M for $200M in junior claims—unsecured bonds receive 40 cents on the dollar ($60M of $150M), subordinated notes get 20 cents ($20M of $50M), equity gets zero. Recovery varies wildly by seniority.
In Excel, this requires nested IF statements checking if each creditor class gets paid in full before proceeding to the next tier: =IF(enterprise_value>=secured_debt, secured_debt, enterprise_value) for secured recovery, then =IF(enterprise_value-secured_debt>=unsecured_debt, unsecured_debt, MAX(0, enterprise_value-secured_debt)) for unsecured, repeating down the capital structure. Add complications like accrued interest (compounds daily), professional fees ($15M+), DIP financing (super-priority), and make-whole premiums (prepayment penalties), and you're managing 50+ interconnected formulas just to calculate who gets paid what.
What happens when the reorganization plan includes equity for creditors instead of cash?
You need to value the new equity being distributed, which depends on post-emergence enterprise value and capital structure assumptions. If unsecured bondholders receive 60% of new equity in exchange for $150M claims, you must estimate: post-bankruptcy enterprise value ($400M?), minus new debt ($100M), equals equity value ($300M), times 60% ownership = $180M recovery ($1.20 per dollar of bonds vs $0.40 cash alternative). But enterprise value assumptions vary wildly—management projects $500M (130% recovery), creditor advisors say $350M (93% recovery), equity committee claims $600M (156% recovery). Excel forces you to build separate scenarios for each projection, manually updating dozens of dependent calculations.
Sourcetable handles this complexity through intelligent questioning. Upload the debt schedule and reorganization plan, then ask: "Compare bondholder recovery under three scenarios: $350M, $400M, and $450M post-emergence EV, assuming 60% equity ownership and $100M new debt." The AI calculates implied equity value for each EV assumption, applies ownership percentage, converts to recovery rate, and presents side-by-side comparison showing $0.93, $1.20, and $1.47 recovery per dollar. Follow-up: "Which EV assumption makes bonds attractive at current 45 cent market price?" Response: "Bonds are attractive at $400M+ EV (167% return at $1.20 recovery vs 45¢ cost), break-even at $375M EV."
Real-World Example: Analyzing J.Crew's 2020 Distressed Debt Opportunity
Let's walk through a complete distressed investment analysis for J.Crew Group's 2020 bankruptcy—a real case demonstrating creditor waterfall analysis, restructuring scenarios, and return calculations.
Step 1: Understand the capital structure (May 2020)
J.Crew files Chapter 11 with complex capital structure. Upload debt schedule to Sourcetable showing:
- Secured term loan: $1,675M, trading at 82¢
- 8.125% senior unsecured notes: $385M, trading at 14¢
- 13% PIK toggle notes: $269M, trading at 8¢
- Accrued interest across all debt: ~$47M
- Total funded debt: $2,329M plus interest = $2,376M
Ask Sourcetable: "Calculate total claims by priority." AI response: Secured claims $1,722M (loan + accrued interest), unsecured senior claims $432M (notes + interest), unsecured subordinated claims $316M (PIK notes + interest), total $2,470M in claims.
Step 2: Analyze liquidation scenario (June 2020)
What's the downside if J.Crew liquidates?
Upload asset values and ask: "Calculate recovery if assets liquidate: inventory $520M at 60% recovery, PP&E $180M at 30%, brand/IP $200M at 25%, real estate leases $50M." AI calculates liquidation proceeds:
- Inventory: $312M (60% of $520M)
- PP&E: $54M (30% of $180M)
- Brand/IP: $50M (25% of $200M)
- Leases: $50M
- Subtotal: $466M
- Less professional fees: -$30M (legal, advisors, trustees)
- Net liquidation value: $436M
Ask: "Apply bankruptcy waterfall to $436M proceeds." Sourcetable calculates: Secured term loan receives $436M of $1,722M claim (25.3% recovery), unsecured notes receive $0 (0% recovery), PIK notes receive $0. Liquidation scenario shows secured lenders lose 75%, unsecured creditors wiped out completely. Current trading prices (82¢ for secured, 14¢ for unsecured senior, 8¢ for PIK) all imply better outcomes than liquidation—market expects reorganization.
Step 3: Model reorganization scenarios (July 2020)
Management proposes reorganization plan: secured lenders convert to $1.5B new debt + 30% equity, unsecured noteholders receive 97% of equity, PIK notes receive 3% of equity. Ask Sourcetable: "Calculate implied recovery for each class if post-emergence EV is $1.2B, $1.5B, or $1.8B."
AI generates scenario table:
- $1.2B EV scenario (bear case): Secured 58% recovery ($1.5B new debt - $300M shortfall), Unsecured senior 0%, PIK 0%
- $1.5B EV scenario (base case): Secured 87% ($1.5B full), Unsecured senior 0%, PIK 0%
- $1.8B EV scenario (bull case): Secured 100% ($1.5B + $222M equity), Unsecured senior 47% ($202M equity / $432M claim), PIK 14% ($46M equity / $316M claim)
Key insight: unsecured notes only recover value if EV exceeds $1.65B (secured claims fully satisfied, leaving equity for juniors). At 14¢ trading price, you're paying $60M for notes with $432M face value. Break-even: need $432M equity value = 100% of post-reorg equity = $1.93B total EV (after $1.5B debt). That's 28% above base case—aggressive but possible if retail recovers post-COVID.
Step 4: Trade execution and outcome (August 2020)
Investment decision: Buy $50M face value unsecured notes at 14¢ = $7M investment. Thesis: COVID created temporary distress, J.Crew brand has value, e-commerce growth supports $1.8B+ EV. Risk: if EV stays below $1.65B, recovery is zero.
September 2020: J.Crew emerges from bankruptcy. Actual outcome: reorganization plan approximately as proposed, post-emergence EV estimates $1.7B. Unsecured noteholders receive equity stake worth approximately 35¢ per dollar of claims. Your position: $50M face value × 35% = $17.5M equity value, vs $7M cost = 150% return in 4 months.
Ask Sourcetable: "What was actual IRR on this trade?" AI calculates: invested $7M in August, received equity worth $17.5M in December (4 months), IRR = 453% annualized. Follow-up: "How sensitive was return to EV assumptions?" Response shows: at $1.65B EV (3% below actual), recovery drops to 20¢ (186% return), at $1.9B EV (12% above), recovery increases to 52¢ (643% return)—high sensitivity to enterprise value.
Absolute Priority Rule Violations: When Junior Creditors Get Paid Before Seniors
Can equity holders receive value while bondholders are impaired?
In theory, no—absolute priority rule requires senior creditors be paid in full before juniors receive anything. In practice, yes—through negotiated "gifting" where seniors agree to give juniors value to secure plan approval. Chapter 11 allows debtors to propose reorganization plans that deviate from strict priority if all impaired classes vote to accept the plan (consensual) or if the plan meets cramdown standards (non-consensual but "fair and equitable"). This creates leverage for junior creditors: threaten to vote no (blocking confirmation), demand gift from seniors in exchange for support.
Example: Company with $300M enterprise value, $200M secured debt, $150M unsecured bonds. Strict priority: secured gets $200M (100%), unsecured gets $100M (67%), equity gets zero. But equity holders control the debtor, can delay bankruptcy, threaten to pursue alternatives. Secured creditors, wanting quick exit, negotiate compromise: secured accepts $195M, unsecured gets $100M, equity receives $5M to support the plan. This "gift" of $5M from secured to equity violates absolute priority but speeds confirmation.
For distressed investors, this matters because recovery calculations based on strict waterfall analysis may underestimate actual outcomes. If you buy unsecured bonds calculating 67% recovery but final plan includes equity gift, your bonds might recover only 64% (the $5M gift comes from the pot that would go to unsecured). Conversely, buying equity that should be worthless under strict priority might yield small recovery through gifting.
Sourcetable can model these negotiated outcomes. Ask: "Compare recovery under strict priority vs negotiated plan where secured accepts $195M, unsecured gets $100M, equity gets $5M." AI shows: strict priority gives unsecured 67% ($100M of $150M), negotiated plan gives 67% but with $5M less to distribute (gift to equity), so unsecured actually gets $98M (65%). You can test different gifting scenarios to understand how negotiations affect your recovery range.
Fulcrum Security Analysis: Finding Where the Value Breaks in the Capital Structure
The "fulcrum security" is the debt class where enterprise value equals total claims—securities senior to the fulcrum recover fully, securities junior get partial or zero recovery, and the fulcrum itself gets fractional recovery. Identifying the fulcrum tells you where to focus investment attention: senior securities offer lower returns but higher safety, the fulcrum offers highest risk-adjusted returns (meaningful recovery with upside), junior securities are lottery tickets.
Take capital structure: $400M secured term loan, $250M unsecured notes, $100M subordinated debt, $50M preferred equity. Estimate enterprise value at $550M. The fulcrum: secured creditors get full $400M, leaving $150M for $400M in junior claims—unsecured notes are the fulcrum security (partial recovery), subordinated debt and preferred get zero. Buying unsecured notes at 40¢ implies 60% recovery ($600M EV), offering 50% return if base case $550M EV is conservative.
How do you identify the fulcrum when EV estimates have wide ranges?
Calculate fulcrum security across the EV range—where the fulcrum sits changes with assumptions. For the example above with $400M secured, $250M unsecured, $100M sub debt:
- $350M EV (low case): Secured is fulcrum (87.5% recovery), all juniors get zero
- $550M EV (base case): Unsecured notes are fulcrum (60% recovery), sub debt gets zero
- $750M EV (high case): Sub debt is fulcrum (100% unsecured recovery, sub debt gets zero, equity recovers)
This fulcrum shift is critical for position selection. If you believe EV is $550M-$750M (base to bull case), unsecured notes at 40¢ offer the best risk-reward: downside protected if EV only reaches $500M (50% recovery = 25% return), massive upside if EV hits $650M (100% recovery = 150% return). Secured debt at 95¢ offers limited upside (100% recovery = 5% return), subordinated debt at 5¢ is too risky (needs $750M+ EV just to break even).
Sourcetable performs fulcrum analysis automatically. Upload capital structure and ask: "Identify fulcrum security across EV range from $300M to $800M in $50M increments." AI generates table showing which security class is fulcrum at each EV level, implied recovery rates, and where the best risk-adjusted opportunities exist. You can also ask: "If unsecured notes trade at 40¢, what EV do I need to double my money?" Instant answer: "$650M EV gives 100% recovery (2.5x return on 40¢ cost), probability of reaching $650M based on comparables: 38%."
Event-Driven Trading: How Bankruptcy Milestones Move Distressed Securities Prices
Distressed securities don't trade on earnings—they trade on bankruptcy milestones. Each court filing, disclosure, or ruling provides new information about recovery values, causing sharp price movements. DIP financing approval indicates operational viability (+15-30% price move), plan filing shows creditor treatment (+25-50% move for securities in the money, -40-60% for securities out of the money), confirmation hearing provides near-final recovery (+10-20% move as uncertainty resolves). Active distressed investors monitor court dockets daily, modeling how each development affects recovery scenarios.
The challenge: bankruptcy proceedings generate hundreds of pages of filings weekly. A typical Chapter 11 produces 500-1,500 docket entries over 12-18 months, including schedules of assets and liabilities, disclosure statements, reorganization plans, creditor objections, sale motions, and fee applications. Extracting the information that matters for recovery analysis—updated asset valuations, creditor claims amounts, plan treatment terms—requires reading through legal documents and manually updating your models.
Which bankruptcy events create the largest trading opportunities?
Plan disclosure and confirmation are the highest-impact events because they reveal exactly who gets paid what. Before plan disclosure, you're estimating recovery based on asset values and assumed capital structure. When the plan files, you see actual treatment: unsecured noteholders get 95% of new equity (better than expected), subordinated debt gets 5% (worse than zero previously assumed), equity gets nothing (as expected). If unsecured notes were trading at 50¢ implying 65% recovery but the plan shows 95% equity worth 80¢, notes should jump to 75-80¢ immediately as the market reprices.
Real example: During Hertz bankruptcy, unsecured bonds traded at 35¢ pre-plan (market assumed 40-50% recovery based on distressed asset values). When the reorganization plan filed showing stronger-than-expected used car prices and equity treatment for unsecured creditors, bonds jumped to 65¢ in two days (+86% move). Confirmation hearing provided final validation, bonds reached 85¢ (+30% move from plan filing). Total move from filing to confirmation: 143% in 45 days.
Sourcetable helps monitor these events systematically. Upload your portfolio of distressed positions and ask: "Alert me to material docket entries: plan filings, sale motions >$50M, significant claim disputes, DIP amendments." The AI monitors public bankruptcy databases, flags relevant filings, and summarizes impact: "New claim filed by supplier for $18M—reduces unsecured recovery by 4%, from 62% to 58%." You can immediately ask: "Recalculate all my positions with updated claims total" and get revised recovery analyses in seconds.
Frequently Asked Questions
If your question is not covered here, you can contact our team.
Contact UsWhat's the minimum capital needed for distressed investing?
How long do distressed investments typically take to resolve?
What risks am I missing in recovery rate calculations?
Can I use distressed investing strategies for public companies not in bankruptcy?
How do I find distressed investment opportunities?
Should I buy debt or equity of distressed companies?
What legal expertise do I need for distressed investing?
