Mortgage Payment Calculator
The fields highlighted in yellow are input fields. None of the other fields can be changed, unless you take the protection off first.
Alternative 1
Variables used in calculation of monthly payments: Amount of Loan: Yearly Effective Interest Rate Payment Periods (Months): Calculation of Loan Payment Amount of Loan: 60,000 Yearly Effective Interest Rate 7.00% 1.07 Payment Periods: 180 Monthly Compounded Interest Rate: 0.565415% 1.0057 Monthly Loan Payment: 532.11 Interest to be paid: 35,779.76
Alternative 2
Variables used in calculation of monthly payments: 60,000 7.00% 180 Yearly Effective Interest Rate
Calculation of Loan Payment Yearly Effective Interest Rate Monthly Compounded Interest Rate:
Difference in interest payments: (over Alternative 1) Calculation of Number of Payments Amount of Loan: 60,000 Annual Interest Rate: 7.00% Payment Periods: 180 Monthly Compounded Interest Rate: 0.565415% Monthly Loan Payment*: 532.11 Interest to be paid: 35,779.76 Calculation of Number of Payments
Monthly Compounded Interest Rate:
*The loan payment amount must be entered as a negative amount (prefaced by a minus sign). Difference in interest payments: (over Alternative 1)
Variables used in calculation of monthly Amount of Loan: Yearly Effective Interest Rate Payment Periods (Months): 60,000 7.00% 300
Calculation of Loan Payment Amount of Loan: 60,000 Yearly Effective Interest Rate 7.00% 1.07 Payment Periods: 300 Monthly Compounded Interest Rate: 0.565415% 1.0057 Monthly Loan Payment: 415.87 Interest to be paid: 64,761.89 Difference in interest payments: 28,982.13
Calculation of Number of Payments Amount of Loan: 60,000 Annual Interest Rate: 7.00% Payment Periods: 300 Monthly Compounded Interest Rate: 0.565415% Monthly Loan Payment*: 415.87 Interest to be paid: 64,761.89
gative amount (prefaced by a minus sign). Difference in interest payments: 28,982.13