4/10/2024 0 Comments Hdfc home loan calculatorTo make it easy for you, here is a free excel based Home Loan EMI Calculator that also shows you the loan amortization schedule. Home Loan EMI Calculator (Free Excel Download) + Home Loan Amortization (Free Excel Download) 2023 Or you can easily get a quick idea of the same using online loan amortization table calculators. It will indicate exactly your outstanding home loan amount at any point in time. If you have a home loan, just ask your lender for the home loan amortization table. You can see the bulk of the EMI payments during the initial years goes towards interest payment. The actual amount you have repaid would be about 23-24% only. So don’t think that if it’s a 25-year loan, then you would have paid back half your loan in 12-13 years. Do spend some time studying the table below: With each passing month’s EMI, the interest paid decreases and the principal repaid increases. During the latter years, the principal component is higher. If you look at the annual loan schedule below, you will realize that the interest component paid is higher during the initial years. Outstanding Loan Principal at the end of month = Rs 49,89,450Īnd this continues for one by one for all the months in the loan tenure.Įvery month, the Interest payment for the month goes down while the principal repayment goes up.Principal payment for month = EMI – Interest Payment = 38,591 – 33,298 = Rs 5292.Outstanding Loan Principal at the beginning of month = Rs 50 lakh – Rs 5258 = Rs 49,94,742.Outstanding Loan Principal at the end of month = Rs 49,94,742.Principal payment for month = EMI – Interest Payment = 38,591 – 33,333 = Rs 5258.Interest to be paid for month = 50 lakh * 8%/12 = Rs 33,333.Outstanding Loan Principal at the beginning of month = Rs 50 lakh.Now let’s see what part goes towards principal repayment and what part goes towards interest payment? That is, the monthly EMI is Rs 38,591 per month (in EMI). Loan Tenure in Months = 25 years * 12 = 300 months.Using the following values in the PMT formula in excel: This is the loan EMI calculator excel sheet formula Monthly EMI = PMT (Monthly Interest Rate, Tenure in Months, Loan Amount) We use the excel formula PMT to calculate home loan EMI. Suppose you take a home loan of Rs 50 lakh for 25 years at 8%. And in turn, the lower will be the monthly EMI. The bigger the downpayment, the lower will be the loan amount. Down payment amount: This is an indirect factor.Loan interest rate: Higher the interest rate of a loan, the higher will be your EMI.Repayment tenure: Longer the loan tenure, the lower will be your loan EMI.Loan amount: Higher the loan amount, the higher the EMI.And in the later years of the loan tenure, the EMIs contribute more towards repayment of the loan principal.Īnd what are the factors that impact EMI? But the initial EMIs contribute more towards the interest component of the loan. The EMI amount is fixed for the full tenure. Or to put it simply, a part of the home loan EMI goes towards interest payment while the other part is used to reduce the outstanding loan principal. The EMI is made up of 2 parts: i) principal amount being repaid and ii) accrued interest. If something is unaffordable for you as of now, you can purchase it by taking a loan and repaying back in smaller EMIs over a period of time. The best part about EMI is that you get to repay back the loan in small parts which are easier for most salaried individuals. It’s a monthly payment that the borrower makes towards repayment of the home loan. How Home Loan EMI works?ĮMI stands for Equated Monthly Installment. Wrong! It’s on the contrary quite easy.Īnd once you understand how EMI works, you will be in a better position to understand how changing the variables like principal, loan interest rate and tenure results in changing the monthly EMIs. Many people think that EMI calculations are tough and even if they tried, they won’t be able to figure things out. In this post, we discuss how to calculate home loan EMI yourself and also provide you with Free Excel-based Home Loan EMI Calculator (Free download) The banks will no doubt be willing to tell you the EMI you need to service, but it’s in your interest to understand the calculation of home loan EMIs Right? So you should understand how to calculate EMI on home loan correctly even if you have to use a loan EMI calculator in excel or otherwise. At least for the vast majority of people who aren’t into business requiring business loans. So you are looking for Home Loan EMI Calculator (Free Excel sheet download) for the year 2023?Ī home loan is probably the biggest loan you will ever take in your life.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |