PLEASE POST THE EXCEL FORULUMAS AND SOLVE IN EXCEL!!!!!

Dividend Year S0.70 SI 20 SI 08 1. Historical dividends for four companies are given in the following table: Company 1 Company 2 Company 3 Company 4 2013 $0.60 $1.00 2014 $0,70 $0.77 $1.14 SI20 2015 $0.80 $0.85 $0.90 2016 $0.90 $0.93 S103 S1.10 2017 $1,00 S1.02 $0.98 $1.00 Required Return 10% 16% 12% 14% a) Calculate the compound average annual growth rate of the dividend for each company. If you expect the dividend to grow at that rate in the future, what is the price at which you would be willing to buy these companies' stocks? b) Calculate the arithmetic average annual growth rate of the dividend for each company. If you expect the dividend to grow at that rate in the future, what is the price at which you would be willing to buy these companies' stocks? c) Use the TREND function to calculate the dividend growth rate of each company. If you expect the dividend to grow at that rate in the future, what is the price at which you would be willing to buy these companies' stocks