Private Equity Acquisition Model — Bankable Mid-Market Buyout Template (Excel, FAST-standard, assumption-driven)

All Industries, Asset Management, Banking, Financial Model, Financial Services, General Excel Financial Models

5-year Financial Projections, Debt Amortization, Debt Schedule, Debt Security, Debt Service Coverage, Dividends, Financial Analysis, Financial Debt, Financial Model, Financial modelling, Financial Ratios, Financial Reporting, Financial Statements, LBO (Levered Buyout), Three Statement Model | Three Financial Statements, Uses and Sources of Funds

This is a bankable, three-statement leveraged buyout (LBO) and acquisition model for a mid-market business, built in Microsoft Excel to a professional FAST-style standard and structured to the level of rigour lenders and investment committees expect. A monthly calculation engine drives clean annual outputs from FY22A through FY30F, fully linking the income statement, balance sheet and cash flow statement so every input flows through to the returns and credit metrics automatically.

Crucially, the model is assumption-driven: all hardcoded entries live on dedicated input tabs — historical P&L, historical balance sheet and forecast assumptions — kept separate from the calculation engine. Every driver is visible, labelled and editable in one place, so the model is transparent, easy to audit and quick to flex. Change a single assumption and the entire model — statements, returns, debt schedule and covenants — re-flows instantly.

The model is designed for private equity sponsors, corporate development / M&A teams, search funders, debt advisers, lenders and finance professionals who need a robust, bankable, audit-ready buyout model they can populate with a live deal in hours rather than weeks.

What’s included (21 linked tabs)

Cover & navigation — key facts, colour-coding legend, hyperlinked tab index and a value-creation roadmap.
Model checks — 17 live integrity checks (balance sheet ties, cash flow reconciliation, debt, goodwill, covenants, revenue build and more); a single master cell shows “ALL OK” when the model is clean.
Scenario switch — one control cell toggles the entire model between Base, Upside and Downside cases.
Integrated financial statements — P&L, balance sheet and cash flow on a single tab.
Debt schedule — senior bank term loan with scheduled amortisation, subordinated vendor PIK loan, a revolving credit facility (RCF), and an excess-cash-flow (ECF) sweep.
Covenants — leverage and interest-cover covenant tracking with step-down thresholds and headroom.
Value creation — EBITDA-growth and deleveraging bridge built around six value-creation levers (pricing, vendor rebates, mix, overhead, working capital and FX discipline).
Sensitivity analysis — two-way data tables on EBITDA, leverage and interest cover.
Supporting schedules — revenue build by product line, employee/headcount build, COGS & gross margin, operating expenses, FX hedging, working capital (DSO/DIO/DPO and cash conversion cycle), fixed assets & capex, purchase price allocation / goodwill & intangibles, and tax (including loss carry-forwards).

Key features

Bankable, lender- and investment-committee-grade structure and presentation.
Fully integrated, formula-driven three-statement model — no hardcoded outputs.
Assumption-driven: all inputs isolated on dedicated assumptions and input tabs for full transparency and easy auditing.
Three switchable scenarios from a single control cell.
Monthly engine rolling up to annual results FY22A–FY30F.
Complete LBO capital structure: term loan, vendor PIK, RCF and cash sweep.
Covenant compliance dashboard with step-down thresholds.
Six-lever value-creation / deleveraging bridge.
Purchase price allocation with goodwill and badwill treatment.
Working-capital engine by product line (DSO / DIO / DPO → CCC).
17 automated integrity checks so you always know the model ties.
Clear colour-coding convention (blue = input, black = formula, green = link, red = export).
Built to a FAST-style modelling standard for transparency and auditability.

What you receive

Two ready-to-use Excel files:

Populated example — a fully worked, internally consistent example with all 17 checks passing, ideal for learning the structure and stress-testing the logic.
Blank template — all inputs cleared and an added step-by-step Instructions tab, ready for you to drop in your own deal.

How to use it

Enter your data into the blue input cells only, in the order set out on the Instructions tab: select a scenario, enter historical P&L and balance sheet actuals, set your forecast assumptions and deal/debt terms, configure timing, then confirm the Model Checks tab reads “ALL OK”. Outputs, statements, covenants and the value-creation bridge update automatically.

Compatibility & format

Microsoft Excel (.xlsx). No macros required. Works in Excel for Windows and Mac and is broadly compatible with other spreadsheet applications.

Note

All company names, figures and assumptions in the template are illustrative placeholders only and do not represent any real entity or transaction. This model is provided for illustrative and educational purposes and does not constitute investment, legal, tax or accounting advice; verify all formulas, assumptions and outputs independently before relying on them.

You must log in to submit a review.