View Policies Current Attempt in Progress Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions), Inc. Target Walmart Corporation Income Statement Data for Year $65,357 $408,214 Net sales 45,583 304,657 Cost of goods sold Selling and administrative expenses 15.101 79,607 707 2,065 (94) (411) Interest expense Other income (expense) Income tax expense Net income 1,384 7,139 $ 2,488 $ 14,335 Balance Sheet Data (End of Year) Current assets $18.424 $48,331 Noncurrent assets 26,109 122,375 Balance Sheet Data (End of Year) Current assets $18.424 $48,331 Noncurrent assets 26,109 122,375 Total assets $44,533 $170,706 Current liabilities $11,327 $55,561 17,859 44,089 Long-term debt 15,347 71,056 Total stockholders'equity Total liabilities and stockholders' equity $44,533 $170,706 Beginning-of-Year Balances $44,106 $163,429 Total assets Total stockholders' equity 13.712 65,682 10,512 55,390 Current liabilities 30,394 97,747 Total liabilities Other Data $7,525 $4,025 Average net arcounts receivable Total stockholders equity 10,512 55,390 Current liabilities 30,394 97747 Total liabilities Other Data $7.525 Average net accounts receivable $4,025 6,942 33,836 Average inventory 5,881 26,249 Net cash provided by operating activities 1,729 12,184 Capital expenditures 496 4,217 Cash dividends paid (a) For each company, compute the following ratios. Assume that all sales were on credit and that there is no preferred stock. (Enter fre cash flow in millions. Round Current ratio to 2 decimal places, eg. 1.67. Round Debt to assets ratio to 0 decimal places, e.g. 18 or 18%. Rour other answers to 1 decimal place, e.g. 1.6, or 1.6% Use 365 days for calculation) Ratio Target Walmart 1 (1) Current ratio (1) Current ratio 1 :1 (2) Accounts receivable turnover times times (3) Average collection period days days (4) Inventory turnover times times ( ) (5) Days in inventory days days (6) Profit margin % 96 (7) Asset turnover times times (8) Return on assets % %% 19 ) Return on common stockholders equity % % (10) Debt to assets ratio % % (11) Times interest earned times times (12) $ million Free cash flow million