An LBO spreadsheet can show an attractive equity return while the business runs short of cash in year two. That usually happens when the model gives more attention to the exit multiple than to collections, capital spending, and debt service.
A useful leveraged buyout model starts with the operating business. Debt capacity follows from the cash it can generate under realistic conditions, including a period when performance disappoints.
Reconcile sources and uses
Show exactly how the acquisition is funded and where the money goes. Uses may include equity purchase proceeds, existing debt repayment, transaction fees, financing fees, and opening cash. Sources may include new debt, sponsor equity, and seller rollover.
Make the enterprise-value-to-equity-value bridge explicit. Keep assumed debt, cash, and working-capital adjustments consistent with the purchase agreement. A model can balance mathematically while still counting an item twice.
Translate earnings into cash
Forecast revenue and costs using the business’s operating drivers. Then account for cash taxes, capital expenditures, and changes in working capital. Depreciation is not a direct cash payment, but equipment replacement is. Similarly, revenue growth can consume cash if customers pay later than suppliers require payment.
Split maintenance investment from expansion plans where the evidence allows. Ask operations to review the assumptions. Deferring necessary repairs may improve a spreadsheet temporarily while making future performance less reliable.
Model each debt instrument separately
Include opening balances, draws, interest, amortization, optional repayments, and maturity. Floating-rate debt requires explicit rate assumptions and any contractual floor. Payment-in-kind interest adds to the balance rather than disappearing as a cost.
Subordinated or mezzanine financing may carry different payment, priority, and equity-linked terms. Read the documents before combining instruments into a single blended rate. Model covenant definitions separately from management’s reporting EBITDA when the definitions differ.
Make the downside case operational
The OCC’s leveraged lending handbook emphasizes realistic cash-flow assessment under different conditions. For a buyer, that means testing what happens when revenue falls, margins compress, collections slow, or borrowing costs rise.
A hypothetical business with $8 million of EBITDA, $2 million of cash interest, $1 million of cash taxes, $2 million of capital spending, and a $1 million working-capital outflow has $2 million left before principal repayments and other uses. EBITDA alone would overstate that repayment capacity.
Explain the source of the equity return
Separate earnings growth, debt repayment, and any change in valuation multiple. Test an exit multiple below the entry multiple. Include fees and the actual distribution waterfall where relevant. Report both cash-on-cash return and timing-sensitive measures so that one metric does not conceal the tradeoff.
- Does cash ever fall below the operating minimum?
- What happens at debt maturity if refinancing is unavailable?
- Which covenant has the least headroom?
- Which planned improvements require additional investment?
A strong model makes a difficult case understandable. It should help the investment team decide what risk it can fund, rather than making a predetermined purchase price appear affordable.