Common stock value: Constant growth. Use the constant-growth dividend model (Gordon growth model) to find the value of each firm shown in the following table. Important Do not use cell references to cells in rows 6 to 10. For all required answers, use cell references to values atarting in rov 15 . Dividend expected next Dividend Required Firm year growth rate return {:[5,15],[10,14],[8,9]:} 8 (9)/(20) Solution Stock A Dividend expected next yea: Dividend growth rate Required return Stock value Stock B Dividend expected next yea Dividend growth rate Required return Stock value Stock C Dividend expected next yea Dividend growth rate Required return Stock value Stock D Dividend expected next yea Dividend growth rate Required return Stock value Stock E