The acquisition of another company using a significant amount of borrowed money (bonds or loans) to meet the cost of an acquisition is named a Leveraged Buyout Analysis. It is used to determine an implied valuation range for a given target in a potential LBO sale based on achieving acceptable returns.
Step by step LBO Valuation tutorial
In these coming four steps, you will be able to perform your own LBO Analysis. This LBO model is simplified in order to teach you the basics of a LBO valuation.
Sneak peek of the LBO model (click to enlarge screenshots)
You need to activate “iterations” in Excel for this LBO model to work properly. It can be switched on under Excel options / formulas / then check the box “Enable iterative calculations”. See picture here for help (if needed).