Q Searches course line Activity: Nonconstant growth 0 x H Video Excel Online Structured Activity: Nonconstant growth Computech Corporation is expanding rapidly and currently need 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 $1.75 coming 3 years from today. The dividend should grow rapidyata rate of 17 per year during Years 4 and 5, but after year 5.growth should be a constant 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 Open spreadsheet If the required return on Computech is 15%, what the value of the stock today? Round your awer to the nearest cont. Do not round your intermediate calculations 5 7 8 9 4 1 p E R Y T F H K L D G V B N M * Search this cou apter 8 - Stock Valuation Homework ack to Assignment Attempts Keep the Highest: /10 7. Problem 3-08 (Constant Growth Rate) ebook Constant Growth Rate, A stock is trading a 540 per share. The stock is expected to have a year and dividend of $2 per share ( 0-52), and it is expected to grow at some constant rate throughout time. The stock's required rate of retum is 15% (assume the market is in equilibrium with the required retum equal to the expected return). What is your forecastor. Do not round intermediate calculations. Round the answer to two decimal places 9 Grade it Now Save & Continue Continue without saving 1 $ & 7 8 5 3 6 0 > O U Y w R E T G F H J K L D V X V M. B N k Command to Assignment empts Keep the Highest: /20 . Problem 8-12 (Nonconstant Growth Stock Valuation) elook Problem Walk Through Nonconstant Growth Stock Valuation Assume that the average firm in your company's industry is expected to grow at a constant rate of sand is dividend yields. Your company is about as risky as the average firm in the industry and just paid a dividend (D) of $1. You expect that the growth rate of dividends will be so during the first year (Ru: -50) and 20% during the second year (ou - 20%). After Year 2, dividend growth will be constant 7. What is the required rate of retum on your company's stock? What is the estimated value per share of your firm's stockel Do not round intermediate calculations. Round the monetary value to the nearest cent and percentage value to the nearest whole number PS Grade it Now Save & Continue Continue without saving 5 6 3 8 Y 1 T P 0 E R F G S J H D K L . A X V N 00 M 8 command