Private Equity – Leveraged Buyout Model

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.

Private Equity Leveraged Buyout
,
, , , , , , ,

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)

Add to wish list
Excluding 8.1% tax

You must log in to submit a review.