Home Loan Prepayment Calculator – Free

Today after years of painstaking focus and persistence of my family, we are finally debt free.

There is no home loan. In fact, there are NO loans any more. It is a different life.

I have still not earned the tag of being a middle-aged-man, and see, I am debt free!

I dreamt of this phase of life and it has finally come true.

What made it happen?

It will like an overstatement to say that my home loan prepayment calculator made it possible.

But this is also true that 5 years back, it all started with it.

Loan prepayment Calculator…

When I was first building this calculator on my excel sheet, I knew that this is going to be the most utilitarian excel sheet I have used till now.

Today this one excel sheet changed my life.

Later on my brother went ahead and converted the excel to an online prepayment calculator.

Check this link to access the free online loan prepayment calculator

Ever since then, this one blog post has helped many readers to understand the concept and necessity of loan prepayment.

So the idea is to strive to become debt free in life as early as possible. And, a tool like my home loan prepayment calculator will help you do just that.

#1. The Interest Burden

Interest paid by the borrower is the profit for the banks. Banks would like us to continue paying interest till eternity.

It is in our benefit that we shall find ways to reduce OUR interest burden. And we can do it only if we get aware of it.

We are providing here an EMI calculator with home loan prepayment functionality enabled.

We try to provide you the best loan calculator. What makes a loan calculators best for its users?

A loan calculators utility is substantially enhanced by incorporating the functionality of prepayment (also called part payment).

But this is not all, you get something more valuable in this blog post.

This blog not only offers a good home loan prepayment calculator, but it also provides a researched, in depth write up.

This blog explains in detail the concept & benefits of home loan prepayment.

One can save large sums of money if prepayment is done timely. Hence this blog has been prepared with objective of making its readers more knowledgeable about the concept of loan prepayment.

Though the title talks about home loan prepayment, but the concept of prepayment can be used with any loan.

We strongly believe that home loan prepayment is the most effective tool available for common men which can eventually make them financially very stable.

When we developed this prepayment calculator in year 2013, only a handful websites used to offer prepayment calculator online. But now, almost all banks offer loan calculators with a prepayment option.

Why use a prepayment calculator?

Prepayment calculators helps in estimation of potential savings. Exemplifications coupled with a great software makes this home loan calculator a rare find on internet.

Lets try to understand the utility of loan prepayments.

Lets take an example. Suppose one took home loan with tenure of 20 years. In this tenure total interest payable will be 1.4 times of principal (@10.5% p.a.). Means, if home loan is $100,000, total interest payable will be $140,000. Total payment to be made by the borrower will be $100,000+$140,000 = $240,000.

So whats the problem, if we take loan we must pay the interest. Whats the big deal?

The big deal is in the interest burden.

One took loan of $100,000. Repayment of these $100,000 is not a problem. The problem is with the interest payment. In our example the interest payment was 1.4 times that of the loan amount.

All of $140,000 that one pay as interest is EXTRA COST. We must do everything to reduce this extra cost burden.

So, it is important to understand this concept that we cannot take home loan and keep paying its EMI’s for year together just like that. It is in our interest to THINK and form a strategy of how we can reduce our interest burden.

If we can use use a good home loan prepayment calculator, we can plan to save huge amount of money in interest component of the loan.

Home loan prepayment calculator provided here can help us to both visualize the problem & save lots of money in interest.

Utility of home loan prepayment calculator

What this calculator does best is make people aware about the potential savings they can ensure with every dollar of prepayment.

But why I am so crazy about loan prepayments (some banks also call it part-payment of loan)?

The worse part of interest payments is that, even it we continue paying interest for next 100 years, the loan burden will not reduce even by one dollar.

It is important to realize that we must pay-off principal portion of loan as soon as possible.

There are two components of any loan. One part is principal & second part is interest. Till we pay-off principal, interest expense will continue to incur month after month.

We can continue to pay interest all our life, but loan will never finish. Without clearing principal component of loan, the loan never gets paid.

When we pay EMI, major portion of EMI is used to pay interest. Another portion is used to pay principal. As banks priority is to earn interest, they will never like you to prepay you loans.

But we must plan a way to pay more principal. How it is possible?

The solution lies in the prepayment of loans.

Lets see an example…

