Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE DO NOT USE EXCEL SOFTWARE TO COMPLETE THESE QUESTIONS. HANDWRITTEN OR WORDS IS PREFERABLE. THANK YOU! Following are Dell's condensed consolidated statement of financial

image text in transcribed

image text in transcribedimage text in transcribed

PLEASE DO NOT USE EXCEL SOFTWARE TO COMPLETE THESE QUESTIONS. HANDWRITTEN OR WORDS IS PREFERABLE. THANK YOU!

Following are Dell's condensed consolidated statement of financial position and condensed consolidated statement of operations, in millions (unaudited). Statement of Financial Position FY05 Prior Annual Results FY04 FY03 FY02 FYO1 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: $ 4.747 5,060 4,414 459 2.217 16,897 $ 4,317 835 3,635 327 1,519 10,633 $ 4,232 406 2.586 306 1,394 8.924 $ 3.641 273 2.269 278 1.416 7.877 $ 4.910 525 2.424 400 1.467 9.726 1,691 4.319 308 $23,215 1,517 6,770 391 $19,311 913 5.267 366 $15,470 826 4,373 459 $13,535 996 2,418 530 $13,670 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: $ 8,895 5.241 14.136 505 2.089 16,730 6,485 $ 7.316 3.580 10.896 505 1.630 13,031 6,280 $ 5,989 2.944 8.933 506 1,158 10,597 4,873 $ 5,075 2.444 7,519 520 802 8,841 4,694 $ 4.286 2.492 6.778 509 761 8,0448 5,622 $23,215 $19,311 $15,470 $13,535 $13,670 FYOS ** Prior Annual Results FY04 FY03 FY02 * FY01 - $49,205 $71,71 $35,4044 $31,168 $31,888 18.7 40,190 9,015 4.298 463 17.1 33.892 7,552 3.544 464 13.6 29.055 6,349 3.050 455 -2.36 25.661 5,507 2.784 452 482 3.718 1,789 Income Statement: Net revenue Sequential Growth Y/Y Growth Cost of revenue Gross margin SG&A RED 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 acct principle Net income Sequential Growth Y/Y Growth 26.29. 25.445 6,443 3.193 482 105 3.780 2,663 4.008 3.505 4.761 ,25+ 3,544 2,8 ++ 191 180 183 (58) 531 7.445 1.402 3.724 1,079 3,027 905 1,731 +85 3.194 958 $ 3,043 $ 2,645 $ 2,122 59 $ 2,177 $1,246 15.0. % 24.6 70.3% -2.8 30.7 Assume all net revenue are from credit sales. Using the above information, calculate the following ratios for FY05 to FY02: 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investment Grade Energy Audit Making Smart Energy Choices

Authors: Shirley J. Hansen, James W. Brown

1st Edition

0824709284, 978-0824709280

More Books

Students also viewed these Accounting questions