Computational finance

1) . Perform a sensitivity analysis to model the effect of a change in interest rate on the monthly payment amount. Use a house value of $ 750 000 over 20 years with a deposit of $ 20 000 on the price of the house. Use interest rate values from 6% to 10% in increments of 0.5%. Use your sensitivity analysis table to answer the following questions.

i) Give the monthly payment amount corresponding to an interest rate of 8.5%.

ii) At what interest rate will the monthly payment amount be more than $ 6 000 ?