Home Loans
How To Calculate Loan Payments and Amortization on the Back of an Envelope With a Cheap Calculator
(presented by www.refinance-refinance.net - mortgage lenders)
By Peter Boston
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:
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.
|
(c) 2006 Peter Boston is an attorney, writer, and the editor of the profacere.com website, a tips and resource site to refinance a second mortgage, get no fax payday loans, or improve your FICO credit score, updated daily on the profacere.com credit blog. |
===========================================
For additional Mortgage Refinancing information
and resources visit Mortgage Refinancing.
(http://www.refinance-refinance.net)
===========================================
Technorati Tags: mortgage refinance, refinance, home refinance, bad credit refinance, bad credit mortgage refinance, loan refinance, home loan mortgage refinance, mortgage refinance information, refinance mortgage, home equity loan, home equity loans, equity loans, debt consolidation, debt consolidation loans, debt consolidation loan, consolidation loans, credit card debt consolidation, credit card consolidation
