Skip to content
Edition NigeriaGlobal
Country: Papua New Guinea

You are in the Papua New Guinea edition. Type your country to switch.

Set up your profile

You are learning in the Papua New Guinea edition, with examples in kina and from Papua New Guinea.

Financial modelling · Lesson 5 of 6

Common financial modelling errors

Most 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 terminal value that assumes the impossible. Several widely reported cases show that such errors can change public decisions and cost firms heavily.

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 name the most common mechanical errors in financial models and how to prevent each one.
  • You can spot unit, currency and sign errors in data drawn from several sources.
  • You can recognise economic errors, such as growth above the discount rate or mixing nominal and real figures.
  • You can describe widely reported cases in which spreadsheet errors affected public decisions and large losses.

Key terms in this lesson

Hard-coded value
A number typed directly into a formula or calculation cell rather than linked to a labelled input. A common cause of modelling errors.

Step 1 of 5

Most errors are ordinary

Opening this step…

Step 2 of 5

Mechanical errors in formulas

This step opens when you finish the one above.

Step 3 of 5

Units, currencies and signs

This step opens when you finish the one above.

Step 4 of 5

Structural and economic errors

This step opens when you finish the one above.

Step 5 of 5

When ordinary errors had large consequences

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 & 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 & analyticsVaR and tracking error: methods …Read nowVaR and tracking error: methods and limitsFinancial data & analytics · Advanced · 15 minFinancial data & analyticsChecking a financial modelRead nowChecking a financial modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsforecasts fail, and stating unce…Read nowWhy forecasts fail, and stating uncertainty honestlyFinancial data & analytics · Advanced · 15 minMacro & global marketsInflation and real returns: what…Read nowInflation and real returns: what you really earnMacro & global markets · Beginner · 15 minFinancial data & analyticsBuilding a three-statement modelRead nowBuilding a three-statement modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsSurvivorship, missing data, time…Read nowSurvivorship, missing data, time zones, calendars and currenciesFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsScenarios and sensitivities in a…Read nowScenarios and sensitivities in a modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsBuilding a DCF in a modelRead nowBuilding a DCF in a modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsReading tables, charts and log s…Read nowReading tables, charts and log scalesFinancial data & analytics · Beginner · 15 min
English