Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

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

Costing

Authors: Lucey

7th Edition

1844809439, 978-1844809431

More Books

Students also viewed these Accounting questions