MUST BE ANSWERED USING EXCEL!!! I will happily up vote if the answer is detailed and ONLY IF IT IS DONE USING EXCEL!!!! Please explain if possible.

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