this is how far ive gotten but im not sure what to do next, can you please show me how to in excel :)

Common stock value-Variable growth Personal Finance Problem Home Place Hotels, Inc., is entering into a 3-year remodeling and expansion project. The construction will have a limiting effect on earnings during that time, but when it is complete, it should allow the company to enjoy much improved growth in earnings and dividends. Last year, the company paid a dividend of $2.70. It expects zero growth in the next year. In years 2 and 3,6% growth is expected, and in year 4,18% growth. In year 5 and thereafter, growth should be a constant 8% per year. What is the maximum price per share that an investor who requires a return of 18% should pay for Home Place Hotels common stock? The maximum price per share that an investor who requires a return of 18% should pay for Home Place Hotels common stock is $. (Round to the nearest cent.) A B C D \begin{tabular}{|c|l|l|l|l|} \hline 1 & YEAR & GROWTH & RATE OF RETURN & DIVIDEND \\ \hline 2 & & & & \\ \hline 3 & last year & & & 2.1 \\ \hline 4 & year 1 & & & =D3(1+B4) \\ \hline 5 & year 2 & 0.06 & 0.16 & =D4(1+B5) \\ \hline 6 & year 3 & 0.06 & 0.16 & =D5(1+B6) \\ \hline 7 & year 4 & 0.22 & 0.16 & =D(1+B7) \\ \hline 8 & year 5+ & 0.11 & 0.16 & =D7(1+B8) \\ \hline 9 & & & & \\ \hline 10 & & & price of stock & =D8/(C8B8) \\ \hline \end{tabular}