In a earlier report we presented a uncomplicated formula to calculate the quantity of a month-to-month household mortgage loan payment. The formula applies to any compound interest loan. The only specific gear you will need is a calculator with a energy function essential. That is the essential with the y superscript x (y ^ x). If you have little ones in college you in all probability currently have one.
Right here is a critique of month-to-month payment formula.
The variables are:
N = loan period in months. i.e. 20 years = 240 months.
R = interest price in complete numbers. i.e. eight% written as eight.
P = principal quantity of the loan. The quantity borrowed.
Q = the Q issue. An intermediate calculation.
M = month-to-month payment quantity
Right here's the complete formula for the month-to-month payment quantity of a compound interest loan:
M = (P * R * Q) / (1200 * (Q -1))
Uncomplicated sufficient, but initial you have to calculate the worth of Q. Right here is the formula:
Q = (1 + R/1200) ^N. Fairly straightforward, but you do will need the energy function crucial. N can get big.
In our prior instance we calculated a month-to-month payment of $418.22 on a $50,000 second mortgage at eight% for 20 years. You have paid the 2nd mortgage loan for 5 years (60 months). The pay off quantity is $43,763 (rounded). This is how to calculate the pay off quantity on any compound interest loan following N number of payments.
This is an straightforward 3 step procedure with a subtraction at the finish. Initial calculate the development worth of the loan quantity (P). P increases by a issue of (1 + R/1200) per month, so following N months the worth of the principal quantity of the loan would have inflated to P * (1 + R/1200) ^ N. For the current $50,000 second mortgage the calculation appears like this:
50000 * (1 +eight/1200) ^60 = 74492.28 (step one)
The month-to-month payments have also inflated by a element of (1 + R/1200) per month so in math speak we have a geometric series with n terms. The month-to-month payment component is a small much more complicated and the formula appears like this:
1200 * M * ((1 + R/1200) ^N -1) / R
Plug in the actual values and it appears like this:
1200 * 418.22 * (1 + eight/1200) ^60 / eight = 30729.49 (step two)
Now end up by subtracting the inflated repayment worth from the inflated loan quantity worth to get the pay off quantity:
74492.28 - 30729.49 = 43762.79 (pay-off)
As soon as you know how to calculate the month-to-month payment and pay-off quantity for any compound interest loan on the back of an envelope, you can noodle mortgage and vehicle loan what-ifs from anyplace.
No comments:
Post a Comment