Question

In: Accounting

Abbey Taylor, CFA, has been directed to determine the value of Sundanci’s stock using the FCFE...

Abbey Taylor, CFA, has been directed to determine the value of Sundanci’s stock using the FCFE valuation model. Taylor believes that Sundanci’s FCFE will grow at 12% for years 2020, 2021, 2022, 2023, and 2024, and 5% thereafter. Capital expenditures, depreciation, and working capital are all expected to increase proportionately with FCFE. Assume that the corporate tax rate is 30 percent. Using the data from Table 1, calculate the value of a share of Sundanci stock at the end of year 2019 based on the two-stage FCFE valuation model

2018 2019
Income Statement
Revenue 624.000 746.000
Tot Op Costs 368.000 460.000
Depreciation 35.000 48.000
EBIT 221.000 238.000
Interest 10.000 9.000
Taxes 63.300 68.700
Net Income 147.700 160.300
Dividends 29.540 32.060
EPS 1.758 1.670
Div PS 0.352 0.334
Com shares Outs 84.000 96.000
Balance Sheet
Current Assets 246.000 384.000
Net PPE 629.000 748.000
Total Assets 875.000 1132.000
Current Liabilities 86.000 141.000
Long-term Debt 205.000 178.000
Total Liabilities 291.000 319.000
Shareholder's equity 584.000 813.000
Total L&E 875.000 1132.000
Capital Expenditures 56.000 68.000
Other Info
Existing market Value of Debt 185.000 169.000
Selected Financial Information
Required Rate of ROE 0.14
WACC 0.102
Growth Rate of Industry 0.13
Industry P/E ratio 26

Solutions

Expert Solution

Determination of Forecasted Free Cash flow of the Sundanci’s
Particulars 2019 2020 2021 2022 2023 2024 Terminal year
Revenue (12% growth).        746.00         835.52       935.78              1,048.08      1,173.85       1,314.71          1,380.44
EBIT (12% growth).        238.00         266.56       298.55                 334.37        374.50         419.44             440.41
a. EAT (12% growth).        160.30         179.54       201.08                 225.21        252.24         282.50             296.63
b. Depreciation (12% growth).          48.00           53.76        60.21                   67.44          75.53           84.59               88.82
(a+b)        208.30         233.30       261.29                 292.65        327.76         367.10             385.45
Less:-Capital Expenditure (12% growth).          68.00           76.16        85.30                   95.54        107.00         119.84             125.83
Less:-Change in Working capital (WN)          83.00           29.16        32.66                   36.58          40.97           45.88               21.41
FCFF         57.30        127.98     143.33                160.53       179.80        201.37            238.21
Working Notes:-
2018 WC = 246 - 86 = 160
Current Assest - Current Liabilities =384 - 141
Working capital employed during the year 243 272.16       304.82                 341.40        382.37         428.25             449.66
Change in Working capital 83 29.16        32.66                   36.58          40.97           45.88               21.41
Present Value of FCFF
Year FCFF PV @ 14% Present value of cash flow
2019 57.3 1 57.3
2020 127.98 0.8772 112.26
2021 143.33 0.7695 110.29
2022 160.53 0.675 108.36
2023 179.80 0.5921 106.46
2024 201.37 0.5194 104.59
Present Value of FCFF 599.27
Terminal Cash flow
= FCFF / WACC - g
= 238.21
.102-.05                                                    = 4580.96
Present value of terminal cash flow =
= 4580.96 *    1     = 4580.96*.5193
                 (1.14)^6 2378.89
Value of the firm = 2379.35+599.27        = 2978.16
Less Value of Debt                                     = 169.00
Value of Equity 2809.16
No of shares given 96
Value per share = value of equity/no of shares 29.26

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Abbey Ansah, valued AVG company’s stock using the free cash flow to equity (FCFE) model. He...
Abbey Ansah, valued AVG company’s stock using the free cash flow to equity (FCFE) model. He believed that the company’s FCFE will grow at 20%. The required rate of return on equity is 25%. All figures are million dollars. Depreciation 30 Earnings per share 10 Dividend per share 2.15 Common shares outstanding (millions) 90.0 Additions to working capital 155 Capital expenditures 45 Using the data above calculate (a) the amount of FCFE per share for the company. (b) The value...
You are an analyst that has been requested to assess FCFF and FCFE in the recently...
You are an analyst that has been requested to assess FCFF and FCFE in the recently completed financial year ended 30 June 2016 in a company under review. You have been provided with the information below: $ thousands EBITDA 64,208 Depreciation 15,144 Net Interest Expense 5,550 Capital Expenditure net of proceeds on disposal 16,240 Increase in Net Operating Working Capital 1,190 New issues of unsecured notes (bonds) 10,440 Unsecured notes redeemed 7,642 Issues of new Ordinary Shares 13,910 Ordinary Share...
 Taylor Systems has just issued preferred stock. The stock has a 9 ​% annual dividend and...
 Taylor Systems has just issued preferred stock. The stock has a 9 ​% annual dividend and a $ 75 par value and was sold at ​$72.00 per share. In​ addition, flotation costs of ​$6.00 per share were paid. Calculate the cost of the preferred stock.
I. Tara Taylor has just been elected Mayor of Stars hollow. Although, Mayor Taylor is a...
I. Tara Taylor has just been elected Mayor of Stars hollow. Although, Mayor Taylor is a brilliant attorney she has limited knowledge of financial accounting and no knowledge of government accounting. She has contacted your accounting firm because she is perplexed about fund accounting, modified accrual accounting and the financial resources measurement focus. She has asked you to draft her a letter explaining the basics of fund accounting. Required: Draft a one to two page letter, explaining the basics of...
Do Pham is evaluating Phaneuf Accelerateur by using the FCFF and FCFE valuation approaches. Pham has...
Do Pham is evaluating Phaneuf Accelerateur by using the FCFF and FCFE valuation approaches. Pham has collected the following information (currency in euros): • Phaneuf has net income of €250 million, depreciation of €90 million, capital expenditures of €170 million, and an increase in working capital of €40 million. • Phaneuf will finance 40 percent of the increase in net fixed assets (capital expenditures less depreciation) and 40 percent of the increase in working capital with debt financing. • Interest...
Do Pham is evaluating Phaneuf Accelerateur by using the FCFF and FCFE valuation approaches. Pham has...
Do Pham is evaluating Phaneuf Accelerateur by using the FCFF and FCFE valuation approaches. Pham has collected the following information (currency in euros): • Phaneuf has net income of €250 million, depreciation of €90 million, capital expenditures of €170 million, and an increase in working capital of €40 million. • Phaneuf will finance 40 percent of the increase in net fixed assets (capital expenditures less depreciation) and 40 percent of the increase in working capital with debt financing. • Interest...
Question 1 Problem 1 - Using FCFE It is 12/31/15.  The following data have been accumulated from...
Question 1 Problem 1 - Using FCFE It is 12/31/15.  The following data have been accumulated from analysis of Frank Beamer Incorporated: 1 2 3 2016E 2017E 2018E Annual FCFE $         120,000 $      160,000 $          180,000 Given: 　 　 　 Net Debt $         500,000 Shares Outstanding             200,000 Stock Price per share $             15.00 Effective Tax Rate 30.0% WACC 8.0% Beta 1.10 Risk Free Rate 4.00% Equity Risk Premium 6.00% Terminal Growth Rate 5.0% 　 　 Calculate the Equity Value per Share for Frank Beamer Incorporated as of 12/31/15 using the Free...
Part III – Samson Taylor A 33-year-old entrepreneur, Samson Taylor, has not been feeling like himself...
Part III – Samson Taylor A 33-year-old entrepreneur, Samson Taylor, has not been feeling like himself lately. He has been feeling quite tired and his co-workers have commented on his droopy eyelids. Additionally, he is experiencing weakness in his arms and legs, has difficulty talking clearly and even clients and customers have been concerned that Samson hasn’t been looking very happy at work. One day at lunch, Samson started to choke on his food, causing one of his coworkers to...
Marcus has been using a spear and physics to determine how the refraction of light in...
Marcus has been using a spear and physics to determine how the refraction of light in water will change and how this will affect the fishing process.  If the producers of the show diabolically decide to provide marcus with a laser spear, will his fishing strategy change? What part of the fish should he aim at to amke a hit? Explain how the laster spear will act in comparison to the regular spear.  
Write a python program to calculate the value of sin(?) using its Taylor series expansion: sin(?)...
Write a python program to calculate the value of sin(?) using its Taylor series expansion: sin(?) = ? − ? 3 3! + ? 5 5! − ? 7 7! + ? 9 9! … The program should consist of the following functions: a) Develop and test a calcSin() function that receives as an argument, of type float, the value of the variable and returns the result as a float also. Include 20 terms maximum from the series, or until...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT