Help I System Announcements Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart CTAR Inc. Income Statement Data for Year $66,900 45,000 15,000 700 $419,000 309,000 80,000 1,900 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income (80) (390) 1,500 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 $17,000 26,700 $43,700 $11,000 18,200 14,500 $45,000 120,000 $165,000 $55,000 45,000 65,000 24 F7 F5 F3 Kimmel, Accounting, 6e Help I System Announcements Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity 26,700 $43,700 $11,000 18,200 14,500 $43,700 120,000 $165,000 $55,000 45,000 65,000 $165,000 Beginning-of-Year Balances Total assets Total stockholders' equity Current liabilities Total liabilities $43,000 12,600 10,000 30,400 $165,000 64,000 58,000 101,000 Other Data Average net accounts receivable Average inventory Net cash provided by operating $7,700 6,800 5,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 de 24 Kimmel, Accounting, 6e (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. Ratio Target Wal-Mart (1) Current ratio (2) Accounts receivable turnover times times days times days (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 flow Click if you would like to Show Work for this question: Open Show Work days times days times times times times 24 F4 F5 F7