Please do it on Excel

After that, you think dividends will grow at a constant 4% rate. a. Use the variable growth version of the dividend valuation model and a required return of 12% to find the value of the stock. at the price calculated in part b. Use the IRR approach to calculate the expected return on the stock over three years. Could you have guessed what the answer would be before doing the calculation? d. Suppose the stock's current market price is actually $30.45. Based on your analysis from part a, is the stock overvalued or undervalued? along with the stock's current market price from part d, calculate the return that your friend expects to earn on the stock over the next three years. a. Using the variable growth version of the dividend valuation model and a required return of 12%, the value of the stock is $. (Round to the nearest cent.)