work in excel and show formulas please: Majestic Homes' stock traditionally provides $8\%$ rate of return. The company just paid a $$2$ annual dividend, which is expected to increase by $4\%$ per year. If you are planning on buying $1,000$ shares of this stock next year, how much should you expect to pay per share if the market rate of return for this type of security is $6\%$ at the time of your purchase?