
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)