please write with formulas, i will solve it over excel

Question 4 a) Calculate value of a stock which has just paid a dividend of $4. Assume that the required rate of return is 10% and the expected growth rate is 7%. b) Consider 3 investors, investor A, B and C, which holds the stock for 1, 3 and 4 years respectively and then sell. Fill the below stated table to calculate the expected sale prices for years 1, 3 and 4: c) What holding period rate of return should each investor expects if they purchase this stock at the current price calculated in part a and sell from the expected price calculated in part b