A distressed acquisition model in Excel is a cash-and-claims model that answers a simple question: what can we pay today to control an impaired business and still keep it alive through a rough path. A cash waterfall is the rulebook that decides who gets paid, when, and from which accounts. A “fulcrum” security is the slice of the capital structure most likely to convert into equity in a restructuring, because it sits at the edge of recovery.
If you build this like a standard LBO and call it a day, you’ll miss the point. In stress, the job is not to polish an equity IRR. The job is to avoid a mechanical failure: running out of cash, tripping a covenant, losing key contracts, while keeping enough upside to justify the control fight and the fees.
Why this Excel model is different (and what you get from it)
A distressed acquisition can mean four different things, and Excel needs to reflect which game you’re playing. You might buy the equity of a stressed company. You might buy the fulcrum credit and take the keys through a restructuring. You might buy assets out of an insolvency process or a carve-out. Or you might provide rescue financing with control rights that behave like ownership.
The boundary condition is control over cash and collateral. If you cannot control the cash waterfall, you are modeling a trade, not an acquisition. That one distinction changes the entire spreadsheet.
To keep the model honest, use one rule of thumb: if you can’t point to the exact bank account and document section that governs a cash movement, treat that cash as unavailable until proven otherwise. This “cash access discount” is a practical edge in real deals, because many distressed plans fail on timing, not on headline value.
What “winning” looks like when time is compressed
Stress compresses time and pushes stakeholders into corners. Management wants runway and retention economics. Existing lenders want par takeout or maximum recovery with the least legal spend. Trade creditors want payment certainty and sometimes have leverage through critical vendor status. Regulators and pension trustees can act like senior claimants even if the cap table says otherwise.
In Excel, these incentives become constraints that cap your bid. Liquidity runway sets a hard ceiling. Minimum cash and borrowing base availability set another. Consent thresholds and closing conditions determine whether the deal is even executable. Legal limits on priming liens or stripping covenants decide whether your proposed capital structure can survive.
Control premiums also behave differently here. You’re often paying for the right to stop cash leakage, reset contracts, reject liabilities in court, or rationalize capex and working capital. Those are not “multiple expansion” stories. Model them as cash flow deltas with timing, probability, and implementation cost. Otherwise, you’re just writing down hopes.
Define the transaction perimeter before you touch formulas
Start with a one-page transaction perimeter sheet and treat it like a contract with yourself. State what you are buying, which liabilities come with it, which contracts you assume, and which approvals block closing. If you don’t lock this, the model will drift into consolidation fantasies.
A few perimeter questions drive the entire build. First, is this a going-concern equity purchase, an asset purchase, or a credit-to-own path where ownership comes later? Next, is the transaction inside a court process or outside? Then, will you hold the target in an SPV or fold it into an existing group? Finally, which licenses or customer contracts have change-of-control triggers, and can you get waivers in time?
In stress, value often moves through assumed liabilities rather than headline cash price. Your model needs to treat assumed liabilities as part of enterprise value, even if accounting puts them in different boxes. When someone says, “We’re only paying $50 million,” ask what liabilities they’re quietly agreeing to carry. The cash doesn’t care about labels.
Excel architecture that prioritizes survival over optics
Build around liquidity, not GAAP optics. You can include three statements, but the controlling schedule is a weekly or monthly liquidity bridge tied to the actual cash-control mechanics. If the business is high-burn or ABL-driven, weekly is often the honest choice.
A workable structure looks like this: inputs and scenario control (base, downside, severe, plus toggles for close date, court timeline, and financing availability); sources and uses that show cash and non-cash consideration; an opening balance sheet at close; a simple operating model; a liquidity and waterfall tab that dictates whether you live or die; separate debt schedules by tranche; covenants and triggers; returns and recoveries; and checks and audit flags.
Keep formulas readable. Avoid macros. In these deals, the spreadsheet gets pushed across the table to lenders and advisers under time pressure. If they can’t follow it, you lose time, and in stress, time is money and leverage.
Scenario discipline: don’t “average” distress
Scenario design should reflect discrete events, not smooth sensitivities. For example, a single “customer pause” can shift collections timing and collapse ABL availability even if revenue is only slightly down. Therefore, pair your downside case with a timing case: slower receipts, faster payables pressure, and delayed close.
If you want a simple framework, use three scenarios and make them meaningfully different: base (stabilization works), downside (stabilization is late), and severe (a restructuring happens). Then, attach an explicit probability to each and calculate an expected value that you can discuss with an investment committee.
Sources and uses: where the negotiation actually happens
The sources-and-uses schedule is not decoration. It is where the deal is priced and where the hard conversations show up.
On the uses side, include the obvious: purchase price, debt repayment, fees. Then include the items that usually break the plan: cure costs for assumed contracts and leases, professional and court costs, working capital peg and escrow, make-wholes and call premiums, default interest if triggered, and a restructuring reserve funded at close if lenders require it.
On the sources side, show new equity and each new debt tranche. If you are credit bidding or exchanging debt for equity, show the value as a non-cash source that reduces cash outlay. If any existing debt rolls, show it explicitly and confirm it’s permitted.
Then model “hidden consideration” in plain sight: pension deficits, environmental remediation, customer penalties tied to service failures, and purchase price adjustments. Omitting these does not make them go away. It just turns your bid into a future apology.
Opening balance sheet: think like a creditor
In stress, the opening balance sheet is about collateral and near-term bills. Break out unrestricted cash versus restricted cash. Show eligible receivables and inventory if there’s an ABL. Separate fixed assets that support term debt from intangibles that may be excluded from collateral. Identify priority claims and structurally senior liabilities.
If cash is commingled across entities, apply a haircut until you have treasury control. That haircut is not pessimism; it’s a timing assumption. Treasury control can take weeks, and those weeks can decide who runs the process.
Structure matters. In an asset purchase, the opening balance sheet is “newco” and only includes purchased assets and assumed liabilities. In an equity purchase, legacy liabilities stay unless you refinance or settle them. Many models fail because they blend these two worlds and end up with a balance sheet that no lawyer would recognize.
Operating model: keep it simple and cash-focused
Precision is expensive, and distressed data is often unreliable. Build a parsimonious operating model that explains cash burn, stabilization timing, and sensitivity to slippage. If management hands you a 300-line forecast, treat it as a starting point, not a truth.
Focus on the lines that usually drive outcomes: revenue run-rate and churn; gross margin, including supplier repricing and expedited freight; opex split between “keep the lights on” and discretionary spend; capex with a real maintenance level; and working capital using a simple cash conversion cycle (DSO, DIO, DPO) with a stress shock for tightened supplier terms and slower customer payments.
Model restructuring costs as cash, not EBITDA add-backs. Put severance timing, lease exits, professional fees, and system cutovers where they belong: in the liquidity schedule, with dates. If your thesis depends on cost-out, show when savings arrive and what the implementation costs. A cost save in month 18 does not pay payroll in month 2.
Liquidity schedule: the heart of the distressed acquisition model
Liquidity is the main output. Build a bridge that starts with beginning unrestricted cash and walks to ending unrestricted cash, line by line: operating cash before interest, cash interest by tranche, mandatory amortization and fees, capex, one-time items, working capital changes, revolver draws and repayments subject to availability, and the ending cash balance.
Enforce a hard no-negative-cash rule. If cash goes below zero, force a revolver draw or show a default. Do not let Excel “solve” a deficit with a circular reference that hides the problem. If the plan needs more money, the model should say so.
Add “days of liquidity” as a governance metric. It tells you when lenders gain leverage and when you need an amendment. It also keeps the team honest about how close the cliff really is.
ABL and revolvers: availability is what matters
In these deals, the commitment size can be a mirage. Model availability as the minimum of commitment and borrowing base, net of reserves. Put the borrowing base on its own tab and feed availability into the liquidity schedule.
Borrowing base mechanics usually include eligible receivables times an advance rate, net of dilution reserves, concentration limits, and ineligibles. Inventory eligibility is its own world: obsolescence reserves, appraised values, and eligibility cuts for slow-moving items. Foreign receivables, intercompany balances, and aged AR often get excluded. Model those exclusions explicitly.
Include a toggle for springing cash dominion. When dominion is active, collections sweep to the lender and the company’s access to cash slows down. That creates operational friction and can worsen performance. It’s a timing issue with real consequences.
One aside: better EBITDA does not necessarily improve ABL availability. Collateral drives borrowing base, not profitability. A turnaround can still fail if receivables shrink, customers pay slower, or inventory becomes ineligible.
Debt tranches: legal terms become cash mechanics
Give each tranche its own schedule. At a minimum, input principal, OID, index and margin, floors, default interest, cash-pay versus PIK rules, amortization, mandatory prepayments, fees, call protection, maturity, extension options, and security and intercreditor position. For a deeper build-out of tranche behavior, see debt scheduling in financial modeling.
Model PIK carefully. It saves cash now and adds principal that must be carried later, increasing future interest and leverage. Sometimes PIK is the bridge that keeps the company alive. Sometimes it’s the bridge to a heavier restructuring. The model should show both outcomes clearly: near-term liquidity relief and longer-term deleveraging burden.
Even if covenants are waived, include a simple cash interest coverage metric. Reality does not waive itself.
Covenants, triggers, and the cash waterfall (model the forcing functions)
Focus on what can accelerate a crisis: minimum liquidity covenants, borrowing base deficiencies, springing FCCR tests in ABL structures, reporting requirements, and cross-defaults. A “MAC” clause is hard to quantify, but you can model operational thresholds that typically drive lender behavior: missed milestones, large customer losses, or repeated forecasting misses.
Do not let covenants sit as passive ratios on a dashboard. If a covenant is breached, trigger a flag that flows into liquidity as an amendment fee, a margin step-up, tighter baskets, or restricted draws. That forces the model to price the cost of “just getting a waiver.” Waivers are not free, and they rarely arrive early.
Model payment priority the way the documents and the bank accounts enforce it. A typical going-concern order is taxes and payroll, revolver/ABL interest and fees, critical vendors and logistics, secured term debt interest, capex subject to baskets, restructuring spend subject to an agreed budget, and then anything optional, usually blocked.
If there’s a court process and DIP financing, model it as the top claim with its fees, milestones, and roll-up features. A DIP with tight milestones can create a “deadline default” even if cash is fine. Milestones are control instruments, and they should be treated as such.
Returns and valuation: use recovery logic, not one exit multiple
Equity IRR can matter if you are buying equity or equitizing credit. But in stress, recoveries across the capital structure often matter more than one equity number.
Match outputs to the deal path. For an equity purchase, show returns based on exit enterprise value, deleveraging, and distributions with a credible timeline. For credit-to-own, show lender IRR based on purchase price, coupons, fees, and recovery value at equitization or exit. For asset deals, show unlevered cash flows and resale value with reinvestment capex explicit.
Include a downside case where stabilization fails and a restructuring happens. Build a simplified recovery waterfall based on collateral value and claim priority. This is where intercreditor terms start to matter in dollars, not in legal prose.
Avoid leaning on a single exit multiple. Use at least two anchors: a conservative EBITDA multiple and a collateral-based valuation where relevant. In stress, the buyer set changes, and liquidity buyers price differently than strategic buyers.
Timeline, gating items, and kill tests (make “no” an output)
Regulatory approvals, consent processes, and court timelines should enter the model as delays and costs. Add drop-dead dates, ticking fees, extension costs, and operating burn during the delay. If the plan requires a quick close, a 60-90 day approval process can wipe out your cushion.
A good model should also surface reasons to say no. Build kill tests that are explicit, visible, and hard to argue with.
- Liquidity cliff: Minimum liquidity breaches in the base case within two quarters, or “days of liquidity” falls below your governance threshold.
- ABL collapse: Availability falls due to AR aging, concentration limits, or inventory ineligibility even if EBITDA is improving.
- Non-waivable consents: Change-of-control clauses in key contracts cannot be waived in time, killing execution certainty.
- Fee overload: Professional fees, cure costs, and call premiums consume a large share of value before stabilization.
- Cash control delay: Cash cannot be ring-fenced quickly due to entity complexity or banking constraints, so accessible cash is meaningfully lower than reported cash.
Automate the flags on a summary page. If a flag trips, force a specific mitigation assumption with a cost and a timeline. If you can’t write that mitigation in plain language, you probably don’t have it.
Closeout and record hygiene
Archive the model package and supporting files with an index, version history, Q&A log, user list, and full audit logs. Hash the final files and store the hash with the archive so you can prove integrity later. Apply a retention schedule that matches legal and regulatory requirements, then direct the vendor to delete remaining copies and provide a destruction certificate. If a legal hold applies, it overrides deletion until counsel releases it.
Key Takeaway
A distressed acquisition model succeeds when it treats liquidity, control, and document-driven cash movement as first-class outputs. Build the spreadsheet so it can fail loudly on cash access, borrowing base mechanics, covenant triggers, or timeline slippage, and you will price the deal with realism instead of hope.
Sources
Live Source Verification: Selected sources below are from stable publisher domains and evergreen reference pages commonly accessible without paywalls. Links were chosen to support definitions and mechanics referenced in the article.