Home Mortgage Calculator

Export CSV

Monthly Principal & Interest:

Monthly Tax:

Monthly Insurance:

Monthly HOA:

Monthly PMI (initial):

Total monthly payment (initial):

Total monthly (excluding escrow):

Total payment (all months):

Total interest (all months):

MonthPayment PIInterest Principal PaidBalance TaxInsuranceHOA PMITotal Monthly
About the Asset Mortgage Calculator
What is a mortgage?

A mortgage is a secured loan used to buy an asset, usually real estate. The asset is collateral. If you default, the lender can repossess and sell the asset.

Why it matters
  • Plans cash flow by estimating monthly payments.
  • Shows total interest over time.
  • Tests scenarios: rate, term, down payment, extra payments.
Advantages
  • Leverage. Acquire an asset without full price upfront.
  • Predictable amortization for fixed rates.
  • Potential tax benefits where applicable.
Limitations
  • Interest cost can exceed principal over long terms.
  • Rates, taxes, and insurance can change.
  • Market risk. Asset value can fall below loan balance.
How to manage a mortgage
  • Keep loan-to-value (LTV) moderate. Larger down payment lowers risk.
  • Target affordable debt-to-income (DTI).
  • Build an emergency fund for 3–6 months of payments.
  • Use extra principal payments to cut term and interest.
  • Refinance if rate drop covers fees within a reasonable breakeven.
Fields used in this calculator
  • Property/Asset Price: Agreed purchase price.
  • Down Payment: Cash paid upfront. Reduces loan amount.
  • Loan Amount: Price minus down payment plus financed fees.
  • Interest Rate (Annual): Nominal yearly rate. Fixed or variable.
  • Loan Term: Years to repay (e.g., 15, 20, 25, 30).
  • Payment Frequency: Monthly, biweekly, weekly. Affects count of payments per year.
  • Property Tax (optional): Yearly tax. Added to the escrowed monthly estimate.
  • Home Insurance (optional): Yearly premium. Added to monthly estimate.
  • PMI / Mortgage Insurance (optional): Applies at high LTV. Ends when LTV drops below threshold.
  • HOA/Fees (optional): Monthly fees for associations or maintenance.
  • Closing Costs: One-time fees at origination. Can be paid cash or financed.
  • Extra Payment (optional): Extra amount applied to principal each period.
  • Start Date: Used to build an amortization schedule by month.
Core formulas
Periodic rate r = (annual_rate / payments_per_year)
Number of payments n = term_years × payments_per_year
Payment M = P × r × (1+r)^n / ((1+r)^n - 1)
Interest this period = balance × r
Principal this period = M - interest
New balance = balance - principal - extra_payment
      
Key outputs
  • Periodic Payment: Principal + interest. Escrows add on top.
  • Total Interest: Sum over the term. Falls with larger down payment or extra principal.
  • Amortization Schedule: Period-by-period split of interest and principal, with running balance.
  • LTV: Loan ÷ Asset value. Important for risk and PMI.
  • All-in Monthly: Payment plus taxes, insurance, PMI, and fees.
Interpreting results
  • Shorter terms raise payment but cut interest sharply.
  • Lower rate reduces both payment and total interest.
  • Extra principal early has the highest impact.
  • High LTV increases risk and may trigger PMI.

Note: This is an estimate. Actual offers depend on underwriting, credit, income, asset type, and local rules.