Excel Online Structured Activity: Nonconstant growth Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it does not pay dividends. However, investors expect Computech to begin paying dividends, beginning with a dividend of $1.50 coming 3 years from today. The dividend should grow rapidly - at a rate of 29% per year during Years 4 and 5, out after Year 5, growth should be a constant 7% 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 15%, 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 Excel template- Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Automate Help Editing Arial 10 Bvv Av Currency C14 A B C D 1 Nonconstant growth 00 0 2 3 Year 3 Dividend, D $1.50 4 Supemormal growth rate, g 29.00% 5 Normal growth rate, g 6 Required retum, r 7.00% 15.00% 7 29.00% 29.00% 7.00% B 0 2 9 Dividends 3 $1.50 0 10 Ps 11 Cash flows to common stockholders 12 13 PV of cash flows to common stockholders 14 Stock Price, P 15 15 Alteratively, using Excel NPV function 17 Stock Price, P 18 20 21 22 Formulas 29.00% 29.00% 7.00% 0 23 Dividends 24 P 25 Cash flows to common stockholders $1.5000 NIA N/A B N/A NIA 0 0 NA NA NA 26 27 PV of cash flows to common stockholders 20 Stock Price, P NIA N/A NA NA SNA N/A 29 30 Alteratively, using Excel NPV function 31 Stock Price, P NIA 32 35 BSheett Waiting for fs microsoft.com Loading