O'Reilly logo

Mastering Cash Flow and Valuation Modelling by Alastair Day

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

18

Auditing and review

Model review

Self-checks

Excel audits tools

Consistency checks

Audit sheet

Summary

MODEL REVIEW

The model now needs to be reviewed and checked to eradicate errors in the code. Most companies do not appear to have a formal auditing process in place and allow spreadsheet models to be used without formal testing or any kind of review. It is normally certain that errors exist in the model even if it is a simple case of a misspelt label. Models have to be checked and you should always assume that there are errors until you are satisfied otherwise.

The level and amount of testing required depend on the size of the spreadsheet, the amount of funds processed and its importance in a document chain. If a spreadsheet model is for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required