You are presented with the following forecast information relating to Baker Limited for the nine months to 30 September 2017.
Forecast statements of profit or loss (abridged) for the three quarters ending 30 September 2017:

Additional information:
1 Sales of tangible non-current assets in March 2017 were expected to realise £12,000 in cash.
2 Administration, selling and distribution expenses were expected to be settled in cash during the month in which they were incurred.
3 Baker Limited includes as liquid resources term deposits of less than one year.
4 The directors have proposed that a dividend of £15,000 be paid on 28 February 2017.

Required:
(a) Calculate Baker Limited’s forecast net cash position at 31 March, 30 June and 30 September 2017 respectively.
(b) Prepare a forecast statement of cash flows for the nine months ending 30 September 2017.

Transcribed Image Text:

Revenue Cost of goods sold Gross profit Depreciation Administration, selling and distribution expenses Forecast net profit Forecast balances at Debit balances Tangible non-current assets at cost 90-day deposit at cost Inventory at cost Trade accounts receivable Cash at bank and in hand Credit balances Loan notes (10%) Trade accounts payable Taxation 31 Dec 2016 £000 360 15 40 50 80 80 ∞ 8 March 2017 £000 250 (200) 50 (3) (37) £10 31 March 2017 £000 240 5 30 65 - 120 June Sept 2017 £000 2017 £000 300 (240) 60 (20) (40) 30 June 2017 £000 480 5 40 75 - 140 350 (280) 70 (4) (42) £24 30 Sept 2017 £000 480 10 55 80 50 150