PLEASE SHOW ME WITH EXCEL FORMULA.

Consider the following three stocks: a. Stock A is expected to provide a dividend of $12.2 a share forever. b. Stock B is expected to pay a dividend of $6.1 next year. Thereafter, dividend growth is expected to be 4% a year forever. c. Stock C is expected to pay a dividend of $6.1 next year. Thereafter, dividend growth is expected to be 20% a year for 5 years (i.e., years 2 through 6) and zero thereafter. a. If the market capitalization rate for each stock is 12%, which stock is the most valuable? Stock A Stock B Stock C b. If the market capitalization rate for each stock is 6%, which stock is the most valuable? Stock A Stock B Stock C