60.1K

Verified Solution

Link Copied!

Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2019 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Wal-Mart Target Stores, Corporation Inc. Income Statement Data for Year $65,600 $410,000 44,000 308,000 14,600 75,000 690 2,100 (90) (420) 1,400 7,300 $4,820 $17,180 Net income Current assets Noncurrent assets Balance Sheet Data (End of Year) $17,000 $48,000 26,700 120,000 $43,700 $168,000 Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity $11,000 17,000 15,700 $43,700 $56,000 45,000 67,000 $168,000 Total assets Total stockholders' equity Current liabilities Beginning-of-Year Balances $45,000 $165,000 13,600 66,000 10,000 58,000 31,400 99,000 Total liabilities Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,800 6,900 5,700 1,800 450 $4,000 34,500 26,900 12,400 3,600 (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 2) Accounts receivable turnover times times (3) Average collection period days days Inventory turnover times times (5) Days in inventory days days % % (6) (7) Profit margin 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

Answer & Explanation Solved by verified expert

See Answer