calculate-loan

01 Loan payments

House Payment Calculator With Escrow: What It Includes

Calculator No. 01-6172 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A house payment calculator with escrow estimates your monthly mortgage principal and interest plus the monthly amounts set aside for property taxes and homeowners insurance. Enter the home price, down payment, interest rate, loan term, annual tax and insurance estimates, and the result shows an estimated monthly payment with escrow broken out.

Formula

The calculator adds the fixed-rate mortgage payment to monthly estimates for property tax and homeowners insurance:

Estimated monthly payment with escrow = principal-and-interest payment + annual property tax / 12 + annual homeowners insurance / 12.

  • price is the home price in dollars; down is the down payment in dollars.
  • Loan principal, P, is price minus down, in dollars.
  • APR is the entered annual percentage rate. The monthly rate, r, is APR / 1200.
  • Term is yrs × 12 monthly payments.
  • Annual property tax and annual homeowners insurance are dollar estimates for a full year.

For principal and interest, the level-payment formula is P × r / (1 − (1 + r)−n), where n is the number of monthly payments. The monthly tax and insurance estimates are each annual amounts divided by 12. Escrow is their combined monthly estimate. The calculator assumes the down payment is less than or equal to the price; its square-root check prevents a negative loan amount from producing a result.

Worked Example

Using the calculator’s default entries: a $350,000 home, $70,000 down, 6.5% APR, a 30-year term, $4,200 annual property tax, and $1,800 annual homeowners insurance:

  1. Loan principal: $350,000 − $70,000 = $280,000.
  2. Monthly rate: 6.5 / 1200 = 0.0054167; term: 30 × 12 = 360 payments.
  3. Monthly principal and interest: $280,000 × 0.0054167 / (1 − (1 + 0.0054167)−360) = $1,770.08, rounded to cents.
  4. Monthly tax estimate: $4,200 / 12 = $350.00. Monthly insurance estimate: $1,800 / 12 = $150.00.
  5. Estimated escrow: $350 + $150 = $500.00. Total monthly payment estimate: $1,770.08 + $500 = $2,270.08.

Assumptions

  • The interest rate stays fixed for the entire term.
  • Payments are monthly and made at the end of each period.
  • Interest is compounded monthly using APR / 12.
  • Tax and insurance are estimated as even monthly amounts based on the annual figures entered.
  • The estimate excludes fees, mortgage insurance (PMI), association dues, utilities, maintenance, and any other costs not entered. It does not model changes in taxes or insurance over time.

What Escrow Means in a House Payment

In a mortgage context, escrow commonly refers to money collected with the mortgage payment and held to pay certain property bills, especially property taxes and homeowners insurance. Rather than paying those bills as separate large annual or semiannual amounts, a borrower’s monthly bill may include a portion of the expected yearly cost. The mortgage servicer later pays the bills from the escrow account.

Escrow is not part of the loan principal, and it does not reduce the mortgage balance. Principal and interest repay the loan; escrow funds cover the bills included in the account. The word “escrow” can also describe other arrangements in property transactions, so here it means the ongoing tax-and-insurance collection, not a one-time closing account.

What the Estimate Includes—and Leaves Out

The calculation is useful for a first-pass monthly budget, but a house payment can contain more than principal, interest, tax, and insurance. Some loans also have mortgage insurance, while a property may have association dues or other recurring costs. Those are not included because the calculator has no inputs for them. Closing costs and utility bills are separate from this recurring estimate.

Also, “escrow” does not mean every property-related expense is automatically covered. Check which bills a servicer plans to collect and pay. Some homeowners pay one or more bills directly instead; in that case, those expenses still affect the household budget even if they are not part of the mortgage draft.

Choosing Useful Inputs and Understanding Changes

Use a loan amount and term that reflect the scenario you want to estimate. The loan amount here is calculated from home price minus down payment; do not enter the down payment as though it were additional borrowed money. Enter the annual tax and insurance amounts as yearly totals, not monthly bills. If you know only a monthly estimate, multiply it by 12 before entering it.

  • Use property-tax information relevant to the specific property when available; assessed values and tax bills can differ from a rough estimate.
  • Use an insurance estimate for the coverage and property being considered. Premiums can vary with property features and coverage terms.
  • Enter the rate and loan term shown in a lender’s quote for a scenario, rather than treating the sample defaults as a market rate.
  • Run a separate estimate if taxes, insurance, down payment, rate, or term changes. Each can change the result in a different way.

The calculator holds the tax and insurance amounts level over the full period. Actual bills and escrow collections can be adjusted when costs change or the account is reviewed. That can make the monthly amount collected differ from this simple estimate, even when the loan’s principal-and-interest payment is fixed.

Common Misconceptions and Limits

A common misconception is that the displayed total is the complete cost of owning a home. It is only the included mortgage and escrow estimate. Another is that the escrow portion is interest or a fee: it is an allowance for specified bills, not an extra repayment of principal. The servicer’s collection and payment schedule may also differ from a simple annual-cost-divided-by-12 calculation.

The calculator does not estimate eligibility, approval, closing cash, or a lender’s final payment. It also does not calculate changing rates, variable insurance premiums, tax reassessments, escrow shortages or refunds, or the effect of optional extra principal payments. Ask the lender or servicer for the actual figures and which items are included in its payment quote.

Frequently Asked Questions

Does a house payment calculator with escrow include property taxes?
Yes. This calculator adds the annual property-tax estimate divided by 12 to monthly principal and interest.

Does escrow include homeowners insurance?
This estimate includes the annual homeowners insurance amount entered, divided by 12. Actual mortgage arrangements can differ, so confirm which insurance bills are collected through escrow.

Is escrow part of my mortgage loan balance?
No. In this calculation, escrow is a monthly estimate for tax and insurance bills. It is separate from the principal balance and interest charged on the loan.

Why might my actual payment differ from the calculator?
The entered rate, term, taxes, or insurance may differ from final figures. A servicer’s escrow collection can also change as bills or account estimates change; additional costs such as mortgage insurance or association dues are not included here.

Should I enter monthly or annual taxes and insurance?
Enter annual totals. The calculator divides each by 12 to estimate a monthly amount. If you have only monthly figures, multiply each by 12 first.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

Formula used
in price | Home price | $ | 350000 | 1 | 100000000
in down | Down payment | $ | 70000 | 0 | 100000000
in apr | Interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Loan term | years | 30 | 0.0833 | 50
in tax | Annual property tax | $ | 4200 | 0 | 10000000
in ins | Annual homeowners insurance | $ | 1800 | 0 | 10000000
out pay | Monthly payment with escrow | $ | (price - down) * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) + tax / 12 + ins / 12 + 0 * sqrt(price - down) | 2
out pi | Monthly principal and interest | $ | (price - down) * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) + 0 * sqrt(price - down) | 2
out esc | Monthly estimated escrow | $ | tax / 12 + ins / 12 | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →