only need 5-12

Suppose selected financial data of Target and Wal-Mart for 2020 are presented here 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 Balance Sheet Data (End of Year) $18,424 $48,331 26,109 122,375 $44,533 $170,706 $11,327 $55,561 17,859 44,089 15,347 71,056 $44,533 $170,706 Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Beginning-of-Year Balances $44,106 $163,429 13,712 65,682 Total stockholders' equity Current liabilities 10.512 55.390 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 $4,025 33,836 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends $7,525 6,942 5,881 1,729 26,249 12,184 4,217 496 For each company, compute the following ratios. (Enter free cash flow in millions. Round Current ratio to 2 decimal places, e.g. 1.67. Round Debt to assets ratio to O decimal places, e.g. 18 or 18%. Round all other answers to 1 decimal place, e.g. 1.6, or 1.6%. Use 365 days for calculation.) Ratio Target (1) Current ratio :1 (2) Accounts receivable turnover times Average collection period days 3 (4) Inventory turnover times (5) Days in inventory days (6) Profit margin % (7) Asset turnover times (8) Return on assets % (9) Return on common stockholders' equity % (10) Debt to assets ratio % (11) Times interest earned times (12) Free cas $ million