.

Saturday, February 23, 2019

Dell Computer Company

DELLs Working Capital 1. How was dingles running(a) corking policy a competitive advantage? dell has achieved outset working capital by keeping its work-in-process and finished goods inventory very(prenominal) low. The competitive advantage dell achieves from this is that its inventory is significantly lower than its competitors, it does non require large w arhouses for stocking the inventories and Dell is also able to adapt the instantaneous to technology changes in the components. The competitors would find it difficult to adapt to technology changes in a unretentive time because they have larger inventories than Dell does.In short, Dell builds computers only when ordered and thus does not spend a great deal capital as a result. The declining DSI means that Dell takes increasingly shorter old age to sell its inventory. 2. How did Dell strain its 52% harvesting in 1996? Dell needed the pastime amount to fund its 52% growth in 1996 (using exhibit 4&5) direct assets (OA) = total assets short edge enthronization OA in 1995 = 1594 484 = 1110 ml USD Operating Asset to Sales balance = 1110/3457 = 32% Sales growthd from 3457 to 5296 land mile USD in 1996. Multiplying the run asset to gross revenue ratio by the increase in gross sales 0. 2 x (5296 3457) = 582 cc USD, which is the run assets that Dell needed to fund its 52% growth. This increase in assets meant an increase in liabilities too, proportional to the sales. The increase in liabilities would be Liabilities in 1995 = 942 Mil USD Liabilities to Sales ratio = 942/3475 = 27. 1% Increase in liabilities = 0. 271 x (5296 3475) = 494 land mile USD So, Dell would have an increase in direct assets of 582 mil USD and an increase in liabilities of 494 mil USD. The short investments would remain the uniform as it is not related to operations.Operational emolument would increase with the Operating Profit to Sales ratio (net profit/sales) x (5296 3457) = (149/3457) x (5296 3457) = 227 mil USD In completely, we figure that a sales increase of 52% has to be funded by 582 mil USD in operation(p) assets. The sales increase would also land additional 494 mil USD in liabilities, while generating 227 mil USD of operating profit, with short edge investments remaining the same at 484 mil USD. As a result, any 2 combinations of liabilities, operational profit or short term investments would be sufficient to offset the 582 mil USD operating assets needed to nonplus the 52% sales growth.In 1995, as shown earlier, the operating asset to sales ratio was 32%. Similarly, the ratio in 1996 was (2148 591)/5296 = 29. 4%. The difference in the percentages is 2. 54%. This decrease in operating assets in category 1996 suggests that operating efficiency was improved by the same amount. Multiplying this difference in ratio by total sales in 1996 5296 x 0. 0254 = 134. 5 mil USD, this amount can be cut down from the originally forecasted 582 mil USD to entertain the actual addition al operating asset required to fund the 52% growth 582 134. 5 = 447. 5 mil USD. The net margin in 1995, as shown earlier was 4. % (149/3457). In 1996 it increased to 272/5296 = 5. 14%. This net profit is an increase from the forecasted 227 mil USD (calculation shown earlier), and can be attributed to improved net margins. Also, we enamor an increase in current liabilities of 187 mil USD between 1995 and 1996. We also see that the sum of the increase in current liability and the net profit, of 1996, is higher(prenominal) than the actual additional operating asset requirement 272 + 187 = 459 mil USD 447. 5 mil USD. Therefore, Dell funded its 1996 sales growth through internal resources, i. e. bring down its current assets and increasing its net margin. . Assuming Dell sales bequeath grow 50% in 1997, how might the company fund this growth internally? How much would working capital need to be nullifyd and/or profit margin increased? What steps do you recommend the company take? For the year 1996, Operating Assets = entire Assets Short term Investments = 2148 591 = 1557 Mil USD When the sales increases by 50% in 1997, operating assets are also expected to increase by 50%. So for 1997, Dell requires an operating asset of 1557 x 1. 5 = 2336 Mil USD. We should also develop that the net profit as a percentage of sales get out increase proportionally by 50% for 1997.For 1996, Net profit as a percentage of sales = 272/5296 = 5. 14% For 1997, Net profit = 5296 x 0. 0514 * 1. 5 = 408 Mil USD For 1997, additional operating asset required = 2336 1557 = 779 Mil USD How could this be funded by Dell? let us assume two scenarios Scenario 1 Let us assume the liabilities remain the same for the year 1997 even when sales increases by 50%, i. e. DELL would not go for any additional liability to fund the increase in operating asset and it would try to do it internally. As per the calculation shown in the connect exhibit, Dell would need 371 Mil USD to fund the increase in sales.The following are the ways DELL could fund this increase in operating asset 1. They could liquidate the short term investments of 591 Mil USD which would cover all of the additional funds required. 2. Dell could sell around of its fixed assets 3. They could reduce inventories, account receivables, and increase the account account payables. They could bring down the working capital substantially by having a very low cash cycle. They could do with their suppliers for a higher DPO. With the Just In Time (JIT) concept, they could receive payments at present from their customers. Let us assume in 1997 Q4 1996 Q4 1997 Difference DSI 31 20 -11 DSO 42 25 -17 DPO 33 50 17 CCC 40 -5 -35 So, there is a high possibility to attain a blackball cash cycle which in turn saves on the working capital. add up daily sales in 1997 = 7944/365 = 21. 8 Mil USD Cost of sales in 1997 = (4229/5296) x 7944 = 6343. 5 Mil USD Average daily represent of sales in 1997 = 6343. 5/365 = 17. 4 Mi l USD For the year 1997, savings due to improved cash cycle isSavings due to rock-bottom inventory days = 11 x 17. 4 = 191. 4 Mil USD Savings due to reduced receivable days = 17 x 21. 8 = 370. 6 Mil USD Savings due to increased payable days = 17 x 17. 4 = 295. 8 Mil USD Total saving from cash cycle improvements = 857. 8 Mil USD Scenario 2 Let us assume liabilities for 1997 increase proportionally (50%) with the increase in sales, i. e. Dell would look for external funding for the increase in operating asset. As per the calculation shown in the attached exhibit, Dell would have enough notes to fund the increase in sales with the corresponding increase in liabilities.In fact they will have an excess of 161 Mil USD assume the long term debt remains unchanged. Dell could use this excess funds to repay the long term debt or it could buy back some common stocks. 4. How would your answers to Question 3 change if Dell also repurchased $ cholecalciferol mil USD of common stock in 1997 an d repaid its long-term debt? Let us assume Dell repurchased 500 Mil USD of common stock in 1997 and it also repaid its long term debt. In such a scenario, as per the calculation shown in the attached exhibit, Dell would need 452 Mil USD to fund the increase in sales. The points discussed in scenario 1 of Q3 holds good here as well.

No comments:

Post a Comment