Selected hypothetical financial data of larget and Wal-Mart for 2022 are presented here (ir Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,500 $406,000 46,000 305,000 15,100 77,000 720 2,000 (70) (410) 1,500 7,500 $2,110 $ 14,090 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) $16,000 $46,000 26,400 121,000 $42,400 $167,000 $12,000 $54,000 18,400 45,000 12,000 68,000 $42,400 $167,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $ 163,000 14,100 66,000 10,800 57,000 28,900 97,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,600 $4,100 6,800 34,000 5,900 26,300 1,700 11,500 520 3,700 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to 0 decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%.) Ratio Target Wal-Mart (1) Current ratio 1.33 :1 .85 :1 (2) Accounts receivable turnover 8.6 times 99 times (3) Average collection period 42.44 days 3.70 days Inventory turnover 6.76 times 9.0 times (4) ( Days in inventory 54 days 41 days (6) Profit margin 3.2 % 3.5 % (7) Asset turnover 1.5 times 2.5 times (8) Return on assets 4.9 % 8.5 % (9) Return on common stockholders' equity 16.2 % 21.0 % (10) Debt to assets ratio 72 % 58 % (11) Times interest earned 6.1 times 12 times (12) Free cash flow $ 3680 $ 11,100 Selected hypothetical financial data of larget and Wal-Mart for 2022 are presented here (ir Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,500 $406,000 46,000 305,000 15,100 77,000 720 2,000 (70) (410) 1,500 7,500 $2,110 $ 14,090 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) $16,000 $46,000 26,400 121,000 $42,400 $167,000 $12,000 $54,000 18,400 45,000 12,000 68,000 $42,400 $167,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $ 163,000 14,100 66,000 10,800 57,000 28,900 97,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,600 $4,100 6,800 34,000 5,900 26,300 1,700 11,500 520 3,700 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to 0 decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%.) Ratio Target Wal-Mart (1) Current ratio 1.33 :1 .85 :1 (2) Accounts receivable turnover 8.6 times 99 times (3) Average collection period 42.44 days 3.70 days Inventory turnover 6.76 times 9.0 times (4) ( Days in inventory 54 days 41 days (6) Profit margin 3.2 % 3.5 % (7) Asset turnover 1.5 times 2.5 times (8) Return on assets 4.9 % 8.5 % (9) Return on common stockholders' equity 16.2 % 21.0 % (10) Debt to assets ratio 72 % 58 % (11) Times interest earned 6.1 times 12 times (12) Free cash flow $ 3680 $ 11,100