Financial Modeling Essentials
Leveraged Buyouts
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.
Learning Outcomes
-
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
Lessons
1. What is a Leveraged Buyout (LBO)?
2. How to Build a LBO Model
4. Transaction Assumptions Part 2
5. Secured Debt
6. Unsecured Debt
Read More
7. Entering Our Loan Structure in Excel
8. Creating the Debt Schedule
9. Calculating the Cash Balance
10. Amending Our Transaction Assumptions
11. Key Metrics for Covenants
12. Estimating Our Returns from the LBO
13. Conclusions and Improvements
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
