OUR BOOKS

16 personal finance principles every investor should know how to be your own financial planner in 10 steps 11 principles to achieve financial freedom

How EMI’s Principle and Interest breakup is done

by Manish Chauhan · 431 comments

Do you know who to calculate principle and interest part in your home loan’s EMI break up? Do you know how each EMI is distributed to principal and interest repayments? It is extremely important to have this knowledge because a lot of real life decisions like prepaying the loan, opting for the loan tenure and many more such aspects depend on how your EMI is structured.

home loan EMI breakup

Basics of Home Loan EMI’s

What happens in a general scenario? Loan is opted for from a Bank and you start paying your EMIs each month as contracted (see this excellent article on how EMI formula is derived). When you pay your EMIs, some part of it goes towards interest and remaining towards principal repayment. So each month you are reducing your loan by some extent and now as your loan have reduced, you will be paying less interest on your next instalment. In the same way, with each passing month, your loan gets paid by some amount and balancing amount keeps on reducing resulting in paying lesser interest month on month and year on year and the day comes when you fully close your loan. Note that your EMI is generally fixed and internally it’s worked out into ‘interest’ and ‘principal’ repayments.

However, even today, a lot of people have no understanding of the idea that in the early years of repaying the loan, interest component is very high as compared to principal repayment. The longer the tenure of the loan, the interest component will be higher than principal payments and also the rate at which the interest part will come down will also be lower, making sure that in the initial years most of the EMIs goes towards ‘Interest’ and not ‘principal’.

Example of EMI payment

Lets say you take a HDC Home Loan of Rs 30 lacs for 20 yrs tenure, your EMI would be Rs 28,950/month. In the first EMI, the interest part would be Rs 25,000 and only Rs 3,950 will be the principal payment, which means out of total hdfc home loan of 30 lacs, only Rs 3,950 will be reduced in the first month and rest Rs 25,000 will go away in interest. Sounds disappointing? What is EMI disease ?

In the same way After 100 payments (8 yrs and 4 months), when you would be paying your 101st EMI of Rs 28,950, the interest part would still be as high as Rs 19,891 and the principal part would be Rs 9,060. Still disappointed? Now let’s fast forward towards the end, let’s take 200th payment. When you make your 200th EMI payment of Rs 28,950; this time your interest part would be very less at Rs 8,349 and principal would be Rs 20,601. So now, with all these examples I gave, you can see how interest part is very high in initial years. Let’s look at it from a different point now!

Just consider this- For the scenario above; If you keep paying your EMI’s for 2 yrs (24 payments), you will pay total of 6.94 lacs (24 x EMI) from your pocket, but your loan would just go down by 1.05 lacs! And your outstanding loan would be still 28.95 lacs. In the same way in 5 yrs even though you pay around 17.37 lacs (60 x EMI), your loan outstanding would be down by just 3.06 lacs and loan outstanding would be just Rs 26.94 lacs.

The chart below shows the breakup of interest and principal payment for each year for a 30 lacs loan for 20 yrs tenure assuming interest @10%. So each bar is broken into two parts, where green bar represents Interest part and orange bar represents principal part. It is clearly visible that how interest forms a major part of overall EMI in initial years and only in the later years principal part becomes high.

Loan Amortization calculation

Here is the actual breakup of the EMI in numbers

Loan Amortization

Pre-payment of long tenure loan

A lot of investors opt for 15-20 yrs loan thinking that they will pre-pay the loan in next 4-6 yrs itself because of their salaries will rise or for some other reasons. In these cases, for the initial years they keep paying loan interest only and not a lot towards principal. When they prepay the loan, they end up paying a little lesser amount then original loan amount. Example, if you take a loan of 30 lacs for 20 yrs tenure at 10% p.a. and prepay the loan in 5 yrs itself, you will still end up paying 27 lacs as loan outstanding, even though you have already paid 17 lacs in EMI in last 5 yrs, Pre-payment penalty would be extra! But the positive side is that there might be a good appreciation in the house value itself.

So if you are taking loan for longer duration thinking that you would pre-pay the loan very soon, you need to rethink! This makes sense, once the worth of your house has gone up and there is a decent profit. A better option which I can think of is to pre-pay in small chunks each year along with your EMI’s from the start of the loan payment. It would make sure that you principal goes down in big chunks each month.

If you take short term loans, because of the shorter duration, the bigger chunk of the EMI is actually principal part, hence you can look forward to pre-pay the loan incase you wish to.

Free Calculators for Loan Amortization

I have created and found out some loan amortization calculators which you can use for calculating your EMI’s and its breakup into principal and interest for each month.


By now you must have got a clear understanding on loan amotization and how home loan EMI is broken into principle and interest component. Note that the asssumption for this article was that the loan is on “Monthly Reducing Balance”

Subscribe via RSS or Email:
What do you want to read about
Mutual Funds Life Insurance BankingHealth Insurance Credit Report and ScoreMost Commented ArticleReal Life Experiences Share MarketLoans Real Estate Income TaxCredit Cards For Begineer Investors Succession Laws EPF ULIP Product ReviewsBest of Jagoinvestor Other Products & Concepts How-TO GuidesBooks, Launches, Initiatives Investors Myths Psychology & Wisdom PPF General  
Buy Jagoinvestor Books in Ebook Format

{ 431 comments… read them below or add one }

1 Kriti Parikh April 14, 2011 at 3:41 pm

Hi Manish,

Till now, I was always of the mind that the longer the tenure, the easier the payments and the simpler it gets to pre-pay the loan…
Great going… thanks :)

Regards
Kriti Parikh

Reply

2 Manish Chauhan April 14, 2011 at 5:52 pm

Kriti

Yea ,, thats how most of the people think .

Reply

3 AV ARUN July 10, 2012 at 4:33 pm

Dear Manish,

I was looking for a Home Loan Calculator which will also accomodiate Intrest changes during the entire loan period ( ie change of intrest rates during the actual tenure of the loan ), this will be very good tool to check the actual impact of intrest on a floating rate home loan.

Regards,
Arun

Reply

4 Manish Chauhan July 10, 2012 at 7:10 pm

Will accomodate it soon …

Reply

5 Nagarajan Santhan April 14, 2011 at 3:49 pm

Nice article manish ….

Nagarajan S

Reply

6 Manish Chauhan April 14, 2011 at 5:53 pm

Nagarajan

Thanks , keep reading :)

Reply

7 Nagarajan Santhan April 15, 2011 at 10:04 am

Thanks Manish

I would like to share my experience with all.

I have housing loan with ICICI bank for 4L.

EMI start from Apr 2007 and it was upto 2030 (4731 is my initial EMI and 4k+ is interest and some hundreds only in principal amount)

Apr-2007 loan amount 410520 @ 11.25% interest
….
Dec-2008 loan amount 400116 @ 13.75% interest

See, I paid 20 months EMI (20 X 4731 = 94620) and my principal reduced only 10404. Beauty is here, my housing loan is 4 laks and 10520 is ICICI insurance for my home.

After paying 95000, i paid only my insurance amount and my loan is still pending.

I blindly paid my EMI without knowing Principal and Interest part.

Jan 2009 – Apr 2011 period i paid half of my loan (by part payments and increase EMI)

As of today my loan status: 190000 and loan will be closed on mid of 2013 :)

But i have a plan to close my loan before 2012.

Thanks
Nagrajan S

Reply

8 Manish Chauhan April 15, 2011 at 11:28 am

Nagarajan

Exactly, what i said in the article . The same thing happened to you in real life . I think as it was a smaller loan , you should have taken a smaller tenure loan which would mean your EMI goes more on principle part and less on interest . But anyways , I think its better to close the loan faster .

thanks for sharing your case .

Manish

Reply

9 Nagarajan Santhan April 15, 2011 at 1:29 pm

Thanks Manish …

Reply

10 CA Karan Batra April 14, 2011 at 4:00 pm

The most important aspect of knowing the break up of EMI is that Pricipal and Interest Repayments are deductible under different sections of the Income Tax Act and have different limits attached to them.
Unless and untill you dont know the break up of your EMI, you wont be able to claim benefits is these have to be disclosed in the Income Tax Return.

Reply

11 Manish Chauhan April 14, 2011 at 5:53 pm

Karan

Yes .. Most of the people take the detials from the bank at the time of filing the returns .

Manish

Reply

12 AJ April 14, 2011 at 4:05 pm

Good one Manish. One strategy that I have been using is quarterly part prepayment of the loans, to keep my interest component low

Reply

13 Manish Chauhan April 14, 2011 at 5:54 pm

AJ

I think its one of the best option , as its less of headache and serves the purpose . Paying each month would be a hassle

Reply

14 Nitin Gupta April 14, 2011 at 4:58 pm

Hi manish,

I would like to understand that what happens in case of Prepayment of entire loan amount buy using another loan.

using same numbers, 30L, 240 months, 10% interests, i see the emi is 28950. after 10 years, balance due is 2958978. Now if want to make a prepayment of this loan by using another new loan for rest 10 years. i take a loan of balance amount i.e. 2958978 for rest 10 years as 10% rate, i see emi comes 39103.
Ideally the emi should not change much. I am surprised that what factor i am missing here.
If it was the right calculations, then how come people change banks for less interest rates.

Reply

15 Nitin Gupta April 14, 2011 at 5:00 pm

All,

ignore this one, i kno what was incorrect in my calculations :)

Reply

16 Manish Chauhan April 14, 2011 at 5:03 pm

Nitin

Please let me know what was the mistake you did ? mistakes are the best way to learn

Reply

17 Rakesh April 14, 2011 at 8:23 pm

Manish,

Excellent article. I think it is better to make part payments every year, I did the same for my home loan. Instead of keep the money is savings account its better to reduce your loan burden.

Rakesh

Reply

18 Manish Chauhan April 14, 2011 at 8:26 pm

Rakesh

Thats what i also advocate ,but tax deductions is one thing we have to look at and consider it in overall planning

Reply

19 Srinivas April 14, 2011 at 8:35 pm

Informative reminder.

I took a loan fron ING Vysya @10.5% in 2008. Condition is that i cannot prepay more than 25% of the outstanding in any year. I missed it in teh first year and for the past 3 years i am religiously paying this 25%. I feel i will be able to come out in a couple of years. That is one reason why even though they raised the interest rate to 12.75%, i didnot feel the pinch.

If one plan and goes for prepayment, it is using the bank’s money for our use. If one pays for the full tenure, it is the bank which benifits and not us.

Thanks for the nice post, Manish

Reply

20 Manish Chauhan April 14, 2011 at 8:38 pm

Srinivas

Well.. I agree with you largely , but one the other hand I would ike to say that for many keep paying home loan EMI for long term may make sense , provided they earn better returns on their investmetns and utilize the tax benefits also .

Manish

Reply

21 Sunnydoc April 14, 2011 at 9:25 pm

Nice Article Manish! I’m getting addicted to your posts!

Sunnydoc…

Reply

22 Manish Chauhan April 15, 2011 at 12:25 am

Sunny

great to hear that :)

Reply

23 Nitin April 14, 2011 at 10:01 pm

Manish,

You explained it wonderfully with a great example. I have just one doubt. As in your example someone prepays the loan after 5 years from first disbursement and has already paid 17 lacs in EMI. In this case the interest paid so far was a part of total interest calculated for the period of 30 years. Does the bank recalculate the total interest at the time of settlement for the new applicable period (5 years in this case) and comes up with the amount to be payed by the borrower? I hope an clear in my problem statement. If not, do let me know.

Reply

24 Manish Chauhan April 15, 2011 at 12:27 am

Nitin

Actually you are not clear to me , But let me try to answer still .

At any point in time , you have some outstanding loan , which is your total liability . With each EMI , you reduce the principle part from that EMI , and you have a new outstanding loan .

So in my case , after 5 yrs, you have outstanding loan of some Rs X , and from this point, what happened in past have no relation with what happens later .

Manish

Reply

25 Nitin Gupta April 15, 2011 at 11:44 am

Nitin,

At any point of time, if u want to prepay the loan, u have to pay the outstanding loan amount(value of last column) only. which in ur example would be 27 L.

if u think that in 5 years, interest got paid for 20 years calculation, it is not correct.
I think for each emi, interest is calculated based on outstanding amount only, and so interest does not depend on tenure of the loan. so when u prepay, (in other words change the tenure of the loan), no need to recalculate the interest.

Reply

26 Manish Chauhan April 15, 2011 at 11:53 am

Nitin

I get what you want to say , Interest does not change for a particular year becuase of tenure change ,but its indirectly related to tenure . Tenure decides how much is the interest part of your overall payment .

Like if your tenure is 20 yrs then your interest payment might be Rs X , but it can be 85% if your EMI ,. but in other case if tenure is 10 yrs , even though in this case interest is again same at Rs X , it might be 50% of your EMI , so from customer point you have to look at that part . I hope thats clear to you

I am still not clear on the conclusion . Are we discussing what you actually wanted ?

Manish

Reply

27 Joel April 15, 2011 at 12:48 am

Hi Manish,
I am also addicted to your blogs..Made a habit to read your blogs during lunch time ..quit rediff and other timepass websites ;-) .. Here i go ..
I took 10Lkahs loan last year July with 9.25 % intrest rate ,for 15years.Fortunately after few months i got a chance to go overseas and now i am in a good situation to repay atleast 3-4 Lakhs .
Just need you suggestion how to go about it. Sooner the better isn’t it ?
Could you please tell me what will be the outstanding amount if i pay 4lakhs (prepayement) by this year end and also let me know the the EMI amount after the prepayment.
Hats off to you boss.
Joel.

Reply

28 Manish Chauhan April 15, 2011 at 11:37 am

Joel

As per your info , your current EMI should be around Rs 10,300 (Not included things like processing and other charges , take it as approx) ,.

Now if you repay around 4 lacs, your outstanding loan would be around only 6 lacs (assuming everything else is same) . So , your new EMI would be around 6,200 .

Coming back to the point of wheather its good to pre pay the loan always , its not TRUE .

Your interest is only 9.25% , which is a cheap one . If following 2 things are true , then it does not make much sense to close the loan .

1. You claim tax benefits on house loan
2. You are doing your investments wisely and earning better than 10% in long run , which you can get in long run in equity .

Manish

Reply

29 Joel April 15, 2011 at 4:51 pm

Hi Manish ,

Thanks for the quick answer .I did a rough calculation.
Let me assume , i am going to prepay 4Lakhs at the end of Dec 2011.
Till this date i have already paid the bank 18 EMI’s @10300 rs =>Jul 2010 to Dec 2011 => approx 1.85 lakhs .And the outstading amount @ dec2011 is 9.5 lakhs.
Now i paid 4 lakhs as prepayment. Hence my outstanding loan amount will be reduced to 5.5 Lakhs. My new EMI will be Rs 5900 (i calculated this based on 162 months=>180-18 ,intrest rate 9.25 % and loan amount 5.5lakhs).
Let me assume ,i do not prepay the loan here after . Thus i end up paying 9.55Lakhs after 162 months (162 * 5900 rs) .
Hence the total amount that i paid to the bank after 180 months is
1.85 lakhs + 4 lakhs +9.55Lakhs = 15.4 lakhs.

I had not done that single prepayment ,then i would have paid a total of 18.5 Lakhs (10300 *180) . So there is a gain :-) Isn’t it ?

So in my case it would make sense to prepay the loan since,
1) I am not going to sell me home (want to live permanently there).
2) Tax benifits => i can not claim atleast for 5 years as a feel that i will be based overseas for the next 5 years.

Please shed some light .

Thank you.

Reply

30 Manish Chauhan April 15, 2011 at 8:26 pm

Joel

You are missing an important point here . You are not considering present value of money .

In you case you are assuming that paying 15.4 lacs in case of prepayment is “gain” rather than paying 18.5 lacs without pre-payment . But in case of pre-payment remember that you paying 4 lacs in one go NOW , thats a big thing , in case of paying EMI for all 10 yrs , you are spreading the payments to a bigger duration so the EMI’s paid at some later years will be cheaper for you .

You need to incorporate this into you analysis too .

Manish

Reply

31 ravi October 1, 2011 at 2:32 pm

thanks for all your information. i got stuck with a problem and that is — for a loan amount of 27L with rate of interest 10% for 240 months if emi is 26056 then how we can find the share between interest and principal.

Reply

32 Manish Chauhan October 4, 2011 at 9:06 pm
33 Praveen April 15, 2011 at 7:26 am

Great article. It would be nice if the calculator table gives the total amount interest paid after the loan tenure.

Reply

34 Manish Chauhan April 15, 2011 at 11:38 am

Praveen

Praveen .. Hmm.. you can get that for now at http://www.jagoinvestor.com/calculators/html/EMI-Calculator.html

Reply

35 E Pradeep April 15, 2011 at 9:12 am

Two ways of faster repayment are making part payments and increasing your EMI. No bank allows you to an online part-payment and you have to visit their Home Loan servicing branch only; an attempt probably to dissuade customers from making part payments frequently. Thankfully, part payments do not have a penalty in most banks.

Normally, banks increase your EMI when the rate increases and decrease the tenure when it falls. Due to falling interest rates, my EMI had fallen initially but later on, the tenure kept on increasing till it ballooned to 45 years (Have no idea how the bank expects customers to pay off loans with such high tenures). If you go to a bank and ask for an EMI increase, it happens immediately but now ICICI Bank asks for a credit evaluation and so you have to submit salary slips and bank statements and even then, this took me 3 months after 8 phone calls, 6-7 mails and close to 3 levels of escalations. How come they can reduce the EMI without my consent but to increase it, I need to prove my credit worthiness? Now, I plan to transfer this home loan; wonder how tedious this would be looking at the way they have handled my EMI increase request.

Reply

36 Ajay April 15, 2011 at 10:14 am

State Bank allows you to xfer funds from savings to loan like a normal account xfer. Makes life easy :)

Reply

37 Manish Chauhan April 15, 2011 at 11:41 am

Ajay

Thanks for that Info

Reply

38 Manu April 15, 2011 at 8:11 pm

I agree with Ajay. I recently transferred a small amount online and had no problem. I was told by the branch manager, that as long as these funds from my own account as a result of my own savings, then I don’t get hit with penalty.

Reply

39 Manish Chauhan April 15, 2011 at 11:41 am

Pradeep

What bank does is in thier interest . If they increase your EMI , it would would benefit you and not them , So they incrrease the tenure . Its not right i agree .. the bank has to be flxible in both direction .

Thanks for sharing your story

Reply

40 R April 15, 2011 at 10:02 am

