Please use excel to solve.The problem and the data provided must be clearly laid out in the spreadsheet and cell referencing must be used.

An investor buys 100 shares of a $40 stock that pays an annual cash dividend of $2 a share (a 5 percent dividend yield) and signs up for the dividend reinvestment plan. a) If neither the dividend nor the price changes, how many shares will the investor have at the end of ten years? How much will the position in the stock be worth? b) If the price of the stock rises by 6 percent annually but the dividend remains at $2 a share, how many shares are purchased each year for the next ten years? How much is the total position worth at the end of ten years? c) If the price of the stock rises by 6 percent annually but the dividend rises by only 3 percent annually, how many shares are purchased each year for the next ten years? How much is the total position worth at the end of ten years? Since divi- dend plans credit fractional shares, use three decimal places in parts (b) and (c)