Calculator to Reduce Loan EMI: How to use it?

Prepayment of loan can directly lowers the principal amount. If one keeps the tenure unaltered, lowering of principal amount will directly lower the EMI.

This is the way one can make a prepayment and save money. In order to understand how much EMI can be reduced by prepayment, I am providing here an excel based calculator. You can download it from here.

In this article, I’ll explain how one can use this calculator and estimate the potential savings from making a prepayment.

How to use this excel sheet?

  • Step #1 – Enter loan details like this:
Calculator to Reduce Loan EMI - Enter Data Here
  • Step #2 – Enter prepayment details. Suppose loan prepayment of Rs.10,000 in 13th month. Lets see how this data entry (related to loan prepayment) is made in this excel sheet:
Calculator to Reduce Loan EMI - lower EMI months
  • Step #3 – Just note the reduced EMI due to prepayment:
Calculator to Reduce Loan EMI - Compare EMI
  • Step #4 – Note the saving made due to prepayment. There are two clear benefits of prepayments: (1) It reduces EMI, and (2) It also saves some over time.
Calculator to Reduce Loan EMI - Savings

If you will compare the saving achieved due to “tenure reduction” and “EMI reduction”, the clear winner will be tenure reduction. But the reality is not like this. Read this detailed blog post on loan prepayment for EMI reduction.

Check this free online home loan prepayment calculator:

Analyze Stocks Like a Pro: If you’re looking to analyze Indian stocks, don’t miss out on our Stock Engine tool! It is our in-house developed tool with powerful screening and analysis capabilities. Use the tool to make informed decisions and stay ahead of the game. Take advantage of this invaluable resource!


Hi. I’m Mani, I’m an Engineering graduate who in pursuit of financial independence, has converted into a full time blogger. After working in the corporate world for almost 16+ years, I bid it more

Leave a Reply

Your email address will not be published. Required fields are marked *