Mortgage Mechanics Breaking a Mortgage

Question #2 Imagine you have $100,000 and you want to use it as a down payment to buy a $500,000 house. You choose a $400,000 closed mortgage with a 5-year term and amortized over 25 years. This mortgage has a fixed interest rate of 3.6% (APR) compounded semi-annually and is paid back monthly. The penalty for breaking this mortgage is equal to three months interest on mortgages outstanding balance.

Part A: Compute your monthly payments. Part B: How much money do you owe (i.e., what is the outstanding balance) at the end of the term of the mortgage? Part C: Assume that the interest rate decreases to 3% (APR) compounded semi-annually after three years and it remains at this level forever. How much you should pay monthly if you decide to break the mortgage? Is it economical to break your mortgage and refinance it at the new rate? In case of breaking the mortgage, the penalty would be added to the principal and would be amortized over the amortization period. Please show all calculations and justify all the steps and conclusion.

PLEASE SHOW ALL WORKINGS/EXCEL