How this calculation works
A lump-sum prepayment reduces the outstanding loan principal after your scheduled instalments. This comparison uses the same prepayment for two choices: lower the monthly EMI while keeping the original end date, or keep paying the original EMI and finish earlier. Compare the monthly relief against the interest saved and check the lender’s treatment of part payments before choosing a plan.
Worked example
This example uses illustrative inputs. Your current result is shown above.
Start with a ₹40,00,000 loan at 8.5% annual reducing-balance interest for 20 years. Its EMI is about ₹34,712.93. After 36 monthly payments, the balance is approximately ₹37,39,440.34. A ₹5,00,000 prepayment reduces it to ₹32,39,440.34. Keeping the original end date lowers the remaining EMI to about ₹30,071.47; keeping the original EMI shortens the remaining term from 204 to about 154 months, saving 50 months.
Assumptions and limits
- This comparison uses a monthly reducing-balance loan with a constant annual rate.
- The prepayment happens immediately after the selected scheduled monthly instalment; the amount cannot exceed the outstanding balance.
- Prepayment charges, switching fees and tax effects are excluded. Check the loan agreement and applicable lender rules before making a payment.
Questions people ask
Does reducing EMI or reducing tenure save more interest?
For the same constant-rate loan and prepayment, continuing the higher original EMI normally repays principal faster and saves more interest. A lower EMI instead reduces the immediate monthly obligation. The two result columns show that trade-off.
What does prepayment timing mean?
It is the number of scheduled monthly payments already made before the lump sum is applied. A timing of 36 months means the extra payment is made just after instalment 36, not at the start of the loan.
Can I enter the full original loan amount as a prepayment?
Use the balance still outstanding at that time. Scheduled payments have already repaid some principal, so a later prepayment cannot be greater than the remaining balance. Paying that remaining balance closes the loan in the model.
Are bank prepayment charges included?
No. Eligibility for charges depends on the agreement and applicable rules, including the loan’s rate type and purpose. Add any permitted charges to your real-world comparison before deciding whether the saving is worthwhile.