Problem 13-5A

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 $65,300 $417,000 Cost of goods sold 45,000 301,000 Selling and administrative expenses 14,000 79,000 Interest expense 660 1,800 Other income (expense) (85 ) (380 ) Income tax expense 1,500 7,100 Net income $ 4,055 $ 27,720 Balance Sheet Data (End of Year) Current assets $16,000 $50,000 Noncurrent assets 27,400 121,000 Total assets $43,400 $171,000 Current liabilities $11,000 $54,000 Long-term debt 17,800 43,000 Total stockholders equity 14,600 74,000 Total liabilities and stockholders equity $43,400 $171,000 Beginning-of-Year Balances Total assets $45,000 $162,000 Total stockholders equity 12,800 66,000 Current liabilities 10,800 54,000 Total liabilities 32,200 96,000 Other Data Average net accounts receivable $7,600 $3,800 Average inventory 7,100 33,200 Net cash provided by operating activities 5,600 27,400 Capital expenditures 1,600 12,100 Dividends 470 4,200 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.) Ratio Target Wal-Mart

(1) Current ratio Entry field with correct answer 1.45 :1 Entry field with correct answer 0.93 :1

(2) Accounts receivable turnover Entry field with correct answer 8.59 times Entry field with correct answer 109.74 times

(3) Average collection period Entry field with correct answer 42.48 days Entry field with correct answer 3.33 days

(4) Inventory turnover Entry field with correct answer 6.34 times Entry field with correct answer 9.07 times

(5) Days in inventory Entry field with correct answer 57.59 days Entry field with correct answer 40.26 days

(6) Profit margin Entry field with correct answer 6.21 % Entry field with correct answer 6.65 %

(7) Asset turnover Entry field with correct answer 1.48 times Entry field with correct answer 2.5 times

(8) Return on assets Entry field with incorrect answer 10.86 % Entry field with incorrect answer 17.26 %

(9) Return on common stockholders equity Entry field with incorrect answer 27.77 % Entry field with incorrect answer 37.46 %

(10) Debt to assets ratio Entry field with incorrect answer .66 % Entry field with incorrect answer .57 %

(11) Times interest earned Entry field with correct answer 9.42 times Entry field with correct answer 20.34 times

(12) Free cash flow $Entry field with incorrect answer 4000 $Entry field with incorrect answer 15300

I need help on numbers 8/9/10/12. Thanks