Hello , can you please help me with this assignment. I have highlighted the table I am struggling with red. I am not sure how to calculate Estimated Sock Price in Table 2 according to ( Gordon Model also need explain this and also verify my number. Thank you so much!

In this step, you have been asked to visit a credible Web site that provides detailed information on publicly traded stocks and select 1 that has at least a 5-year history of paying dividends and 2 of its closest competitors.

"To fill up the first table, you will need to gather information needed to calculate the required rate of return for each of the 3 stocks (use the Capital Asset Pricing model). You will need to find the risk-free rate online. It is the 5-year Treasury rate.You will need the market return which is just the return on the S&P 500 Index, and it is available online. You should use an average over 5 years (find the historical yearly returns for the S&P 500 Index and average them). You must research your stocks to find the betas. You should be able to find them atfinance.yahoo.com."

5-year Risk- 5-Year Return Company Free Rate of Beta (B) of S&P 500 Required Rate of Return Index Return (CAPM) Johnson & Johnson | 0.85% 071 14.29% 10.39% Pfizer 0.85% .62 14.29% 9.18% Merck 0.85% .43 14.29% 6.63%Estimated Stock Price Gordon Projected Next Required Model) = Next Current Current Growth Rate of year's dividend Over/under Company year's Stock Dividend Rate of Priced Dividends Dividend Return (required rate Price (CAPM) of return projected growth rate of dividends Johnson & $4.04 2.53% $4.04 10.39% $159.60 Johnson Pfizer $1.56 2.84% $1.56 9.18% $34.94 Merck $2.60 5.76% $2.60 6.63% $74.60Estimated Estimated Current Over/Under Company Earning P/E Ratio Stock Price Stock Price Priced (next year) (P/E) Johnson& Johnson $9.51 28.98 $275.60 $159.60 Undervalued Pfizer $3.31 28.17 $95.03 #34.94 Undervalued Merck $6.56 26.82 $175.94 $74.60 Undervalued