LBO Model Example
Private Equity Financial Model (Free Excel Download)
Evaluate leveraged buyouts with sources and uses, debt paydown, cash generation, exit assumptions, sponsor IRR, MOIC, and return sensitivities.
professionals from Deloitte
Used by professionals from
About this model
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 every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the LBO Model Example
- 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
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.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
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.
Have more financial modelling questions? Contact us
Related templates
M&A Modeling & Valuation
Comprehensive M&A valuation with DCF, comparable companies, and precedent transactions analysis.
Exit Waterfall Model
Waterfall analysis for M&A, IPO, or sale with proceeds distributed to shareholders and securities holders.
Sum of Parts Valuation
Value a diversified company by valuing each business segment independently and summing the parts.
Venture Capital Fund Model
Model VC fund cash flows, distributed returns, and IRR by vintage year and exit scenario.
