Loan Prepayment Calculator formula — how it actually works
A loan prepayment calculator is not guessing. It runs the same amortisation maths your lender uses, month by month: it works out the EMI from the loan amount, the rate and the tenure, then walks through the loan month by month, splitting each EMI into interest and principal, until the balance reaches zero. A prepayment is just one extra step in that walk — the balance drops by the prepayment amount in that month, and everything after it is recalculated.
The EMI formula
The EMI comes from the standard formula. With P as the loan amount, r as the monthly interest rate (the annual rate divided by 12) and n as the number of months, EMI = P × r × (1 + r)ⁿ ÷ ((1 + r)ⁿ − 1). The monthly rate is the annual rate divided by 12, not by 12 with any other adjustment — a detail that matters, because using the annual rate as the monthly rate would make the EMI twelve times too large.
Worked example — the EMI by hand
Take a loan of ₹10,00,000 at 10% a year for 10 years. The monthly rate r is 0.10 ÷ 12 = 0.008333, and n is 120 months. (1 + r)¹²⁰ is 2.707. So EMI = 10,00,000 × 0.008333 × 2.707 ÷ (2.707 − 1) = 10,00,000 × 0.008333 × 2.707 ÷ 1.707, which is ₹13,215 a month. That is the figure the calculator uses as its starting point.
How the prepayment is applied
Each month, the calculator charges interest on the balance — balance × r — and the rest of the EMI pays down the principal. In the first month of that loan, interest is 10,00,000 × 0.008333 = ₹8,333, so ₹4,882 of the ₹13,215 EMI goes to principal and the balance falls to ₹9,95,118. Month by month the interest part shrinks and the principal part grows.
A prepayment is applied after that month’s EMI: the balance drops by the prepayment amount in one step. After 12 months the balance is ₹9,38,658; pay ₹1,00,000 extra and it becomes ₹8,38,658. The EMI stays ₹13,215, so the loan now needs only 91 more months instead of 108, total interest falls from ₹5,85,809 to ₹4,57,011, and ₹1,28,798 is saved.
EMI = P × r × (1 + r)ⁿ ÷ ((1 + r)ⁿ − 1) r = 0.10 ÷ 12 = 0.008333, n = 120 EMI = 10,00,000 × 0.008333 × 2.707 ÷ 1.707 = ₹13,215 Month 1: interest ₹8,333, principal ₹4,882 After 12 months: balance ₹9,38,658 Prepay ₹1,00,000 → balance ₹8,38,658 Remaining: 91 months (was 108); saved ₹1,28,798
At a glance
Loan balance over time on the ₹50,00,000 home loan at 9%. Without a prepayment the balance falls slowly at first; with ₹5,00,000 prepaid in year 2 it drops in one step and reaches zero about 4 years sooner.
The mistake to avoid
The common mistake is to treat the prepayment as if it came off the interest first. It does not: a prepayment comes off the principal, the balance. That is exactly why it saves so much — it cuts the amount on which all future interest is charged. If you instead subtracted it from the total interest, you would understate the saving by a wide margin.
This is general information about how prepayment maths works, not financial advice. Rates and charges vary by lender; check your loan agreement before paying extra.
Frequently asked questions
What is the EMI formula?
EMI = P × r × (1 + r)ⁿ ÷ ((1 + r)ⁿ − 1), where P is the loan amount, r is the monthly interest rate (annual rate ÷ 12) and n is the number of months. For ₹10,00,000 at 10% for 10 years, that gives ₹13,215.
How is the monthly rate worked out?
Divide the annual rate by 12. A 10% annual rate is 0.10 ÷ 12 = 0.008333 a month. Never use the annual rate as the monthly rate — that would make the EMI about twelve times too large.
Where does the prepayment go in the calculation?
Straight off the balance, after that month’s EMI. It does not come off the interest. Cutting the balance is what cuts all the future interest.
Why does the calculator walk through the loan month by month?
Because the interest each month depends on the balance that month, and the balance changes every month. There is no single-step shortcut that gives the exact saving — the month-by-month schedule is the calculation.
More guides on the Loan Prepayment Calculator
- How to use the Loan Prepayment Calculator — step by step
- Loan Prepayment Calculator explained with worked examples
- Loan Prepayment Calculator for beginners — start here
- Common mistakes people make with the Loan Prepayment Calculator
- Loan Prepayment Calculator vs doing it by hand — which is faster?
- loan prepayment calculator — the complete guide
- How to get an accurate result from the Loan Prepayment Calculator
- Loan Prepayment Calculator for students — with examples
- Loan Prepayment Calculator for homeowners and DIYers
A free calculator that shows how much interest a prepayment saves and how many months it cuts from your loan.