Skip to content

Loan Repayment Calculator with Prepayment & Schedule (India)

By
About the author
Vishvas YadavFounder, HR Calcy

Founder of HR Calcy and an independent HR and payroll consultant with 16+ years in Indian HR and payroll. PGDM in Human Resources from XLRI Jamshedpur, ISO 9001:2015 and ISO 27001:2022 Lead Auditor, with HR and payroll software implementations for multinational companies across several countries. Advises on payroll and statutory compliance, labour law (PF, ESI, CLRA, gratuity and bonus) and wage structuring. Based in Bengaluru, Karnataka.

View full profile
Loan Repayment CalculatorSchedule · Payoff date
With prepayment
₹50,000₹1 crore
5%24%
1 year30 years
Prepayment (optional)
EMI = P × R × (1 + R)N ÷ [(1 + R)N − 1] · Interest each month = balance × R · R = yearly rate ÷ 12 ÷ 100
Repayment Summary
Enter the loan amount, rate and term, and your EMI and repayment schedule appear here.
Home loan? Year-wise interest and tax deduction
Note: Worked out on a monthly reducing balance at a fixed rate, with the EMI and each month's interest rounded to the rupee and the last EMI adjusted. Your lender's figures may differ slightly because of daily interest, the disbursal date, broken-period interest, charges or a change in a floating rate.

Loan Repayment Calculator: Work out your monthly EMI, total interest and the full repayment schedule for any fixed-rate loan, from a personal loan to a home, car or education loan. Add an extra monthly payment or a lump-sum prepayment, choose whether your lender cuts the tenure or the EMI, and see the interest you save and the month your loan closes. The month-wise and year-wise schedules can be downloaded as a CSV file.

How Loan Repayment Is Calculated

Most loans in India are repaid in equal monthly instalments (EMIs) on a reducing balance. Each EMI first pays the interest for the month on the balance still owed; the rest of the EMI repays principal.

EMI = P × R × (1 + R)N ÷ [(1 + R)N − 1]

P = loan amount, R = monthly rate (yearly rate ÷ 12 ÷ 100), N = number of monthly instalments. Interest for a month = balance at the start of the month × R. Principal repaid = EMI − interest.

Example: ₹5,00,000 at 10% a year for 5 years (60 EMIs). R = 10 ÷ 12 ÷ 100 = 0.008333, so the EMI is ₹10,624.

EMI no.EMIInterestPrincipalBalance
1₹10,624₹4,167₹6,457₹4,93,543
2₹10,624₹4,113₹6,511₹4,87,032
3₹10,624₹4,059₹6,565₹4,80,467
60 (last)₹10,593₹88₹10,505₹0
Total₹6,37,409₹1,37,409₹5,00,000

Interest falls every month because the balance falls, so more of each EMI goes to principal over time. The last EMI is slightly smaller because each figure is rounded to the rupee.

How the Loan Term Changes Your Total Interest

A longer term lowers the EMI but raises the total interest. For a ₹10,00,000 loan at 12% a year:

TermMonthly EMITotal interestTotal repayment
3 years₹33,214₹1,95,718₹11,95,718
5 years₹22,244₹3,34,677₹13,34,677
7 years₹17,653₹4,82,818₹14,82,818

Stretching the term from 3 to 7 years cuts the EMI by ₹15,561 but adds ₹2,87,100 of interest, about 2.5 times as much. Choose the shortest term whose EMI you can pay comfortably.

Prepayment: Reduce Tenure or Reduce EMI?

A part payment goes straight to principal, so every later month's interest is worked out on a smaller balance. Lenders usually let you either keep the EMI and close the loan earlier, or keep the end date and pay a lower EMI. Here is a ₹10,00,000 loan at 12% for 7 years, with ₹1,00,000 prepaid along with EMI 24:

OptionEMINumber of EMIsTotal interestInterest saved
No prepayment₹17,65384₹4,82,818–
Reduce tenure₹17,65375 (9 fewer)₹4,09,050₹73,768
Reduce EMI₹15,428 from EMI 2584₹4,49,359₹33,459

Reducing the tenure saves more than twice as much interest, because the full EMI keeps attacking the smaller balance. Reducing the EMI suits you when the monthly outgo is the bigger worry. Enter your own figures in the calculator to compare both.

Try your own loan in the calculatorEMI, schedule, payoff date and prepayment savings

Prepayment Charges: What RBI Allows

Under the RBI (Pre-payment Charges on Loans) Directions, 2025, which apply to loans sanctioned or renewed on or after 1 January 2026:

