(Solved) : Valuation And Discounted Cash Flows Mortgage Problem Finance Problem . . .

Question Description

Solve the problem using formulas or excel ( steps must be shown)

Mr. and Mrs. Spirit purchased a $35,000 house 20 years ago. They took a 30-yearmortgage for $30,000 at a 3% annual interest rate. Their bank, the First AmityvilleNational Bank, has recently offered the Spirits two alternatives by which theycould prepay their mortgage. The Spirits have just made their 20th annualpayment.

[A] Under the first alternative, the Spirits could prepay their mortgage at a 30% discountfrom the current principal outstanding. If current 10-year mortgage rates are 12%, should the Spiritsaccept the offer? Ignore taxes and assume payments are