Excel Online Structured Activity: Nonconstant growth Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, does not pay dividends. However, investors expect Computech to begin paying dividends, beginning with a dividend of $1.25 coming 3 years from today. The dividend should grow rapidly - at a rate of 16% per year - during Years 4 and 5; but after Year 5, growth should be a constant 10% per year. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet If the required return on Computech is 16%, what is the value of the stock today? Round your answer to the nearest cent. Do not round your intermediate calculations. $ Check My Work Reset Problem B D E F G H 1 J A Nonconstant growth Year 3 Dividend, D, Supernormal growth rate, 9, Normal growth rate, 9, Required return, rs $1.25 16.00% 10.00% 16.00% 16.00% 4 16.00% 5 10.00% 6 0 2 0 3 $1.25 0 Dividends PS Cash flows to common stockholders 0 0 3 PV of cash flows to common stockholders Stock Price, P. Alternatively, using Excel NPV function: Stock Price, Po