excel formula please

Kay's Sewing Loft is going to reduce its annual dividend by 10 percent a year for the next two years. After that, it will maintain a constant dividend of $2 a share. Last year, the company paid an annual dividend of $3 per share. What is the market value of this stock if the required return is 13.7 percent? XYZ stock currently sells for $50 per share. The next expected annual dividend is $2, and the growth rate is 6%. What is the expected rate of return on this stock? If the required rate of return on this stock were 12%, what would the stock price be, and what would the dividend yield be? stock price