Modeling for Business
Forward-Looking Models
Your data doesn’t just give a snapshot of your company’s past, it also holds the key to its future. Forward-looking financial models use patterns in existing data to predict future outcomes. In this course, you’ll explore how to build these models in Excel to give your business decisions concrete numbers to rely on.
Advanced    18 Lessons    150 Minutes    CPD Credits
About This Course
To make predictions about business outcomes, financial modelling uses patterns in existing data to offer an idea of the risk involved. Forward-looking models are a valuable tool in that process.
Across 18 lessons, you’ll learn how to structure and build your model, exploring decision trees, risk-weighted cash flows, tornado charts, and many more tools.
By the end of this course, you’ll understand the risks involved in predicting future outcomes, and feel confident in helping your team make calculated decisions based on your models.
Learning Outcomes
-
Create a decision tree to understand a business problem
-
Create model formulas that responds to model input changes
-
Use intermediate variables to simplify calculations
-
Create tornado charts
-
Build multiple scenarios for a model
-
Limit the possible values of model inputs
Lessons
1. What's New in Forward-Looking Models
2. Decision Trees
4. Structure Model in Excel
5. Make Your Model Responsive
6. Shorten Formulas with New Variables
Read More
7. Risk-Weighted Cashflows
8. Tornado Charts Part 1
9. Tornado Charts Part 2
10. Update Warnings for Charts
11. Adding Taxes to Our Model
12. Building Multiple Scenarios Part 1
13. Building Multiple Scenarios Part 2
14. Analyzing Our Scenarios
15. Formula Auditing with Colorize
16. Restrict Model Inputs
17. Recommendations to SupraChem
18. Limitations of SupraChem Model
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
