Loan & Property
Taxes & Insurance
Downloads
CSV includes full amortization schedule with monthly breakdown.
Results
Balance & Payment Composition
Amortization Schedule (sample)
Example shown after calculation| Month | Payment | Principal | Interest | Taxes | Insurance | PMI | HOA | Balance |
|---|
Formula Used
Monthly interest rate: r = annualRate / 12 / 100
Number of payments: n = termYears × 12
Monthly principal & interest:
M = P * r * (1 + r)^n / ((1 + r)^n - 1)
Property tax (monthly): tax = homePrice × (taxRate/100) / 12
Homeowners insurance (monthly): ins = annualInsurance / 12
PMI (monthly): pmi = loanBalance > 0.8 × homePrice ? (loanAmount × (pmiRate/100) / 12) : 0
HOA (monthly): user-entered.
If escrow is included, total monthly payment = M + tax + ins + pmi + HOA. The amortization schedule updates balance monthly by subtracting principal.