Good article, man! Very enlightening! However, a teeny-tiny correction… when we refer to the amount on which interest is calculated, the spelling is ‘principal’ and not ‘principle’ (as can be verified here.

Reply

41 Manish Chauhan April 15, 2011 at 11:57 am

R

thanks for pointing that out . I made the changes

Manish

Reply

42 lakshman April 15, 2011 at 10:12 am

E. Pradeep

I am surprised your EMI tenure got increased to 45 years!! Which bank is it? ICICI? I am surprised that its not easy to part-pay…

I have a Home loan from state bank of travancore. I have online access to the loan account and part-paying is simply initiating a neft transfer from any of my saving accounts to this loan account. It has been very convenient so far.. Since its online, i can see the outstanding principal amount i have on any given day.

Reply

43 Manish Chauhan April 15, 2011 at 12:03 pm

Laksman

Loan tenure extending till 45 yrs is not a function of which bank is it ! . It will be done by any bank, its mainly dependent on interst rate movement .

for instance , if one has a loan of 40 lacs at 10% for 20 yrs tenure , the EMI comes to 19300 . Now if interest rates move up and increase upto 11.5% , then inorder to keep teh Same EMI , the tenure has to go up to 45 yrs , check it at http://www.jagoinvestor.com/calculators/html/EMI-Calculator.html

So the best thing would be to increase the EMI would not be that substantial

Manish

Reply

44 Vishnu April 15, 2011 at 12:38 pm

I want to share similar case with our home loan in ICICI. We did not check the interest rate for more than 6 months. The EMI was being deducted regualarly. There was no communication (email/phone/letter) about the hike in interest rate change. Suddenly, when we see the schedule, the tenure was increased by more than 5 years because of hike.

And, when there is any scheme ongoing (like pay 0.5% or 5,000 and and get the interest rate reduced by 2%), there will not be any communication in any medium not even their site. At least, I have not seen any time. Only when you call them by yourself and ask them now and then, they will inform you about such schemes.

Once you pay some amount (e.g. 0.5%) and get the interest rate reduced, there is no gaurantee till what time it will be intact. Any time when the home loan rates are increased, the interest rate will be increased as per the new rates. Again, they will bring new scheme. (This time, we have been asked to pay 6,000 to get 0.5% reduction)

Reply

45 Manish Chauhan April 15, 2011 at 12:47 pm

Vishnu

Even Nagarajan shared same kind of thing .

Manish

Reply

46 E Pradeep April 15, 2011 at 10:28 am

Yes, Lakshman, it was an ICICI Bank Home Loan. I tried to explain to the Customer Care about how ridiculous can it be that the bank expects someone to pay a 45 yr loan (it was a 25 yr loan) but they had no answer to that.

From what I have seen, only public sector banks seem to be giving an online option to do part payment of principal..You can see the o/s at any point of time in ICICI but principal part payment is not allowed..HDFC Ltd allows you to pay online but only of the EMI and not of the principal alone and even here, they charge Rs 100 per payment..

Reply

47 Nagarajan Santhan April 15, 2011 at 11:00 am

Hi,

If your loan in ICICI bank, keep visiting (when you have a time) Branch and ask any offer they have currently.

In my case, last year my int rate was 13.75% and my loan balance was 3Laks, when i went to pay my part-payment I asked the person if they have any special scheme.

They told me if you pay 0.5% of your outstanding, your int will be reduced to 8.75% (surprise)

So I paid 1500 only (which is 0.5% of my outstanding) and reduce my int rate to 8.75%.

Regards
Nagarajan

Reply

48 Manish Chauhan April 15, 2011 at 12:13 pm

Pradeep

See my reply to Laksmanan above, that will explain why the tenure went up to 45 yrs .

Manish

Reply

49 E Pradeep April 15, 2011 at 3:40 pm

I am a banker myself, so I don’t deny the mathematics that will lead to a loan going upto 45 years in case of a rate increase but no credit evaluation team will ever give a loan for 45 years. When a loan appraisal is done, the age of the borrower is taken into account, so a 45 yr loan is totally meaningless. Normally, there is a max. tenure that is set for any loan and in case the max. tenure is reached, the EMI is increased by the bank itself.

Reply

50 Manish Chauhan April 15, 2011 at 8:28 pm

Pradeep

thats good actually .. thats what should not happen and ideally bank should raise EMI , but here we have taken a case where it went to 45 s yrs, but what about some one who has taken a loan for 5 yr and it goes up to 12 lacs ?

Manish

Reply

51 Santosh M April 15, 2011 at 12:36 pm

I am confused while reading your prepayment example. You say if I prepay my loan in the 5th year i have to pay the bank the enitre loan outstanding of 2,694,072. The is the amount outstanding which includes some portion of principal and interest calculated for the next 15 year period. So If I prepay my loan at year 5, shouldn’t the prepayment amount be less than 2.7 million because the tenure of my loan is effectively 5 years instead of 15 years. Shouldn’t the bank look at the principal outstanding at the 5th year and recalculate the interest component taking into account that my loan was for 5 years only and not 20 years that i had initially signed for?

Why should I be paying 2.7 million which contains interest for next 15 years, when i am closing my account in 5 years. I should be charges for 5 year interest only.

Reply

52 Manish Chauhan April 15, 2011 at 12:56 pm

Santosh

No , It does not work that way .

When you initially take a loan for 20 yrs, it out means you are saying that you will for 20 yrs and not 5 yrs . Later if you pre pay the loan , it was your decision later , bank has nothing to do with that . Remember that at any point of time you have to pay “Loan Outstanding” . Loan outstanding means “the loan which you to pay right now” . So when you want to prepay the loan , you pre-pay the loan , it will be even more than outstanding loan , becasu there will be penalty for prepay also “_

Manish

Reply

53 Sumit Anand April 15, 2011 at 12:37 pm

One more thing that this post made me note is about the break up in the Home Loan. We do take tax debates for different part of the loan i.e.:

Interest : Upto 1,50,000/-
Principal : Upto 1,00,000/- under section 80 C

For ex. a 20 Lac Loan, in the initial years 5-6 years, interest component is high, so total 1,50,000/- rebate can be taken but in the later the interest component will fall and thus the interest rebate amount will also fall below 1,50,000.

Similarly, for 80C deduction, the amount will increase in the later years and possible, only home loan principal repayment and PF will take care of 80C 1 lac investments.

Beacause of these factors, some of us may need to relook at the tax saving investments under 80C like ELSS investments ( which may no longer be required ) and overall tax liability ( which may increase in later years ).

Also, this will be different for each loan depending on the amount and no. of years, thus, each one will need to individually calculate. Hope this helps, correct me if am wrong

Reply

54 Manish Chauhan April 15, 2011 at 12:53 pm

Sumit

You raised a good point . You are correct . In the initial years the interest component will cross 1.5 lacs , but not principal part . Also one thing one should keep in mind is that tax rules might get change after 5-10 yrs, so we can think about it today

Manish

Reply

55 Manish Chauhan April 15, 2011 at 12:53 pm

Sumit

You raised a good point . You are correct . In the initial years the interest component will cross 1.5 lacs , but not principal part . Also one thing one should keep in mind is that tax rules might get change after 5-10 yrs, so we can think about it today

Manish

Reply

56 Arudra Kumar April 15, 2011 at 1:44 pm

Hi guys,

Just wanted to share my experience here.
I have a loan of about 14 Lakhs which i borrowed from ICICI bank in year 2006. Initially my EMI was around Rs.12500. After the increase in the interests rates they increased my emi to Rs.14200 and my tunure close to 30 years (interest rate @ 13%. initial tenure was 20 years @ 9.25%). I also had a car loan for which the emi was around Rs.7000. This car loan was over in the year 2009. I contacted ICICI customer support the immediate next month after my car loan got over and asked them to increase my emi to Rs.20000 (i was already habituated to pay Rs.21000 as EMIs by then). Fortunately without much trouble they increased my EMI amount to Rs.20000 per month and the tenure came down to around 10 years ;) . Now, during last year June, I got an email from ICICI about this scheme to reduce the home loan interest rate to 8.5% fixed upto Mar 2011 after which it would become 9.25% fixed until Mar 2012 and would be FRR-2% from Apr 2013. I immediately approached the bank and learned that I had to pay around Rs.7500 to avail this offer which I did. Now my tenure came down to 6.5 years. I still am paying Rs.20000 as EMI so that my loan principal comes down drastically before Apr 2013 so that my tenure does not increase astronomically when the interest rate becomes FRR-2% in Apr 2013. I am planning to close my home loan in the next 5 years by making some partial payments in between.

Regards,
Arudra.

Reply

57 Nicket April 15, 2011 at 3:57 pm

This one was good. You are the first customer of ICICI who din have any complain about them. Good to learn, for a change.

Reply

58 Arudra Kumar April 18, 2011 at 5:01 pm

Nicket,

Not really. Even I am a victim of ICICI Bank. Fortunately not with Home loan but with my ICICI credit card. :(

Regards,
Arudra.

Reply

59 Manish Chauhan April 15, 2011 at 8:29 pm

Arudra

Thats good experience , it shows how prepayment can help in reducing the burden .

Manish

Reply

60 Bhargav April 15, 2011 at 3:04 pm

Hi Manish,

Thanks for useful article. I have taken home loan of 25L from SBI. My current EMI is 25,000 approx. My question is: If I change EMI to 27,000 – will it be usefule or should I save 2000 each month and should do prepayment ?

Your reply will be help ful.

Reply

61 Manish Chauhan April 15, 2011 at 8:37 pm

Bhargav

You should be doing prepayment ,remeber than if you make it part of EMI , the major part of that 2k will also go towards interst and not principal , but prepaying , all of it will go to principal . But if you make EMI as 27000 , there will be some reduction in your tenure , but overall , you should pre-pay

Reply

62 Nicket April 15, 2011 at 3:50 pm

hi Manish, Nice article!

One takes a loan of 60L for an under construction property. The disbursement is say, 20L in first year, 20L in second and 20L in the third year. Each year its done twice, means 10L every six months. The borrower opts to start his EMI immediately after the first disbursement. What will be the effect on the component of interest and pricipal in this case?

That one may be me. I dont yet know which lenders give this option to start EMI early.

Reply

63 Manish Chauhan April 15, 2011 at 8:39 pm

Nicket

What you are talking about is very much like Per-EMI option . Its not exactly pre-EMI , but very much like it . If all the conditions are same ,you should opt for paying it late . From your side keep the EMI in an RD , and delay the payment if you can (assuming there is no penality of extra cost)

Manish

Reply

64 Nicket April 16, 2011 at 2:34 pm

Thanks for the reply Manish,
What’s the advantage of RD? The interest rate on Deposits is lower than the housing loan in general. The one advantage is, you have an option of using that Fund elsewhere, if needed. That too is dangerous!
To me the psychological burden of debt is more difficult. As I have life, till now, free of debt and credit cards.

Reply

65 Manish Chauhan April 20, 2011 at 5:58 pm

Nicket

I am assuming that you have an option of making a late payment, so if you can delay it by all means, but from your side , keep the EMI’s in some investments which is liquid

Manish

Reply

66 Nicket April 25, 2011 at 2:30 am

Thanks Manish, Again there are pre payment charges.

Well, Finally, I have developed something with the help of RBI! So if you opt for starting the full EMI from the very next month of the first disbursement by the lender, then your EMI is Rs 56753 and if you assume that you take full loan (ready property) disbursement then the EMI will be Rs 64477.

Now understand that, in the pre-EMI option, for the first 3 years one is paying only interest, the principal remains same. So your total out go is pre-EMI for 3 years plus EMI of Rs 64477 for the next 15 years.

This is for 60L loan for 15 years at 10% fixed monthly reducing balance.

Reply

67 Rajeev April 15, 2011 at 4:33 pm

Hi, very interesting conversation. Manish, could u pls help in calculating net interest rate on Loan (20 Lacs, 9.90% fixed for 5 years, 20 years tenure) for first 5 years by considering tax exemption on Interest part (1,50,000/-)? I don’t what interest rate may be 6th year onward for next 15 years:(.

I am keen to compare above option vs interest earned on FD at 9.50% (non-taxable due to slab thing):).

Reply

68 Manish Chauhan April 16, 2011 at 11:40 am

Rajeev

It depends on the market conditions what will be interst after 5 yrs , I am not clear on what comparision you are looking at ? Give more inputs on that

Manish

Reply

69 Priyanka December 8, 2011 at 5:16 pm

Hello Mr. Manish,

Its too good article, very informative.
Well for the person like me who has lack of info about loan and its replayment structure.
Actually im seeking your input on our transaction.. we have taken a home loan from idbi, the loan amout is 30L for 20yrs tenure @11% rate of interest. Its almost a year past we are paying EMI, now we came to as per bank statement out of our EMI only 30000 is been adjusted against our principle amount and rest was the interest as on.. as we had no idea about this calculation of EMI adjustment.. after going thru this block somehow my doubts are cleared. But not completely. Well can you please explain at what proportionat this adjustment bank do approx. calculation. As we both are earning, EMI has been deducting from my husband’s account. We are trying our best to reduce the burdan by making prepayment in early loan period e.g. in 1st 5 years. Pls advise at what structure we should go for prepayment.. please give some examples that way we can work on our transaction if that would be possible for us. Also advise is it feasible if we request bank to shorten the loan tennure at the time of making prepayment. Pls advise.
Priyanka

Reply

70 Manish Chauhan December 8, 2011 at 7:10 pm

Priyanka

Note that you have a Constant EMI every month which is calculated in the statt only at the time of taking the loan , now the interest part would depend on the loan outstanding , as your loan is for 20 yrs , in the starting years the INTEREST part wouldbe very high and principal part is very low , so even if you pay 30k X 12 = 3.6 lacs in first year .. most of it was INTEREST . so now what you should do is , if possible better PREPAY the loan every month with a certain amount .

Every month put 10k or 20k extra as PRE PAYMENT and this should make sure that you complete your loan in less than 10 yrs

Manish

Reply

71 Priyanka December 13, 2011 at 3:54 pm

Thanks Manish!

Reply

72 Atul April 15, 2011 at 4:57 pm

Hi Manish,

Great article!
One should also look at home loan interest from Taxable perspective. Not sure how long the limit of 1.5L will remain, but one can always repay the loan once Interest component falls below the 1.5L limit. Definitely by that time one has paid more principal and less interest but thats how the EMI funda works.

Loan amortization is great tool, thanks for sharing. Helps in seeing which loan is eating more into your expenses

Cheers

Atul

Reply

73 Manish Chauhan April 16, 2011 at 11:42 am

Atul

Yea . once has to consider the interest component tax benefits also while looking at his calculations .

Reply

74 prabeesh April 15, 2011 at 5:26 pm

Manish,
I have a Home loan with HDFC for 17.5L which has EMI started from this april.
I am thinking in below lines about the prepayment based on tax exemption.

I believe Home Loan at 9.25 is cheap at current stage.So i will keep paying my EMI and save some amount in a liquid scheme until march 2012.At the time i will calculate the left out amount of 80C after calculating my EPF,TermInsurance,Medical insurance etc. And i will pay this amount as pre payment.

While doing this i will also make sure i constantly do my investing in SIP,which i believe to give 10-12% returns on a long term.By this i will be having good savings and balance pre payment of loan.

Is there a flaw in this method that you see?

Reply

75 Manish Chauhan April 16, 2011 at 11:44 am

Prabeesh

Why are you not prepay the loan each month with that amount which you are thinking of investing in liquid fund ?

Manish

Reply

76 prabeesh April 16, 2011 at 4:35 pm

that seems to be a cumbersome activity as i need to make DD for that amount..Will that work better on quarterly instead of yearly?

Also one more question?
How do i calculate incase of EMI started before the complete disbursal of the loan amount. Like in my Case i have applied for 17.5L so far only 10L is disbursed but i started the EMI now itself?

Reply

77 Manish Chauhan April 20, 2011 at 6:12 pm

Prabeesh

quarterly thing looks better if it demands DD each time, dont your bank have it online ?

Also check if your bank is charging only interest part before the full disbursal . Is your loan a pre-EMI loan ?

Manish

Reply

78 Manu April 15, 2011 at 8:14 pm

What will be the effect of DTC when it comes into picture?

Reply

79 Manish Chauhan April 15, 2011 at 8:27 pm

Effect of what ?

Reply

80 Nicket April 16, 2011 at 2:36 pm

No changes due to Direct Tax Code.

Reply

81 Sharath M N May 5, 2011 at 3:15 pm

Hi Manu and Nicket,

In the Direct Tax code which will come into effect from 2012 principal paid on home loan will not be considered for income tax exemption as is the case for the current year.
Principal : Exwmption upto 1,00,000/- under section 80 C— Not applicable under Direct Tax Code 2012

Reply

82 Karthik April 15, 2011 at 9:27 pm

Hi Manish,

Very good Article.. I work in a Banking product company and in the Loan Module and we know how the banks all over the world wants us to calculate the components of a Loan Product.

As you said, out of Rs.28,950, only 3,950 goes to Principal which makes the outstanding principal decrease to a peanut size…
I prefer, instead of having a fixed tenure like 5/10/15/20 yrs, we should buy the loan based on our capability to spend per month on an EMI.
As the initial years has a big chunk of interest component, the first EMI should be in a ratio of atleast 60:40 for Interest:Principal. Based on this, we should calculate the tenor. The Banks deliberately makes the tenor as fixed one and calculate the EMI which makes the interest component in EMI as higher.

The best options are
1. Increase the EMI whenever you can pay more money. This will reduce your tenor and subsequent interest payments.
2. PrePay a huge chunk if you have a lot of money irrespective of the Prepayment Charge.

Increasing EMI by 5000 will save you a lot more than if you save that 5000 for one year and prepay it. Because the recalculation happens only from the day you prepay. But if you increase EMI, your recalculation happens right away which reduces the total interest payable.

Also, Variable Interest rate, one should keep an eye on the outstanding principal always.

Regards
Karthik

Reply

83 Manish Chauhan April 16, 2011 at 10:15 am

Karthik

Thanks for the comment , I agree with both of your points . I liked your point of increasing the EMI , instead of prepaying the loan . This is some good advice to be used for one of the next articles

Manish

Reply

84 Karthik April 19, 2011 at 3:53 am

Hi Manish,

On the two points i mentioned, it depends on the financial situation of an individual.
When a guy receives raise in his monthly salary he could raise his EMI.
When a guy receives a huge bonus, he could do a principal prepayment.

Both the options will help. Out of the both, raising the EMI option will help more and the decision should be based on the situation.

In some banks around the world, there are options to do a prepayment along with the installments. For eg.. Consider an EMI as USD 560. If the Customer has USD 600, then the system allocated the USD 560 to his current installment and prepay the excess USD 40 as a prepayment. This is more in case of microcredits. In this case, the customer has the leverage that, the whole $40 will be allocated to Principal which will further reduce the Oustanding Principal. Some banks have minimum prepayment threshold. Also some banks allows prepayment for any value and without any charge.

Another point I disagree generally is… The loan vendors say that they can use 1.50 Lakhs exemption limit. This is an exemption which should be used for the advantage of the individual and not the Bank. Bank generally increase the tenor which will increase the Interest part and so they sell the loans by telling.
1. The EMI is less..
2. The Interest will save tax..

If the Banks increases the EMI instead of tenor.. this will reduce the tenor and overall interest payable and you could still achieve the 1.5 Lakhs limit. In general loans is a liability and 1.5 Lakhs is an expense for the Customer anyways and it should dealt carefully.

Regards,
Karthik

Reply

85 Manish Chauhan April 20, 2011 at 5:28 pm

Karthik

Even in India i suppose one can pre-pay the loan upto the EMI money each month ? No ?

Manish

Reply

86 Karthik April 21, 2011 at 7:20 am

Manish,

I don’t think banks in India offer this facility to make prepayment along with every installment. I had heard some banks has a limit like 2 per annum. It depends on the Bank’s policies.. Generally, they have a minimum threshold.

Karthik

Reply

87 Vijay April 26, 2011 at 5:49 pm

SBI has this and it doesn’t have any cap on number of transactions

Reply

88 Shobha May 6, 2011 at 2:52 pm

I have a home Loan with Axis Bank.

They have a clause that Prepayment amount has to be higher than 3 months EMI, but I can Pre Pay once every Quater..

Reply

89 Rohit Ghule April 16, 2011 at 11:24 am

How can I get a Future Payment Schedule for a flexi-interest rate loan. For e.g. I have taken a loan of Rs. 10 lakhs for 15 years with 8% interest for 2 years & then 8.5% interest for next years & then prevailing float interest for next 11% years.
I am planning to pay-up the loan in the fours years.

Can I have calculator for this thing, as I feel this is an ongoing interest rate scenario for all the home owners?

Reply

90 Manish Chauhan April 16, 2011 at 11:41 am

Rohit

I have given the excel sheet for down load at the end , you can see it at the end , the one created by me , in that sheet you see the interest for each month , change the interst as per the condition and you well get the appropriate answer

Manish

Reply

91 Krish April 16, 2011 at 11:44 am

As usual an impressive article. However I felt that this article could have focussed on impact of rise in interest rate on EMI rather than simply describing what constitutes EMI.

Let me explain my experience of home loan EMI. I was able to hit two cycles on my home loan i.e. securing the loan when the interest was at its bottom i.e. 7.25% and went to the peak of 14%. This is to say, keeping same EMI, the tenure is almost doubled. Some banks chose to increase the tenure as long as 45 years. Others had kept a ceiling of 30 years and effected part EMI rise on their own.

I got a funny discussion with a private bank when my under 10L loan interest was spiked without a reason. The officer said that I should not bother about hike because the interest portion is still under the tax limit of 1.5 lacs. Most of the private banks have misused home loan tax advantage extended by GOI to levy higher charges causing loss to the exchequer.

The banks with sheer institution size are able to guage the interest cycle much better than the retail loan customer. No wonder when the interest cycle goes downword, they are extracting charges in the name of reducing the rate. I believe the customer get benefit only when the extended lower rate is sustained beyond 2 years. Else it is same story for the customer. The private banks knew the game and they continue to ensure 11+% rate of return on home loans.

Reply

92 Manish Chauhan April 16, 2011 at 11:52 am

Krish

Yes , this is one common problem where if a person takes loan on floating rate basis , his EMI’s or tenure gets balloned later with interest rates hike and at the same time banking are not ready to lower it suddenly when the reverse happens

Manish

Reply

93 lpm April 17, 2011 at 12:01 pm

Excel has the PMT, IPMT, PPMT functions that can be used to compute the EMI, interest, and principal respectively.

Reply

94 Manish Chauhan April 17, 2011 at 1:17 pm

I have heard about PMT , what is IPMT and PPMT ?

Manish

Reply

95 Ajay April 17, 2011 at 5:44 pm

Manish – Interest and Principal Payment :)
In fact they are easy methods for getting the loan EMI, interest and principal details, nevertheless the spreadsheet that you have created foes to the basis of those formula.

