Skip to content
Edition NigeriaGlobal
Country: Switzerland

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

Set up your profile

You are learning in the Switzerland edition, with examples in francs and from Switzerland.

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 minFinancial data & analyticsBuilding a three-statement modelRead nowBuilding a three-statement modelFinancial data & analytics · Advanced · 15 minAI & securityModel risk management and explai…Read nowModel risk management and explainabilityAI & security · Advanced · 15 minFinancial data & analyticsData governance: licences, linea…Read nowData governance: licences, lineage, market-sensitive data and model riskFinancial data & analytics · Advanced · 15 minFinancial data & analyticsScenarios and sensitivities in a…Read nowScenarios and sensitivities in a modelFinancial data & analytics · Advanced · 15 minInvestment researchResearch data management: reprod…Read nowResearch data management: reproducible models and an audit trailInvestment research · Advanced · 15 minFinancial data & analyticsPivot tables for financial dataRead nowPivot tables for financial dataFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsBuilding a simple valuation mode…Read nowBuilding a simple valuation model from dataFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsLab 7: watching a model overfitRead nowLab 7: watching a model overfitFinancial data & analytics · Advanced · 15 min
English