Hello, can I please get a step by step solution using excel to this problem?? Thank you!

Consider four different stocks, all of which have a required return of 20 percent and a most recent dividend of $3.40 per share. Stocks W, X, and Y are expected to maintain constant growth rates in dividends for the foreseeable future of 10 percent, 0 percent, and -5 percent per year, respectively. Stock 2 is a growth stock that will increase its dividend by 20 percent for the next two years and then maintain a constant 12 percent growth rate thereafter. What is the dividend yield for each of these four stocks? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 3216J What is the expected capital gains yield for each of these four stocks? (Leave no cells blank - be certain to enter "0" wherever required. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)