LoanPrepayment charge
Floating-rate loan to an individual for a non-business purpose (home, car, personal, education)None, by any regulated lender, even with co-borrowers
Floating-rate business loan to an individual or micro or small enterpriseNone from commercial banks, Tier 4 urban co-operative banks, upper-layer NBFCs and all-India financial institutions. Small finance banks, regional rural banks, Tier 3 and state or central co-operative banks and middle-layer NBFCs cannot charge on loans up to ₹50 lakh
Fixed-rate loans and other casesAs per the lender's policy, disclosed in the sanction letter, loan agreement and Key Facts Statement

There is no minimum lock-in period before you prepay, whatever the source of the money, and a charge the lender waived earlier cannot be added back at prepayment. For older loans, check your loan agreement or ask your lender.

Which HR Calcy Loan Calculator to Use

You wantCalculator
Full repayment schedule, prepayment savings and payoff dateThis loan repayment calculator
A quick EMI for any loanEMI calculator
Interest paid each year on a home loan, and the tax deductionHome loan interest calculator
A personal loan EMIPersonal loan calculator
A car loan EMICar loan calculator
Gold loan interest and eligibilityGold loan calculator

About This Calculator

How to Use It

  1. Enter the loan amount, the yearly interest rate and the term in years or months. For a running loan, enter today's outstanding balance and the months left.
  2. Pick the month of your first EMI to see the exact closing month.
  3. To plan a prepayment, enter an extra amount every month, a lump sum with the EMI number when you will pay it (once or every year), and whether your lender reduces the tenure or the EMI.
  4. Open the year-wise or month-wise schedule, tap the chart for amounts, and use CSV to download the schedule for Excel.

How the Figures Are Worked Out

The calculator follows a lender's statement: the EMI and each month's interest are rounded to the rupee, interest is charged on the balance at the start of the month, and the last EMI is adjusted so the balance ends at exactly zero. A prepayment is applied after that month's EMI. With "reduce EMI", the EMI is worked out again on the new balance over the months left. The schedules always add up exactly to the totals shown.

Your lender's figures can differ by a small amount because of daily interest, the disbursal date, broken-period interest, processing fees or a change in a floating rate.

Tips to Repay Your Loan Faster

  • Prepay early in the loan, when the balance and the interest on it are highest.
  • Keep the EMI and reduce the tenure when you prepay, if you can afford it.
  • A small extra amount every month adds up: ₹2,000 a month on a ₹10 lakh, 5-year loan at 10.5% closes it 6 months early and saves ₹33,166.
  • If your rate is floating, recheck the schedule when your lender changes the rate.
  • Match the EMI date to your salary credit date so you never miss a payment.

Frequently Asked Questions

What is a loan repayment calculator?

A tool that works out your monthly EMI, total interest and the month-by-month repayment schedule from the loan amount, interest rate and term. This one also shows the payoff date and the interest you save by prepaying.

How is loan repayment calculated?

EMI = P × R × (1 + R)^N ÷ [(1 + R)^N − 1], where R is the monthly rate and N the number of EMIs. Each month, interest is the balance × R, and the rest of the EMI repays principal. A ₹5 lakh loan at 10% for 5 years has an EMI of ₹10,624 and total interest of ₹1,37,409.

Is it better to reduce EMI or tenure after a prepayment?

Reducing the tenure saves more interest. On a ₹10 lakh loan at 12% for 7 years, prepaying ₹1 lakh with EMI 24 saves ₹73,768 if you reduce the tenure, against ₹33,459 if you reduce the EMI. Reduce the EMI only if you need the lower monthly outgo.

Can a bank charge for prepaying a loan?

For floating-rate loans to individuals for non-business purposes, sanctioned or renewed from 1 January 2026, RBI does not allow any prepayment charge. Fixed-rate loans follow the lender's policy, which must be shown in the Key Facts Statement and loan agreement.

What happens if I pay extra on my loan every month?

The extra amount reduces the principal straight away, so the loan closes earlier and you pay less interest. ₹2,000 extra a month on a ₹10 lakh, 5-year loan at 10.5% saves ₹33,166 and closes the loan 6 months early.

How do I find my loan payoff date?

Enter the month of your first EMI. The calculator shows the month of your last EMI, with and without prepayment.

Can I download the repayment schedule?

Yes. Tap CSV to download the month-wise schedule, with EMI, principal, interest, prepayment and balance for every month. It opens in Excel or Google Sheets.

Why is my bank's schedule slightly different?

Banks may charge daily interest, add broken-period interest for the first month, round differently or change a floating rate during the loan. The difference is usually small.

Does it work for a floating-rate loan?

It assumes the current rate stays the same. When your lender changes the rate, enter the outstanding balance, the new rate and the months left to get the new schedule.

Does using this calculator affect my credit score?

No. It runs in your browser, needs no login and sends nothing to a lender or credit bureau.

Last updated: 22 October 2026 · By Vishvas Yadav, Founder, HR Calcy (XLRI Jamshedpur; 16+ years in HR and payroll) · Source: RBI (Pre-payment Charges on Loans) Directions, 2025