$3)$ Create a plot of the dividend growth over the sample period. Discuss factors for the company that is affecting the dividend growth rate. Research the firm and industry to identify these economic factors, do not simply give your opinion. $3)$ You will calculate the required rate of return for the stock using a market model regression. You must discuss this method in the report and comment on the statistical quality of your estimated discount rate. $4)$ You must create a formal table of the stock price you estimate. The table should include the value based on the estimated discount rate and the goal seek discount rate. Analyze the difference between the calculated discount rate and the fitted discount rate. You must also calculate the stock price based on the constant growth dividend discount model and discuss the financial implications of the methods. $5)$ Estimate the dividend discount model based on $75,50,$ and $35$ years rather than the $100$ years used in the base model. Create a formal table showing the four estimates' mean, median, and standard deviation. Discuss the financial implications of this analysis. In addition, find the average contribution to the stock's price for only the dividend in year $100.$ Include this value in your discussion. Use the calculated discount rate for this table. $6)$Create a formal table estimating the dividend discount model based on $75,50,$ and $35$ years using goal seek to fit the discount rate. The table should contain the fitted discount rate, the mean stock price and the standard deviation. Discuss the financial and economic implications of this table. $7)$ An economic and financial discussion of the cause of the results should accompany any required table or plot. Do not simply describe a plot as going up and down or state the values in the included table. $$Average $$4\mathrm{.}66$ Std $$$$32\mathrm{.}35$ Median $$2\mathrm{.}24$ Max $$424\mathrm{.}31$ Min $($$$530\mathrm{.}02)$ High Range $$$$37\mathrm{.}02$ Low Range $$$$(27\mathrm{.}69)$