Amortization schedule
Enter the loan and see the payment, the total interest, and how each payment splits between interest and principal.
Everything is worked out in your browser. The numbers you type never leave this page.
In RPNLog, AMORT is free for any block of payments. The full schedule table and CSV export are part of RPNLog Pro. RPNLog on Google Play.
Estimates, not financial advice. Check the figures against your lender's documents before you rely on them.
How it is calculated
First the payment, from the standard loan formula. It is the amount that takes the balance to zero after the last period:
payment = balance × i ÷ (1 − (1 + i)^−n)
i is the yearly rate ÷ payments a year, as a decimal. n is the number of payments. For payments at the start of each period, divide the result by (1 + i).
Then, for each payment in turn:
interest = balance × i, rounded to the cent principal = payment − interest balance = balance − principal
With payments at the start of each period, the first payment has no interest in it, since no time has passed yet.
Worked example
450,000 at 6.5% a year over 30 years, paid monthly.
- The monthly rate is 6.5% ÷ 12 = 0.54167%, and there are 360 payments. The payment is 2,844.31.
- First month's interest: 450,000 × 0.0054167 = 2,437.50. The rest, 406.81, goes to principal. The balance becomes 449,593.19.
- After the first 12 payments, interest paid is 29,101.89, principal paid is 5,029.83, and the balance is 444,970.17.
- Over the whole loan, total interest is 573,947.33.
Limits
- A fixed rate and equal payments only. It does not model adjustable rates, extra payments or interest-only periods.
- The rate is divided evenly across the payments in a year, compounding once per payment. Some mortgages, including many in Canada, compound differently, so the payment can differ a little.
- Principal and interest only. It leaves out taxes, insurance and fees.
- Up to 1,200 payments, the same limit as the app's schedule.
- Amounts are shown as positive here, for reading. The TVM calculator shows payments as negative, following the sign convention.
Frequently asked
Why is the last balance not exactly zero? The payment is rounded to the cent, and interest is rounded each period. Those small differences add up. On the example above, the last balance is −4.27, which means the final payment would be 4.27 smaller than the rest. Lenders settle this on the last payment.
Why is so much of the early payment interest? Interest is charged on the balance, and the balance is largest at the start. As it falls, less of each equal payment goes to interest and more goes to principal.
Will this match my lender's schedule? It often comes close. Each period's interest is rounded to the cent, the way lenders commonly do. But day-count rules, payment dates and how the rate compounds can vary, so your lender's statement is the one that counts.
Does it work for biweekly payments? Choose 26 payments a year. The yearly rate is divided by 26, so it treats each payment as one equal period. A real biweekly plan offered by a lender may work differently, so check its terms.