70.2K

Verified Solution

Link Copied!

# 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. However, Investors expect Computech to begin paying dividends, beginning with a dividend of 80.75 coming 3 years from today. The dividend should grow rapidly at a rate of 44% per year during Years 4 and 5; but after year 5 growth should be a constant 9% per year. The data has been collected in the Microsoft Excel Online Alle below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet Ir the required return on computech is 244, what in the value of the stock today? Round your answer to the nearest cont. Do not round your intermediate calculations Check My Work Reset Problem Excel template Paused p Search Option Tie Home Drew Page Layout Tormos Data Review View Help ing Aral B $ O. C14 A Nonconstant growth C D G H 1 4400 400% 9.00% 3 Year Dividend D 50.75 4 Summal growth 4400 5 Normal growth 9.00% Required reum 1400W 2 3 0 9 Dividends 10 11 Cashflows to common this 12 1) Petcash flow to consider 14 Stock Price 15 16 Alamatively, using function 17 Stock Price 50275 10 20 21 22 Farms ON 4400% SEX 26P 25 Cash flow to con 440 5 WNA WA NA SNA NA SNA 27 of how to con 28 Stock > Naming Action 31 WNA WA WA

Answer & Explanation Solved by verified expert

See Answer