Mortgage Payment Math

How to Calculate Mortgage Payments: A Step-by-Step Guide

Understand the formula for monthly mortgage payments, work through examples, and factor in taxes, insurance, and PMI—no calculator required.

A simple calculator with a small piece of paper and a pen on a clean wooden desk, with a warm bokeh background of a home interior, symbolizing the math of mortgage payments.

Understanding the Mortgage Payment Components

A monthly mortgage payment is more than just repaying the loan amount. It typically includes four parts: principal, interest, taxes, and insurance—often abbreviated as PITI.

Principal is the amount you borrowed. Interest is the cost of borrowing that money, calculated as a percentage of the remaining balance each month. Property taxes are collected by your lender and paid to your local government, while homeowners insurance protects your home and is also escrowed by the lender. If your down payment is less than 20%, you may also pay private mortgage insurance (PMI).

Understanding these components helps you see why your payment can change over time, even with a fixed interest rate, as taxes and insurance premiums rise or fall.

  • Principal: the loan balance you’re repaying.
  • Interest: the fee the lender charges for borrowing.
  • Property taxes: annual tax divided into monthly escrow payments.
  • Homeowners insurance: monthly premium for hazard coverage.
  • PMI: required when your down payment is under 20%.

The Basic Formula: M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1 ]

The standard formula for calculating a fixed-rate mortgage payment is:

M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1 ]

In this formula, M is the monthly payment, P is the principal loan amount, i is the monthly interest rate (annual rate divided by 12), and n is the number of monthly payments (loan term in years multiplied by 12).

This formula gives you the principal and interest portion of your payment. It does not include taxes, insurance, or PMI, which you add separately.

Step-by-Step Example Calculation

Let’s calculate the monthly payment for a $300,000 loan at a 6% annual interest rate for 30 years.

First, convert the annual rate to a monthly rate: 6% ÷ 12 = 0.005 (or 0.5% per month).

Next, find the number of payments: 30 years × 12 = 360 payments.

Now plug the numbers into the formula: M = 300,000 × [0.005(1.005)^360] / [(1.005)^360 – 1].

Using a spreadsheet or a standard calculator, (1.005)^360 ≈ 6.0226. Then the payment is about $1,798.65 per month for principal and interest.

This example shows how the formula works with any loan amount, rate, and term.

  1. Determine the principal (P), annual interest rate, and loan term.
  2. Divide the annual rate by 12 to get the monthly rate (i).
  3. Multiply the loan term in years by 12 to get the number of payments (n).
  4. Calculate (1 + i)^n using a calculator or spreadsheet.
  5. Apply the formula: M = P × [i(1 + i)^n] / [(1 + i)^n – 1].

How to Factor in Property Taxes, Insurance, and PMI

Your total monthly payment often includes more than principal and interest. Lenders typically collect one-twelfth of your annual property tax bill and homeowners insurance premium each month and hold those funds in an escrow account.

PMI is required for many conventional loans if your down payment is less than 20% of the home’s purchase price. Government-backed or niche loans may have different mortgage insurance rules. PMI premiums vary by lender and loan details, but a common estimate is 0.5% to 1% of the loan amount per year. You can ask your lender for the exact PMI rate for your situation.

To get a full payment estimate, add the monthly escrow amounts and PMI to the principal-and-interest figure from the formula.

  • Property taxes: annual tax amount ÷ 12.
  • Homeowners insurance: annual premium ÷ 12.
  • PMI: annual premium ÷ 12, if applicable.
  • Total payment = principal + interest + taxes + insurance (+ PMI).

Comparison of Monthly Payments for Different Rates and Terms

The table below shows estimated principal-and-interest payments for a $300,000 loan at various interest rates and common terms. These figures use the formula above and exclude taxes, insurance, and PMI.

As the table shows, a lower interest rate reduces your monthly payment, while a shorter loan term increases it—but saves on total interest over time.

Estimated monthly principal and interest on a $300,000 fixed-rate mortgage
Interest Rate15-Year Term30-Year Term
5%$2,372$1,610
6%$2,531$1,799
7%$2,696$1,995

Using a Spreadsheet for Calculations

You can easily build your own mortgage payment calculator in a spreadsheet program. The key is to use the built-in payment function (often called PMT) rather than typing the full formula by hand.

In a spreadsheet, you can use the PMT function with either the annual rate and term in years or the monthly rate and total number of payments—just be consistent. For example, in Microsoft Excel or Google Sheets, if you enter the annual interest rate in cell A1 and the loan term in years in cell A2, the formula =PMT(A1/12, A2*12, -loan_amount) returns the monthly payment.

This approach lets you quickly test different rates, terms, and loan amounts. You can also add rows for taxes, insurance, and PMI to get a full monthly payment estimate.

Frequently asked questions

What is PMI and how does it affect my payment?

PMI stands for private mortgage insurance. It is required for many conventional loans when you make a down payment of less than 20%. PMI protects the lender if you default. It adds a monthly cost to your payment, typically 0.5% to 1% of the loan amount per year, divided by 12. For many conventional loans, you may request PMI cancellation when your loan-to-value ratio reaches 80%, and it often terminates automatically at 78%. Rules vary, so check your loan documents and lender.

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

On a $300,000, 30-year fixed-rate loan, a 1% increase from 5% to 6% raises the principal-and-interest payment from about $1,610 to $1,799—an increase of about $189 per month. A change from 6% to 7% raises it by about $196 per month. The exact effect depends on the loan amount and term.

What is amortization and how does it work?

Amortization is the process of paying off a loan with regular, equal payments over time. Each payment covers both interest and principal. Early in the loan, a larger portion goes toward interest; later, more goes toward principal. The formula M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1 ] calculates the fixed payment that amortizes the loan over n periods.

Can I calculate my payment without a calculation guide?

Yes, you can calculate it yourself using the formula on this page and a basic calculator or spreadsheet. Follow the step-by-step example in the section above to understand the process.