Consider the "buy vs

Finance Nov 17, 2020

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? Briefly 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.