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
- What is a Leveraged Buyout (LBO)?
- How to Build a LBO Model
- Transaction Assumptions Part 1
- Transaction Assumptions Part 2
- Secured Debt
- Unsecured Debt
- Entering Our Loan Structure in Excel
- Creating the Debt Schedule
- Calculating the Cash Balance
- Amending Our Transaction Assumptions
- Key Metrics for Covenants
- Estimating Our Returns from the LBO
- Conclusions and Improvements
Contact us
If you have any questions regarding this or any other CPD course or
requirements, please feel free to contact the team here or call us at (+353) 01 523 3930