Reply

96 dr kishan April 17, 2011 at 6:41 pm

Manish
Nice article indeed. this is really an eye opener for many. in this connection i would like to share some by principle while i take a loan.
our family has till now taken about 5- 6 loans inthe form of car or home loans. some have been fore closed also. at the present too i am running a home loan and car loan from sbi.
while doing the research i found out that some times there is a probability of bargaining on the rate of interest especially the private banks. we should not think that the available information is the final ROI. the banks have the facility of reducing the ROI making use some special powers given to the senior officials. when i approached ICICI for car loan i was first told that the ROI is 10.5% but during the negotiation they came down to 9.5% and probably would have gone further down i had persuaded more. secondly they are ready to give discounts on processing charges or may even waive them completely in some cases as offered to me. i didnot try this with SBI but i think that SBI wouldn’t have reduced the loan ROI. so i would suggest to negotiate hard while taking a loan espl. pvt banks.
secondly now a days teaser loans are being offered making the picture rosy for the initial period. but ROI increases after some period and then the picture is clear. what i have done is i calculate emi on the basis of max ROI which has been in the past that is around 14% (and not 8% which is initail offer ROI) and see whether this emi is payable by me or not and then calculate my LOAN amount so that even if the ROI increases in the future i am ready for it.
thirdly there is a very nice EMI calculator at http://www.bankbazaar.com and even the loan transfer claculator. these have been of great help to in the past. they give many info like annual interest pay out. we can add probable pre-payments and also see how it affects or interest and loan tenure.

thanks
dr kishan

Reply

97 Manish Chauhan April 18, 2011 at 10:39 am

Dr Kishan

Wow .. you have calculated the EMI on highest possible interest, thats something very smart and one has to do it that way only . Thanks for sharing your experience .

Manish

Reply

98 Rajeev April 18, 2011 at 10:16 am

Hi, I downloaded file from “Download Excel version of Loan amortization calculator (created by me)” link and it acutally download a WinZip file and that contains number of xml files than .xls file. Is there some other way to go about it? Rajeev

Reply

99 Manish Chauhan April 18, 2011 at 10:19 am

Rajeev

Not sure why ? It links to http://img.jagoinvestor.com/files/loan-amortization-excel-sheet.xlsx . Download it

Reply

100 Ajay April 18, 2011 at 11:13 am

Rajeev – Are you using 7zip or something ? I suggest you to open excel application and then open the file. It should open.
I think its because of one of those new formats that Microsoft introduced for Office 2007 / 2010.

Reply

101 Rajeev April 18, 2011 at 12:37 pm

Hi Ajay, different version of MS office may be the reason. I am using MS Office 2003 and just now getting upgraded to 2007.

Reply

102 Narendra Pingle April 18, 2011 at 10:42 am

Hi Manish,

The article has given detailed insight on EMI. Thanks a lot.
I have taken loan of 12L for 20 yrs. from the syndicate bank under a scheme where the interest would be as follows:
first 3 years: 8.25%
next 2 years: 8.75% & after that some 2% lesser than the PLR.
Now, i just want to know how can i calculate the exact interest amount i will be paying and would it be benefitial if i prepay the loan for every year by some chunk as the interest rate is less.

Thanks,

Reply

103 Manish Chauhan April 18, 2011 at 12:24 pm

Narendra

You interest rates are low (especially in the first 5 yrs) and hence you should enjoy that . However from long term perspective still you will be paying significant part in interest

Reply

104 NitinJ April 18, 2011 at 11:36 am

Very well written article followed up with very useful informative discussions.

Regarding part payment calculations, Is there some tool to determine the impact of part payment.

Manish, Pls share if it’s avaiable.

Reply

105 Manish Chauhan April 18, 2011 at 12:23 pm

Nitin

Periodic Part Payments will make sure that a person reduces his interest part significantly soon and reduce the tenure . What tool you want ? You can edit the excel sheet given by me

Manish

Reply

106 dr kishan April 20, 2011 at 10:46 pm

Hi NitinJ,
the impact of part payment can be readily seen if u log on to http://www.bankbazaar.com, the Loan EMI calculator has a function of adding part prepayments and seeing the subsequent impact on the total interest payment.
dr kishan

Reply

107 NitinJ April 21, 2011 at 2:14 pm

Thanks. It helped to calculate exact figures.

Reply

108 NitinJ April 21, 2011 at 2:27 pm

Below is another good tool to calculate the impact of pre payment.

http://www.finaid.org/calculators/prepayment.phtml

Reply

109 Manish Chauhan April 22, 2011 at 9:02 pm

Nitin

Thanks for the link

Reply

110 Vijay April 19, 2011 at 10:59 am

Hi Manish,

Nice article, as always.

I was wondering about following possibility. I am sure you are aware of SBI max gain and similar product from HDFC where bank offers loan from 25L+ with current account like feature. You can reduce your loan amount by adding funds to a/c and on daily reducing your interest is calculated for month.
I have opted for such option, i have 30L loan EMI is around 34K for 15Y, i keep on adding additional funds to this account and thus my interest component decreases and i can take out additional funds when i need it.
I still have to pay EMI of 34K every month but i can take it back next day.

Why this option shouldn’t save lot of money during high interest period or is there i am missing altogether!

Thanks,
Vijay

Reply

111 Manish Chauhan April 20, 2011 at 5:25 pm

Vijay

SBI max gain looks good to me as a design , all it says is put your addtional money in SBI max gain account and you get principal reduced as well as you also have the liquidity . Better you read this excellent discussion here : http://www.indianrealestateforum.com/pune/t-sbi-maxgain-advantage-10995.html

Manish

Reply

112 Lucky April 19, 2011 at 2:31 pm

Hello Manish

I have a home loan of 15 lakh with a fixed emi of 12781/- till march 2012. Loan started in feb 2010. From April 2012 my intrest rate will rise for sure.
Should I make pre-payment now or do s0 in March 2012, so that I have the tax benefit on the full interest payment of this year and reduce the increased emi burden for coming years.

Reply

113 Manish Chauhan April 20, 2011 at 5:15 pm

Lucky

Its not a one time decision like this, how long is your loan for ? If its a small tenure , then its a different thing , but if its 15-20 yrs loan , then majority of your loan goes in interest and you might want to lower it by pre-paying sooner .

Manish

Reply

114 Vivek April 19, 2011 at 11:58 pm

Hi Manish,
Nice article,
Would like to add this,
Why banks loan agent try to push you EMI payment on 10th of each month and not end of Month.
Reason they give is: “Sir if any month you get your salary late and not able to pay EMI you have 10 days to manage.”
Real reason , They want to earn extra interest of 10 days for full tenure of 20 years.

Thank you,
–Vivek

Reply

115 Manish Chauhan April 20, 2011 at 4:44 pm

Vivek

Nice point :)

Manish

Reply

116 sunil April 25, 2011 at 11:47 pm

Wonderful Manish,

I am actually thniking of repaying my loan amount completely which is around 60,000 (remaining for one year) but after calculating i feel putting that money into a Mutual Fund wold get me more money than i actually save on the interest as i am only paying larger chunks of principle amount.

Guide me if i am wrong.

Reply

117 Manish Chauhan April 26, 2011 at 12:33 am

Sunil

If its just one more year , then whats the point of pre-payment, anyways all the money you pay would mostly go in principal , so better pay per month only. also there would be pre-payment penalty if you pre-pay . So just pay the EMI for one more year

Manish

Reply

118 Ramnath April 27, 2011 at 4:13 pm

Hi Manish,

Excellent Article. I have a question for you. I have a Loan of 14lakh for 12 years. an d my monthly EMI at 8% for first year is 15,284.00

And after 3 EMI’s my loan is still 13,84,000. So if I make a Part-PAyment of 1 lakh , will this hit a Principal OR goes to the Interest amount too.
Edit Reply

Reply

119 Manish Chauhan April 27, 2011 at 5:11 pm

Ramnath

Prepay ment will hit only principal , not interest . So your outstanding loan will go down by 1 lac . Do it .

Manish

Reply

120 Ramnath April 28, 2011 at 2:40 pm

Hi Manish,

Thanks for your Reply. I have couple of questions for you.

1. The Pre-Payment of 1 lakh made will have a Pre-closure charge of 2% as i have NOT compeleted 3 years after Loan Opened.

2. Is it Good to make a RD of 2k each month and pay at one shot of 24k at the End of the Year

OR

Pay extra 2k towards the EMI?

Let me know which would be better?

Reply

121 Manish Chauhan May 2, 2011 at 12:42 pm

Ramnath

Better pay 2k as principal only and take that 2% penalty , but that 2% is penalty on what?

Manish

Reply

122 Ramnath April 28, 2011 at 4:34 pm

Manish,

i have take a SBI Maxgain home loan in Dec 2010

And According to it the ROI is

1st year 8% Fixed ROI
2nd and 3rd year 9 % Fixed ROI
and 4th year onwards Floating ROI.

By any chance my loan ROI during the first 3 years can change?

If Yes , Then why it is called as Fixed Interest rates?

regards
Ramnath

Reply

123 Manish Chauhan May 2, 2011 at 12:41 pm

Ramnath

“Fixed interst rates” means “Fixed for X years” where X can be 3 or 5 yrs, after that again its fixed but based on current rates . So its not exactly “fixed for life”

Manish

Reply

124 Manu April 27, 2011 at 6:17 pm

In a way, both go down. When you pre-pay, your principal goes down. Consequently, the time required to pay goes down, and with that, the overall interest paid reduces.

Reply

125 Manish Chauhan May 5, 2011 at 8:00 am

Yea .. But the only gray point here is that the potential time for claiming tax deductions are getting smaller

Manish

Reply

126 Balamurugan April 29, 2011 at 4:22 pm

Hi Manish, You explanation was so good.
I have a query

Will it benefit me , if i pay EMI 5000 and Part-payment as 5000 (hope this will reduce my principal) insted of paying EMI as 10,000 ?

I know EMI with 5000 will increace loan tensure. But i belive that Part-payment of 5000 will help me to close the loan earlier than paying EMI 10,000 (with short tensure).

Please do help me out

Reply

127 Manish Chauhan May 2, 2011 at 12:15 pm

Balamurgan

Nice thought , but there is a problem i see , for the loan amount, there is an EMI for a particular tenure , if you increase the tenure ,the EWI comes down , but the problem here is that the EMI can not keep coming down , at some point the EMI will reduce to the minimum level and not go down further , so see what is the minimum EMI which you need to pay for a reaslitic tenure ? come back with figures !

Manish

Reply

128 Balamurugan May 2, 2011 at 1:25 pm

Thanks for you valuable response.

I had also checked the below link for calculating the same.
http://www.finaid.org/calculators/prepayment.phtml

Reply

129 Balamurugan May 2, 2011 at 12:11 pm

Hi Manish, You explanation was so good.
I have a query

Will it benefit me , if i pay EMI 5000 and Part-payment as 5000 (hope this will reduce my principal) insted of paying EMI as 10,000 ?

I know EMI with 5000 will increace loan tensure. But i belive that Part-payment of 5000 will help me to close the loan earlier than paying EMI 10,000 (with short tensure).

Please do help me out

Reply

130 Balamurugan May 2, 2011 at 12:59 pm

Manish,

Rate Type is given as : Monthly Reducing and daily reducing .

Please explain, what is the difference between these two ?
Which one is better ?

Reply

131 Manish Chauhan May 2, 2011 at 2:15 pm

Mothly reducing means that any amount which goes towards Principle gets reduced on monthly basis , and in daily reducing its on daily basis

Manish

Reply

132 Balamurugan May 2, 2011 at 2:50 pm

Thanks Manish :-)

Reply

133 Pavan Kulkarni May 6, 2011 at 7:04 am

wow…this was a revealing article! though i new the breakup before I didnt know that shorter terms can be more beneficial esp. for smaller loans! Thanks Manish!

Reply

134 Manish Chauhan May 12, 2011 at 12:54 am

Pavan

Yea .. its just maths , if you can do some analysis , you are good

Manish

Reply

135 Lucky May 8, 2011 at 11:41 pm

Hi Manish/Jago Investor readers,

Please help me on this,

I want to go for masters for which I wish to take education loan of around 8.90 lakhs.Post my bachelors uptil now I had been working courtesy which I have saved 1.60 Lakh.
All banks give 1% interest concession on full tenure of education loan, if interest is serviced during study period which actually is repayment holiday/moratorium period.
I am in doubt if I should use some part of my savings to get 1%interest concession by servicing interest during moratorium period and rest of savings to minimize loan amount or I should use all of savings amount to minimize the loan amount and pay the loan back with original interest rate. Which one is a better deal? Would be glad if you can share the calculations involved in arriving at your conclusion.

Thanks
JG Fan Lucky

Reply

136 Manish Chauhan May 9, 2011 at 12:29 am

Lucky

I would say that if you can arrange for the interest part during study , then better pay it month by month , because if you dont, then all the interest part will be accumulated and your final EMI will rise to a good extent , but if you are sure that your salary after studies would be good enough to afford a higher EMI , then I think you can use the existing 1.6 lacs to be with you and keep for some emergency .

Manish

Reply

137 Kedar May 12, 2011 at 6:48 pm

Hi Manish,

Nice article it is…
I had this confusion from long as to pre-pay the home loan or not…I had taken a home loan of 18L couple of years back and now the outstanding loan amount is around 15.80L with interst rate of around 10%.
I wanted to pay off the loan as early as possible considering the loan as a liability. But my father insisted to continue with the EMI at least till 7 to 8 years. His point is that till 7 to 8 years, I will be paying most of the interest part and this will be useful for me for claiming the income tax.
Following is the current situation –
Currently EMI – Rs 18500.
Monthly tax – around Rs 10000.
Annual interest for the home loan – 1.44L

So I understand my father’s point that I am saving income tax on aound 1.44L annually and also getting some tax benefit on the principal part.
My question is, shall I plan to close my home loan after 7 to 8 years from now or shall I consider the option of pre-paying the loan in every quarter as suggested above?

Thanks and Regards,
Kedar

Reply

138 Md Ismael May 23, 2011 at 3:26 pm

thnx a lot manish…its an eyeopener for me..

Reply

139 sudharkar May 26, 2011 at 11:17 pm

I took a loan for 44L @ 10.75% from Axis. I did a prepayment for 3L and they reduced the tenure from 240 to 228 months. is there a calculator available to confirm the reduction in tenure is correct or not?

Reply

140 mercury May 27, 2011 at 8:30 pm

Hi interesting reading.

my question is, isn’t there any RBI ceiling on the maximum percentage of the interest component which may be charged by a bank?

for instance if in the first five years of a 240 month loan of 27 lakh, if I am paying 3 lakhs per year, my repayment towards the principal component is only about 27,000, which I feel needs to be regulated. What do you think?

Reply

141 Ritesh August 16, 2011 at 1:11 pm

HI Manish
I have a query regarding Principal and Interest component of EMI. I have taken a home loan of Rs.20 lakhs (Interest rate : 9.5%, Duration: 20 years). As per my calculations and the caclulator provided by you EMI should be Rs.18643 with interest component of Rs.15833 and principal component of Rs.2810 for the first EMI. Where as per the bank statement Rs.17,356 was deducted as interest and Rs.1,287 was deducted as principal component in EMI.
It would be great if you could shed some light on the same.

Thanks in advance.
Ritesh

Reply

142 Ritesh August 18, 2011 at 2:41 pm

