e Learning .htmldeploymentld-5902632365234278943577737914&SBN 9781337909636d-9945386928/snapshotid=20069308 M Connect login Log in to Canvas Scentsy Dashboard uncpe Ethicales For 6 Red Flags You NDTAP Q Search this COL y. Nonconstant growth 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. Howeves investors expect Computech to begin paying dividends, beginning with a dividend of $1.00 coming 3 years from today. The dividend should grow rapidly at a rate of 27% per year during Years 4 and 5; but after Year 5 growth should be a constant 4% per year. The data has been collected in tha Microsoft Excel Online Nebelow. Open the spreadsheet and perform the required analysis to answer the question below, Open spreadsheet If the required return on Computech is 12%, 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 Nerd Back 325 e o + 2 DELL POUD F12 Devet Insert N F9 F10 FB F6 Priser T F11 18 Lock TELE Excel Online Activity: Noncomstar X MindTap Cengage Learning Excel Online Student Work X aboutblank Apps M Gmail @ YouTube 9 Maps > New Tab M Connect login Log in to Canvas Scentsy Dashboard suncp email Ethical issues For 6 Red Flags Your HH Excel template - Saved le Home Insert Formulas Data Review View Help Tell me what you want to do X Arial - 10 23 B I > Actium- Paste U B A.A A $ - % 982 Conditional Format Formatting - table Insert Delete Format Styles Sort & Filter Opboard Font 00 4 Alignment Number bles Ce Eting fo B D E G Nonconstant growth H Year 3 Dividend D. Supernormal growth rate 5 Normal growth rate Required reum, 7 $100 27.00% 4.00% 1200% 27.00% 27.00% 400% 0 5 D $100 D Dividends 10 P 11 Cash flows to common stockholders 12 13 PV of cash flows to common stockholders 14 Stock Price PC 15 16 Alternatively using Excel NPV funcions 17 Stock Price, P. e Sheet + CAS Type here to search o Fuel Online Activity: Nocomarx * Mind lap Cengige arning Excel Online Student Work + e O about blank Hi! Apps M Gmai YouTube Maps 5 New Tab M Connect login Log Into Canvas Scently Dashboard un pema Ethical for FL 6 Red Flags You x Excel template Saved File Home Insert Formulas Data Review View Help Tell me what you want to do Anal - 10 29 X IN 3 Paste 1 B U Anson D " . A A HI S. % 928 Co Foming Fort G Tablet Insert Delete Format Sort Clear Clipboard Font Veda C14 Alamat NO cos 10 D F G G 27 00 400% 0 20 Formulas 21 22 23 Dividends 24 PM 25 Cash flows to common stockholders 2700% 4 NA $10000 5 WNA NA MNA 0 NA SNA NA WA SNA ONA 27 PV of cash flows to common stockholders 28 Stock Price. Po 30 Alternatively, using Excel NPV function 31 Stock Price. Po 33 33 34 38 37 Sheet1+ Calculation Mode Auto Type here to learch O DEL
