Problem 13-5A

Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).

(a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.)

Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $66,500 44,000 15,100 Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) 730 $407,000 310,000 79,000 1,900 (380) 6,700 $ 9,020 Income tax expense (80) 1,300 $ 5,290 Net income Balance Sheet Data (End of Year) Current assets Noncurrent assets $19,000 25,500 $44,500 Total assets $50,000 123,000 $173,000 $56,000 44,000 73,000 Current liabilities $10,000 17,200 17,300 Long-term debt Total stockholders' equity Total liabilities and stockholders' equity $44,500 $173,000 Beginning-of-Year Balances Total assets Total stockholders' equity $44,000 14,500 10,600 29,500 $165,000 64,000 58,000 101,000 Current liabilities Total liabilities Other Data Average net accounts receivable Average inventory Net cash provided by operating activities $8,000 6,900 $4,200 34,300 5,800 26,300 1,600 11,700 Capital expenditures Dividends 490 4,400 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 A $