Quarterly Leveraged Buyout LBO Model
Originally published: 13/10/2016 17:26
Last version published: 16/10/2018 09:20
Publication number: ELQ-50818-4
View all versions & Certificate

Quarterly Leveraged Buyout LBO Model

An LBO model illustrating a number of detailed analytical techniques to construct an acquisition LBO model with history

A Leveraged Buyout is a transaction whereby a group of investors, for example, purchase a corporation with a mixture of equity and debt. The collateral for such a transaction is the company's cash flow, which is thus used to secure and eventually repay the borrowed money.

An LBO model is used to estimate the value of the company that is in line to be purchased. A financial forecast will be completed in order to predict the future growth or performance of the business. LBO models are therefore critical to the purchasing of a business as they represent the value of the transaction and what will be used to convince other investors/parties to the transaction to get on board.

Sections of this LBO model:
- Periodic Model
- Standalone Case
- LBO Summary
- Transaction and Pro-forma
- LBO Model
- Annual
- Quarterly and Annual
- Standalone Annual
- Prep Course Model
- Total Returns Chart
- Equity Returns Chart
- Functions

- Complex Working Capital in LBO Model (41 minutes)
- Revolver Analysis and Tax and Financing (1h24 minutes)
- Completion of LBO Model (41 minutes)
- IRR's and Annual Summary in LBO Model (22 minutes)
- Final Analysis and Quarterly/Annual (22 minutes)

This LBO Model & Associated Videos are linked to Ed's book, Chapter 4, which you can find also attached.

=> Ed Bodmer, 2016, edbodmer.wikispaces.com

This Best Practice includes
1 Excel Model, 5 Explanatory & Supporting Videos, 1 Supporting Excel File to Chapter 4

Acquire business license for $10.00

Add to cart

Add to bookmarks



keyboard_arrow_downShow all

People using this Best Practice also downloaded


More Best Practices from Prof. Ed Bodmer

See all

Any questions on Quarterly Leveraged Buyout LBO Model?

The user community and author are here to help. Go ahead!

4.7 / 5 (28 votes)

please wait...