Recalculate your Loan EMI and Total Interest Due in a snap!
Monthly amount paid to your Loan provider
Your debt repayment schedule in regular instalments over a period of time.
|Year||Principal Paid(A)||Interest Paid(B)||Total Payment (A+B)||Outstanding Loan Balance||Pre-payment|
Find better loan rates, special discounts, cashback offers from all banks only with BankBazaar.com's real time interest rate calculator.
EMI stands for Equated Monthly Instalment which is a fixed amount of payment a borrower has to make to the lender at a specified date on monthly basis. EMIs consists of your principal loan amount and interest amount, payable every month.
Although the EMI remains fixed for every month, the amount paid towards principal and interest changes. The interest component constitutes a major portion of the EMI payment in the initial stages. However, as the loan period progresses and the principal outstanding reduces, the portion of interest repayment decreases. This happens until the end of the loan period when the entire loan amount has been paid off.
Consider a situation where you have decided that you are going to take a loan, be it a personal, car or a home loan. The first step with taking the loan is not applying for it but actually sitting down and calculating how much it is going to cost you. This cost is calculated in terms of the monthly payments that will have to be paid towards the loan and are referred to as EMIs or Equated Monthly Instalments.
To get to the EMI you basically need to calculate the amount borrowed, the interest that you will have to pay on the amount and the amount that you will pay as the processing fee for said loan. Once have all this information, you will have to sit down with a pen and paper to see how much the monthly payment will be for your chosen loan tenure. Once that is done, you may realise that the EMI is too big and you need to reduce it somehow. To do this you will either have to adjust either the loan tenure or the amount that you wish to borrow and do the calculations all over again.
Once you have the right EMI for you, you will start looking at other banks or financial institution that offer you these loans and will realise that you have to repeat the same calculation for each bank and make sure that you make no mistakes. Just reading about this process is so tiring that you will wish there was an easier way to do this whole exercise quickly and efficiently so that you can make your decisions fast and THAT is where the EMI calculator comes into the picture.
To put it quite simply, an EMI calculator is a tool that will require you to enter the amount you want to borrow, the duration of the loan, the interest rates and the processing fee and it will do the rest. The basic formula that works behind an EMI calculator is:
E = P x r x (1+r)^n/((1+r)^n – 1)
This is the most basic formula that will be used by the calculator but there are some that may even include things like the processing fee for the loan, into the calculation of the monthly instalment. The processing fee will generally be a certain percentage of the amount being borrowed and can range from 1% to 3% but since it is decided by the bank it can be different for each bank.
There are three parts to the information that the calculator provides. The first is the EMI itself, the second a breakup of the payments due and the third the amortisation table.
The EMI or the Equated Monthly Instalments are the amount that you can expect to pay if you go in for a loan. It includes payments of the principal and the interest that is applicable on the loan. It is the most important information that the calculator provides since the EMI is at the basis of the decision about the affordability of the loan.
The breakup is a breakup of the entire amount that you will pay to the bank or the financial institution. It will tell you the amount that will be paid back as the principal and the amount that will be paid as the processing fee for the loan. It will also tell you how much of the repayment will be the interest on the loan.
The amortisation table is a snapshot of the progression of the loan and tells you how much you will have paid back at the end of each year, as the loan progresses. It also helps you understand how the interest on the loan will be paid back. It also shows you how much of the initial EMIs will be the interest and how much will be the principal.
BankBazaar’s EMI Calculator helps calculate the monthly instalments payable on any of your loans whether a personal loan, auto loan or home loan.
Calculating EMIs can be a tedious and confusing process. However, BankBazaar has an exceptional and simple EMI Calculator which lets you know the precise amount of your monthly EMIs instantly.
Help you arrive at EMIs in seconds - This calculator will help you calculate exactly how much money you need to pay towards your loan each month.
Simplify calculations - Determine EMIs accurately with minimal effort to reduce stress and confusion caused by tedious manual calculations.
Help plan your finances - Compare possible EMIs by varying the key loan parameters of tenure, amount and interest rate to determine which loan plan is the most affordable to you.
Be it a home loan, personal loan or car loan, now you can easily calculate your EMIs using this user-friendly tool offered by BankBazaar.
Using this calculator is very easy. All you need are the following loan details:
(If you don’t have this information at hand, you can obtain it navigating to your chosen bank’s loan page under the section ‘Select a product to begin’, featured under the calculator).Once, you have these details, use the sliders to set the required parameters for the loan amount and tenure. Then, input the interest rate and processing fee in the relevant boxes.....and Voila!
The loan EMI calculator will instantly reveal your monthly EMI amount payable on the loan!
It will also provide a clear, graphic and tabular break-up of your loan repayments, using the EMI so calculated. In addition an amortization table is created which gives you a detailed overview of your repayment schedule. A cut above the rest, BankBazaar’s EMI Calculator delivers more than you expect.
BankBazaar has customised its EMI Calculator to suit different loan schemes. To calculate your EMIs on your personal loan, navigate to the Personal Loan EMI Calculator provided under the sites ‘Financial Tools’ section. Similarly, you can calculate EMIs on your auto and home loans using BankBazaar’s Car Loan EMI Calculator and BankBazaar’s Home Loan EMI Calculator, respectively.
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)
Pick the most affordable loan by comparing EMIs for different loan tenures. This can be done by altering the loan period in the calculator; keeping the loan amount and interest rate the same. By lengthening the loan period for a chosen loan scheme, the EMI amount can be reduced. Using the calculator, you can quickly compare EMIs for different tenures and choose the one that most suits your budget.
Understand loan repayment schedules by altering the interest rate, keeping loan amount and tenure the same. In case of fixed rate loans, interest rates remain constant over the loan tenure. In this case, EMIs also remain constant. This is usually the case with car loans and personal loans.However, in case of floating rate loans, interest rates can vary with movements in market rates. In this case, EMIs will change. This is particularly beneficial for home loans.Input the new interest rate in BankBazaar’s EMI Loan Calculator to compare EMIs before interest rate changes and after. A new amortization schedule is also generated to reflect changes in EMIs.
The home loan EMI calculator comes packed with features that can range from the obvious to the not so obvious. It, obviously, shows the exact EMI that will be payable every month for a specific amount borrowed and a specific tenure. The feature that are not so obvious is the fact that this calculator can also provide the facility to include planned pre-payments towards the home loan. This means that when the calculator shows you the instalments payable, it has already accounted for prepayments and has also included them when showing the breakup of the expenses. The detailed break up will include the amount borrowed, the interest payable, the amount you will pay through prepayment, the processing fee and the fee for prepayment.
The car loan calculator is a tool that can be used to calculate the exact amount that you will have to pay on a monthly basis when you decide to take a car loan. This calculator too will collect information related to the amount you wish to borrow, the interest rates, the processing fee and the tenure of the loan and provide you with the amount that you will pay every month. Down payments for the vehicle don’t have to be considered when using this calculator and it too comes with the breakup of the expenses and the amortisation table.
The personal loan EMI calculator is the ideal tool for deciding how much you can afford to pay back since it is specific to personal loans. It too collects details of how much you wish to borrow, the duration, interest rates and the processing fee for the loan. It can also be customised to take into account any prepayments that you intend to make before telling you the EMI that you will have to pay.
Now that we know its types and how the EMI calculator works, let’s take a look at some of the features and benefits that EMI calculators have to offer.
There can be no denying the ease with which the calculations can be made with this tool. It offers that convenience of calculations that can be done in mere seconds that help you compare the offerings of various banks and reach decisions without wasting much time.
If you were to sit down with a pen and a paper, every time you vary the interest rates, tenures, amounts to borrow, you run the risk of making mistakes. When you add multiple banks to the mix the chances for errors can be disastrously high and that is where the accuracy of the calculator comes into play.
With a pen and paper you could spend hours on end doing calculations and then checking and re-checking them. With this tool you could do all sorts of calculations within seconds. Which means that you can explore all the options of tenures, amounts that can be borrowed and interest rates without having to worry about how long it will take.
There is no denying that while at the base of it, most loans follow the same principles but there are certain nuances that separate one loan from another and these EMI calculators come adjusted for such nuances. This means that a home loan EMI calculator will give you precisely the kind of information need to decide on a home loan and so will a personal loan EMI calculator.
These calculators don’t just give you an idea of how much you will have to pay on a monthly basis, many of them also provide graphic representations in the form of pie diagrams. These diagrams will show you the total amount that you will pay by the time the loan is fully paid up. It will also show you that of the amount you pay, how much will be the principal, how much the interest and how much will be spent of the processing fee.
Amortisation tables form an important part of any EMI calculator since it is the one table that will show you the future. What is does is to show you how the loan will progress over time and will also show you how much you will have paid back each year of the loan, in terms of the principal and the interest.
Apart from the online calculators, EMI calculators can also be configured in an Excel sheet. To do this you will need to know the formula that makes an EMI calculator works and also how to use formulae in excel sheets. The one disadvantage of the excel sheet calculator is that you need to know how to configure it and also need to input the interest rate after calculating the monthly rates. It also does not take into account the processing fee. By contrast, the online EMI calculator can take the interest rates as annual rates and convert them to monthly rates on its own. It can also include the processing fee and other smaller features like prepayments.
Loans generally come with tree different types of interest rates; the fixed interest rate, the floating interest rates and a combination of the two. With the fixed interest rates, the EMI will always remain the same since nothing changes with such a loan in relation to the interest rate which means that the EMI calculators also is pretty simple and straightforward. With the floating interest rate, or interest rates where a one part is fixed and the other floating, the EMI calculators are not so simple to build. This is so because future interest rates cannot be predicted and hence a definite EMI cannot be determined for such loans. In such cases, the EMI will actually change every month.
The mathematical formula for calculating EMI = [P x R x (1+R) ^n] / [(1+R)^ n-1]. (P is the principal loan amount, R rate of interest per month and N is the the number of monthly instalments). Manual calculations are too complicated to perform accurately, which is why many borrowers are left confused after availing a loan. Understanding this pain-point led BankBazaar to develop one of the easiest and most user-friendly online Loan EMI Calculators.
You can view your loan amortization schedule at BankBazaar by using its EMI Calculator. A loan amortization table is a systematic and tabular display of your loan payment process. The table shows the break-up between the interest component and principal component of a particular EMI payment, enabling you to have a clear idea about the period of payment, interest and principal payments, and the outstanding loan amount over the entire loan tenure. This table can be very helpful for you, in case you want pre-close the loan.
A. 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.
A. The only difference between the two is that with a calculator, it is a ready to use tool whereas with an excel sheet, you may have to program the calculator before you start using it. Such programing can be a little tedious and complicated, especially if you are not very comfortable with the software which makes the calculator the preferred choice.
A. Yes. These days most, if not all, banks have calculators, specific to various loans, available on their websites.
A. The simplest answer is that it’s fast and it’s convenient. This means that you can do multiple calculations in minutes where such calculations many take longer were you to sit down with a pen and paper. These calculators are also super accurate so it eliminates the possibility of errors in calculations, provided you provide accurate data.
A. When it comes to the EMI, assuming that the bank will approve the amount and tenure, the exact EMI 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 EMI.
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...
Most of us do not know how loan EMIs are calculated. Yet, we make payments as per the repayment schedule...
EMIs can be broadly classified as EMI during loan disbursal or EMI after you get the loan...
Manoj Kumar, 29, a Bangalore-based MNC employee, fulfilled his dream of owning a new a car in 2010...
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 loan
For 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..Advantages of Pre-EMIs
Here, EMIs i.e. interest + principal are repaid only once the entire loan amount is disbursed.Advantages of Full EMIs
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.MICROSOFT EXCEL FOR EMI CALCULATION
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.STEPS TO CALCULATE LOAN EMIs USING EXCEL
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.
The Marginal Cost of Funds Based Lending Rate (MCLR) of Bank of Baroda is revised to 8.30% p.a. recently. The revised MCLR is applicable on all the tenures of loan starting from overnight to 3 years. The new MCLR will come into effect across all the tenors from 7 December 2017.
While the MCLR for overnight tenure is fixed at 8.05% p.a., the 3 month and 6 month tenure has been reviewed to 8.10% p.a., 8.15% p.a. and 8.25% p.a. respectively. Revisions has also been made to the 3 years and 5 years MCLR, where it is fixed at 8.45% p.a. for 3 years and 8.60% p.a. for 5 years.
The new MCLR which will be effective across all the tenors from 7 December 2017, has remained the same as the existing one as no changes have been made in the current MCLR during the revision.
8th December 2017
Owning a home in one’s name is a big dream that most people have. Many people work hard to earn money in order to make funds ready for the purpose of making a down payment for a home loan. With a home loan, one need not spend his or her own money. Instead, a person can utilise the home loan and repay it conveniently through equated monthly installments (EMIs).
However, EMIs tend to get many people stressed as they can affect your other monthly expenses. To avoid this trouble, one can choose a good EMI for a longer period, make high down payments, have a good discussion with the lender to negotiate and get a good interest rate, and may be also shift to a new lender for better interest rates.
7th December 2017
The Reserve Bank of India (RBI) will probably retain the policy rates in the upcoming monetary policy, which is the fifth policy. It is for the financial year 2017-18. The current key policy rate is 6%. Since there is a steady growth, a risk to inflation, and an economic unpredictability, the central bank of the nation may not cut down the policy rates.
Many financial experts are of the opinion that there will not be any change in the policy rates. Even if there is actually no alteration, the language and the goals of the financial statement may get modified.
6th December 2017
The monetary policy panel of the Reserve Bank of India can possibly keep the repo rate on hold in the next monetary policy review. Possibility of retail inflation because of hike in the prices of vegetables, protein items, and crude oil, increased interest rates of the US Fed, and danger of financial slippage are the vital factors responsible for this hold.
Though the RBI monetary policy has been reviewed four times in the current financial year, RBI has opted for a repo rate cut only once during this entire tenure. In the last review conducted on August 2017, the central bank has reduced the policy repo rate, the interest rate at which RBI provides overnight funds to the banks for resolving their liquidity issues, from 6.25 p.a. to 6% p.a.
Though the latest revisions in the GST rates are expected to settle down the existing price pressures in the economy, the chances of inflation still exist. In this situation, the RBI monetary policy committee is most likely to wait and give time to the previous rate cuts work before making any further revisions in the current repo rate.
5th December 2017
Allahabad Bank, leading bank in India, recently decreased its marginal cost of funds-based lending rate (MCLR) by 5 basis points. This change in the rate was implemented for all loan tenors. This change in the MCLR has come into effect from December 1, 2017.
The overnight MCLR rate will be 7.75% which was earlier 7.8%. The MCLR rate for 1-year tenor will be 8.25% which was earlier 8.30%.
On the other hand, the one-month MCLR rate will be 7.9%. The 3-month MCLR rate of the bank is now 8.1%. Meanwhile, the 6-month MCLR is 8.2%.
4th December 2017
When demonetisation was implemented in the nation, the real estate sector was affected very negatively. However, after one year, demonetisation is being viewed as a great boon for the housing industry.
The prices of real estate deals are also improving extensively. Also, the buyers of this industry are genuine now. Moneytize India intends to increase awareness about housing loans and their benefits and features among the public.
Tata Housing has a brand new loan offer with a rate of 3.99%. This attractive rate is making the whole deal offered by Tata Housing very interesting and cost-effective.
30th November 2017
In a report released on Monday, the credit rating body, ICRA, has predicted that the GNPAs (gross non-performing assets) are likely to surge by the end of financial year 2018. According to the report, while the GNP for FY 2017 was Rs. 7.65 trillion (9.5%), this year it can peak out to Rs. 8.8 to 9.0 trillion (10% to 10.2%).
To add here, the credit provisions of the banks surged on a sequential basis by 40% and on a YoY basis by 30% and reached Rs.645 billion during Q2 FY 2018. Also, the total credit provisions for H1 FY 2018 were increased to Rs.1.1 trillion by 17% on a YoY basis. This has consequently weakened the position of the PSBs as out of 21 banks 12 banks are below the regulatory minimum capital requirement for March 31, 2018.
To aid up the PSBs in this situation, the Government of India has announced the most expected recapitalisation plan. Karthik Srinivasan, the Group head of Financial Sector Ratings ICRA Ltd, said that they are expecting the government to provide minimum Rs.850 billion recapitalisation bonds by the end of FY 2018 so that the PSBs can meet the minimum capital requirement.
29th November 2017
Non-banking financial companies (NBFCs) have been concentrating a lot on medium and small scale enterprises (MSMEs) by lending exclusively to them. This is being done in order to increase their MSME loan book. NBFCs have a special four-fold raise for these MSME loan books.
This is a massive move and it offers a lot of good opportunities. However, constant monitoring and tracking of the entire sector or industry is very taxing but important for managing risks efficiently. The present lending market size for MSMEs is around Rs.14 lakh crore.
28th November 2017
IFMR Capital and DCB Bank has invested in Home Credit India Finance's loan securitisation and helped it to raise Rs.153 crore in the process. Though this Prague-based non-bank lender made similar deals twice in India earlier, it entered such deals in the consumer loan segment for the first time. Previously, this company has raised Rs.87 crore by way of securitising two-wheeler loans from the same investors they have dealt with this time.
According to Mariusz Dabrowski, the Chief Financial Officer of Home Credit India Finance, the loan securitisation market in India is growing slowly in volume as well as size and there are better prospects in future. At present, only 5% of Home Credit India Finance’s loans is made up of consumer durables whereas almost 92% of their loan portfolio is attributed for financing mobile handsets. The company is currently targeting to grow its August portfolio of Rs.2900 crore to Rs.4000 crore by the last half of December, 2017.
28th November 2017
If you are interested in looking for a home loan that will allow you to pay low equated monthly installments (EMIs), you should check out the following article. To get a good home loan with low EMIs, you need to do proper research online to secure the most economical home loan product. In the current market, Bajaj Finserv has a great home loan with an interest rate of only 8.30%. The loan amount ranges from Rs.20 lakh to Rs.10 crore. The home loan offered by Aditya Birla charges an interest rate ranging from 8.55% to 8.99%. You will need to repay this loan within 20 years. You can choose your home loan tenure accordingly. Meanwhile, Indiabulls has a home loan with an interest rate of 8.40% to 11.75%. You will get a loan that covers up to 90% of the full value of the property that you are interested in.
27th November 2017
Viral Acharya, the deputy governor of the Reserve Bank of India (RBI), said that he is observing the suggestions that were provided for the RBI study group recommendations regarding external benchmark-based lending rate system. He said that they are also keeping a check on the expenses related to the transition to the brand new loan pricing system.
The report has suggested that RBI policy repo rates, certificate of deposit rates, and treasury bill rates are much better compared to other interest rates for the purpose of the external benchmark.
He also said that bank recapitalisation and asset resolution will enhance the position of bank balance sheets.
23rd November 2017
The introduction of the improved Marginal Cost of Funds Based Lending System (MCLR) to replace the old Base Rate system served as a great technique to make sure that rate reductions are made faster so that they help borrowers. This has been very helpful to borrowers of personal loans, home loans, and car loans.
When the old base rate system was in force, banks were extremely hesitant to make alterations to interest rates. They used to modify interest rates only when the RBI enforced a significant decrease on the interest rates.
The RBI also recently stated that every borrower who is borrowing a loan under the base or MCLR system be transferred to the external benchmark rate system within 1 year after it is launched.
22nd November 2017