Investors expect the following series of dividends from a particular common stock: Year 1 $0.95 Year 2 $1.03 Year 3 $1.18 Year 4 $1.24 Year 5 $1.32 After the 5th year, dividends will grow at a constant rate. If the required rate of return on the stock is 8% and the current market price is $47.86, what is the long-term rate of dividend growth expected by the market?

Done in excel