hhuicPlease show me the excel formulas I need to use for these questions. Thanks!

B D E G H 1 J K L M N 1 1. A share of stock is expected to pay $1.00 in dividends next year and for all years after. If investors require an 8% return, what is the fair value of this stock? 2 3 4 5 2. A share of stock is expected to pay $1.00 in dividends next year. The dividend is expected to grow 6% per year thereafter. What is the fair value of this stock if the required return is 8%? 6 7 8 9 3. An investor is evaluating the purchase of a stock. She expects that she can sell the stock for $30 (P4) in 4 years and that the stock will pay the dividends as listed in the table below. If the investor requires a 10% return, 10 11 Dividend Year 1 12 0 13 2 14 3 $1.00 $1.50 $2.00 15 4 16 17 18 19 20 4. Company Y has an expected dividend of $2.00/share. Dividends are projected to grow by 10% per year. What is the implied required return if the stock is currently selling at $100/share? 21