Suppose selected financial data of Target and Wal-Mart for 2014 are presented here (in millions).
|
|
Target Corporation
|
|
Wal-Mart Stores, Inc.
|
|
|
Income Statement Data for Year
|
Net sales
|
|
$65,058
|
|
|
$412,070
|
|
Cost of goods sold
|
|
44,493
|
|
|
300,265
|
|
Selling and administrative expenses
|
|
14,313
|
|
|
80,030
|
|
Interest expense
|
|
670
|
|
|
2,152
|
|
Other income (expense)
|
|
(88)
|
|
|
(395)
|
|
Income tax expense
|
|
1,470
|
|
|
7,329
|
|
Net income
|
|
$ 4,024
|
|
|
$ 21,899
|
|
|
|
|
|
|
|
|
|
|
Balance Sheet Data (End of Year)
|
Current assets
|
|
$18,846
|
|
|
$48,777
|
|
Noncurrent assets
|
|
25,173
|
|
|
120,791
|
|
Total assets
|
|
$44,019
|
|
|
$169,568
|
|
Current liabilities
|
|
$10,432
|
|
|
$55,783
|
|
Long-term debt
|
|
17,183
|
|
|
44,562
|
|
Total stockholders' equity
|
|
16,404
|
|
|
69,223
|
|
Total liabilities and stockholders' equity
|
|
$44,019
|
|
|
$169,568
|
|
|
|
|
|
|
|
|
|
|
Beginning-of-Year Balances
|
Total assets
|
|
$43,699
|
|
|
$164,440
|
|
Total stockholders' equity
|
|
14,470
|
|
|
65,233
|
|
Current liabilities
|
|
10,130
|
|
|
55,092
|
|
Total liabilities
|
|
29,229
|
|
|
99,207
|
|
|
|
|
|
|
|
|
|
|
Other Data
|
Average net accounts receivable
|
|
$7,545
|
|
|
$3,954
|
|
Average inventory
|
|
6,834
|
|
|
34,287
|
|
Net cash provided by operating activities
|
|
5,765
|
|
|
26,622
|
|
Capital expenditures
|
|
1,799
|
|
|
11,751
|
|
Dividends
|
|
512
|
|
|
4,215
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 12.61%.)
|
|
|
|
Target
|
|
Wal-Mart
|
(1)
|
|
Current ratio.
|
|
|
:1
|
|
|
:1
|
(2)
|
|
Accounts receivable turnover.
|
|
|
times
|
|
|
times
|
(3)
|
|
Average collection period.
|
|
|
days
|
|
|
days
|
(4)
|
|
Inventory turnover.
|
|
|
times
|
|
|
times
|
(5)
|
|
Days in inventory.
|
|
|
days
|
|
|
days
|
(6)
|
|
Profit margin.
|
|
|
%
|
|
|
%
|
(7)
|
|
Asset turnover.
|
|
|
times
|
|
|
times
|
(8)
|
|
Return on assets.
|
|
|
%
|
|
|
%
|
(9)
|
|
Return on common stockholders' equity.
|
|
|
%
|
|
|
%
|
(10)
|
|
Debt to assets ratio.
|
|
|
%
|
|
|
%
|
(11)
|
|
Times interest earned.
|
|
|
times
|
|
|
times
|
(12)
|
|
Current cash debt coverage.
|
|
|
times
|
|
|
times
|
(13)
|
|
Cash debt coverage.
|
|
|
times
|
|
|
times
|
(14)
|
|
Free cash flow.
|
|
$
|
|
|
$
|
|