17.14A Working with the information from 17.13A, put the cash flow information into a spreadsheet. Use the spreadsheet to perform 'what if' calculations to answer Silas's questions as follows:

i) 'What would happen to my estimated cash at bank balance at the end of March if my debtors took two months, instead of one month, to pay me? Would the bank account go overdrawn at any point in the year?'

ii) 'I think I may have underestimated my sundry admin expenses. What would happen to the cash at bank balance at the end of March if my expenses each month were £400 rather than £200?'

iii) 'What would happen to the end of March cash at bank balance if both of these things happened - i.e. debtors take two months to pay me, not one, and admin expenses increase to £400 each month? Would I have an overdraft at any point, and if so, what would be the maximum budget overdraft figure?'