Excel Online structured Activity: Nonconstant growth Computech Corporation expanding rapidly and currently needs to ren all of its earnings hence, it does not pay dividends. However, investors with a dividend of $1.25 coming years from today. The dividend should grow rapidyart of 10 per year durres and butter a has been collected in the Microsoft Excel Online Nebelow. Open the spreadsheet and perform the requedan tower the question below Computachten t the d ed per the data 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 termediate calculations Year 3 Dividend, D Superormal growth rate, Normal growth rate, Required rebum.rs $125 18.00% 4.00% 15.00% 18.00% 18.00% No Dividends P. Cash flows to common stockholders jell PV of cash flows to common stockholders Stock Price, P. O Alternatively, using Excel NPV function: Stock Price. Po Formulas 18.00% 18.00% 4.00% Dividends o ON $12500 NA ANA Cash flows to common stockholders NA NA PV of cash flow to common stockholders Stock Price, Po Alternatively, using Excel NPV function: Stock Price. Po Nonconstant growth Year 3 DividendDe Supernormal growth tale, Normal growth Required returns $125 18.00% 400% 15.00% 18.00% 18.00 9 Odonds Tool- 11 Cash flows to common stockholders 13 PV of cash fows to common stockholders 14 Stock Price, P. O 16 Alfomatively, using Excel NPV function Stock Price. Po Formulas 18.00 Dividends $12500 ANA Cash flows to common sockholders PV of cash fows to common stockholders Stock Price, P Alternatively, using Excel NPV function: 0 ON $12500 NA NA 23 Dividends 24 PS 25 Cash flows to common stockholders . 27 PV of cash fows to common stockholders 28 Stock Price, P 29 30 Alternatively, using Excel NPV function 31 Stock Price, Po