Loan Prepayment Calculator

See how much interest and time you save by prepaying your loan

How many monthly payments have you made so far?
Lump sum amount you want to pay additionally
Excel courseLearn Excel from beginner to confident userthe Udemy course by Ajay Anand, 7× Microsoft Excel MVPView the course →
Total interest saved
—
—
Without prepayment
Remaining months—
Remaining interest—
Total outgo—
After prepayment
New tenure—
Interest paid—
Total outgo—

Prepayment Tips

When is the best time to prepay?

Early in the loan tenure. In the early years, most of your EMI goes toward interest. Prepaying in years 1–5 of a 20-year home loan saves dramatically more interest than prepaying in years 15–18.

Prepay vs invest — which is better?

If your loan rate is 8.5% and you can earn 12% in equity mutual funds, investing gives a higher return. However, the debt-free peace of mind has real value. A common strategy: prepay if the loan rate is above 9%, invest if below 8%.

Free tutorialsFree Excel tips & tutorials at XLnCADstep-by-step guides by a 7× Microsoft Excel MVPVisit xlncad.com →

Master Excel & Google Sheets

These calculators give you quick answers — but building them yourself in a spreadsheet is a real superpower. Learn Excel from the basics to confident, everyday use in my top-rated Udemy course.

Start the Excel course →