please show using excel

B eBook General Cereal common stock dividends have been growing at an annual rate of 8 percent per year over the past 10 years. Current dividends are $1.8 per share. What is the current value of a share of this stock to an investor who requires a 13 percent rate of retum ir the following conditions exist? Round your answers to the nearest cent. a. Dividends are expected to continue growing at the historic rate for the foreseeable future. b. The dividend growth rate is expected to increase to 9 percent per year. c. The dividend growth rate is expected to decrease to 7 percent per year. $