Using data from our fictitious Company, MT 217 (from attached sheet), we will calculate the expect value of its stock using the Constant Growth Model (attached): Po = D1/(r - g)
To do that we will have to estimate the vales of r, g, and D1.
To estimate the value of r we will use the Capital Asset Pricing Model:
CAPM = Rf + Beta(Rm - Rf)
Risk Free Rate = Rf = 3.5%
Market Return = Rm = 12%
Beta of BA 217 Corp. = .85
Question 1: Calculate "r".
Next we estimate the value of "g" using the average growth rate of past dividends.
Assume 6 years ago MT 217 paid a dividend of $1.20 and this year they paid a dividend of $1.55, using the Excel RATE formula calculate the average growth rate it took for the dividend to the current level in the period of time.
Question 2: Calculate "g".
Next we estimate the value of D1, the dividend next year as required by the Constant Growth Model.
D1 = Do(1 + g), where Do = the dividend today, $1.55
Question 3: Calculate "D1".
Using your solutions estimate the value of MT 217 Corporation's stock using the Constant Growth Model.
Po = D1/(r - g)
Question 4: Calculate the estimated value or Price Today of MT 217 = "Po".
Finally comment on this question. If the actual market value was BELOW your estimated value of MT217, and you were highly confident in your assumptions, what action might you take?© BrainMass Inc. brainmass.com December 20, 2018, 1:10 pm ad1c9bdddf
Estimating the growth rate of a fictitious company and its value.