In: Finance
Consider a typical Canadian mortgage for $750,000. Suppose that the current nominal interest rate is 12% and the maturity is set at 25 years. The rollover period is 3 years.
a) Please find the semi-annual payment on this mortgage.
b) Suppose the interest rates moves to 11% a day after the mortgage is issued. What is the market value of this mortgage?
c) Suppose the nominal interest rate moves to 14% 3 years from now. What will be the new semi-annual mortgage payments?
The following are the obtained results in spreadsheet:
The following are the data inputs in spreadsheet: