show all the work in handwriting and also show formulas and work in microsoft excel step by step

Question 2: You are looking at another private REIT. The REIT pays an annual dividend of $1.06. The REIT is doing very well and has said it intends to increase the amount of the annual dividend by 1% every year. Based on a 5-year Model, what is the stock price at the end of each year. The WACC for the company is 6.4%. Additionally, if you decide to purchase a share in the REIT, what would your IRR and NPV be for the investment