1. Home
  2. Calculators
  3. Loan Prepayment Calculator

Loan Prepayment Calculator

Find out how much a lump sum or a small monthly top-up cuts from the interest on a loan.

Free, no sign-up. Runs in your browser: nothing is uploaded.

How to use Loan Prepayment Calculator

  1. Enter your numbers, or press a sample to see an example.
  2. Read the results and the table under them.
  3. Copy the results or download the table as a CSV file.

Features

  • One-time part-payment at any month
  • Extra payment every month
  • Shorten the loan or lower the instalment
  • Months and interest saved
  • Instalment before and after

Supported formats

Input

  • Typed numbers

You get

  • On-screen results
  • CSV

Private by design

Everything you enter is processed by your browser on this device. Nothing is sent to openWorkstand or anyone else, so the Loan Prepayment Calculator is safe for private and work data. After you have used it once while online, it also works without an internet connection. How local processing works

Good to know

  • The interest rate is assumed fixed; floating-rate changes are not modelled.
  • Prepayment charges are not included.

Guide

Prepaying a loan: shorten the tenure or lower the instalment, and what each saves

A loan’s interest is a charge for each month that a balance is outstanding. Pay part of the balance off early and you remove interest for every month that remains. That is why prepayment can be so effective, and why people with a bonus or a spare sum often ask whether to put it into the loan. This calculator shows the exact effect, whether you pay once or a little every month.

What happens to the loan

Each month interest equals the balance × the rate ÷ 12, the instalment is paid, and the rest of the instalment reduces the balance. A part-payment removes a lump sum from the balance at the time you choose. After that you can either keep paying the same instalment, in which case the loan ends sooner, or ask the lender to recalculate a smaller instalment over the original number of months. The page models both, and an extra amount each month for the first.

A worked example

The default loan is 30,00,000 at 8.75% with 240 months left, so the instalment is 26,511.32 and the interest over the life is 33,62,717. A part-payment of 3,00,000 now, with the instalment kept, ends the loan in 15 years 7 months, 53 months early, with 22,52,370 of interest, a saving of 11,10,347. Instead of the lump sum, an extra 5,000 a month brings the instalment to 31,511.32, ends the loan in 13 years 8 months, 76 months early, and saves 12,23,856 of interest. If you keep the end date and ask for a lower instalment after a 3,00,000 payment at month 24, the instalment becomes 23,748.65 and the saving is 2,96,737.

Shorter loan or smaller instalment

Keeping the instalment is the bigger saver because you continue to pay at the old rate and remove principal faster. Lowering the instalment gives immediate relief to your monthly budget, but you go on paying interest for the full term, so the saving is much smaller: 2.97 lakh against 11.10 lakh in the sample. If your cash flow is comfortable, shortening the loan wins; if it is tight, the lower instalment keeps you safe.

Timing

The earlier the money goes in, the more it saves. Because the first years of an amortising loan are mostly interest, a part-payment in year one removes the most. Use the month field to test paying at month 12, 24 or 60 and watch the saving fall. A small extra amount paid every month from the start can beat a larger lump sum made much later.

Edge cases

A part-payment equal to or larger than the balance is rejected, because it would simply close the loan. A part-payment of zero with an extra monthly amount models regular top-ups alone. Months left up to 600 are accepted. The final instalment is smaller when the balance is nearly cleared.

Limits

The rate is assumed fixed. On a floating-rate loan the rate may change, and some lenders adjust the instalment rather than the term, so confirm how yours behaves. Prepayment charges, taxes and the opportunity cost of using the money, which might have earned a return elsewhere, are not included.

Checked against the current version of the Loan Prepayment Calculator on .

Troubleshooting

The download did not start

Look for your browser’s download bar or icon. Some browsers ask once before a site may download files; allow it and click the button again.

Frequently asked questions

Why does the page ask for a month number?

Because the same part-payment saves less the later it is made. Interest is charged on the balance each month, so money that reduces the balance in month 1 avoids interest for 239 more months, while the same money in month 120 avoids it for 120. Setting the month to 0 means paying before the next instalment.

Is the extra monthly amount added to the instalment?

Yes, in the keep-the-instalment case. Each month you pay the normal instalment plus the extra, and the whole of the extra goes to principal. In the lower-instalment case the extra is not used because the instalment is recalculated for the original end date.

Is it better to reduce the EMI or the tenure?

Shortening the tenure saves more interest because you keep paying the larger amount. Lowering the EMI gives you breathing room each month.

Do lenders charge for prepayment?

Floating-rate home loans for individuals usually have none in India, but fixed-rate and business loans may. Check your loan agreement.

Keep working with the result

After you download, choose “Save to Workstand” to keep the result in a folder on your computer, attach it to a project and create a follow-up task. It is saved by your browser, not uploaded.