Question

In: Finance

An analyst is trying to value KL’s stock. The analyst has collected data from the company...

  1. An analyst is trying to value KL’s stock. The analyst has collected data from the company and other sources to prepare the below financials, both actual and projected. Based upon these sources, the analyst expects the company’s free cash flows to grow at 8% in 2019, 6% in 2020, and at 4% on average thereafter. The analyst has estimated the company’s cost of capital to be 12.01%. Given this and the below information, what is the value of the firm? What is a reasonable estimate of its appropriate share price today assuming that there are 10,000,000 shares issued and outstanding?

Income statement for the fiscal year ending January 1 (Millions of dollars)

                                                 2017 (Actual)

2018 (Projected)

Net Sales

$400.0

$430.0

Costs

260.0

283.5

Depreciation

37.5

42.5

Earnings before interest and taxes

102.5

104.0

Interest expense

14.1

16.0

Earnings before taxes

88.4

89.9

Taxes (40%)

35.36

35.2

Net income before preferred dividends

53.04

52.8

Preferred dividends

6.0

6.5

Net income

47.04

46.3

Common dividends

37.632

38.2

Addition to retained earnings

9.0408

8.1

Balance sheets for the fiscal year ending January 1 (Millions of dollars)

                                              2017 (Actual)

2018 (Projected)

Cash

$6.3

$6.6

Marketable Securities

40.9

37.128

Accounts Receivable

62.0

66.0

Inventories

107.0

115.5

Net plant & equipment

391.0

415.36

Total Assets

607.2

640.58

Accounts payable

9.6

12.1

Accruals

25.5

29.1

Long-term bonds

210.7

227.78

Preferred Stock

55

57.1

Common Stock (Par plus PIC)

160.0

160.0

Retained earnings

146.4

154.5

Total Liabilities & Equity

607.2

640.58

Solutions

Expert Solution

Free cash Flow to Firm (FCFF) =

EBIT= Earning Before Interest and Tax

t= tax rate

Cap.Ex = Capital Expenditure

= Change in working capital

calculating capital expenditure in 2018-

- Net plant and equipment in 2018 end = Net plant and equipment in 2017 end+ capital expenditure in 2018-depreciation in 2018.

Particulars Amount($Million)
Net plant & equipment in 2018 415.36
Add-Dereciation of 2018 42.5
Less-Net plant & equipment in 2017 391
Addition of plant & equipment or Capital expenditure in 2018 66.86

calculating working capital change in 2018-

working capital = Curremt assets-Current liabilities

Working capital chahnge in 2018 = Net working capital in 2018- Net working capital 2017

2018 2017 Changes
Current assets $MILLION $MILLION
Cash 6.6 6.3
Marketable Securities 37.128 40.9
Accounts Receivable 66 62
Inventories 115.5 107
Total current assets(A) 225.228 216.2
Current liabilties
Accounts payable 12.1 9.6
Accruals 29.1 25.5
Total Current liabilities(B) 41.2 35.1
Net working capital(A-B) 184.028 181.1 2.928

hence net working capital change is $2.928 million

Free cash Flow to Firm (FCFF) =

=>FCFF of 2018 = 104(1-0.40)+ 42.5 -66.86-2.928 = $35.112 MILLION

FCFF of 2019 = FCFF of 2018*(1+growth) = $35.112*(1+8%) = $35.112*1.08 = $37.92096 million

FCFF of 2020 = FCFF of 2019*(1+growth) = 37.92096*(1+6%) = 37.92096*1.06 = $40.1962176 million

FCFF of 2021 = FCFF of 2020*(1+growth) = 40.1962176*1.04 = $41.8040663 million

v0 = value of firm at year 0

FCFF1 = Next year Free cash flow

Ke = cost of capital

g =growth rate

=>value of firm at year 2020 end = FCFF at 2021/(12.01%-4%) = $41.8040663 million / 0.0801 = $521.8984557 million

value of Firm at 2017 = PV of FCFF till 2020+ PV of value of firm at the end of 2020

sl no year Amount($million)(A) [email protected]%(B)

pv of FCFF(A*B)

1 2018 FCFF 35.112 0.8927774306 31.34720114
2 2019 FCFF 37.92096 0.7970515406 30.22495959
3 2020 FCFF 40.1962176 0.7115896264 28.60321147
3 2020 Value of firm 521.8984557 0.7115896264 371.3775271
Total 461.5528993

hence value of firm at 2017 = $461.5528993 million or $461.553 million (Round off)

value of firm = value of shares+value of debt+value of preferred stock

=>value of share = value of firm-value of debt-value of preferred stock

=>value of share at 2017 = $461.553 million-$210.7 million-$55 million = $195.853 million

estimate share price = value of share/ number of shares outstanding

