Dell's Working Capital Spreadsheet

Balance Sheet Year Ended January 28, 1996 Current Assets: Cash Short Term Investments Accounts Receivables, net Inventor

Views 135 Downloads 5 File size 56KB

Report DMCA / Copyright

DOWNLOAD FILE

Recommend stories

Citation preview

Balance Sheet Year Ended January 28, 1996 Current Assets: Cash Short Term Investments Accounts Receivables, net Inventories Other Total Current Assets Property, Plant & Equipment, net Other Total Assets Current Liabilities: Accounts Payable Accrued and Other Liabilities Total Current Liabilities Long Term Debt Other Liabilities Total Liabilities Stockholders’ Equity: Preferred Stock Common Stock Retained Earnings Other Total Stockholders’ Equity

% of Sales

January 29, 1995 % of Sales

55 591 726 429 156 1,957 179 12 2,148

1% 11% 14% 8% 3% 37% 3% 0% 41%

43 484 538 293 112 1,470 117 7 1,594

1% 14% 15% 8% 3% 42% 3% 0% 46%

466 473 939 113 123 1,175

9% 9% 18% 2% 2% 22%

403 349 752 113 77 942

12% 10% 22% 3% 2% 27%

6 430 570 (33) 973 2,148

0% 8% 11% -1% 18% 41%

120 242 311 (21) 652 1,594

3% 7% 9% -1% 19% 46%

Profit & Loss Statement Fiscal Year Sales Cost of Sales Gross Margin Operating Expenses Operating Income Financing & Other Income Income Taxes Net Profit

Net profit expected (% of sales)

1996 $5,296 4,229 1,067 690 377 6 111 272

% of Sales 100% 80% 20% 13% 7% 0% 2% 5%

1995 % of Sales $3,475 100% 2,737 79% 738 21% 489 14% 249 7% (36) -1% 64 2% 149 4%

1995 actual 1996 projected 1996 actual 227 272

Operating Assets Cash Accounts Receivables, net Inventories Other Extra Operating assets

986 43 538 293 112

1,503 66 820 447 171 517

1,366 55 726 429 156 380

Current liabilities Accounts Payable Accrued and Other Liabilities Extra Current Liabilities

752 403 349

1,146 614 532 394

939 466 473 187

123

193

Difference

Balance Sheet Year Ended January 28, 1996 Current Assets: Cash Short Term Investments Accounts Receivables, net Inventories Other Total Current Assets Property, Plant & Equipment, net Other Total Assets Current Liabilities: Accounts Payable Accrued and Other Liabilities Total Current Liabilities Long Term Debt Other Liabilities Total Liabilities Stockholders’ Equity: Preferred Stock Common Stock Retained Earnings Other Total Stockholders’ Equity

% of Sales

January 26, 1997 % of Sales

55 591 726 429 156 1,957 179 12 2,148

1% 11% 14% 8% 3% 37% 3% 0% 41%

83 887 1,089 644 234 2,936 269 18 3,222

1% 11% 14% 8% 3% 37% 3% 0% 41%

466 473 939 113 123 1,175

9% 9% 18% 2% 2% 22%

699 710 1,409 170 185 1,763

9% 9% 18% 2% 2% 22%

6 430 570 (33) 973 2,148

0% 8% 11% -1% 18% 41%

9 645 855 (50) 1,460 3,222

0% 8% 11% -1% 18% 41%

Profit & Loss Statement Fiscal Year Sales Cost of Sales Gross Margin Operating Expenses Operating Income Financing & Other Income Income Taxes Net Profit

Net profit expected (% of sales) Operating Assets Cash Accounts Receivables, net Inventories Other Extra Operating assets Current liabilities Accounts Payable Accrued and Other Liabilities Extra Current Liabilities Difference

1997 $7,944 6,344 1,601 1,035 566 9 167 408

% of Sales 100% 80% 20% 13% 7% 0% 2% 5%

1996 actual 1997 projected 272 408 1,366 55 726 429 156

2,049 83 1,089 644 234 683

939 466 473

1,409 699 710 470 214

1996 % of Sales $5,296 100% 4,229 80% 1,067 20% 690 13% 377 7% 6 0% 111 2% 272 5%

Balance Sheet(With repurchase and debt repayment) Year Ended January 28, January 26, 1996 % of Sales 1997 Current Assets: Cash 55 1% 55 Short Term Investments 591 11% 543 Accounts Receivables, net 726 14% 1,089 Inventories 429 8% 644 Other 156 3% 234 Total Current Assets 1,957 37% 2,565 Property, Plant & Equipment, net 179 3% 269 Other 12 0% 18 Total Assets 2,148 41% 2,851 Current Liabilities: Accounts Payable Accrued and Other Liabilities Total Current Liabilities Long Term Debt Other Liabilities Total Liabilities Stockholders’ Equity: Preferred Stock Common Stock Retained Earnings Other Total Stockholders’ Equity

466 473 939 113 123 1,175

9% 9% 18% 2% 2% 22%

699 710 1,409 0 185 1,593

6 430 570 (33) 973 2,148

0% 8% 11% -1% 18% 41%

6 425 860 (33) 1,258 2,851

Profit & Loss Statement Fiscal Year Sales Cost of Sales Gross Margin Operating Expenses Operating Income Financing & Other Income Income Taxes Net Profit

Net profit expected (% of sales) Operating Assets Cash Accounts Receivables, net Inventories Other Extra Operating assets Current liabilities Accounts Payable Accrued and Other Liabilities Extra Current Liabilities Difference

1997 $7,944 6,344 1,601 1,035 566 9 167 408

% of Sales 1996 % of Sales 100% $5,296 100% 80% 4,229 80% 20% 1,067 20% 13% 690 13% 7% 377 7% 0% 6 0% 2% 111 2% 5% 272 5%

1996 actual 1997 projected 272 290 1,366 55 726 429 156

2,022 55 1,089 644 234 656

939 466 473

1,409 699 710 470 186