Private Equity – Leveraged Buyout Model

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 templates 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
  • Internal Rate of Return Analysis
The financial model template is available in a LIGHT and a FULL Version. The FULL Version has the additional features:

 

LIGHT Version
  • Valuation date at year end
  • IRR calculation
  • Yearly financial projections
FULL Version
  • 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

 

Add to wish list
Purchase Excluding 8% tax

 

Screenshots

 

Financial Overview

Financial Overview

 

Key Financial Ratios

Key Financail Ratios

 

Quarterly Income Statement Pre/Post Transaction

Quarterly Income Statement Pre/Post Transaction

 

Quarterly Cash Flow Statement Pre/Post Transaction

Quarterly Cash Flow Statement Pre/Post Transaction

 

Quarterly Balance Sheet Pre/Post Transaction

Quarterly Balance Sheet Pre/Post Transaction

 

Shareholder’s Equity Table

Shareholder's Equity Table

 

Debt Financing Schedule

Debt Financing Schedule

 

Discounted Free Cash Flow Valuation

Discounted Free Cash Flow Valuation

 

 

Internal Rate of Return and Cash on Cash Multiple Calculation

Internal Rate of Return and Cash on Cash Multiple Calculation

 

Executive Summary Private Equity View

Executive Summary Private Equity View

 

Charts with Key Financial Metrics

Charts with Key Financial Metrics

 

Add to wish list
Purchase Excluding 8% tax

 

Users who purchased Private Equity – Leveraged Buyout Model, also purchased:
Equipment Rental Cash Flow Model
Equipment Rental
  •  x 
  •  x 
Add to wish list
Purchase Excluding 8% tax
Commercial Real Estate Investment Model
Commercial Real Estate Investment
Add to wish list
Purchase Excluding 8% tax
Gold Mine Investment Model
Gold Mining
Add to wish list
Purchase Excluding 8% tax
Industry ,
Summary 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.
Screenshots / Pictures
Use Cases , , , , , ,

Write a Review