Skip to main content

How to Calculate Your Mortgage Interest Rate

What a mortgage interest rate calculation actually shows you

A mortgage interest rate calculation tells you how much of each payment goes toward interest rather than principal, and how that split changes over time. The rate itself—the percentage your lender charges—is set when you lock in your loan. What you can calculate is how that rate translates into actual dollars, how much total interest you'll pay over the life of the loan, and how the interest portion of your monthly payment shrinks as you pay down the balance.

The math is straightforward once you know three numbers: your loan amount, your interest rate, and your loan term in months. A calculator handles the heavy lifting, but understanding the formula behind it helps you spot errors and compare offers from different lenders with confidence.

Key Takeaways

  • Your interest rate is set by your lender; what you calculate is how that rate becomes a monthly payment and total interest cost.
  • You need your loan amount, annual interest rate, and loan term in months to run any calculation.
  • An amortization schedule shows you exactly how much interest and principal you pay each month, and how the split changes over time.
  • Comparing the total interest paid across different rate offers reveals the real cost difference between a 6.5% loan and a 7% loan.
  • Online mortgage calculators are free and accurate; a spreadsheet formula works too if you prefer to build it yourself.

The three numbers you need before you start

Loan amount is the total you're borrowing—your home price minus your down payment. If you're buying a $300,000 house with 20% down, your loan amount is $240,000.

Annual interest rate is the percentage your lender quoted. This is not the APR (annual percentage rate), which includes fees; it's the rate alone. If your lender said 6.5%, that's your number.

Loan term in months is how long you have to repay. A 30-year mortgage is 360 months. A 15-year mortgage is 180 months. Some loans run 20 years (240 months) or other lengths—check your loan documents.

Write these down or have them open in front of you. A single digit wrong will throw off every number that follows.

How to calculate your monthly payment

The formula for a fixed-rate mortgage payment is:

M = P × [r(1 + r)^n] / [(1 + r)^n − 1]

Where M is your monthly payment, P is the loan amount, r is your monthly interest rate (annual rate divided by 12), and n is the number of months.

Example: $240,000 loan at 6.5% annual interest over 30 years. Your monthly rate is 6.5% ÷ 12 = 0.00542 (or 0.065 ÷ 12 in decimal form). Your number of months is 360. Plugging in: M = 240,000 × [0.00542(1.00542)^360] / [(1.00542)^360 − 1]. The result is roughly $1,520 per month in principal and interest (not including property tax, insurance, or HOA fees).

This is where a calculator saves time. Mortgage calculators on Bankrate, NerdWallet, or your lender's website do this math instantly. You enter the loan amount, rate, and term, and it returns your monthly payment. No need to do the exponents by hand.

Breaking down each payment into interest and principal

Your monthly payment stays the same, but the split between interest and principal changes every month. Early payments are mostly interest; later payments are mostly principal.

To find how much interest you pay in month one: multiply your remaining loan balance by your monthly interest rate. On a $240,000 loan at 6.5%, that's $240,000 × 0.00542 = $1,301 in interest. If your total payment is $1,520, then $219 goes to principal.

Next month, your balance is $240,000 − $219 = $239,781. Interest on that is $239,781 × 0.00542 = $1,299. Now $221 goes to principal. The interest drops by $2, and principal rises by $2. This repeats for 360 months.

Calculating this by hand for every month is tedious. An amortization schedule does it for you. Most lenders provide one with your loan estimate. Online calculators also generate amortization schedules—enter your numbers and download or print the full month-by-month breakdown.

Finding your total interest cost

Multiply your monthly payment by the number of months, then subtract the original loan amount. On the $240,000 example: $1,520 × 360 = $547,200 total paid. Minus $240,000 borrowed = $307,200 in total interest over 30 years.

This number matters when you're comparing offers. A 7% rate on the same loan might give you a $1,596 monthly payment. Over 360 months, that's $574,560 total paid, or $334,560 in interest. The difference is $27,360 more in interest for a 0.5% higher rate. Seeing that gap in dollars—not just percentages—often changes how you think about refinancing or shopping for a better rate.

If you're comparing a 30-year loan to a 15-year loan at the same rate, the 15-year version will have a higher monthly payment but far less total interest. A $240,000 loan at 6.5% over 15 years costs roughly $1,859 per month and $334,620 total paid—meaning only $94,620 in interest instead of $307,200. The trade-off is a higher monthly bill.

Using a spreadsheet if you want to build it yourself

Excel, Google Sheets, and other spreadsheet programs have a built-in PMT function that calculates your monthly payment in one line. In Google Sheets, the syntax is =PMT(rate, nper, pv). Your rate is the monthly interest rate (annual rate ÷ 12), nper is the number of months, and pv is the loan amount as a negative number.

Example: =PMT(0.065/12, 360, -240000) returns your monthly payment. The negative sign tells the sheet you're borrowing money, not depositing it.

To build an amortization schedule, create columns for month, beginning balance, payment, interest, principal, and ending balance. Month 1 beginning balance is your loan amount. Interest is beginning balance × monthly rate. Principal is payment − interest. Ending balance is beginning balance − principal. Then copy that row down for all 360 months, and each row pulls the ending balance from the row above as its beginning balance.

This takes 15 minutes to set up the first time, and then you can change the loan amount, rate, or term and watch all the numbers recalculate instantly. It's a useful tool if you're running multiple scenarios.

Why your actual payment might differ from the calculation

Your mortgage payment includes principal and interest, but your actual monthly bill from your lender usually includes more. Property taxes, homeowners insurance, and mortgage insurance (if your down payment was less than 20%) are often rolled into one payment. Some lenders also collect a portion of your annual property taxes and insurance each month and hold it in an escrow account, paying the bills when they're due.

The interest rate calculation covers only the interest and principal portion. Ask your lender for a loan estimate, which breaks down the total monthly payment into each component. That way you know exactly what the interest rate calculation covers and what else you're paying.

Frequently Asked Questions

Is the interest rate the same as the APR?

No. The interest rate is the percentage charged on your loan balance. The APR includes the interest rate plus lender fees, closing costs, and other charges, expressed as an annual rate. The APR is always higher than the interest rate and is the number you should use when comparing offers from different lenders.

Can I calculate interest if my rate changes during the loan?

Not with the simple formula above—that assumes a fixed rate for the entire term. Adjustable-rate mortgages (ARMs) have a fixed rate for a set period, then adjust annually or semi-annually. You can calculate the fixed-rate portion, but the rest depends on what future rates will be, which you can't know. Your lender can show you worst-case scenarios, but the actual payment will change when the rate adjusts.

What if I make extra principal payments?

Extra payments reduce your balance faster, which means less interest accrues in future months and you pay off the loan earlier. The calculation changes month to month as your balance drops. An amortization schedule assumes regular payments only; if you're planning to pay extra, ask your lender how that affects your payoff date and total interest, or use a calculator that lets you enter extra payment amounts.

How do I know if my lender's calculation is correct?

Run the numbers yourself using a free online calculator or a spreadsheet. If your monthly payment matches what the lender quoted, the math is right. Check the loan estimate your lender provides—it shows the interest rate, loan amount, term, and calculated monthly payment. If those three inputs match yours, the payment should match too.

Does a lower interest rate always mean lower total interest?

Yes, if the loan term stays the same. A lower rate means a lower monthly payment and less total interest paid. But if you extend the term to lower the monthly payment, you might pay more total interest even at a lower rate. Compare total interest costs across different scenarios, not just monthly payments.