You are looking to buy a $500,000 house and you need to get a good deal on a mortgage. You are considering a 15 year 2.50%, zero points, $2,400 property tax and $800 Insurance per year rate. You will put 20% down. What will be your monthly payment?

Q9: What if your friend were offered the same deal in question 8, but they had to pay 2 points, what would be the comparative interest rate on that mortgage? Hint: Use TVM calculator, you are solving for i, but your friend gets 2 percent less of a mortgage because they have to pay the points. However, they still have to make the same payments as you (tax and insurance are not part of the equation).

Answer rating: 100% (QA)

Monthly payment using PMT function in excel is PMT308002 N1512180mo... View the full answer