Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Wal-Mart Target Income Statement Data for Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $66,900 45,000 15,000 $419,000 309,000 80,000 1,900 (80) 1,500 (390) 6,700 4,620 21,010 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders" equity Total liabilities and stockholders $17,000 26,700 $43,700 $11,000 18,200 14,500 $43,700 $45,000 120,000 $165,000 55,000 45,000 65,000 $165,000 Total assets Total stockholders' equity Current liabilities Total labilities Beginning-of-Year Balances $165,000 64,000 58,000 101,000 $43,000 12,600 30,400 2 4 6 8 9 Other Data Average net accounts receivable Average inventory Net cash provided by operating $7,700 6,800 S,500 1,800 490 $4,200 34,500 25,800 12,300 4,200 activities Capital expenditures Dividends (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, eg. 1.83 or 1.83%.) Ratio Target Wal-Mart (1) Current ratio (2) Accounts receivable turnover (3) Average collection period (4) Inventory turnover (5) Days in inventory (6) Profit margin (7) Asset turnover (8) Return on assets (9) Return on common stockholders' equity (10) Debt to assets ratio (11) Times interest earned (12) Free cash fow Click if you would like to Show Work for this question: times days days times days times Open Show Work 8 2