Suppose one takes loan of Rs 100,000 for 5 years @ 15% per annum interest. His monthly EMI will be close to Rs 2,382. Total interest to be paid in 5 years is Rs 42,920. Total amount returnable to bank is Rs 100,000 + 42,920 in 5 years.

If he prepays the loan after 6th month itself, he paid just Rs 4,436 in interest (in place Rs 42,920). This is a huge saving.

Its true that clearing a 5 year loan in just 6 months is very difficult. But what is important to visualize here that what is the SAVING POTENTIAL.

If in a loan of one lakh Rupees, we can save approx. Rs.40,000, Imagine what will be the saving if loan amount is Rs.50 lakhs?

Is there a right time to prepay home loans?

Purpose of home loan prepayment is to save the interest component. Interest load is maximum in initial months. Hence loan prepayments made in initial months saves the most amount of money.

The earlier we start home-loan-prepayment the better.

Interest burden is maximum in initial months. Interest then gradually falls in later months.

Lets visualize how interest & principal component of loan varies with time.

In initial years, principal component is maximum. Principal maximum means chargeable interest will be maximum. This is why in initial years, majority of our EMI is consumed to pay interest.

emi calculator with prepayment of loan

Example of loan payment in initial years…

Suppose one took a home loan of Rs 30 Lakhs @ 10.5% for 20 years.

  • In the first year sum of all EMI’s would be approx. Rs 2,10,000
  • Out of this Rs 2,10,000 only Rs 26,600 will used to pay loan principal.
  • Balance Rs 1,83,400 is used only to pay interest.

So how does LOW principal payment impact us?

Low principal payment means higher loan outstanding balance. High loan balance means higher interest to be paid in next EMI’s.

Already thinking how to reduce loan outstanding….?

If we pay only EMI, we have no possibility to save interest. By loan prepayment we can pay-off principal component faster. By making prepayment we pay additional sums of money above EMI.

Prepayment allows us to pay principal faster. Each payment made, in addition to scheduled EMI, goes as prepayment.

How effective are online home loan prepayment calculators?
These calculators helps us to visualize how much can we saved because of prepayment. This motivates people to practice loan prepayment.

On internet there are great loan prepayment calculators launched every day. It means people are becoming more aware about the concept of loan prepayment.

home loan emi calculator with prepayment

How EMI’s on Home Loan is calculated?

The formula for EMI calculation is:

E = EMI
P = Principal
r = monthly rate of interest (Interest is 10.5% it means r = 10.5/12/100 =0.00875)
n = time in months

Example: home loan of Rs 30,00,000 at rate of 10.5% per annum for a period of 20 years (240 months). EMI will be:
E = 30,00,000 x 0.00875 x [(1+0.00875)^240 / {(1+0.00875)^240}-1} = Rs 29,951 per month for next 20 years.

Prepayment of home loan is always a better choice?

No not always.

There are cases when prepayment cannot take top priority.

If there are other opportunities that gives higher returns, then loan prepayment will take a second priority.

Confused? Let me explain…

How to decide if extra money in hand shall be used for prepaying loans or to be used elsewhere ? Here is a way out….

Rule says, pay your costlier debts first before making any investment. But what if you know that your investment is going to give you very high returns? In this case the call will be based on numbers…how?

Suppose you you are investing in an index funds, then probably your long term return will be close to 12% per annum (leave aside risk factors).

Compare this return with your home loan interest rate. If home loan interest rate is higher than 12%, then prepay your home loan first.

When home loan interest falls below 12%, even them home loan shall be paid?

In most cases, YES. Why?

The problem is, majority does not know how to handle investment (leave aside equity – index funds)?

My personal preference (for people like me and you) is home loan prepayment. Interest that we save on home loan is ASSURED. Once we make a prepayment, interest saving is assured.

But if the same money in used to buy index funds, are its returns assured? No. Expert investors may give YES as an answer here. But for common men, loan prepayment is a much better alternative.

Interest saving in tune of 10% per annum is phenomenal. At times, even stock market cannot assure such high returns in short term.

home Loan Prepayment

Loan prepayment is common mans way to get rich

Home loan is the biggest-loan an average middle class avails in his life. As home loan amount is big, people often go for longer loan tenure like 20-25 years. In home loan, both loan amount & tenure is big. These two factors makes the interest burden huge.