Problem resolved after talks with the bank representative.
The home loan interest rate has been increased to 10.75% :-(

Reply

143 Shwetansh September 23, 2011 at 1:53 pm

Dear Manish.

I want to Know regarding mine Term Loan . I have taken a Term Loan of 16 Lacs From SBI for Three Years. Till Today mine Account come under NPA Accout. Outstanding Till Today Mine Standing is 12.20 LAcs They have given me a Notice to Regularise it or they Will Use Take over The mortage Property.. Now i can’t pay at this time…. i can pay it with 4 -5 months from now. How i can Get the time from bank for it…. One more this is that i will have 10 Lacs within these 4-5 months. so what should i do in this case. please tell me

Reply

144 Manish Chauhan September 24, 2011 at 9:25 pm

Shwetansh

Your query is not clear to me ,the term plan covers you form death, how is it related to you not able to pay back the loan

Manish

Reply

145 Dd gururani October 6, 2011 at 9:07 am

Hey Manish,
Just happened to read this nice article of yours..awesome.
Can you be kind enough to forward all your loan related blogs to my mail..
thanks.

Reply

146 Manish Chauhan October 6, 2011 at 9:15 am
147 jaya October 13, 2011 at 2:28 am

Hi Manish,

I have taken a loan of 20 lakhs and I am prepaying the loan and now the balance is only 10 lakhs. Can I ask the bank to adjust my EMI to the remaining tenure?

Reply

148 Manish Chauhan October 14, 2011 at 11:10 am

Jaya

Depends on the bank , you can ask them to readjust the EMI , but because you might have given the PDC (post dated cheques) , there might be reluctance

Manish

Reply

149 Vibhor October 15, 2011 at 2:02 am

Excellent article and awesome discussion! I am planning to go for a home loan and trying learn all these intricacies. :(

Manish, can you also please shed some light on the tricks behind the “No EMI” feature marteked by builders (in conjunction with banks) these days for buying a house? Are there some hidden factors that we should know?

Thanks in advance.
- Vibhor

Reply

150 Manish Chauhan October 15, 2011 at 11:56 am

Vibhor

Mostly they are gimmicks , if you do maths , ultimately its not in the favour of cusomter , you can read this related article : http://foundation.moneylife.in/article/unreal-schemes/12126.html

Manish

Reply

151 Vibhor October 16, 2011 at 12:33 am

Thanks for your inputs Manish, but it still partially resolves my concern. I am planning to buy a property under “No EMI” scheme, where the builder proposes no EMI for 24 months and possession in 27 months. Buying any other property would mean that I have start paying pre-EMI from day 1, which would be tough along with paying my current rent, as most of the builders are showing that they have already built upto 2nd roof, hence even under CLP plan they would ask me to pay around 50-60% within around 45 days. Therefore I am kind of getting interested with no EMI scheme, but am trying to understand if there shall be any tricks with it.

Thanks for your responses.

Cheers,
V

Reply

152 Manish Chauhan October 16, 2011 at 6:41 pm

Vibhor

There are some points here ..

1. Real estate sector is going through rough time and getting cusotmers is not as easy as it was earliar , so it can be a genuine measure from builder side to get a customer

2. Another point is that the no EMI might be priced already in the final price of the HOUSE , what if the actual cost was 30 lacs with EMI from day 1 and builder tells you no EMI for 2 yrs , with cost of 35 lacs .. then whats a big deal .. so its not a FREE lunch , it might be factored in the price itself .

What is it that you need to pay in the start to him ? the booking amount ? Who is the builder , It would be good to initiate a conversation on http://www.indianrealestateforum.com/ , I really recommend that and i am sure you will benefit from the community there !

Manish

Reply

153 shiva October 30, 2011 at 10:38 am

Hi Manish, My doubt is, when an amount is prepaid, the complete prepaid amount is deducted from principal amount only or from the total EMIs amount for the complete loan tenure..? Thank you !

Reply

154 Manu October 30, 2011 at 12:01 pm

Hi Shiva,
I can answer that as I am currently prepaying my home loan. The EMI consists of an interest component and principal component. At the beginning of this year my home loan outstanding was Rs 10 laks. My EMI had Rs 8500 as interest and Rs 1800 as principal – so overall it was Rs 10.3 k per month for 15 yrs. Over the last few months I have managed to prepay Rs 4 laks. The EMI remains same, but now interest component is down to Rs 6000 n principal is balance.

In other words, prepayment reduces the principal outstanding overall n the effect is the decrease in interest payments on your EMI.

Reply

155 shiva October 30, 2011 at 7:30 pm

Dear manu,

Thank you for response ! so it is wise to prepay whenever we get money by some source..ok. thanks again !

Reply

156 smith October 30, 2011 at 10:52 pm

Mis-leading article …Don’t prepay anything ..when you take loan of 20L for 20 years and at the end of it your property would be worth 1.20 crore easily. now assume, you got 5L in the first year that you want to prepay ..instead if you invest that 5L in some land or stock and it would be 50L after 20 years going by past returns from real estate industry.

Reply

157 Manish Chauhan November 5, 2011 at 4:20 pm

Smith

Not sure if thats very convincing , Prepayment is not only done from returns point of view .. there are other reasons also like getting out of debt “feeling” .. decreasing the fear of “What If I loose the job and cant pay off the loan later” … also with prepayment , your EMI duration will go down or EMI might go down and hence you are left with more money … So kindly give a proper comparision of with prepayment and without prepayment

Manish

Reply

158 smith November 5, 2011 at 7:01 pm

That’s something that i agree. Being indians the “feeling” of coming out is something important to us.

Reply

159 Rahul Sharma November 1, 2011 at 10:51 am

Hi Manish, excellent and enlightning discussion. Well I also hav a query, I have taken two home loans (13 lakhs for 20 yrs @ 10.25% starting Jun 2009 and 14 lakhs for 10 yrs @ 10.75% starting July 2011) for two properties, of which one is utilised by my wife (joint owner) for IT rebate and other one is utilised by me for the same reason. I now hav enough funds to repay both the loans, however, I am planning to go for third property (for which I’ll have to again take loan of about 50 lakhs). Please advice whether I should prepay the existing loans (with this option I will have to take even higher home loan for third property) or continue with the existing loan and take additional loan (50lakhs) for the third property because managing so many home loans (3) will be cumbersome as also without any IT benefit from the third loan planned.
Secondly, do you have any calculations to know what is the effective rate of interest on home loan after taking IT rebate into account ?

Reply

160 Manish Chauhan November 5, 2011 at 1:51 pm

Rahul

If your cash flows are strong , and you can service the EMI’s even if your income drops a bit or EMI increase a bit, then its suggested to go for loan itself, but if you are into a tight position , then better prepay the loans and take a further loan for 50 lacs , you have to compare both the situations and do some numbers .. have you done anything from your side ?

Manish

Reply

161 Rahul Sharma November 5, 2011 at 8:28 pm

Hi Manish, thnx for the prompt response, really grateful. Well, my present outgo in EMI for existing home loans is Rs 32000/- and I hav a stable income of Rs 1.8 Lakhs PM. I hav reworked on my third home loan requirement which is Rs 25 Lakhs (not 50 lakhs as mentioned earlier) and that too in 2013 since the third property I hav gone for is under construction, if I do not prepay my existing home loans. In case of a financially tight situation or increase in EMI, which can be a possibility with anyone, I have some investments to fall back to. With this as a backdrop, I need your advice to either go for prepayment of existing loans(s) or go for third home loan from Return on Investement perspective.
My Second query continues as earlier ie. do you have any calculations to know what is the effective rate of interest on home loan after taking IT rebate into account considering I am in 30% IT bracket ?

thnx n rgds, Rahul

Reply

162 Manish Chauhan November 5, 2011 at 8:36 pm

Rahul

I am not sure what are your other cash flows , but with 1.8 lacs of inflows , 32k in EMI is smaller outgo compared to standard percentage .. I guess if your income is stable and also expected to RISE :) , you can go for the third home loan too … and you should be getting the tax advantage also , why do you think you will not ?

As you have 2 yrs in hand , I am sure there will be more CASH coming in and that you can use to prepay partly your earliar loans .. If your cash flow is strong and networth is “respectable” , then just go ahead ..

But make sure you take responsibility of your decision and have a plan B clear in mind, not because you are fearing anything but just from planning point of view .. here i am trying to be little aggresive in my recommendation .. after all … without aggression , you wont go very far :)

Manish

Reply

163 Rahul Sharma November 12, 2011 at 6:36 pm

Hi Manish, thnx once again for the response. Well my cash outflows other than EMI are 30000/-PM in SIP and 60000/-PM for household expenditure. On an optimistic note, I agree my income will be stable and even rise in future and I can go in for third loan comfortably. How do u say I can get tax benefit from third property coz I think one can avail tax benefit for one residential property only which me and wife are already claiming from existing two properties, pls throw some more light on this aspect.
Do u recommend partial prepayment of any existing home loan (i would like to mention here that LIC HFL has a unique recovery policy wherein they are recovering both principle and interest equally in EMI even though loan has commenced in July 2009). Thanx n rgds

Reply

164 Manish Chauhan November 13, 2011 at 6:28 pm

Rahul

So total compulsory outgo is EMI + Household = 92 , lets say 1 lac , so you are left with 80k per month , you can stop SIP thing for now if you want to go for home loan . Is this 80k Enough for all the EMI’s you will be having other than your current EMI ? If yes , then you can go ahead with next loan . If think it was pretty simple to conclude , where exactly are you stuck and want the advice ?

Manish

Reply

165 sujit sudhan November 2, 2011 at 4:31 pm

hey!..can you update your excell sheet by providing additional column for prepayment (variable) for each month.
And even variable ROI ,as ROI changes everytime RBI screws!

with these incorportions, your excel sheet will be best for planning loan payment.

Regards and Best Wishes,
Sujit

Reply

166 Manish Chauhan November 5, 2011 at 1:17 pm

Sujit

Will do it some time when i get dedicated time for that . for now you can find out how to do that . its pretty easy actually

Manish

Reply

167 sumit November 25, 2011 at 9:12 pm

hi manish , lik ur post !
can u suggest me hw do i pay the prepayment of my home loan. i hv taken a home loan from HDFC on dec 2010, loan amount is Rs3500000 and the tenure is for 20yrs till nw i m paying EMI ie. Rs34477 . can u suggest me hw do i pay my prepayment amount for the coming yrs ?

Reply

168 Manish Chauhan November 29, 2011 at 3:18 pm

Sumit

All i would say is try to prepay as much as possible when ever you get the opportunity

Manish

Reply

169 lalchandra November 29, 2011 at 4:51 pm

Hi Manish,
Sorry Manish , I didn’t understand the Breakup of EMI. How Principal Amount Calculated? Interest Part i got it and how principal amount calculating Manish.

Reply

170 Manish Chauhan November 30, 2011 at 9:03 am

lal chandra

Actually you know EMI number and Interest number for a particular month, just deduct Interest amount from EMI and that will be PRINCIPAL , you can do it for any month .

Manish

Reply

171 Ansh December 1, 2011 at 1:25 pm

Manish, very useful article.

One concern i have is related to Home loan where loan is on Flexi plan. Now the case is that person A has taken 30L loan from bank where home is under construction. Bank says to start EMI after 2 years and person A has taken 15 L amount as disbursement from bank and paying the interest as well
Once 2 years completes, what should be EMI in this case.. is it on the total loan amount 30L or disbursed amount 15L ?

Reply

172 Manish Chauhan December 4, 2011 at 7:43 pm

Ansh

At any point of time, the interest is aloways dependent on the LOAN OUTSTANING .

Manish

Reply

173 Ansh December 9, 2011 at 6:39 pm

Thanks Manish, but my concern here is that the case is where the person has taken only 15L as disbursed amount, in that what should be EMI.. is it the whole EMI based on 30L loan sanctioned or is it the EMI based on 15L amount disbursed from bank ?

Reply

174 Manish Chauhan December 13, 2011 at 9:18 pm

Ansh

EMI would be only for the loan disbursed till date .. but this is the question you should ask the BANK directly

Manish

Reply

175 deepak December 9, 2011 at 10:10 pm

Hi Manish,

I have takenup loan of 35,62,000(34,60,000 Loan + 1,02,000 Insurance) for 25 years form SBI @10.75. my EMI would be around 34270.
Initially i was planning to go for taking 35,00,000 Lakh for 20 years tenure but I was getting this amount only for 25 years due to lower takehome salary/month.

Now I got very good hike in my salary. could you please suggest me what should i do at this point of time when i can pay more then my current EMI.

1. should i pay more amount along with my emi
2. should i pay some lumpsump amout after each quarter

Please provide your expert opinion.

Thanks,
Deepak

Reply

176 Manish Chauhan December 13, 2011 at 9:11 pm

Deepak

Better you pay some excess amount each month . that would make sure your loan closes in just 15-16 yrs

Manish

Reply

177 deepak singhal December 17, 2011 at 6:56 pm

Thanks Manish for your prompt Reply.

Could you please help me , in which account i should put more money, should i put on SBI max gain Over draft account or SBI Suraksha Loan account,

I am bit confused :(

Thanks,
Deepak

Reply

178 Manish Chauhan December 17, 2011 at 7:14 pm

Deepak

Not that way .. just do a simple prepayment which will reduce your principle amount

Manish

Reply

179 deepak singhal December 18, 2011 at 4:33 pm

this prepayment should be made towards loan account or maxgain over draft account?

or what is the process to make pre-payment.

Thanks a lot.
Deepak

Reply

180 Manish Chauhan December 18, 2011 at 7:33 pm

Deepak

Towards loan account and the process is to make extra payment for your home loan , check with your bank

Manish

Reply

181 Fuad December 14, 2011 at 4:45 pm

Dear

I have selected Loan Tenure 60 month, Yearly Interest Rate 10% and Total Amount of Loan Rs. 100,000.00 your EMI size Rs.2124.71 and last installment is showing Rs.2124.28 but actually it should be 2715.265

Appreciate your comments in my Email.

Thanks

Fuad

Reply

182 Manish Chauhan December 14, 2011 at 8:44 pm

Faud

Which figures are you talking about ? I have not considered any processing fees or extra charges

Manish

Reply

183 Jiten Dalvi December 24, 2011 at 6:30 pm

I had availed Rs. 4,65,000 home loan from ICICI Bank in year 2005. Currently Rs.4,00,000 is my outstanding loan amount and interest rate will be 8.25% till Feb,2012. Since last few years RBI is changing Repo rate every month which is directly affecting home loan interest rate and tenures. I am planning to repay entire Home loan outstanding amount by borrowing Personal loan from some other bank. Personal loan interest is 16% for 60 months. Does it make sense to close home loan by taking Personal loan. Pl advise. Thanks

Reply

184 Manish Chauhan December 24, 2011 at 9:16 pm

Jiten

Not at all .. why do you think that it makes sense to pay the home loan by personal loan ? Does it makes sense to pay 16% to pay something where you are paying 8-10% . I am interested to know why you thought like that ?

Manish

Reply

185 Ash January 16, 2012 at 5:00 pm

Hi Manish,

I am planning to buy a plot in undeveloped area which I want to
Make my residence. Plot cost is 80 lakh. I have 30 lakh in hand.
My salary is 1.5 lakh per month. Can I afford this plot.
Secondly, I am keen to buy bigger plot of 1.2 crore. I have another flat which I want to sell for 30L.

So, which plot should I buy?
Shall I sell the flat first and then go for bigger one? As I am not sure that plot will be available.
I know these questions are not related to your post but Your opinion will be valuable

Reply

186 Ash January 16, 2012 at 5:06 pm

Hi,

My salary is 1.5 lakh/mo. I want to buy a plot.

Small One is 80Lakhs. Bigger one is 1.2 crore.

I have 30lakh in hand and also have a flat of 30lakh worth. I pay monthly rent of rs 40,000.

Shall I get loan and buy bigger plot or smaller. Please suggest.

I know my query is not related to your post but you opinion will be valuable. Please suggest

Reply

187 Karthik January 18, 2012 at 12:14 pm

Hi manish,
Not sure if I will get a reply as its been quite sometime that this threads last post was posted. I took a loan for 17.5Lakhs from LIC Housing Finance. We sold our family property and I got a share of 4Lakhs,which I want to put into the principal amount. 2 questions here:

1.LICHFL agent says i have to pay 2% penalty..Is it correct? I heard RBI has weaved these penalties.But LICHFL denies it.

2.Once i pay this 4l, the outstanding comes down to 13.5. So will the Tenure come down? Or they will decrease my EMI amount? I effectively want the first option.

Request your valuable inputs

Reply

188 Manish Chauhan January 18, 2012 at 1:33 pm

Karthik

1. Yes .. the penality might be there .. didnt you check this while taking the loan that how much was the prepayment penality ? generally these penalities are only when you make a very big lumpsum payment . Most of the companies allow some prepayment per month (approx upto the EMI value) , so you can make the prepayment per month for some amount without penality .

2. Yes , Outstanding loan will come down and mostly your tenure will come down . EMI;’s are generally fixed and this is the best option

Manish

Reply

189 Karthik January 18, 2012 at 2:37 pm

Thank you Manish. No I didnt check it while taking loan.perhaps i didnt had that thought that I will do some part payment in the interim..
Once again thank you :)

Reply

190 Rahul January 19, 2012 at 3:46 pm

Hi Manish,

Have been following your blog quite religiously for the past few days….its fantastic.

As others, I also have a home loan with ICICI of around 7 lacs which I took in 2007 for a period of 15 years on floating rate of interest, which has magically been changed to 40 years now. I have been paying my EMIs, currently the interest rate is 15% coming up with an EMI of Rs. 8753. I am planning to pay around 4 lacs of my loan as a part payment. What will be my balance loan amount once that amount of 4 lacs has been paid off and I keep the same EMI.

Thanks in advance.

Rahul

Reply

191 Manish Chauhan January 20, 2012 at 11:13 am

Rahul

Nothing has happened magically, Its just maths .. When interest rates go up , either your EMI has to increase or your Tenure , in most of the cases banks increase tenure, which goes up like anything if they have to keep up the same EMI , so thats the reason your tenure has gone up , dont worry a lot on this . You can prepay your loan for 4 lacs and then that amount will be deducted from your outstanding loan (assuming its 7 lacs right now) , so it will come down to 3 lacs , keeping your EMI as at amount ,your tenure will come down drastically .. and I would suggest better prepay this loan soon now ..

Manish

Reply

192 Rahul January 20, 2012 at 2:53 pm

Thanks a lot for the response Manish.

ICICI is not accepting any online transaction for the part payment. As we do not live in India anymore, what is the next best option. ICICI has given us the option of Power of Attorney, but its quite a lengthy process. if there is nothing else, we will have to go ahead with this. How good is this option and how long does it take for them to accept and credit the cheque in our loan account?

Appreciate your time and response.

Regards

Reply

193 Manish Chauhan January 21, 2012 at 1:48 pm

Rahul

Do one thing , trying adding your LOAN ACCOUNT NUMBER as third party into your internet banking account , and try to make a test payment of Rs 1000-2000 , Some guys told me that this way they can make the prepayment and it has worked for them , If this is successful , you can make the part payment using this method .

Otherwise , what else they expect ? Are they ok with you sending a cheuqe to them ? Or you need to be physically be there, in which case you might want to wait till your next trip to india.

One thing , try to threaten them that you are considering to shift your loan to other bank and this is because the prepayment is not getting accepted by them online , they might work out something !

Keep me updated

manish

Reply

194 Rahul January 21, 2012 at 5:27 pm

Thanks Manish..

I am not really sure how to do the third party thing. I would try that if guided by you.

We did have a long discussion with ICICI the day before regarding our online prepayment. We did talk to the customer service department and the supervisor regarding the same. They were not able to give any other option to us than to visit India and pay the money or only through Power of attorney.

We requested them to transfer us to the branch from whom we have taken the loan (we were told we cannot talk to the branch) or to the person who is the decision maker (the manager or any other personal), they said they would contact us back but we havent heard anything from them yet.

I will try talking to them again and will use the loan transfer thing…lets see if we can convince them.

Will surely keep you posted…thanks a lot for your replies. I will wait for the guide about the third party account creation.

Thank you.

Reply

195 Manish Chauhan January 21, 2012 at 5:54 pm

Rahul

