LBO Modelling: Building a Leveraged Buyout Model from Scratch

The Leveraged Buyout (LBO) is the flagship transaction of Private Equity. Understanding its modeling is essential for any professional working in M&A, PE, or corporate finance. This guide walks you through building a complete LBO model.

What is an LBO?

An LBO involves acquiring a company using a significant proportion of debt (typically 50% to 70% of the acquisition price). The goal is to maximize returns for equity investors through financial leverage.

Characteristics of a Good LBO Candidate

• Stable, predictable cash flows: The company must be able to service its debt
• Defensive market position: Niche leadership, barriers to entry
• Operational improvement potential: Improvable margins, optimizable costs
• Tangible assets: Serve as collateral for the debt
• Strong management: Ability to execute the value creation plan

Step 1: Sources & Uses

The Sources & Uses table is the starting point of every LBO model. It answers a simple question: how much does the acquisition cost and how is it financed?

Uses

Enterprise Value (EV)         €500M
+ Transaction fees              €15M  (3% of EV)
+ Financing fees                €10M  (2% of debt)
+ Minimum cash on balance        €5M
= Total Uses                  €530M

Sources

Senior Debt (Term Loan A)     €150M  (3.0x EBITDA)
Senior Debt (Term Loan B)     €100M  (2.0x EBITDA)
Mezzanine / High Yield         €50M  (1.0x EBITDA)
= Total Debt                  €300M  (6.0x EBITDA)
Equity (Sponsor)              €230M
= Total Sources               €530M

Key ratio: Total leverage (Debt / EBITDA) typically ranges between 4x and 7x depending on market conditions and the target's risk profile.

Step 2: Debt Structure

Each debt tranche has specific characteristics that affect the model:

Term Loan A (TLA)

• Amortization: Progressive (20-25% per year)
• Rate: EURIBOR + 200-300 bps
• Maturity: 5-6 years
• Seniority: Highest

Term Loan B (TLB)

• Amortization: Bullet (repaid at maturity)
• Rate: EURIBOR + 300-450 bps
• Maturity: 6-7 years
• Seniority: Senior, but subordinated to TLA

Mezzanine / High Yield

• Amortization: Bullet + PIK (Paid-in-Kind) possible
• Rate: 8-12% (cash + PIK)
• Maturity: 7-8 years
• Seniority: Subordinated

Step 3: Financial Projections

Financial projections are the heart of the model. They determine the company's ability to repay its debt.

Income Statement

Project over 5 to 7 years:

• Revenue: Organic growth + potential bolt-on acquisitions
• EBITDA: Apply planned operational improvements
• D&A: Linked to the investment plan
• Finance charges: Calculated from the debt schedule
• Taxes: Effective rate, considering the debt tax shield

Cash Flow Statement

Cash flow determines the pace of deleveraging:

EBITDA
- Cash taxes
- Change in working capital
- CAPEX
- Cash interest expense
= Free Cash Flow to Firm (FCFF)
- Mandatory debt repayment
= Cash available for prepayment (cash sweep)

Step 4: Return Calculations

LBO returns are primarily measured by IRR (Internal Rate of Return) and MOIC (Multiple on Invested Capital).

Exit Scenarios

Define an exit multiple (EV/EBITDA) and calculate:

Exit Enterprise Value = EBITDA(exit) × Exit Multiple
- Residual Net Debt
= Exit Equity Value

IRR (Internal Rate of Return)

Typical targets:

• Minimum IRR: 20-25%
• Target IRR: 25-30%+

MOIC (Multiple on Invested Capital)

MOIC = Exit Equity Value / Equity Invested

Typical targets:

• Minimum MOIC: 2.0x
• Target MOIC: 2.5x - 3.0x+

Value Creation Levers

1. Deleveraging: Debt repayment mechanically increases equity value
2. EBITDA growth: Organic profit increase
3. Multiple expansion: If exit multiple > entry multiple
4. Dividends / recapitalizations: Cash distributions during the holding period

Step 5: Sensitivity Analysis

Key Variables to Test

• Entry multiple vs. exit multiple
• Revenue growth vs. EBITDA margin
• Initial leverage vs. interest rate
• Exit year (3, 4, 5, 6, 7 years)

Classic Scenarios

Conclusion

LBO modeling is a rigorous exercise combining financial analysis, capital structure understanding, and strategic vision. Mastering this exercise is essential for any career in Private Equity or M&A.

Our LBO Model Excel template integrates all these components with a dynamic debt schedule, multiple exit scenarios, and automated sensitivity analysis.