Finance

Mortgage Payment Calculator

Your monthly mortgage payment is principal and interest plus, usually, property tax and homeowners insurance (PITI), and sometimes PMI and HOA dues. A $320,000 loan at 6.5% over 30 years has a principal-and-interest payment of $2,022.62; with $400 a month of tax and $150 of insurance, the total is $2,572.62.

$
Enter as
%

Use the rate from your lender’s quote or Loan Estimate. The figures above are examples only.

$
$
% of loan
$
$

Total monthly payment

—

—

Principal & interestTax & insurancePMI & HOA

Principal & interest
—
Property tax
—
Homeowners insurance
—
PMI
—
HOA dues
—
Loan amount
—
Total interest over the loan
—
Payoff time
—
Interest saved by extra payments
—

Your down payment is under 20%. Conventional loans usually require PMI in this case. Ask your lender for the PMI rate and enter it above.

Amortization schedule (principal & interest)

What goes into a monthly mortgage payment

Most lenders talk about the monthly payment as PITI: principal, interest, taxes and insurance. The Consumer Financial Protection Bureau describes these as the four basic elements of a mortgage payment. Depending on your loan and your home, you may also pay:

  • Private mortgage insurance (PMI), usually on conventional loans with less than 20% down.
  • Homeowners association (HOA) dues, if the property is in a community with an association. These are normally paid to the HOA, not the lender, but they are still part of your monthly housing cost.

This calculator adds all of these together so the number you see is closer to what actually leaves your bank account each month, not just the principal-and-interest figure many quick calculators show.

How to use the calculator

  1. Home price and down payment. Enter the down payment as a percentage or a dollar amount. The calculator works out the loan amount for you.
  2. Interest rate and loan term. Use the rate on your lender’s quote or Loan Estimate. Pre-filled values are examples, not current market rates.
  3. Property tax and home insurance per year. Your local tax assessor’s website or the property listing usually shows the current tax bill; an insurance agent can quote the premium.
  4. PMI rate, if your down payment is under 20%. Your lender will tell you the annual rate as a percentage of the loan.
  5. HOA dues per month, if any, and an optional extra principal payment.

The mortgage payment formula

The principal-and-interest part is calculated with the standard amortization formula used for fixed-rate loans:

M = P × r ÷ (1 − (1 + r)−n) P = loan amount (home price − down payment) r = annual interest rate ÷ 100 ÷ 12 n = loan term in years × 12 Total monthly payment = M + (annual property tax ÷ 12) + (annual insurance ÷ 12) + (loan × PMI rate ÷ 12) + HOA dues

Worked example: a $400,000 home with 20% down

  • Down payment: 20% of $400,000 = $80,000, so the loan is $320,000.
  • Rate 6.5%: r = 6.5 ÷ 100 ÷ 12 ≈ 0.0054167. Term 30 years: n = 360.
  • Principal and interest: $2,022.62 a month.
  • Property tax: $4,800 ÷ 12 = $400. Insurance: $1,800 ÷ 12 = $150.
  • No PMI (20% down) and no HOA.

Total monthly payment: $2,022.62 + $400 + $150 = $2,572.62. Over 30 years the loan costs $408,142.36 in interest, more than the amount borrowed.

Why early payments are mostly interest

In the first month of the example, interest is $320,000 × 0.0054167 ≈ $1,733.33, so only about $289.28 of the $2,022.62 payment reduces the balance. Across the whole first year, you pay $20,694.69 of interest and just $3,576.72 of principal. The split slowly reverses as the balance falls. Open the amortization schedule above the article to see the exact numbers for your loan, year by year or month by month.

15-year vs 30-year mortgage

$320,000 at 6.5%Principal & interestTotal interest
30-year term$2,022.62$408,142.36
15-year term$2,787.54$181,757.84

At the same rate, the 15-year loan costs about $765 more a month but saves more than $226,000 in interest. Lenders often offer shorter terms at lower rates, so compare real quotes for both terms before you decide.

The effect of paying extra principal

Paying even a small amount extra each month shortens the loan and reduces interest, because each extra dollar stops collecting interest for the rest of the term. In the example, adding $100 a month pays the mortgage off in 314 months (26 years 2 months) instead of 360, and saves $61,698.47 in interest. Confirm with your servicer that extra payments go to principal and that your loan has no prepayment penalty.

Bi-weekly mortgage payments

With a bi-weekly plan you pay half your monthly payment every two weeks. A year has 52 weeks, so that is 26 half-payments, the same as 13 full monthly payments instead of 12. The extra payment goes to principal.

