Mortgage Calculator: Monthly Payment + Amortization (Excel Download)
Include taxes, insurance, PMI, HOA, extra payments — and switch to ARM mode only if you need it.
Loan type
Home price ($)
Down payment
Interest rate (APR %)
Loan term (years)
Results
Down payment
$150,000.00 (20.00%)
Loan amount
$600,000.00
Monthly principal + interest
$3,792.41
All-in monthly payment
$3,792.41
Total interest (over loan life)
$765,266.93
Note: Estimates only. Verify with your lender and local tax/insurance figures.
How this mortgage calculator works
This mortgage calculator estimates your monthly payment using your loan amount, interest rate, and loan term. You can include property taxes, homeowners insurance, PMI, HOA fees, and extra payments to see a realistic total monthly housing cost.
What affects your monthly mortgage payment?
- Loan amount and down payment
- Interest rate and mortgage term
- Property taxes and homeowners insurance
- PMI and HOA fees
- Extra monthly or annual payments
The calculator also generates a full amortization schedule and lets you download the results to Excel for deeper analysis or sharing.
This tool is designed for education and planning purposes and does not represent a lender quote.