POSTED BY January 18, 2008 COMMENTS (129)ON
Taking loan on EMI is a good option, but do you know how to calculate EMI? Its not just about Home loan, it can be any loan EMI .
In this post I will tell you how does the monthly EMI for home Loan is calculated and how increasing Tenure does not help much after a certain point.
EMI is an abbreviation of Equated Monthly Installments. The name itself explains what does it exactly means. Its a monthly installment that a borrower have to pay to the bank or the financial institute from where he has taken the loan.
This EMI depends upon the principle amount of loan and tenure i.e. years for which the loan has been taken.
EMI can be calculated on the basis of 3 terms, which are as –
The formula for calculating EMI is given below.
L = Loan amount
i = Interest Rate (rate per annum divided by 12)
^ = to the power of
N = loan period in months
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. Have a look at the example given below to get a clear idea about it.
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)|
|EMI =||916 X (5.161846 / 4.161846)|
|EMI =||Rs 1,136|
Note at i = 11 percent / 12 = .11/12 = .00916
You must have got an idea about calculating EMI. Some people think that increasing the tenure of EMI is a good option because it will help to reduce the EMI.
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)
Lim C1 / C2^n
and as C2 > 1 (C2 = 1+i)
Lim C1/C2^n = 0
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 10% interest rate.
See the table given below. In this table, i have shown how EMI changes with increasing tenure, and also the difference in your old EMI and new EMI you will have to pay after increasing the tenure.
|Period||New EMI||Difference between old & new EMI|
From this table you must have realized that after a particular time there is no sense in increasing the tenure because the difference between your old EMI and new EMI will be in some rupees which is negligible.
So it is advisable not to extend your loan tenure to much just to reduce the EMI.
Interest rate on loan is different for different banks. So the EMI you will have to pay is also different from bank to bank. In the table given below, I have enlisted some top banks and their EMI calculators link. Click on the links to check the EMI of different banks.
|Bank if India||https://www.myloancare.in/home-loan-emi-calculator/bank-of-india|
|Bank of Baroda||https://www.bankofbaroda.com/baroda-home-loan.htm|
Taking loan is not a bad thing and it doesn’t carry a risk with it, but its only then when you manage it properly. If you have any doubt regarding this information please leave your query in the comment section.