We are solving it over excel, can you please write with the formulas

Question 4 5] Calculate value of a stock which has just paid a dividend of S4. Assume that the required rate of return is 10% and the expected growth rate is 7%. bl 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. I