From the course: Advanced Python in Excel for Finance: A Hands-On Approach
Join today to access over 24,600 courses taught by industry experts.
Financial modeling: Part 2
From the course: Advanced Python in Excel for Finance: A Hands-On Approach
Financial modeling: Part 2
- [Instructor] For financial modeling two, let's delve into more advanced topics, such as leverage, buyout modeling, merger and acquisitions modeling and advanced DCF techniques. These scripts will illustrate how to set up these more complex models in Python, leveraging the bundles and AMPI libraries for competitions. Let's start with the leveraged buyout model. An LBO model involves financing a significant portion of the purchase price of a company with debt and then using the company's cash flows to pay off the debt over time. So for the LBO modeling, let's start by creating LBO model data, which are important like the year, the EBITDA, the CapEx, the working capital increase in the debt repayment. Those are the significant portions we need. And we can use our own data set for this case, can just create like a very simple data, let's call it LBO data. And it's given by, it's a dictionary with year, as one of the variables and its range of 2021 to 2028. Right. And the next we have…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.