The summarised balance sheet of Newland Traders at 30 May 20X7 was as follows:

Selling and materials prices at 30 May 20X7 provide for a gross profit at the rate of 25 per cent of sales.

The creditors at 30 May 20X7 represent the purchases for May 20X7, and the debtors the sales for April of £150,000 and May of £165,000.

Estimates of sales and expenditure for the six months to 30 November 20X7 are as follows:

(i) Sales for the period at current prices will be £800,000. Sales for the months of September and October will each be twice those of the sales in each of the other months.

(ii) Stock at the end of each month will be the same as at 30 May 20X7 except that at 30 November 20X7 it will be increased to 20 per cent above that level.

(iii) Creditors will be paid one month after the goods are supplied and debtors will pay two months after the goods are supplied.

(iv) Wages and expenses will be £20,000 a month and will be paid in the month in which they are incurred.

(v) Depreciation will be at the rate of £5,000 a month.

(vi) There will be capital expenditure of £80,000 on 1 September 20X7. Depreciation, in addition to that given in (v) above, will be at the rate of 10 per cent per annum on cost.

(vii) There will be no changes in issued capital, general reserve or prices of sales or purchases.

Required:

(a) Sales and purchases budgets and budgeted trading and profit and loss accounts for the six months ended 30 November 20X7.

(b) A budgeted balance sheet as at 30 November 20X7.

(c) A cash flow budget for the six months ended 30 November 20X7 indicating whether or not it will be necessary to make arrangements for extra finance and, if so, your recommendation as to what form it should take.

Transcribed Image Text:

Fixed assets at cost Less depreciation Current assets Stocks Debtors Cash at bank and in hand Less Current liabilities Creditors Capital and reserves Issued capital General reserve Profit and loss account £000 210 315 48 573 128 £000 610 264 346 445 791 600 150 41 791