Its extremelly easy process actually .. just like you add a third party bank account when you wnat to transfer the money to him , in the same way you can add your PPF account (confirmed , see this post : http://www.jagoinvestor.com/2011/12/ppf-account-online-investing-netbanking.html)

Now in the same way you can also add your LOAN ACCCOUNT NUMBER (unconfirmed , but some one told me this can be done) , so just put the nickname as “LOAN ACCOUNT” , put account number as your LOAN ACCOUNT NUMBER and then when it comes to choose the address , you can put the brach address from where you took that loan

Based on this try to atleast add the account , lets see if account addition helps ?

Manish

Reply

196 Rahul January 21, 2012 at 6:16 pm

Hi Manish…

Nope it doesn’t let me add my loan account as a third party account :( becoz it is from the same bank.

The only option I am left with is to call them and see if they can do anything for us (which I seriously doubt) else will go ahead with the POA option as I want to clear at least half of my loan at the earliest.

Thanks for your guidance…please keep up the good work through your blog.

Reply

197 Manu January 21, 2012 at 6:04 pm

I have done the similar way for SBI. In the last few months I have paid off a substantial chunk online without visiting the bank – in fact they themselves suggested this option. What Manish said should be possible with ICICI bank. It’s like setting up an account to which you transfer funds – lets say you send some money to your parents every month. You would have added their account in third party transfer section. Same applies to loan account. Hope this helps.

Reply

198 Rahul January 21, 2012 at 6:48 pm

Manu…guess you were lucky to have had the loan account with SBI :) unlike us :(

Reply

199 JJ January 19, 2012 at 7:04 pm

Hi ,

If I want to buy a 2 BHK for Rs. 3364000, How much do you think I would be paying Downpayment? and also how much loan can I get if my AI is 8.4Lak / Annum

Reply

200 Manish Chauhan January 20, 2012 at 10:59 am

JJ

totally depends on banks , its generally 20% downpayment

Manish

Reply

201 Ashish Hota January 20, 2012 at 1:54 am

Hi Manish,

I was reading your BLOG and its really fantastic and have lots of information.

I have taken a home loan of 20 lacs from SBI on OCT2010 for 20 years. Last Month I have done a part payment of 5 lacs. So the balance amount is somewhat close to 15 lacs.

Can you please suggest, if it is better to do some more part payments in the coming months (as I have some money) so that I can bring down the principal amount.

I was planning to pre-close the loan within this year.

Thanks in advance
-Ashish

Reply

202 Manish Chauhan January 20, 2012 at 10:24 am

Ashish

You can actually keep some part as loan as it gives your tax advantage . Why do you want to close the loan fully ? depends on the interest you are paying ..

Reply

203 Ashish Hota January 23, 2012 at 9:51 am

The interest is first year 8% fixed and then two year 9% fixed and then floating. I just want to get rid of the Loan ASAP. I’m currently working at Onsite and hopefully will work here for another two years, so I will not be getting the TAX advantages. If you suggest then I can pre pay 60 – 70% of the loan amount by this year and rest of it I will keep it for the Tax advantages.

Reply

204 Manish Chauhan January 23, 2012 at 5:54 pm

Ashish

Then if you have hte money , better prepay the loan .. once you come back , you can always buy another house and claim tax deductions

Manish

Reply

205 deepak singhal January 28, 2012 at 4:51 pm

Hi Manish,

how to come up with a figure or potion of loan which can be kept for tax advantage,

Thanks,
Deepak

Reply

206 Manish Chauhan January 29, 2012 at 2:33 pm

Deepak

Why do you need a formula for that .. do the maximum amount if you can , else do what amount you really have

Reply

207 Gowtham January 24, 2012 at 2:25 pm

Hi Manish,

I am in confusion…i hope u wil clear that…..
I took a home loan of 25 lakhs at 13% interest and 20 years tenure. Its now a year.
As nw the market interest rates in other banks are less,i am planning to move to other bank.But here the Preclosure charges are 5%.
And i can prepay 1 lakh a year apart from EMI’s.
So my Confusion is that whether i should switch to other bank r stay in the same bank????
?:|

Thanks in advance

Reply

208 Manish Chauhan January 24, 2012 at 2:36 pm

Gowtham

Even in other companies, the low interest rates are only for 1-2 yrs and then they all get changed to floating inteest rate and even their the same thing can happen , with 5% closure charges ,you will not really gain a lot , But what you can do is ask your bank about it and threathen them that you are planning to change your loan bank , and ask them to provide you same lower interest rate . generally banks do this at a cost , you will have to pay a small fees for this.

Manish

Reply

209 Gowtham January 27, 2012 at 6:33 pm

Thanks Manish…

Reply

210 muniraj January 27, 2012 at 7:56 pm

Thanks for sharing the valuble info.

I have one question.
How do we calculate first month’s principle amount…

If you could reply to this mail.. it would be great
muniraj.shanthakumar@ness.com

Thanks in advance…

Reply

211 Manish Chauhan January 28, 2012 at 10:15 am
212 Vidyanand Nayak January 30, 2012 at 9:18 pm

Hi Manish,
I have borrowed loan from IDBI bank for Rs. 2,476,540.00. Since I opted for under construction property I paid Pre-EMI of 134,560 plus total EMI which is (Rs.530,447 in Interest and Rs 119,770 in Principal). Now that I intend to close the account by paying the outstanding amount from own source, the bank is charging me the amount of Rs.25021 which they claim to be normal interest charged until the outstanding amount is realized.
My EMI hits 10th of every month and I plan to foreclose the loan account by 9th of coming month still the bank is charging with me the interest of ROI. So I eventually end up paying the interest even I am closing the loan account before my next EMI date.
I was never informed about this before and came to my surprise when I received the foreclosure letter mentioning about the amount to be paid as interest to the bank.

I believe this is clear cheating from the bank of such repute. Could you suggest what can be done in this case to avoid myself from paying the additional interest levied by the bank?

Thanks in advance!

Vidyanand Nayak

Reply

213 Manish Chauhan January 30, 2012 at 11:28 pm

Vidyanand

Was it not mentioned in the contract done by you and bank , I doubt so .. it must be clearly mentioned in the contract , if its not , then bank cant do it , you can complain to RBI on this .

Manish

Reply

214 Vidyanand Nayak January 31, 2012 at 3:50 pm

Hi Manish,

Thanks for your response. i believe all banks are charging the simple interest til date the outstanding amount is realised by the bank.

Checked with executive from multiple banks,even RBI does it.

Reply

215 Ankur Jain February 8, 2012 at 12:40 am

Hi Manish,

That was a great post, opened my eyes on tenure part. We tend to take loans on higher tenure considering it will ease up our life but as you noted in comment #49-50 above, even if we’re pre-paying after 5 years bank will still charge interest for the rest years too! Common sense may say it is pre-posterous but on the other hand I do understand bank’s point of view too.

Here are some questions spinning inside me now-

1) Acc. to financial advisors, what percentage of our salary should constitute our EMI? (I understand it may vary acc to individuals, just asking an expert opinion)

2) Do you have an article on which banks rule the roost when it comes to customer choice, customer satisfaction, hassle free and yet are low on loan %age?

3) I am planning to take a joint loan for a house in my mother’s name? Do you have any general idea about the maximum age banks and HFCs allow for loan as a co-owner?

4) Do banks allow an increase in tenure mid-term? Example – Let’s say if I take a loan for 15 years tenure today and god-forbid after ‘n’ years I decide to extend that loan for 5 more years, do banks allow that?

Reply

216 Manish Chauhan February 8, 2012 at 1:34 pm

Ankur

1. this has no standard answer , but I think it should not cross 40% of your take home , I say this considering that another 40% should be your house hold related expenses and then 20% of cushion should be there..

2. No we dont have that . but teh best way to find it out would start a thread on our forum : http://www.jagoinvestor.com/forum/ , see mouthshut.com also for this

3. No , again use http://www.jagoinvestor.com/forum/ and do your own finding , in such a big task and goal , never rely on other info , take pointer and then do your own findings

4. No I dont think thats allowed ,also the max term anyways is limited to 20 yrs ..

Manish

Reply

217 Ankur Jain February 8, 2012 at 12:52 am

Well revisiting your comment #50, I think I still didn’t get that. If we are thinking in terms of “loan outstanding” then what is the advantage of pre-payment of loan?

Reply

218 Manish Chauhan February 8, 2012 at 1:22 pm

Ankur

When you prepay , all your money goes towards PRINCIPAL AMount and your loan outstanding comes down , which means more principal payment and less interest compared to what you used to pay before the prepayment ..

What else did you expect from prepayment ? I am not clear why you dont think prepayment helps here ?

Reply

219 Ankur Jain February 8, 2012 at 6:21 pm

Probably I misunderstood your comment #50. Let me ask you when you say Loan outstanding, what does that mean –
Is Loan Outstanding = Remaining Principal OR
is Loan Outstanding = Remaining Principal + Remaining Interest?

Reply

220 Manish Chauhan February 8, 2012 at 6:52 pm

Ankur

LO = Remaining Principle

Reply

221 Suresh Naidu Gali February 13, 2012 at 10:07 am

I was having home loan in ICICI and preclosed the loan on aug of 2011 – 12 finalcial year with the amount of 3.5 Lacs in 2 instalments. Can i get the Exemption on the amount paid againest intrestfor the period.

Reply

222 Ashal Jauhari February 13, 2012 at 10:50 am

Dear Suresh, Yes you ‘ll get the benefit of the interest paid till the date of foreclosure of your loan, paid by you to ICICI Bank.

Thanks

Ashal

Reply

223 Suresh Naidu Gali February 14, 2012 at 2:38 pm

Dear Ashal,

Thanks for the information.

Reply

224 Manish Chauhan February 13, 2012 at 8:25 pm

yes , but the limits will apply !

Reply

225 basheer February 18, 2012 at 11:11 pm

Hi Manish,

Very nice article and all the suggestions mentioned here will definitely help me a lot to make a decision on taking home loan. I am almost finalizing a flat worth 37 lakhs. I am paying 20% and 80% as loan from a bank. Even though I have to yet finalize the bank. I am preferring SBI since I have my salaried account and seems they are also charging the same interest as other private banks and they have better prepay options than others. Suggest if anyother bank looks attractive at this moment. My take home is 75K, and I don’t have any other obligations except the monthly expenditure of 30K. So I am planning to take loan for a period of 15 years. In between probably I have to go to onsite where I can save some amount, which can be used as prepay. Please share your suggestions.

Reply

226 Manish Chauhan February 19, 2012 at 12:59 pm

Basheer

Yea it will be a good option , considering your total EMI does not cross 50% or 40% of your take home , you can do ahead . Also see if you can go for 10 yr loan if possible for you .

Manish

Reply

227 basheer February 19, 2012 at 9:38 pm

Thanks Manish.

Reply

228 Ashal Jauhari February 19, 2012 at 8:09 pm

Dear Basheer, Please opt SBI’s Maxgain home loan for yourself. Please contact your branch for more details on the same. Go for around 28-29L Rs. loan amount & rest from your own pocket. For a 15Y period, the EMI ‘ll be around 31-32K Rs. Which is around 45% of your take home pay so not bad.

Thanks

Ashal

Reply

229 basheer February 19, 2012 at 9:39 pm

Thanks Ashal.

Reply

230 Naveen Bhatt February 20, 2012 at 12:40 pm

Dear Manish

My age is 26 and i am planning to opt for a home loan of 16 lacs for a tenure of 20 years @ 10.75.I plan to pre-pay 2 lacs per year apart from the regular EMi’s till the loan closes since that’s the amount which i can easily afford.Now my query is that keeping in mind the figures that i have mentioned, for how many years would i need to pay the loan amount (EMi + pre-payment amt.) and how much total amount would i end up paying(EMi + pre-payment amt.)

kindly advise.

regards…Naveen Bhatt

Reply

231 Ashal Jauhari February 20, 2012 at 6:02 pm

Dear Neeraj, If you are paying 2L Rs. yly as part prepayment, within next 6-7 years you ‘ll be able to close your full loan.

Thanks

Ashal

Reply

232 Manish Chauhan February 21, 2012 at 12:30 pm

Naveen

There is a calculator which you can use http://jagoinvestor.com/calculators/html/loan-amortization.html . This will give you some direction . Also forum is a better place to get more discussion on this : jagoinvestor.com/forum

Reply

233 Veerendra February 21, 2012 at 4:19 pm

Hi Manish,

I have a query regarding RPLR spread.
My loan is on floating interest rate. Currently RPLR spread for my home loan is 5%. The financial organization is offering 6%. In return they are asking for conversion fee (0.5% of outstanding principle).
My outstanding is approximately 23.5 Lacs and 144 EMIs left to pay. Conversion fee is coming around Rs 11750/-
Is this deal any good or bad?
any suggestions?

Thanks

Reply

234 Veerendra February 21, 2012 at 4:27 pm

Hi Manish,

I have a query regarding RPLR spread.

I have a home loan with floating interest. My current RPLR spread is 5%. The financial organization is offering me 6%. In return i will have to pay conversion fees (0.5% of the outstanding principle)
In my case outstanding principle is 23.5 lac and 144 terms to pay. The fee is coming around Rs. 11750.

Is the deal good or bad?
Any suggestions?

Thanks

Reply

235 Ashal Jauhari February 21, 2012 at 11:54 pm

Dear Veerendra, yes the deal is good. Against this payment of 0.5% processing fee, you ‘ll be able to save a lot. How? I assumed your current applicable interest rate is 11.75% & you ‘ll get 10.75% as your new rate.

For the same EMI i.e. you are paying as of now, your tenure ‘ll come down from current 144 to 132. It’s a saving of 12 months or full 1Y. Multiply these 12 months to your actual EMI amount & you ‘ll be able to see the saving. Against this you w’d have to calculate the opportunity cost of that 11750 Rs. that you w’d pay as conversion fee. If you invest those 11750 Rs. @ 9% for next 12 years, your maturity amount ‘ll be around 34200 Rs.

So final take, go for conversion.

Thanks

Ashal

Reply

236 Manish Chauhan February 23, 2012 at 4:56 pm

http://www.jagoinvestor.com/forum/ will give you better answer

Reply

237 Ranjan February 22, 2012 at 3:29 pm

Hi Manish,
I am planning to take a home loan for ready to move Apartment. The apartment is got loan from LIC and the builder is also insisting to take it from LIC. Is it good to go with LIC or shall I opt any other. I have a plan of 30L loan. Do LIC charge on part payment in home loan.

Thx

Reply

238 Ashal Jauhari February 23, 2012 at 10:58 am

Dear Rajan, I assume you mean LIC housing Finance. Well, it’s a good HFC & you may go with it. After NHB, guidelines no HFC can levy pre penalty charges. You are free to prepay as much amount as you wish.

Please go ahead & our best wishes in advance for your dream home.

thanks

Ashal

Reply

239 Ranjan February 23, 2012 at 11:11 am

Thanks Ashal.

Reply

240 Ranjan February 8, 2013 at 10:55 am

Dear Manish/Ashal,
I would like thank both of you for your time in replying to a lot of query which helps a lof of people around the world you cant imagine.

Loan Details:

LIC HFL
Loan amt: Rs 3244000/-
Interest rate : 10.7 fixed for 3 years
Loan term: 20 yrs
1st EMI : June 7th 2012
EMI amount( 32925/-)

Can you please clarify the below point.

I Would like to pay 1 lakh rupees as part prepayment in this March end.

Can you please tell me how much tenure will be reduced from 240 months.(Assuming EMI fixed amount).

Pls mention the calculation formula.

Thanks a Lot
Ranjan

Reply

241 ASHAL JAUHARI February 9, 2013 at 4:16 am

Dear Ranjan, the term ‘ll come down by 21 months to 219 months if the ROI remains same. if it also comes down, the term ‘ll go down below 219 months, If it increases from here onwards, the term ‘ll go up again.

thanks

Ashal

Reply

242 Ranjan February 9, 2013 at 3:21 pm

Dear Ashal,
Thanks for the information. If you see my details, I have already paid 9 months (i.e paying from June 7th 2012). So by taking this updated info and considering from March onwards how much tenure will reduce. Can you please share how you arrive at the figure 21 months reduction.

Regards
Ranjan

Reply

243 ashal February 9, 2013 at 4:52 pm

Dear Ranjan, I calculated for exact details. So out of total 240 months, your term ‘ll be 219 months. As on date, you are already past 9 months, so your remaining term ‘ll be 210 months instead of 231 months in the original schedule.

Hope it clarifies your doubt.

Thanks

Ashal

Reply

244 ashal February 9, 2013 at 4:56 pm

Dear Ranjan, As you are already past 9 monthsd, your remaining term ‘ll be 210 months from here onwards.

Thanks

Ashal

Reply

245 Ranjan February 12, 2013 at 8:56 am

Dear Ashal,
I am not clear how you have arrived at the figure 210. Please explain, I am poor in this field.

Total period in months = 240 months
Paid as of Feb 2012 = 9 months
Remaining Months to be paid = 231 (Assuming same contribution).

If I pay 1 Lakh additional towards principal in March then my tenure will be 210 months, means reduction of 21 months.

Please tell me this 21 months calculation.

Regards
Ranjan

Reply

246 Ashal Jauhari February 12, 2013 at 1:01 pm

Dear Ranjan, the 1L Rs. prepayment is the reason that your loan ‘ll be closed 21 months earlier. Actually due to this 1L Rs. prepayment, your EMI break up ‘ll change & a greater part ‘ll go towards principal & lesser part ‘ll go towards interest. That’s how your loan ‘ll be closed in 210 months from here onwards.

Sprite! Clear hai! :)

Thanks

Ashal

Reply

247 Manish Chauhan February 18, 2013 at 3:29 pm

Some prepayment calculators are attached at the end of the article, use them to see when the loan finishes and how many months are saved ?

Reply

248 Manish Chauhan February 11, 2013 at 8:03 pm

Close to 10-12 months will be reduced .

Reply

249 Ranjan February 19, 2013 at 2:39 pm

HI Manish,
Just would like to know how the calculation differs so much. As per Ashal it would reduce 21months but as per your calculation it would reduce only 10-12 months. Pls clarify how so much difference is there. I mean a difference of 9 months.

Thanks
Ranjan

Reply

250 Manish Chauhan February 21, 2013 at 9:54 am

Ranjan

19 months should be right then .. my answer was mostly a guess work based on numbers , better try those calculators which I mentioned and try them once.. unless you do it yourself, you should not believe me or ashal !

Reply

251 Ranjan May 14, 2013 at 1:47 pm

Dear Manish/Ashal,
I would like thank both of you for your time in replying to a lot of query which helps a lof of people around the world you cant imagine.

Wanted to share my experience in Home loan partpayment. Details:

LIC HFL
Loan amt: Rs 3244000/-
Interest rate : 10.7 fixed for 3 years
Loan term: 20 yrs
1st EMI : June 7th 2012
EMI amount( 32925/-)

I paid 1 lakh rupees as part prepayment in this May 2013. My tenure has been reduced exactly 20 months.

Your calculation is absolutely correct. Thanks a lot.

Regards
Ranjan

Reply

252 Manish Chauhan May 18, 2013 at 1:10 pm

Great :)

Reply

253 Ranjan May 21, 2013 at 1:19 pm

Hi Manish/Ashal,
If I continue to Pay 1 lakh rupees part payment every year, how long it will take to close the loan.

Is it better to pay more part payment in the initial year or should be ok if I continue to pay 1 lakh part payment every year.

Regards
Ranjan

Reply

254 Manish Chauhan May 25, 2013 at 5:56 pm

BEtter pay in intial year .. try out prepayment calculators we have given at the end of the article

255 Manish Chauhan February 23, 2012 at 3:14 pm

Ranjan

All the companies have their own terms and conditions . I dont recommend you rely on anyone else info on this , but go through their brochure your self . Also discuss it on forum : jagoinvestor.com/forum

Reply

256 Arpit February 22, 2012 at 8:42 pm

Hi Manish,

Your posts are really adding values. Thanks for that.

I would like to know, Can I take home loan from both bank and my parents for a single property? If yes what do I need to produce to my employer to avail tax exemptions for interest and principle paid for loan portion arranged from parents? Also, which method should be applied to distribute the principle and interest payment, if we agreed on X% of interest for showing during tax exemptions ?
Idea is to get maximum tax benefit, please suggest on choosing the tenures for both bank and parents loan. I am planning to arrange 40% from bank and 60% from parents for the total required loan amount.

- Arpit

Reply

257 Ashal Jauhari February 23, 2012 at 11:01 am

Dear Arpit, In all probability, your employer ‘ll not entertain the private loan part i.e.e loan taken from your parents but you may claim it while filing your ITR.

You shouyld prepare a loan agreement between your parents & you mentioning the details like term of loan, quantum of loan, ROI to be paid, terms of repayment i.e. EMI or lump sum……………

Please make the loan agreement on stamp paper.

Thanks

Ashal

Reply

258 Manish Chauhan February 23, 2012 at 2:41 pm

Arpit

How will taking a loan from two banks help ? Why do you want to do that ? Ultimately the total limit is 1 lac for 80C and 1.5 lacs for interest , it can be from 1 bank or 10 bank . that does not matter . I think it would be good idea to discuss this on our forum : http://www.jagoinvestor.com/forum

Reply

259 Manmohansinh February 23, 2012 at 2:56 pm

Hi,
I have taken home laon from HDFC in 2010.
Amt. 13,00,000/-
ROI -8.25 % upto 31-03-2012 & After That normal ROI that in market
Tenure–Original 20 Years ,Which i Reduce to 15 Years

Currently I am paying Rs.12,383/- as my EMI upto 31-03-2012. After that I came to know that my ROI will be 11.5% means 15,600/- as EMI after march 2012

Please tell me what is better option for me
(1) To reduce Tenure to 10 years
(2) To add the amt. in prnicipal (Partial paymet)

Reply

260 Manish Chauhan February 23, 2012 at 5:01 pm

Your question is not clear .. rephrase it !

Reply

261 Manmohansinh February 24, 2012 at 9:33 am

