How to Calculate Housing Loan Interest
The two ways lenders calculate what you owe
Housing loan interest is calculated one of two ways: simple interest or amortization. Almost all mortgages use amortization, which means your monthly payment stays the same, but the split between principal and interest changes each month. Early payments are mostly interest; later payments are mostly principal. Understanding which method your loan uses and how to work through the math helps you see where your money goes and what happens if you pay extra.
The calculation depends on three numbers: your loan amount (the principal), your interest rate, and your loan term in months. A fourth number—how much you have already paid down—matters if you are calculating mid-loan.
Key Takeaways
- Most mortgages use amortization, which means each monthly payment is the same, but the portion going to interest versus principal shifts over time.
- To find the monthly payment, you need the loan amount, annual interest rate, and number of months; the formula is M = P[r(1+r)^n]/[(1+r)^n-1], where r is the monthly rate.
- The interest portion of any single payment is calculated by multiplying your remaining balance by the monthly interest rate.
- You can verify your lender's math using an amortization table or spreadsheet, or by checking your loan documents for the payment schedule.
- Paying extra toward principal reduces the total interest you pay and shortens the loan term, but only if your loan has no prepayment penalty.
How to calculate your monthly payment
The standard formula for a fixed-rate mortgage payment is:
M = P[r(1+r)^n] / [(1+r)^n - 1]
Where:
- M = monthly payment
- P = principal (the amount you borrowed)
- r = monthly interest rate (annual rate divided by 12)
- n = total number of monthly payments
Example: You borrow $300,000 at 6.5% annual interest over 30 years. Your monthly rate is 6.5% ÷ 12 = 0.00542 (or 0.542%). Your total payments are 30 × 12 = 360. Plugging into the formula gives a monthly payment of approximately $1,896.
You do not need to do this by hand. Your lender provides the payment amount in your loan documents. A spreadsheet (Excel, Google Sheets) or an online calculator will do the work if you want to test different scenarios—a higher down payment, a shorter term, a different rate.
Breaking down each monthly payment into interest and principal
Once you know your monthly payment, you can see how much of each payment goes to interest versus principal. The interest portion is always calculated first, on the remaining balance.
Interest for the month = remaining balance × monthly interest rate
The rest of your payment goes to principal. Example: After one year of payments on the $300,000 loan above, your remaining balance is roughly $293,000. The monthly rate is still 0.00542. Interest for that month is $293,000 × 0.00542 = $1,588. Your payment is $1,896, so $1,896 − $1,588 = $308 goes to principal. As you pay down the balance, the interest portion shrinks and the principal portion grows.
Your lender sends you an annual statement (Form 1098) showing total interest paid that year. You can also request an amortization schedule—a month-by-month table showing the payment, interest, principal, and remaining balance for every month of the loan. Many lenders provide this at closing or on their website.
What changes with adjustable-rate mortgages
An adjustable-rate mortgage (ARM) has an interest rate that changes after an initial fixed period. During the fixed period, you calculate interest the same way as above. When the rate adjusts, your lender recalculates your monthly payment using the new rate and the remaining balance and remaining term.
The adjustment date, the new rate, and how often it can change are all spelled out in your loan documents. Some ARMs cap how much the rate can rise per adjustment period or over the life of the loan. If your ARM is adjusting soon, your lender is required to tell you the new rate and new payment at least 30 days in advance. At that point, you can recalculate using the same formula with the new rate plugged in.
How extra payments reduce interest and shorten your loan
If you pay more than your monthly payment, the extra goes directly to principal (assuming your loan has no prepayment penalty—check your documents). Reducing the principal balance means less interest accrues in future months.
Example: On the $300,000 loan, if you pay an extra $200 per month toward principal, you reduce the balance faster. Over the life of the loan, you pay thousands less in interest and finish the loan years earlier. A spreadsheet or amortization calculator can show you the exact savings if you enter the extra payment amount.
Before making extra payments, confirm your loan documents do not include a prepayment penalty—a fee charged if you pay off the loan early. Most conventional mortgages do not have one, but some older loans or loans with lower rates do. Your lender can tell you in one call.
Using a spreadsheet to verify your lender's numbers
You can build a simple amortization table in Excel or Google Sheets to check your lender's math or to model different scenarios. Set up columns for: payment number, payment amount, interest paid, principal paid, and remaining balance.
Row 1 (month 1): Interest = starting balance × monthly rate. Principal = payment − interest. New balance = starting balance − principal. Row 2 (month 2): Use the new balance from row 1 to calculate interest, and repeat. Copy the formula down for all 360 months (or however many your loan term is). The final balance should be zero (or within a few cents due to rounding).
If your numbers match your lender's amortization schedule, you understand how the calculation works. If they do not, ask your lender to explain the difference—it usually comes down to how they handle the first or last payment, or rounding.
Interest calculations for loans with different terms
A 15-year mortgage has 180 payments instead of 360. The monthly payment is higher, but you pay far less total interest because the loan is shorter and the balance drops faster. A 20-year or 25-year loan falls between the two.
The formula is the same; only n (the number of payments) changes. A $300,000 loan at 6.5% over 15 years has a monthly payment of roughly $2,380—about $480 more per month than the 30-year version. But over the life of the loan, you pay roughly $130,000 less in interest. Your lender can show you the payment and total interest for any term you are considering.
Frequently Asked Questions
Why does my first payment have so much interest and so little principal?
Interest is calculated on the full remaining balance each month. In month one, that balance is the entire loan amount, so interest is at its highest. As you pay down principal, the balance shrinks, and interest shrinks with it. This is how amortization works—it is not a mistake.
Can I calculate interest on a loan that is already halfway through?
Yes. You need the remaining balance (from your latest statement), the interest rate, and the number of months left. Plug those into the same formula. Your lender can tell you all three numbers if you call and ask.
What if my interest rate is variable or changes mid-loan?
For the fixed-rate period, use the fixed rate in the formula. When the rate changes, your lender recalculates the payment using the new rate, remaining balance, and remaining term. The calculation method stays the same; only the rate number changes.
Does paying biweekly instead of monthly save interest?
Yes, but only slightly. Biweekly payments mean you make 26 payments per year instead of 12, so you pay down principal faster and accrue less interest over time. The savings are real but modest—usually a few thousand dollars over the life of a 30-year loan. Check with your lender first; some charge a fee to set up biweekly payments, which can erase the savings.
How do I know if my lender made a calculation error?
Request your amortization schedule and build your own in a spreadsheet using the formula above. If your numbers match, the lender is correct. If they do not, compare line by line to find where they differ. Most differences are rounding; actual errors are rare but do happen. Your lender must explain any discrepancy in writing.