Financial Modeling Essentials
Debt structures are very common in financial modeling and are required learning for analysts. In this course, you’ll learn how to use different forms of debt to complete a Leveraged Buyout.
Advanced 13 Lessons 120 Minutes CPD Credits
About This Course
Using debt to acquire a company is a common practice in the business world. In this course, you’ll learn how to assess the risks and benefits of this, by exploring how a Leveraged Buyout (LBO) can help.
Across 13 lessons, you’ll learn how to build, run and manipulate a LBO model in Excel, using an acquisition case study as an application example.
By the end of the course, you should have a clear understanding of the steps involved in an LBO and feel confident in helping your company with such an acquisition.
Build a Leveraged Buyout model in Excel
Define the assumptions of an LBO transaction
Understand the difference between secured and unsecured debt
Create a Sources and Uses table in Excel
Create a debt repayment schedule
Analyze the impact of adjusting transaction assumptions
Calculate debt service metrics
Calculate the returns from an LBO