# LBO Model Example Build a leveraged buyout model with debt tranches, repayment logic, cash flow generation, and sponsor return analysis in a cleaner professional structure. - Canonical: https://finamodel.com/examples/lbo-model - Excel download: https://finamodel.com/templates/lbo.xlsx - Category: Private Equity - Model type: Valuation - Difficulty: Advanced - Audiences: Bankers & advisors, Fund managers, PE Analysts, Investment Bankers, Deal Teams, M&A Advisors - Tags: lbo, leverage, pe, return-analysis, debt-structure ## Overview A Leveraged Buyout (LBO) Model structures a private equity acquisition with optimized debt and equity contributions to maximize sponsor returns. The model simulates entry valuation, debt stack composition (senior, subordinated, and mezzanine), operational performance projections, and exit proceeds to compute cash-on-cash multiple and IRR to sponsors. It explicitly models working capital, capex, mandatory and optional debt paydown, and EBITDA-based covenant compliance. A typical middle-market LBO targets 20-25% levered IRR over a 4-6 year hold with 2.5-3.5x cash-on-cash return. The three-statement core builds revenue forecasts (top-down or bottom-up), margins by segment, and EBITDA generation to feed the debt waterfall. The Debt Schedule computes interest expense and mandatory amortization on each tranche; optional paydowns use excess cash flow to deleverage and improve DSCR. The Returns Sheet calculates entry multiple (EV/EBITDA), exit multiple scenarios (upside/base/downside), and the resulting equity IRR and multiple across sensitivities. Debt covenant tracking - leverage ratios, interest coverage, and net leverage tests - validates lender covenants throughout the hold. The model is essential for PE sponsors, lenders, and target company management teams to evaluate acquisition attractiveness, assess debt capacity, and model downside resilience. Typical debt/equity splits are 60/40 to 70/30; exit multiples typically remain flat to 100 bps compression relative to entry, with IRR driven by EBITDA growth and deleveraging. ## What's included - Sources and uses with transaction funding breakdown - Debt schedule with repayment logic and financing assumptions - Operating forecast and cash flow available for debt paydown - Sponsor return outputs including IRR and MOIC - Exit sensitivity analysis across leverage and valuation assumptions - Entry price, equity investment, and debt financing structure - Senior, subordinated, and mezzanine debt with interest rates and amortization - Revenue and EBITDA projections with margin assumptions - Working capital management and capex requirements - Mandatory and optional debt repayment schedules - Exit analysis with multiple and cash-on-cash returns ## Inside the LBO Model: How the Five-Year Sponsor Analysis Works This five-year LBO model sizes a leveraged buyout, builds the capital structure with senior, sub, and revolver debt, integrates the three financial statements, tracks covenants, and calculates sponsor returns. It also includes management rollover and GP economics. This page explains the operating drivers, calculation flow, outputs, and practical use for anyone evaluating the template. The public download is a values-only preview. ### Operating Drivers and Scenario Assumptions The model is driven from a single Assumptions sheet where Base, Bull, and Bear scenarios sit side by side, and a toggle selects which case is live. Revenue growth is specified separately for each of the five forecast years, allowing the operating profile to change over the hold rather than being locked to identical growth. - Costs are split into variable and inflated-fixed components, so operating leverage emerges from revenue growth rather than being hard-coded. A pro-forma adjustment line bridges reported LTM margin to forward operating margin by capturing run-rate synergies or cost cuts at close. - Exit year is also an input, so the hold period can be shortened without rebuilding the model. ### Calculation Flow and Working Capital The model integrates the income statement, balance sheet, and cash flow statement over five years. Net income flows from the income statement, while capital expenditure and depreciation are scheduled in a PP&E roll. - Working capital changes feed the cash flow, and the debt schedule supplies mandatory amortisation, cash sweep, and sub-debt PIK accrual. A pre-sweep cash line breaks the circularity between cash available and debt repayment, after which the revolver automatically draws or repays to keep a minimum cash balance. - The balance sheet consolidates the statements, and the check row should return zero each year. The income statement also carries a net operating loss block, so taxes apply only after available losses are used. ### Debt Tranches, Covenants, and Credit Outputs The capital structure includes a senior term loan with mandatory amortisation and a cash sweep, subordinated debt with PIK accrual and a cash coupon paid on the average balance, and a revolver that draws or repays automatically. - A deferred financing cost asset is amortised straight-line over the senior tenor and is shown below EBITDA while also added back in the cash flow. - The covenants sheet monitors a maximum leverage step-down, a minimum interest coverage ratio, and a minimum debt service coverage ratio, each with threshold, actual, cushion, and a pass or fail flag. - These credit outputs help assess whether the deal stays within lender limits under the selected scenario. ### Returns, Value Creation, and Practical Use Returns analysis calculates exit enterprise value using exit EBITDA and exit multiple, nets debt and cash to reach sponsor exit equity, and produces IRR and MOIC. An exit-year input changes the length of the equity cash flow stream, so repricing the hold period flows through both return measures. - A value-creation bridge decomposes the return into EBITDA growth, multiple expansion, debt paydown, cash generation, and fees, which helps identify what is actually driving the outcome. Management rollover participates pro rata, and sponsor returns reflect the sponsor share. - Use this LBO model to compare how operating assumptions and financing terms affect sponsor returns. The public preview is values only. ## Built for leveraged deal work Use this model when leverage, debt paydown, and sponsor returns are central to the investment case. ## Structured around how LBOs are reviewed A useful LBO model needs more than an IRR output. It should show how the deal is funded, how cash is generated, how debt is repaid, and what drives the exit outcome. ## Better for scenario and committee work This gives you a cleaner base for testing different capital structures, operational assumptions, and exit cases without constantly rewiring the workbook. ## Designed for deal teams This page targets private equity and banking workflows where leverage and sponsor returns are central to the analysis. ## Cleaner LBO structure Start from a proper structure instead of downloading a generic template that needs major repair. ## Better for scenario work Test multiple leverage, growth, and exit assumptions without rebuilding the model. ## Workbook structure ### Cover A simple front sheet that frames the deal model and keeps navigation clear. - Workbook overview and deal framing - Simple navigation across key sheets - Clear front sheet for internal review ### Assumptions This sheet holds purchase price, financing terms, leverage assumptions, operating case drivers, and exit assumptions. - Purchase price and transaction assumptions - Debt structure and financing terms - Operating case and growth assumptions - Exit timing and valuation assumptions ### Sources & Uses The transaction funding sheet shows where capital comes from and how it is applied at close. - Equity and debt funding sources - Fees, purchase price, and transaction uses - Funding breakdown at closing - Clear view of how the deal is capitalised ### Operating Forecast This sheet projects operating performance and cash generation, which is what ultimately supports debt repayment. - Revenue and margin forecast - Operating cost build - Cash generation profile - Performance assumptions that drive debt paydown ### Debt Schedule The debt schedule tracks balances, interest, amortisation, and cash sweep or repayment behaviour across the hold period. - Opening and closing debt balances - Interest and mandatory amortisation - Cash sweep or optional repayment logic - Leverage and coverage metrics where relevant ### Returns The returns sheet brings the deal together through sponsor IRR, MOIC, leverage outputs, and exit sensitivity analysis. - Sponsor IRR and MOIC outputs - Debt paydown impact on equity returns - Exit sensitivity analysis - Final investment case summary ## Features - **Debt covenant tracking:** Monitor leverage ratios (EBITDA/Debt, Interest Coverage), revolver availability, and covenant cushions throughout the hold period. - **Multiple exit scenarios:** Compare outcomes from strategic sales, secondary sales, or dividend recaps. See how entry-to-exit spread impacts equity returns. - **Sensitivity dashboards:** Pull-through tables show equity returns (MOIC and IRR) as revenue growth and exit multiples vary. ## Use cases - **Investment committee approval:** Present sponsor returns (MOIC, IRR) and debt paydown trajectory to secure deal approval. - **Seller negotiation:** Model bid scenarios at different entry multiples to understand the leverage impact on returns. - **Operational planning:** Build a roadmap showing when debt milestones must be hit and what operating improvements unlock value. ## Frequently asked questions ### What is included in an LBO model? An LBO model usually includes sources and uses, a debt schedule, operating projections, cash flow, and sponsor return outputs such as IRR and MOIC. ### Who uses LBO models? Private equity investors, bankers, and corporate development teams use LBO models to analyse leveraged acquisitions. ### What should an LBO model include? A strong LBO model should include sources and uses, debt tranches, repayment logic, cash flow generation, and exit return analysis. ### What outputs matter most in an LBO model? The main outputs are usually sponsor IRR, MOIC, leverage metrics, debt paydown, and exit sensitivity. ### Can I adapt this for different capital structures? Yes. The workbook is intended as a structured Excel starting point that can be adjusted for different debt and deal assumptions. ## Related templates - [M&A Modeling & Valuation](https://finamodel.com/templates/ma-model) - [Exit Waterfall Model](https://finamodel.com/templates/exit-waterfall-model) - [Sum of Parts Valuation](https://finamodel.com/templates/sum-of-parts-model)