how would I solve this in excel?

i Manipulating the basic constant-growth dividend discount model What is the exected annual dividend for a stock currently selling for $ 51.00 that has 13.0% expected return and a 7.1% expected capital gain? Current price= $ 51.00 E(r= 13.0% Expected growth rate=g= 7.1% Expected annual dividendo 4.3% i Calculating the expected rate of return, assuming market efficiency What is the required rate of return for a firm whose stock price is $ 41.00 and whose expected annual dividend is $ 1.75 given a expected sustainable growth rate of Stock price: $ 41.00 Expected dividend= $ 1.75 Expected sustainable growth rate (g)= 4.3% Expected required rate of return=