Want to see exactly where your money goes? Use this amortization tables mortgage calculator to generate a complete schedule of your payments, showing the breakdown between principal and interest over the life of your loan.
Amortization Schedule Calculator
Total Cost: $0.00
Amortization Tables Mortgage Calculator Formula
An amortization table is built by calculating the monthly payment first, then iterating through each month to split that payment into interest and principal components:
Principal = Payment – Interest
The base monthly payment (M) formula is:
Variables
- P: Principal Loan Amount (Starting Balance).
- i: Monthly Interest Rate (Annual Rate / 12).
- n: Total Number of Payments (Years × 12).
- Balance: Remaining loan amount after each payment.
Related Calculators
- Extra Payment Calculator
- Refinance Calculator
- Bi-Weekly Mortgage Calculator
- Home Affordability Calculator
What is Amortization Tables Mortgage Calculator?
An amortization tables mortgage calculator is a detailed financial tool that goes beyond just showing your monthly payment. It provides a year-by-year and month-by-month roadmap of your loan repayment.
In the early years of a mortgage, the majority of your payment goes toward interest. As time passes, the balance shifts, and more of your payment goes toward principal. This calculator visualizes that shift, helping you understand how equity is built over time.
How to Calculate Amortization Tables Mortgage Calculator (Example)
Example: $200,000 loan at 6% for 30 years.
- Monthly Payment: Calculated as $1,199.10.
- Month 1 Interest: $200,000 × (0.06 / 12) = $1,000.
- Month 1 Principal: $1,199.10 – $1,000 = $199.10.
- Month 1 Ending Balance: $200,000 – $199.10 = $199,800.90.
- Month 2 Calculation: Repeat using the new balance.
Frequently Asked Questions (FAQ)
Interest is calculated on the outstanding balance. Since your balance is highest at the beginning, the interest portion is largest. As you pay down the principal, the interest charge decreases.
No. An amortization schedule strictly tracks the Principal and Interest of the loan. Taxes and insurance are held in escrow and do not affect the loan balance or amortization timeline.
Yes, you can typically print the page or copy the table data into a spreadsheet like Excel or Google Sheets for further analysis or record-keeping.
Making extra principal payments reduces the balance faster than scheduled. This means future interest charges will be lower, and the loan will be paid off before the full term ends.