Part 1: Calculation
Year 1:
- Current Assets = Inventory + Trade Receivables + Cash
= 100,000+60,000 + 15,000=∗∗175,000**
- Current Liabilities = Trade Payables + Bank Overdraft
= 80,000+0 = **80,000∗∗
- Working Capital = Current Assets - Current Liabilities
= 175,000−80,000 = **95,000∗∗
Year 2:
- Current Assets = 150,000+90,000 + 5,000=∗∗245,000**
- Current Liabilities = 120,000+20,000 = **140,000∗∗
- Working Capital = 245,000−140,000 = **105,000∗∗
Part 2: Analysis and Suggestion
Analysis:
Working capital increased from 95,000to105,000. However, the company's liquidity position has worsened. Both inventory and trade receivables have increased by 50%, tying up significant cash. Cash has fallen from $15,000 to just $5,000, and the company has had to take on a $20,000 overdraft. This pattern suggests the business might be overtrading – expanding sales rapidly without sufficient working capital to finance the growth, leading to a severe cash shortage.
Suggestion:
One way to improve the working capital position is to manage trade receivables more effectively. The company could offer customers a discount for early payment, for example, a 2% discount if invoices are paid within 10 days instead of the usual 30. This would accelerate cash inflows. For instance, if half the receivables ($45,000) were collected 20 days earlier, it would significantly improve the cash balance, reducing the need for an overdraft, even though it would slightly reduce the gross profit margin.