I have done a and b just dont know what formula to use for part c
NOTE: As of you have already solved part (a) and part (b) of the question, the solution provided is for part (c) only
(c) The stock is initially priced by assuming a perpetual growth rate of 5.5 %, expected dividend of $ 5.1 and Required Return of 14%. Norman Osborn wants to replace his dividends in such a way that the stock price remains unaffected.
Unaffected Stock Price = P0 = 5.1 / (0.14-0.055) = $ 60
The new dividends policy intends to pay a constant growth dividend for 15 years and no dividends afterwards.
Let the new constant growth rate be g%
Therefore, 60 = 5.1 x [1/(0.14-g)] x [1-{(1+g)/(1.14)}^(15)]
1.64706 - 11.7647 g = 1 - {(1+g)/(1.14)}^(15)
11.7647 g - 0.64706 = (1+g)^(15) / (1.14)^(15)
83.9757 g - 4.61867 = (1+g)^(15)
Using EXCEL's Goal Seek Function to solve the above equation we get:
g = 0.12151 or 12.151 % 12.15 %
I have done a and b just dont know what formula to use for part c...
Santa Klaus Toys just paid a dividend of $3.30 per share. The required return is 9.6 percent and the perpetual dividend growth rate is 4.2 percent. What price should this stock sell for five years from today?
I have the answers I
just don't know how to input the answers into a formula in the
excel solver so that it can accept my answers. Thank
you.
EXCEL 3: CHAPTER 7 x Get Homework Help With Che X → C newconnect.mheducation.com/flow/connect.html EXCEL 3: CHAPTER 7 A Saved Help Save & Exit Submit ? X - Sign In 05. Calculating stock price - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW * Calibri 111 SAA = %...
Chapter 7 - Master it! In practice, the use of the dividend discount model is refined from the method we presented in the textbook. Many analysts will estimate the dividend for the next 5 years and then estimate a perpetual growth rate at some point in the future, typically 10 years. Rather than have the dividend growth fall dramatically from the fast growth period to the perpetual growth period, linear interpolation is applied. That is, the dividend growth is projected...
Quantitative Problem 1: Hubbard Industries just paid a common dividend, Do, of $1.20. It expects to grow at a constant rate of 2% per year. If investors require a 10% return on equity, what is the current price of Hubbard's common stock? Do not round intermediate calculations. Round your answer to the nearest cent. per share Zero Growth Stocks: The constant growth model is sufficiently general to handle the case of a zero growth stock, where the dividend is expected...
1. A company is a fast growing technology company. The firm projects a rapid growth of 40 percent for the next two years and then a growth rate of 20 percent for the following two years. After that, the firm expects a constant-growth rate of 12 percent. The firm expects to pay its first dividend of $1.25 a year from now. If your required rate of return on such stocks is 20 percent, what is the current price of the...
Mailings Review View Strong Subeitie 9-3 Stock Price vs. Intrinsic Value The intrinsic value of a stock is $39/share. The market value is curently $40/share. Should an investor buy or sell the stock? 9-4 The Dividend Discount Model How can the price of a stock be estimated? 9-5 Constant Growth Stocks-Part 1 A dividend grows from $1 in year 1, to $1.02 in year 2, to $1.0404 in year 3, and is expected to continue the same rate of growth...
I know the answer but I wanted to know how to work the problem and the formulas. Thank you! ORcell Co. has the following dividend policy. Next year, the company will pay a dividend of $3. In year 2 the company will pay a dividend of $2.75. After year 2, the company expects to decrease its dividend at a constant rate of 3% per year indefinitely. If the return required by share holders is 13%, what is the price of...
Quantitative Problem 1: Hubbard Industries just paid a common dividend, Do, of $1.10. It expects to grow at a constant rate of 3% per year. If investors require a 12% return on equity, what is the current price of Hubbard's common stock? Do not round intermediate calculations. Round your answer to the nearest cent. per share Zero Growth Stocks: The constant growth model is sufficiently general to handle the case of a zero growth stock, where the dividend is expected...
Quantitative Problem 1: Hubbard Industries just paid a common dividend, Do, of $1.40. It expects to grow at a constant rate of 3% per year. If investors require a 8% return on equity, what is the current price of Hubbard's common stock? Do not round intermediate calculations. Round your answer to the nearest cent. per share Zero Growth Stocks: The constant growth model is sufficiently general to handle the case of a zero growth stock, where the dividend is expected...
Eastwood, Inc., has an unusual dividend policy. The company will pay a dividend of $7, $16, $13, and $2.75 for each of the next four years, respectively. Afterwards, the company has pledged to increase dividends by 5 percent per year indefinitely. If the required return on the company is 11 percent, how much should you pay for the stock today? Dividend in Year 1 $ 7.00 Dividend in Year 2 $ 16.00 Dividend in Year 3 $ 13.00 Dividend in...