For example, a home loan of Rs 30 lakhs, for 20 years at rate of 10.5% per annum, interest burden is Rs 42 lakhs. But when home loan of Rs 30 lakhs, is availed only for 15 years at rate of 10.5% per annum, interest burden is only Rs 27 lakhs. When home loan of Rs 30 lakhs, is availed only for 10 years at rate of 10.5% per annum, interest burden is only Rs 19 lakhs.

These type of permutations can be easily done using home loan prepayment calculators.

A Calculation we shall never forget….

As a rule of thumb, a real estate property which yields rental income of 4% per annum is considered a good investment.
Property Value (our cost) = Rs 30 Lakhs
Rental Income in first year = Rs 10,000/month (Rs 120,000/year)
Rental Yield = 120,000/30,00,000 = 4%
But the yield of 4% will happen when we we buy property without taking loan. In this case our our cost is only Rs 30 lakhs.

In case of home loan scenario Rs 30 lakhs is not only our cost. Out total cost is Interest+Principal. Cost will be equal to Rs 30+41.5=71.5 Lakhs. In this case our rental yield will be much lower:
Property Cost (due to loan) = Rs 71 Lakhs
Rental Income in first year = Rs 10,000/month (Rs 120,000/year)
Rental Yield = 120,000/71,00,000 = 1.7%

We can see that due to interest burden, the rental yield gets reduced substantially. The interest burden has made our property investment less lucrative. In order to make our property investment more lucrative, we must decide to prepay our home loan as fast as possible.

Lets see how much interest we can save by making small prepayments

Lets take an example, home loan of say Rs 30,00,000 at rate of 10.5% per annum for a period of 20 years (240 months).

SL EMI (Rs) Extra Payment as prepayment/ month (Rs) Total Interest Paid in Loan Tenure (Rs) Savings (Rs) Years for Loan to be 100% paid
1 29,951 0 41,88,335 0 20
2 29,951 500 39,23,348 2,64,968 19
3 29,951 1000 36,95,405 4,92,929 18.1
4 29,951 1500 34,96,554 6,91,781 17.3
5 29,951 2000 33,21,043 8,67,292 16.5
6 29,951 2500 31,64,653 10,23,681 15.8
7 29,951 3000 30,24,198 11,64,137 15.3
8 29,951 4000 27,81,503 14,06,833 14.3
9 29,951 5000 25,78,476 16,09,860 13.4
10 29,951 10,000 19,07,612 22,80,724 10.3

From this table you can see that, just by making extra payment of Rs 500/month we can save Rs 2.65 lakhs. By making extra payment of Rs 3,000 we can save as high as Rs 11 lakhs in totality. By making those extra payment we are paying nothing extra. We are just prepaying the home loan.

How to plan for prepayment of home loan?

Not many of us has that surplus cash to make a substantial prepayment of home loan. But the difficult part is banks does not accept small amounts of money as prepayment. They want prepayment to be made in multiples of EMI. So if ones EMI is Rs30K, he/she can make prepayment of Rs 30K or its multiples. But making prepayment of Rs30K each month is very difficult. What is the solution?

A better strategy will be to start a parallel saving plan like Recurring deposit. Start a recurring deposit of Rs 3,000 and contribute it till next 10 months. In ten months one will have Rs 30,000 as savings. In the 11th month make the prepayment of Rs 30K. Even such small prepayments of Rs 3,000 per month will make huge long term saving of interest. Prepayment of home loan will also reduce the loan tenure. It means one can plan his/her next real estate investment. [See Tip 6 below]

Before starting of EMI payment towards home loan, always keep a note of two things:
(1) how much total interest you are paying against your loan &
(2) Break-up of principal and interest in each year of your loan payment. As shown in the above chart, interest payment in first few years are maximum and in later years principal portion gradually increases.

So if you are interested to get the dual benefits of prepayment (interest saving and term reduction), then extra payment shall shall start from first few months itself. If you are not making payment in initial years you are actually paying back majority of interest to bank without saving it. If you are making extra payment in later years you will only reduce the loan tenure. Interest saving will be negligible.

Recap of what we learnt about Loan Prepayment

(1) If you would like to make prepayment of your home loan, then start making prepayment from first years itself. You will save heavily on interest the earlier you start.

