Scenarios, Ratios and Analysis
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.
of video
course files
test questions
modules
What you will be able to do
Set Base, Upside and Downside values for the eleven inputs that move the forecast.
One cell moves the whole model, and no live input can read the wrong case.
Run every case with the circularity switch off and on, and prove the checks still pass.
Profitability, liquidity, leverage and efficiency, and when each one misleads.
Split ROE into three and then five DuPont drivers, and tie both back to the reported figure.
Read a trend for direction and pace, then write up a company's Downside case yourself.
Who it's for
Stress-test a forecast and explain the ratios, the way interviews and case studies ask you to.
Add the scenarios and ratio analysis that turn a budget into a discussion.
Practical CPD in analysing financial statements, on a real listed company.
Get ahead of your classmates. Learn the analysis employers test in interviews, before you even graduate.
What's inside
One forecast, three futures, one switch.
Turn the numbers into a view you can defend.
Join students, analysts and finance professionals who are building practical modelling skills.