urgent! how to do it on excel please

3. Hindsight Bank just issued some new preferred stock. The issue will pay an annual dividend of $20 in perpetuity, beginning 20 years from now. If the market requires a return of 5.8 percent on this investment, how much does a share of preferred stock cost today? 4. FTJ Corporation is expected to pay the following dividends over the next four years: $12, 58, 57, and $2.50. Afterward, the company pledges to maintain a constant 5 percent growth rate in dividends forever. If the required return on the stock is 12 percent, what is the current share price