Wheat Inc. has just paid its annual dividend of $$2\mathrm{.}00.$ The company is expected to pay the same $$2\mathrm{.}00$ dividend for years $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\mathrm{.}5\%$ indefinitely. The required rate of return on Wheat Inc. stock is $14\%.$

What is the expected dividend in year $5?$

What is the expected dividend in year $7?$

What is the expected value for the stock in year $7?$

What is the current value of one share of Wheat Inc. stocks today?

What is the expected price in year $15?$

Bonus:

Calculate the expected stock price today if the dividend is expected to cease after $15$ years. $($Year $15$ will be the last divided$)$

Highlight and label all your answers. please use excel only