From the course: Financial Modeling Foundations
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Beyond the basics in financial models
From the course: Financial Modeling Foundations
Beyond the basics in financial models
- [Instructor] We've gone through and created a three-statement model and a DCF model, and those are fine, but they're also fairly simplistic models. We often need more advanced models when it comes to modeling buyouts of other firms or complicated deals. In particular, we need to be able to examine the cash flows in the future and then show actions dependent on those cash flows. There are three key modeling techniques that we're gonna need to talk about, corkscrews, toggles, and waterfalls. Each of these help to create more robust models that represent more complex actions in corporate finance. And advanced models often link simpler models together. For example, our DCF model might be linked to a buyout model, which is linked to our three-statement model. Building out this type of structure, then, allows us to see how changes flow through from one part of the model to another based on the assumptions that we make.…
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.
Contents
-
-
-
-
-
-
-
(Locked)
Beyond the basics in financial models1m 28s
-
(Locked)
Corkscrews and models5m 46s
-
(Locked)
Waterfalls and models3m 22s
-
(Locked)
Adding toggles to a financial model2m 29s
-
(Locked)
Model outputs4m 4s
-
(Locked)
Hiding tabs and making models readable6m 13s
-
(Locked)
Stress testing models4m 27s
-
(Locked)
-
-
-
-