PLEASE ANSWER IN EXCEL FORMAT, WITH FORMULA USED. Thank you!!

8.Consider the following three stocks:

Stock A is expected to provide a dividend of $11.10 a share forever.

Stock B is expected to pay a dividend of $6.10 next year. Thereafter, dividend growth is expected to be 5.00% a year forever.

Stock C is expected to pay a dividend of $4.90 next year. Thereafter, dividend growth is expected to be 21.00% a year for five years (i.e., years 2 through 6) and zero thereafter.

If the required rate of return for each stock is 11.00%, what is the stock price for each of the stocks?