Leveraged Buyout LBO Model
A fully customizable excel LBO model to assess the debt level your firm can take in a deal & expected investor returns
Why waste time making your own Leveraged Buyout Model?
A leveraged buyout model shows what happens when a private equity firm or private investors acquire a company using a combination of equity and debt, and then sells it in 3-5 years. Leveraged buyouts are similar to normal M&A deals, but in an LBO you assume that the buyer is a financial investor and sells the target in the future.
* Input major inputs on Summary worksheet (all inputs in blue).
* Input company historical financial information on Historical Financials worksheet (all inputs in blue).
* Input assumptions for future periods on Assumptions worksheet (all inputs in blue).
* Optional assumptions on Projected Financials worksheet (all inputs in blue).
* Optional assumptions on Return Analysis worksheet (all inputs in blue).
* Model assumes 100% acquisition of target company.
* Model assumes most recent year-end balance sheet is closing balance sheet for transaction.
* Model assumes no step-up in asset values.
* Model assumes no amortization of goodwill from acquisition.
* Transaction amount (Uses of Funds) is expected to equal Financing Amounts (Sources of Funds).
* Debt amortization = "Yes" results in equal annual amortization.
* Debt amortization = "No" results in balloon repayment.
* Short-term debt is not amortized in model.
* Model assumes investment exit in 5th year following acquisition.
* Use Print -> Entire workbook to print all pages.
- Firmex Team
This business tool includes
1 Excel Model
Firmex offers you this business tool for free!
Download for free
- Reece P.(last updated: 04/12/2017 14:30)
- Alfonso Cioffi(last updated: 12/10/2017 20:22)
- Long Lê(last updated: 08/10/2017 11:03)
- Bhavna Katre(last updated: 29/09/2017 19:11)
- Vaibhav Chandoli(last updated: 19/07/2017 14:00)
People using this tool also downloaded
Any questions on Leveraged Buyout LBO Model?
The user community and author are here to help. Go ahead!