The leveraged buyout model is one of the most important and frequently tested models in investment banking and private equity. If you can explain an LBO conceptually, that is a great start, but actually building one from scratch demonstrates a much deeper level of understanding. This guide walks through every step of building an LBO model, from the initial transaction assumptions to the final returns analysis.
What Is an LBO Model?
An LBO model projects the financial performance of a company after it has been acquired using a significant amount of debt. The model starts with the purchase price, lays out how the deal is funded (the “sources and uses”), projects the company’s cash flows over a hold period (typically 5 years), models how debt is paid down, and calculates the return to the private equity sponsor when the company is eventually sold.
The key output is the internal rate of return (IRR) and the multiple of money (MOIC) to the equity investor. These metrics tell the sponsor whether the deal generates sufficient returns to justify the investment.
Step 1: Set Up the Transaction Assumptions
Every LBO model starts with the basic deal parameters. You need to establish:
- Purchase price. This is typically expressed as an EV/EBITDA multiple applied to the target’s LTM (last twelve months) or forward EBITDA. For example, if the company has $100 million of EBITDA and the purchase multiple is 10x, the enterprise value is $1 billion.
- Transaction fees and expenses. Include advisory fees, financing fees, and other transaction costs. These are typically modeled as a percentage of the enterprise value or as fixed dollar amounts.
- Existing debt. Any existing debt on the target’s balance sheet must be refinanced or assumed as part of the transaction. This affects total funding needs.
Step 2: Build the Sources and Uses Table
The sources and uses table is the foundation of the LBO. It answers two questions: how much money is needed, and where does it come from?
Uses of Funds
- Purchase of equity (enterprise value minus existing debt assumed, or equity value)
- Refinancing of existing debt
- Transaction fees and expenses
- Financing fees (typically capitalized and amortized)
Sources of Funds
- Senior secured debt (term loans)
- Subordinated or mezzanine debt
- High yield bonds or notes
- Sponsor equity (the “plug”, whatever is left after debt)
- Rollover equity from management (if applicable)
Total sources must equal total uses. The sponsor equity is typically the balancing item: it is the residual after all debt capacity has been maximized. The ratio of debt to total capitalization (leverage) is one of the most important parameters in the model. Higher leverage means less equity invested, which boosts returns if the deal goes well, but also increases risk.
Step 3: Build the Operating Model
The operating model projects the company’s income statement and key cash flow items over the hold period. This is essentially a simplified version of a three-statement model, focused on the metrics that matter most for the LBO.
Key Projections
- Revenue growth. Project revenue for each year of the hold period based on your assumptions about organic growth, pricing, volume, etc.
- EBITDA margins. Apply margin assumptions to get EBITDA. Consider whether the sponsor plans to improve margins through cost-cutting or operational improvements.
- Capital expenditures. Model maintenance capex (required to sustain operations) and any growth capex separately.
- Changes in net working capital. Project how working capital will change as the business grows. This is often modeled as a percentage of revenue or revenue growth.
- Taxes. Apply the appropriate tax rate to taxable income (EBITDA minus D&A minus interest expense).
The end product of the operating model is free cash flow available for debt repayment in each period.
Step 4: Build the Debt Schedule
The debt schedule is the heart of the LBO model. It tracks each tranche of debt, calculates interest expense, and models debt repayment over time.
Debt Tranches
A typical LBO capital structure includes multiple tranches of debt, each with different terms:
- Revolving credit facility (revolver). A flexible line of credit that can be drawn and repaid. Typically used as a liquidity cushion rather than permanent financing.
- Term Loan A. An amortizing loan with scheduled principal payments. Lower interest rate due to senior secured status.
- Term Loan B. Minimal amortization (typically 1% per year) with a bullet payment at maturity. Common in leveraged finance structures.
- Senior notes / high yield bonds. Unsecured debt with no amortization: all principal due at maturity. Higher interest rate to compensate for subordination.
- Mezzanine debt. The most expensive and most subordinated layer of debt. May include PIK interest or equity warrants.
Cash Flow Sweep
After making all required debt payments (mandatory amortization and interest), any remaining free cash flow is used to pay down additional debt. This is called the “cash flow sweep” or excess cash flow sweep. In the model, this cash is typically applied to the most expensive debt first (to minimize total interest expense) or to whichever tranche the credit agreement specifies.
Interest Expense Calculation
Interest expense for each tranche is calculated based on the average or beginning balance multiplied by the interest rate. This creates a circularity: interest expense reduces net income and free cash flow, which affects how much debt can be repaid, which affects the debt balance, which affects interest expense. Most LBO models handle this with a circular reference toggle or by using the beginning balance for interest calculations to avoid the circularity entirely. For more on this, see our guide on circular references in financial models.
Step 5: Build the Returns Analysis
The returns analysis is the final and most important output of the LBO model. It calculates how much money the sponsor makes when the company is sold at the end of the hold period.
Exit Enterprise Value
The exit value is calculated by applying an exit multiple to the company’s projected EBITDA in the exit year. For example, if Year 5 EBITDA is $150 million and the exit multiple is 10x, the exit enterprise value is $1.5 billion. Most models assume the exit multiple equals the entry multiple, though you should sensitize this assumption.
Exit Equity Value
Subtract the remaining net debt at exit from the exit enterprise value to get the equity value. This is the amount returned to the equity holders (primarily the PE sponsor).
IRR Calculation
The IRR is calculated using the XIRR function in Excel, with the initial equity investment as a negative cash flow at time zero and the exit equity proceeds as a positive cash flow at the exit date. Any interim dividends or recapitalizations would also be included. Most PE firms target IRRs in the range of 20-25%+, though this varies by strategy and market conditions.
Multiple of Money (MOIC)
MOIC is simply exit equity proceeds divided by initial equity invested. A 2.0x MOIC means the sponsor doubled their money. While IRR accounts for the time value of money, MOIC tells you the absolute return regardless of timing.
Step 6: Sensitivity Analysis
No LBO model is complete without sensitivity tables. The most common sensitivities include:
- Entry multiple vs. exit multiple. Shows how returns change if the company is bought or sold at different valuations.
- Entry multiple vs. EBITDA growth. Shows the interplay between purchase price and operational performance.
- Leverage vs. returns. Demonstrates how different capital structures affect IRR and MOIC.
Build these using Excel’s DATA TABLE function (under What-If Analysis) for two-variable sensitivity tables. These are standard in every LBO presentation and are commonly tested in investment banking interviews.
What Drives Returns in an LBO?
Understanding the key return drivers helps you build better models and answer interview questions more effectively. Returns in an LBO come from three sources:
- EBITDA growth. If the company grows its earnings, the exit value will be higher than the entry value (assuming constant multiples).
- Multiple expansion. If the company is sold at a higher multiple than it was purchased at, that creates additional value. However, assuming multiple expansion is generally considered aggressive.
- Debt paydown. As the company uses its cash flows to repay debt, a larger share of the enterprise value accrues to equity holders. This is the core mechanical advantage of leverage.
In interviews, you should be able to articulate how changes in each of these drivers affect the sponsor’s returns. For example: “If EBITDA grows faster than expected, more cash is available for debt paydown, which increases the equity value at exit and boosts both IRR and MOIC.”
Common Interview Questions About LBO Models
LBO-related questions come up frequently in Superday interviews, especially for banks with strong leveraged finance or sponsor coverage groups. Here are some common ones:
- “Walk me through an LBO model.”: Start with the sources and uses, explain the operating projections, walk through the debt schedule, and end with the returns analysis.
- “What makes a good LBO candidate?”: Stable and predictable cash flows, low capex requirements, strong market position, potential for operational improvements, and a business model that can support significant leverage.
- “How does increasing leverage affect returns?”: More leverage means less equity invested. If the deal performs well, IRR goes up because you are earning the same dollar return on a smaller equity base. But more leverage also increases risk: if cash flows underperform, the company may struggle to service its debt.
- “What is the difference between IRR and MOIC?”: IRR is time-weighted and accounts for when cash flows occur. MOIC is the absolute multiple regardless of timing. A deal with a 3x MOIC over 3 years has a much higher IRR than a 3x MOIC over 7 years.
For more on technical interview preparation, check out our Technical Cheatsheet and free course.
Want Personalized Interview Coaching?
If you are serious about breaking into investment banking, the best thing you can do is work with someone who has been through the recruiting process and knows exactly what top banks are looking for. At Wall Street Mastermind, we have helped over 2,500 students land offers at every bulge bracket and elite boutique bank on Wall Street. Book a free strategy call to learn how we can help you prepare for your interviews and maximize your chances of landing the offer.
Related Articles
- How to Explain an LBO in an Interview
- Leveraged Finance: Complete Guide
- Building a Three-Statement Financial Model: Complete Guide
- How to Calculate Unlevered Free Cash Flow
- Circular References in Financial Models
- Valuation Multiples: EV/EBITDA, P/E, and More
Follow Wall Street Mastermind
Stay up to date with the latest investment banking recruiting tips, technical guides, and career advice:
- YouTube
- TikTok
- X (Twitter)
- Podcast: Apple Podcasts | Spotify | SoundCloud
