?- Stock Valuation and Required Return - Excel Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri Paste B r u.ER.??. Alignment Number Conditional Format as Cell Cells Editing Formatting Table. Styles Clipboard Font 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? s Dividend next year 265 Dividend growth rate Red required return Yellow required returr Blue required return 10 Complete the following analysis. Do not hard code values in your calculations. s Red price 17 Yellow price 19 Blue price 16 Sheeti ?? + 100% Attempt(s) 5814