Question

14. # -/7.18 points TanFin11 5.3.048. My Notes Five years ago, Diane secured a bank loan of $340,000 to help finance the purchase of a loft in the San Francisco Bay area. The term of the mortgage was 30 years, and the interest rate was 6%/year compounded monthly on the unpaid balance. Because the interest rate for a conventional 30-year home mortgage has now dropped to 2.5%/year compounded monthly, Diane is thinking of refinancing her property. (Round your answers to the nearest cent.) (a) What is Diane's current monthly mortgage payment? (b) What is Diane's current outstanding principal? (c) If Diane decides to refinance her property by securing a 30-year home mortgage loan in the amount of the current outstanding principal at the prevailing interest rate of 2.5%/year compounded monthly, what will be her monthly mortgage payment? (d) How much less will Diane's monthly mortgage payment be if she refinances?

Answer 1

1.
=PMT(6%/12,12*30,-340000)
=$2,038.47

2.
=FV(6%/12,12*5,PMT(6%/12,12*30,-340000),-340000)
=$316,384.81

3.
=PMT(2.5%/12,12*25,-FV(6%/12,12*5,PMT(6%/12,12*30,-340000),-340000))
=$1,419.36

4.
=PMT(6%/12,12*30,-340000)-PMT(2.5%/12,12*25,-FV(6%/12,12*5,PMT(6%/12,12*30,-340000),-340000))
=619.1165694