The Basic Formula for Your Monthly Payment

Your mortgage payment comes from a single formula that lenders use to spread your loan across the years you borrowed it for. The formula 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 total number of payments.

In plain terms: the lender takes your loan amount, adds interest spread across your payment months, and divides by how many months you have to pay. A larger loan or shorter payoff period raises your payment. A higher interest rate raises it further. The formula accounts for the fact that early payments cover more interest and later payments cover more principal.

You do not need to do this math yourself—a calculator does it in seconds—but understanding the pieces helps you see why your payment is what it is, and what changes it.

Key Takeaways

  • Your monthly payment depends on three things: the loan amount, the interest rate, and how many years you have to pay it back.
  • An online mortgage calculator or a spreadsheet formula will give you the exact payment in seconds; doing it by hand requires a scientific calculator and is error-prone.
  • Changing any one of the three inputs—borrowing less, getting a lower rate, or extending the loan term—changes your payment in a predictable way.
  • Your actual monthly bill may be higher than the payment itself because it often includes property taxes, insurance, and mortgage insurance, which the formula does not cover.

Using an Online Mortgage Calculator

The fastest way to find your payment is a mortgage calculator on a lender's website or a neutral site like Bankrate or the Consumer Financial Protection Bureau's calculator. You enter the loan amount, interest rate, and loan term (usually 15 or 30 years), and it shows your monthly payment instantly.

Most calculators also show you an amortization schedule—a month-by-month breakdown of how much of each payment goes to interest and how much goes to principal. This schedule is useful because it shows you that early payments are mostly interest, and later payments are mostly principal. It also shows your remaining balance after each payment.

If you are shopping for a mortgage, use the same calculator with different rates and terms to see how each choice affects your payment. A 0.5% difference in interest rate can change your monthly payment by $100 or more on a $300,000 loan.

Doing the Calculation in a Spreadsheet

If you want to avoid a website or need to run many scenarios at once, you can use a spreadsheet. Excel, Google Sheets, and most other spreadsheet programs have a built-in PMT function that does the mortgage formula for you.

The syntax is: =PMT(rate, nper, pv). The rate is your monthly interest rate (annual rate divided by 12), nper is the number of payments (years times 12), and pv is the loan amount as a negative number. For example, a $300,000 loan at 6.5% annual interest over 30 years would be: =PMT(0.065/12, 30*12, -300000). The result is your monthly payment before taxes and insurance.

Spreadsheets are useful if you want to build a full amortization table or test many scenarios side by side. You can also save your spreadsheet and update it as your situation changes.

What Changes Your Payment and by How Much

The three inputs to the formula work in opposite directions. Increasing the loan amount increases your payment proportionally—borrow twice as much, pay twice as much per month. Increasing the interest rate raises your payment, but not proportionally; a 1% higher rate on a $300,000 loan over 30 years raises your payment by roughly $200 per month. Increasing the loan term (stretching payments over more years) lowers your monthly payment but raises the total interest you pay over the life of the loan.

A common trade-off is between a 15-year and a 30-year mortgage. A 15-year mortgage has a higher monthly payment but you pay off the loan faster and pay much less total interest. A 30-year mortgage has a lower monthly payment but you pay interest for twice as long. Use a calculator to see both side by side with your actual numbers.

Interest rate changes have the biggest effect on affordability. If you are pre-approved at one rate and rates drop before closing, ask your lender whether you can lock in the lower rate. If rates rise, your payment rises with them unless you have already locked in a rate.

Understanding Principal, Interest, and the Amortization Schedule

Your monthly payment is split between principal (the amount borrowed) and interest (the lender's charge). Early in the loan, most of your payment goes to interest. Late in the loan, most goes to principal. This is why paying extra toward principal early in the loan saves you the most interest.

An amortization schedule shows this split for every payment. In month one of a $300,000 loan at 6.5% over 30 years, your payment might be roughly $1,896, with about $1,625 going to interest and $271 going to principal. By month 360 (the last payment), almost all of it goes to principal. The schedule also shows your remaining balance after each payment, which is useful if you plan to refinance or pay off the loan early.

You can request an amortization schedule from your lender, or generate one using a spreadsheet or calculator. Many lenders provide it automatically when you lock in a rate.

When Your Payment Includes More Than Just the Loan

The mortgage formula gives you the payment for the loan itself, but your actual monthly bill from the lender is often higher. Many mortgages include PITI—Principal, Interest, Taxes, and Insurance. Taxes are your property tax (divided by 12 and added to each payment), and Insurance includes homeowners insurance and, if you put down less than 20%, mortgage insurance (PMI).

Your lender can tell you the property tax rate in your area and the homeowners insurance cost for your specific property. Mortgage insurance depends on your down payment percentage and credit score; the lower your down payment, the higher your PMI. A calculator that includes PITI will show you the full monthly bill, not just the loan payment.

Property taxes and insurance can change over time, so your actual monthly payment may rise even if your loan payment stays the same. Ask your lender for an estimate of the full PITI payment before you commit to a mortgage.

Checking Your Lender's Math

When you receive a loan estimate from a lender, it includes a monthly payment figure. You can verify it using a calculator or spreadsheet with the loan amount, interest rate, and term shown on the estimate. If your calculated payment matches the lender's payment (before taxes and insurance), the math is correct.

If the numbers do not match, ask the lender to explain the difference. Sometimes the difference is because the lender included an extra fee, adjusted the rate, or rounded the term differently. Getting clarity now prevents surprises at closing.

Keep in mind that the interest rate on your estimate may be a preliminary rate that can change before closing. Once you lock in a rate, that number is fixed (unless you choose to float and rates move in your favor).

Frequently Asked Questions

What is the difference between a fixed-rate and adjustable-rate mortgage payment?

A fixed-rate mortgage has the same interest rate and payment for the entire loan term. An adjustable-rate mortgage (ARM) has a lower starting rate that increases after a set period, usually 3, 5, 7, or 10 years. Your payment stays the same during the fixed period, then rises when the rate adjusts. Use the starting rate to calculate your initial payment, but plan for the payment to increase later.

How much does a 1% difference in interest rate change my payment?

The exact change depends on your loan amount and term, but as a rough guide, a 1% increase on a $300,000 loan over 30 years raises your monthly payment by about $200. On a $500,000 loan, it raises the payment by about $330. Use a calculator with your actual numbers to see the precise impact.

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

Yes. Use the current market rate for your loan type as a placeholder. Check your lender's website or a rate comparison site to see what rates are being offered today. Your actual rate may be higher or lower depending on your credit score and down payment, but the placeholder gives you a realistic estimate to work with.

What happens to my payment if I make extra payments toward principal?

Extra payments reduce your remaining balance, which shortens the loan term and saves you interest, but they do not change your required monthly payment. Your lender will continue to expect the same payment each month. The extra payments simply pay off the loan faster. Check with your lender about whether there are any prepayment penalties before making extra payments.

Should I use an online calculator or a spreadsheet?

An online calculator is faster and requires no setup. A spreadsheet is better if you want to run many scenarios at once, build a full amortization table, or save your work for later. For a single quick calculation, use a calculator. For detailed planning, use a spreadsheet.