80.2K

Verified Solution

Link Copied!

Suppose selected financial data of Target and Wal-Mart for 2017 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 Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $66,700 $418,000 45,000 309,000 15,200 78,000 740 1,900 (95) (420) 1,400 6.700 $ 4,265 $21.980 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) $18.000 $45,000 25,600 120,000 $43,600 $165,000 $11,000 $56,000 17,200 44.000 15.400 65,000 $43,600 $165,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $45,000 $163,000 13,400 65,000 10,600 58,000 31,600 98,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,500 7,000 5,800 1,700 450 $3,900 32,800 26,900 11,800 4,400 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, es 1.83 or 1.83%) Ratio Target Wal-Mart (1) Current ratio 1 -1 (2) Accounts receivable turnover times times (3) days days (4) Average collection period Inventory turnover Days in inventory times times (5) days days (6) Profit margin X (7) Asset turnover times times (8) Return on assets 19) M Return on common stockholders equity Debt to assets ratio (10) 3- (11) Times interest earned times times (12) Free cash flow $

Answer & Explanation Solved by verified expert

See Answer