Suppose selected financial data


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.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

:1

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

:1

(2)

 

Accounts receivable turnover.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(3)

 

Average collection period.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

days

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

days

(4)

 

Inventory turnover.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(5)

 

Days in inventory.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

days

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

days

(6)

 

Profit margin.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

(7)

 

Asset turnover.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(8)

 

Return on assets.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

(9)

 

Return on common stockholders' equity.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

(10)

 

Debt to assets ratio.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

(11)

 

Times interest earned.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(12)

 

Current cash debt coverage.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(13)

 

Cash debt coverage.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(14)

 

Free cash flow.

 

$https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

 

$https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

Request for Solution File

Ask an Expert for Answer!!
Financial Accounting: Suppose selected financial data
Reference No:- TGS01258708

Expected delivery within 24 Hours