Following are Dell's condensed consolidated statement of financial position and condensed consolidated statement of operations, in...

Transcribed Image Text:

Following are Dell's condensed consolidated statement of financial position and condensed consolidated statement of operations, in millions (unaudited). Assets: Cash & cash equivalents Short-term investments Accounts receivable, net Inventories Other Total current assets Property, plant, & equipment, net Investments Other noncurrent assets Total assets: Liabilities & Stockholders Equity: Accounts payable Accrued and other. Total current liabilities Long-term debt Other noncurrent liabilities. Total liabilities: Stockholders' equity: Total liabilities & stockholders' equity: FY05 Statement of Financial Position $ 4,747 5,060 4,414 459 2,217 16,897 1,691 4,319 308 $23,215 $8,895 5,241 14,136 505 2,089 16,730 6,485 $23,215 FY04 Prior Annual Results FY03 $4.317 835 3,635 327 1,519 10,633 1,517 6,770 391 $19,311 $7,316 3,580 10,896 505 1,630 13,031 6,280 $19,311 $ 4,232 406 2,586 306 1.394 8,924 913 5,267 366 $15,470 $5,989 2,944 8.933 506 1,158 10,597 4,873 $15,470 FY02 $ 3,641 273 2,269 278 1,416 7,877 826 4.373 459 $13,535 $5,075 2.444 7,519 520 802 8,841 4,694 $13,535 FY01 $4.910 525 2,424 400 1,467 9,726 996 2,418 530 $13,670 $ 4,286 2.492 6,778 509 761 8,048 5,622 $13,670 Income Statement: Net revenue Sequential Growth Y/Y Growth Cost of revenue Gross margin SG&A R&D Special charges Total operating expenses Operating income Investment and other income. net Income before income taxes & chg in acet principle Income tax provision Cumulative effect of change in acet principle Net income Sequential Growth Y/Y Growth FY05 ** $49,205 18.7% 40,190 9,015 4.298 463 4.761 4,254 191 4.445 1,402 $3,043 15.0% FY04 Prior Annual Results FY03 $41,444 17.1% 33,892 7,552 3.544 464 4.008 3,544 180 3,724 1,079 $2,645 24.6% $35,404 13.6% 29.055 6,349 3,050 455 3.505 2,844 183 3,027 905 $2,122 70.3% FY02 $31,168 -2.3% 25.661 5,507 2.784 452 482 3.718 1,789 (58) 1,731 485 $1,246 -42.8% Assume all net revenue are from credit sales. Using the above information, calculate the following ratios for FY05 to FY02: FY01 - $31,888 26.2% 25.445 6,443 3.193 482 105 3.780 2,663 531 3,194 958 59 $2,177 30.7% 5. Days' sales in inventory 6. Days' purchases in accounts payable 7. Net days' working capital 8. Long-term debt to assets ratio 9. Total debt-to-equity ratio 10. Total liabilities to total assets Note: Use average inventory, average accounts receivable, and average accounts payable in the calculation of days' sales in inventory, days' sales in accounts receivable, and days' purchases in accounts payable respectively. Following are Dell's condensed consolidated statement of financial position and condensed consolidated statement of operations, in millions (unaudited). Assets: Cash & cash equivalents Short-term investments Accounts receivable, net Inventories Other Total current assets Property, plant, & equipment, net Investments Other noncurrent assets Total assets: Liabilities & Stockholders Equity: Accounts payable Accrued and other. Total current liabilities Long-term debt Other noncurrent liabilities. Total liabilities: Stockholders' equity: Total liabilities & stockholders' equity: FY05 Statement of Financial Position $ 4,747 5,060 4,414 459 2,217 16,897 1,691 4,319 308 $23,215 $8,895 5,241 14,136 505 2,089 16,730 6,485 $23,215 FY04 Prior Annual Results FY03 $4.317 835 3,635 327 1,519 10,633 1,517 6,770 391 $19,311 $7,316 3,580 10,896 505 1,630 13,031 6,280 $19,311 $ 4,232 406 2,586 306 1.394 8,924 913 5,267 366 $15,470 $5,989 2,944 8.933 506 1,158 10,597 4,873 $15,470 FY02 $ 3,641 273 2,269 278 1,416 7,877 826 4.373 459 $13,535 $5,075 2.444 7,519 520 802 8,841 4,694 $13,535 FY01 $4.910 525 2,424 400 1,467 9,726 996 2,418 530 $13,670 $ 4,286 2.492 6,778 509 761 8,048 5,622 $13,670 Income Statement: Net revenue Sequential Growth Y/Y Growth Cost of revenue Gross margin SG&A R&D Special charges Total operating expenses Operating income Investment and other income. net Income before income taxes & chg in acet principle Income tax provision Cumulative effect of change in acet principle Net income Sequential Growth Y/Y Growth FY05 ** $49,205 18.7% 40,190 9,015 4.298 463 4.761 4,254 191 4.445 1,402 $3,043 15.0% FY04 Prior Annual Results FY03 $41,444 17.1% 33,892 7,552 3.544 464 4.008 3,544 180 3,724 1,079 $2,645 24.6% $35,404 13.6% 29.055 6,349 3,050 455 3.505 2,844 183 3,027 905 $2,122 70.3% FY02 $31,168 -2.3% 25.661 5,507 2.784 452 482 3.718 1,789 (58) 1,731 485 $1,246 -42.8% Assume all net revenue are from credit sales. Using the above information, calculate the following ratios for FY05 to FY02: FY01 - $31,888 26.2% 25.445 6,443 3.193 482 105 3.780 2,663 531 3,194 958 59 $2,177 30.7% 5. Days' sales in inventory 6. Days' purchases in accounts payable 7. Net days' working capital 8. Long-term debt to assets ratio 9. Total debt-to-equity ratio 10. Total liabilities to total assets Note: Use average inventory, average accounts receivable, and average accounts payable in the calculation of days' sales in inventory, days' sales in accounts receivable, and days' purchases in accounts payable respectively.

Answer rating: 100% (QA)

The detailed answer for the above question is provided below D... View the full answer