PLEASE GIVE EXCEL FORMULAS FOR BOXES IN BOLD. I HAVE THE ANSWERS I ONLY NEED FORMULAS. The answers in red are to check work on the formulas.

Two-Stage Dividend Growth Model and H-Model 2 Please use following information and solve the Two-Stage Dividend Discount Model and H-Model Problem 3 Suppose a firm has a current dividend of D(0)=$2.00 which is expected to growth 25% a year for 3 years 4 and thereafter grow at the rate of 5 percent with a discount rate or required rate of return of 15 percent 1 Two-Stage Dividend Discount Model What is the value of the stock? P(0) $34.07$87.57 2 H-Model What is the value of the stock? \begin{tabular}{l|l|l|l|l|} \multicolumn{1}{l|}{ Growth Rate } & Year 1 & Year 2 & \multicolumn{1}{l|}{ Year 3 } & \multicolumn{1}{l|}{ Year 4 } \\ \cline { 2 - 5 } & & & & \\ \hline & & & & \\ \hline & & & & \end{tabular} Two-Stage Dividend Growth Model and H-Model 2 Please use following information and solve the Two-Stage Dividend Discount Model and H-Model Problem 3 Suppose a firm has a current dividend of D(0)=$2.00 which is expected to growth 25% a year for 3 years 4 and thereafter grow at the rate of 5 percent with a discount rate or required rate of return of 15 percent 1 Two-Stage Dividend Discount Model What is the value of the stock? P(0) $34.07$87.57 2 H-Model What is the value of the stock? \begin{tabular}{l|l|l|l|l|} \multicolumn{1}{l|}{ Growth Rate } & Year 1 & Year 2 & \multicolumn{1}{l|}{ Year 3 } & \multicolumn{1}{l|}{ Year 4 } \\ \cline { 2 - 5 } & & & & \\ \hline & & & & \\ \hline & & & & \end{tabular}