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.
Waterfalls and models
From the course: Financial Modeling Foundations
Waterfalls and models
- [Instructor] Complex financial models are often used to help us to understand where cash is flowing, particularly when it flows to a variety of different investors at various levels based on the capital they've committed. This is what we refer to as a cash flow waterfall. Here's an illustration of a cash flow waterfall. Essentially, we might start out with capital coming in and we can think about that as water pouring into a bucket. Then from there, some of that cash flow is paid out for project operation and maintenance, right? Operating the firm. Remaining cash flow after project operation and maintenance are taken care of, goes towards senior debt service. Then after senior debt services covered, remaining cash flow goes towards senior debt service reserves. Then after those reserves are covered, additional cash flow flows through in returns to the project sponsor that is the investors. We need a model that helps…
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)
-
-
-
-