(2) If you have costlier loans like credit card debt, personal loan etc, pay them first. Idea is to pay costlier debt first before making prepayments

(3) Make sure to declare the interest and principal component of your loan when you fill your income tax return. This can save you a lot on income tax.

(4) As per present directive of RBI, prepayment charges on home loan cannot be charged by any bank. So do not be fooled by banks if they give you discourage you to make prepayment of home loan.

(5) Your prepayment decision should not be delayed. One day a close friend of mine came and told me that he took a home loan of Rs 30 lakhs 4 years back and after paying 48 installments his outstanding principal is still Rs 27 lakhs. He was furious and he wanted to prepay the loan in order to reduce the principal. I immediately advised him to go ahead. If possible, one must start prepayment from the second month itself. We shall not wait for too long to start making prepayment.

(6) Plan to save money each month. Generally banks accept prepayment amount equivalent or multiple of your existing EMI. Put aside a fixed amount each month towards prepayment. When this accumulated savings is equivalent to one EMI, use them to make prepayment.

(7) Every year we get a pay hike. Decide to use 60% of your pay hike in making prepayment.

Take it from me the you will thank yourself thousand times after you have prepaid your home loan in full. Start now.


Disclaimer: All blog posts of getmoneyrich.com are for information only. No blog posts should be considered as an investment advice or as a recommendation. The user must self-analyse all securities before investing in one.

