PLEASE SHOW ON EXCEL

NEED BONUS PLEASE

Wheat Inc. has just paid its annual dividends of $2.10. The company is expected to pay the same $2.10 dividend for year 1 and 2. After that dividends is expected to grow at an annual rate of 18% for the following 2 years, and at 12% for 3 years after that, then, starting in year 8 dividend is expected to grow at a constant rate of 5% indefinitely. Required rate of return on Wheat Inc. stock is 14%.

1. What is the expected dividend in year 5?
2. What is the expected dividend in year 7?

Bonus (1):

What is the expected price in year 15?