Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data for Argils Textiles2014 financial statements are given in Tables 7.1 and 7.2 in the chapter. a) Compute the 2014 values of the following ratios:

Data for Argils Textiles2014 financial statements are given in Tables 7.1 and 7.2 in the chapter.

a) Compute the 2014 values of the following ratios:

b) Briefly comment on Argiles 2014 financial position. Can you see any obvious strengths or weaknesses?

c)Compare Argiles 2014 ratios with its 2015 ratios, which are presented in Table 7-6. Comment on whether you believe Argiles fincial position improved or deriorated ruring 2015.

d) What other information would be useful for projecting whether Argiles financial position is expected to improve or deteriorate in the future?

TABLE 2: Argile Textiles: Income Statement for Years Ending December 31 ($ million, except per-share data)

2015

2014

Amount

Percent of total Assets

Amount

Percent of total assets

Net Sales

$750.0

100.0%

$700.0

100.0%

Cost of goods sold

(600.0)

80.0

(560.0)

80.0

Gross profit

$150.0

20.0

140.0

20.0

Fixed operating expenses except depreciation

(55.0)a

7.3

(50.0)

7.1

Earnings before interest, taxes, depreciation

and amortization (EBITDA)

$95.0

12.7

$90.0

12.9

Depreciation

(30.0)

4.0

(24.0)

3.4

Net operating income (NOI)

=Earnings before interest and taxes (EBIT)

$65.0

8.7

$66.0

9.4

Interest

(20.0)

2.7

(18.0)

2.6

Earnings before taxes (EBT)

$45.0

6.0

48.0

6.9

Taxes (40%)

(18.0)

2.4

(19.2)

2.7

Net income

$27.0

3.6

$28.8

4.1

Preferred dividends b

0.0

0.0

Earnings available to common shareholders (EAC)

$27.0

$28.8

Common dividends

(14.0)

(13.0)

Addition to retained earnings

$13.0

$15.8

Per-Share Data (11 million shares)

Earnings per share (EPS) = (Net income)/Shares

$2.45

$2.62

Dividends per share (DPS)

$1.27

$1.18

=(Common dividends/Shares

TABLE 6: Argile Textiles: Summary of 2015 Financial Ratios ($ million, except per-share dollars)

Ratio

Formula for Calculation

Computation

Ratio Value

Industry Average

Comment

Liquity

Current

= Current assets__

Current liabilities

$235.0

$65.0

=

3.6x

4.1x

Low

Quick, or acid test

= Current assets Inventory

Current liabilities

$100.0

$65.0

=

1.5x

2.1x

Low

Asset Management

Inventory turnover

= Cost of goods sold

Inventory

$600.0

$135.0

=

4.4x

7.4x

Low

Days sales out-

standing (DSO)

= Accounts receivable

$90.0

$2.08

=

43.2 days

32.1 days

Poor

Fixed assets

turnover

= ___Sales_______

Net fixed assets

$750.0

$190.0

=

3.9x

4.0x

OK

Total assets

turnover

= Sales

Total assets

$750.0

$425.0

=

1.8x

2.1x

Low

Debt Management

Debt-to-total-assets

= Total liabilities

Total assets

$217.0

$425.0

=

51.1%

42.0%

Poor

Times interest

earned (TIE)

= EBIT________

Interest charges

$65.0

$20.0

=

3.3x

6.5x

Low

Fixed charge

coverage

= ____EBIT+ Lease payments

Interest Lease Sinking fund payments

charges + payments + (1 Tax rate)

$70.0

$31.7

=

2.2x

5.8x

Low

Profitability

Net profit margin

= Net income

Sales

$27.0

$750.0

=

3.6%

4.9%

Poor

Return on total

Assets (ROA)

= Net income

Total assets

$27.0

$425.0

=

6.4%

11.5%

Poor

Return of equity

(ROE)

=Net income available to common stockholders

Common equity

$27.0

$208.0

=

13.0%

$17.7

Poor

Market Value

Price/Earnings(P/E)

=Market price per share

Earnings per share

$20.00

$2.45

=

8.2x

15.0x

Low

Market/Book (M/B)

=Market price per share

Book value per share

$20.00

$18.91

=

1.1x

2.2x

Low

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

Students also viewed these Finance questions