Country: Canada
You are in the Canada edition. Type your country to switch.
Nigeria
The Americas
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the Canada edition, with examples in dollars and from Canada.
Your learning profile
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.
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: Most errors are ordinary, not started
- Step 2: Mechanical errors in formulas, not started
- Step 3: Units, currencies and signs, not started
- Step 4: Structural and economic errors, not started
- Step 5: When ordinary errors had large consequences, not started
About 9 min of reading
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.
Popular this week: Basics: BeginnerCanadian markets: Beginner