Selected financial data of Target and Wal-Mart for 2006 are presented here (in millions).

Instructions
(a) For each company, compute the following ratios.
(1) Current.
(2) Receivables 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 total assets.
(11) Times interest earned.
(12) Current cash debt coverage.
(13) Cash debt coverage.
(14) Free cash flow.
(b) Compare the liquidity, solvency, and profitability of the twocompanies.

Transcribed Image Text:

Target Co Wal-Mart Stores, Inc ration Income Statement Data for Year Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $57,878 39,399 14,315 572 905 1,710 2,787 $348,650 264,152 64,001 1,809 (1,039) 6,365 11,284 Balance Sheet Data (End of Year) Current assets Noncurent assets Total assets Current liabilities Long-term debt Total stockholders equity Total liabilities and stockholders equity $14,706 22,643 $37,349 $11,117 10,599 15,633 $37,349 S 46,588 104,605 151,193 51,754 37,866 61,573 $151.193 Beginning-of-Year Balances 138,187 53,171 Total assets Total stockholders' equity Current liabilities Total liabilities 34,995 14,205 9,588 20,790 48,825 85,016 Other Data Average net receivables Average inventory Net cash provided by operating activities Capital expenditures Dividends 5,930 6,046 4,862 3,928 380 $2,707 32,797 20,209 15,666 2,802