David Chen is a Certified Financial Analyst with over 10 years of experience in mortgage analytics and amortization modelling.
Use this free mortgage calculator with amortization table to see monthly P&I, total interest, and a full payment schedule—no Excel download required.
Free Mortgage Calculator with Amortization Table
Amortization Formula
Monthly Payment: M = P × [ r(1+r)^n ] / [ (1+r)^n – 1 ]
Interest Portion: Previous Balance × r
Principal Portion: M – Interest
Formula Sources: Investopedia | Bankrate
Variables
- P: Original loan amount.
- r: Monthly interest rate (annual rate ÷ 12).
- n: Total number of monthly payments (years × 12).
Related Calculators
- Excel Amortization Schedule Download
- Bi-Weekly Amortization Calculator
- Mortgage Payoff Accelerator
- Loan Comparison Calculator
What Is a Free Mortgage Calculator with Amortization Table?
It replicates Excel’s classic PMT + amortization schedule in a single web widget. Every row shows payment number, interest, principal, and remaining balance—perfect for visualizing equity build-up or planning extra payments.
How to Use (Example)
- Enter loan amount (e.g., $400,000).
- Input annual interest rate (e.g., 6.0%).
- Set term (e.g., 30 years).
- Click “Calculate” for monthly payment and full table.
Frequently Asked Questions (FAQ)
Does the table include taxes or insurance? No—pure principal & interest; add escrow separately.
Can I export the table? Copy-and-paste from the on-screen list or request the CSV version.
Is the math identical to Excel? Yes—matches Excel PMT and amortization to six decimal places.
How large a loan can I model? Any dollar amount; browser performance is stable up to 50-year tables.