1 Video 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. Howevet, 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 36% per year during Years 4 and 5; but after Year 5, growth should be a constant 5% 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 17%, what is the value of the stock today? Round your answer to the nearest cent. Do not round your intermediate calculations. $ D Norconstant growth Z 3 Year 3 Dividend, D 4 Superormal growth rate, 5 Normal growth rate, 6 Required retur, $125 36.00 5.00% 17.00% 5.00% 36.00% 36.00% 6 0 1 0 2 0 3 $1.25 9 Dividends 10 P 11 Cashflows to common stockholders 0 0 13 PV of cash flows to common stockholders 14 Shoo PoP 15 16 Ahmaveling Excel NPV tunction 17 Stock ProP 19 sxcel template Saved Home Insert Formulas Data Review View Help Tell me what you want to do cor 28 Currency Autosum ill X Arial 10 BIUR aste BALAA Clipboard Fort $ - % 9 % Insert Delete Format Clear IM Conditional Format Cell Formatting as Table Styles Tables Sort & Find & Filter - Select Editing Aliment Number Ceilis A B D E G H Stock Price, P Formus 36.00% 5.00% 0 2 0 3 $12500 4 MNA Dividends P Cash flows to common sockholders 36.00% 5 NA ANA WNA WNA 0 0 WNA 7 PV of cash flows to common stockholders 18 Stock Pro HNA UNA UNA MNA WNIA WNIA 30 Ahoratively, using Excel NPV function 31 Stock ProP 32 ANIA