Skip to main content

How to Calculate Your Monthly Mortgage Payment

The Basic Formula for Monthly Mortgage Payments

Your monthly mortgage payment comes from a formula that uses three numbers: the loan amount you borrowed, the interest rate your lender set, and how many months you have to pay it back. The formula is called an amortization calculation, and it produces a single number that covers both principal (the money you borrowed) and interest (the cost of borrowing it).

The formula itself is: M = P [ r(1 + r)^n ] / [ (1 + r)^n – 1 ], where M is your monthly payment, P is the principal loan amount, r is your monthly interest rate (annual rate divided by 12), and n is the total number of payments. You do not need to memorize this or do it by hand—a mortgage calculator or spreadsheet will do it for you—but understanding what goes into it helps you see why your payment is what it is.

Key Takeaways

  • Your monthly payment depends on three things: how much you borrowed, your interest rate, and how many years you have to repay it.
  • A higher interest rate or shorter loan term raises your monthly payment; a lower rate or longer term lowers it.
  • Your actual monthly payment also includes property taxes, homeowners insurance, and possibly mortgage insurance, which are not part of the base calculation.
  • You can calculate the base payment using a spreadsheet formula, a mortgage calculator, or by asking your lender for an amortization schedule.
  • The first payments are mostly interest; later payments are mostly principal, which is why paying extra early saves you the most money.

Breaking Down the Three Numbers You Need

The principal is the amount you actually borrowed. If you put 20 percent down on a $300,000 house, your principal is $240,000. This is the P in the formula.

The interest rate is what the lender charges you to borrow the money, expressed as a yearly percentage. A 6.5 percent rate means you pay 6.5 percent of the loan amount per year in interest. To use it in the formula, divide by 12 to get the monthly rate. A 6.5 percent annual rate becomes 0.065 ÷ 12 = 0.00542 as your monthly rate (r in the formula).

The loan term is how many years you have to pay it back. A 30-year mortgage means 360 monthly payments (30 × 12). A 15-year mortgage means 180 payments. This is n in the formula. A shorter term means higher monthly payments but less total interest paid over the life of the loan.

Using a Spreadsheet to Calculate Your Payment

If you have access to Excel, Google Sheets, or any spreadsheet program, you can calculate your monthly payment in seconds using the PMT function. The syntax is =PMT(rate, nper, pv), where rate is your monthly interest rate, nper is the number of payments, and pv is the loan amount (entered as a negative number).

For example, a $240,000 loan at 6.5 percent annual interest over 30 years would be entered as =PMT(0.065/12, 360, -240000). The result is approximately $1,520 per month. This covers only principal and interest, not taxes or insurance.

The spreadsheet approach is useful because you can change one number at a time and see how it affects your payment. Raise the interest rate to 7 percent and the payment jumps to about $1,596. Lower it to 6 percent and it drops to about $1,439. This lets you compare scenarios before you commit to a loan.

What a Mortgage Calculator Does (and Why It Matters)

An online mortgage calculator does the same math but saves you the spreadsheet step. You enter the loan amount, interest rate, and term, and it shows you the monthly payment instantly. Many calculators also let you add property taxes, homeowners insurance, and mortgage insurance (PMI) to see your full monthly housing cost, not just the principal and interest.

The difference between the base payment and the full payment can be substantial. A $240,000 loan at 6.5 percent over 30 years costs $1,520 in principal and interest, but if your property taxes are $200 a month, insurance is $150, and PMI is $300, your actual monthly payment is $2,170. Lenders often refer to this full amount as your PITI payment (Principal, Interest, Taxes, Insurance).

Free calculators are available from Bankrate, NerdWallet, and most major lenders' websites. They are useful for comparing offers before you apply, but your lender will give you the exact number once you are approved.

How Interest and Principal Split Over Time

One thing that surprises many borrowers is how much of your early payments go to interest rather than principal. On a $240,000 loan at 6.5 percent, your first payment of $1,520 includes about $1,300 in interest and only $220 in principal. By payment 180 (halfway through a 30-year loan), the split is roughly $800 interest and $720 principal. By the final payment, it is almost entirely principal.

