Peter Boston asked: In a previous article we presented a simple formula to calculate the amount of a monthly home mortgage loan payment. The formula applies to any compound interest loan. The only special equipment you need is a calculator with a power function key. That’s the key with the y superscript x (y ^ x). If you have kids in school you probably already have one.
Here is a review of monthly payment formula.
The variables are:
N = loan period in months. i.e. 20 years = 240 months.
R = interest rate in whole numbers. i.e. 8% written as 8.
P = principal amount of the loan. The amount borrowed.
Q = the Q factor. An intermediate calculation.
M = monthly payment amount
Here’s the entire formula for the monthly payment amount of a compound interest loan:
M = (P * R * Q) / (1200 * (Q -1))
Easy enough, but first you have to calculate the value of Q. Here is the formula:
Q = (1 + R/1200) ^N. Pretty simple, but you do need the power function key. N can get large.
In our earlier example we calculated a monthly payment of $418.22 on a $50,000 second mortgage at 8% for 20 years. You have paid the 2nd mortgage loan for 5 years (60 months). The pay off amount is $43,763 (rounded). This is how to calculate the pay off amount on any compound interest loan after N number of payments.
This is an easy three step process with a subtraction at the end. First calculate the growth value of the loan amount (P). P increases by a factor of (1 + R/1200) per month, so after N months the value of the principal amount of the loan would have inflated to P * (1 + R/1200) ^ N. For the current $50,000 second mortgage the calculation looks like this:
50000 * (1 +8/1200) ^60 = 74492.28 (step one)
The monthly payments have also inflated by a factor of (1 + R/1200) per month so in math talk we have a geometric series with n terms. The monthly payment part is a little more complicated and the formula looks like this:
1200 * M * ((1 + R/1200) ^N -1) / R
Plug in the actual values and it looks like this:
1200 * 418.22 * (1 + 8/1200) ^60 / 8 = 30729.49 (step two)
Now finish up by subtracting the inflated repayment value from the inflated loan amount value to get the pay off amount:
74492.28 – 30729.49 = 43762.79 (pay-off)
Once you know how to calculate the monthly payment and pay-off amount for any compound interest loan on the back of an envelope, you can noodle mortgage and car loan what-ifs from anywhere.
Mathew
