please help

A B D E F G H 1 Red, Inc., Yellow Corp., and Blue Company each will pay a dividend of $2.65 next year. The 2 growth rate in dividends for all three companies is 5 percent. The required return for each company's stock is 8 percent, 11 percent, and 14 percent, respectively. What is the stock price for each company? 4 5 Dividend next year 2.65 6 Dividend growth rate 5% Red required return 8% 8 Yellow required return 11% 9 Blue required return 14% 10 11 12 Complete the following analysis. Do not hard code values in your calculations. 13 14 15 Red price 16 17 Yellow price 18 19 Blue price 20 21