Question: Your answer is partially correct. Try again. Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart

 Your answer is partially correct. Try again. Suppose selected financial data

of Target and Wal-Mart for 2017 are presented here (in millions). Target

Your answer is partially correct. Try again. Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense $66,800 45,000 14,400 690 (75) 1,300 $ 5,335 $406,000 305,000 78,000 2,000 (420) 6,900 $ 13,680 Net income Current assets Noncurrent assets Balance Sheet Data (End of Year) $19,000 $48,000 27,300 121,000 $46,300 $169,000 $12,000 $55,000 17,500 44,000 16,800 70,000 Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders equity $46,300 $169,000 Beginning-of-Year Balances Total assets Total ockholders' equity Current liabilities Total liabilities $45,000 13,800 10,800 31,200 $164,000 66,000 57,000 98,000 Other Data $8,000 7,100 $4,100 34,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends 6,000 25,800 1,800 450 11,500 3,700 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1. Ratio Target Wal-Mart (1) Current ratio 1.58 1 0.87 11 re to search HA Other Data $8,000 7,100 $4,100 34,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends 6,000 25,800 1,800 450 11,500 3,700 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.8.3 or 1.83%) Ratio Target Wal-Mart (1) Current ratio 1.58 11 0.87 51 M (2) Accounts receivable tumover 8.35 times 99 02 times M (3) Average collection period 43.11 days 3.64 days (4) Inventory turnover 6.34 times 8.97 times (5) Days in inventory 57 days 40 days (6) Profit margin 7.99% 3.37% (7) Asset turnover 1.46 times 2.44 times (8) Return on assets 11 69 8.22 (9) Return on common stockholders' equity 34.87 26.12 % x (10) Debt to assets ratio 66.49 . 59.17 M (11) Times interest earned 10.62 times 11.29 times (12) Free cash flow 4,200.00 14,300.00 Click if you would like to Show Work for this question: Open Show Work LINK TO TEXT

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!