P i L 1 in 1 in - 1. -PMT 65 100 12 30 12 200000 65 100 12 200000 1 - 1 65 100 12 -30 12 126414. The PV argument is 180000 the present value of the loan.
In the formula because you are determining your monthly payment the length of the loan must be broken down to months.
Multiply the length of the loan in years by 12. In the formula because you are determining your monthly payment the length of the loan must be broken down to months. For these fixed loans use the formula below to calculate the payment. For a 30-year mortgage your formula should resemble.