Skip to main content
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
Start Today

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.

Start Today

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


1. What's New in Forward-Looking Models
2. Decision Trees
3. Build an Influence Diagram
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.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world