Suppose that a lender gives you a choice between the following two 25-year mortgages of $200,000: Mortgage

Question:

Suppose that a lender gives you a choice between the following two 25-year mortgages of $200,000:
Mortgage A: 6.5% interest compounded monthly, two points, monthly payment of $1350.41
Mortgage B: 7% interest compounded monthly, one point, monthly payment of $1413.56
Assume that you can invest money at 3.5% compounded monthly. The length of time that you must retain the mortgage in order for mortgage A to be the better choice is obtained in Excel by evaluating NPER(i, R, -P). What are the values of i, R, and P?
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Finite Mathematics and Its Applications

ISBN: 978-0134768632

12th edition

Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair

Question Posted: