I am trying to find the payment amount for an arm loan. This is a $200,000, five year interest only loan, with a 7% interest rate, amoritized for 30 years. THe payment for years 1-5 is interest only so it does not affect the principle. The payment for years 6 and 7 will be $1414, leaving a principle balance of $193,660. In year 8 the rate goes up by 5%. My example said the payment should be $2094, but I get $2069.
Here is my formula:
=PMT((B1+C1)/12,23*12,D1)
B1=7%
C1=5%
D1=$193660
Can anyone tell me where my error is?
Thanks!
Here is my formula:
=PMT((B1+C1)/12,23*12,D1)
B1=7%
C1=5%
D1=$193660
Can anyone tell me where my error is?
Thanks!