You can model this with the extra principal field: enter one-twelfth of your principal-and-interest payment. In the example that is $2,022.62 ÷ 12 ≈ $168.55 a month, which pays the loan off in about 290 months (24 years 2 months) and saves about $93,073 in interest. Before signing up for a bi-weekly program, check that your servicer applies each payment to principal straight away and does not charge a setup fee.

How to calculate a mortgage payment in Excel

Excel and Google Sheets have a built-in payment function that uses the same formula as this calculator:

=PMT(annual rate / 12, number of months, −loan amount) =PMT(6.5%/12, 360, -320000) → 2,022.62

The loan amount is entered as a negative number so that the payment comes out positive. PMT returns principal and interest only; add property tax, insurance, PMI and HOA dues in separate cells to get the full monthly payment.

Using it as a refinance mortgage payment calculator

To estimate a new payment after refinancing, enter your current loan balance (plus any closing costs you will roll into the new loan) as the home price, set the down payment to 0, and use the new rate and term. Compare the new principal-and-interest payment and total interest with your current loan. Keep in mind that restarting a 30-year term can lower the payment while increasing the total interest you pay.

About PMI

The CFPB explains that you might have to buy private mortgage insurance on a conventional loan when your down payment is less than 20% of the purchase price. PMI protects the lender if you stop paying; it does not protect you. It is usually paid as a monthly premium added to your mortgage payment, and it can often be cancelled once you have built up enough equity. FHA and other government-backed loans have their own mortgage insurance rules, so ask your lender which applies to you.

Limits of this estimate

  • It assumes a fixed interest rate for the whole term. Adjustable-rate mortgages can change after the initial period.
  • Property tax and insurance usually change over time; the calculator uses today’s figures for every month.
  • Closing costs, points and lender fees are not included in the monthly payment.
  • PMI is shown as a constant monthly cost and is not automatically removed as you build equity.

Not sure whether to buy at all? The rent vs buy calculator compares the long-term cost of owning with renting and investing the difference.

For other borrowing, such as a car or personal loan, try the loan calculator. Planning renovations after you move in? The square footage calculator helps you measure rooms for flooring and paint.

Frequently asked questions

How do I calculate a mortgage payment?

Work out the principal-and-interest part with the formula M = P × r ÷ (1 − (1 + r)−n), where P is the loan amount, r is the annual rate ÷ 12 and n is the number of months. Then add one-twelfth of your yearly property tax and homeowners insurance, plus any monthly PMI and HOA dues. For a $320,000 loan at 6.5% over 30 years, M is $2,022.62.

How do you calculate a mortgage loan payment in Excel?

Use the PMT function: =PMT(annual rate/12, years*12, -loan amount). For a $320,000 loan at 6.5% for 30 years, =PMT(6.5%/12, 360, -320000) returns $2,022.62, the same principal-and-interest payment this calculator shows. Add taxes, insurance, PMI and HOA dues separately.

Do bi-weekly mortgage payments save money?

Paying half your monthly payment every two weeks adds up to 26 half-payments, or 13 full payments, a year. That extra payment goes to principal. On a $320,000 loan at 6.5% for 30 years, it is roughly like adding $168.55 a month, which pays the loan off in about 24 years 2 months and saves about $93,073 in interest. Check that your servicer applies the payments to principal and does not charge a fee for the plan.

What does PITI mean?

PITI stands for principal, interest, taxes and insurance, the four basic parts of a monthly mortgage payment. Taxes and insurance are often collected by the lender through an escrow account and paid on your behalf.

When do I have to pay PMI?

According to the Consumer Financial Protection Bureau, private mortgage insurance is usually required on a conventional loan when your down payment is less than 20% of the purchase price. It protects the lender, not you, and can often be removed once you build enough equity. Ask your lender for your PMI rate and enter it in the calculator.

Is a 15-year or 30-year mortgage better?

A 15-year mortgage has a higher monthly payment but far less total interest. On a $320,000 loan at 6.5%, the 15-year payment is $2,787.54 against $2,022.62 for 30 years, but total interest falls from $408,142.36 to $181,757.84. In practice, 15-year loans are often offered at a lower rate too, which widens the gap. The right choice depends on whether the higher payment leaves room for savings and emergencies.

Why might my actual payment change over time?

On a fixed-rate loan the principal-and-interest part stays the same, but the escrow part can change when property taxes or insurance premiums change. On an adjustable-rate mortgage, the interest rate itself can change after the initial period.

Sources and formula references

  1. Consumer Financial Protection Bureau – What is PITI?
  2. Consumer Financial Protection Bureau – What is private mortgage insurance?
  3. Consumer Financial Protection Bureau – Principal and interest payment vs total monthly payment