This is why paying extra toward principal early in the loan saves you so much money. An extra $100 per month on a 30-year mortgage can cut years off the loan and save tens of thousands in interest. Your lender should allow you to make extra principal payments without penalty—ask about this before you sign.

You can see this breakdown in detail on an amortization schedule, which your lender will provide. It shows every payment, how much goes to interest, how much goes to principal, and your remaining balance after each payment. Many online calculators generate this schedule too.

Adjustable-Rate Mortgages and How They Change Your Payment

If you have an adjustable-rate mortgage (ARM), your interest rate is fixed for an initial period—often 3, 5, 7, or 10 years—and then adjusts annually or semi-annually based on a market index. Your monthly payment stays the same during the fixed period, but once the rate adjusts, your payment recalculates using the new rate.

For example, you might have a 5/1 ARM with a 5.5 percent rate for the first five years. Your payment is locked at $1,365 per month on a $240,000 loan. After five years, if the rate jumps to 7 percent, your new payment recalculates for the remaining 25 years and might rise to $1,595. This is why ARMs carry more risk than fixed-rate mortgages—your payment can increase significantly once the fixed period ends.

If you are considering an ARM, calculate what your payment would be at a higher rate (lenders often use a worst-case scenario) to make sure you can afford it if rates rise. Your lender should provide this information in the loan estimate.

Common Mistakes When Calculating Your Payment

The most common mistake is forgetting to include taxes, insurance, and PMI in your total monthly cost. The principal-and-interest number alone is not what you will actually pay each month. If you are comparing offers, always ask for the full PITI amount or calculate it yourself using local tax rates and insurance quotes.

Another mistake is using the wrong interest rate. Make sure you are using the rate from your loan estimate, not a national average. Rates vary by lender, credit score, down payment, and loan type. A 0.5 percent difference sounds small but adds up to thousands over 30 years.

A third mistake is assuming your payment never changes. On a fixed-rate mortgage, your principal-and-interest payment stays the same, but your property taxes and insurance can increase, so your total payment may rise. On an ARM, the entire payment can jump. Budget for this possibility.

Frequently Asked Questions

Does the down payment affect my monthly payment?

Yes, directly. A larger down payment lowers the principal you borrow, which lowers your monthly payment. A 20 percent down payment on a $300,000 house means you borrow $240,000; a 10 percent down payment means you borrow $270,000. The higher principal results in a higher monthly payment, plus you will also owe PMI until you reach 20 percent equity.

What is the difference between a 15-year and 30-year mortgage payment?

A 15-year mortgage has a higher monthly payment but costs far less in total interest. On a $240,000 loan at 6.5 percent, a 30-year payment is about $1,520 per month; a 15-year payment is about $1,975 per month. Over the life of the loan, the 30-year mortgage costs roughly $307,000 in interest, while the 15-year costs roughly $115,000 in interest.

Can I calculate my payment if I do not know my interest rate yet?

You can estimate using current market rates, but your actual rate depends on your credit score, down payment, loan type, and the lender. Use a calculator with a realistic rate estimate to get a ballpark figure, but wait for your loan estimate from the lender for the exact number. Rates change daily, so do not lock in a calculation from weeks earlier.

What happens to my payment if I refinance?

Refinancing replaces your old loan with a new one, so your payment recalculates based on the new principal (what you still owe), the new interest rate, and the new term you choose. You might refinance to a lower rate (lowering your payment), a shorter term (raising your payment but saving interest), or to cash out equity (raising your payment). Your lender will show you the new payment before you commit.

Should I use an online calculator or ask my lender?

Use both. An online calculator helps you compare scenarios and understand how changes affect your payment. Your lender's calculation is the official one and will appear on your loan estimate. The lender's number should match a calculator's number if you use the same inputs, so if they do not match, ask the lender why.