12.03.2023
The course is very excellent as well as the instructor teaching style.
A comprehensive hands-on guide to leveraged buyout valuation. Learn how to create an LBO model in Excel from scratch.
Do you want to learn the ins and outs of an exciting acquisition strategy? Are you looking for an opportunity to improve your financial modeling skills? This LBO Modeling in Excel course is the perfect fit for you. It combines leveraged buyout theory with two hands-on case studies that bridge LBO theory and the practical application needed when working in a real-world environment. Understanding the mechanics and details behind a leveraged buyout deal can be rewarding for every finance professional. These are complex transactions involving different financial instruments, covenants, and structures. Therefore, this LBO Modeling in Excel course is an excellent choice for professional development and continuous learning. The two extensive LBO case studies you’ll partake in have different difficulty levels. The first one represents the so-called ‘paper LBO’—a simple one-page financial model that’s easy to understand and suitable for beginners. (A frequently asked task in investment banking interviews is creating a paper LBO financial model). The second model we’ll create (step-by-step) together is significantly more complicated. It involves calculating transaction fees and goodwill, creating a fixed asset roll forward, P&L, Balance sheet, cash flow, equity, and debt schedule. This involves a greater level of detail than the paper LBO model. This task will help you improve your financial modeling skills by working on a sophisticated multi-layered LBO valuation. This LBO modeling course is highly recommended if you wish to pursue a career in investment banking or investment analysis. It teaches you concepts and skills that are frequently asked about during the recruitment process.
In this LBO Modeling in Excel course, theory and practice go hand in hand. We introduce the fundamental approach behind leveraged buyouts (LBOs) and work on practical case studies that will reinforce theoretical concepts and teach you how to create an LBO model in an authentic work environment.
In the first section of this LBO modeling course, you’ll learn about leveraged buyouts, how an LBO works, who the lenders are, how to measure a firm’s debt capacity, when an LBO is a feasible option, how to determine the fair price investors would be willing to offer to execute an LBO transaction, and exit strategies LBO investors could pursue.
What is an LBO? Free How an LBO work in practice Free Who are the lenders in an LBO Free What is debt capacity and hot to define the maximum debt capacity in an LBO deal? When is an LBO a feasible option? How to determine the maximum LBO price The different types of LBO strategies that can be pursued by financial sponsorsIn 2013, Michael Dell partnered with investment firm Silver Lake in a deal aiming to delist Dell from public markets. This is the company he had started 29 years earlier. At the time, analysts believed Dell wasn’t positioned well from a strategic perspective because they were too reliant on PC sales, a segment that was slowing down due to the introduction of devices such as tablets and smartphones, which caused shifting consumer behaviour. Mr Dell, on the other hand, saw things differently. He believed the company was uniquely positioned, as a process of transition that started in 2008 was now running its course. In short, this is the context, which led to the Dell LBO.
Dell case study - Intro to the deal Dell case study - Dell's business from a strategic perspective Dell case study - Parameters and specifics of the deal Dell case study - The aftermathThis section teaches you how to create your first LBO model: a paper LBO. This simple, intuitive exercise allows you to reinforce the theory learned in the first part of the course.
Intro to the Paper LBO exercise Working on debt capacity of the deal Obtaining equity needed for the LBO deal Filling in P&L projections Working on Debt schedule and P&L completion Calculating Cash Flow Completing financial projections Obtaining Equity at exit and IRR Sensitivity analysiswith Ned Krastev