Overview
A leveraged buyout (LBO) model is constructed in the event of a an acquisition funded with a significant amount of debt to evaluate the transaction. In an LBO transaction, the assets of the target company and acquiring company are used as collateral for the loans to fund the deal. The acquirer aims at using the minimum amount of equity financing and fund the rest of the purchase price with debt, which enables investors to maximize their risk-adjusted internal rate of return (IRR). A detailed LBO model is therefore built to determine the expected return on equity and target purchase price, which tells the acquirer whether it is a worthy investment or not.

Components of the Detailed LBO Model

This model consists of several important components that all LBO models must have:

Inputs

The input worksheet contains all assumptions and information required to perform the LBO analysis, including the number of shares outstanding as of the transaction date, options outstanding, and consensus street estimates on the company's key financial data such as net sales, net income, and diluted EPS.

Projections

The projections worksheet presents the three financial statements (income statement, balance sheet, cash flow statement) which contains three years of historical financial data and five years of forecast generated based on the assumptions. It also lays out the capitalization summary detailing the forecast capital structure of the target company (use of equity or different types of debt) and interest expenses.

LBO

This is the main part of the entire LBO model. The LBO worksheet consists of multiple important sections for the leveraged buyout analysis:
  • Transaction Summary: lays out the use of funds, source of funds, transaction multiples, leverage profile, and return to common equity.
  • Transaction Assumptions: includes goodwill and other intangibles, financing assumptions, mandatory amortization schedule, and other amortization schedules.
  • Pro Forma Balance Sheet: opening balance sheet, accounting adjustments, financing adjustments, and pro forma balance sheet.
  • Three Financial Statements: income statement, balance sheet, and cash flow statement after the LBO transaction.
  • Capitalization Summary and Calculation of Net Interest Expense: amount in each of the capital stack, repayment schedules, interest expense schedule.
  • Valuation Calculations: calculations of enterprise value and equity value based on trailing EBITDA multiples, as well as equity value to management and equity value to outside equity.
  • Returns to Common Equity: returns for equity investors in the LBO transaction.

LBO Tables

This worksheet includes two-way sensitivity analysis tables on the internal return on return (IRR) based on the purchase price per share and exit multiple.

DCF Analysis

This worksheet contains the discounted cash flow analysis of the target company, which includes the calculation of free cash flow to the firm (FCFF) and the terminal value using the EBITDA multiple method.

Screenshot from the template.

Who Should Use This Model

This detailed LBO model is an excellent tool for finance professionals in private equity or any other areas of corporate finance who would like to perform an in-depth LBO analysis on a target company and determine its target price based on a set of assumptions and specified capital structure.
Share
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
restructuring financial model template preview 1 Restructuring Financial Model Template
198
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
311
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
bank financial model template preview 1 Bank Financial Model Template
294
0
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Synthetic Call Chart Option Profit/Loss Graph Maker
897
238
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
720
0
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
421
106
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…