Scenarios, Ratios and Analysis

Stress-test the forecast. Think like an analyst.

Take a finished model of a real listed company and turn it into a tool for planning and decisions. Build three cases, wire them to one switch, check nothing breaks, then calculate and interpret the ratios that investors, lenders and boards ask about.

50m

of video

17

course files

81

test questions

2

modules

What you will be able to do

Outcomes that matter

Build scenarios that hold up

Set Base, Upside and Downside values for the eleven inputs that move the forecast.

Wire a clean case switch

One cell moves the whole model, and no live input can read the wrong case.

Stress-test with confidence

Run every case with the circularity switch off and on, and prove the checks still pass.

Read the four ratio families

Profitability, liquidity, leverage and efficiency, and when each one misleads.

Decompose return on equity

Split ROE into three and then five DuPont drivers, and tie both back to the reported figure.

Turn numbers into a view

Read a trend for direction and pace, then write up a company's Downside case yourself.

Who it's for

Built for the ambitious

Aspiring bankers and equity analysts

Stress-test a forecast and explain the ratios, the way interviews and case studies ask you to.

Corporate finance and FP&A professionals

Add the scenarios and ratio analysis that turn a budget into a discussion.

Accountants

Practical CPD in analysing financial statements, on a real listed company.

Students

Get ahead of your classmates. Learn the analysis employers test in interviews, before you even graduate.

What's inside

The full curriculum

Module 1
Building the Scenarios

One forecast, three futures, one switch.

  • Scenario modelling: build Base, Upside and Downside cases
  • The eleven assumptions that move the whole forecast
  • What-if analysis: flip one switch, move the entire model
  • What could go wrong: stress-test the Downside before it happens
  • Integrity checks that hold in every case, circularity on or off
Module 2
Ratios and Analysis

Turn the numbers into a view you can defend.

  • Every key ratio: profitability, liquidity, leverage and efficiency
  • DuPont analysis: find what really drives return on equity
  • Read a trend for direction and pace
  • A worked analysis of the Base case
  • Your turn: write up the Downside case, with a model answer
50 minutes of on-demand video
17 course files
8 Dare To Do case studies
Essential Reading Pack
Self-paced

Ready to brief the investment committee?

Join students, analysts and finance professionals who are building practical modelling skills.

Scenarios, Ratios and Analysis