Exide stock price had been lagging its industry averages so


Exide Corporation

Exide stock price had been lagging its industry averages, so its board of directors brought in a new CEO, John Lee. Lee had brought in Ashley Novak;finance MBA who had been working for a consulting company, to replace the old CFO, and Lee asked Ashley to develop the financial planning section of the strategic plan. In her previous job, Novak's primary task had been to help clients understand and interpret financial statements and develop financial forecasts.

Novak began as she always did, by comparing Exide's financial ratios to the industry averages. If any ratio was substandard, she discussed it with the responsible manager to see what could be done to improve the situation. The following data shows Exide's latest financial statements plus some ratios and other data that Novak plans to use in her analysis.

Exide (Millions of Dollars Except Per Share Data)

 

Balance Sheet, 12/31/2013

Income Statement, Year Ending 2013

 

Cash

$     20

Sales

$2,000

 

Accts. rec.

280

Op. costs (excl. depr.)

1,800

 

Inventories

     400

Depreciation

       50

 

Total CA

$   700

EBIT

$   150

 

Net fixed assets

     500

Interest

40

 

Total assets

$1,200

Pretax earnings

$   110

 



Taxes (40%)

      44

 

Accts. pay. & accruals

$     80

Net income

$     66

 

Line of credit

$0



 

Total CL

$     80

Dividends

$20.0

 

Long-term debt

     500

Add. to RE

$46.0

 

Total liabilities

$   580

Common shares

10.0

 

Common stock

420

EPS

$6.60

 

Retained earnings

200

DPS

$2.00

 

 Total common equ.

   $620

Ending stock price

$52.80

 

Total liab. & equity

$1,200



 

Selected Additional Data for 2013


Exide

Industry


Exide

Industry

Op. costs/Sales

90.0%

88.0%

Total liability/Total assets

48.3%

36.7%

Depr./FA

10.0%

12.0%

Times interest earned

3.8

8.9

Cash/Sales

1.0%

1.0%

Return on assets (ROA)

5.5%

10.2%

Receivables/Sales

14.0%

11.0%

Profit margin (M)

3.30%

4.99%

Inventories/Sales

20.0%

15.0%

Sales/Assets

1.67

2.04

Fixed assets/Sales

25.0%

22.0%

Assets/Equity

1.94

1.56

Acc. pay. &accr. / Sales

4.0%

4.0%

Return on equity (ROE)

10.6%

16.1%

Tax rate

40.0%

40.0%

P/E ratio

8.0

16.0

ROIC

8.0%

12.5%




NOPAT/Sales

4.5%

5.6%




Total op. capital/Sales

56.0%

45.0%




Note:  Exide was operating at full capacity in 2013.  Also, you may observe small differences in items like the ROE

when calculated indifferent ways.  Any such differences are due to rounding, and they can be ignored.

a. Using Exide data and its industry averages, how well run would you say Exide appears to be in comparison with other firms in its industry? What are its primary strengths and weaknesses? Be specific in your answer, and point to various ratios that support your position. Also, use the Du Pont equation as one part of your analysis.

b. How much additional funds needed (AFN) for 2014 if the sale growth rate is 10%. Assume that the firm's 2013 ratios will remain the same in 2014.

c. Define the term capital intensity. Explain how a decline in capital intensity would affect the AFN, other things held constant. Would economies of scale combined with rapid growth affect capital intensity, other things held constant?

d. Explain how changes in each of the following would affect AFN, holding other things constant: the growth rate, the amount of accounts payable, the profit margin, and the payout ratio.

e. Define the term Internal and Sustainable growth rate. What is Exide's sustainable growth rate? Would the sustainable growth rate be affected by a change in the capital intensity ratio or the other factors mentioned in the previous question? Other things held constant, would the calculated capital intensity ratio change over time if the company were growing and were also subject to economies of scale and/or lumpy assets?

Use the following assumptions to answer the questions below:

(1) Operating ratios remain unchanged.

(2) Sales will grow by 10%, 8%, 5%, and 5% for the next four years. 

(3) The target weighted average cost of capital (WACC) is 9%.


Actual

Forecast

Inputs

2013

2014

2015

2016

2017

Sales growth rate:


10%

8%

5%

5%

Op. costs/Sales:

90%

90%

90%

90%

90%

Depr./FA

10%

10%

10%

10%

10%

Cash/Sales:

1%

1%

1%

1%

1%

Acct. rec. /Sales

14%

14%

14%

14%

14%

Inv./Sales:

20%

20%

20%

20%

20%

FA/Sales:

25%

25%

25%

25%

25%

AP &accr. / Sales:

4%

4%

4%

4%

4%

Tax rate:

40%

40%

40%

40%

40%

Rate on all debt


8.0%

8%

8%

8%

Div. growth rate:

5%

10%

10%

10%

10%

Target WACC


9%

 

 

 

f. For each of the next four years, forecast the items in the above table.

g. Using the forecasted items in the section f, calculate for each of the next four years the net operating profit after taxes (NOPAT), net operating working capital, total operating capital, free cash flow, (FCF), annual growth rate in FCF, and return on invested capital.  What does the forecasted free cash flow in the first year imply about the need for external financing? Compare the forecasted ROIC compare with the WACC. What does this imply about how well the company is performing? Calculate the Economic Value Added (EVA) to see whether the company is creating value or destroying.

EVA = (ROIC - WACC) (Beg. Capital)

h. Assume that FCF will continue to grow at the growth rate for the last year in the forecast horizon (Hint: 5%). What is the terminal value at 2017? What is the present value of the terminal value? What is the present value of the forecasted FCF? (Hint: use the free cash flows for 2014 through 2017). What is the current value of operations? Using information from the 2013 financial statements, what is the current estimated intrinsic stock price?

Request for Solution File

Ask an Expert for Answer!!
Finance Basics: Exide stock price had been lagging its industry averages so
Reference No:- TGS01002656

Expected delivery within 24 Hours