following ratios and inventory levels are for the Sterling Company for each of the past...

50.1K

Verified Solution

Question

Accounting

following ratios and inventory levels are for the Sterling Company for each of the past 3 years:

Sterling Company Ratio Analysis

Actual

Actual

Actual

Industry Average

TS:Time-series

Ratio

2007

2008

2009

2009

CS:2009 vs. Industry Average

Current ratio

1.40

1.55

1.67

1.85

TS:

CS:

Quick ratio

1.00

0.92

0.88

1.05

TS:

CS:

Inventory turnover

9.52

9.21

7.89

8.60

TS:

CS:

Average collection

TS:

period

45.6 days

36.9 days

29.2 days

35.5 days

CS:

Average payment

TS:

period

59.3 days

61.6 days

53.0 days

46.4 days

CS:

Total asset turnover

0.74

0.80

0.83

0.74

TS:

CS:

Debt ratio

0.20

0.20

0.35

0.30

TS:

CS:

Times interest earned

8.2

7.3

6.5

8.0

TS:

CS:

Fixed payment

TS:

coverage ratio

4.5

4.2

2.3

4.2

CS:

Gross profit margin

0.30

0.27

0.25

0.25

TS:

CS:

Operating profit

TS:

margin

0.12

0.12

0.13

0.10

CS:

Net profit margin

0.062

0.062

0.066

0.053

TS:

CS:

Return on total

TS:

assets

0.045

0.050

0.055

0.040

CS:

Return on common

TS:

Equity

0.061

0.067

0.085

0.066

CS:

Earnings per share

TS:

(EPS)

$1.75

$2.20

$3.05

$1.50

CS:

Price/earnings

TS:

(P/E)

12.0

10.5

13.0

11.2

CS:

Market/book ratio

TS:

(M/B)

1.20

1.05

1.01

1.10

CS:

a) In the last column above, indicate the following:

Under TS: indicate whether the performance improved or deteriorated over the years.

Under CS: indicate how the company performed overall against the industry average (poor, fair, better).

b) Analyze Sterlings overall financial situation from both a cross-sectional and a time-series viewpoint for the following areas:

- Liquidity performance

- Activity performance

- Debt performance

- Profitability performance

- Market performance

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students