Selected hypothetical financial data ofTargetandWalmartfor 2022 are presented here (in millions).

Target

Corporation

Walmart Inc.

Income Statement Data for Year

Net sales

$65,357

$408,214

Cost of goods sold

45,583

304,657

Selling and administrative expenses

15,101

79,607

Interest expense

707

2,065

Other income (expense)

(94

)

(411

)

Income tax expense

1,384

7,139

Net income

$2,488

$14,335

Balance Sheet Data

(End of Year)

Current assets

$18,424

$48,331

Noncurrent assets

26,109

122,375

Total assets

$44,533

$170,706

Current liabilities

$11,327

$55,561

Long-term debt

17,859

44,089

Total stockholders' equity

15,347

71,056

Total liabilities and stockholders' equity

$44,533

$170,706

Beginning-of-Year Balances

Total assets

$44,106

$163,429

Total stockholders' equity

13,712

65,682

Current liabilities

10,512

55,390

Total liabilities

30,394

97,747

Other Data

Average net accounts receivable

$7,525

$4,025

Average inventory

6,942

33,836

Net cash provided by operating activities

5,881

26,249

Capital expenditures

1,729

12,184

Dividends

496

4,217

(a)For each company, compute the following ratios.(Round current ratio to 2 decimal places, e.g 1.83 and all other answers to 1 decimal place, e.g. 1.8 or 2.5%. Use 365 days in calculation.)

Ratio

Target

Walmart

(1)

Current ratio

enter Current ratio rounded to 2 decimal places

:1

enter Current ratio rounded to 2 decimal places

:1

(2)

Accounts receivable turnover

enter a number of Accounts receivable turnover in times rounded to 1 decimal place

times

enter a number of Accounts receivable turnover in times rounded to 1 decimal place

times

(3)

Average collection period

enter a number of Average collection period in days rounded to 1 decimal place

days

enter a number of Average collection period in days rounded to 1 decimal place

days

(4)

Inventory turnover

enter a number of Inventory turnover in times rounded to 1 decimal place

times

enter a number of Inventory turnover in times rounded to 1 decimal place

times

(5)

Days in inventory

enter a number of days in inventory rounded to 1 decimal place

days

enter a number of days in inventory rounded to 1 decimal place

days

(6)

Profit margin

enter Profit margin in percentages rounded to 1 decimal place

%

enter Profit margin in percentages rounded to 1 decimal place

%

(7)

Asset turnover

enter a number of Asset turnover in times rounded to 1 decimal place

times

enter a number of Asset turnover in times rounded to 1 decimal place

times

(8)

Return on assets

enter Return on assets in percentages rounded to 1 decimal place

%

enter Return on assets in percentages rounded to 1 decimal place

%

(9)

Return on common stockholders' equity

enter Return on common stockholders' equity in percentages rounded to 1 decimal place

%

enter Return on common stockholders' equity in percentages rounded to 1 decimal place

%

(10)

Debt to assets ratio

enter Debt to assets ratio in percentages rounded to 1 decimal place

%

enter Debt to assets ratio in percentages rounded to 1 decimal place

%

(11)

Times interest earned

enter a number of times interest earned rounded to 1 decimal place

times

enter a number of times interest earned rounded to 1 decimal place

times

(12)

Free cash flow

$

enter Free cash flow in dollars

$

enter Free cash flow in dollars