Change language

Finance

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.

Published by SolucionesAhora.com How we verify

Calculator inputs

  1. Enter your figures, or press “See example” to watch it work.
  2. If your case is unusual, open “Advanced options”.
  3. Read the result and, below it, what it means and how it was worked out.

The amount you borrow, not counting fees. It is the balance you start from in the first month.

The contract’s nominal annual interest rate. Each month one twelfth is applied to the outstanding balance.

Number of monthly payments in the contract. To convert years to months multiply by 12 (five years = 60).

Up to 600 months

Advanced options

What you add to the payment every month. All of the extra goes straight to reducing the principal, so the loan ends sooner and you pay less interest.

Optional

A single additional payment (a bonus, an inheritance…). If your contract charges for early repayment, that fee is not included.

Optional

In which payment you make the one-off repayment. The sooner you do it, the more interest you save.

Payment number

See the result

Results

Monthly payment386.66
Total interest3,199.36
Total paid23,199.36
Payments until paid off60
Interest saved by the extra payments0
Payments you save0
Amortisation schedule
#PaidInterestPrincipalBalance
1386.66100286.6619,713.34
2386.6698.57288.0919,425.25
3386.6697.13289.5319,135.72
4386.6695.68290.9818,844.75
5386.6694.22292.4318,552.32
6386.6692.76293.8918,258.42
7386.6691.29295.3617,963.06
8386.6689.82296.8417,666.22
9386.6688.33298.3217,367.89
10386.6686.84299.8217,068.07
11386.6685.34301.3216,766.76
12386.6683.83302.8216,463.94
13386.6682.32304.3416,159.6
14386.6680.8305.8615,853.74
15386.6679.27307.3915,546.35
16386.6677.73308.9215,237.43
17386.6676.19310.4714,926.96
18386.6674.63312.0214,614.94
19386.6673.07313.5814,301.36
20386.6671.51315.1513,986.21
21386.6669.93316.7213,669.49
22386.6668.35318.3113,351.18
23386.6666.76319.913,031.28
24386.6665.16321.512,709.78
36386.6645.33341.338,724.07
48386.6624.27362.384,492.53
60386.661.92384.730
See the working step by step
  1. Interest without extra payments = 3,199.36; with them = 3,199.36
Free, no sign-up! What if you could do this without a calculator? A five-minute game with challenges, lives and points. It clicks even when you cannot be bothered.

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.

  1. 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.