Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exhibit 1 presents balance sheets in percentage form as well as selected ratios computed from fiscal 2009 balance sheets and income statements for 13 companies

Exhibit 1 presents balance sheets in percentage form as well as selected ratios computed from fiscal 2009 balance sheets and income statements for 13 companies from the following industries:

x airline

x railroad

x pharmaceutical

x commercial banking

x computer and office equipment production and servicing

x discount general-merchandise retail

x electric utility

x fast food restaurant chain

x wholesale food distribution

x supermarket chain

x Internet retailing

x tax preparation and diversified financial services

x computer software development

Study the balance sheet profiles and the financial ratios listed for each of the 13 companies as presented in Exhibit 1.1 Your assignment is to use your intuition, common sense, and basic understanding of the unique attributes of each industry to match each column in the exhibit with one of the industries listed above. Be prepared to give the reasons for your pairings, citing the data that seem to be consistent with the characteristics of the industry you selected.

1

2

3

4

5

6

7

8

9

10

11

12

13

Year end

1.30.10

5.31.09

12.31.09

4.30.09

12.25.09

1.31.10

12.31.09

10.31.09

12.31.09

1.2.10

12.31.09

12.31.09

12.31.09

Assets: Cash

4.7%

26.6%

23.6%

31.8%

4.0%

4.6%

46.1%

11.6%

8.6%

0.1%

18.4%

5.9%

0.8%

Accts. Receivable

3.9%

9.3%

3.9%

9.6%

3.7%

2.4%

7.2%

16.7%

5.9%

25.1%

64.4%

3.5%

3.9%

Inventory

21.2%

0.0%

2.0%

0.0%

0.8%

19.4%

15.7%

5.3%

7.2%

28.6%

0.0%

0.4%

1.0%

Other CA

2.4%

3.2%

4.7%

6.6%

1.0%

1.8%

2.0%

12.1%

3.7%

2.1%

3.0%

1.5%

3.9%

Total Current Assets

32.3%

39.2%

34.2%

48.0%

9.5%

28.3%

70.9%

45.8%

25.4%

55.8%

85.8%

11.3%

9.6%

Net PP&E

60.3%

4.1%

58.1%

6.9%

85.9%

59.9%

9.3%

9.8%

16.3%

21.5%

2.6%

71.2%

66.3%

Goodwill

5.0%

39.7%

0.0%

15.9%

0.0%

9.4%

8.9%

28.8%

10.6%

16.7%

2.1%

8.0%

1.2%

Other

2.4%

17.0%

7.7%

29.3%

4.6%

2.3%

10.8%

15.6%

47.7%

6.1%

9.5%

9.4%

22.9%

Total Assets

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

Liabilities: Accts. Pay.

16.8%

0.6%

7.2%

13.2%

3.6%

17.8%

40.6%

12.9%

2.0%

24.1%

74.4%

2.1%

0.8%

ST Debt

2.5%

2.1%

7.6%

0.6%

0.4%

2.6%

0.0%

1.6%

1.4%

0.4%

1.4%

0.1%

2.2%

Other

14.1%

16.6%

19.5%

30.9%

2.9%

12.1%

12.7%

22.9%

10.6%

6.4%

0.7%

7.7%

5.7%

Total Current Liabilities

33.4%

19.3%

34.3%

44.7%

6.9%

32.5%

53.3%

37.5%

14.1%

30.9%

76.4%

9.9%

8.7%

LT Debt

32.4%

19.5%

41.4%

20.7%

29.2%

21.3%

0.8%

12.2%

14.3%

27.9%

9.3%

34.9%

29.1%

Other

13.0%

8.3%

19.6%

8.4%

31.1%

3.4%

7.8%

15.1%

16.7%

6.1%

2.4%

8.7%

31.3%

Total Liabilities

78.8%

47.1%

95.4%

73.8%

67.2%

57.3%

61.9%

64.7%

45.1%

64.9%

88.1%

53.6%

69.1%

Equity: Minority Interest

0.3%

0.0%

0.0%

0.0%

0.1%

1.3%

0.0%

0.0%

2.2%

0.0%

0.0%

0.0%

0.0%

Net Contributed Capital

-8.3%

27.4%

17.3%

-23.4%

1.7%

2.4%

37.2%

12.0%

18.2%

10.0%

6.1%

-59.5%

10.6%

Retained Earnings + OCI

29.2%

25.5%

-12.7%

49.6%

31.0%

39.0%

0.8%

23.2%

34.5%

25.1%

5.8%

105.9%

20.3%

Total Equity

21.2%

52.9%

4.6%

26.2%

32.8%

42.7%

38.1%

35.3%

54.9%

35.1%

11.9%

46.4%

30.9%

Total Liab. & Equity

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

ROS

0.1%

24.1%

-2.2%

11.9%

12.7%

3.5%

3.7%

6.7%

47.0%

0.1%

15.8%

20.0%

6.7%

Asset Turnover

3.32

0.49

0.98

0.76

0.33

2.39

1.77

1.00

0.24

5.22

0.04

0.75

0.38

ROA

0.3%

11.8%

-2.2%

9.0%

4.3%

8.4%

6.5%

6.7%

11.5%

0.3%

0.7%

15.1%

2.6%

Financial Leverage

4.71

1.89

21.66

3.81

3.05

2.34

2.63

2.83

1.82

2.85

8.40

2.15

3.24

ROE

1.4%

22.3%

-47.8%

34.5%

13.0%

19.7%

17.2%

18.9%

21.0%

0.8%

5.5%

32.4%

8.3%

Current ratio

0.97

2.03

1.00

1.07

1.38

0.87

1.33

1.22

1.80

1.81

1.12

1.14

1.10

Receivables collection

4

70

14

46

40

4

15

61

88

18

5710

17

37

Inventory Turnover

12.0

N/A

N/A

N/A

8.4

9.2

8.7

9.2

1.1

16.8

N/A

86.3

13.5

Gross margin

23.2%

94.2%

N/A

33.2%

N/A

25.4%

22.6%

23.7%

67.1%

8.0%

N/A

40.8%

63.4%

Dividend payout

340.0%

4.5%

0.0%

41.0%

29.9%

29.4%

0.0%

10.0%

27.0%

332.6%

33.5%

49.1%

69.2%

Revenue growth

0.8%

3.7%

-17.4%

-0.1%

-19.7%

0.9%

27.9%

-3.2%

15.0%

12.5%

-16.8%

-3.3%

-4.1%

R & D ratio

N/A

11.90%

N/A

N/A

N/A

N/A

5.06%

2.46%

21.31%

N/A

N/A

N/A

N/A

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Auditing A Practical Approach

Authors: Robyn Moroney, Fiona Campbell, Jane Hamilton, Valerie Warren

4th Canadian Edition

1119709490, 9781119709497

More Books

Students also viewed these Accounting questions