Please review carefully the data in Data Table 1 below. These data are for actual mortgage products and rates offered by one of the largest banks in Canada on two different dates and were recorded in the morning of January 17, 2018 and February 11, 2018. Many questions in this assignment relate to the data in this table and also to the article Everyones Mortgage is About to Get More Expensive, published on Jan 17, 2018 in MacLeans and appeared on the Internet. The announcement of the rate increase by the Bank of Canada occurred in the afternoon of the same day

Mortgage Product	Date 1	Bank 1	Date 2	Bank 1
Prime Rate	17-Jan-18	3.20%	11-Feb-18	3.45%
Mortgage Prime Rat	17-Jan-18	3.35%	11-Feb-18	3.60%
1-year fixed closed	17-Jan-18	3.04%	11-Feb-18	3.04%
2-year fixed closed	17-Jan-18	3.24%	11-Feb-18	3.24%
3-year fixed closed	17-Jan-18	3.34%	11-Feb-18	3.34%
4-year fixed closed	17-Jan-18	3.89%	11-Feb-18	3.89%
5-year fixed closed	17-Jan-18	5.14%	11-Feb-18	5.14%
6-year fixed closed	17-Jan-18	5.14%	11-Feb-18	5.14%
7-year fixed closed	17-Jan-18	5.30%	11-Feb-18	5.30%
10-year fixed closed	17-Jan-18	6.10%	11-Feb-18	6.10%
Convertible 6 months	17-Jan-18	3.14%	11-Feb-18	3.14%
1-year fixed open	17-Jan-18	4.50%	11-Feb-18	4.50%
5-year variable closed	17-Jan-18	2.75%	11-Feb-18	2.95%
5-year variable open	17-Jan-18	4.35%	11-Feb-18	4.60%

2. What is the monthly mortgage payment for the 1-year fixed rate closed mortgage on January 17, 2018? The amortization period is 25 years and the mortgage amount to be loaned out is $750,000.

3. What is the monthly mortgage payment for the 1-year fixed rate closed mortgage on January 17, 2018? The amortization period is 20 years and the mortgage amount to be loaned out is $750,000.

4. What is the semi-annual mortgage payment for the 1-year fixed rate closed mortgage on January 17, 2018? The amortization period is 25 years and the mortgage amount to be loaned out is $750,000

5. Provide the amortization schedule in an Excel sheet format for the 1-year fixed rate closed mortgage for the first years, based on 25 years of amortization periodand $750,000 mortgage loan. You MUST show or describe sufficiently every detail of your computational work on each column of the amortization schedule.

6. Reconsider Question 2 and suppose that the interest rate for the 1-year fixed rate closed mortgage goes up to 4% at the end of the year (or the beginning of the second year). What is the monthly mortgage payment for the same 1-year fixed rate closed mortgage in the second year of the mortgage?

7. Provide the amortization schedule in an Excel sheet format for the same 1-year fixed rate closed mortgage above for the second year. You MUST show or describe sufficiently every detail of your computational work on each column of the amortization schedule

8. Consider a borrower who is contemplating either the 5-year variable open mortgage or the 5-year variable closed mortgage in the amount of $750,000 over the 25-year amortization periodon January 17, 2018. Compute the prepayment penalties as a percent of the mortgage amount.

9. On January 17, 2018, the interest rate difference is (i) 1.60% between the 5-year variable open and the 5-year variable closed contracts and (ii) 1.46% between the 1-year fixed closed and 1-year fixed open contracts. Both differences are supposed to capture the effect of the pre-payment penalties on the interest rates. One would expect a relatively constant premium for the prepayment penalties on the same day. Explain why the pre-payment premium is not constant on January 17, 2018.