You financed the purchase of a $300,000 apartment with a down payment in cash of 20% of the purchase price. The remaining 80% is financed with a mortgage with a 1% monthly interest rate over the next 20 years. The mortgage is repaid with equal monthly installments.

1. Compute the monthly installments on the mortgage. (5 points)

2. What is the outstanding principal balance of the mortgage after 5 years (i.e., after 60 installments)? (5 points)

3. Ten years later (after 120 installments), your bank manager offers to refinance your mortgage with a new loan carrying a 0.9% interest rate for a one- time commission. What is the maximal commission you would be willing to pay? Assume you pay the commission when you refinance. (Hint: Use Excel Solver. Find the EAR of the old and new mortgage.) (10 points)