Refinance Calculator With Escrow: What It Includes

A refinance calculator with escrow estimates your new monthly principal-and-interest payment plus the property-tax and homeowners-insurance amounts you enter. Enter the new loan balance, APR, term, and monthly escrow estimates to see an estimated monthly total and total interest; escrow is an estimate, not part of the loan’s interest calculation.

Formula

The calculator first finds the level monthly principal-and-interest payment, then adds the monthly escrow estimates:

Monthly total = M + T + I

M = round[P × r ÷ (1 − (1 + r)⁻ⁿ), 2]

• P is the new loan balance in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
• n is the number of monthly payments, calculated as years × 12.
• M is monthly principal and interest in dollars, rounded to cents.
• T is the monthly property-tax escrow estimate in dollars.
• I is the monthly homeowners-insurance escrow estimate in dollars.

Total interest is calculated as M × n − P. This uses the rounded monthly payment, as shown by the calculator. Escrow is added to the monthly estimate, but it does not reduce the loan balance or accrue loan interest in this model.

Worked Example

Using the calculator’s default inputs: a $300,000 balance, 6.5% APR, a 30-year term, $500 monthly property-tax escrow, and $150 monthly homeowners-insurance escrow:

1. Monthly rate: 6.5 ÷ 1,200 = 0.0054166667.
2. Number of payments: 30 × 12 = 360.
3. Monthly principal and interest: round[300,000 × 0.0054166667 ÷ (1 − (1 + 0.0054166667)⁻³⁶⁰), 2] = $1,896.20.
4. Estimated monthly total with escrow: $1,896.20 + $500 + $150 = $2,546.20.
5. Total interest over the term: $1,896.20 × 360 − $300,000 = $382,632.00.

Assumptions

• The APR is fixed for the full term.
• Payments are level monthly payments, made at the end of each monthly period.
• Interest compounds monthly using APR ÷ 12.
• Escrow estimates are fixed monthly inputs; actual bills and escrow collections can change.
• The calculation excludes closing costs, points, prepaid items, mortgage insurance, other fees, and any existing-loan payoff charges. It also does not estimate taxes or insurance bills from property details.

What Escrow Means in a Refinance Estimate

Mortgage escrow is an account used to collect money toward certain property-related bills, commonly property taxes and homeowners insurance. A monthly mortgage bill may include principal, interest, and an escrow collection. The escrow part is not an additional loan balance: it is money collected toward bills that may come due at different times during the year.

A refinance can change the loan payment without making tax or insurance costs disappear. The calculator keeps those estimates visible alongside principal and interest so the monthly total is easier to compare with a current payment. It does not determine what the servicer will collect, when bills will be paid, or whether the escrow account will have a surplus or shortage.

How to Enter Useful Numbers

Use the proposed refinance balance, not automatically the home’s value or the original mortgage amount. A new balance may include an amount needed to pay off the existing loan, and some borrowers also model costs added to the balance. The lender’s written estimate is the appropriate source for the proposed loan amount and APR; do not treat the example defaults as a quote.

• APR: Enter the annual percentage rate supplied for the proposed loan. It is not the monthly rate; the formula converts it by dividing by 1,200.
• Term: Enter the proposed repayment period in years. A longer term changes both the monthly principal-and-interest payment and the number of payments used for total interest.
• Property taxes: For a rough monthly input, divide the annual tax estimate by 12. Use a current bill or a relevant estimate, then account for any expected change separately.
• Insurance: Divide the annual homeowners-insurance premium by 12 if that is the figure available. Premiums can change, so an older bill may not represent a future collection.

If taxes or insurance are paid outside escrow, enter zero for that item. The resulting total then represents the modeled mortgage payment plus only the escrow items entered; it does not mean the omitted bill has no cost.

What the Result Leaves Out

This is a payment-and-interest estimate, not a full refinance quote or a complete comparison of loan costs. It does not include closing costs, discount points, title or recording charges, prepaid interest, lender fees, or the payoff amount on the old mortgage. If costs are financed, they may increase the new balance; if paid separately, they still affect the cash needed to complete the refinance.

It also excludes mortgage insurance and other possible monthly charges because they are not inputs. Check the lender’s estimate for the complete payment breakdown and ask which costs are included in the proposed balance. For a more meaningful comparison, compare the same categories of costs and the same time period, rather than looking only at the monthly payment.

Common Escrow Misunderstandings

• Escrow is not interest. Property-tax and insurance collections do not pay down principal in this formula and are not included in total interest.
• The calculator does not forecast escrow changes. Tax bills and insurance premiums may be reassessed or renewed at different amounts. The fixed inputs here cannot anticipate those changes.
• The monthly total is not necessarily the exact bill. Other charges may apply, and the servicer’s collection can differ because of its escrow analysis and billing schedule.
• A lower payment does not by itself show lower overall cost. The term, upfront costs, balance, and time the loan is kept all matter. This calculator reports payment and modeled interest, not every cost or a break-even point.

Frequently Asked Questions

Does a refinance calculator include escrow?
Only if it has inputs for escrow costs or otherwise states that it includes them. This calculator adds the monthly property-tax and homeowners-insurance amounts you enter to principal and interest.

Does escrow affect my interest rate or loan balance?
No. Escrow is a collection for specified bills, not principal borrowed under the loan. In this estimate, it does not change the APR, amortization, or total interest.

Should I include taxes and insurance in the refinance loan amount?
Not as monthly escrow inputs. Enter the proposed new loan balance separately, and use the escrow fields for estimated monthly collections. Whether any costs are included in a loan balance must come from the proposed loan terms.

Why is my lender’s payment different from the calculator?
The lender’s figure may include charges this calculator omits, use different tax or insurance estimates, or reflect a different balance, APR, term, or payment date. Compare the itemized figures rather than assuming the difference is an error.

What if I pay property taxes or insurance myself?
Enter zero for the relevant escrow item. Remember that the bill still exists; it simply is not included in the calculator’s monthly mortgage total.

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

Related

• Burj Khalifa Total Cost: What the $1.5 Billion Includes
• Bank of the West Refinance Rates Calculator
• Brown University Total Cost: Tuition and Full Budget

in bal | New loan balance | $ | 300000 | 1 | 100000000
in apr | Interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Loan term | years | 30 | 0.0833 | 50
in tax | Monthly property tax escrow | $ | 500 | 0 | 1000000
in ins | Monthly homeowners insurance escrow | $ | 150 | 0 | 1000000
out total | Estimated monthly payment with escrow | $ | round(bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) + tax + ins | 2
out pi | Monthly principal and interest | $ | round(bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest over the term | $ | pi * yrs * 12 - bal | 2