Amortization Schedule Calculator Guide: How Loans Pay Down

Most people know their monthly loan payment, but far fewer know where that payment actually goes. In the early years of a long loan, the surprising answer is that most of it goes to interest, and only a small slice reduces the amount owed. That is not a trick by the lender; it is the mathematics of amortisation, and understanding it changes how you think about extra payments, refinancing, and loan length.

The Amortization Schedule Calculator takes a loan amount, an annual interest rate, and a term, and returns the monthly payment, the total amount paid over the life of the loan, the total interest, and the split of the first payment between interest and principal. An amortisation schedule is simply the full month-by-month version of that split, showing the balance falling slowly at first and faster later. This guide explains the maths, works through a realistic mortgage-sized example, and shows why the timing of extra payments matters so much.

How the monthly payment is calculated

For a fixed-rate loan with monthly payments, the payment is calculated so that the same amount, paid every month for the whole term, exactly clears the loan plus interest. The formula uses the monthly interest rate, which is the annual rate divided by 12, and the total number of payments. The payment equals the loan amount multiplied by the monthly rate, divided by one minus the monthly rate factor raised to the negative number of payments.

You do not need to memorise that formula, but one intuition helps: the payment must cover each month's interest on the outstanding balance, plus enough principal to bring the balance to zero by the final payment. Because the balance is largest at the start, the interest portion is largest at the start too. As the balance falls, the interest portion shrinks, and more of each fixed payment goes to principal. That is why the schedule curves: slow progress early, faster progress later.

Worked example: 200,000 over 30 years at 5 percent

Take a loan of 200,000 at an annual rate of 5 percent over 30 years, which is 360 monthly payments. The monthly rate is 5 percent divided by 12, which is 0.0041667. Applying the formula gives a monthly payment of about 1,073.64. Over 360 payments, the total paid is 1,073.64 multiplied by 360, which equals about 386,510. The total interest is therefore 386,510 minus 200,000, which equals about 186,510, nearly as much as the amount borrowed.

Now look at the first payment. Interest for the first month is the starting balance multiplied by the monthly rate: 200,000 multiplied by 0.0041667 equals 833.33. The rest of the payment goes to principal: 1,073.64 minus 833.33 equals 240.31. So after the first payment, the borrower has paid 1,073.64 but owes only 240.31 less, with a new balance of 199,759.69. After twelve such payments, the balance has fallen by only about 3,000, even though more than 12,800 has been paid. That slow start is normal, not a sign that something is wrong.

By contrast, near the end of the loan the picture reverses. With only a small balance left, the monthly interest is tiny, and almost the whole payment reduces principal. The fixed payment never changes, but its composition transforms completely over the life of the loan.

What the tool does not do

The calculator models a straightforward fixed-rate loan with equal monthly payments and no fees, no taxes, no insurance, and no rate changes. Real loans often include extra costs: arrangement fees, insurance, property taxes collected monthly, or an interest rate that changes after an introductory period. An adjustable-rate loan will have its payment recalculated when the rate changes, so the original schedule only holds until the first adjustment.

The calculator also assumes every payment is made on time and in full. Missed or late payments can add fees and interest, and some loans charge penalties for early repayment, which would change the benefit of extra payments. These figures are educational estimates for comparing loan shapes, not a quote, and not financial advice. For a real borrowing decision, compare the lender's own disclosure, which must show the true total cost under the actual terms.

Common mistakes

The most common mistake is comparing loans by monthly payment alone. A longer term always lowers the monthly payment, but it usually raises total interest substantially. A 30-year loan at the same rate costs far more in total interest than a 20-year loan, even though the monthly figure looks friendlier. Always look at total paid and total interest alongside the monthly payment.

The second mistake is assuming extra payments help equally at any time. An extra payment made in year two, when the balance is high, saves interest on that amount for the remaining 28 years. The same extra payment made in year 28 saves interest for only two years. Early extra principal is far more powerful, which is why borrowers who can afford it often start extra payments as soon as possible, subject to any early-repayment terms.

The third mistake is forgetting that the schedule assumes the rate never changes. If your loan has a fixed period followed by a variable rate, the payment after the fixed period could rise or fall, and the original total interest figure will no longer hold. Read the rate terms before relying on a schedule that runs to the end of the loan.

A short practical routine

Before signing, run the loan through the calculator and write down four numbers: monthly payment, total paid, total interest, and the first payment's principal slice. Then run the same loan over a shorter term and compare total interest; the difference is the price of the lower monthly payment. If you can afford extra payments, test what a modest monthly overpayment does to the total interest and the payoff date, and check with the lender that overpayments reduce principal without penalty.

Revisit the schedule once a year. Check your actual balance against the scheduled balance, confirm that extra payments were applied to principal, and update the figures if the rate has changed. A schedule you never check is just a piece of paper; a schedule you check annually is a plan.

For comparing different borrowing shapes, the Mortgage Calculator adds property costs to the picture, the Compound Interest Calculator shows how interest compounds in the other direction when you save, and the Simple Interest Calculator contrasts the simpler case. For more on calculating percentages correctly, see How to Calculate Marks Percentage Correctly Every Time.

The takeaway

Amortisation is front-loaded interest by design: early payments mostly service interest, later payments mostly clear principal. Knowing that shape helps you judge loan length honestly, see why early extra payments matter most, and compare loans by total cost rather than by monthly payment alone.