Buy-and-Build Model – 10 Years | Excel Template for Platform, Add-ons, IRR & Exit | Private Equity Roll-up

Planning a buy-and-build strategy or testing whether a platform with several add-on acquisitions pays off? This model shows over 10 years how revenue, EBITDA, leverage and returns grow with every add-on – including IRR and money multiple.

Built by an investment banker with M&A experience – the way buy-and-build cases are actually modelled in private equity.

WHAT'S INCLUDED – 7 LINKED SHEETS
• Dashboard: key figures, IRR, money multiple, layer cake chart and leverage
• Platform: revenue, EBITDA margin, purchase multiple and 10-year plan
• Add-ons: up to 10 acquisitions with purchase year, multiple, debt share, transaction and integration costs
• Synergies: cost and revenue synergies with ramp-up
• Consolidation: P&L, free cash flow, working capital, acquisition debt, amortisation, cash sweep, covenant check
• Exit and returns: exit value, IRR, money multiple and value creation bridge (EBITDA growth, multiple arbitrage, deleveraging)
• Sensitivities: IRR and money multiple by exit year and exit multiple

HOW IT WORKS
1. Enter the closing year and the platform
2. Set add-ons, financing and exit in the blue cells
3. All results, charts and sensitivities update automatically

PERFECT FOR
• Private equity and family office investors
• Entrepreneurs growing through acquisitions (e.g. practices, agencies, trades, services)
• M&A advisors, students and investment banking candidates

YOU RECEIVE
• 1 Excel file (.xlsx), English, 10 years, amounts in EUR thousands (works for any currency)
• Example values to guide you – simply overwrite them
• No macros, no circular references, optimised for Microsoft Excel

PLEASE NOTE
• Digital download – nothing will be shipped.
• Taxes simplified via a tax rate.
• This model does not replace tax, legal or transaction advice.