Derek Gorton is self-employed and manufactures car mats. After trading for six months he was very satisfied with the progress of his business. He produced sets of car mats at a cost of 6.00 a set, and sold them to car accessory shops for 8.00 a se

Authors Avatar

SARBJIT SINGH SANGHA   MODULE: MANAGING FINANCIAL RESOURCES

ASSIGNMENT 2: “CASH IN HAND”

Scenario

Derek Gorton is self-employed and manufactures car mats. After trading for six months he was very satisfied with the progress of his business. He produced sets of car mats at a cost of £6.00 a set, and sold them to car accessory shops for £8.00 a set.

Derek kept enough finished goods in stock to last for 30 days of trading, paid all his bills immediately, and allowed his customers 30 days credit. On January 1st his working capital situation was:

        Cash                £8,000

        Stock                £6,000

        Debtors        £8,000

In January he produced and sold 1,000 sets of car mats (on credit) for £8,000, they cost him £6,000 to make (paid out immediately). His profit for the month was therefore £2,000. He also collected £8,000 from his December sales.

Customer feedback was favourable, and Derek could reliably forecast that sales would increase over the next few months.

Predicted Sales are forecast to be:

  • February        1,500 sets
  • March                2,000 sets
  • April                2,500 sets
  • May                3,000 sets

(sold on 30 days credit).

In order to maintain supplies and stock levels at 30 days predicted trading, output is forecast to rise as follows:

  • February        2,000 sets
  • March                2,500 sets
  • April                3,000 sets
  • May                3,500 sets

(materials paid for immediately).

This trend is expected to continue for at least a year. Derek is encouraged that his January sales have not only made a good profit, but have increased the cash in the business. He sees this as a trend which will continue as sales increase, and would like to lease a new computer system for £2,000 a month, and now believes that there is enough cash being generated for him to commit the business to the deal for two years.

Cash Generated by the Business in February as Compared to January

At the end of trading in January the business had a closing bank balance of £7,000 and £3,000 in February. The business had failed to generate more cash in February than January by a difference of £4,000, even though sales receipts were the same in January and February of £8,000. The reason for the difference was because output levels had increased in February as compared to January and payment for Februarys output would not be received until March, due to the 30 days credit allowed to customers, and payment for materials were made immediately in February.

It is imperative to identify the point when cash is actually received or paid out. Hence, as customers are allowed up to 30 days credit before they need to pay for supplies, then the sales for month January will not be received until February and the sales for February will not be received until March and the cycle continues. Although it is important to be realistic, it is also wise to be prudent and not recognise receipts too early or payments too late.

At the end of the period, both months had a favourable cash surplus, indicating money in the bank. Cash inflows in January were slightly higher than in February although cash outflows in February were higher than in January.

Cash Flow Projection for the fourth coming Months

Derek Gorton’s cash flow shows the movement of money through the business. The cash  flow  forecast  sets  out  the  anticipated cash inflows and cash outflows over the  

coming months. Each column shows money coming into and out of the business in that month.

The forecast then shows the effect of each month’s cash flow upon the business’s cash balance/total. One essential rule to the cash flow forecast construction is that money is shown when it is received or paid. Therefore it is important to emphasise that the profit of the business may be significantly different from the cash flow.

The cash flow forecast shows if there is sufficient cash available each month. Although the company may be profitable in the long-term, in the immediate short-term the company suffers cash flow difficulties as output continues to increase. In the short-term, cash flow plays a vital role and the business does survive without making a profit for some time. It should be noted that for future long-term survival and especially growth, profit is essential.

The negative cash flow in the months, April, May, June and July indicates that the company has insufficient funds. The business requires an overdraft facility as there are insufficient funds to cope with the period of negative cash flow. Preventive action must be implemented immediately, such as:

Join now!

  • Obtain an overdraft facility;
  • Consider an application for a loan;
  • Negotiate shorter credit terms for customers;
  • Negotiate longer credit terms from supplies;
  • Cutting or delaying expenditure.

The surplus cash start off in January continues into February and breaks even in March. The business manages to pay off the overdraft in August and breaks even. In September there is surplus cash and this trend continues till the end of the year when the business has a closing surplus cash balance of £18,000.

The business also has capital tied up in debts due to the 30 ...

This is a preview of the whole essay