Reference no: EM131201523

Practice questions:

Using the information given in Question , imagine that Philip has negotiated a bank loan of £5,000 at 12% per annum which he receives in January. He has to pay the interest on at the end of each quarter. In addition, he wishes to draw £500 per month from the business for his personal use. Construct a cash flow forecast for Philip Trigg for the 6-month period January to June. Explain what action Philip might take to resolve any cash deficit that occurs during the period.

Question
Philip Trigg has negotiated with two manufacturers of electric circuit boards to carry out assembly work for them as a subcontractor. He anticipates assembling the following numbers of assembly boards for each manufacturer during 1998:

Month	Firm A	Firm B
January	120	200
February	130	200
March	130	240
April	150	240
May	140	240
June	140	220
July	160	220
August	160	270
September	170	270
October	140	270
November	140	230
December	120	210

Firm A has agreed to pay £6.60 for each board assembled and Firm B £6.50. Firm A will pay 2 months after the work has been done, but Firm B will pay 1 month after the work has been done. Philip anticipates the following expenses:

•Rent of workshop                         £ 16,000 per annum, payable at the beginning of each quarter

•Lighting and heating                    £ 120 per month. payable 1 month in arrears

•Telephone                                    £ 50 per quarter. payable at the end of each quarter

•Packaging                                    10% of sales, payable in the month following the month in which the sales occur

•Miscellaneous expenses               £ 25 each month

•Tools and equipment                    £ 12,500 in January. £ 1,000 in February and £ 500 in March

Draw up a cash flow forecast for Philip Trigg for the 6-month period January to June and calculate the amount of capital he needs to invest in the business to prevent a cash deficit in any month.