I used your mortgage calculator and entered in a loan of $100,000 at a 7% fixed interest for 30 years. It gave me a number of $139,508.90 after 30 years, that is the total interest paid over the life of the loan. This number does not make sense because 7% of $100,000 is only $7,000 and not $139,508.90. $139,508.90 is almost 140% of the original $100,000. Please explain your reasoning for this.
I look forward in hearing from you.
If you borrowed $100,000 from a lender with an agreement that at the end of 30 years you would repay the original loan amount plus 7%, then your total repayment would be $107,000. This is not how mortgage loans work, as mortgages utilize a nominal interest rate: the interest rate per year. The repayment process is far more complicated, and involves the concept of amortization.
When money is loaned for 30 years, the mortgage agreement requires the borrower to make 360 periodic (monthly) payments to the lender. The payments must remain the same each month and fully repay both the interest and principal during the life of the loan.
The quoted interest rate
of 7.00% per year is compounded 12 times a year, resulting in a monthly rate of 0.58% (which is computed by dividing the note rate by 12).
To calculate the interest due for a given month, the monthly rate is multiplied by the current loan balance. If you borrowed $100,000 at 7%, at the end of the first month your interest due would be $100,000 x (0.07 / 12).
The process of recalculating the interest and principal every month is called amortization.
To illustrate how each monthly payment is applied to your loan we need to construct an amortization table, reflecting each payment on it's own line. To build an actual amortization table on a 30-year fixed $100,000.00 loan at 7.00% we need to answer the following two questions:
1. How to compute the monthly payment for this loan?
2. How is the interest part calculated each month?
As soon as these questions are answered, the remaining part of each payment that goes monthly toward your loan balance is easily calculated by subtracting the interest part from the monthly payment.
We will derive the equation for the monthly payment PMT in the following manner: