Analysis and presentation
Reviewing a model
Audit a colleague's three-statement model: find the hard-code, the broken reference, the sign error, the missing link and the faulty check — and fix them.
Learning objectives
- Review a model systematically: checks first, then row consistency, hard-codes, signs and plugs
- Explain how each error type distorts the outputs or hides other errors
- Correct the errors so the model balances and its checks are genuine
Most models you work on were built by someone else, under time pressure. Before you rely on one — or send it to a lender — you review it. A good reviewer doesn't read every cell at random; they look for the errors that experience says are most common and most damaging.
In this lesson a colleague hands you the integrated Rawdah Home Retail Co. model from the three-statement lesson. The schedules and inputs are fine, but five errors have crept into the statements and checks. Rawdah Home Retail Co. is a fictional retailer; all figures are SAR millions and illustrative.
A review routine
- Check the checks. What does each check actually compare? A check that can never fail (or always fails) is worse than none.
- Look for plugs. Any balance-sheet line calculated as "whatever makes it balance" — usually cash or equity — hides every other error.
- Read each row across. A formula should be the same in every forecast column; one that differs (a different column reference, a number instead of a formula) is suspect.
- Hunt hard-codes. Numbers typed into calculation tabs don't move when inputs change. Flex an input and see what fails to follow.
- Check signs. On the cash flow, outflows are negative; a line already signed as (increase)/decrease must not be flipped again.
Included with a Formula Quest membership
The rest of this lesson is for members. Members get the full lesson, including its 3 graded exercises, and every other Finance Quest lesson.
That's the last lesson in Financial Modeling
Prove what you've learned with this track's assessed work — it counts towards your certificate.