Last week, a mid-market PE firm in Frankfurt called me in because their LBO model for a €150M German manufacturing target blew up during bank diligence—the debt schedule didn’t link properly to the three-statement forecast, forcing a rushed rebuild under deadline pressure. We’ve all seen it: a model that looks solid in pitch decks but crumbles when lenders start probing assumptions. This guide walks you through constructing a transaction-tested model tailored to European mid-market deals, where leverage caps at 5-6x EBITDA and regulatory nuances like German GAAP add layers of complexity.
Core Model Architecture
Start with a fully integrated three-statement model: P&L, balance sheet, and cash flow must link dynamically, with every revenue driver flowing through to debt paydown and returns. In European mid-market LBOs, we separate assumptions into color-coded tabs—blue for inputs, black for calculations—to make audits straightforward; banks here demand traceability, unlike looser US standards.
What most overlook: circularity in interest and debt schedules. Use Excel’s iterative calculation (enable under Formulas > Enable Iterative Calculation) and paste special values for debt balances to prevent crashes—I’ve fixed dozens of models where this broke during sensitivity runs.
Unitranche debt, common in €50-200M deals, blends senior/junior terms at LIBOR + 400-600bps with 1% floors; it simplifies syndication but requires modeling blended amortization (5% mandatory) and OID amortization over 8 years, as non-cash interest impacts EBITDA add-backs.
Entry Valuation and Sources/Uses
Calculate entry EV at 8-10x LTM EBITDA for mid-market—say €120M EBITDA target at 9.5x yields €1.14B EV, minus €200M net debt for €940M equity value. Apply Treasury Stock Method for options dilution: if strikes are ITM, net new shares = (Options x Strike / Offer Price).
Sources: 60% unitranche (€684M at 6x), 20% revolver (undrawn), 20% sponsor equity. Uses: purchase equity, refinance net debt, €25M cash to BS, 2% financing fees (€14M amortized over 8 years). Balance the table first—it’s your error check before forecasting.
What we frequently see when called to deals: teams ignore PPA write-ups, like 10% on intangibles (15-year life) and PP&E (8-year), creating €30M annual incr. D&A that erodes FCF by 15%; consequence is understated leverage and failed covenants.
LBO Forecast Build
Project revenue via unit economics: for a manufacturing carve-out, forecast €200M base with 5% organic growth, plus bolt-on synergies (2% revenue uplift, 50bps margin expansion post-Year 1). Margins compress to 12% EBITDA in Year 1 from integration costs, stabilizing at 14%.
Debt schedule next: revolver draws for add-ons (e.g., €50M bolt-on at 9x), unitranche amortizes 5% mandatory + 100% FCF sweep post-revolver. Include PIK toggle for mezz (8.5% accrual) and covenant checks—leverage <6x, ICR >2x.
But here’s where it gets interesting: European mid-caps face FX volatility (e.g., EUR/GBP hedges) and capex spikes for ESG compliance, so build scenario toggles for ±15% revenue downside.
Whether to model revolver as cash-flow based or A/R collateralized depends on asset intensity—if NWC >10% revenue and EBITDA covers 2x interest, go cash-flow; else, limit to 20% eligible A/R.
You’re facing a live mid-market deal right now, staring at messy CIM projections?
If you need a model that withstands bank scrutiny without last-minute fixes, let’s discuss your transaction—schedule a consultation to scope it.
Returns Analysis and Exit
IRR and MOIC drive decisions: base case exits at 10x EBITDA in Year 5 (€1.5B EV) yields 25% IRR, 2.5x MOIC for sponsors. Build football field (DCF, comps 9x, precedents 10.5x) and sensitivities (revenue ±10%, multiple ±1x).
For co-investors, layer convertible preferred: $475M at 8.5% PIK, convert at $1.25 strike—max(Accrued Value, Conversion Value x Exit Price). Dividend recap in Year 3 (if covenants pass) pulls 50% equity out, boosting IRR to 30%.
Mid-market Europe demands conservative levers—avoid aggressive add-ons unless FCF covers 1.5x; test dividend recaps only post-Year 2 validation.
FAQ
How long to build a full M&A/LBO model for a €100M mid-market deal?
2-4 hours for a robust version, plus 1 hour sensitivities; pros use templates but customize debt/covenants.
What’s the biggest mistake in European LBO models?
Ignoring PPA D&A and DTL unwinds—erodes FCF 10-20%, failing bank tests; always allocate premium first.
Unitranche vs. traditional TL in mid-market?
Unitranche for speed (one lender, blended 10-12%), traditional for larger deals needing syndication; model both in sensitivities.
When to add bolt-ons in the model?
Year 1-2 if synergies >€5M EBITDA; fund via revolver, cap at 20% of platform size to avoid dilution.
Typical leverage for European mid-market LBOs?
4.5-6x total net, with 1x revolver; covenants tighten post-2024 on ESG rules.
If your deal model needs practitioner review for European nuances, we’re available for a targeted consultation.