3 This week please find the current price of each stock. I have provided you with the required return and the dividend information, Please fill in the blue highlighted cells with a formula that solves each situation. ABC Stock Dividend Information will pay dividends for the next 5 years. A different amount each year and then never again Year Dividend Amount 2 $35 3 $45 5 $70 $25 $55 7.0% Requred Return Current Price 0 1 2 13 14 15 16 17 58 39 20 23 02 23 24 GRW Stock Dividend Information Just Paid a $2 dividend and will growth the dividend at a rate of 5% forever Last Dividend $2 Dividend Growth Rate 596 10.0% Requred Return = Current Price = 28 27 28 PREF Stock Dividend Information A preferred Stock will pay a $12 dollar dividend in perpotuity Dividend Amount $12