What is best option for 13 lakh home laon @ 15 years tenure. (ROI 11.5%)

Either pay more amount in principal or reduce tenure.?

Reply

262 Ashal Jauhari February 24, 2012 at 9:58 am

Dear Manmohansinh, any amount paid as prepayment apart from your regular EMI’ll be directed adjusted from your outstanding loan amount & it ‘ll ultimately lead to reduction of term of your loan automatically.

So, in my view, if you do have mly cash flow to handle extra EMI, increase your regular EMI & at the same time, prepay a part of your loan.

Thanks

Ashal

Reply

263 Ranjan February 24, 2012 at 11:19 am

Hi Ashal,
I need some more clarification on your reply.

“So, in my view, if you do have mly cash flow to handle extra EMI, increase your regular EMI & at the same time, prepay a part of your loan.”

In the above case I could think three option:
1. Should I keep the same EMI and rest of savings I can pay as part payment.
2. Should I increase the EMI and Dont do any Part payment.
3. Should I increase the EMI and do partpayment whatever possible from the saving

Please take a look at it and let me know your thought about it.

Regards
Ranjan

Reply

264 Manish Chauhan February 24, 2012 at 8:13 pm

Ranjan

I think prepaying the home loan each month with extra cash would be better !

Reply

265 Ranjan February 9, 2013 at 3:29 pm

Dear Manish,
Thanks a lot for a lot of information. I have a question here.

Consider I have taken a home loan for 15 years tenure and my EMI would be 40000/-. If I do this I will not be left with any additional money to pre-pay any amount towards principal and close it earlier. That means I will pay till 15 years.

Will it be better if I opt for 20/25 years instead of 15 year, so that my EMI amount will be less and I can save some money and pay towards principal once in a year or so, which will help me in closing the loan earlier than 15 years.

Regards
Ranjan

Reply

266 Ashal Jauhari February 24, 2012 at 11:58 pm

Dear Ranjan, what I mean – increase your EMI from current level to a higher one as per your cash flow position. At the same time, if you do have some money to prepay, use the same to bring down the loan liability immediately.

Thanks

Ashal

Reply

267 Ranjan February 24, 2012 at 11:14 am

Hi Manish,
I am planning to take a house(Apartment) loan of 30 Lakhs from LIC. Would you please suggest me to take 10.4% floating interest OR 10.7 % fixed for 3 years OR 11.15% fixed for 5 years. I am in confusion which option I should opt to get the benefit out of it. The above option LIC is having currently. IF you have some more suggestion its allways welcome. Next thing I would like to close this house loan as quick as possible may be within 5-6 years Maximum.

Regards
Ranjan

Reply

268 Manish Chauhan February 24, 2012 at 8:15 pm

Ranjan

This decision cant be taken by anyone else . There is always a risk in any decision , If you go with fixed option, the risk is that interest rates dont increase and your choice is a wasted one. The risk in taking floating one is that interest rate go wild , so what matters most to you , security of interst rates or freedom . Choose as per your decision !

Reply

269 Ashal Jauhari February 24, 2012 at 11:55 pm

Dear Ranjan, out of the 3 options you have with you, please opt for the one which is more likely scenario from here on wards for next 3-5 years. As rightly pointed out by dear Manish, only you can make a call for yourself, what’s important to you? If you anticipate that from current level, Interest rate may go down, opt 10.4% rate. If you think rate ‘ll remain as it is or may increase a bit opt 10.7%. If you think rate may increase in a big way from here, opt for 11.5%.

Thanks

Ashal

Reply

270 Rakesh Agarwal February 25, 2012 at 5:44 pm

Dear Sir,

I have a Housing Loan from Union Bank of India @8.5% Internet P.A. but the bank transfer the amount in Installments then plz tell me how i calculate the Internet & the Interest was calculating in Floating rates.

regards

Rakesh

Reply

271 Ashal Jauhari February 26, 2012 at 1:01 am

Dear Rakesh Agarwal, you need not to calculate any interest. Simply ask your branch to provide the loan statement & you ‘ll get the break up of interest & principal paid by you till date.

Thanks

Ashal

Reply

272 Manish Chauhan February 28, 2012 at 11:22 am

Rakesh

You dont need to do it yourself , ask your bank to give a statement for principle and interest .

Reply

273 Priyanka March 4, 2012 at 7:09 pm

Hi Manish,

i have taken home loan of 9 lakhs for 20 years in aug 2010 on floating interest.
i have done part payment of 5 lakhs so far and wanted to know that it was correct to select 20 years tenure if i am paying off my loan in 2 years time.

everytime i paid part payment, i had requested for tenure change…was that decison correct?
my bank allows me to pay 60% of the o/s in one financial year. so should i pay off the complete loan even if the bank charges me extra or should i continue to pay only 60% of the o/s every year?

Priyanka

Reply

274 Manish Chauhan March 5, 2012 at 3:32 pm

Priyanka

Ashal has replied you

Dear Priyanka, as you have already paid back more than 50% of your loan amount till date, there is no benefit for asking – opting 20Y of loan term was a right decision?

From your query, it seems you have both – lump sum surplus amount to pay back your home loan as well as mly cash flow to pay higher EMIs.
In my opinion, please pay 60% & at the same time increase your regular EMI from current level to a higher level as per your own cash flow position.
Thanks

Ashal

Reply

275 ASHAL JAUHARI March 4, 2012 at 11:38 pm

Dear Priyanka, as you have already paid back more than 50% of your loan amount till date, there is no benefit for asking – opting 20Y of loan term was a right decision?

From your query, it seems you have both – lump sum surplus amount to pay back your home loan as well as mly cash flow to pay higher EMIs.

In my opinion, please pay 60% & at the same time increase your regular EMI from current level to a higher level as per your own cash flow position.

Thanks

Ashal

Reply

276 Laksha March 5, 2012 at 1:06 pm

if have taken home loan of 9 lakhs for 20 years on floating interest.
i have plans of paying off my loan in 2 years time.
Should i go for higher tenure ie 20 years tenure or short tenure?

Reply

277 Manish Chauhan March 5, 2012 at 2:59 pm

Laksha

You can pay off the loan if you want, but there are benefits like tax deducations etc which you can take . Dont you want to take those ?

Reply

278 sneha March 6, 2012 at 2:15 pm

very nice article. it open my eyes …now i understand why bank agent insists for 20 yr tenure, they talk very clearway about ..you have to pay less EMI , Excellent Article.

Reply

279 Manish Chauhan March 6, 2012 at 5:57 pm

Good to know that Sneha that you are very much clear now ! . Take action now !

Reply

280 devender singh March 8, 2012 at 12:12 am

Hi Manish,

Suppose I take a loan of 1000000 at 10% for 10 years. Now my understanding is bank will calculate the interest for 10 years and add that to the principal amount and divide it by 120 months for the EMI. In this case the EMI should be 16,666 but through your calculator it is 13215 so obvisiouly I am wrong so kindly let me know how the EMI is calculated.

Another question is suppose I prepaid my loan after 5 years in that case my pending amount is 621971.83 as per the EMI calculator. But shouldn’t the amount be reduce by the extra interest I paid in the first 5 years. The interest I was paying for the first 5 years was on the assumption that I have kept the 1000000 for 10 years but actually I loaned that amount only for 5 years now.

Thanks,

Devneder Singh

Reply

281 Manish Chauhan March 9, 2012 at 3:05 pm

Devendra

NO , EMI formula is different , the way you are calculating is not how it works See this : http://www.jagoinvestor.com/2008/01/how-home-loan-emi-is-calculated.html

Also when you prepay the loan at that time there is a LOAN OUTSTANDING Amount and thats what you have to pay . Each time you pay the EMI , some part of it goes to main principle and your main loan gets deducted by that amount only

Reply

282 Mohan rao March 8, 2012 at 1:32 pm

Dear Manish
Very enlightening articles and discussions. I want one clarification. SBI is offering daily reducing balance . I understand that EMI remains the same, but interest portion gets reduced from the second month on the principal component repaid in the first month and so on in the subsequent months. On account of this the interest burden on a 5 year tenure loan of Rs.22 lakh @10.5% comes down by about Rs.1.34 lakh as compared the interest charged by ICICI for the same loan, roi and tenor. I had reduced the mothly principal portion and worked out the interest component which is less in cawe of SBI and constant in case of ICICI. pl enlighten all those loan seekers on this aspects. thanx

Reply

283 Manish Chauhan March 8, 2012 at 3:53 pm

Mohan

Your question is very unclear to me , Please repharse it in proper manner again . Also in daily reducing balance , the interest changes every day .

Reply

284 ASHAL JAUHARI March 8, 2012 at 8:26 pm

Dear Mohan Rao, in case of SBI, it ‘ll charge you the interest for the no. of days for each of the month say 28-29 for Feb, 30 for April, June…., 31 for Jan, Mar….

Where as ICICI, ‘ll charge interest on a fixed pattern of EMI to EMI date counting 1 month.

That’s where the difference occurs but I’m unable to understand that it ‘ll generate such a huge difference of 1.34L Rs. in 5Y term.

Please share your finding in detail if possible.

Thanks

Ashal

Reply

285 Mohan rao March 8, 2012 at 8:49 pm

Dear all
Thankx for quick response. I repeat what I have attempted. For a loan of Rs.22 lakh @ 10.5% roi with 5 year tenor with daily reducing balance on a monthly rests basis as I presume for SBI, i caliculated full interest for the first month and for second and subsequent months i reduced the principal component of the EMI (assumed EMI at Rs.50000) from the loan outstanding thus from very second month onwards the interest comes down because the principal outstanding is less by the amount of principal component in the previous month EMI. In case of ICICI, i reduced the principal repaid in the previous year on annual basis and arrived at the interest portion of the EMI each year. Thus i got a difference of about Rs.1.34 lakh between the monthly rests of SBI and annual rests of ICICI. Am i correct. pl enlighten. thanks

Reply

286 ASHAL JAUHARI March 8, 2012 at 9:00 pm

Dear Rmohan, now I can understand. You are using annual reduction for ICICI Bank loan. My dear friend, you are wrong, even ICICI bank also now a days use mly reducing for calculation of Interest & principal from EMI.

Thanks

Ashal

Reply

287 bhaskar March 14, 2012 at 12:48 pm

Hi Manish,

I have a home loan for 23.5 Lakh for 20yrs tenure from LIC, which started Jan’2012. The EMI is Rs.24,500/-.

1. I want to pre pay principal of 5Lakhs. And I want to buy a plot for 25Lakhs on loan. Is it better to prepay the principal or invest as a margin money to buy the plot. please advice.

2. Is it better to pay Rs.25,000/- more as prepayment of principal every month? or is better to reduce the tenure of the new plot loan? one more thing I may not get the 20Lakhs without large tenure. Please suggest.

Reply

288 Manish Chauhan March 14, 2012 at 1:04 pm

Bhaskar

1. Prepaying will mean that the tenure is reduced because in most cases EMI are not reduced, its the tenure . so the cash flow will remain same for several years.

2. Yes it would be good to prepay some amount each month .

Reply

289 stanley manuel March 25, 2012 at 5:58 am

Hey mohit this is stanley and i work in a BPO and i get paid 19k and i had purchased a flat in the year 2010 for 9 lacs i was 21 then,i took a loan of 750000 at the interest rate of 9.75% in a fluctuating basis and now as on 24th march 2012 the interest rate is 11.75% … i got my bank loan statement and i saw that my outstanding amount and it is 740847 as on 31st march 2012.. i want to finish up my loan as soon as possible.. coz i am the only one earning in my family so i have to look up for my savings also … i dont know anything abt these housing loan policies and stuffs so i keep looking for some articles like this … so please suggest me how to plan about to repay my loan .. plz do reply

Reply

290 Manish Chauhan March 28, 2012 at 4:58 pm

Stanley .. “How to pay” ? What exactly do you expect in this ? No magic can happen , keep paying and prepaying from time to time, unless you increase your EMI , you will end up paying till end, make sure you keep prepaying the extra amount whenever you keep getting the money from here and there !

Reply

291 Bipin March 30, 2012 at 2:49 pm

The above loan is repayable in Equated Monthly Installments (EMIs) comprising of principal and interest. The total
amount of EMIs payable from 01/04/2011 to 31/03/2012 is Rs. 203143. The breakup of this amount into principal and
interest is as follows :-

Principal Component Rs. 14032.00
Interest Component Rs. 189111.00

Balance Outstanding as on 27-DEC-11 : Rs. 1735459.00

As you are suggesting for part payment.How part payment of loan is good according to you?

Reply

292 ASHAL JAUHARI March 30, 2012 at 3:15 pm

Dear Bipin, the part prepayment made by you for the loan, ‘ll be adjusted directly to the outstanding loan amount & hence the loan amount ‘ll come down immediately. For example if you are making a part prepayment of 3L Rs., your outstanding loan amount ‘ll come down to 1435459. So from next months for the same EMI, your interest outgo ‘ll reduce & the principal component in your EMI ‘ll increase. This ‘ll again help to close the loan early & thus saving the interest paid on your home loan.

Thanks

Ashal

Reply

293 bipin April 8, 2012 at 11:02 am

thanks for your input, but there one more catch here… it is not adviced to reduce tenure but rather reduce the EMI. In that way to dont keep ur partpayment money ideal till the end of tenure

Reply

294 ASHAL JAUHARI April 9, 2012 at 1:10 am

Dear Bipin, I’m sorry but I could not understand your reply. Can you elaborate it?

Thanks

Ashal

Reply

295 haribhaskar April 1, 2012 at 9:07 pm

Dear Manish, Appreciate your help and the service you do. Your article, response and the tools provided to calculate are very professional and very useful. Continue this service to us.

Reply

296 Manish Chauhan April 2, 2012 at 5:20 pm

Good to hear it was of help Haribhaskar !

Reply

297 lovely jhon April 6, 2012 at 9:43 am

Pls see the calculation of sbi on the rate 8.5%, my question is why the interest amount is increasing and decreasing though the rate of interest is fixed for the period
debit credit
.31-Mar-2012 (31-Mar-2012) 9,908.00
29-Mar-2012 (29-Mar-2012) 12,490.00
29-Feb-2012 (29-Feb-2012) 9,295.00
29-Feb-2012 (29-Feb-2012) 12,490.00
31-Jan-2012 (31-Jan-2012) 9,949.00
29-Jan-2012 (29-Jan-2012) 12,490.00
31-Dec-2011 (31-Dec-2011) 9,967.00
29-Dec-2011 (29-Dec-2011) 12,490.00
30-Nov-2011 (30-Nov-2011) 9,668.00
29-Nov-2011 (29-Nov-2011) 12,490.00

Reply

298 Manish Chauhan April 6, 2012 at 9:53 am

Lovely

Interest amount will obviously be increasing/decreasing because its calculated on monthly reducing balance . as you pay the EMI each month , the interest part changes

Reply

299 lovely jhon April 6, 2012 at 11:01 am

but as principal amount is decreasing and rate of interest is same so it should decrease only

Reply

300 Manish Chauhan April 6, 2012 at 11:05 am

that must be because of the floating interest rates which increased !

Reply

301 ASHAL JAUHARI April 6, 2012 at 10:28 am

Dear Lovely John, The difference is due to the no. of days in the each month. Nov. was 30 days, Dec, 31…. Feb 29……

Also after each month as principal amount is being repaid a bit, your next month’s interest ‘ll come down a bit also.

Thanks

Ashal

Reply

302 ASHAL JAUHARI April 7, 2012 at 12:05 am

Dear Lovely John, please look in to your DATA again, Dec, Jan, & March 3 months are of 31 days & from your own data, the interest charged for you was 9967, 9949, 9908 Rs. in that order, is it not decreasing with every month?

Thanks

Ashal

Reply

303 sachin April 16, 2012 at 10:06 pm

hi manish
very nice article
my question is
i have purchased a under construction property the contractor is asking for the documents for loan case & the EMI will be started after 12months i.e. after i get the possession of the house.
1. is it good option to start paying EMI from the start of loan disbursing to the contractor.
2.if i want to pay some amount which i have in savings to the contractor & reduce my loan amount is it good option

Reply

304 Manish Chauhan April 17, 2012 at 12:05 pm

Sachin

Its always better to pre-pay the loan incase you have some money in your side ..

Reply

305 sachin April 18, 2012 at 7:26 pm

Thanx for your reply
but can i start EMI imidiately after disbursing the money to the contractor.
& also paying money directly to the contractor will creat any problem in future.

Reply

306 Manish Chauhan April 19, 2012 at 7:53 am

Sachin

If loan is given by bank , then pay the EMI to bank only directly, why to builder ? And when does EMI start will be mentioned in your loan agreement , read it

Reply

307 Mohan April 30, 2012 at 2:08 pm

Hi Manish,
I have read in today ‘s TOI that you can get the rebate on purchase of your second house for Interest amount(not on principle amount).Please clarify this in details.
Will this me to reduce the burden on my Income tax & also have investment as an asset

Reply

308 Manish Chauhan April 30, 2012 at 2:25 pm

Yes , thats true .. you can claim the full interest paid on your second home loan , without any limit

Reply

309 Vivek Kumar May 28, 2012 at 1:17 am

Hi Manish,
Is there any concept of variable EMI?
Suppose my EMI for some loan is 20k, so can I pay 30k for any particular month?
If not, can we decrease the duration for loan repayment, i.e. increasing EMI thereafter??

Thanks in advance!!!
-Vivek Kumar

Reply

310 Manish Chauhan May 29, 2012 at 11:01 am

Vivek

I know dont if there is anything like this , but you can also prepay a loan to certain extent each month, so you can make 10k additional payment for your loan each month when you have the money

Reply

311 Vivek Kumar May 29, 2012 at 11:12 am

Thanks for reply!!!
So, this means that EMI is the minimum amt. to be paid each month.
We can pay any extra amt. over EMI, if i hav money, to reduce the loan duration as well as interest.
Am i right??

-Vivek

Reply

312 Manish Chauhan May 29, 2012 at 9:35 pm

Yes , thats correct

Reply

313 Ankur June 4, 2012 at 8:08 pm

Hi Manish,

I have taken a home loan of 20 lacs for 15 years @10.5% from HDFC. EMI is deducted from my acc on 4th of every month. I would like to make a prepayment of around 5 lacs this month. My question is: would it make any difference if I prepay on 5th or 25th of this month?

Thanks
Ankur

Reply

314 Manish Chauhan June 4, 2012 at 11:20 pm

I think once you make the payment on 25th , your outstanding will do down and the new balance will be considered for EMI interest calcualtion , but if you do it on 5th , it depends which one is considered first , EMI payment or Prepayment .

I suggest you clarify it on our forum : http://www.jagoinvestor.com/forum

Reply

315 Ashok June 7, 2012 at 5:59 pm

We taken loan 300000/- in 2004 -05 & EMI started with Rs. 3640/- from ICICI Home Loan. Now they r charging interest @15.75%pa which was earlier at the time of sanction of loan was floating rate 7.5%pa . Now we come to know that it is not as per RBI norms. What action we should take? If there is no remedy then suggest another option to re-loan.

Reply

316 Manish Chauhan June 7, 2012 at 10:12 pm

Ashok

as for the explaination from ICICI BANK , get it in written and still if you feel its not as per rule , file a case and complaint with RBI and banking ombudsman

Reply

317 Sudeep Jain June 11, 2012 at 10:26 pm

Hi,

I keep repaying for my home loan of 20 yrs. My target is to close the home loan in next 5 years. Usually I keep lowering my EMI amount whenever I repay or there is a reduction in the interest. In your opinion what could be better option – reduction in EMI or reduction in tenure, If I want to pay less total interest in the span of 5 years (I am damn sure that I would close my home loan in 5 years :)).
Or does it matter reduction in EMI or Tenure in terms of total interest paid in 5 years.

- Sudeep jain

Reply

318 Manish Chauhan June 12, 2012 at 6:39 am

