2. As a stock broker, you recommend stocks to your clients. After gathering data on Apex Products, Inc., you determined that its dividend has been growing at a rate of 4% per year to the current (Do) S1.25 per share. The stock is now selling for $30 per share, and you believe that an appropriate rate of return for this stock is 9.5% per year A. If you expect that the dividend will grow at a 4% rate into the foreseeable future, what is the highest price at which you would recommend purchasing this stock to your clients? B. Suppose now that you believe that the company's new product line will cause much higher growth in the near future. Your new estimate is for a three-year period of 12% annual growth to be followed by a return to the historical 4% growth rate. Under these new assumptions. what is the value using the two-stage dividend growth model? valued based on the one-stage and two-stage growth models. models for long-run growth rates from 0% to 10% in one-percentage-point increments C. Create an IF statement that shows whether the stock is undervalued, overvalued, or fairly D. Create a data table that shows the stock value using the one-stage and two-stage growth