please show all the answers in excel with all the formulas

Determine the price of a share of stock whose last annual dividend payment (0) was $2.50, assuming a 22 required rate of return of 10% and considering the following: 23 a) The dividend payment is expected to remain constant (i.e., g = 0) indefinitely. 24 lb) The dividend payment is expected to grow at a constant rate of 3% per year indefinitely 27 Last Dividend 28 Required rate of Return $2.50 10.00% 32 Dividend 33 Stock Price 38 889 8 NN 3.00% 36 Growth Rate 37 Dividend 38 Stock Price