Suppose that a lender gives you a choice between the following two 25-year mortgages of $200,000: Mortgage
Question:
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
Finite Mathematics and Its Applications
ISBN: 978-0134768632
12th edition
Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair
Question Posted: