Financial Performance of Seven Companies - Microsoft, Walmart, Royal Carrobean, Dell, Hp, Tiffany and Applebee

1. Microsoft

2. Wal-mart

3. Royal Carribean

4. Dell

5. Hewlett- Packard

6. Tiffany’s

7. Applebee’s

% of sales

 Cost of goods sold

16.1%

78.1%

0.0%

77.9%

68.1%

76.4%

50.9%

 Operating expense

41.9%

16.1%

81.5%

11.4%

23.7%

9.0%

42.2%

% of assets

 Cash and equivalents

62.3%

3.8%

3.0%

43.2%

12.1%

1.3%

17.9%

 Accounts receivable

6.5%

2.2%

0.7%

34.8%

18.5%

3.4%

10.2%

 Inventory

0.0%

34.2%

0.6%

5.5%

18.4%

1.3%

45.5%

 Current assets

71.1%

42.3%

5.0%

91.7%

64.1%

6.8%

77.2%

 Net, PPE

6.7%

47.4%

89.2%

8.0%

18.9%

71.3%

18.0%

 Current liabilities

25.6%

33.5%

15.7%

63.2%

40.0%

12.9%

27.7%

 Interest-bearing debt

0.0%

21.2%

43.4%

0.4%

9.8%

28.8%

27.5%

 Equity

74.4%

42.2%

43.2%

30.3%

50.2%

57.9%

48.8%

DuPont analysis

 Net Margin

29.4%

3.2%

12.6%

7.7%

6.3%

7.7%

7.7%

 Total asset turnover

0.683

2.784

0.464

2.888

1.398

1.267

1.106

 Return on asset

20.1%

8.9%

5.8%

22.1%

8.7%

9.8%

8.5%

 Financial leverage

1.345

2.368

2.316

3.301

1.990

1.726

2.048

 Return on equity

27.0%

21.0%

13.5%

73.0%

17.4%

16.9%

17.4%

Other metrics

 Current ratio

2.77

1.26

0.32

1.45

1.60

0.53

2.78

 A/R days outstanding

34.92

2.93

5.12

44.00

48.33

9.67

33.72

 Inventory days O/S

n/a

57.33

n/a

8.85

70.38

4.95

295.07

Companies

Number

Applebee’s

7

Wal-Mart

2

Dell

4

Microsoft

1

Royal Carribean

3

Tiffany’s

6

Hewlett-Packard

5

2006-$ millions

Wal-Mart

365/Days

Target

365/Days

Costco

365/Days

Sales

$ 315,654

864.81

$ 52,620

144.16

$ 52,935

145.03

Cost of sales

240,391

658.61

34,927

95.69

46,347

126.98