Please help fill in the colored areas. *Excel formulas please*

8 Nonconstant growth D Year 3 Dividend, Supernormal growth rate. Normal growth rate Required reum $0.75 48.00% 10.00% 14.00% 5 0 48.00 48.00% 10.00% 0 0 3 50.75 9 Oneidends 10 P 11 Cash Pows to common stockholders 12 13 PV of cash flows to common stockholders 14 Stock Price, P 15 16 Alternatively. Uning Excel NPV function 12 Stock Price, P. 1 19 20 Formulas 21 22 23. Dividends 24 P. 25 Cash flows to common stockholders 24 27 PV of cash flows to common stockholders 2 Stock Price 29 30 Alematively Using Excel NPV function 1 Stock Price P 0 48 DON 400 1000 0 50 7500 NA 0 INA NA NA UNA 0 0 NA UNA NA NA NA WA WNA NA SNA Sheet1 + Calculation Mode: Automatic Workbook Statistics 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 $0.75 coming 3 years from today. The dividend should grow rapidly - at a rate of 48% 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. Open spreadsheet If the required return on Computech is 14%, 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 8 Nonconstant growth D Year 3 Dividend, Supernormal growth rate. Normal growth rate Required reum $0.75 48.00% 10.00% 14.00% 5 0 48.00 48.00% 10.00% 0 0 3 50.75 9 Oneidends 10 P 11 Cash Pows to common stockholders 12 13 PV of cash flows to common stockholders 14 Stock Price, P 15 16 Alternatively. Uning Excel NPV function 12 Stock Price, P. 1 19 20 Formulas 21 22 23. Dividends 24 P. 25 Cash flows to common stockholders 24 27 PV of cash flows to common stockholders 2 Stock Price 29 30 Alematively Using Excel NPV function 1 Stock Price P 0 48 DON 400 1000 0 50 7500 NA 0 INA NA NA UNA 0 0 NA UNA NA NA NA WA WNA NA SNA Sheet1 + Calculation Mode: Automatic Workbook Statistics 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 $0.75 coming 3 years from today. The dividend should grow rapidly - at a rate of 48% 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. Open spreadsheet If the required return on Computech is 14%, 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