Skip to content
Edition NigeriaGlobal
Country: Malaysia

You are in the Malaysia edition. Type your country to switch.

Set up your profile

You are learning in the Malaysia edition, with examples in ringgit and from Malaysia.

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.

Advanced11 min read5 steps

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 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.

Up next

Financial data & analyticsCommon financial modelling errorsRead nowCommon financial modelling errorsFinancial data & analytics · Advanced · 15 minFinancial data & analyticsPresenting a financial modelRead nowPresenting a financial modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsPerformance attribution: where t…Read nowPerformance attribution: where the return came fromFinancial data & analytics · Advanced · 15 minFinancial data & analyticsSharpe, Sortino and benchmark co…Read nowSharpe, Sortino and benchmark comparisonFinancial data & analytics · Advanced · 15 minEthical & Islamic investingGreen bonds, green sukuk and sus…Read nowGreen bonds, green sukuk and sustainability-linked debtEthical & Islamic investing · Advanced · 15 minAdvanced strategies & derivativesPairs and relative value in plai…Read nowPairs and relative value in plain termsAdvanced strategies & derivatives · Advanced · 5 minFunds & ETFsETFs vs mutual funds: which is w…Read nowETFs vs mutual funds: which is which?Funds & ETFs · Intermediate · 5 minMedia strategy & planningGRPs, TRPs and impressionsRead nowGRPs, TRPs and impressionsMedia strategy & planning · Intermediate · 5 minMarket operationsMargin and risk desks in operati…Read nowMargin and risk desks in operationsMarket operations · Intermediate · 15 minRisk, governance & ethicsEthical decision-making: a step-…Read nowEthical decision-making: a step-by-step frameworkRisk, governance & ethics · Beginner · 15 minMalaysian marketsBursa Malaysia (Bursa)Read nowWhat is Bursa Malaysia (Bursa)?Malaysian markets · Beginner · 15 minFinancial journalismAttribution and quotes: who says…Read nowAttribution and quotes: who says so, and whereFinancial journalism · Beginner · 15 min
English