Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

elected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Target Corporation Walmart Inc. Income Statement Data for Year Net

elected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions).

Target Corporation

Walmart Inc.

Income Statement Data for Year

Net sales

$65,520

$410,820

Cost of goods sold

46,200

307,580

Selling and administrative expenses

14,500

77,000

Interest expense

660

2,000

Other income (expense)

(85

)

(410

)

Income tax expense

1,400

7,100

Net income

$ 2,675

$ 16,730

Balance Sheet Data (End of Year)

Current assets

$16,000

$49,140

Noncurrent assets

26,100

123,000

Total assets

$42,100

$172,140

Current liabilities

$10,000

$54,000

Long-term debt

17,100

45,000

Total stockholders equity

15,000

73,140

Total liabilities and stockholders equity

$42,100

$172,140

Beginning-of-Year Balances

Total assets

$43,000

$164,000

Total stockholders equity

13,900

65,000

Current liabilities

10,900

57,000

Total liabilities

29,100

99,000

Other Data

Average net accounts receivable

$7,800

$4,100

Average inventory

7,000

33,800

Net cash provided by operating activities

5,600

27,400

Capital expenditures

1,800

12,500

Dividends

470

3,700

(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.)

image text in transcribed

Ratio Target Walmart (1) Current ratio .1 :1 1 ) (2) Accounts receivable turnover times times (3) ( Average collection period days days (4) Inventory turnover times times (5 (5) Days in inventory days days (6) Profit margin %6 (7) Asset turnover times times (8) Return on assets %6 6 (9) Return on common stockholders' equity % 6 (10) Debt to assets ratio % OX (11) Times interest earned times times (12) Free cash flow $ $ $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions