Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

XYZ develops computer products for consumers. In June 2013, a team of analysts issued a research report that valued XYZ's stock at $7.89 per

image text in transcribed

XYZ develops computer products for consumers. In June 2013, a team of analysts issued a research report that valued XYZ's stock at $7.89 per share, compared to the then-current market price of $10. The research report's discounted cash flow valuation table is reproduced below. The 2013 figures are as reported by XYZ, but the 2014 through 2021 figures are analysts' forecasts. Key assumptions include a weighted average cost of capital of 13%, cost of equity 8% and a perpetual growth rate of 1%. All dollar amounts are in millions except share value. Actual 2013 2014 2015 2016 Analyst Forecast 2017 2018 2019 2020 2021 Total Revenues: 120 130 186.3 218.1 239.2 280.5 315.2 363.2 410.3 EBITDA 6 9 16 28 35 69 76.5 113.1 145.4 Capital expenditures -0.6 -1.9 -2.1 -2.4 -3.9 -6 -7.2 -9.3 -8.5 Cash taxes -1.8. -2 -3 -9.8 -2.9 -5.6 -6.6 -11.5 -15.1 Free cash flow 3.6 5.1 10.9 15.8 28.2 57.4 62.7 92.3 121.8 Discount factor: Present value Present value beyond 2021 Present value 2014-2021 0.69305 0.613319 0.884956 0.783147 4.513274 8.536299 10.95019 17.29559 31.15442 30.11597 39.2331 45.81627 0.54276 0.480319 0.425061 0.37616 385.6203 187.6151 Less net debt 573.2354 60.1 Equity value Shares ourstanding Share value Required: 513.1354 65 7.894391 1, Comment on how the analyst of XYZ calculate free cash flow compares with how the professional CFA might compute free cash flow directly from the company's financial statements. (4 marks) 2, What role does the 8% cost of equity play in the discounted cash flow valuation analysis? How about the role of cost of equity in the abnormal earnings valuation analysis? (2 mark) 3, Explain in detail to someone unfamiliar with present value calculations about how the Present value 2014-2021(i.e. $187.6151) is computed. (4 marks) 4, Explain in detail how the figure $385.6203 for Present value beyond 2021 is computed. (5 marks) 5, Why does the analyst team subtract an amount for net debt in arriving at Equity value? (Note: The term net debt is defined for spreadsheet purposes as financial liabilities (e.g., loans) minus any financial assets (e.g., money market investments)) (2 marks) 6, What share value estimate would the XYZ have calculated if they had used an abnormal earnings value approach rather than a discounted cash flow approach and had developed forecasts of abnormal earnings and book values that were consistent with the cash flow forecast in the above worksheet? Why? (3 marks) 7, Sometimes analysts' research reports contain inadvertent computational errors. What would the estimated value of XYZ's stock have been if the analysts mistakenly used 56 million shares outstanding rather than the correct 65 million share count? (2 marks) 8, If you were the analyst of XYZ in June 2013, what would be your investment recommendation advice to the investors of XYZ based on your discounted cash flow valuation analysis? (2 marks)

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

Human Resource Management

Authors: Wayne Dean Mondy, Judy Bandy Mondy

12th edition

978-0132553001

More Books

Students also viewed these Accounting questions