Mortgage Calculator

True monthly payment including taxes, insurance and PMI — plus a full year-by-year amortization schedule.

📊 Want this as a spreadsheet you own? Get the Rental Deal Analyzer workbook — $9 →

Total monthly payment
Principal & interest
Taxes + insurance + PMI
Loan amount
Total interest paid
Total cost of loan

Amortization schedule (yearly)

YearPrincipal paidInterest paidBalance

Frequently asked questions

How is the monthly payment calculated?

Principal & interest use the standard amortization formula P × r / (1 − (1+r)−n); taxes, insurance, PMI and HOA are added on top.

When does PMI go away?

On conventional loans PMI can be removed at 80% loan-to-value and must be removed at 78%. This calculator applies PMI only when your down payment is under 20%.

15-year vs 30-year — which is better?

A 15-year term roughly halves total interest but raises the monthly payment ~35–45%. Change the term above to compare instantly.

📊 Rental Deal Analyzer — the full Excel model ($9)

Everything these free calculators do, in one spreadsheet you own: live cash-flow & ROI, cap rate, cash-on-cash, DSCR, a BRRRR refinance tab, a 30-year amortization schedule, and side-by-side comparison of 5 deals. Works in Excel and Google Sheets. Instant download.

Buy now — $9 → One-time payment · instant download · no subscription