Amortisation schedule with extra payments
Payment by payment: interest and principal, and how much you save and how many months you cut by overpaying monthly or in one go.
Calculator inputs
Results
Enter your values and press “Calculate” to see the result.
| # | Paid | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | 386.66 | 100 | 286.66 | 19,713.34 |
| 2 | 386.66 | 98.57 | 288.09 | 19,425.25 |
| 3 | 386.66 | 97.13 | 289.53 | 19,135.72 |
| 4 | 386.66 | 95.68 | 290.98 | 18,844.75 |
| 5 | 386.66 | 94.22 | 292.43 | 18,552.32 |
| 6 | 386.66 | 92.76 | 293.89 | 18,258.42 |
| 7 | 386.66 | 91.29 | 295.36 | 17,963.06 |
| 8 | 386.66 | 89.82 | 296.84 | 17,666.22 |
| 9 | 386.66 | 88.33 | 298.32 | 17,367.89 |
| 10 | 386.66 | 86.84 | 299.82 | 17,068.07 |
| 11 | 386.66 | 85.34 | 301.32 | 16,766.76 |
| 12 | 386.66 | 83.83 | 302.82 | 16,463.94 |
| 13 | 386.66 | 82.32 | 304.34 | 16,159.6 |
| 14 | 386.66 | 80.8 | 305.86 | 15,853.74 |
| 15 | 386.66 | 79.27 | 307.39 | 15,546.35 |
| 16 | 386.66 | 77.73 | 308.92 | 15,237.43 |
| 17 | 386.66 | 76.19 | 310.47 | 14,926.96 |
| 18 | 386.66 | 74.63 | 312.02 | 14,614.94 |
| 19 | 386.66 | 73.07 | 313.58 | 14,301.36 |
| 20 | 386.66 | 71.51 | 315.15 | 13,986.21 |
| 21 | 386.66 | 69.93 | 316.72 | 13,669.49 |
| 22 | 386.66 | 68.35 | 318.31 | 13,351.18 |
| 23 | 386.66 | 66.76 | 319.9 | 13,031.28 |
| 24 | 386.66 | 65.16 | 321.5 | 12,709.78 |
| 36 | 386.66 | 45.33 | 341.33 | 8,724.07 |
| 48 | 386.66 | 24.27 | 362.38 | 4,492.53 |
| 60 | 386.66 | 1.92 | 384.73 | 0 |
| Month | Balance without extra payments | Balance with extra payments |
|---|---|---|
| 0 | 20,000 | 20,000 |
| 1 | 19,713.34 | 19,713.34 |
| 2 | 19,425.25 | 19,425.25 |
| 3 | 19,135.72 | 19,135.72 |
| 4 | 18,844.75 | 18,844.75 |
| 5 | 18,552.32 | 18,552.32 |
| 6 | 18,258.42 | 18,258.42 |
| 7 | 17,963.06 | 17,963.06 |
| 8 | 17,666.22 | 17,666.22 |
| 9 | 17,367.89 | 17,367.89 |
| 10 | 17,068.07 | 17,068.07 |
| 11 | 16,766.76 | 16,766.76 |
| 12 | 16,463.94 | 16,463.94 |
| 13 | 16,159.6 | 16,159.6 |
| 14 | 15,853.74 | 15,853.74 |
| 15 | 15,546.35 | 15,546.35 |
| 16 | 15,237.43 | 15,237.43 |
| 17 | 14,926.96 | 14,926.96 |
| 18 | 14,614.94 | 14,614.94 |
| 19 | 14,301.36 | 14,301.36 |
| 20 | 13,986.21 | 13,986.21 |
| 21 | 13,669.49 | 13,669.49 |
| 22 | 13,351.18 | 13,351.18 |
| 23 | 13,031.28 | 13,031.28 |
| 24 | 12,709.78 | 12,709.78 |
| 25 | 12,386.67 | 12,386.67 |
| 26 | 12,061.95 | 12,061.95 |
| 27 | 11,735.6 | 11,735.6 |
| 28 | 11,407.62 | 11,407.62 |
| 29 | 11,078 | 11,078 |
| 30 | 10,746.74 | 10,746.74 |
| 31 | 10,413.82 | 10,413.82 |
| 32 | 10,079.23 | 10,079.23 |
| 33 | 9,742.97 | 9,742.97 |
| 34 | 9,405.03 | 9,405.03 |
| 35 | 9,065.4 | 9,065.4 |
| 36 | 8,724.07 | 8,724.07 |
| 37 | 8,381.03 | 8,381.03 |
| 38 | 8,036.28 | 8,036.28 |
| 39 | 7,689.81 | 7,689.81 |
| 40 | 7,341.6 | 7,341.6 |
| 41 | 6,991.65 | 6,991.65 |
| 42 | 6,639.95 | 6,639.95 |
| 43 | 6,286.5 | 6,286.5 |
| 44 | 5,931.27 | 5,931.27 |
| 45 | 5,574.27 | 5,574.27 |
| 46 | 5,215.49 | 5,215.49 |
| 47 | 4,854.91 | 4,854.91 |
| 48 | 4,492.53 | 4,492.53 |
| 49 | 4,128.34 | 4,128.34 |
| 50 | 3,762.32 | 3,762.32 |
| 51 | 3,394.48 | 3,394.48 |
| 52 | 3,024.79 | 3,024.79 |
| 53 | 2,653.26 | 2,653.26 |
| 54 | 2,279.87 | 2,279.87 |
| 55 | 1,904.62 | 1,904.62 |
| 56 | 1,527.48 | 1,527.48 |
| 57 | 1,148.46 | 1,148.46 |
| 58 | 767.55 | 767.55 |
| 59 | 384.73 | 384.73 |
| 60 | 0 | 0 |
See the working step by step
- Interest without extra payments = 3,199.36; with them = 3,199.36
In short
- What it calculates
- Payment by payment: interest and principal, and how much you save and how many months you cut by overpaying monthly or in one go.
- Formula used
Payment = P · i / (1 − (1 + i)^−n) with i = annual rate / 12- Example
- Example 1. The loan with no extras.
Loan amortisation schedule
An amortisation schedule shows what the payment hides: in the early years you mostly pay interest and the balance falls very slowly. That is what makes overpaying early so rewarding.
Enter the loan and, if you like, an extra monthly payment or a one-off lump sum. You will see the schedule payment by payment, how much interest you save, how many payments you cut and, in a chart, how the balance falls with and without the extra payments. Everything runs in your browser.
How it works
Each month the interest is calculated on the outstanding balance. The difference between what you pay and that interest is what you actually repay, and it is subtracted from the balance. As the balance falls, each payment carries less interest and repays more principal.
An extra payment goes entirely to reducing the principal. With the balance lower sooner, the interest of every later month is smaller and the loan is paid off earlier than planned. The calculator keeps the payment and shortens the term, which is the option that saves the most interest.
Formula
Payment = P · i / (1 − (1 + i)^−n) with i = annual rate / 12
Monthly interest = balance × i
Month’s payment = payment + monthly extra (+ one-off in its month), capped at what is owed
Principal repaid = month’s payment − monthly interest
New balance = balance − principal repaid
Interest saved = interest without extras − interest with extras
Worked example
Example 1. The loan with no extras.
$20,000 at 6% over 60 months: payment $386.66, total interest $3,199.36. The first payment carries $100 of interest and $286.66 of principal; the last, $1.92 of interest and $384.74 of principal.
Example 2. An extra $100 a month.
With $100 more each month, the loan is paid off in 47 payments instead of 60: thirteen fewer. Total interest falls to $2,444.38 and you save $754.98.
Example 3. A $5,000 lump sum in month 12.
With a single $5,000 extra repayment at payment 12, the loan ends in month 45 and you save $1,120.11 of interest, more than with the $100 a month, which adds up to $4,700 over those 47 months.
Example 4. A mortgage.
$150,000 at 3.2% over 360 months: payment $648.70 and total interest $83,532. With $200 extra each month it is paid in 240 payments, ten years early, and you save $30,417 of interest.
Explanation
Why it is almost all interest at the start
Each month’s interest is calculated on the outstanding balance, which at the start is the whole loan. The payment is constant, so when interest is high, little is left to repay principal. Over the years the balance falls, interest shrinks and the amortising part grows.
Extra payments: how much they save
Every pound you repay early avoids the interest it would have generated over the rest of the loan. So:
- Repaying **early** saves far more than doing it at the end.
- A big **one-off** payment and a small **monthly** one can save about the same; what counts is how much principal you remove and when.
- The higher the interest rate, the bigger the saving.
Shorten the term or lower the payment
When you overpay, most lenders let you choose between keeping the payment and shortening the term, or keeping the term and lowering the payment. This calculator keeps the payment and shortens the term, which saves the most interest. Lowering the payment gives more breathing room month to month but saves less.
Common mistakes
- Forgetting the early-repayment charge in the contract.
- Overpaying with money you need as an emergency cushion.
- Comparing the interest saved without considering what you would earn by investing that money.
- Thinking a constant payment means constant interest.
Limits of this calculator
- It assumes a constant-payment loan at a fixed rate; it does not model variable rates or payment holidays.
- It does not include any early-repayment charge your lender may apply.
- The first 24 payments are shown, then yearly checkpoints, to keep the table readable.
- An extra payment always goes to principal and keeps the payment; it does not compute the option of lowering the payment.
Notice
This is an estimate. Check the official schedule in your contract and the early-repayment terms with your lender.
Frequently asked questions
Why is it almost all interest at the start?
Because interest is charged on the outstanding balance, which at the beginning is the full loan. With a constant payment, little is left to repay principal at first.
Is it worth overpaying early?
Yes. The sooner you cut the principal, the less interest accrues on every later payment, and the saving is bigger.
Which is better, a monthly extra or a lump sum?
It depends on your cash. For the same principal repaid, sooner saves more. A big lump sum early on saves more than small amounts spread over years.
Should I shorten the term or lower the payment?
Shortening the term saves more interest. Lowering the payment eases your monthly budget but keeps the loan going longer. Choose according to your situation.
How does the calculator work out the interest saved?
It subtracts the interest of the loan with extra payments from that of the loan without them, always keeping the same payment.
Is there a charge for repaying early?
It depends on the contract. Many personal loans and some mortgages charge one; this calculator does not include it, so subtract it from the saving to see whether it pays off.
Why are only the first 24 payments shown?
To keep the table readable: after that, each year’s closing balance is shown.
Is my data sent to a server?
No. The calculation runs in your browser.
Sources and references
The formula behind this calculator is not ours. These are the sources it comes from, in APA 7 format, in case you want to go to the original or cite them in your own work.
- Brigham, E. F., & Houston, J. F. (2019). Fundamentals of financial management (15.ª ed.). Cengage Learning. Constant payment and amortisation schedule of a loan.
Need to calculate something else?
These tools are often used alongside this calculator.
Loan
Monthly payment, total interest, APR with fees and insurance, and how principal and interest split each year.
Mortgage
Monthly payment, total interest and the cash you need upfront to buy a home.
Compare loans
Compare two offers for the same amount: payment, APR, total cost, which is cheaper if you repay early and…
Monthly payment
Instalment amount when the term is quoted directly in months.
Compound interest
How much your money grows with regular contributions, and what it is really worth once inflation and fees…
Discount
Final price after a discount and exactly how much you save.