Roofline
Language

Roofline / Mortgage amortization schedule

Mortgage amortization schedule

See how each payment splits between interest and principal, year by year or month by month.

Taxes, insurance and extra payments

The pre-filled numbers are examples, not today's market rates. Enter the rate your lender quoted.

Monthly payment

  • Principal
  • Interest
  • Tax and insurance
Principal and interest
Property tax
Insurance
Loan amount
Total interest
Total repaid (principal + interest)
Paid off in
Interest saved by extra payments
Still owed at the end

Amortization schedule

YearInterestPrincipalBalance
Show every month
MonthInterestPrincipalExtraBalance

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.