Question 2 (Excel) Synovec Co. is growing quickly. Dividends are expected to grow at a rate...

Transcribed Image Text:

Question 2 (Excel) Synovec Co. is growing quickly. Dividends are expected to grow at a rate of 25 percent for the next two years, with the growth rate falling off to a constant 5 percent thereafter. The required return is 11 percent, and the company just paid a dividend of $2.00. a) Construct on an Excel sheet the first 300 dividend payments, and the present values in an adjoining column and use this to approximate the stock price. Question 2 (Excel) Synovec Co. is growing quickly. Dividends are expected to grow at a rate of 25 percent for the next two years, with the growth rate falling off to a constant 5 percent thereafter. The required return is 11 percent, and the company just paid a dividend of $2.00. a) Construct on an Excel sheet the first 300 dividend payments, and the present values in an adjoining column and use this to approximate the stock price.