The integrity of your model is vital in business. Users need to be confident in the figures that are produced and do not want to spend time going through each of their formulas to check for accuracy. The way Excel-Financial-Model overcomes this is an extensive integration of checksums and sanity checks.
All model specific checksums (more than 30 different control cells => see below screenshot) are consolidated in the integrity and error checks section at the bottom of the "Inputs" sheet. This section is where you will be alerted of any errors anywhere in your model workbook. An error produces a flag and the message “FAIL” in red in column "H" (see screenshot).
The master integrity flag is linked to the header of every sheet. It indicates if any error is preventing your model from calculating correctly. This helps ensure the maximum integrity of your model. The screenshot below ("Sales" sheet), shows the master model integrity indicating an error (“Fail”). The following general procedure should help locate and eliminate errors: 1.Click on the link “Go to error checks” This takes you to the integrity and error checks section on the “Inputs” sheet. 2.Pinpoint the location and description of the error in the table. If there is more than one error message, solve one problem at a time. 3.Click on the appropriate link "To control cell". This takes you to the calculation, causing the error 4.Locate and eliminate the cause by changing inputs or assumptions.
|