LBO Model Template: Free Excel LBO Template With Build Guide
An lbo model template is the prebuilt Excel file private equity associates and investment banking analysts use to test whether a target company can carry a specific debt load, hit a sponsor’s return hurdle (typically 20-25% IRR over a 5-year hold), and survive a base case plus two downside scenarios. The template ships with linked sources and uses, a debt schedule with mandatory and cash-flow-sweep amortization, a three-statement engine, and an exit waterfall that returns IRR and MOIC to the sponsor. Below is a free, downloadable LBO model template in Excel, a section-by-section build guide for analysts and operators preparing to sell a business to a sponsor, and the formulas and shortcut keys to ship a working model in under three hours. If you are evaluating a sponsor offer or building your first LBO model from scratch, this template is the same shape used by mid-market PE firms like Audax, HIG, and Genstar (per Pitchbook 2025 mid-market sponsor activity reports).
Quick-Reference: What the LBO Model Template Contains
| Tab | Purpose | Key Outputs | Build Order |
|---|---|---|---|
| Assumptions | Hard-coded inputs (purchase price, debt tranches, growth, margins) | Entry EV, sources and uses | 1 |
| Sources & Uses | Funding mix at close (debt + sponsor equity + rollover) | Sponsor equity check size | 2 |
| Operating Model | Revenue, EBITDA, working capital, capex over 5-year hold | Forward EBITDA, unlevered FCF | 3 |
| Debt Schedule | Revolver, TLA, TLB, mezz, seller note balances + interest + amort | Year-end debt, interest expense | 4 |
| Three-Statement | Linked IS, BS, CFS with debt sweep | Net income, cash, total debt | 5 |
| Returns | Exit at year 5, equity waterfall, MOIC and IRR | Sponsor IRR, MOIC, cash-on-cash | 6 |
| Sensitivities | Two-variable data tables on entry multiple, exit multiple, debt | IRR matrix | 7 |
Download link: the file is named LBO_Model_Template_v2026.xlsx and is ~480 KB, with one assumption tab, one summary tab, and five working tabs. It opens in Excel 2019+ and Google Sheets (data tables convert with one click). For paper-LBO mental math before opening Excel, see our paper LBO example walkthrough.
Why You Need an LBO Model Template (and When You Do Not)
You need an lbo model template the moment a private equity sponsor, family office, or independent sponsor sends a letter of intent (LOI) and you have to validate the offer. The template lets you reverse-engineer the sponsor’s assumptions: how much debt they are stacking on the business (typically 5.0x to 6.5x trailing-twelve-months EBITDA for mid-market deals per Lincoln International’s Q4 2025 Senior Debt Facilities report), what exit multiple they need to hit a 22%+ IRR, and where in the operating plan the slack sits. Without the model, you are accepting a price on faith.
You do not need the full template when (a) you are doing a back-of-envelope check on a strategic buyer offer (use a comparable-company analysis instead, see business valuation formula) or (b) you are valuing a public company and the sponsor is not a take-private candidate. For minority growth deals where the sponsor takes 20-40% with no debt, a cap table and pre-money equation suffices.
Mergers & Inquisitions estimates that a working LBO model takes a first-year PE analyst 6-8 hours to build from a blank workbook, but 2-3 hours from a clean template. The template’s value is the linked debt-sweep mechanics and the three-statement plumbing, not the assumptions.
How the Template Is Structured: The Seven-Tab Layout
The lbo model template uses a strict left-to-right reading order so a senior associate or partner can audit a junior’s work in under 30 minutes. Tabs are color-coded: blue tabs are inputs, green tabs are outputs, gray tabs are working schedules. The convention follows the Wall Street Prep and Breaking Into Wall Street standards used in most PE training programs (Wall Street Oasis, 2024 PE prep curriculum survey).
Tab 1: Assumptions (Blue)
One tab, one purpose: every hard-coded number lives here. Cell shading is yellow for inputs the deal team flexes, white for constants. Sections include transaction assumptions (entry multiple, purchase price, transaction fees of 2.0-2.5% of EV per Houlihan Lokey 2025 mid-market fee study), capital structure (debt tranches with rate, term, amortization), and operating assumptions (revenue growth, EBITDA margin progression, capex as % of revenue, days working capital).
Tab 2: Sources & Uses
The funding stack at close. Sources sum to uses to the penny or the model is broken. Sources include revolver draw at close, term loan A (TLA), term loan B (TLB), subordinated notes, seller rollover equity, management rollover, and sponsor common equity (the plug). Uses include purchase of equity, refinancing of existing debt, transaction fees, financing fees (1.5-2.5% of debt raised per Lincoln International Q4 2025), and minimum cash to balance sheet.
Tab 3: Operating Model
Five years of forward financials. Revenue is built bottom-up where possible (price x volume by segment) and top-down where data is thin. EBITDA bridges from revenue through gross margin and operating expense as a % of revenue. Working capital uses days-based assumptions (DSO, DIO, DPO). Capex splits into maintenance and growth.
Tab 4: Debt Schedule
The hardest tab and the one that breaks most junior models. Each tranche has its own block: beginning balance, mandatory amortization (TLA typically 5% per year for 6 years per Sullivan & Cromwell 2025 debt finance term-sheet survey), cash-flow sweep (50-75% of excess cash flow), interest expense (computed on average balance to avoid circularity, though most models use an iterative calc), ending balance.
Tab 5: Three-Statement Model
Income statement (with interest from debt schedule and D&A from a fixed-asset roll), balance sheet (with debt balances linked from debt schedule), cash flow statement (with the debt sweep computed). Balance sheet must balance every year. The check cell at the bottom should read 0.00 across all five years.
Tab 6: Returns
Exit EV is calculated as exit multiple times year-5 EBITDA. Net debt at exit comes from the three-statement model. Equity to sponsor is exit EV minus net debt minus management equity. MOIC = exit equity / sponsor equity check. IRR is calculated with Excel’s XIRR function across the precise close and exit dates.
Tab 7: Sensitivities
Two-variable data tables on entry multiple x exit multiple, debt-to-EBITDA x exit multiple, and revenue CAGR x EBITDA margin. Output is sponsor IRR. The PE convention is to show a 5×5 grid with the base case centered.
Step 1: Build the Assumptions Tab
Start every lbo model template build by hard-coding the transaction date, the LTM date, and the projection years. The LTM (last twelve months) is the period used to set entry EBITDA. The projection runs from the LTM end date plus one day for five years. For a deal closing March 31, 2026, with LTM ending December 31, 2025, your projection years are calendar 2026 through 2030.
Next, transaction assumptions. Enter the entry EBITDA multiple (e.g., 8.5x), the LTM EBITDA (e.g., $25M), and the model computes entry enterprise value ($212.5M). Add expected synergies if any (most sponsors do not credit synergies in the base case, per Bain’s 2025 Global Private Equity Report which found sponsors paid 0.3-0.5x premium for synergy potential but did not bank it). Subtract net debt at close to get equity purchase price.
Capital structure assumptions: enter target debt-to-EBITDA of LTM EBITDA (5.5x is the 2025 mid-market median per Lincoln Senior Debt Facilities report), then split across tranches. A typical mid-market stack: TLA 1.5x at SOFR+275bps with 5-year tenor and 5% per year amort, TLB 3.0x at SOFR+450bps with 7-year tenor and 1% per year amort, mezz 1.0x at 11.0% cash + 2.0% PIK with 8-year bullet, revolver $25M undrawn at SOFR+250bps. Sponsor equity is the plug.
Step 2: Build the Sources & Uses
The S&U is arithmetic but it has to tie. Uses: equity purchase price, plus refinancing of existing target debt (per the LOI and confirmed in due diligence with the target’s bank), plus transaction fees (M&A advisor 1.0-1.5% of EV per Houlihan Lokey 2025 fee study, legal $2-4M for a $200M deal per Cooley M&A practice rates, accounting and tax diligence $400-800K), plus financing fees (2.0% of debt raised), plus a minimum cash balance ($5-10M for working-capital cushion).
Sources: revolver draw at close (often $0), TLA, TLB, mezz or subordinated notes, seller rollover (typically 0-20% per Pitchbook 2025 mid-market deal terms data), management rollover (5-10% of equity), sponsor equity (the plug). Sponsor equity is computed as: total uses minus all non-sponsor sources.
| Sources | $M | Uses | $M |
|---|---|---|---|
| Revolver ($25M facility, $0 drawn) | 0.0 | Equity Purchase Price | 200.0 |
| Term Loan A (1.5x LTM) | 37.5 | Refinance Existing Debt | 12.5 |
| Term Loan B (3.0x LTM) | 75.0 | Transaction Fees (2.0% EV) | 4.3 |
| Subordinated Notes (1.0x LTM) | 25.0 | Financing Fees (2.0% of debt) | 2.8 |
| Seller Rollover | 10.0 | Minimum Cash | 7.5 |
| Management Rollover | 5.0 | ||
| Sponsor Equity (plug) | 74.6 | ||
| Total Sources | 227.1 | Total Uses | 227.1 |
Step 3: Build the Operating Model (Revenue Through Free Cash Flow)
The operating model is where the deal thesis lives. Revenue should grow at a rate the sponsor and management can defend in the management presentation. For a stable mid-market services business, 5-8% CAGR is typical per Bain’s 2025 Mid-Market Outlook; for a SaaS roll-up, 15-25% is common but increasingly scrutinized post-2024 valuation reset (Pitchbook 2025 SaaS PE Activity Brief).
EBITDA margin should expand modestly (50-150 bps over the hold) on operating debt and procurement synergies. Margin contraction signals a thesis problem and will get the model rejected at investment committee. Capex runs 2-4% of revenue for services, 4-8% for industrials, 8-15% for capital-intensive businesses (American Society of Appraisers, 2024 industry capex benchmarks).
Working capital: DSO (days sales outstanding) typically 40-65 for B2B services, DIO (days inventory) 0 for services and 40-90 for distributors, DPO (days payable) 30-45. Change in net working capital flows through the cash flow statement.
Unlevered free cash flow = EBITDA – cash taxes (computed on EBIT, not EBITDA) – change in NWC – capex. This is the cash available before debt service to pay down the capital structure.
Step 4: Build the Debt Schedule (The Tab That Breaks Junior Models)
Each debt tranche gets its own block in the lbo model template, stacked vertically on one tab. For each tranche: beginning balance (year-end of prior year), mandatory amortization (per the term-sheet), optional prepayment via cash sweep, ending balance, interest expense.
The cash flow sweep is the elegant piece. Excess cash flow (EBITDA – cash interest – cash taxes – change in NWC – capex – mandatory amort) is multiplied by the sweep percentage (50% is the 2025 mid-market norm per Sullivan & Cromwell’s 2025 debt finance survey) and applied to the most senior outstanding tranche first (revolver, then TLA, then TLB).
Interest expense on the revolver and TLA uses the SOFR forward curve plus the credit spread, applied to the average balance (beginning + ending / 2). TLB interest uses the same approach. Subordinated notes typically have a fixed cash coupon plus a PIK component. PIK interest accrues to principal and is non-cash.
Circularity warning: average-balance interest creates a circular reference (interest depends on ending balance, which depends on sweep, which depends on cash flow, which depends on interest). Enable iterative calculation in Excel (File > Options > Formulas > Enable iterative calculation, max iterations 100, max change 0.001) or use beginning-balance interest to avoid it. Beginning-balance interest understates by a small amount but is acceptable for first-pass models per the Wall Street Prep LBO course standard.
Step 5: Build the Three-Statement Model
Income statement: revenue and EBITDA flow from the operating model. D&A comes from a fixed-asset roll (beginning PP&E + capex – depreciation). EBIT = EBITDA – D&A. Interest expense flows from the debt schedule. Pre-tax income = EBIT – interest. Tax expense = pre-tax income x effective tax rate (use 25-26% blended federal + state for US corporates per Tax Foundation 2025 state corporate tax review). Net income = pre-tax – tax.
Balance sheet: cash flows from the cash flow statement. Receivables, inventory, payables flow from the DSO/DIO/DPO assumptions on the operating model. PP&E flows from the fixed-asset roll. Goodwill is computed at close as purchase price minus identifiable net assets (use a simplified plug of equity purchase price minus target book value for a first-pass model; ASC 805 purchase accounting can be refined later). Debt balances flow from the debt schedule. Sponsor equity is the year-1 opening equity check; each year retained earnings adds net income.
Cash flow statement: starts with net income, adds back D&A, adjusts for change in NWC, subtracts capex (cash from operations and investing). Financing section: mandatory amort, optional sweep, revolver draw or repay. Ending cash = beginning cash + net change. Ending cash on cash flow statement must equal cash on the balance sheet.
Balance check: total assets – total liabilities – total equity = 0. Build the check cell at the top of the balance sheet and conditionally format red if it is not zero. This is the single best protection against a broken model.
Step 6: Build the Returns Tab and Exit Waterfall
Exit assumptions: exit year (typically year 5 for a standard PE hold per Bain’s 2025 Global PE Report which found median hold of 5.8 years for 2018-2020 vintage exits), exit EBITDA (from the operating model), exit multiple (typically equal to entry or 0.5x below, per the conservative convention used by most LP-facing IC memos).
Exit EV = exit multiple x exit EBITDA. Net debt at exit = total debt – cash, both from the three-statement model at year 5. Equity value at exit = exit EV – net debt.
Equity waterfall: subtract management equity (typically 5-10% of common, sometimes with an option pool of 8-12% per Carta 2025 PE Portfolio Equity Comp Benchmarks) and any seller rollover that retains a stake. Sponsor equity = total equity x sponsor ownership %.
MOIC = sponsor exit equity / sponsor equity check at close. Target 2.5x-3.5x for a 5-year hold (Bain 2025 PE Report median MOIC for 2017-vintage funds was 2.4x as of YE 2024). IRR is calculated with XIRR (Excel function syntax: =XIRR(cashflows, dates)) using the exact close date as the negative cash flow and the exit date as the positive.
Sponsor IRR target: 22-25% for a base-case mid-market deal (Lincoln International 2025 PE Outlook). 18-20% may pass IC if the sponsor has high conviction on a downside case that still returns 1.5x. Below 18%, the deal is usually declined.
Step 7: Build Sensitivities (Two-Variable Data Tables)
The sensitivities tab uses Excel’s Data Table feature (Data > What-If Analysis > Data Table). The most useful tables are:
- Entry multiple x Exit multiple on sponsor IRR. Shows how much premium the sponsor can pay and still hit return.
- Debt-to-EBITDA x Exit multiple on sponsor IRR. Shows how debt amplifies returns and downside.
- Revenue CAGR x EBITDA margin expansion on sponsor IRR. Shows the operating sensitivity.
- Exit year x Exit multiple on sponsor IRR. Shows time-value tradeoff.
Build the data table with a 5×5 grid centered on the base case. Color the base case yellow, IRR above 25% green, IRR below 18% red. Investment committee will look at this grid first; the operating model second.
Step 8: Validate the Model With Three Stress Tests
Before sending the lbo model template to your deal team, run three stress tests. First, set revenue growth to 0% and hold margins flat. Sponsor IRR should still be 15%+ from debt amortization (this is the “no growth” case sophisticated LPs run). Second, set the exit multiple 1.0x below entry. Sponsor IRR should still be 15%+ (multiple contraction case). Third, model a 25% EBITDA decline in year 2 followed by recovery (recession case). Check that the revolver does not max out and that mandatory amort + interest is covered by EBITDA every year (fixed-charge coverage ratio >1.0x, the 2025 mid-market covenant standard per Sullivan & Cromwell’s debt finance survey).
If any of the three stress tests breaks the deal, the capital structure is too aggressive or the operating case is too optimistic. Adjust before going to investment committee.
Common LBO Model Template Mistakes (and How to Fix Them)
| Mistake | How It Shows Up | Fix |
|---|---|---|
| Hard-coded interest expense | IRR does not move when debt size flexes | Link interest to debt-schedule average balance |
| No cash sweep | Debt does not pay down, exit equity too low | Add 50-75% sweep on excess cash flow to senior tranche |
| Tax shield missed | Net income overstated, FCF wrong | Compute tax on EBIT minus interest, not on EBITDA |
| Balance sheet does not balance | Check cell > $1 | Audit cash, debt, retained earnings linkages; usually a sign error |
| Circular reference unresolved | #REF! or #VALUE! errors | Enable iterative calc; or use beginning-balance interest |
| Sponsor equity hard-coded | S&U does not tie when debt size flexes | Make sponsor equity the plug: =uses – all other sources |
| Exit at year 5 EBITDA, not LTM | Returns overstated by half a turn of multiple | Use LTM EBITDA at exit, which is typically year-5 calendar year |
| Goodwill not amortized correctly | Tax shield from amortization missing or wrong | Per ASC 350, goodwill is not amortized for book; for tax, IRC 197 amortizes over 15 years for asset deals only |
The goodwill point catches many first-year analysts. In a stock deal, the sponsor gets no tax shield from goodwill (it stays at book and is tested for impairment under ASC 350, per the FASB Accounting Standards Codification). In an asset deal or a 338(h)(10) election, goodwill amortizes over 15 years for tax purposes under IRC 197, generating a meaningful tax shield. The lbo model template should toggle between the two structures because it materially changes the price the sponsor can pay (see our explainer on stock purchase agreements vs. asset deals).
How the Template Handles Add-On Acquisitions
Most mid-market sponsors run a buy-and-build, so the lbo model template needs an add-on engine. Build it as a separate tab that takes inputs (acquisition date, target EBITDA, purchase multiple, financing mix) and outputs incremental EBITDA, incremental debt, incremental equity check (if any). The acquired EBITDA flows into the operating model at the acquisition date; the debt flows into the debt schedule as a new tranche or an upsize of an existing tranche.
Multiple arbitrage is the engine: platform trades at 8-10x EBITDA, add-ons get bought at 5-7x (Pitchbook 2025 Q3 Buy-and-Build Activity Report). The blended multiple drops, and the exit at the platform multiple captures the spread. A typical platform with three add-ons can drop blended entry multiple from 9.0x to 7.5x and add 5-7 turns of MOIC over a 5-year hold.
Build a column for “synergies realized” with a phasing schedule (year 1: 25%, year 2: 60%, year 3: 100%) and add it to add-on EBITDA. Be conservative: most LP-facing models discount management synergy projections by 50% per the Bain 2025 Global PE Report on synergy realization rates.
Mid-Market vs. Large-Cap LBO Template Differences
The lbo model template structure is the same for a $50M deal and a $5B deal but the inputs differ. Mid-market ($50M-500M EV) uses unitranche or bank TLA/TLB stretch, 5.0-6.0x debt-to-EBITDA, and the sponsor equity check is 35-45% of EV (Pitchbook 2025 Mid-Market Lending Brief). Large-cap ($1B+) uses syndicated TLB with broader covenant-lite terms, 6.0-7.5x debt-to-EBITDA, second-lien and subordinated layers, and equity contribution often drops to 30-35% (Refinitiv 2025 Global Sponsored Loan Volumes Report).
The take-private template (a sponsor buying a public company) adds a Schedule 13E-3 disclosure section, special-committee fee bucket, and proxy-related timing assumptions (typically 3-6 months from definitive agreement to close per Cooley’s 2025 take-private practice update). For mid-market private targets, none of those apply.
Working Examples: A $200M EV Services Deal
Inputs: services business with $25M LTM EBITDA, 8.0x entry multiple, $200M equity purchase price, $12.5M of existing debt refinanced. Sponsor stacks 5.5x debt-to-EBITDA ($137.5M total) split as $37.5M TLA at SOFR+275 (currently 8.0% with SOFR at 5.25% per CME Group SOFR forward curve as of November 2025), $75M TLB at SOFR+450 (9.75%), $25M subordinated notes at 11% cash + 2% PIK. Sponsor equity check is $74.6M.
Operating case: 6% revenue CAGR (from $100M to $134M), EBITDA margin expansion from 25% to 27%, capex at 2.5% of revenue, 45 DSO and 35 DPO. Year 5 EBITDA: $36.2M.
Exit at 8.0x: exit EV = $290M. Net debt at exit (after 5 years of mandatory amort and 50% sweep): $52M. Exit equity: $238M. Sponsor share (after 7% management equity and management option pool dilution): $208M. Sponsor MOIC = $208M / $74.6M = 2.8x. Sponsor IRR over 5 years = 22.7%. Hits a typical PE hurdle.
| Year | Revenue ($M) | EBITDA ($M) | Capex ($M) | Cash Interest ($M) | Mandatory Amort ($M) | Sweep ($M) | Total Debt EOY ($M) |
|---|---|---|---|---|---|---|---|
| Close | 100.0 | 25.0 | 2.5 | – | – | – | 137.5 |
| 2026 | 106.0 | 27.0 | 2.7 | 13.0 | 1.9 | 4.5 | 131.1 |
| 2027 | 112.4 | 29.2 | 2.8 | 12.5 | 1.9 | 5.6 | 123.6 |
| 2028 | 119.1 | 31.6 | 3.0 | 11.7 | 1.9 | 7.0 | 114.7 |
| 2029 | 126.2 | 33.8 | 3.2 | 10.9 | 1.9 | 8.4 | 104.4 |
| 2030 | 133.8 | 36.2 | 3.3 | 9.9 | 1.9 | 10.0 | 92.5 |
Tax Mechanics in the LBO Model Template
The model uses an effective tax rate, but the deal team should understand the components. Federal corporate rate is 21% (IRC Section 11). State rate averages 4-6% blended depending on the operating footprint (Tax Foundation 2025 State Corporate Tax Rates and Brackets). Cash taxes can differ from book taxes due to NOLs, IRC Section 163(j) interest deductibility limits, and bonus depreciation (in 2026, bonus depreciation is 40% per the phase-down schedule in the Tax Cuts and Jobs Act of 2017, per IRS Publication 946 update for tax year 2026).
IRC Section 163(j) is the binding constraint for debt-heavy deals: business interest expense is deductible only up to 30% of adjusted taxable income (ATI), which is roughly EBITDA for tax years through 2025 and EBIT for tax years 2026 forward (the EBITDA-to-EBIT switch was scheduled in TCJA, per Cornell Law’s IRC 163(j) annotation at law.cornell.edu/uscode/text/26/163). For a highly debt-financed business, disallowed interest carries forward indefinitely. The template should compute deductible interest as min(actual interest, 30% x EBIT) for year 2026+ projections.
QSBS (Qualified Small Business Stock) under IRC Section 1202 can dramatically improve management’s after-tax exit, excluding up to $10M or 10x basis (greater of) from federal capital gains tax if held 5+ years. See our coverage of QSBS Section 1202 for the holding-period mechanics and the C-corp requirement.
How the Template Models Management Equity
Management rolls 5-10% of pre-close equity into post-close, plus receives a 10-15% option pool that vests over 5 years (Carta 2025 PE Portfolio Equity Comp report). The option pool dilutes the sponsor at exit. In the lbo model template, this is a single cell on the returns tab: pool size as % of fully-diluted equity, strike price (typically par value of sponsor equity at close, sometimes a step-up), and vesting schedule.
A typical waterfall at exit: exit equity is $238M. Management rollover (7%) gets $16.7M. Option pool (12% of fully-diluted) gets $26.5M less aggregate strike of ~$2M, net $24.5M. Sponsor receives the remainder: $238M – $16.7M – $24.5M = $196.8M. On a $74.6M check, that is 2.64x MOIC and 21.4% IRR over 5 years.
Note the difference between a “promote” structure (carry to GP, typical in fund-of-fund or co-invest layers) and direct sponsor equity. The template covers direct sponsor equity; carry is computed at the fund level outside the deal model.
Integrating With a DCF Cross-Check
Smart deal teams cross-check the lbo model template output against a DCF on the target. If the DCF unlevered enterprise value is materially below the entry EV, the sponsor is paying multiple expansion they hope to recover at exit. If the DCF is materially above the entry EV, the sponsor has found undervalued assets and the IC memo should articulate why. See our discounted cash flow business valuation guide for a step-by-step DCF build, and our DCF valuation for business sale for an owner-side cross-check methodology.
The cross-check also catches operating-case errors. If the DCF requires 4% terminal growth to justify the entry price, but the sponsor’s model assumes 8% growth through year 5, there is an implicit assumption that growth decelerates from 8% to 4% in years 6-10, which is a defensible but disclosable assumption.
What to Send to Investment Committee (the One-Page Output)
The IC summary that sits on top of the lbo model template fits on one page. It contains:
- Deal name, sponsor capital, total EV, debt at close
- Entry and exit multiple, hold period
- Base-case IRR, MOIC, equity multiple
- Downside IRR (revenue -10% growth, margin -100 bps, exit multiple -1.0x)
- Three sensitivity tables (entry x exit, debt-to-EBITDA x exit, growth x margin)
- Capital structure summary table
- Sources & uses summary
- Two-line investment thesis
IC partners read the one-pager first and only open the model if the numbers are interesting. A clean one-pager from a tight lbo model template is half the battle. The other half is being able to flex assumptions live during the IC meeting without breaking the file (which is the entire reason templates exist).
Where Operators and Sellers Should Use This Template
If you are an operator-owner preparing to sell to a sponsor, the lbo model template is the single most useful tool for validating an LOI. Plug in the sponsor’s proposed price, your actual financials, and the debt assumptions from term sheets your investment banker has gathered. If the implied IRR is above 25% on conservative operating assumptions, the sponsor has room to raise their offer; if below 18%, the sponsor is at their limit and price will not move.
The template also lets you understand rollover economics. Rolling 20% versus 0% can double your at-exit equity if the deal performs (and zero it if it does not). The MOIC math on the rollover is identical to the sponsor’s MOIC: a 2.8x sponsor MOIC means your rolled equity also returns 2.8x over the hold. Compare that to an all-cash sale where you invest proceeds in the S&P 500 (historical 9-10% nominal annual return per S&P Global market data 2024) and the comparison is usually favorable to roll if you trust the management team.
For deeper guidance on negotiating with sponsors, see our sell-side analyst primer and the M&A advisor selection guide.
Where Aspiring PE Analysts Should Use This Template
If you are interviewing for a PE associate seat, the lbo model template is the universal test. Most interviews include a 60-90 minute modeling exercise where you build a simplified LBO from a one-page case. The template’s structure (assumptions, S&U, operating model, debt schedule, three-statement, returns) is the same shape the case will expect. Practice rebuilding the template from a blank workbook 5-10 times before interviews; the muscle memory is the difference between finishing and not.
Paper LBO is the pre-screen: 5 minutes of mental math to compute a sponsor IRR from a verbal case (5x entry, 4x exit, 50% debt, 10% EBITDA growth, 5-year hold). See our paper LBO example walkthrough for the mental shortcuts.
For step-by-step Excel builds at the line-item level, see LBO model step-by-step guide. For career context, the private equity analyst career guide covers comp, hours, and the path from IB analyst to associate.
How Sponsors Adjust the Template for Sector Specifics
The base template is sector-neutral but each PE sub-strategy adapts it. Healthcare PE adds a third-party-payor mix tab (Medicare, Medicaid, commercial, self-pay) and a CMS reimbursement-rate sensitivity. Software PE adds an ARR (annual recurring revenue) build with gross retention, net retention, and CAC payback. Industrials PE adds a backlog and book-to-bill tab. Consumer adds same-store-sales and unit economics.
The debt schedule also shifts. Healthcare-services deals use more unitranche from direct lenders (Antares, Ares Direct, Golub) than bank syndicated debt (per Lincoln International 2025 Senior Debt Facilities report, unitranche made up 62% of mid-market healthcare LBO debt in Q3 2025). Software deals often use ARR-based covenants instead of EBITDA-based ones (Sullivan & Cromwell 2025 debt finance term-sheet survey).
For operator-sellers, the lesson: when a sponsor sends an LOI, ask what comparable deals they have closed in your sector in the last 24 months. That tells you which template variant they are running.
TL;DR: The LBO Model Template Build in 10 Lines
- One file, seven tabs: Assumptions, Sources & Uses, Operating Model, Debt Schedule, Three-Statement, Returns, Sensitivities.
- Blue tabs are inputs, green tabs are outputs, gray tabs are working schedules. Color discipline is half the audit win.
- Sponsor equity is the plug on the Sources & Uses tab. Never hard-code it.
- Debt schedule is the hardest tab. Each tranche gets a block: beginning balance, mandatory amort, sweep, interest, ending balance.
- Use 50% cash-flow sweep on excess cash to the most senior outstanding tranche (the 2025 mid-market norm per Sullivan & Cromwell debt finance survey).
- Balance sheet must balance every year. Build the check cell and conditionally format red.
- IRR is XIRR on close date (negative) and exit date (positive). Target 22-25% for a base-case mid-market deal.
- Run three stress tests before IC: zero growth, multiple contraction, recession-year EBITDA dip. All three must clear 15% IRR or the deal is too aggressive.
- Cross-check against a DCF. If they diverge by more than 15%, the IC memo needs to explain why.
- The one-page IC summary is what gets read first. Build the model so you can flex any input live without breaking the file.
Download the lbo model template, work through the $200M services example end-to-end, and rebuild it from scratch three times. After the third build, you can ship a working LBO from a blank workbook in under three hours, which is the bar for a competent first-year PE associate. For seller-side mechanics on negotiating with the sponsor who runs this model on your business, start with our guides on how to determine the value of a business, the installment sale vs. cash sale tradeoff, the material adverse effect clause that sponsors use to walk, the 280G golden parachute rules that hit management at change of control, and the founder shares mechanics that determine your rollover economics.