Monthly amount paid to your Loan provider
Your debt repayment schedule in regular instalments over a period of time.
Year | Principal Paid(A)1 | Interest Paid(B) | Total Payment (A+B) | Outstanding Loan Balance | Pre-payment |
---|---|---|---|---|---|
1 | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
2 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
3 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
4 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
5 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
6 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
7 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
8 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
9 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
10 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
11 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
12 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
13 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
14 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
15 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
16 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
17 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
18 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
19 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
20 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
|
Dec | ![]() |
![]() |
![]() |
![]() |
|
21 | ![]() |
![]() |
![]() |
![]() |
|
Jan | ![]() |
![]() |
![]() |
![]() |
|
Feb | ![]() |
![]() |
![]() |
![]() |
|
Mar | ![]() |
![]() |
![]() |
![]() |
|
Apr | ![]() |
![]() |
![]() |
![]() |
|
May | ![]() |
![]() |
![]() |
![]() |
|
Jun | ![]() |
![]() |
![]() |
![]() |
|
July | ![]() |
![]() |
![]() |
![]() |
|
Aug | ![]() |
![]() |
![]() |
![]() |
|
Sep | ![]() |
![]() |
![]() |
![]() |
|
Oct | ![]() |
![]() |
![]() |
![]() |
|
Nov | ![]() |
![]() |
![]() |
![]() |
The formula which is used to calculate the equated monthly installments which you are required to pay the lender for availing the loan is
P x R x (1+R)^N/[(1+R) ^ (N-1)]
where P stands for principal amount, R is rate of interest and N is loan tenure.
Let us assume that these are the details of your personal loan by using personal loan EMI calculator :
Loan amount | Loan tenure | Interest rate | Processing fee | Loan EMI |
---|---|---|---|---|
Rs.10 lakh | 5 years | 10.99% | 2% | Rs.21,737 |
Total amount payable
Total interest due | Rs.3,04,246 |
Processing fee | Rs.20,000 |
Loan quantum | Rs.10 lakh |
Total amount to be paid | Rs.13,24,246 |
EMI breakup for a personal loan of Rs.10 lakh
Year | Principal (in Rs.) | Interest (in Rs.) | Total of Principal and Interest (in Rs.) | Outstanding Loan Balance (in Rs.) |
---|---|---|---|---|
2020 | 90,510 | 61,652 | 1,52,162 | 9,09,490 |
2021 | 1,69,254 | 91,597 | 2,60,851 | 7,40,236 |
2022 | 1,88,821 | 72,029 | 2,60,850 | 5,51,416 |
2023 | 2,10,649 | 50,199 | 2,60,848 | 3,40,766 |
2024 | 2,35,002 | 25,846 | 2,60,848 | 1,05,764 |
2025 | 1,05,764 | 2,923 | 1,08,687 | 0 |
The above calculation has been done assuming that you are not making any prepayments and the loan has been availed in the month of June 2020.
Let us assume that these are the details of your home loan by using home loan EMI calculator :
Loan amount | Loan tenure | Interest rate | Processing fee | Loan EMI |
---|---|---|---|---|
Rs.40 lakh | 10 years | 9.75% | 0.5% | Rs.52,308 |
Total amount payable
Total interest due | Rs.22,76,972 |
Processing fee | Rs.20,000 |
Loan quantum | Rs.40 lakh |
Total amount to be paid | Rs.62,96,972 |
EMI breakup for a home loan of Rs.40 lakh
Year | Principal (in Rs.) | Interest (in Rs.) | Total of Principal and Interest (in Rs.) | Outstanding Loan Balance (in Rs.) |
---|---|---|---|---|
2020 | 1,42,083 | 2,24,074 | 3,66,157 | 38,57,917 |
2021 | 2,63,101 | 3,64,597 | 6,27,698 | 35,94,816 |
2022 | 2,89,931 | 3,37,766 | 6,27,697 | 33,04,884 |
2023 | 3,19,496 | 3,08,200 | 6,27,696 | 29,85,386 |
2024 | 3,52,080 | 2,75,617 | 6,27,697 | 26,33,306 |
2025 | 3,87,983 | 2,39,713 | 6,27,696 | 22,45,322 |
2026 | 4,27,550 | 2,00,147 | 6,27,697 | 18,17,773 |
2027 | 4,71,150 | 1,56,546 | 6,27,696 | 13,46,623 |
2028 | 5,19,197 | 1,08,499 | 6,27,696 | 8,27,427 |
2029 | 5,72,141 | 55,555 | 6,27,696 | 2,55,284 |
2030 | 2,55,284 | 6,257 | 2,61,541 | 0 |
The above calculation has been done assuming that you are not making any prepayments and the loan has been availed in the month of June 2020.
Let us assume that these are the details of your car loan by using car loan EMI calculator :
Loan amount | Loan tenure | Interest rate | Processing fee | Loan EMI |
---|---|---|---|---|
Rs.8 lakh | 5 years | 9.12% | 2.5% | Rs.16,653 |
Total amount payable
Total interest due | Rs.1,99,199 |
Processing fee | Rs.20,000 |
Loan quantum | Rs.8 lakh |
Total amount to be paid | Rs.10,19,199 |
EMI breakup for a car loan of Rs.18 lakh
Year | Principal | Interest | Total of Principal and Interest | Outstanding Loan Balance |
---|---|---|---|---|
2020 | 75,722 | 40,852 | 1,16,574 | 7,24,278 |
2021 | 1,39,524 | 60,317 | 1,99,841 | 5,84,756 |
2022 | 1,52,793 | 47,049 | 1,99,842 | 4,31,964 |
2023 | 1,67,324 | 32,516 | 1,99,840 | 2,64,640 |
2024 | 1,83,238 | 16,602 | 1,99,840 | 81,401 |
2025 | 81,402 | 1,866 | 83,268 | 0 |
The above calculation has been done assuming that you are not making any prepayments and the loan has been availed in the month of June 2020.
The BankBazaar Equated Monthly Instalment Calculator is very easy to use. It uses some basic details of the loan that you are willing to avail. In the calculator, you will be required to provide the following details:
After this, the BankBazaar EMI Calculator will process the details and show you ‘Your Monthly Loan EMI’ amount. In addition to this, the calculator will also display a detailed amortisation table for the loan. The actual loan amount, total due interest, and the processing fee are also calculated and displayed at the same time.
Should you find yourself flush with cash, you may decide to prepay your loan (i.e. pay an extra amount towards principal). If so, you can calculate your new EMIs by adjusting for the amount you wish to prepay. This will let you know how much interest you save by reducing the principal outstanding. (interest is calculated on the principal outstanding).
On the basis of the prepayment that you make and the terms and conditions of the loan-provider, you might be required to pay an extra amount in the form of prepayment charge or fee.
When you are planning to take a loan for your financial needs, you need to calculate the amount that you will have to pay through equated monthly installments in order to match with your repayment capability. For this, you will need to take a few factors under consideration which can be altered to meet your loan requirement and repayment capability:
In most cases they can be the same since all three loans work off the same basic set of information like amount borrowed, prepayments, tenure, interest rates and processing fee however with some calculators there could be a restriction placed on the amount to borrow based on the type of loan.
When it comes to the EMI, assuming that the bank will approve the amount and tenure, the exact instalment that you will have to pay may differ slightly since there is a chance that things like the interest rates and the processing fee may be a bit different from what you used while calculating the due amount.
The bank will charge a penalty fee if a borrower misses an EMI payment. A missed or delayed instalment payment will reflect on your credit report. Not making loan due amount payments on time can have a negative effect on your credit score.
In the case of a business loan and home loan, banks offer floating rate of interest. Therefore, your loan instalment may change with the change in interest rate. Some banks allow you keep the Equated Monthly Instalment constant while increasing the loan tenure. Loan prepayment can also change your due amount. Banks will give you the option to either keep the EMI constant and decrease the loan tenure or reduce the Equated Monthly Instalment and keep the loan tenure the same.
Pre-closing your loan before the end of its tenure can have a negative effect on your credit score. Making timely due payments can help you improve your credit score. Therefore, opt to prepay a part of your loan (not the whole loan) and reduce the loan tenure to save up on interest payments. Banks charge a penalty fee for prepayment.
If you miss an EMI payment or pay it after the due date, the majority of lenders charge late payment fees or penalties. These fees may increase your overall debt and raise the cost of repaying the loan. Additionally, your credit score may be impacted if you miss EMI payments. Your credit score is significantly influenced by your payment history, and missed or late payments can lower your score, making it more difficult to get credit in the future. Apart from this, in extreme non-payment situations, the lender may file a lawsuit to recoup the amount. This may lead to legal action, and if the lender is successful in getting their way, they may be able to take your assets or garnish your salary in order to recoup the unpaid balance.
Based on your loan amount, interest rate, and loan term, EMI calculators provide you exact monthly installment amounts. You can better organise your money and make sure you can comfortably meet your repayment commitments thanks to this precision. To determine how changes in interest rates would impact your monthly payments, utilise an EMI calculator. When choosing loan products or haggling interest rates with lenders, this information can assist you in making well-informed selections. EMI calculators offer quick results and are simple to use. Without the need for intricate computations, you may swiftly evaluate many circumstances and come to intelligent conclusions.
Assuming that both sides utilise the same loan parameters and formulae, the EMI computed by a bank or financial institution should match the EMI calculated using an EMI calculator. While some internet calculators may offer more decimal places, banks may round off the EMI computation to the next whole number or a certain decimal point. The computed EMI may experience slight fluctuations as a result.
Yes, paying EMI regularly will improve your credit score.
The formula to calculate EMI is EMI = [P x R x (1+R) ^N]/ [(1+R) ^ (N-1)].
Top picks from our Financial Expert
The most common thing everyone asks when they avail a loan is “What are EMIs? How do I know how much I have to repay every month to clear my loan?”
Understanding EMIs and amortization tables is probably the most confusing part of the entire process of availing any kind of loan. The EMI, or Equated Monthly Instalment, is important because it signifies monthly outflows towards repayment of the loan.
In order to calculate EMI for your loan, you should first understand its components:The formula consists of using the loan amount, interest rate and tenure of the loan (in months): to find out your EMI (Equated Monthly Instalments)
M = No of months to pay the loanFor example: You avail a home loan of Rs.5 lakhs and the bank disburses the loan in instalments of Rs.1 lakh each at each stage of completion of the house being funded. Once the first instalment is disbursed i.e.Rs.1 lakh, the borrower begins making interest payments. Pre-EMIs do not reduce the principal component of the loan amount..
Here, EMIs i.e. interest + principal are repaid only once the entire loan amount is disbursed.
If you plan to sell the house, or are expecting large income inflows orare anticipating higher returns from the property funded by the loan, it is better to opt for Pre-EMIs. However, if you are not sure and do not want to take any undue risks, Full EMIs are a better option.
Manoj Kumar, 29, a Bangalore-based MNC employee, fulfilled his dream of owning a new a car in 2010. He bought a car for about Rs 5.95 lakh. He managed to do this by availing a car loan. The down payment he was required to pay was Rs 1.5 lakh and the remaining amount was funded by his auto financier. The car loan interest rate was 12% p.a. and the loan tenure was set at four years. As per the terms of the agreement, he currently pays a monthly EMI of Rs. 11,700. Manoj goes by the payment schedule as set out by the bank. But, how does he verify the amounts payable as per the schedule? Is there any way he can reduce or increase the EMI based on his financial situation?
Calculating EMIs can be confusing and tedious. There are many borrowers who find it hard to understand EMI calculations and Manoj is no exception. Most borrowers are unsure whether they are paying the right amount as EMIs; in many cases, the lenders themselves may have erred in their calculations.
The irony of it all it that EMIs are not that hard to understand. Using MS Excel, a very popular tool used the world over, anyone can easily calculate the amounts due as EMIs.
An Excel spreadsheet is a software specifically designed for mathematical calculations and performs calculations using a number of preset formulae. This makes it one of the most convenient tools to calculate and understand EMIs or repayment schedules.
To calculate loan EMIs using Excel, you have to use the function ‘PMT’ . You will need to know the rate of interest (rate), the tenure of your loan (nper) and, the value of the loan or present value (PV). Apply this to the formula: =PMT(rate,nper,pv).
Example:If you were to choose a different frequency, say a quarterly payment schedule as opposed to monthly payments, all you would have to do is factor this into the formula to get the desired results.
Example:Its really as simple as plugging in data and receiving results, completely eliminating confusion and anomalies. This not only helps you as a borrower in choosing the right loan plan but also helps you adjust your EMIs according to your financial situation.
HDFC Bank offers various loan products meant for customers of different demographics and incomes. Calculating EMI on any of the loans can be done through a few simple clicks at BankBazaar which specializes in providing free financial services to customers and general visitors.
Availing loans can be a very tricky proposition if you don’t know the underlying details such as EMI amounts, interest rates, processing charges and amortization. You may be looking for a car loan, personal loan, or even a house loan, and the best place to begin your search starts from the Internet.
BankBazaar offers a dedicated EMI Calculator tool that will provide you with information regarding the loan break-up and amortization details. You can access this tool by following these steps:
Once you select an option as detailed above, you will be taken to a new page with different dynamic fields. To use the HDFC Loan EMI Calculator, please follow the steps outlined below:
Once you are done with filling the details, click on ‘Calculate’. The results will appear just below the ‘Calculate’ button. The results are shown in terms of ‘Your Monthly Car/Home/Personal Loan EMI’, ‘Loan Break-up’ and ‘Amortization Details’.
EMI Amount: The monthly amount you have to repay for your particular loan product, according to the details entered by you.
Loan Break-up: Loan Break-up section will show details such as the loan amount, total interest payable, processing fee, and the total repayable amount. The results are also shown aesthetically in graphical format.
Amortization: This result will show details of the amount to be paid at any point during the loan tenure such as principal paid, interest paid, outstanding balance, and total payment made.