Country: United Arab Emirates
You are in the United Arab Emirates 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 United Arab Emirates edition, with examples in dirhams and from the United Arab Emirates.
Your learning profile
Financial modelling · Lesson 4 of 6
Checking a financial model
Checking 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 catch mechanical errors, ratio and history comparisons catch nonsense, and a structured review by a second person catches what the builder cannot see.
This lesson is complete in writing. A video for it is on its way.
What you will learn
- By the end you can build a block of automatic checks into a model and know what each one catches.
- You can test whether a model's outputs make economic sense by comparing ratios with history and peers.
- You can review someone else's model in a structured order, from purpose and structure to formulas and outputs.
- You can keep versions, a change log and an assumptions log so that every change can be explained.
Key terms in this lesson
- Return on capital employed
- Operating profit divided by the capital tied up in the business, usually total assets less current liabilities. Often shortened to ROCE.
- Model audit
- An independent, structured review of a model's logic, formulas, inputs and outputs, often done before an important decision.
- Version control
- Keeping each saved version of a file or model, with a note of what changed and why, so that any published version can be found and compared.
- Change log
- A record of every change made to a model or file, with the date, the person, what changed and why.
- Assumptions log
- A record of each assumption in a model with its value, reason or source, date and author, so the model can be reviewed and updated.
- Step 1: Three kinds of check, not started
- Step 2: Mechanical checks built into the model, not started
- Step 3: Sense checks: does the story make sense?, not started
- Step 4: Reviewing someone else's model, not started
- Step 5: Version control and logs, not started
About 10 min of reading
Step 1 of 5
Three kinds of check
Opening this step…
Step 2 of 5
Mechanical checks built into the model
This step opens when you finish the one above.
Step 3 of 5
Sense checks: does the story make sense?
This step opens when you finish the one above.
Step 4 of 5
Reviewing someone else's model
This step opens when you finish the one above.
Step 5 of 5
Version control and logs
This step opens when you finish the one above.
Key takeaways
The key takeaways open when you finish every step.
Lesson quiz
6 questions. You need 85% to pass.
The quiz opens when you finish every step.
Read first
Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.
Popular this week: Basics: BeginnerUAE markets: Beginner