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.
Corkscrews and models
From the course: Financial Modeling Foundations
Corkscrews and models
- [Instructor] More complex financial models often build simpler models, put them together, and link them in various ways. They also incorporate more advanced tools like corkscrews. Let's take a look at an example. I'm in the 05_02_Begin Excel file. So, we have this model for Acme Financial, and as you can see, we've got a three-statement model here, and I've changed the formatting on this versus what we'd seen previously. This is a more advanced and kind of more professional, but more complex format to see, but looks nicer. And we've essentially combined our three-statement model with a DCF model and an LBO model, or leveraged buyout model. Let's take a look at this model though and see kind of how this links everything together. So in particular, I wanna start up here at the top and you'll see that we built this model for an initial evaluation in 2017, but then we're gonna update this for the year 2024 and 2025. So I've…
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)
-
-
-
-