Leveraged Buyout LBO Model

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.

Instructions:

* 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