SHOW ALL THE WORK IN WRITING AND SHOW THE FORMULAS OF HOW YOU THE ANWER IN EXCEL

Homework: Please show your work in Microsoft Excel Question 1: You are making a personal investment and are looking to estimate the stock price for a private REIT. The REIT pays an annual dividend of $1.47 per share. The REIT does not anticipate increasing the dividend in the next 5 years. The growth rate for the company at 1.5%. Based on a 5-year Model, what is the stock price at the end of each year. The WACC for the company is 7.4%. Additionally, if you decide to purchase a share in the REIT, what would your IRR and NPV be for the investment