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

Instructions
(a) For each company, compute the following ratios.
(1) Current ratio.
(2) Accounts receivable turnover.
(3) Average collection period.
(4) Inventory turnover.
(5) Days in inventory.
(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.
(b) Compare the liquidity, solvency, and profitability of the two companies.

Transcribed Image Text:

Target Corporation Wal-Mart Stores, Inc Income Statement Data for Yea $65,357 45,583 15,101 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $408,214 304,657 79,607 2,065 (411) 7.139 $ 14,335 0 (94) 1384 $2,488 alance Sheet Data (End of Year $18,424 $48,331 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity 26,109 $44,533 $11,327 17,859 15.347 $44,533 122.375 $170,706 $55,561 44,089 71,056 $170,706 Beginning-of-Year Balances Total assets Total stockholders' equity Current liabilities Total liabilities $44,106 13,712 10,512 30,394 $163,429 65,682 55.390 97,747 Other Data Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends $7,525 6,942 5,881 1,729 496 $4,025 33,836 26,249 12,184 4,217