Better reduce your tenure .. that is much better from total interest payment point of view .

Reply

319 Nitin Bansal June 13, 2012 at 11:50 am

Hi Manish,

I have one question. My home loan has just started. Please find details below:

Loan Amount: 2500000
Loan Interest: 10.5%
EMI : 27635

I am going onsite soon and I might have extra money to pay my home loan. I am planning that I will pay Rs50000 every month extra. What do you suggest. Should I pay 3L to 4L every 4-5 months or should I pay every month.

Is there any calculator which can tell what part payment will be better.

regards,
Nitin Bansal

Reply

320 Manish Chauhan June 14, 2012 at 3:48 pm

You should prepay each month .. That will bring down your tenure like anything

Reply

321 PrasadNVR June 17, 2012 at 8:21 am

Hi,

I have gone through this website and there is so much useful information that people should know before going for housing loan. I will have a doubt on my housing loan. please clarify.

I have applied for a housing loan of 18000 for the tenture of 20 yrs, from SBI. As per some scheme first year interest is 8% and 2nd nd 3rd years is 9%. The bank calculated the EMI as 16520 and my EMI has started on Jan 2011. The thing here is even though I have applied for 18L, I have taken only 15L ( 14,93,750/- exactly) from the bank, but the bank is deducting the EMI(16520), which is calculated on 18L.

As of now I have paid 17 EMI ( 280840) and my outstanding amount has come down to 13,67,333. To my knowledge without my knowledge I am paying some extra principal amount every month. Now If I wanted to prepay 3L to the bank, which would be better in the following options.

1. Keeping the same EMI, making tenture less
2. Less EMI for the tenture of 20 years.

When I asked people, I was told that OPTION 1 is always bettter. But I go with 2nd option, what will be the difference of amount, I wuld by paying to the bank?
Please let me know how to calculate this?

Reply

322 Manish Chauhan June 19, 2012 at 10:28 am

Prasad

You should go with option 1 and as your bank is SBI , i would suggest using RTI for this questions .. you will get proper results .

Reply

323 Gopi Krishna Settur October 8, 2012 at 10:39 am

Hi Prasad,

Always 1 option is the best.i explain taking my own example.

Iam paying 30220 INR to IDBI as my home loan repayment EMI
for an year iam paying 30220 x 12 = 3,62,640 INR (principal + Interest)
I recenty prepaid 2 Lakhs and the bank reduced 3 years in my term hence i saved 3,62,640 X 3 = 10,87,920 INR.

If i had consided the option 2 i would had reduced a mere 1000 per EMI of 30220.

option 1 in other words means you are prepaying the principal amount and that will reduce the interest component in the EMI hence you save..

Reply

324 Deepak choudhary June 19, 2012 at 6:27 pm

Hi manish,
I like your post on home loan very much. Thanks for your effort.
Recently I have applied for home loan from Idbi for Rs 2220000. My loan reimbursement will continue for one year and only after that my emi will start till then I will have to pay interest on the part of the loan disbursed. My question is- is it possible to start emi early i.e. as soon as bank starts disbursing loan so that I could reduce principal by some extent.
Also I am planning to prepay Rs 10000 every quarter to reduce my principal. So should I increase my emi every year or prepay as mentioned above, which will be more beneficial?

Please reply.

Deepak Choudhary

Reply

325 Manish Chauhan June 19, 2012 at 6:33 pm

Deepak

I dont think you can start the EMI earliar , Should you prepay each month to clear off the loan at earliest !

Reply

326 Sushant July 22, 2012 at 10:53 pm

Hi Deepak, Manish,

You can start paying your Full EMI from the month first disbursement is done. I am doing it with HDFC. The advantage is huge, as interest is calculated only on the amount disbursed till date and rest of the amount out of EMI goes towards the principal repayment.

Essentially, it reduces your principal amount drastically by the time construction is complete and full amount is disbursed. Say, if total duration of loan was 10 years, paying the full amount from beginning will close the loan in total 9 years (1 year before construction + 8 years afterwards). More is the construction time, more benefit you get, as more of the money would have been paid towards the principal.

Reply

327 Manish Chauhan July 25, 2012 at 6:57 am

Sushant

May be you want to explain us this concept , I am still not clear, can you start with a proper example and explaination with comparision

Reply

328 Sushant July 26, 2012 at 10:38 pm

Manish,

Below link has the explanation of the concept behind it and comparison with regular Pre-EMI option -
http://capitalmind.in/2011/05/pay-pre-emi-or-full-emi-the-facts-revealed/

However it does not provide the full detail of calculation. If you wish to have the exact details of calculations, I would be more than happy to prepare an excel sheet and send you over the weekend. This text box does not have provision for image or spreadsheet posting. You can post the sheet’s information in your way(image/graph) over the forum once we are in the same plane of understanding over the topic.

I have learnt a lot from this forum and it’s time I can help others .

Reply

329 Manish Chauhan July 27, 2012 at 8:06 am

Yes , why dont you send a excel sheet which explains the concept !

Reply

330 Sushant July 29, 2012 at 7:37 pm

Hi Manish,

Could you send me your email-id please. I am done with the sheet and can send you.

Regards,
Sushant

Reply

331 Deepak choudhary June 19, 2012 at 7:19 pm

Hi manish,
I like your post on home loan very much. Thanks for your effort.
Recently I have applied for home loan from Idbi for Rs 2220000. My loan reimbursement will continue for one year and only after that my emi will start till then I will have to pay interest on the part of the loan disbursed. My question is- is it possible to start emi early i.e. as soon as bank starts disbursing loan so that I could reduce principal by some extent.
Also I am planning to prepay Rs 10000 every quarter to reduce my principal. So should I increase my emi every year or prepay as mentioned above, which will be more beneficial?

Please advice.

Deepak Choudhary

Reply

332 Manish Chauhan June 21, 2012 at 3:39 pm

No Deepak

What you have is called as Pre-EMI loan .

Reply

333 navneet singh July 12, 2012 at 1:29 am

Hi Maneesh,

I read your article & I feel cery blessed to have such positive discussion on net.I am 0 on calculating emi but from your discussions I am able to manage some of my financial calculations.

Navneet Singh

Reply

334 Manish Chauhan July 12, 2012 at 7:17 am

Good to hear that :)

Reply

335 Balu August 3, 2012 at 7:13 pm

Sir,

i want ask you, if i start construction with my own money around 20 lcs there will be any tax pay or if i take loan from bank is there any benefit

Regards

Balu

Reply

336 Manish Chauhan August 4, 2012 at 12:18 pm

You get benefit only if you take a loan , else not

Reply

337 Kumar August 8, 2012 at 9:51 pm

Thanks Manish

Reply

338 Vidydhar Sharma August 29, 2012 at 9:14 am

Hello Manish,

I have been through all the posts and these are amazing. I am not expert in this area and take extra time to understand things. I have couple of questions but let me explain my condition first.

Last month only I availed a home loan (to construct) for 10 lacs for 10 yrs @ 10.50% interest rate. I got my first installment of 2 and half lacs and will be getting same installment after some period lets say 6 months (fixed tenure). Now questions are :

1. How bank will calculate the interest? (I mean for 10 lacs or for 2 and half lacs for first six months and then)
2. If I am going to pay 30k every month how soon i can close tht loan.
3. for tax benefits I got to know that i can claim after comletion of my construction only. Is it true?

I am just starting this process so your suggestion will be really great full. Do let me know if you need additional information.

Thanks
Vidya

Reply

339 Manish Chauhan August 29, 2012 at 9:49 am

Vidya

Yes you will be able to claim the tax exemptions , only once you get the possession of house. Read this for more on this – http://www.jagoinvestor.com/2011/02/4-home-loan-facts.html

Coming to your questions . All your queries will be automatically answered if you go through these

http://www.jagoinvestor.com/2011/04/loan-amortization-emi.html , look at the amortization table given at the end

Manish

Reply

340 Dwarakanath October 22, 2012 at 3:22 pm

Hi Manish,

Its very nice article. I also have same problem. I hv a home loan in IDBI….30L for 20 yrs and 11.25% interest. From past one month just 30000 principal has been paid and around 3,50,000 interest.

The problem is I cannot pre pay some bulk amount every year. How to reduce this interest amount. Every month its going to the interest itself.

Please help.

Regards,
Dwaraka

Reply

341 Manish Chauhan October 22, 2012 at 3:29 pm

Dwarka

It works like this only . One thing you can do is that reduce your tenure by 5 yrs , your EMI will increase but a very little amount which I am sure you can afford.

Reply

342 kiran October 27, 2012 at 4:02 pm

Hi Manish
Thanks for sharing such useful information here.
Can you suggest me the better prepayment option for an outstanding loan of Rs.15 lakh as on date for 15 years. Is it better to prepay 1 lakh right now or increase my EMI by Rs.1000 p.m.?

Reply

343 Manish Chauhan October 30, 2012 at 11:48 am

Do the maximum , Prepay 100000 and aslo prepay EMI by 1k more each month is possible .

Reply

344 Pavan October 28, 2012 at 3:15 pm

Hi Manish,
Thanks for the loan amortization calculator. it has helped to plan out priorities given that kids are coming to pre-university shortly.

regards, Pavan

Reply

345 Manish Chauhan October 30, 2012 at 10:56 am

good to hear that Pavan

Reply

346 kartik November 12, 2012 at 2:00 pm

Hi Manish,
we had taken housing loan in year 2005 june for 7400000 from hsbc bank and the rate of intrest was 7 % when we took loan and we have paid still now 7850000 and the principal outsatding is 6800000 and rate intrest now is 14 % dont know what to do . if we want to close the loan they are charging 2%

Reply

347 Manish Chauhan November 15, 2012 at 7:53 pm

You are stating facts , What exactly is the question !

Reply

348 Chandan November 15, 2012 at 5:31 pm

Dear Manish,

Nice blog. I regularly visit your blog and brush up my knowledge on different aspects of investing.

I have one doubt, hope you can point out the solution.

I have taken a loan of 21L from Axis Bank and as i understand from the Excel sheet if i do the repayment then Principle will be reduced and hence lesser will be the interest which i will pay. I just want to know is there any limit on Prepayment which i can do with respect to time? Or we have to pay some charges also if we do bulk prepayment to reduce the EMI load?

Also, if i want to reduce the tenure of my loan (and increase EMI) is it possible by requesting bank? Is there any charges involved?

Guess i’m able to explain my query correctly.

Thanks,
Chandan.

Reply

349 Manish Chauhan November 15, 2012 at 6:52 pm

How much you can prepay is defined in your agreement with bank . At times banks put a minimum and maximum limit, like minimum 3 months of EMI , not less than that … just an example .

Yes, you can talk to bank on reducing the tenure , but when you make prepayment, anywyas your tenure will come down !

Reply

350 Chandan November 16, 2012 at 11:19 am

Ok,

Thanks for you reply. BTW, Is this max. and min. vary from loan to loan or bank to bank. Any insight would be really helpful.

Thanks,
Chandan.

Reply

351 Manish Chauhan November 20, 2012 at 4:47 pm

That was just an example. look into your agreement !

Reply

352 Elbis January 16, 2013 at 11:58 am

Chandan,

I also have a home loan with axis. There are no prepayment/foreclosure charges now (as per rbi’s mandate). I would suggest you to just try repaying as much as you want. I don’t think they will reject your repayment (they have a loan pool account to which you can transfer your repayment amount).

HTH.

Reply

353 Anu November 27, 2012 at 9:32 am

Hi Manish,
I have a doubt about assignment deal for purchasing a ready-to-occupy home. An investor bought this property and is now willing to sell it but he has not done registration of his property and has also availed a loan on this property from Corporation bank. And the builder is the main party in this deal when we register the property in our name and investor ( flat owner ) will merely be a consenting witness. But the problem is that SBI doesnt give loan on 2nd agreement ( between us and builder ), instead gives 80% loan on 1st agreement ( which is between current flat owner and builder ). So we are planning to go for loan from HDFC but we are not sure if everything will be clean or not if we do so or will we be forced to take loan from Corporation bank only despite higher interest rate. Because usually the bank will disburse loan on the registration day so we dont know how the 1st buyer got his loan without registering the property. Any help/advice will be really appreciated. Thanks..

Reply

354 Manish Chauhan November 30, 2012 at 1:38 pm

Anu

This needs more people to comment who really have seen this – ask it on our forum please – http://www.jagoinvestor.com/forum/

Reply

355 Maren J January 10, 2013 at 8:40 pm

Hi,

Please help me , I have taken loan 38,00,000 lakh from LICHFL for 10 years in April-2011 and interest is fixed for 5 years 10.15 % . I have paid Pre-EMI for 1 year 2011-2012 and from Augest 2012 I started paying EMI 54,910k per month. Now when I took Report from LIC it gave me certificate for 01/04/2012 to 30/3/2013 that
Total Principle : 2,19,576 Total Interest : 2,65,269

I started paying actual EMI from Aug-2012 per month 54,910 and when i am trying to calculate Principle and Interest part then EMI i am paying in Aug-2012 to Mar-2013 is not matching with the toatat amount paid.

Please tell me how i should calculate what is happening here i am not able to understand. when i am paying 54,910 for 8 months and as per statement my Principle is deducted 41101.30 and interest 13808 rs in Aug-2012 when actual EMI started , i am not at all able to figure out calculation. please help

Reply

356 Sudeep Ghosh January 23, 2013 at 8:47 pm

This was an excellent place to get very valuable information. Thanks to all of you. I am starting my home loan shortly and this helped a lot. @Manish you loan amortization calculator has actually given me a clear view on how I can close my loan within 15 years rather than 20 years. I ll try to reduce it further by 2-3 years through prepayment as and when possible. Appreciate everyones contribution on this page.

Reply

357 Manish Chauhan January 24, 2013 at 2:03 pm

Yes .. glad to know that you got some value out of it .. We have much more at our wealth club incase you want to become a member – jiwealthclub.com

Reply

358 Kalyani January 30, 2013 at 10:11 am

hi Manish:
Thanks for this one : I am specifically looking at one in which say I increase the emi from x to x + 10k, or made some prepayments during the tenure, how would my tenure vary ? Do you have any excel for that ?? Please let me know
thanks
Kalyani

Reply

359 Manish Chauhan January 30, 2013 at 1:00 pm

There are some of the calculators given at the end of this article, just take of them which gives you the full schedule of the EMI for each month .. Then for the month from where you want to prepay the amount , just decrease the OUTSTANDING AMOUNT by that much, and you will see that the outstanding amount will go ZERO at some point , see how much is it reduced .

Manish

Reply

360 SRILAKSHMI March 16, 2013 at 12:14 am

Manish, I usually do not leave any comments on net. But after reading this article, I really felt to thank you. Article is excellent and is beneficial to many investors. It saves many peoples money who does not know about how the loan magic ( simple maths ofcourse :) )works. I have made my plans on how to re-pay the principle amount after reading this article. God bless you.
Srilakshmi

Reply

361 Manish Chauhan March 19, 2013 at 11:34 am

Good to hear that Srilakshmi

Keep commenting once in a while and ask your doubts and leave your opinion , the blog is yours , not mine :)

Reply

362 Ranjan Nayak March 27, 2013 at 10:08 pm

Hello Manish Chauhan,
You wrote a great article.
I have one question, recently I took a loan of 27 Lacs for 20 years.
My
Month EMI Interest Principal
1. Rs. 26055 Rs. 22500 Rs. 3555.59
2. Rs. 26055 Rs. 22470 Rs. 3585.22


12 Rs. 26055 Rs.22160 Rs. 3895.44

If suppose every month, I am paying Rs. 20,000 (20k) then in one year I will pay 20, 000*12 = Rs. 2, 40,000. Here, the question is after paying Rs 20k per month my usual principal amount will deducted as per it is decided (with respect to 27 Lacs) or the new principal amount will get deducted,
Let say,
My Loan amount is 27 Lacs
1st month EMI = 26000 (principal = Rs. 3555)
And I am paying Rs. 20k more to my loan account.
So, the 2nd month EMI will be on 27Lacs – 3555 – 20,000 = Rs. 2676445.
So, the 2nd month EMI will be Rs.26000 or Rs.25862. So, the principal amount deduction will be Rs. 3585/- or Rs. 3555/-(New amount based on RS. 2676445)?

Please reply.

Reply

363 Manish Chauhan April 3, 2013 at 1:29 pm

Yes , the next month outstanding amount will reduce by 20,000 more , so it will be 2676445. , but the EMI will be same , but your tenure will come down .. note that EMI’s are constant , only tenure keeps up and down

Reply

364 Raju April 1, 2013 at 12:55 pm

Dear Manish,
I have taken an home loan of Rs.13.28 lakhs from SBI in year 2013.
for 10 year period.
I had planned to repay loan in 24 month period duration.

Is it advisable to do so. if not what should be the ideal duration for repayment if extra amount is available.
I have already paid extra amount more than the EMI amount for first two months.

Pl advice

Thanks

Reply

365 Manish Chauhan April 3, 2013 at 9:29 am

Yes you can do that .. just see if you want to let go the home loan tax deductions !

Reply

366 amol April 21, 2013 at 9:45 am

Hi manish ,

I am planning to take 45Lkh loan from HDFC
I am planing to take 30 lakh as floating (10.15 for 20 years) and 15lakh ( 20 years ) which is fixed for 10 years at 11%. as I wanted to to mitigate risk on floating portion of it and also I plan to repay some part with EMI chunks. What do u suggest.
Amol

Reply

367 Manish Chauhan April 26, 2013 at 2:09 pm

Amol

Kindly open a thread to discuss it here – http://www.jagoinvestor.com/forum/

Reply

368 Rakesh Joshi July 4, 2013 at 2:37 pm

Hi Manish,
I have a housing loan account with SBI for 27 lakhs floating. Rate of interest currently is 10.2% and tenure is 25 years. I am also using the maxgain account. I wanted to know how is the interest calculated. Is it calculated on a monthly basis or is it calculated on daily balances like a credit card? If interest is to be deducted on the last day of the month, is it enough to have money transferred to maxgain account only on the day of the calculation or is it better to keep all my salary there for the whole month to increase the principal deduction?

Reply

369 Manish Chauhan July 5, 2013 at 9:46 am
370 Rakesh Joshi July 5, 2013 at 10:59 am

Thanks Manish for your reply. What I understand is that it is better to have the balance throughout the month in my OD account instead of one day.

Reply

371 Manish Chauhan July 5, 2013 at 11:03 am

Yes. if its possible for you

Reply

372 Someshwar Upare August 8, 2013 at 11:26 am

I have taken the loan in 21-09-2012 from DHFL of worth Rs. 2280212 with the interest is 11.5% for tenture 20 Years. DHFL had paid the 1530212 to builder and took the PEMI (interest only) of worth Rs.14665 up to Mar-2013. In Mar – 2013 another disbursement has been happened of Rs 500000 and Now combined amount for builder to paid is Rs. 2030212 and they have taken Rs. 19456 of PEMI interest up to May 2013. In June 2013 they have been started the EMI Rs.24330 on actual Loan amount i.e. 2280212 and given the Principle for extra amount I paid i.e. 4874. I am not getting Possession till now and Loan balance still remain for Rs. 250000 from DHFL, but EMI is started from June 2013. Could You please tell me that How principle will be adjusted if full payment is done from DHFL to builder after getting possession.

Reply

373 Manish Chauhan August 9, 2013 at 9:36 am

Please raise this in our forum as its needs extensive discussion – http://www.jagoinvestor.com/forum/

Reply

374 Archana August 12, 2013 at 4:15 pm

Hi,
We are planning to buy an appartment costing around 60L (incl reg+taxes). About 25L would be funded from my famaily and relatives and rest i.e. 35L will be loan from LIC at 10.25% RIO. However we have loan eligibility of 40L, should I go for max bank loan and save the family fund or utilise the family fund and lesser bank loan? Please suggest me on the same and appreciate any other suggestions on this regard. thanks

