60.1K

Verified Solution

Link Copied!

Please answer Parts 5-12.Thank you.

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 Net income 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 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) $17,000 $48,000 26,700 120,000 $43,700 $168,000 $11,000 $56,000 17,000 45,000 15,700 67,000 $43,700 $168,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $45,000 $165,000 13,600 66,000 10,000 58,000 31,400 99,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,800 $4,000 6,900 34,500 5,700 26,900 1,800 12,400 450 3,600 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.85 or 1.85%.) Target Wal-Mart Ratio Current ratio (1) T (2) Accounts receivable turnover (3) Average collection period 1.55:1 8.41 times (43.47 days times days .86:1 102.5 times 3.56 days 8.93 365 (4) Inventory turnover (5) Days in inventory 365 (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

Answer & Explanation Solved by verified expert

See Answer