Country: Saudi Arabia
You are in the Saudi Arabia edition. Type your country to switch.
Nigeria
Middle East
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the Saudi Arabia edition, with examples in riyals and from Saudi Arabia.
Your learning profile
Advanced path · Free course
Financial modelling
Build and check a model: a three-statement model, a DCF, scenarios and sensitivities, checking a model, common modelling errors and presenting a model.
- Advanced level
- 6 lessons
- 1 hour of study
- 1 final test
- $10 certificate
- Saudi Arabia edition
Education, not advice: this course explains how products and rules work. It does not recommend any product, trade or provider.
What you will learn
- By the end you can lay out a financial model with separate inputs, historical figures, calculations and outputs.
- By the end you can calculate unlevered free cash flow from a three-statement model.
- By the end you can build a scenario switch that moves a whole model between consistent sets of assumptions.
- By the end you can build a block of automatic checks into a model and know what each one catches.
- By the end you can name the most common mechanical errors in financial models and how to prevent each one.
- By the end you can structure a model presentation that leads with the answer, the range and the main drivers.
Skills you will practise
Syllabus
-
Building a three-statement modelA three-statement model forecasts the income statement, balance sheet and cash-flow statement together from a short list of drivers. The statements a…
11 min · 5 steps
- Why model all three statements
- Layout: inputs, history, calculations and outputs
- Forecasting from drivers
- Linking the statements and the balance check
- Debt, interest and the circular reference
- Lesson quiz
-
Building a DCF in a modelA DCF built on a three-statement model takes each year's unlevered free cash flow, discounts it at the weighted average cost of capital, adds a termi…
11 min · 5 steps
- From the model to free cash flow
- The discount rate: the weighted average cost of capital
- Terminal value: the cell that matters most
- Discounting and timing conventions
- From enterprise value to value per share
- Lesson quiz
-
Scenarios and sensitivities in a modelA model should show a range, not a point. A scenario switch moves the whole model between consistent sets of assumptions, sensitivity tables show how…
10 min · 5 steps
- Why a model must show a range
- Building the scenario switch
- Making scenarios consistent
- Sensitivity tables and the tornado chart
- Probability weighting, breakevens and their limits
- Lesson quiz
-
Checking a financial modelChecking a model means testing that it is built correctly, that its numbers make economic sense and that someone else can follow it. Built-in checks …
11 min · 5 steps
- Three kinds of check
- Mechanical checks built into the model
- Sense checks: does the story make sense?
- Reviewing someone else's model
- Version control and logs
- Lesson quiz
-
Common financial modelling errorsMost modelling errors are ordinary: a typed-in number, a wrong sign, mixed units or currencies, a range that stops too soon, double counting, or a te…
11 min · 5 steps
- Most errors are ordinary
- Mechanical errors in formulas
- Units, currencies and signs
- Structural and economic errors
- When ordinary errors had large consequences
- Lesson quiz
-
Presenting a financial modelA model is useful only if decision-makers understand what it says and how much to trust it. A good presentation starts with the answer and its range,…
10 min · 5 steps
- Start with the decision, not the spreadsheet
- The one-page summary
- Charts that compare honestly
- Explaining assumptions, risks and limits
- Documentation and handing over
- Lesson quiz
Final test
A fresh set of questions drawn from every lesson of this course, timed, with the options in a new order every time. You need 85% to pass, and passing earns your certificate.