In: Finance
The mortgage on your house in Winnipeg is five years old. It required monthly payments of $1402, had an original term of 30 years, and had an interest rate of 9% (APR with semiannual compounding). In the intervening five years, interest rates have fallen, housing prices in the United States have fallen, and you have decided to retire to Florida. You have decided to sell your house in Winnipeg and use your equity for the down payment on a condo in Florida. You will roll over the outstanding balance on your old mortgage into a new mortgage in Florida. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.625% (APR with monthly compounding, which is typical for U.S. mortgages).
What monthly repayments will be required with the new loan?
If you still want to pay off the mortgage in 25 years, what monthly payment should you make on your new mortgage?
Suppose you are willing to continue making monthly payments of $1402. How long will it take you to pay off the new mortgage?
Suppose you are willing to continue making monthly payments of $1402, and you want to pay off the mortgage in 25 years. How much additional cash can you borrow today as part of the new financing?
** please show the complete work out/steps with formulas. No excel sheets.**