need help with finance hw please

Common stock value: Constant growth. Use the constant-growth dividend model (Gordon growth model) to find th 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 starting in row 15. Solution Stock B \begin{tabular}{l|r|} \hline Dividend expected next year & 4.00 \\ \hline Dividend growth rate & 5% \\ \hline Required return & 15% \\ \hline Stock value & \\ \cline { 2 } & \end{tabular} Stock D Stock E \begin{tabular}{l|r|} \hline Dividend expected next year & 2.25 \\ \cline { 2 } Dividend growth rate & 8% \\ \hline Required return & 20% \\ \hline Stock value & \\ \hline & \end{tabular} \begin{tabular}{l} \hline Requirements \\ \begin{tabular}{|l|l|l|} \hline 1 & In cell E18, by using cell references to the given data, calculate the value of stock A. & Points \\ \hline 2 & In cell E24, by using cell references to the given data, calculate the value of stock B. & 1 \\ \hline 3 & In cell E30, by using cell references to the given data, calculate the value of stock C. & 1 \\ \hline 4 & In cell E36, by using cell references to the given data, calculate the value of stock D. & 1 \\ \hline 5 & In cell E42, by using cell references to the given data, calculate the value of stock E. & 1 \\ \hline 6 & Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. & 0 \\ \hline \end{tabular} \end{tabular}