please assist with resolving in excel
Based on the following data for the AAA stock, what is the implied growth rate? Assume that the stock is currently priced in equilibrium and that the dividend will grow at a constant rate. Last dividend per share: $5 Beta for the stock: 1.0 Risk free rate: 4% Market risk premium: 6% Current market price: $80
Select one: a. 4.62%
b. 4%
. 2.75%
d. 3.53%
e. 3%
Feedback The correct answer is: 3.53%
Required return on stock = Rf + [beta * (Rm - Rf)]
Ke = 4% + [1 * 6%]
Ke = 10%
Required return on stock = 10%
Growth rate (g) = Ke - [D0 * (1 + g) / P ]
g = 0.10 - [$5 *(1 + g) /$80
g = 0.10 - 0.0625*(1 + g)
g = 0.10 - 0.0625 - 0.0625g
1.0625 g = 0.0375
g = 0.0353
g = 3.53%
So, Growth rate = 3.53%
please assist with resolving in excel Based on the following data for the AAA stock, what...
Excel Online Structured Activity: Constant growth You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.75 a share at the end of the year (D = $2.75) and has a beta of 0.9. The risk-free rate is 4.9%, and the market risk premium is 5.5%. Justus currently sells for $40.00 a share, and its dividend is expected to grow at some constant rate, g. The data has been collected in the Microsoft...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.75 a share at the end of the year (D1 = $2.75) and has a beta of 0.9. The risk-free rate is 5.5%, and the market risk premium is 4.5%. Justus currently sells for $50.00 a share, and its dividend is expected to grow at some constant rate, g. The data has been collected in the Microsoft Excel Online file below. Open the...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.75 a share at the end of the year (D1 = $2.75) and has a beta of 0.9. The risk-free rate is 5.4%, and the market risk premium is 6%. Justus currently sells for $37.00 a share, and its dividend is expected to grow at some constant rate, g. Assuming the market is in equilibrium, what does the market believe will be the...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.75 a share at the end of the year (D1 = $2.75) and has a beta of 0.9. The risk-free rate is 4.4%, and the market risk premium is 6%. Justus currently sells for $41.00 a share, and its dividend is expected to grow at some constant rate, g. Assuming the market is in equilibrium, what does the market believe will be the...
You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.75 a share at the end of the year (D1 = $2.75) and has a beta of 0.9. The risk-free rate is 5.2%, and the market risk premium is 6.0%. Justus currently sells for $34.00 a share, and its dividend is expected to grow at some constant rate, g. Assuming the market is in equilibrium, what does the market believe will be the...
Excel Online Structured Activity: Constant growth You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $1.75 a share at the end of the year (D1 = $1.75) and has a beta of 0.9. The risk-free rate is 5.0%, and the market risk premium is 4.5%. Justus currently sells for $49.00 a share, and its dividend is expected to grow at some constant rate, g. The data has been collected in the Microsoft...
Video Excel Online Structured Activity: Constant growth You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.00 a share at the end of the year (0 - $2.00) and has a beta of 0.9. The risk-free rate is 2.5%, and the market nsk premium is 5.0%. Justus currently sells for $46.00 a share, and its dividend is expected to grow at some constant rate, 9. The data has been collected in the...
A stock is priced at $15.32 today, and analysts have a view that the stock will trade at $17.78 in one year. The stock will not pay a dividend. The current risk free rate in the economy is 5.00% while the market portfolio risk premium is 7.00%. If the stock is fairly priced, what is the implied beta for the stock?
Thanks in advance for any help! Excel Online Structured Activity: Constant growth You are considering an investment in Justus Corporation's stock, which is expected to pay a dividend of $2.00 a share at the end of the year (D1 = $2.00) and has a beta of 0.9. The risk- free rate is 5.0%, and the market risk premium is 5.5%. Justus currently sells for $46.00 a share, and its dividend is expected to grow at some constant rate, g. The...
It will be helpful if you can assist me with the following questions: If the market is in equilibrium, the market value of a common share should always equal its book value. True False All common shares in an equivalent risk class should be priced to offer the same expected return, if the market is in equilibrium. True False Williams Inc. is expected to pay a dividend of $4.10/share next year. Analysts believe that dividends will grow at a 6%...