1 C35 Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Target Corporation Walmart Inc. Income Statement Data for Year $66,120 $409.890 46,230 309.260 14.200 78,000 650 2,200 (70) (390) 1.400 7.100 $ 3,570 $ 12.940 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Balance Sheet Data (End of Year) $19.000 $48,160 26,900 122,000 $45.900 $170,160 $10,000 $56,000 16,900 44.000 19.000 70.160 $45,900 $170,160 Beginning-of-Year Balances $43,000 $162.000 Total assets Question 5 of 6 Total liabilities and stockholders' equity $45,900 $170,160 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $162,000 14,300 65,000 10.500 55.000 28.700 97,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,600 6.900 5,500 1,700 460 $3.900 32.900 26.600 12,400 3.900 (a) For each company, compute the following ratios. (Round current ratio to 2 decimal places, eg 1.83 and all ott place, e.g. 1.8 or 2.5%. Use 365 days in calculation.) Ratio Target (1) Current ratio :1 (2) Accounts receivable turnover times (3) Average collection period days (4) Inventory turnover times Woo Question 5 of 6 -/12 (a) For each company, compute the following ratios. (Round current ratio to 2 decimal places, 1.83 and all other answers to 1 decimal place, es. 1.8 or 2.5%. Use 365 days in calculation.) Ratio Target Walmart (1) Current ratio 1 :1 (2) Accounts receivable turnover times time! (3) Average collection period days days Inventory turnover times time Days in inventory days days 4) 5) () ) Profit margin % % Asset turnover times times (8) Return on assets % 19) Return on common stockholders equity % % (10) % % Debt to assets ratio Times interest earned times time (12) Tree cash flow $ $