LBO Modeling: A Practical Walkthrough

A leveraged buyout model looks daunting, but at its core it answers one question: if we buy this company with a mix of debt and equity, run it for a few years, and sell it, what return do we earn on our equity? Everything else is detail. Here's the anatomy.

Sources and uses

Every LBO starts with the transaction structure.

• Uses are what you're paying for: the purchase enterprise value, refinancing of existing debt, transaction fees, and any cash to the balance sheet.
• Sources are how you fund it: new debt tranches plus sponsor equity as the plug.

The two sides must balance. Equity is the last item you solve for — it's what's left after debt covers as much as prudently possible.

A note on entry multiple

Entry EV is usually expressed as a multiple of EBITDA. The gap between what you pay and what the business can support in leverage determines your equity check. Overpay and your returns compress no matter how well you operate.

The operating model

Project the business over the hold period, typically five years:

• Revenue growth grounded in a defensible thesis, not a hopeful ramp.
• Margin assumptions tied to specific operating levers.
• Capex and working capital, because they consume the cash you need for debt paydown.

The output that matters most is free cash flow available for debt service. That's the engine of deleveraging.

The debt schedule

This is where LBOs earn their name. For each tranche, track:

• Beginning balance
• Mandatory amortization
• Cash sweep (optional prepayment from excess cash)
• Interest expense
• Ending balance

The cash sweep is the mechanism that turns operating cash into equity value: every dollar of debt repaid is a dollar that accrues to you at exit. Model tranches in priority order — senior debt gets paid before subordinated.

The returns bridge

At exit, you assume an exit multiple (often the entry multiple, sometimes with modest expansion or contraction) applied to exit-year EBITDA. Then:

1. Exit EV minus remaining net debt equals exit equity value.
2. Compare exit equity to entry equity for your multiple of invested capital (MOIC).
3. Layer in timing for the IRR.

The three drivers of return

A clean LBO model makes the return drivers explicit:

• EBITDA growth — growing the business, from revenue and margin.
• Multiple expansion — selling at a higher multiple than you bought (the least reliable driver; never underwrite to it).
• Deleveraging — paying down debt with operating cash.

Sensitivity is the point

A single-point answer is worthless. Build sensitivity tables across entry multiple, exit multiple, and EBITDA growth. The goal isn't to prove the deal works at your base case — it's to understand where it breaks.

Common mistakes to avoid

• Circular reference panic. Interest depends on debt, which depends on cash flow, which depends on interest. Enable iterative calculation or use a debt-schedule switch.
• Underwriting multiple expansion. If your returns only work when you sell higher than you bought, you don't have a deal — you have a bet on the market.
• Ignoring the downside. Model a recession-case revenue decline and check whether you breach covenants. If a modest miss wipes out equity, the structure is too aggressive.
• Forgetting management equity and fees. Rollover equity, management incentive pools, and transaction costs all dilute sponsor returns.

The takeaway

The mechanics are learnable in an afternoon; the judgment is not. A model is only as good as its assumptions, and the discipline of a great investor is refusing to make the model say what the deal needs it to say.