Using the excel to answer the following problems:

King Fisher Aviation is expected to pay the following dividends over the next four years: $12.00 $5.00 $7.00 $3.00 Afterwards the company anticipates paying a constant 4%. If the required return on the stock is 15 percent, what is the current share price? Fill in the values in the spreadsheet. Input area: Dividend one Dividend two Dividend three Dividend four Dividend growth rate Required return 12.00 5.00 7.00 3.00 4% 15% Output area: Year 4 price Share price