35 Comments on "Home Loan Prepayment Calculator – Free"

  1. Hi Mani, I have 4L cash amount & want to do prepayment for my Home loan where EMI is around 38K from 2014 Onwards.I am thinking to instead prepayemnt to home loan lets start SIP 10 k per month & keep remaining money in max gain account. Any suggestion.Awaiting quick reply. Thanks for your time

  2. Hello,
    As ROI is not constant ,it’s has changed drastically since I borrowed loan,so in that case how to calculate the interest paid with varying ROI and how to calculate the saving made or can make??

  3. Very Good,
    is there any calculator for prepayment

  4. Super sir I read more articles but not as much as u and the explanation is very simple for understanding and post more articles as related to home loans.

  5. Hello,

    Thanks for this info. Can you please add a calculator for floating interest + pre-payment EMI calculator. This above calculator is for fixed interest rate. I know this can be approx calculated. But it would be beneficial for many as the banks have now started reducing ROI for existing customers.
    Thanks

  6. One query, If I have the enough money to prepay in initial months, isn’t it better to invest it in some cumulative FD. Advantages will be
    1) Income tax deduction of 24b would remain
    2) It would absorb the interest paid out with interest earned
    3) Due to cumulative nature it would overtake the interest portion one day and you end up having nil impact of interest paid as the same you received back from back.
    4) Liquidity remains in your hand
    5) 20years of loan @ 10.5% would give you effectively 5-6% of p.a Impact. However an FD by far will give you 7% p.a which will effectively be 7.5% due to cumulative qtrly.
    6) interest will be doubled in 20years wherein your money will be doubled in 8-9 years so by 20 years it would be 4 times of what you kept in FD.

    Happy to take your views…. I personally did this for my home loan and I am happy that this helps me it not to take a hit of interest paid any more as I am getting it back from the banks… more over if you invest it in FD for 5 years it would give you a tax benefit for 80C Plus Interest received will be interest free. For my purpose I I am happy to take Tax hit as principal paid and PF deduction and LIC premiums is filling my 80C so I have no scope for inv in 80C however I am happy to pay tax but to keep money in most liquid form.

    Please share your views..

    • Dear Rahul,
      There cannot be any better justification of loan prepayment than leading a debt free life as soon as possible.
      Thanks,
      Mani

  7. Hello Mani,

    Thank you very much for such a wonderful post,

    I am under process of disbursing the loan amount of 90lacs,

    I have max tenure option is for 28 Years if i go with longer tenure and prepay amount which was saved in EMI will it be better option to save interest and come out paying loan in the same time as of 20 years,

    Request you to please share your view on it will be very much helpful.

    Thanks and Regards,
    Paresh

  8. This is by far the best website I have come across that explains the basics of investment. I especially like the simple language and examples that you cite to simplify money matters. Please keep up the good work and keep updating us with your wisdom.
    Best Regards

  9. I have a home loan of 1800000 intrest rate 9.40% for 120 months and emi is 23429.i only paid 5 months emi. I took loan from hdfc ,and want close the loan as fast as i can.i want prepay the loan and save intrest. i can pay an extra 5000 to 8000 month for prepayment . Please advaise me about prepayment
    Thank u

    • Yes, you can approach your bank and ask them to increase your monthly EMI. This will be a very good way to make prepayments.

  10. I had taken a home loan of 1964000 from dhfl @ 11.75% interest for 30 yrs in june 2017. I want to finish off the loan in nxt year around May.
    So i wanted to ask if i have to pay the whole interest of 30 yrs or onlu the principal amount at that time.?
    Pls clear my doubt.

  11. How can I download this excel sheet?

  12. Hi Mani,
    Repayment calculator is not working.. any issue with browser or anything else ? can you please share any other link or excel ?

    • Please check now.

      • Shailendra Singh | August 10, 2017 at 4:05 pm | Reply

        Hello Mani,
        I took aloan of 1334486/- from hdfc.My balance on 1.4.2017 is 1076010/-. Iam paying an EMI of 14937 per month @10.15% interest.Shold I return a consoidated amount of balance from savings and PF say 5lakhs.

        • Hello Shailendra, it depends how you would like to finance your prepayment as per your convenience. But being debt free should always be one of our top most priority.

  13. I took a home loan of Rs 22 Lakh @9.35% in nov 2016 for 20 years. Now interest rate dropped to 8.40%. Can i resettle my loan at lower rate of interest before 1 year of loan alloted. Secondly how should i make repayment in order to make max saving. I want to finish my loan in 6-7 years. Currently i am paying EMI of Rs 23500. Will bank charge any penalty if i prepay my loan

  14. Narayana Murthy | May 19, 2017 at 5:44 pm | Reply

    Hi Mani,
    Please advice me on my case. Currently I hold SBI -Max gain Housing loan . Current outstanding is 17.76 Lcs. I am paying EMI : Rs 37,036 ,I have got set in the Bank even though its more than the calculated EMI. Also I am trying to push 20K every alternate months.I have a chance to pull Rs 2 Lcs from PPF and push it to Home loan . My Current Home loan interest is @ 9.35% basic point. and PPF earning 8.65 %. let me know is it benefits me doing this,If so How much ( PPF Earning V/s Interest saving in Home laon)

  15. Can you add change of ROI also in this calculator

  16. What an excellent article! It is written and explained in such a simple language that the layman will have no difficulty in understanding it.

    I count this as a Social Service done by Mr. Mani, educating the masses on such important topic which otherwise is so difficult to understand.

    Keep up the Good work Mr. Mani. I purchased your Home Loan Pre-payment Calculate Sheet and it is excellent. I have put in the Numbers and all the details are plotted automatically. Now i can take better decision on how much more pre-payment i can make in order to reduce my overall interest outgo.

    Regards,
    Amit

  17. Thanks for the informative article.

    I have a question regarding the prepayment. How would it differ if we prepaid some amount monthly to a bulk amount yearly. What is the effect if we ask the bank to change the emi to old emi+ prepayment amount.

    If we are planning to prepay monthly, we are actually diverting the funds from our savings. Considering the future value of the prepayment amount, is it wise to prepay. We are paying an installment ahead of 20 years.

    • old emi+ prepayment (some extra amount each month) is a better option. Approach your bank and ask them to increase the EMI. The increased amount will automatically be treated as prepayment.

  18. Hi,

    When I tried to put big prepayment amount on calculator it shows a message saying “this much amount is not allowed”. can you share if there is a maximum limit of prepayment?

  19. Sir I took 539520/+- car loan from icici bank@ 9.25% for five year, now after paying 12 installment can I pay remaining full amount by cash/ cheque then what will be the interest rate sir.

  20. Good evening sir,

    My name is vivek i am belong to middle class family.
    Here just i want to know that I taken a loan Rs.1675000 in month of Dec 2017 for 17 years and my monthly installment is 17650 with interest rate of 10.50% so how can i complete my loan amount in 8 to 9 years???
    And also tell me what is a prepayment option and how can i start with bank????
    My capacity to extra pay with loan is 2000 means loan installment is 17650+2000….

    So pls sir brief me asap…

  21. Go great I get profited upto 20,000 Thanks

Your comments fuels me to write better...