NBM common stock recently paid annual dividend in the amount of $$2\mathrm{.}25$ per share.

The analyst's estimate of the firm's growth forecast over the next $7$ years is $18\mathrm{.}00\%.$

You expect the firm to slow down in the long run and estimate the long$-$term growth

rate after $7$ years to be $6\mathrm{.}5\%.$ If the required rate of return on the stock is $11\%,$ what is

your estimate of the stock price? PROVIDE THE ANSWER ON EXCEL AND EXPLAIN step by step!