LBO Model: Build One in 60 Minutes (With Worked Example)

A leveraged buyout (LBO) model is a financial projection of an acquisition financed primarily with debt. It calculates the equity returns to the PE fund based on assumptions about the target's operating performance, the financing structure, and the eventual sale.

The LBO model is the central tool in private equity. Every deal that reaches investment committee has an LBO model behind it. Junior analysts spend months becoming fluent in the structure, and the structure is remarkably standardized across firms.

This article covers the components of an LBO model, the worked example of acquiring "Atlas Distribution" — a fictional mid-market US distribution business — at $500M enterprise value, sources and uses of capital, the debt schedule, the operating projections, the returns calculation, sensitivity analysis, and common modeling mistakes.

Components of an LBO model

An LBO model has five core sections:

1. Transaction assumptions: purchase price, entry multiple, financing mix, fees.
2. Sources & uses: where the money comes from, where it goes.
3. Operating projections: revenue, EBITDA, free cash flow over the holding period.
4. Debt schedule: how debt is paid down over time.
5. Returns analysis: equity returns to the PE fund at exit.

Each section feeds the next. The operating projections drive the debt paydown, which drives the equity value at exit, which determines returns.

Worked example: Atlas Distribution

Atlas Distribution is a fictional mid-market US distribution company. Year 0 (LTM = last twelve months) data:

• Revenue: $250M
• EBITDA: $40M (16% margin)
• EBITDA growth (historical): 6% per year
• Net Working Capital: 12% of revenue
• CapEx: 2% of revenue (asset-light distribution business)
• Tax rate: 25%

The PE fund "Atlas Capital" is evaluating an acquisition.

Transaction assumptions:

• Entry EV/EBITDA multiple: 10.0x → Enterprise Value = $40M\times 10=\ast \ast$400M**
• Transaction fees: 2% of EV = $8M
• Existing debt to refinance: $50M
• Financing mix: 55% debt / 45% equity (standard mid-market leverage)
• Senior debt rate: 6.5%
• Mezzanine debt rate: 9.5%
• Equity sponsor IRR target: 22%+

Wait — let me adjust. The pillar mentioned $500M enterprise value. Let me size this more in line:

Revised: EBITDA = $50M,EV=$500M (10x). Let me re-set.

• Revenue: $300M
• EBITDA: $50M (17% margin)
• Entry EV/EBITDA: 10.0x → EV = $500M
• Transaction fees: 2% of EV = $10M
• Existing debt to refinance: $80M
• Total uses: $500M+$10M + $80M=$590M

Sources & uses

The Sources & Uses table shows where money comes from and where it goes in the transaction.

Uses of cash:

Sources of cash (the financing):

So Atlas Capital is putting in $323Mofequity\ast \ast andusing\ast \ast$275M of debt (5.5x leverage on $50M EBITDA — high but not extreme for mid-market).

Operating projections (5-year hold)

Atlas Capital's investment thesis: grow EBITDA from $50Mto$75M over 5 years through:

• Organic revenue growth (5–7%)
• Margin expansion through pricing and cost reduction (200 bps)
• Two tuck-in acquisitions in years 2 and 3 (adding $5M EBITDA total)

For simplicity in the modeling, I'll target EBITDA of $75M at exit (year 5) — slightly below the optimistic case to be realistic.

Free cash flow projection:

For each year, FCF = EBITDA − D&A × (tax rate) − CapEx − $\Delta$NWC + (interest tax shield benefit handled in debt schedule)

Approximating cash flow available for debt service after tax payments:

