Calculator and coins representing private equity leveraged buyout analysis

Financial Model, General Excel Financial Models

DCF Model, Excel, Financial Projections, IRR (Internal Rate of Return), LBO (Levered Buyout), PDF, Private Equity, Valuation

The Private Equity Leveraged Buyout Model offers a simple template to calculate the financial returns (IRR and cash on cash multiple) of a leveraged buyout acquisition from a Private Equity investment perspective.

This financial model template offers the following:

Financial projections over 10 years (Income Statement, Balance Sheet and Cash Flow Statement)
Detailed Debt Financing Schedule
Table with Sources and Uses of Funds
Fixed Asset Schedule
Valuation date at year-end
Yearly financial projections
Internal Rate of Return (IRR) Analysis
Quarterly Financials and Last Twelve Months
Closing Date and Valuation date mid-year
Mezzanine – interest paid in kind (PIK)
Seller financing option
Equity injection option
Shareholder structure with stake % and dilution table
Number of shares, Value per Share, Earnings per Share
Share Premium
Chart with EBITDA Bridge between acquisition and exit date
Chart with more details on capital expenditures (CAPEX), Financial Debt and Debt/EBITDA ratios

The financial model template is available as a Free PDF Demo Version and a fully editable Excel model.

File types:

.pdf (Adobe Acrobat Reader)

.xlsx (Microsoft Excel)

You must log in to submit a review.