Bridgesheet

Paper LBO

Free

Short-form LBO: entry price, a single leverage level, debt repaid from all free cash flow, then exit. It calculates sponsor IRR and MOIC, plus a value creation bridge.

Download the example file (.xlsx)
  • 5 sheets
  • IRR and MOIC sensitivities (5 × 5)
  • 3 checks and 2 alerts
  • Input
  • Calculation

01 — General

Step 1 of 4

Live preview

Recalculating…

Download

Summary, charts and sensitivities, ready to drop into a presentation.

File language

Independent of the interface: for instance, generate a French or German model for a client abroad.

Model currencyEUReditable in the General step

Free plan: files carry a “Free version” notice.

Method

Entry EBITDA is last-twelve-months revenue times the EBITDA margin. EV is that EBITDA times the entry multiple; fees are a % of EV. Debt is a multiple of entry EBITDA. Sponsor equity funds the rest of the uses.

Revenue grows at the rate entered. EBITDA, D&A and capex are % of revenue; the working capital increase is a % of the change in revenue. A single rate applies to opening debt, so there is no circularity. Tax applies to positive pre-tax profit, with no tax losses carried forward.

Free cash flow = net income + D&A − capex − working capital increase. Its positive part repays debt, up to the outstanding balance. Any surplus builds up as cash, earning no interest. There is no revolver: negative free cash flow makes cash negative and triggers an alert.

Exit EV = final-year EBITDA times the exit multiple. Exit equity = EV − net debt. MOIC = exit equity / equity invested; IRR = MOIC^(1/years) − 1, with one cash flow at entry and one at exit and no interim dividends.

The bridge splits the gain into EBITDA growth, multiple expansion, deleveraging and fees, and reconciles exactly with exit equity minus equity invested. Debt does not depend on the multiples, so each sensitivity cell is a direct formula, with no data table.

What's in the file

  1. 01CoverCompany, date, currency, checks status, contents, colour conventions and disclaimer.
  2. 02InputsAll assumptions: operations (rates editable year by year), transaction, sensitivity steps and checks tolerance.
  3. 03LBOSources and uses, operations, cash sweep, sponsor returns and the value creation bridge, all as formulas.
  4. 04OutputsEquity invested and at exit, MOIC, IRR, then two 5 × 5 grids by entry and exit multiple.
  5. 05ChecksThree checks (sources = uses, bridge reconciles, debt not negative) and two alerts (cash, exit equity).