How EMI’s Principle and Interest breakup is done
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.
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 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.
Here is the actual breakup of the EMI in numbers
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.
- Download Excel version of Loan amortization calculator
- Use this Advanced EMI calculator (copyright Manu NIIT)
- Download this multi variable EMI calculator (Source : Joe Verghese)
- Use the below embeded Loan EMI breakup calculator (direct link)
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”
ORIGINAL POST BY MANISH CHAUHAN :