how do i solve using excel formula

Red, Inc., Yellow Corp., and Blue Company each will pay a dividend of $2.65 next year. The 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? Dividend next year Dividend growth rate Red required return Yellow required return Blue required return 2.65 5% 8% 11% 14% Complete the following analysis. Do not hard code values in your calculations. Red price Yellow price Blue price ... Sheet1 ... + ADY 0 D -- 1