Can someone help me format excel to equal the future dividend payment. Thanks!

D 1 2 13 14 15 Stock Inputs Stock Price S53.00 Annual Rate 4.00% Required Retum 11.00 Future Dividend Payment Presenl Value One $0.00 Prescot Value Two 5001 Future Dividend Payment 50.00 Q2: Firm A is expected to pay equal dividends at the end of each of the next two years. Thereafter the dividend will grow at a constant annual rate of 4 percent, forever. The current stock price is $53. What is next year's dividend payment if the required rate of return is 11 percent? DIV. Div(1+g). Div(+8). Dlv;(1+8) DA 1+R (1+R) (1+R) (IR) R