Design a spreadsheet similar to the one below to compute the value of a variable growth rate firm over a five$-$year horizon.

What is the value of the stock if the current dividend is $$1\mathrm{.}3,$ the first$-$stage growth is $16\%,$ the second$-$stage growth is $8\%,$ and the discount rate is $15\%?$

What is the value of the stock if the current dividend is $$1\mathrm{.}3,$ the first$-$stage growth is $8\%,$ the second$-$stage growth is $14\%,$ and the discount rate is $16\mathrm{.}0\%?$

What is the value of the stock if the current dividend is $$2\mathrm{.}6,$ the first$-$stage growth is $14\%,$ the second$-$stage growth is $7\%,$ and the discount rate is $13\%?$