calculate-loan

01 Loan payments

Estimated House Payment With Escrow Calculator

Calculator No. 01-8998 · 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.

An estimated house payment with escrow combines principal and interest with monthly amounts for property taxes, homeowners insurance, and any included mortgage insurance. Enter the loan amount, annual interest rate, term, and estimated annual escrow costs to calculate a monthly total; the result is an estimate, not a lender quote.

Formula

The estimated monthly payment is the monthly principal-and-interest payment plus the monthly share of the selected annual escrow costs:

Total = M + (T + I + Q) / 12

  • M is monthly principal and interest, in dollars.
  • T is estimated annual property tax, in dollars per year.
  • I is estimated annual homeowners insurance, in dollars per year.
  • Q is estimated annual mortgage insurance, in dollars per year; enter zero if it does not apply or is not included in your estimate.

For a fixed-rate, fully amortizing loan, principal and interest are calculated as M = round[P × r / (1 − (1 + r)−n), 2], where P is the loan amount in dollars, r = APR / 1200 is the monthly rate as a decimal, and n = 12 × years is the number of monthly payments. The APR input is a percentage per year. The payment is rounded to cents before escrow is added.

Worked Example

Using the calculator defaults: a $300,000 loan, 6.5% APR, 30 years, $3,600 annual property taxes, $1,200 annual homeowners insurance, and $0 annual mortgage insurance.

  1. Convert the APR to a monthly rate: 6.5 ÷ 1,200 = 0.0054167.
  2. Set the number of monthly payments: 30 × 12 = 360.
  3. Calculate principal and interest: $300,000 × 0.0054167 ÷ [1 − (1 + 0.0054167)−360] = $1,896.20 per month, rounded to cents.
  4. Calculate the monthly escrow estimate: ($3,600 + $1,200 + $0) ÷ 12 = $400.00.
  5. Add the two amounts: $1,896.20 + $400.00 = $2,296.20 estimated per month with escrow.

The escrow figure is a monthly budgeting estimate based on the annual amounts entered; it is not a separate loan payment calculation.

Assumptions

  • The interest rate is fixed for the full term and payments are level.
  • Payments are made monthly, with the first payment one month after borrowing.
  • Interest is compounded monthly at APR divided by 12.
  • Escrow is estimated by dividing annual taxes and insurance amounts by 12.
  • The calculation excludes closing costs, lender fees, utilities, maintenance, association dues, and any costs not entered. It does not model changes in taxes or insurance, escrow reserves, or payment adjustments.

What Escrow Adds to a House Payment

In a mortgage payment estimate, “principal and interest” is only the portion that repays the borrowed amount and its interest. An escrow account is a way a mortgage servicer may collect money along with the payment and later pay certain property-related bills. Property taxes and homeowners insurance are common items paid through escrow; mortgage insurance may also be part of a borrower’s monthly housing outlay, though its handling can differ. Whether an account is required and which bills are included depend on the loan and servicing arrangement. Check the lender’s breakdown rather than assuming every item is escrowed.

Escrow is not extra principal paid toward the loan. In the example, the $400 monthly estimate covers annual tax and insurance costs spread across 12 months. The $1,896.20 principal-and-interest portion follows the loan’s amortization schedule. Keeping these parts separate helps explain why a payment can change even when the loan’s interest rate and balance have not changed.

How to Use the Estimate

Use an intended loan amount rather than the home’s purchase price if the borrower will make a down payment. The calculator has no down-payment input: the amount borrowed must already reflect it. For the rate, term, and cost estimates, use figures supplied for the specific scenario where available. Rates and costs are individual inputs, not predictions; obtain real figures from the lender, insurer, and relevant property records or service providers.

  • Enter annual property taxes and homeowners insurance, not monthly amounts. The calculator divides each annual figure by 12.
  • Enter annual mortgage insurance only if you want it included in this estimate. If you have a monthly quote, multiply it by 12 first.
  • Compare the output with a lender’s itemized estimate, checking that both include the same items and use the same loan amount and term.
  • Recalculate when any assumed annual cost changes. The escrow portion can move independently of principal and interest.

Why the Actual Payment Can Differ

The result depends on the accuracy of the inputs. A tax figure based on an earlier bill may not match the amount used for a future payment estimate, and insurance premiums can change at renewal. A servicer may periodically review escrow collections and adjust the amount collected to reflect updated bills or account balances. That can make the total monthly payment rise or fall while the principal-and-interest calculation remains unchanged.

Other common sources of difference include points or fees that affect the loan terms, an adjustable interest rate, a different payment start date, or mortgage insurance costs not included in the inputs. This calculator assumes a fixed rate and does not calculate loan fees, escrow shortages, reserves, or future rate changes. It also does not include other ownership costs such as repairs, utilities, or association charges. Those may matter to a household budget, but they are not part of the payment shown here.

Frequently Asked Questions

What is included in an estimated house payment with escrow?
The estimate here includes principal and interest, annual property taxes divided by 12, homeowners insurance divided by 12, and optional mortgage insurance entered as an annual amount. Other charges are excluded unless you account for them separately.

Is escrow included in principal and interest?
No. Principal and interest repay the mortgage under its payment schedule. Escrow collections are separate amounts intended to cover selected bills, such as taxes and insurance.

Why did my mortgage payment change if my interest rate did not?
Taxes or insurance may have changed, or an escrow review may have changed the monthly collection amount. A fixed-rate loan’s principal-and-interest amount can remain level even as the total collected changes.

Should I enter monthly or annual property taxes?
Enter an annual amount. The calculator divides annual taxes, insurance, and mortgage insurance by 12 to estimate their monthly shares.

Does this estimate include a down payment or closing costs?
No. Enter the amount borrowed after any down payment. Closing costs and other transaction charges are not included in the monthly estimate.

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

Related

Formula used
in p | Loan amount | $ | 300000 | 1 | 100000000
in apr | Interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Loan term | years | 30 | 0.0833 | 50
in tax | Annual property taxes | $ | 3600 | 0 | 100000000
in ins | Annual homeowners insurance | $ | 1200 | 0 | 100000000
in mi | Annual mortgage insurance | $ | 0 | 0 | 100000000
out pay | Estimated monthly payment with escrow | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) + (tax + ins + mi) / 12 | 2
out pi | Monthly principal and interest | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out esc | Monthly escrow estimate | $ | (tax + ins + mi) / 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 →