C D E F G Design a spreadsheet similar to the one below to compute the value of a variable growth rate firm over a five-year horizon Nm 5 6 a. What is the value of the stock if the current dividend is $1.30, the first stage growth is 18 percent, the second stage growth is 9 percent, and the discount rate is 11 percent? b. What is the value of the stock if the current dividend is $1.30, the first stage is 2 percent, the second stage growth is 8 percent, and the discount rate is 9.5 percent? c. What is the value of the stock if the current dividend id $2.50, the first stage growth is 15 percent, the second stage growth is 7 percent, and the discount rate is 10 percent? 10 B C D E 14 Inputs Current dividend = First-stage dividend = Second-stage = Discount rate = $1.30 18.00% 900.00% 1100.00% 1 2 3 Year Projected dividend Terminal price = Pre sent value =