Analytics and Output Reporting 127
FIGURE 8.1 Cash In versus Cash Out helps
prevent funds from being ‘‘created’’ in the
model.
6.Next go to the Inputs sheet. Since most of the model is controlled from this
sheet it is useful to make sure the model is running correctly as assumptions are
changed. Label cell I3TESTSand I4CashIn=CashOut. Go to cell L4 and
enter the following formula:
=IF('Cash Flow'!CL5=0,"OK","ERROR")
This formula checks the sum of the cash in versus cash out differences to see if
it is zero. If it is then the model is working correctly, otherwise there is an error.
Many of the tests will be set up using this IF statement format with either an OK
or ERROR return. Conditional formatting is particularly useful here so that it is
very obvious when there is an error. If unfamiliar with conditional formatting,
see the ToolBox section of this chapter. Otherwise make the cell shading green
and font bold white for when the cell is OK and red shaded with bold white
font when there is an ERROR.
FIGURE 8.2 The TESTS section is on the Inputs sheet for quick reference.
