The formula
M = P · r / (1 − (1 + r)^−n), where P is the loan amount, r is the monthly rate (annual / 12), and n is the number of months. It's exact algebra given the four inputs — the same formula Microsoft Excel's PMT() function uses.
Monthly payment, total interest, total paid — from the four numbers everyone has.
A fixed-rate mortgage is one of the most common loans on the planet, and the math is identical regardless of lender: monthly payment depends only on principal (home price minus down payment), interest rate, and term. The calculator below uses the textbook closed-form formula — no proprietary curve, no marketing adjustments. Property tax, HOA, and PMI are excluded on purpose so you can see the loan math cleanly.
Loan amount: $320,000.00
Principal & interest only. Property tax, homeowner’s insurance, HOA dues, and PMI are not included.
Loan amount = home price minus down payment. Most US lenders require at least 3–20% down depending on loan type.
Use the rate you've been quoted (or the current national average — Freddie Mac's PMMS is the standard reference). 15- and 30-year are the common US terms.
Monthly payment is what you'll owe each month. Total interest is what the bank earns over the life of the loan. Total paid is principal + interest.
| Loan | Rate | Term | Monthly | Total interest |
|---|---|---|---|---|
| $200K | 6.0% | 30y | $1,199 | $231,676 |
| $200K | 6.0% | 15y | $1,688 | $103,788 |
| $400K | 6.5% | 30y | $2,528 | $510,178 |
| $400K | 5.5% | 30y | $2,271 | $417,615 |
M = P · r / (1 − (1 + r)^−n), where P is the loan amount, r is the monthly rate (annual / 12), and n is the number of months. It's exact algebra given the four inputs — the same formula Microsoft Excel's PMT() function uses.
Property tax (highly local), homeowner's insurance (highly individual), HOA fees (highly community-specific), and PMI (depends on loan-to-value and lender). Add ~25-40% on top of the calculator's monthly payment as a rough first guess for the full PITI.