Mel Thomas, the chief financial officer of Preston Resources, has been asked to do and evaluation of Dunning Chemical Company by the president and chair of the board, Sarah Reynolds. Preston Resources was planning a joint venture with Dunning (which was privately traded), and Sarah and Mel need a better feel for what Dunnings stock was worth because they might be interested in buying the firm in the future. Dunning Chemical paid a dividend at the end of the year one of $1.30, the anticipated growth rate was 10%, and the required rate of return was 14%. A) What is the value of stock based on the dividend valuation model? Use the following formula - P0 = D1 P0 = Price of stock today Ke-g D1 = Dividend at the end of the first year Ke = Required rate of return (discount rate) g = Constant growth rate in dividends B) Indicate the value you computed in p-art a is correct by showing the value of D1, D2, and D3 and by discounting each back to the present at 14%, D1 is 1.30, and it increases by 10%(g) each year. Also discount the anticipated stock price at the end of year back to the present and add it to the present value of the three dividend payments. The value of the stock at the end of year three is: D4= D3(1+g) P3 = D4 Ke-g If you have done all these steps correctly, you should get an answer approximately equal to the answer in part a. C) As an alternative measure, you also estimate the value of the firm based on the price-earnings (P/E) ratio times earnings per share. Since the company is privately traded (not in the public stock market), you will get your anticipated P/E ratio by taking the average value of five publicly traded chemical companies. The P/E ratios were as follows during the time period under analysis: P/E Ratio Dow Chemical.. 15 DuPont.. 18 Georgia Gulf.. 7 3M 19 Olin Corp 21 Assume Dunning Chemical has earnings per share of $2.10. What is the stock value based on the P/E ratio approach? Multiply the average P/E ratio you computed time earning per share. How does this value compare to the dividend valuation model values that you computed in parts a and b? D. If in computing the industry average P/E, you decide to weight Olin Corp. by 40% and the other four firms by 15%, what would be the new weighted average industry P/E? (Note: You decided to weight Olin Corp. more heavily because it is similar to Dunning Chemical.) What will the new stock price be? Earnings per share will stay at $2.10. E. By what percent will the stock price change as a result of using the weighted average industry P/E ratio in part d as opposed to that in part c?