50.1K

Verified Solution

Link Copied!

Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7,139 $ 2.488 $ 14,335 Net income Current assets Noncurrent assets Total assets Current liabilities Balance Sheet Data (End of Year) $18.424 $48.331 26.109 122.375 $44,533 $170,706 $11.327 $55,561 Question 11 of 11 Long-term debt Total stockholders' equity Total liabilities and stockholders' equity 17,859 15,347 $44,533 44,089 71,056 $170,706 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $44,106 $163,429 13,712 65,682 10,512 55,390 30.394 97.747 Other Data Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends $7.525 6.942 5.881 1.729 496 $4,025 33.836 26.249 12.184 4.217 al Formach company.compute the following ratios (Enter free cash flow in millions. Round Current ratio to 2 decimal places, es 1.67. Rou For each company.compute the following ratios. (Enter free cash flow in millons. Round Current ratio to 2 decimal places, eg 1.67. Round Debt to assets ratio to decimal places, eg 18 or 18%. Round all other answers to 1 decimal place, eg. 16, or 1.6% Use 365 days for calculation) Ratio Target Wal-Mart (1) Current ratio 420 :1 2.95 :1 (2) Accounts receivable turnover 8.7 times 101.4 times (3) Average collection period 420 days 3.6 days (4) Inventory turnover 66 times 90 times (5) Days in inventory 55.3 days -06 days Profit margin 35 (71 Asset turnover 1.5 times (8) Return on assets 5.6 S Return on common 1921 (4) Inventory turnover 6.6 times 9.0 times (5) Days in Inventory 55.3 days 40.6 days (6) Profit margin 3.8 % 3.5 96 (7) Asset turnover 15 times 24.4 times (8) Return on assets 5.6 % 85.8 % 19) Return on common stockholders' equity 2 % 2 % (10) Debt to assets ratio % % (11) Times Interest earned times times (12) Free cash flow $ million $ million

Answer & Explanation Solved by verified expert

See Answer