(8 points, 4+4) Consider the "buy vs- rent" Excel spreadsheet provided to you in tab A2. a. According to the assumptions made in that spreadsheet, should the average individual buy or rent? Briey explain. b. Using "Goal Seek" alter the "buy vs. rent" Excel spreadsheet so that it shows the minimum rate of price appreciation the homeowner must receive in order to be better off buying than renting. Highlight in yellow the cell that includes this price appreciation rate. (7 points, 4+3) Consider the levered DCP model provided to you in tab A3 of the Excel spreadsheet. a. Calculate the maximum price that an investors with the assumptions made in the model should be willing to pay for that property. Show this maximum price in cell C8. b. If you expect a general increase in the risk premium for real estate investments over the next 8 years, how would this affect the expected levered return on this propetty? Briey Explain