Please give a detailed answer in Excel with correct labels per each part and please provide formulas if they're required for a great rating. Thank you!

10. The constant-growth dividend discount model can be used both for the valuation of com- panies and for the estimation of the long term total return of a stock. Assume: $20 Price of a Stock Today 8% Expected Growth Rate of Dividends $0.60 Annual Dividend One Year Forward a. Using only the preceding data, compute the expected long-term total retum on the stock using the constant-growth dividend discount model. b. Briefly discuss three disadvantages of the constant-growth dividend discount model in its application to investment analysis. c. Identify three alternative methods to the dividend discount model for the valuation of companies