How to calculate Home loan interest

How to calculate Home loan interest

A home loan is offered to individuals who wish to buy an apartment or other residential property. A home loan is a secured loan meaning that the bank/finance company extends credit to the borrower with the home (or property) as collateral to safeguard against default. Once the borrower pays back the loan amount in full, including interest, the ownership of the property is fully transferred to the borrower’s name.

The cost of borrowing money from a lender is known as interest.  The repayment amount that is due over the entire loan period includes the original loan amount (known as principal) and the interest

What is an EMI?

In simple terms, an EMI (Equated Monthly Instalment) is the amount a borrower has to pay the lender every month to pay off the loan. EMI payments are made to a lender every month generally on a fixed date, till the outstanding amount is completely paid off. For home loans, the repayment period is generally long given the size of the loan amount and can stretch up to 30 years.  

How is the EMI calculated?

 The EMI is calculated using a standard mathematical formula. This formula takes into account the loan amount, the tenure (loan period) and the interest rate charged. You can calculate the interest you need to pay using a simple calculator at home. Alternatively, several banks and housing finance companies offer an EMI calculator tool on their website which is simple to use. All you have to do is to input the numbers for the loan amount, period and interest rate and you will find out your monthly EMI payment. A Loan Amortisation table will further break down your monthly EMI into the principal and interest components and will give you an idea of exactly how much interest you are paying over the entire period of the loan. (See below for a sample Loan Amortisation Schedule.)

 What is the interest rate for a home loan?

Each bank has its own interest rate which can vary based on the customer’s credit profile. There are two main kinds of interest rates that apply to home loans:

Fixed rate: If you opt for a fixed rate loan, then a fixed rate of interest is charged throughout the loan tenure. This means you will pay a constant EMI amount for your entire loan tenure. With this kind of interest rate, you have a fixed monthly outflow which helps with personal budgeting.  During the initial stages of repayment, your EMI will contain a larger interest component, while during the later years you will be repaying the principal.

Floating rate:Floating interest rates vary with current market lending rates. Generally, you would choose a floating interest rate if you feel that interest rates are going to go down in the future and do not want to be tied to the high current interest rate.  The EMI amount you pay can change periodically according to the fluctuations in the interest rates in the market. However, keep in mind that many lenders will allow you to change from a floating to a fixed interest rate, on the payment of a fee.

How can I choose the best offer?

The best thing to do is to research the multitude of home loan products on the market and study what each has to offer. However, many people simply do not have the time to go through the complexities of finding out about home loans and the benefits and drawbacks of each of the offers on the market. In that case, you could approach a professional credit management company, like CreditMantri, to guide you through the process of finding out how much your home loan will cost and help you identify the most suitable loan available in the market depending on your needs and level of affordability.

Sample Amortisation Schedule

 An amortisation table is useful for learning what your monthly EMI or annual outflow will be and what percentage of that outflow consists of interest repayment and principal repayment. You get a good idea of your repayment outflow over the entire loan tenure.

 

AMORTISATION TABLE

Below is a sample table for a loan taken on the following terms:

Principal – Rs. 50,00,000

Tenure – 20 years

Interest Rate – 9.5%

This table doesn’t seem right. You have only subtracted the principal for the ending balance, not interest plus principal. In year 1, after paying 4 lakhs as interest, the ending balance is still only 49 lakhs. Please redo the table correctly.

Also, you have written Month in Column 1, instead of year. I would have corrected it on my own, but since I am sending the article back to you, wanted to point it out. Please be careful about such things. We cannot afford to have any errors in our content. 

Also, if it is an offsite article, like this one, make sure you add a mention of CreditMantri towards the end.

 

Month

Starting Balance

Interest paid

Principal paid

Ending Balance

1

50,00,000

4,71,232

88,047

49,11,953

2

49,11,953

4,62,493

96,785

48,15,168

3

48,15,168

4,52,888

1,06,391

47,08,777

4

47,08,777

4,42,329

1,16,950

45,91,826

5

45,91,826

4,30,722

1,28,557

44,63,269

6

44,63,269

4,17,963

1,41,316

43,21,953

7

43,21,953

4,03,937

1,55,341

41,66,612

8

41,66,612

3,88,520

1,70,759

39,95,853

9

39,95,853

3,71,573

1,87,706

38,08,147

10

38,08,147

3,52,943

2,06,335

36,01,811

11

36,01,811

3,32,465

2,26,814

33,74,997

12

33,74,997

3,09,954

2,49,325

31,25,673

13

31,25,673

2,85,209

2,74,069

28,51,604

14

28,51,604

2,58,009

3,01,270

25,50,333

15

25,50,333

2,28,108

3,31,170

22,19,163

16

22,19,163

1,95,240

3,64,038

18,55,125

17

18,55,125

1,59,111

4,00,168

14,54,957

18

14,54,957

1,19,395

4,39,884

10,15,073

19

10,15,073

75,737

4,83,541

5,31,531

20

5,31,531

27,747

5,31,531

0

Comments (0)
Check your Free Credit Score Online

As part of our efforts to make the end consumer services affordable and available at price points which are favourable to the customer, CreditMantri may receive fees / commissions from lenders.

CreditMantri ™ is a registered trademark of CreditMantri Finserve Private Limited. All Rights Reserved. Product name, logo, brands, and other trademarks featured or referred to within Credit Mantri are the property of their respective trademark holders.

CreditMantri was created to help you take charge of your credit health and help you make better borrowing decisions. We support customers with every kind of credit profile - those who are new to credit and have a minimal or nonexistent record; those who have a problematic history; and those who already enjoy a healthy profile. If you are looking for credit, we will make sure you find it, and ensure that it is the best possible match for you. How do we help you? We enable you to obtain your credit score instantly, in real time. We get your Credit Score online and provide a free Credit Health Analysis of your CIBIL or Equifax report. Based on the analysis, we help you discover loans and credit cards best suited for your credit profile. We help you understand your Credit Information Report (CIR) and offer practical and personalized recommendations, tailored to help you improve your score and become loan-eligible. We are a one-stop shop for all your credit needs. We make it easy for you to browse through and compare the various financial products on offer on the market; access our free and user-friendly online tools; and finally, enjoy a stress-free application process with quick approvals. We ensure that you have a high probability of being approved for the loan or credit card you apply for as we only suggest products pre-matched to your profile. We help you avoid loan rejection by carefully determining your eligibility and matching you with the right lender/product. We achieve this with a cutting edge combination of data science, technology and credit management that ensures that both lenders and borrowers have a transparent common platform to make their decisions. We treat your data with the utmost confidentiality and will never share or sell it to anyone. That is our CreditMantri guarantee. Our dedicated and best-in-class customer service will go the extra mile (or two) to support you on every step of your credit journey. Our 4,20,000 happy customers are our best testimonial.

CreditMantri is India’s No. 1 site for Credit Analysis and Free Credit Score Online. Let us help you take control of your credit goals and unlock the door to your financial freedom.