l need the process of this question in excel, thanks.

As a professional analyst you are responsible for valuing stocks. After gathering data on the Bluth Company you have estimated that its dividend has been growing at a rate of 6.5% per year. You also estimate that next year's dividend will be $7.54 per share. The stock is currently selling at $50.00 per share, and you believe that an appropriate discount rate is 11.5%. You expect that the dividend will continue to grow at 6.5% for the foreseeable future. What is the highest price you would recommend your clients pay to purchase this stock? Stock Price Next Dividend Growth Rate Required Return Valuation \ 50.00 \ 7.54 6.5% 11.5% Based on your valuation, would you say the stock is overvalued or undervalued? Overvalued or Undervalued? Suppose that after looking at the company more closely you decide that it is getting close to maturity, and you think that the dividend will only grow at 6.5% for 12 more years. After that, you think it will only grow at 3.5%. What is your new valuation? Stock Price Next Dividend Growth Rate 1 Growth Rate 2 Required Return Valuation 50.00 \ 7.54 6.5% 3.5% 11.5%