Using the original data from the spreadsheet in Q9, conduct…
Using the original data from the spreadsheet in Q9, conduct a similar calculation to determine the yearly rate of return, for the following scenarios:House Purchase Price increases by 5% above initial price, leave all other values unchanged.House Purchase Price increases by 10% above initial price, leave all other values unchanged.House Purchase Price increases by 15% above initial price, leave all other values unchanged.These calculations should give you 3 different yearly rates of return for scenarios 1 to 3 above, respectively. Compare the change between the return rates as follows:Submit your spreadsheet with the above calculations and comment on how the successive changes (successive increases of 5% in scenarios 1 to 3 above) in house purchase price affects the yearly rate of return using the results from the % change equation above.