Suppose that you are currently making monthly payments on a $200,000 30-year mortgage at 6% interest compounded monthly. For the last 7 years, you have been paying the regular monthly payments. You now have the option to refinance your current mortgage with a new 25year mortgage that has an interest rate of 5.9% compounded monthly. Note that the lender of the new loan has a closing cost fee of $1,300 (for title insurance, home appraisal costs, etc.) for the new (refinanced) mortgage. The lender stipulates that closing cost must be paid in cash and cannot be part of the new loan. You are to determine whether you would save or lose money, in interest, if you were to refinance your home. Take the closing costs into account when determining if you would save or lose money.

Answer rating: 100% (QA)

EFFECT Function EFFECT Function can be summarized as a calculative function in Excel that can tell u... View the full answer