Do you know how home loan EMI is calculated ? Its not just about Home loan , it can be any loan EMI . In this post we will learn how do we calculate monthly EMI for home Loan and how increasing Tenure does not help much after a certain point. A lot of people do not know that increasing the tenure only leads to increase in Interest amount payable and nothing else . The decrease in EMI is not proportional to the increase in Loan tenure . In Housing Finance , Equated Monthly Installments (EMI) refers to the monthly payment towards interest and principal made by a borrower to a lender. EMI is calculated using a formula that considers .
- Loan Amount
- Interest Rate
- Loan Period
Where,
L = Loan amount
i = Interest Rate (rate per annum divided by 12)
^ = to the power of
N = loan period in months
Example
Assuming a loan of Rs 1 Lakh at 11 percent per annum , repayable in 15 years, the EMI calculation using the formula will be :
EMI = (100000 x .00916) x ((1+.00916)^180 ) / ([(1+.00916)^180] – 1)
====> 916 X (5.161846 / 4.161846)
EMI = Rs 1,136
Note at i = 11 percent / 12 = .11/12 = .00916
Q. How much benefit we get by increasing the Tenure of the Loan. Considering a Loan of Rs 30 Lacs at 12% interest rate.
Ans : I did a bit of my so called “mathematical skills” … and found out that EMI is of form
EMI(n) = C1 X C2^n / C2^n-1 , where
C1 = L * i
C2 = 1+i
So the difference in the EMI value for n+1 and n is nothing but
by a bit of caculation i got :
EMI(n) – EMI(n+1) = C1 x (C2^2n – C2^n) / (C2^2n – 1)
and when n becomes very large … and appling limit, we get
Lim C1 x (C2^2n – C2^n) / (C2^2n – 1)
-> Inf=>
Lim C1 / C2^n
n->Infand as C2 > 1 (C2 = 1+i)
=>
Lim C1/C2^n = 0
n->Inf
Or in other words if we differentiate the EMI formula … we get a constant …
It shows and proves that the difference in EMI value is not very significant copmpared to the change in tenure and at one stage its almost of no gain to increase the tenure.
To show this argument : i would like to present an example, considering my old question:
Q. How much benefit we get by increasing the Tenure of the Loan. Considering a Loan of Rs 30 Lacs at 12% interest rate.
I am listing down the EMI value for different Tenures from 10 years to 100 years
Tenure EMI Differnce in EMI when tenure increased by 5 years
10 43041 7036
15 36005 2972
20 33032 1435
25 31596 738
30 30858 391
35 30466. 211
40 30254 115
45 30139 63
50 30076 34
55 30042 18
60 30023 10
65 30012 5
70 30007 3
75 30003 1
80 30002 0.95
85 30001.17 0.52
90 30000.64 0.29
95 30000.35 0.159
What it tells us is that it’s almost useless to extend the tenure after some time …
{ 82 comments… read them below or add one }
You are brilliant! Thank you for sharing your wonderful ideas and tools.
@Stock trading
Thanks a lot .. what do you think about the maths done here
.. just curious 
Manish
I have taken a fixed home loan of 20,00,000 for 15 years with 9.5% rate. My EMI was 22K, however i started paying 30K instead to save some interest.
Current outstanding is 17.40 Lacs,
With my calculation i will be closing the loan in next 6 years.
I have some money now around 1 Lac, Should i pay this one and save interest or invest in a mutual fund and continue as per plan to close in 6 years.
Brilliant conclusion man. Thanks for this
I saw this blog today for the first time, but I will visit again 
Hi Ajeet
Thanks for stopping by and reading . I am sure you will get amazing things in future too
Manish
Manish ,
U Rockz . Tihs blog makes me to re check my math skills
. U r simply awsome
Amarnath
Thanks man … I am sure you are talking about the calculas part
Manish
Was just browsing through old posts of yours. Would be good if readers also browse this loan amortization schedule @ http://office.microsoft.com/en-us/excel-help/using-the-loan-amortization-and-loan-analysis-templates-HA001034640.aspx
hi manish i read this mail, i adviced my sister to take a longer duration home loan, the reason is every year she does top up of 1lac rs in principal and the difference from 20 years to 15yrs is small, she invest the small part in sip, which we book book profit and prepay the loan, we have planned to stop the loan in ten years . this way she is paying more of principal in the initial 6 years.
is it a good statergy.
Geo
I dont think so . If it was increasing the tenure from 5 to 10 yrs or 10 to 15 yrs, the reduction in EMI would be good enough , but just try to see what is the EMI reduction happenening when you increase the tenure from 20 to 25 yrs ?
For a 40 lacs loan @10% interest and tenure 20 yrs , EMI per month = 38601
However when you increase the Tenure to 25 yrs , the EMI comes to 36348 . Thats very insignificant decrease .
Manish
your work is commendable..
but you forgot to take into account time value of money.
Value of money after 30 years is going to be much less than what it is going to be after 10 years. So, repaying the loan in 30 years is much beneficial than repaying back in 10 years. ( in accordance to your stats mentioned above)
You are right when it comes to comparison for 100 years..but I dont think it applies in real world as no bank would offer you that…
cheers,
Srikar
yup
Agree with you
Manish
good this is helpfull.
Dear Manish,
First of all my sincere thanks to you for writing this blog. It really educates me a lot and helps me to lead a wealthy life.
I’ve a query to you regarding housing loan per-repayment of principal while the loan is in partial disburse sate (the loan amount is not fully disbursed).
In details:
- I booked a FLAT which is under construction
- For that, I opt for home loan from SBI (EASY HOME LOAN product)
- The load got sanctioned for 35L on Dec 2009 but the payout(disburse) of the loan amount is linked with the progress of the my flat.
- So for, I the bank disbursed 20L as my flat progressed
- The repayment(EMI) will start in one of the following cases which ever comes first.
1. on July 2011
2. after completion of my flat (i.e. once the full loan amount is disbursed)
- And I don’t need start any repayment(pre-EMI) before the EMI commences.
- But the interest will be calculated for the partial disburse amount and it’s accumulated(again, interest is applicable for the interest) in my loan account.
- From my loan account statement, I can see around 1.5L is accumulated a interest for the partial disburse.
- Meanwhile, I’ve saved around 5L from my salary and put it in a FD (in a different bank) where the interest rate is lower than the home loan interest.
My question here is:
Can I pay 5L towards my loan account now? (1.5L towards interest + 3.5L towards principle)
I asked the same question to my SBI bank manager, he confirmed about the interest part (1.5L) but he is not sure(he don’t know the T&C) about the principle part. He recommend me to not payback the principle now but after the EMI starts.
My problem is, loosing money because of,
– the interest difference between my FD and my home loan
– and the TDS for interest earned form my FD.
And I fear, if any penalty applicable for if I prepay principle(3.5L) at this stage.
Thanks!
Thangavel
Please ask your questions at http://www.jagoinvestor.com/forum/ and please make it short
Manish
Fantastic job done by you Manish. Thanks to people like you who are working for the benefit of all without looking for any personal benefits. Kudos.
Satish
Thanks
. Keep reading
Satish
Thanks
Hi Manish,
I have taken 30,71,000 home loan from SBI for a tenure of 20 years. Interest rate is 8 % 1st year, 9% for 2nd and 3rd year and then floating. SBI has included 18 months of Moratorium period since property will be ready by then, and they will charge only interest part and not principal during this period. Now builder is demanding me to avail ADF facility with SBI. I feel that ADF is not good for me because even on face I am paying extra with Moratorium option, if I invest balance part of EMI for a period of 20 years with average 10 % yearly return that would fill the extra amount I am paying. And second advantage is that I can keep check on builder for work completion to my satisfaction. Can you please help me decide on which option to choose ADF or Moratorium period?
Prithvi
Dont go for ADF , choose pre-EMI , here is why : http://www.rediff.com/getahead/2006/jul/03loan.htm
Manish
Thanks Manish..
I”ve applied a home loan by structured EMI, Where I am paying 1st 4 EMI of Rs. 1000/- and 6th EMI as 11320.00 & nest 5 EMI as 1000.00 and 6th EMI as 11320 for this process entire 60 month paying.
Kindly provide the EMI repayment schedule with EMI, Interest Portion, Principal Protion and Outstanding Principal after EMI.
Loan Amount 100000.00
Tenure – 60 Months
Sturctured EMI – Monthly 1000.00 & Half Yearly 11320.00
Rate of Interest: 20.00%
Pls replay as per the details, if you can provid ethe schdule in Excel than better for me.
Hi,
I want know how bank calculate home loan limit of a person based on his earning power.
Thanks & regards,
mukesh
Mukesh
I am not sure on that, but it should be easy , it should be X times the yearly income , where X can range from bank to bank and is calculated based on job sector , security , past repaying capacity
Manish
I have a plan to take home loan up to 15 lacs.Right now my property is in underconstruction. Now, i want to know if i get the loan from bank during that peroid. How should i have to pay EMI if bank give a money to contractor on progress based.
Amish
the whole procedure whold be almost same as you take a new flat , where exactly are you finding the problem ?
manish
What is the procedure to find out the break-up of Principal and Interest within a Constant EMI. For Example,
Loan Amount = INR 100,000/-
EMI = Constant Amount of INR 3,145.00Per Month, for 36 Months.
Rate of Interest = 8.25%PM
Thus, from Month 1 to Month 36, the Principal Component would increase while the Interest Component would decrease.
Please let me know how the appropriation of the EMI happens, between Principal and Interest Amounts, across these 36 Months.
Thanks in advance.
NVLM
You can use this calculator : http://www.jagoinvestor.com/calculators/html/loan-amortization.html
Manish
In my Query, please read the Interest Rate as 8.25 % PA (type error – mentioned this as 8.25% PM).
Hi Manish,
I have taken a home loan of 17 lakh for 20 years of which only 9.5 lakh is disbursed as yet.Pre EMI interest is being deducted of approx Rs8k .
Can you pls recommend the best options out of below:
1. Get Pre-emi converted to full EMI (of 17k) so that prinicpal also gets reduced
2. Continue paying interest only till full loan disbursement & pay partial repayments from after some intervals to reduced liability
Thanks in advance…!
Manish
loan amount 1000000, 60 months , interest 12.25 % how to calculat education loan emi method ? i want step method to find out principle and interest
Nirmal
You can use this calculator : http://www.jagoinvestor.com/calculators/html/loan-amortization.html
Manish
EMI = (100000 x .00916) x ((1+.00916)^180 ) / ([(1+.00916)^180] – 1)
====> 916 X (5.161846 / 4.161846)
EMI = Rs 1,136
reply me step method : how to calculate ( 1+.00916) ^180
what is mean ^
Nirmal
That means to the power of , you can use our calculator on EMI : http://www.jagoinvestor.com/calculators/html/loan-amortization.html
That was really an eye opener
thanks
Tejkant
Good to hear that you liked it
Hi Manish – great to see the black magic maths behind the EMI, i do have a question on this though, the above formulae seem to calculate for ‘repayment type loans’ which is fine most of the time. Quite curious what would be the formalae when only the ‘interest component is being paid’ as is common in western countries, clearly the above does not suit those cases?
Thanks
Aditya
Aditya
Some maths might be needs in that case .. not aware of that right now .. may be asking it on our Q&A forum would help
Mr. Manish
I wanted to know whether the duration of the loan repayment will reduce or not if i increase the EMI.IF yes, kindly give me the benefits of doing so from the borrower’s point of view.
Selvi
Better than increasing the EMI , go for monthly prepayments .. that would be a better choice !
My home loan (sbi) Rs 20,00,000. tenure 15 yrs emi Rs 19226 I pre paid Rs 3,00,000 towards principle .now i like to pay another 4,00,000 towards principle also want to reduce tenure to 10 yrs . Please give me suitable suggestion
Vasundhara
You can keep prepaying the amount , when your prepay , your EMI will be same, but the tenure will automatically come down ! . Dont worry on that. I am sure when you prepay 7 lac in total out of 20 lacs, your tenure will be below 10 lacs only . Ask your bank to give you the updated tenure now
Great work man ..Keep it up..:-D
thanks Rajiv
DEAR MANISH
Thanks for writing the mindblowing blog
My quiry is
I have purchased a under construction flat, it will be ready in next 1 yr., my construction company asking for the documents for making loan case. the EMI for which will be started after i get the possession of the flat.
1. do i have to pay the intertest on the money the construction company using for the period untile EMI start date. if yes can i pay some principle also with this interest.
2. if i have some money with me now, is it better to pay to the construction company & reduce the loan amount or to prepay this lumpsump amount to the bank after the loan case strat.
Sachin
This question is best suited for our forum : http://www.jagoinvestor.com/forum/
I have taken 12 lakh loan. The interest rate is 8.25 for the first six months and then 9.25 for the next twelve months. How will I calculate the EMI for this loan? I’d be grateful to hear your solutions please. Thanks Binu
You need to make an amortization sheet (learn about it) and then you should be able to make it on your own !
Please advice
1. shall i withdraw my pf fund to reduce my home loan as home loan intrest @ 9.8 % and PF intrest rate is 8.6 % only
2. How the home loan intrest is calculated compounded quarterly or monthly as pf intrest rate is compounded monthly basis…..
Naresh
EMI is calculated this way : http://www.jagoinvestor.com/2008/01/how-home-loan-emi-is-calculated.html
Dear Manish Ji,
Pls tell me how to calculate this figure
Thanks
((1+.00916)^180 ) / ([(1+.00916)^180] – 1)
(5.161846 / 4.161846)
EMI = Rs 1,136
You can do it in excel sheet .. just put a “=” before that and press enter .
Manish
My loan amount is 1500000 lakh, for 20 years & rate if int is 11.10
EMI – 16310
Please tell me what is the calculation. Interest & Principle amount in EMI.
You can use this calculator to find it http://jagoinvestor.com/calculators/html/loan-amortization.html
thanks nice explanation for EMI.
after finding EMI from formulas mentioned above. how can we know what is the amount of principal & interest involved in EMI?
Suresh
This one will help you – http://www.jagoinvestor.com/2011/04/loan-amortization-emi.html
thanks for the reply.
i am looking for the formula used for principal & interest calculation, like above used for calculating EMI.
this will help me to make my own calculation sheet.
You can download this sheet here – http://www.jagoinvestor.com/2011/04/loan-amortization-emi.html
Ihave taken the loan of Rs. 8500000 for 15 years@ 9.5% in 2004. Now after 8 years, how much should I pay totally if I want clear the loan now. And is it wise to do so?
You can check your loan outstanding from the bank where you have taken the loan from . Is it wise or not, will depend on your view about the debt and your over financial situation !
Thanks for putting the calculations Manish. I am planning to transfer my home loan from one bank to another. I want to calculate how much money i am going to save before i make this decision. Can you please point me to calculations which i can do, considering i will keep prepaying some amount in loan time to time?
Right now we do not have any such kind of calculator . I will try to prepare it sometime , as of now you can pose your question here http://www.jagoinvestor.com/forum/
Hello Manish,
Thank you for your valuable information. I have already obtained a Home Loan in my Native place (for which EMI is yet to start) and would like to avail a new loan where I am currently put up.
Could you kindly let me know or point to any information that would be helpful for me (in terms of using the money wisely – reduce loss of cash as interest etc.) and others who are in a similar situation?
Thanks in advance for your guidance.
Murugan.
This might help – http://www.jagoinvestor.com/2011/04/loan-amortization-emi.html
hello sir i ‘ve taken a loan of 1500000 @10.75 i just want to know which tenure period would be beneficial for me if emi can be paid up to 25000.
If you can pay upto 25,000 as EMI , the tenure will automatically get reduced , just start paying more !
I have a question Manish,
We have taken a loan of Rs3590000 and pay an EMI of Rs 40900 from Jan12.
During September and October we paid Rs one lakh each as partial repayment. We would like to know how many instalments we need to pay further at the same rate of EMI
Kindly answer me by mail.
Regards,
Sundar
This article will help you http://www.jagoinvestor.com/2011/04/loan-amortization-emi.html
Thank you Manish for writing such informative articles.
I have following query about Home Loan.
I have selected a builder who is running a scheme called “Live Lite” where at booking we have to pay 20% & Bank will pay rest 80% to the builder(upfront – I think). Till flat possession Pre-EMI is paid by Builder.
Its looks beneficial to me, what is your view?
Deepesh
The question is more suitable for long discussion and more inputs , please open a thread here – http://www.jagoinvestor.com/forum/
very useful article. it spoke our minds.Thank you so much.
Dear Manish,
Found your blog interesting.Please tell me how to calculate the total amount to be repaid ? how to calculate the break up of Principle and interest for the first month?
How to calculate the break up from the month 2 ?
Please guide me. I have applied for a loan of 13lakhs for 10 % interst with HDFC for a tenure of 20 years.
hello sir I ‘ve taken a loan of Rs. 23,00,000 @10.75 for 20 years period. please calculate EMI rate as per above loan amt, interest and period.
You can do it here http://jagoinvestor.com/calculators/html/EMI-Calculator.html
Dear shri Chouhan,
I shall be highly obilized if you please send me per year interest and principal for a housing loan of rs 2000000 for a240 months tenure @ 9.95% intt
Thanking you
s.k.khanna
You can do it using the sheet which are given at the end of the article http://www.jagoinvestor.com/2011/04/loan-amortization-emi.html
hello sir,
im plannin to construct a home, hence forth im applyin loan for 15lakh, where in interest rate is 10%.. hw 2 calculate emi?? usin ur formula, im endin up in an unknown number.. can u plz explain me.. thank u in advance
What is the number you are getting ?
sir for the loan amt of 1500000/- fifteen lakhs for 20 years, sir give in detail what the EMI Would be
+principle amt monthly
Check this – http://jagoinvestor.com/calculators/html/loan-amortization.html
Say i have taken a home loan with following details:
loan amount: 3000000 (thirty lakh)
interest:11%
tenure:25yrs(300 months)
Now my question is if i don’t pay any emi and I say that I will pay full amount after 300 months. What would be the amount I have to pay after 300 months
It will run into several crores . This is not how loan works
.