Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $66,900 $419,000 Cost of goods sold 45,000 309,000 Selling and administrative expenses 15,000 80,000 Interest expense 700 1,900 Other income (expense) (80) (390) Income tax expense 1,500 6,700 Net income $4,620 $21,010 Balance Sheet Data (End of Year) Current assets $17,000 $45,000 Noncurrent assets 26,700 120,000 Total assets $43,700 $165,000 Current liabilities $11,000 $55,000 Long-term debt 18,200 45,000 Total stockholders equity 14,500 65,000 Total liabilities and stockholders equity $43,700 $165,000 Beginning-of-Year Balances Total assets $43,000 $165,000 Total stockholders equity 12,600 64,000 Current liabilities 10,000 58,000 Total liabilities 30,400 101,000 Other Data Average net accounts receivable $7,700 $4,200 Average inventory 6,800 34,500 Net cash provided by operating activities 5,500 25,800 Capital expenditures 1,800 12,300 Dividends 490 4,200 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.85 or 1.85%.) Ratio Target Wal-Mart (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 % % (7) Asset turnover times times (8) Return on assets % % (9) Return on common stockholders equity % % (10) Debt to assets ratio % % (11) Times interest earned times times (12) Free cash flow $ $

Problem 13-05A a 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 Net income Wal-Mart Target Stores, Corporation Inc. Income Statement Data for Year $66,900 $419,000 45,000 309,000 15,000 80,000 700 1,900 (80) (390) 1,500 6,700 $4,620 $21,010 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) $17,000 $45,000 26,700 120,000 $43,700 $165,000 $11,000 $55,000 18,200 45,000 14,500 65,000 $43,700 $ 165,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $165,000 12,600 64,000 10,000 58,000 30,400 101,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,700 $4,200 6,800 34,500 5,500 25,800 1,800 12,300 490 4,200 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.85 or 1.85%.) Ratio Target Wal-Mart (1) Current ratio (2) Accounts receivable turnover times times (3) Average collection period days days 4) Inventory turnover times times (5) Days in inventory days days Profit margin 20 (7) Asset turnover times times (8) Return on assets (9) Return on common stockholders' equity (10) Debt to assets ratio (11) Times interest earned times times (12) Free cash flow Click if you would like to Show Work for this question: Open Show Work