Dell Working Capital Case

1211 words 5 pages
Dell working capital case
Dell’s build to order system created a very different balance sheet. We want to assess their competitive advantage in working capital at the time of the case, evaluate how they funded growth at the time (1996) and evaluate potential ways to fund projected sales growth of 50% in 1997 through use of internal funds. 1. Calculate their working capital advantage. To do this calculate days sales of inventory, payable days and receivables days to find their cash conversion cycle.

Days sales of inventory=365*(429+293)/(2*4229)=31.16
Payable days=365*(466+403)/(2*4229)=37.50
Receivables days=365*(726+538)/(2*5296)=43.56
Cash conversion cycle=31.16+43.56-37.50=37.22
The cash conversion cycle measures how
…show more content…

Comparing to the actual balance sheet, the increase in operating assets=1557-1110=447, the increase in spontaneous liabilities = 473-349=187, the increase in the equity = 272.
The assets and spontaneous liabilities increased less than the projected numbers while the equity increased much more than the projected number.
As cash inflow (491+226.89=717.89) is more than required cash outflow of 579.37, it can be inferred that DELL got enough money to fund the growth in 1996 internally. The profit margin improved from 4.3% to 5.1% in 1996, while the total assets turnover improved from 5.45% to 7.27%.

In summary, Dell internally funded a 52% growth in sales largely by increasing its asset efficiency and profitability.

5. Assuming they want to grow 50% in 1997 how might they fund this growth internally? How much working capital do you need? What steps should they take? What happens to the profit margin?

In 1996, Operating assets= 30% of sales (1557/5296), profit margin=5.1%
So in 1997, Dell would require 30% of increased sales in operating assets. In 1997, Operating assets=(1557/5296)*1.5*5296=2336 so the increased operating assets=2336-1557=779
And the increase in operating


  • Dell's Working Capital
    4287 words | 18 pages
  • Financial Analysis of Dell and Hp Executive Summary
    5939 words | 24 pages
  • Ford Motor Company: Supply Chain Strategy
    3061 words | 13 pages
  • Research on Dell
    5604 words | 23 pages
  • Dell Computer Corporation – Strategy and Challenges for the 21st Century
    16122 words | 65 pages
  • Miss
    2955 words | 12 pages
  • Lenovo Financial Paper
    8016 words | 33 pages
  • Case Solutions for Corporate Finance Ross, Westerfield, and Jaffe 9th Edition
    25037 words | 101 pages
  • Fin 370 Syllabus
    1369 words | 6 pages
  • Gb520 Unit1 Apple Case Analysis
    1496 words | 6 pages