(Cash taxes account for the interest tax shield, which I'm building into a separate debt schedule. These are approximate; the Excel template has the precise calculation.)

Debt schedule

The debt schedule tracks how debt balances change each year.

Senior debt ($225M starting, mandatory amortization 5% per year, all excess cash flow sweep against senior debt until paid):

Mezzanine debt ($50M starting, no mandatory amortization, PIK-style accrual of 9.5%):

(Wait — pure PIK mezzanine of 9.5% would grow to a problematic balance. More typical structure: cash interest 6% + PIK 3.5%. Let me adjust.)

Revised mezz: 6% cash interest + 3.5% PIK accrual, no mandatory amortization, balloon at maturity.

So mezzanine grows from $50Mto$59M over 5 years through PIK accrual.

Total debt at end of year 5: Senior $60M+Mezz$59M = ~$119M.

Down from $275M at close — substantial deleveraging.

Exit analysis

Atlas Capital exits in year 5. Assume exit at the same multiple as entry (10x EBITDA) — a no multiple expansion case, which is the conservative assumption.

• Year 5 EBITDA: $75M
• Exit EV: $75M\times 10=\ast \ast$750M**
• Less: remaining debt: $119M
• = Equity proceeds: $631M

Equity invested: $323M\ast \ast Equityatexit:\ast \ast$631M

MOIC (Multiple on Invested Capital): 631 / 323 = 1.95x

IRR (Internal Rate of Return over 5 years): approximately 14.3%

This is below Atlas Capital's 22% IRR target. The deal at these assumptions is not attractive.

What can fix the deal?

Three levers can improve returns:

Lever 1 — Pay less. If Atlas Capital could buy at 9x instead of 10x EBITDA, the equity check would be smaller, and returns would be higher.

Lever 2 — Grow EBITDA more. If EBITDA grows from $50Mto$85M instead of $75M (more aggressive thesis), exit value increases.

Lever 3 — Multiple expansion. If Atlas Capital can sell at 11x or 12x EBITDA (because the business is more valuable as a platform than as an independent), exit value increases substantially.

Let me run the aggressive case: pay 10x, grow EBITDA to $85M, sell at 11x.

• Exit EV: $85M\times 11=$935M
• Less debt: $119M
• Equity proceeds: $816M
• MOIC: 816 / 323 = 2.53x
• IRR: ~20.5%

Closer to target. But this requires both successful operational thesis and successful exit-multiple expansion.

In practice, PE firms model multiple scenarios (downside, base, upside) and underwrite to the base case. The IRR threshold is typically 20%+ for the base case to greenlight a deal.

Sensitivity analysis

The critical sensitivities for any LBO:

Sensitivity 1 — Entry vs. Exit Multiple:

The lesson: entry multiple matters enormously. Buying at 11x with no multiple expansion makes the deal unattractive even with operational success.

Sensitivity 2 — EBITDA Growth:

If EBITDA grows at 8% per year instead of 8.5%, IRR drops by roughly 200 basis points. Operating execution matters but is less consequential than purchase price.

Common LBO modeling mistakes

Mistake 1 — Optimistic exit multiple assumptions.

The temptation: model 1–2 turns of multiple expansion to make the deal work. The discipline: assume flat multiples in the base case. Multiple expansion should be an upside lever, not a required lever.

Mistake 2 — Forgetting working capital growth.

A growing business needs more working capital. Failing to model this overstates available cash flow and understates the equity check needed for working capital growth post-close.

Mistake 3 — Ignoring CapEx for growth.

The same trap. Operating CapEx must support the projected revenue growth.

Mistake 4 — Mismodeling mezzanine PIK.

PIK interest accrues to the debt balance and creates a balloon at maturity. Models that treat all interest as cash overstate cash flow and understate ending debt.

Mistake 5 — Building debt schedule before operating projections.

The operating projections drive cash available for debt service. Building the debt schedule independently can create internally inconsistent models.

Mistake 6 — Forgetting transaction fees.

Fees (M&A advisory, financing, legal, due diligence) typically run 2–4% of EV. Easy to forget; substantially affects sources & uses.

Mistake 7 — Treating debt as static.

In a real LBO, the company refinances debt periodically. Mid-deal recapitalizations are common. Models should at least allow scenario analysis on refinancing.