This is a detailed and easy-to-use Leveraged Buyout (LBO) financial model. This is a modular financial model meaning that relevant calculations are separated into separate tabs that can be used to perform the LBO analysis for any company. More complex models at the most basic level are separated into 1) inputs; 2) calculations; and 3) outputs. In simplistic models, these items are often grouped into a single tab.
The model template does not overcomplicate the analysis by including too many inputs and assumptions, calculations, and outputs, but rather focuses on key inputs and assumptions required to derive the most relevant outputs (i.e. investor returns, credit metrics, and acquisition structure).
Included is a financial model template and a brief LBO overview presentation.
I have used the following structural approach for every model that I have built, which users have always found to be clean, practical, easy to follow, and user-friendly. Sections may vary somewhat depending on the complexity of the model but the basic layout remains the same.
The sections of this model template are as follows:
1. Title Page: A brief description of the model’s purpose. Contact information can also be included here.
2. Summary Tab: Key outputs from the LBO analysis are presented here in graphical and tabular format, including forecast EBITDA and cash flow, credit metrics, transaction structure, and financing, sources and uses of cash, and investment returns.
3. Sensitivities Tab: Equity return sensitivities that the user can rely on to test the robustness of the valuation.
4. Assumptions Tab: Inputs and assumptions that drive the model, and include target financial information, acquisition, and valuation assumptions, and financing inputs.
5. Returns Tab: A simple and easy-to-follow calculation of the returns by investor type (debt and equity investors) as well as DCF valuation of the target company.
6. LBO Structure Tab: Detailed but easy-to-follow calculations of the acquisition structure, including equity purchase price, acquisition financing, transaction costs, the fair market value bump and goodwill arising from the acquisition, and the key pro forma financial statement items at the closing of the transaction.
7. Financial Forecast Tab: Financial projections that drive the valuation. In this model, the forecast itself is illustrative only and can be replaced with the user’s own forecast. The most important items that are needed from any financial forecast for valuation purposes are: EBITDA, depreciation, interest expense, capital expenditures, and changes in non-cash working capital. Credit metrics and detailed debt amortization schedules are also provided here as supporting schedules.
8. WACC Tab: The information in this tab is illustrative as well and should be replaced with actual comparable companies that are relevant to the user’s situation. The weighted-average cost of capital (WACC) is used as the discount rate in the DCF valuation.
9. Diluted Securities Tab: Inputs to calculate the impact of potentially dilutive securities.
The model template utilizes 10 years for the forecast period.
Again, this is a detailed but user-friendly model that can be used to perform an LBO analysis for any company.
Similar Products
Other customers were also interested in...
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
3 Statement Financial Modeling with DCF & Rel...
Financial Modeling Tutorial guides user via step by step approach on how to build financial models w... Read more
Franchisor Licensing: Financial Model with Cap Tab...
Build up to a 10 year financial forecast with assumptions directly related to the startup and operat... Read more
Joint Venture and Fund Cash Flow Waterfall Templat...
Here are all the spreadsheets I've built that involve cash flow distributions between GP/LP. Include... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
Leveraged Buyout (LBO) Model
Leveraged Buy Out (LBO) Model presents the business case of the purchase of a company by using a hig... Read more
Advanced Financial Model with DCF & Valuation
General Overview Advanced Financial Model suitable for any type of business/industry and fully cu... Read more
Small Business Playbook (Financial / Tracking Temp...
About the Template Bundle: https://youtu.be/FPj9x-Ahajs These templates were built with the ... Read more
Corporate Finance Toolkit – 24 Financial Mod...
They are essential models to increase your productivity, plan your future with budgeting and forecas... Read more
Reviews
The LBO model is useful and highlights some aspects of debt and leverage.
1 of 2 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
You must log in to submit a review.