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:

Automatically Analyze 820+ Stocks in Excel
You are interested to know if your stock is worth investing? You can use my MS EXCEL based tool to analyze it like a pro. You need not do any data entry. Just pick stock from a list and click a buttons. The report is generated automatically. Try my stock analysis worksheet >> Read testimonials.



nv-author-image

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 adieu....read more

Leave a Reply

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