Chapter $9-$ Master It$!$ Please fill table attached with excel

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 to fall by an equal amount each year. For

example, if the high growth period is $15$ percent for the next $5$ years and the dividends are expected to fall to a $5$ percent perpetual growth rate $5$ years later, the

dividend growth rate would decline by $2$ percent each year.

The Value Line Investment Survey provides information for investors. Below, you will find information for AbbVie found in the $2020$ edition of Value Line :

$2020$ dividend

$5-$year dividend growth rate

$

$4\mathrm{.}72$

$16\mathrm{.}5\%$

Although Value Line does not provide a perpetual growth rate or required return, we will assume they are:

Perpetual growth rate

Required return

$4\mathrm{.}0\%$

$11\mathrm{.}0\%$

$a.$

Assume that the perpetual growth rate begins $11$ years from now and use linear interpolation between the high growth rate and perpetual growth rate. Construct a

table that shows the dividend growth rate and dividend each year. What is the stock price at Year $10?$ What is the stock price today?

b$.$

How sensitive is the current stock price to changes in the perpetual growth rate? Graph the current stock price against the perpetual growth rate in $11$ years to find out.

Instead of applying the constant dividend growth model to find the stock price in the future, analysts will often combine the dividend discount method with multiple

Payout ratio

$45\%$

PE ratio at constant growth rate

Use the PE ratio to calculate the stock price when AbbVie reaches a perpetual growth rate in dividends. Now find the value of the stock today by finding the present

value of the dividends during the supernormal growth rate and the price you calculated using the PE ratio.

d$.$

How sensitive is the current stock price to changes in PE ratio when the stock reaches the perpetual growth rate? Graph the current stock price against the PE ratio in $11$

years to find out.