3. A simple cash-flow statement Shown in Figure 4.44 is an estimate of the cash inflows and outflows of the Hibernian Hotel for the next quarter. Using the format shown, calculate the size of overdraft facility that will be necessary to meet the cash-flow needs of the hotel over this period. The cash balance at the beginning of the period is 500. B D Figu Esti spre Que 1 January February March 2 3 Sales Accommodation sales 18.700 Food & beverage sales 10,900 23,970 8,340 24,450 8,760 4 5 6 14 800 3,848 16,155 4,200 15,000 16,605 4,317 7 8 Wages Variable costs Loan repayment Rent due Power & light Payment due 1,000 370 8 10 300 450 11 9,000 12 13 Month and balance 14 (a) In addition, calculate the totals for each category for the month. Use these to generate a simple trading account. Calculate the gross-profit and net-profit percentages Save the spreadsheet. (b)