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 ...

Get Mastering Cash Flow and Valuation Modelling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.