please show how to complete in Excel

a. The most recent annual dividend was $1.00 (DO). The dividend is expected to grow at a constant rate of 4%. The required return on the stock is 10%. Using the constant growth dividend discount model, what is the price of the stock today? (4) b. A stock's price is $50. The upcoming year's annual dividend is expected to be $2.00 (D1). The annual growth in dividends is 5%. What required (expected) return (discount rate, r) is being used by the market to value the stock? (4)