The fixed monthly mortgage repayment calculation is based on the annuity formula and it is mathematically represented as Fixed Monthly Mortgage Repayment Calculation P r 1 rn 1 rn 1 where P Outstanding loan amount r Effective monthly interest rate n Total number of periods months. Our free mortgage calculator can help you estimate your monthly mortgage payments using various loan terms insurances and taxes. The loan payment formula is used to calculate the payments on a loan.
PMTC6 12 C7 - C5.
It also displays the corresponding amortization schedule and related curves. P is the principal amount of the loan. To calculate the number of payment periods for a loan given the loan amount the interest rate and a periodic payment amount you can use the NPER function. The next step is plugging numbers into this loan payment formula based on your loan type.