using excel calculate it.

\begin{tabular}{|l|l|r|r|r|} \hline 29 & & \multicolumn{2}{|c|}{ THREE STAGE GROWTH MODEL } \\ \hline 30 & & & \\ \hline 31 & Recent Dividend Year (D0) & $1.25 & \\ \hline 32 & Required Rate of Return & 12% \\ \hline 33 & Growth Rate 1 & 8% & \\ \hline 34 & Growth Rate 2 & 4% & \\ \hline 35 & \# Years in Growth Rate 1 & 3 & \\ \hline 36 & Years Transitioning from G1 to G2 & 5 & \\ \hline 37 & Price (using Three Stage Model) & & \\ \hline \end{tabular}