Roofline / Mortgage amortization schedule
Mortgage amortization schedule
See how each payment splits between interest and principal, year by year or month by month.
How to read the schedule
In the first years most of each payment is interest, because the balance is still large. As the balance falls, the interest part shrinks and more of the same payment goes to principal. The yearly table shows the trend; the monthly table lists every payment.
Using the CSV
The download is a plain table you can open in Excel or Google Sheets to add your own columns. It is built in your browser; nothing is uploaded.
Frequently asked questions
How is a mortgage payment calculated?
With the formula P × i / (1 − (1 + i)^−n), where P is the loan, i the monthly rate (annual rate / 12) and n the number of monthly payments. Property tax and insurance are added on top.
Does it include property tax and insurance?
Yes, if you fill in the optional fields. They are divided by 12 and added to the monthly payment.
How much does an extra payment save?
Enter the extra amount in the optional section: the calculator shows the new payoff time and the interest saved compared with paying the minimum.
Are the numbers sent anywhere?
No. Everything is calculated in your browser.