Skip to content

Amortization Schedule

Create the full amortization schedule of a loan or mortgage: the monthly payment and, for every month or year, how much goes to principal and interest and what balance remains. Add an extra monthly payment to see how much sooner the loan is paid off, and download the schedule as CSV.

Reset

Frequently asked questions

How is the monthly payment calculated?

With the standard annuity formula: the payment stays the same every month, and it is chosen so that the loan is fully repaid at the end of the term at the given annual interest rate, compounded monthly.

Why does the interest share go down over time?

Interest is charged on the remaining balance. Early in the loan the balance is high, so most of the payment is interest. As the balance falls, more of each payment goes to principal.

What does an extra payment do?

The extra amount goes straight to principal every month, which reduces the interest of all following months. The summary shows how many months earlier the loan is paid off and the new total interest.

Can I see every single month?

Choose monthly to list every payment. The yearly view sums up each year of payments. The CSV download always contains every month.

Does the schedule include taxes, insurance or fees?

No. It covers principal and interest only. Property taxes, insurance, PMI and lender fees come on top of the payment shown.

What if the interest rate is 0%?

Then the loan is simply divided into equal payments over the term, and no interest is charged.

About OneClick Pro

OneClick Pro is a free collection of more than 150 web tools for everyday work: converting images and units, formatting and validating code, checking domains and SEO, and working with text, dates and numbers. Every tool runs without registration or subscription, and what you enter is only used to calculate your result and is never stored. Use it as a quick toolbox for one-off tasks, or bookmark the tools you rely on every day.