1.22 The user should enter all input variables before running the Spreadsheet. Failure to introduce reasonable values for all input values may cause the Spreadsheet to generate erroneous outputs. In the event that #DIV/0!s, #NUM!s or other error messages appear in the IRR section of the Output Box, revise the input values and click on the "IRR Stabiliser" switch. Similarly, in the event that there is non-convergence when testing the Indifference Points (this may arise if very large Indifference Point values are used causing "######" to appear in the Indifference Points section of the Output Box) then, having revised the Input Values, click on the "IP Stabiliser" switch.
1.23 In the unlikely event that error messages appear which are not cleared when pressing the stabiliser switches (having verified that all input values are appropriate) the "Default UC Factor" in the Output sheet may be adjusted either upwards or downwards until the errors messages are removed and the Spreadsheet re-run. Under no circumstances should the Unitary Charge Balancer value be manually changed.
1.24 Each time that the Spreadsheet is run, the user should check that the "Check Box" shows that the debt service is being fully recovered, the pre-tax return equals the target and total cashflows are zero (i.e. that the cells read either "TRUE" or N/A (Not Applicable) - which may be the case for the Pre Tax IRR Target check when an indifference switch is used).