Reply

375 Manish Chauhan August 21, 2013 at 3:18 pm

If you have the capability to repay the loan faster, then I would suggest for higher loan , the money you have can either be kept as reserve for 1 yr of expenses !

Reply

376 kckarukachal September 2, 2013 at 5:57 pm

I want to know that suppose if I have a loan of Rs 10 lacs with an emi of 20,000 and If I make a part payment of Rs 1.00 lac out of the EMI what would be the better option should I go for increase in EMI or decrease the tenure of loan. Please clarify.

Reply

377 Manish Chauhan September 3, 2013 at 12:28 pm

Better decrease the tenure !

Reply

378 Tushar September 5, 2013 at 12:19 pm

Hi Manish,
Thanks a lot for this excellent resource you have created for the benefit of all. I am going to be home loan shopping very soon and was trying to understand this business. This website and all the collection of resources you have here have helped me a lot in my understanding of how home loans work and how the banks are going about this business. Keep up the good work. You are really creating an awakening among people!

Reply

379 Manish Chauhan September 7, 2013 at 5:03 pm

Thanks Tushar

Two more resources I can recommened are my 2nd book – bit.ly/Financial-planner-book (there is a chapter on debt repayment)

And also indianrealestateforum.com . Its the powerhouse of articles and ideas on real estate !

Reply

380 Mohan October 13, 2013 at 5:03 pm

Hello Manish Sir!
Hhve home loan Rs 27,51,000 @11% wef 10 Jan 2008. Did prepayment thrice. Currently, Loan balance is @9,30,000@11.90%, EMI 20000,
(principle -1,05,719 interest Rs. 1,27,741) X 64 months. Whats the best option for me, in case wants to have the max benefit of interest component of loan. To reduce tenure or to increase EMI. Planning for 1 lakh prepayment. Thanks n Regards…

Reply

381 Manish Chauhan October 18, 2013 at 9:54 pm

BEtter Reduce the Tenure , NOT EMI

Reply

382 Mohan October 19, 2013 at 11:41 am

Thank you.
I hope it fulfills my desire of having the maximum rebate on the interest component of home loan, apart from reducing the burden.
Regards.

Reply

383 Karthik November 4, 2013 at 10:27 am

Hi Manish/Ashal,
I have a query – on what balance is the monthly interest computed?
For eg: if, on the 1st of the month, total outstanding = 8,50,000/- and my EMI (say 25,000) is paid on 10th of the month, the interest debited on the 31st of the month – will it be calculated -
> on the balance at the beginning of the month (i.e. 8,50,000) or
> on the balance at the end of the month (i.e. 8,50,000 – 25,000 = 8,25,000) or
> on day-wise balance, i.e. 8,50,000 for the 1st 10 days and 8,25,000 for the remaining 20 days?

Could you let me know?

Reply

384 Manish Chauhan November 4, 2013 at 10:43 am

It will be last outstanding balance. A outstanding balance will be changed the moment you pay your EMI . Out of your EMI , the principle part will be deducted from last outstanding balance, and then it would become the new outstanding balance .. think of it as variables used in programming and you will understand what I am saying !

Reply

385 Karthik November 4, 2013 at 10:57 am

Thanks for the prompt reply, Manish. So that in effect means the 2nd option. Also, do you think it would be beneficial to pay the EMI towards the end of the month – say 25-27th of the month? That way, I’d earn interest from SB for the amount, at the same time, the reduction in outstanding balance for the loan wouldn’t be altered. Is that right?

Reply

386 Manish Chauhan November 4, 2013 at 11:34 am

Correct ! . it would be good option !

Reply

387 Karthik November 4, 2013 at 11:37 am

Thanks a ton Manish.

Reply

388 Shunmuga November 12, 2013 at 3:04 pm

Hi,
I have taken a loan of 20Lakhs for 20 years tenure(@10.95% fixed rate for 10 years) . As suggested by you i made a recurring deposit and made a prepayment of 2.5lakhs at 7 th month. I pay around 20K EMI. Imagine if i reduce my EMI by 5000(Possible in LIC) and pay them at the end of every year as Pre payment will that be fruitful. Also i am not able to find a EMI calculator which will show the impact if i reduce my EMI. Please help.

Reply

389 Manish Chauhan November 12, 2013 at 5:25 pm

the more you prepay, the better it is for sure ! .. So keep prepaying wherever possible , look at this calculator which you asked for – http://www.jagoinvestor.com/2011/04/loan-amortization-emi.html#.UoIWxPmqkxE

Reply

390 geeta December 21, 2013 at 1:31 pm

I have taken loan for Rs 94 Lacs * 12% interest for 20 yrs. EMI is 103503, which i got by calculation but i want to know on what basis they decide the principal amount (9502) and interest amount (94000)??? I want to know the calculation of Principal amount…who and on what basis it is calculated?

Reply

391 geeta December 21, 2013 at 4:08 pm

Anybody pls dont waste your precious time….
I got the formulla…..
=IF(E50,E7*(E6/12)*((1+(E6/12))^E5)/((1+(E6/12))^E5 -1),””)

where E5- tenure (12*20 yrs = 240)
E6 – Rate of Int – 12%
E7 – Loan Amt – 94 Lacs

Reply

392 Manish Chauhan December 25, 2013 at 10:16 am

Its like this, First you calculate EMI using the formula, then that is fixed for whole tenure. NOw each month you calculate the interest by Interest rate * Loan outstanding for the month. then whatever remains if the principle amount

Reply

393 ravi January 6, 2014 at 5:36 pm

Mr. Manish,
I have got the home loan from SBI for the period of 20 years and my EMI is 24,400.
My loan got sanctioned under the scheme of first 3 years at fixed rate of interest and after three years it is at floating rate @ 2.75% less than BPLR.I just want to know, as my EMI is fixed, how this changes in Base rate will have an impact on my repayment schedule. Also can it be possible for getting transferred my loan into floating rate based on base rate rather than on BPLR based?. Kindly suggest me the solution.
Thanks,
K.Ravi

Reply

394 Manish Chauhan January 9, 2014 at 12:40 pm

If its on FIXED rate , then it means that base rate has no relation to you in first 3 yrs, its FIXED.

Reply

395 om January 19, 2014 at 9:34 am

Hi, Manish ji
your article gave a very good insight of EMI.
i am an auditor working in coop dept, we rarely have EMI method in our coop society. Recently i was allotted a society which is using EMI method. I want to know how to treat the EMI Balances in P&L a/c and Balance sheet. How the interest receivable account as at the end of the financial year can be calculated to carry it in p&L and Balance Sheet. Do we have to calculate the interest part for each loan separately.

Reply

396 Manish Chauhan January 20, 2014 at 6:46 pm

Hi OM

I believe your question is very different from Home loan EMI ! .

Reply

397 om January 28, 2014 at 11:20 pm

hi manish ji,
my question is not as a Loan Applicant,
my question is as an auditor of a society which issues EMI Loans for consumer durables & home loans.
my problem is i am unable to workout the actual asset under Loans & advances
and the interest accrued on the Loans
please explain as to how to represent the Loan & Interest Due from the loanes in the balance sheet of the society

Reply

398 Manish Chauhan January 30, 2014 at 5:15 pm

Hi Om

That query of yours is a little advanced one it seems. I suggest a good CA will be able to handle it.

Reply

399 PANDIAN February 15, 2014 at 8:23 pm

GOOD SERVICE SIR, THANK YOU

Reply

400 Rahul April 27, 2014 at 5:28 am

Hi Manish ,
This one is really a good. I was looking for something which let me know how intrest-principal get distributed.
In my case , i have loan of LIC 22Lac @9.5% fixed ROI for 5 years and EMI is 20504.
NOw my first EMI is May 2011 but got possestion in July 1012, with first EMI i started full EMI ,due to which till the time my actual EMI start (Intrest-principal) , i have paid around 1.08 Lac towards principal from my EMI. Now my current outstanding is 196500 after paying 36 installment (36*20504), NOw i want to make part payment of around 2Lac. How can i calculate Intrest-Principal ratio aftre paying 2LAC as part payment, (my EMI and rate of intrest will remain same ).
Your sheet only help us to calculate right from First EMI but how can i come to know how much amount will go to Intrest and what would be toward principal if i made part payment.

Thanks in Advance.

Reply

401 Manish Chauhan April 29, 2014 at 9:17 pm

But with the sheet you can see how it works, when you make the prepayment, that 2 lac will get deducted from the loan outstanding amount , then whatever remains is your loan outstanding, then you calculate the next month INTEREST on that amount, and deduct it from EMI amount, what you get is your priciple payment for next month . I hope you got it ?

Also you can ask your lender to provide you the provisional sheet for interest and priciple !

Reply

402 Rahul June 25, 2014 at 5:06 pm

Hi
I took LICHFL of 22Lac @9.5% fixed INT for 5 years. Its beeing 3 year and 2 more years left for Fixed Rate.
I am thinking of switching it to SBI maxgain. but is it a good idea to switch to SBI maxgain now or shall i wait 2 more year to complete fixed rate and once floating start then switch it.

Regards
Rahul

Reply

403 Manish Chauhan July 3, 2014 at 11:03 pm

You will have to do comparison of both the situations and then decide, there cant be a quick answer to this

Reply

404 Shafik khan July 12, 2014 at 6:18 pm

I have taken the loan of 25 Lacs loan is for 240 month if want to repay it before 240 month it will be benificial for me also what condition will be for repayment

Reply

405 Raj July 28, 2014 at 12:45 am

I had a home of Rs. 31 Lacs at 10.5% pa for 180 months, EMI payable monthly Rs.34,270/= pm. I’am paying regularly Rs.3.75 lacs per month for the last 3 months and will continue to do so. Can you please tell me 1.How many months it will take to close the loan. 2. How much interest i would have paid when closing the loan and 3.How much interest savings i would have got. The bank charges no penalty for prepayment.

Reply

406 Anurag Agarwal July 30, 2014 at 2:13 pm

Dear Manish!
Thanx for your article/blog and pains taken by you in answering the queries. I am planning to buy a house worth 63 lacs. SBI is offering only 80% ie about 50 Lacs of this amount but ICICI is ready to loan up to 60 lacs. Interest rates are same in both banks as of now. As far as I have understood through your teachings that monthly and daily reducing manners do matter when one prepays the loan.
Now my question is – as I need more loan, should I go for ICICI now to meet my needs (though I am really scared to read experiences with ICICI) and transfer this loan to SBI within 3-6 months. ICICI is saying that they don’t charge Transfer Penalty. Is this a wise decision? Second- if I take a joint loan with my wife,Can the entire Tax benefits/Deductions under 80C be utilized by one person or not, rather than by both of us.
Plz do reply soon.

urs

Anurag

Reply

407 Santosh M April 15, 2011 at 1:16 pm

So what you are saying is that there is no benefit in terms of reduction of total loan amount if i prepay the loan? So what is the benefit of prepaying a loan then? Inflation and other things will make the value of money less in future. not prepaying the loan is advantegous in that case right?

Reply

408 Manish Chauhan April 15, 2011 at 1:19 pm

Santosh

Yea , maybe in some cases , Its all about how much time you want to pay in your life. It would vary from case to case

Manish

Reply

409 Manish Chauhan May 12, 2011 at 12:45 am

Sa ntosh

Where did i say that “prepay does not reduce the burden” ,. It does !

All i said is that if you choose to prepay a long term loan of 10 or 15 yrs after 4-5 yrs , then your outstanding loan would still be very much close to what it was earliar

Manish

Reply

410 Balamurugan May 12, 2011 at 8:30 pm

Santosh,

Just to add upon to Manish’s comment.

It is always better to pay more part-payment frequently than pre-closure of full loan

Also Pre-closing a short term loan will benefit more than pre-closing a long term loan. Because Long term loan will cost more interest at initial stage.

Manish,
Correct me, if i am wrong

Reply

411 Manish Chauhan November 5, 2011 at 1:53 pm

Santosh

I never said that . what i am saying is that prepaying a loan very early , will make sure that you pay almost the loan amount because in initial years , you dont payback a lot of PRINCIPAL amount .

What exactly is your situation, give the numbers and we can discuss it

Manish

Reply

412 Manish Chauhan May 13, 2011 at 12:12 am

Balamurugan

Yea , prepaying a big loan seems to be more realistic for a common man , because he does not get a lot of money to pre-close the whole loan . I am of an opinion that one should choose less tenure as far as possible , unless taxation is considered and it makes taking loan term loan attractive .

Manish

Reply

413 Prasad Naik March 12, 2012 at 10:50 pm

Hi Manish

I have taken an home loan of Rs.11.50 lakhs from ICICI bank in year 2007. In Feb 2010 I have come to know that there is scheme of ICICI bank through which I can fixed my rate of interest @ 8.25% for 2 year by paying bank charges of Rs.12000. I opted for that and fixed my rate of interest @ 8.25%. But now since the tenure of 2 years is over ICICI Bank has send me letter stating that my rate of interest will be 11.75%. The current outstanding is Rs.7.27 lakhs. Please advice what to do.

Thanks
Prasad Naik.

Reply

414 Rajdeep January 22, 2012 at 10:59 pm

Hiii….Manish…. your article is simply great …
I want to get some help from you…
I have the following situation…
I got a central Govt Job in march 2010 and my probation period is of 2 years..meaning I will get permanent employee on march 2012.Now I want to buy an apartment having a value of about Rs 13 Lakhs next year..In this regard I want to take home loan of Rs 6 Lakhs for a tenure of 20 years.I will pay the remaining money from my and my father’s earlier savings.Now for a home loan of 6 Lakhs and a tenure of 20 years means an EMI of Rs 6000 apprx. Now my net salary per month is around Rs 28000 and since I am only 23 years old,I dont have any such liabilities.So, I want to prepay my home loan as fast as I can…may be within 3-4 years…
Can you suggest me a way by which I can prepay my Loan properly easily within 3-4 years.Is it really possible…??
For a loan of 6 Lakhs…the total money (interest+principal) for a tenure of 20 years comes out to be 15 Lakhs apprx. Now if I want to prepay the entire loan in 3-4 years…do I have to pay entire 15 Lakhs…or less than that…??
I will really wait for your reply….
tc

Reply

415 Manish Chauhan January 24, 2012 at 12:46 pm

Rajdeep

Why are you applying for loan of 20 yrs ? I am sure you are just trying to play safe , but better take the loan for only 5 yrs , if you take a loan of 6 lacs for 5 yrs .. the EMI would be just in range of 12-15k per month , and I think you can afford it easily , the interest part will be really less in that case . So dont take it for 20 yrs ,take it for only 5 yrs or max 7-8 yrs

Manish

Reply

416 Ashal Jauhari February 6, 2012 at 9:52 pm

Dear Rajdeep, may I know how much money you are taking from your father? I feel I may help you here within the over all scheme of things as planned by you.

Thanks

Ashal

Reply

417 Veerendra January 24, 2012 at 4:30 pm

Hi Manish,

Very good article and a good followup as well.

I took a home loan of 29.5 Lakh in Nov 2010. The current interest rate is 9.25% fixed only till March 2012. From April 2012 it will be converted to floating interest and the projected interest rate is 11.5%. I am paying EMI of Rs 27000.
Till now I did 4 lakhs pre payement. I have kept the EMI same and let the terms reduce. Now my loan term is reduced from 240(original) to 160. And outstanding loan amount is 24.8 lakhs approx.

I have a question,

1. Now, If I reduce my EMI and increase trerms to 240, my EMI gets reduced by Rs. 4300 approx. By yearly, I have to pay Rs. 51600 less toward EMI. Now If I use that projected money savings to do a part prepayment of Rs.51600 in advance of the year, And I can continue doing that every year after. Does that will be more beneficial than paying current EMI of 27000?

In short, which one is more beneficial between below:
A: Keeping 27K emi
Vs
B: reducing it to 22.7K and preyaing 51600 in the begening of year and continue to prepay the savings reduced by EMI in prepayment.

Thanks and Regards

Reply

418 Manish Chauhan January 26, 2012 at 5:28 pm

Veerendra

It would be beneficial if you keep your EMI same , because even if you decrease it and then increase your tenure , ultimately you will again be in same situation , when you prepay yearly .. your tenure will again come down anyways ..

Just keep prepaying ..

Manish

Reply

419 Veerendra January 27, 2012 at 9:57 am

Thanks for the reply Manish.

Reply

420 Rakesh January 27, 2012 at 6:29 pm

Hi Manish,

Regarding Veerendra doubt….

Paying Same EMI and Reducing tenure And Reducing EMI wit same tenure by doing Prepayments…
In this two situations by doing same equal prepayments, at the end the total amount paid is the same r not?

If same …
Then If we reduce the EMI amount is saved and that amount can directly pay as Principle.
Then why u said reducing tenure is better option?

Reply

421 Manish Chauhan January 28, 2012 at 11:17 am

NO , It will be different .. in first case where you reduce the tenure .. the outstanding loan is SAME , only the interest part goes down and principle part goes up by some amount . Where as in the second option , the Loan Outstanding is going down with each payment , so a lot depends on how fast you are prepaying , what amount you are prepaying ..

Manish

Reply

422 Rajdeep February 25, 2012 at 12:15 pm

I will bw taking around 3 lakhs from my father.

Reply

423 Rajdeep February 25, 2012 at 12:17 pm

Hii Ashal
I will be taking around 3 lakhs from my father.

Reply

424 Ashal Jauhari February 26, 2012 at 12:56 am

Dear Rajdeep, Are your father still working or retired?

Thanks

Ashal

Reply

425 Ashal Jauhari February 26, 2012 at 12:59 am

Dear Rajdeep, sorry for the typo – Please replace ‘are’ with ‘is’ ?

Thanks

Ashal

Reply

426 Veerendra February 27, 2012 at 10:45 am

Hi Manish,

I have a question regarding RPLR spread of home loan.

Currently my RPLR spread is 5%. The financial organization is offering me 6% RPLR spread. I will need to pay ‘conversion fees’ 0.5% of my outstanding principle amount.
In my case, principle outstanding is 2350000 so the ‘conversion fee’ is 11750.

Is this offer any beneficial to me? or should I prepay that much amount instead?

Please advice. Could also add some info on RPLR and RPLR spread.

Thanks

Reply

427 Ashal Jauhari February 27, 2012 at 11:15 am

Dear Veerendra, RPLR stands for Retail Prime Lending Rate. Spread stands for the discount offered to you from the RPLR. For your example, I assume your RLPR is 17% %, so @ 5% spread, your current home loan interest rate is 12% & after the conversion fee it ‘ll become 11% @ 6% spread.

In my view, it’s advisable to go for this conversion.

Thanks

Ashal

Reply

428 Veerendra February 27, 2012 at 5:59 pm

Hi Ashal,

Thanks for the explanation and advice.

Reply

429 Manish Chauhan March 13, 2012 at 10:28 pm

Prasad

Yes , ICICI bank is right in that .. as per the market linked interest rate the rates are around 11.75% .. so thats what you will pay, your 2 yrs are not gone . Whats wrong in that ?

Manish

Reply

430 Kumar August 8, 2012 at 2:28 am

Hi Manish,

Thanks much for the information, I have got enough inputs.

In case if I need to clear my loan with pre payments in early years, how do I go about it?

I am just mentioned Rajdeep’s query as an example and this is the same question i have, please clarify.

For a loan of 6 Lakhs…the total money (interest+principal) for a tenure of 20 years comes out to be 15 Lakhs apprx. Now if I want to prepay the entire loan in 3-4 years…do I have to pay entire 15 Lakhs…or less than that…??

Kumar

Reply

431 Manish Chauhan August 8, 2012 at 7:11 pm

Kumar

You have to see your “outstanding balance” , you need to pay that .. when ever you pay any amount, your outstanding balance comes down and it keeps changing .

Reply

Leave a Comment