Complete LBO Underwriting Financial Model - Excel Template

Description
This complete LBO underwriting financial model is a reusable Excel starting point for evaluating leveraged buyouts from entry valuation through sponsor exit.

The populated workbook links purchase price, transaction fees, financing, management rollover and sponsor equity into a seven-year operating forecast. Users can switch among Base, Upside and Downside cases and select a three- to seven-year hold period.


The debt engine covers a revolver, term loan A, term loan B and mezzanine debt, including OID, mandatory amortization, average-balance cash interest, PIK and priority cash sweeps. An optional add-on module incorporates acquisition timing, purchase multiple, debt funding, synergies and integration costs.


Outputs include net debt, leverage, exit enterprise value, sponsor proceeds, MOIC, IRR, covenant headroom and a dedicated investment committee dashboard. Sensitivity tables show how returns change across entry and exit multiples. A checks tab tests sources and uses, debt balances, liquidity, selected cases, return links and add-on timing.


The workbook contains a fully populated illustrative example, clear input and formula conventions, no macros, and unlocked formulas in the paid version. It is designed for private equity professionals, independent sponsors, lenders, investment bankers, corporate development teams and finance students who need a structured underwriting template rather than a black-box calculator.


Illustrative assumptions are provided for planning and education only and should be adapted to the actual transaction, debt documents, tax rules and jurisdiction.