Show me how to make a spreadsheet similar to the one below to compute the value of a variable growth rate firm over a five-year horizon.(Round your answers to 2 decimal places.)

1. What is the value of the stock if the current dividend is $2.3, the first stage growth is 15%, the second stage growth is 8%, and the discount rate is 14%?

What is the value of the stock if the current dividend is $2.3, the first stage growth is 2%, the second stage growth is 8%, and the discount rate is 10.0%?

What is the value of the stock if the current dividend is $4.6, the first stage growth is 13%, the second stage growth is 7%, and the discount rate is 12%?