cash and funding strategies

In the near future a company will purchase a manufacturing business for $315,000, this price to include goodwill ($150,000), equipment and fittings ($120,000), and inventory of raw materials and finished goods ($45,000).

A delivery van will be purchased for $15,000 as soon as the business purchase is completed. The delivery van will be paid for in the second month of operations.

The following forecasts have been made for the business following purchase:

a) Sales (before discounts) of the business’s single product, at a mark-up of 60% on production cost will be:

Month 1 2 3 4 5 6
($000) 96 96 92 96 100 104

25% of sales will be for cash; the remainder will be on credit, for settlement in the month following that of sale. A discount of 10% will be given to selected credit customers, who represent 25% of gross sales.

b) Production cost will be $5 per unit. The production cost will be made up of:

Raw materials $2.50
Direct labour $1.50
Fixed overhead $1.00

c) Production will be arranged so that closing inventory at the end of any month is sufficient to meet sales requirements in the following month. A value of $30,000 is placed on the inventory of finished goods, which was acquired on purchase of the business. This valuation is based on the forecast of production cost per unit given in
(b) above.

d) The single raw material will be purchased so that inventory at the end of a month is sufficient to meet half of the following month’s production requirements. Raw material inventory acquired on purchase of the business ($15,000) is valued at the cost per unit that is forecast as given in (b) above. Raw materials will be purchased on one month’s credit.

e) Costs of direct labour will be met as they are incurred in production.

f) The fixed production overhead rate of $1.00 per unit is based upon a forecast of the first year’s production of 150,000 units. This rate includes depreciation of equipment and fittings on a straight-line basis over the next five years. Fixed production overhead is paid in the month incurred.

g) Selling and administration overheads are all fixed, and will be $208,000 in the first year. These overheads include depreciation of the delivery van at 30% pa on a reducing balance basis. All fixed overheads will be incurred on a regular basis, and paid in the month incurred, with the exception of rent and rates. $25,000 is payable for the year ahead in month one for rent and rates.

Prepare a monthly cash flow forcast. You should include the business purchase and the first four months of operations following purchase.

In this math i’m following the proforma of cash flow forecast.But i’m having a problem to find out the cash outflow section(Purchase working).

so,sir plz give me a hint to figure out this purchase working……..