Flagship home-cost workbook

All-in mortgage calculator

Build a monthly estimate from the loan payment, property tax, insurance, HOA and PMI. Then compare rates and terms, test extra principal, and export the annual amortization schedule.

Nine editable assumptions Scenario table CSV amortization export

Build the loan and ownership-cost estimate

Use annual amounts for tax and insurance, monthly amounts for HOA and PMI, and zero for anything that does not apply. The extra-principal field changes payoff time but not the scheduled payment.

$
$
%
$
$
$
$
$
Estimated monthly housing cost

Principal, interest, entered tax, insurance, HOA and PMI. Extra principal is shown separately.

Principal & interest
Planned outflow with extra
Loan amount
Scheduled total interest
Scheduled loan total
Payoff with extra
Interest / time saved

Hold the price and ownership costs constant

Mortgage scenarios generated from the current inputs
ScenarioRateTermP&IAll-inInterest
PrincipalInterest

Annual amortization with the entered extra payment

Year-by-year principal, interest and remaining balance
YearPrincipalInterestEnding balance

Read the result in layers

The large monthly figure adds the scheduled principal-and-interest payment to the tax, insurance, HOA, and PMI amounts you entered. The Consumer Financial Protection Bureau distinguishes principal and interest from the total monthly payment because the latter commonly includes taxes, homeowners insurance, and mortgage insurance; HOA charges may be separate. See the CFPB explanation of total monthly payment.

How each result should be used
ResultUseDo not assume
Principal & interestCompare loan structures when principal, rate, and term are held constant.That it is the complete monthly cost.
All-in estimatePlace the entered ownership charges beside the loan payment.That tax, insurance, HOA, or PMI will stay unchanged.
Planned outflowSee the cash effect of an optional extra-principal payment.That a servicer will automatically apply every extra dollar to principal.
Annual scheduleTrace principal, interest, and balance using unrounded internal values.That it replaces a lender or servicer statement.

Calculation order

  1. The down payment is subtracted from the home price to produce the loan principal.
  2. The fixed-rate payment is calculated from principal, monthly rate, and number of monthly payments.
  3. Annual property tax and insurance are divided by 12; monthly HOA and PMI are then added.
  4. The optional extra amount is applied to principal after that month's interest. The final payment is reduced when the remaining balance is smaller than the planned payment.
  5. Scenario rows change one rate or term assumption while leaving the property price and entered ownership costs untouched.
Fixed-rate principal-and-interest formula

M = P × [r(1 + r)n] / [(1 + r)n - 1]

P is the loan principal, r is the annual interest rate expressed as a decimal and divided by 12, and n is the loan term in months. At a 0% rate, the payment is simply P divided by n.

The schedule uses full-precision values internally and rounds only what is displayed. The CFPB's explanation of mortgage amortization confirms the basic payment behavior: early payments direct more money to interest, while the principal share rises as the balance falls. Read how paying down a mortgage works.

Public verification record

This version is checked against deterministic cases that anyone can reproduce. The automated test file is part of the site build, and the broader test vectors are documented on the methodology page.

Selected mortgage engine test vectors
PrincipalRate / termExpected P&IReason for test
$300,0006.00% / 30 years$1,798.65Standard fixed-rate amortization case.
$1,2000.00% / 12 months$100.00Confirms the explicit zero-rate branch.
$336,0006.40% / 30 years$2,101.70Matches the page's default loan inputs before ownership costs.

Replace estimates in the right order

Begin with approximate local costs if you are still exploring. As the purchase becomes real, replace them with documents: property-tax information from the local authority, an insurance quote, HOA disclosures, and the lender's PMI and Loan Estimate. The CFPB's interactive Loan Estimate explainer identifies where to check the loan amount, projected payment, mortgage insurance, taxes, insurance, assessments, closing costs, and cash to close.

When comparing lenders, keep tax and insurance assumptions consistent. A lender does not control those costs, so a lower estimate does not by itself make that loan cheaper. Compare principal and interest, lender-controlled upfront costs, and credits separately, then rebuild the same all-in budget for each offer.

Boundaries of the model

Included only when you enter it

Property tax, homeowners insurance, HOA, and PMI are user-supplied dollar amounts. The tool does not infer them from ZIP code, loan program, credit profile, or down-payment percentage.

The model does not include maintenance, utilities, flood or other supplementary insurance, tax deductions, closing costs, adjustable rates, points, temporary buydowns, refinancing, late fees, changing escrow bills, or rules for canceling mortgage insurance. Extra payments are treated as principal immediately; verify how the servicer requires them to be labeled and whether the loan documents contain a prepayment penalty.

U.S. scope: Inputs and results use USD, and the cited documents reflect U.S. mortgage practice. Elsewhere, adapt the tax, insurance, lending-term, and fee assumptions to local rules.

This page is educational and scenario-based. Real loan offers depend on lender rules, credit profile, taxes, insurance, property details, and timing.