=>Esimated share price today = $195.853 million/ 10 million share = $19.5853 per share or $19.59 per share approx


Related Solutions

An analyst is trying to value Jason’s Specialties (JS) stock. The analyst has collected data from...
An analyst is trying to value Jason’s Specialties (JS) stock. The analyst has collected data from the company and other sources to prepare the below financials, both actual and projected. Based upon these sources, the analyst expects the company’s free cash flows to grow at 4% on average. The analyst has estimated the company’s cost of capital (WACC) to be 16% and its cost of equity to be 21%. The risk-free rate is 2.3%.. Which items listed under Current Assets...
An analyst is trying to value Jason’s Specialties (JS) stock. The analyst has collected data from...
An analyst is trying to value Jason’s Specialties (JS) stock. The analyst has collected data from the company and other sources to prepare the below financials, both actual and projected. Based upon these sources, the analyst expects the company’s free cash flows to grow at 4% on average. The analyst has estimated the company’s cost of capital (WACC) to be 16% and its cost of equity to be 21%. The risk-free rate is 2.3%.. Compute the firm’s FCF (free cash...
An analyst is trying to value Jason’s Specialties (JS) stock. The analyst has collected data from...
An analyst is trying to value Jason’s Specialties (JS) stock. The analyst has collected data from the company and other sources to prepare the below financials, both actual and projected. Based upon these sources, the analyst expects the company’s free cash flows to grow at 4% on average. The analyst has estimated the company’s cost of capital (WACC) to be 16% and its cost of equity to be 21%. The risk-free rate is 2.3%.. Which items listed under Current Assets...
An analyst is trying to estimate the intrinsic value of Burress Inc. The analyst has estimated...
An analyst is trying to estimate the intrinsic value of Burress Inc. The analyst has estimated the company's free cash flows for the following years Year Free Cash flow 1 $3,000 2 $4,000 3 $5,000 An analyst estimates that after 3 years (t=3) the company's cashflows will grow at a constant rate of 6% per year. the analyst estimates that the company's WACC is 10%. the company's debt and preferred stock has a total market value of $25,000 and there...
A financial analyst collected some data about a company, which has two sources of financing: debt...
A financial analyst collected some data about a company, which has two sources of financing: debt (25%) and equity (the rest). The firm's bonds yield 7%, and the company's tax rate is 35%. The risk-free rate is 1.50%, the market risk premium is 5%, and the stock's beta is 0.8. Find the company's WACC.
John Smith, an analyst with Fidelity Securities, is trying to evaluate Company ABC’s target stock price...
John Smith, an analyst with Fidelity Securities, is trying to evaluate Company ABC’s target stock price per share. Free cash flow (FCF) estimates for the next four years are -$2, $15, 17, and $20 million, after which the FCF is expected to grow at 6% forever. The overall firm cost of capital is 9%. The firm has $45 million in debt and has 16 million shares of stock. What are the horizon value HV and the estimated value per share?...
An analyst has collected the following data about two projects, each with a 12% required rate...
An analyst has collected the following data about two projects, each with a 12% required rate of return. Initial Cost Life Cash Inflows Project A $15,000 5 years $5,000/year Project B $20,000 4 years $7,500/year (a) Calculate the Net Present Value of both projects. (b) If the projects are independent, which project(s) should the company accept? (c) If the projects are mutually exclusive, which project(s) should the company accept? (d) Calculate the Net Present Value for each project for alternative...
An analyst is interested to value put options on the stock of Bulls Inc. The analyst...
An analyst is interested to value put options on the stock of Bulls Inc. The analyst has accumulated the following information: • The price of the stock is $40. • The strike price is $38. • The option matures in 2 months. • The variance of the stock’s returns is 0.25. • The annual risk-free rate is 6%. Using the Black-Scholes model, what is the value of the put option?
You are an analyst working for Goldman​ Sachs, and you are trying to value the growth...
You are an analyst working for Goldman​ Sachs, and you are trying to value the growth potential of a​ large, established​ company, Big Industries. Big Industries has a thriving​ R&D division that has consistently turned out successful products. You estimate​ that, on​ average, the division launches two projects every three​ years, so you estimate that there is a 60 % chance that a project will be produced every year.​ Typically, the investment opportunities the​ R&D division produces require an initial...
Konza Company has collected the following cost and production data from their manufacturing operations over the...
Konza Company has collected the following cost and production data from their manufacturing operations over the past eight months. Period Units Produced Total costs (Sh) 1 2,200 10,500 2 3,100 12,750 3 5,600 18,500 4 1,700 9,250 5 6,300 20,750 6 8,100 25,250 7 5,050 17,625 8 3,000 12,500 (a) Using the high-low method ; i. Estimate the fixed production costs, ii. Estimate the variable production cost per unit, (b) Establish a cost estimating function for the total production costs....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT