Published on Aug 9, 2019Updated on Nov 8, 2023
Personal loans are now some of the most popular types of loans being availed by people. These are short or medium term unsecured loans that people take out to meet their financial needs. Most commonly they are used to meet expenses of debt consolidation, vacations, unexpected medical expenses, amongst others. Personal loans are offered without keeping any asset as collateral, however, your eligibility will depend on your credit history, income, age, amongst other factors. There are no real restrictions on what you can use the money you get from a personal loan for. Usually, borrowers get a flexible tenure of up to 5 years* to repay the loan amount. This is why personal loans are preferred by customers as compared to the credit cards or other loans.
You can avail a personal loan for up to Rs. 25 Lakhs* from with an instant online application. Personal loans have a flexible repayment tenure of up to 60 months*. Borrowers can avail attractive interest rates, and have a hassle-free online documentation process for quick loan disbursal. If you are planning to take out a personal loan, the first step is to calculate how much EMI (easy monthly instalment) you will be paying, as this will greatly affect your repayment capacity.
One of the easiest ways to calculate the EMI on your loan is by using Microsoft Excel. Excel provides a simple formula for this purpose: PMT (rate, nper, pv, [fv], [type]).
PMT stands for Payment – and gives periodic loan payment or EMI value as an output. The arguments required for this function are:
When using this function, make sure that the units for rate and nper are the same. For example, if you are looking to calculate monthly EMI, the rate should be the monthly interest rate and not the annual interest rate. Let us look at an example to understand this:
Consider a loan of ₹10 lakh at 10% interest per annum for 20 years. If it is repaid in quarterly instalments:
Rate = 10%/4 per quarter
Npr = 20X4
EMI calculation in excel will be:
= PMT(10%/4, 20*4, 10,00,000)
If you do not have access to MS Excel, worry not! You can still calculate the EMI by using a calculator or doing some math yourself. The standard formula for calculating the EMI due is:
EMI = [P x R x (1+R)^N]/[(1+R)^N-1]
Where P is the loan amount or principal, R is the interest rate per period, and N is the number of periodic installments.
Just like in the PMT formula, you must ensure that the units for rate and EMI period are the same. For example, if you are calculating monthly EMI and the interest rate charged is 10% per annum, you should use [10/(12X100)] as the R in the formula. EMI calculation formula will give you the same result as the PMT function, as the function uses the same calculation in the background.
It is important to remember that these calculations are based on a flat-rate being charged for the duration of the loan. Further, any other fees that may need to be paid along with the Principal repayment and Interest payment are not included in the results.
Most banks and financial institutions use a mathematical formula to calculate personal loan EMI. This will depend on your personal loan amount, tenure of the loan and the interest rate. The process of calculating and recalculating the EMI that would suit your repayment capacity can be quite tedious and time-consuming. Here is when you can use an online personal loan EMI calculator to assist you in the process. You can use the EMI calculator to reach an amount which you can easily pay back without causing a strain on your finances.
The Equated Monthly Installment, or EMI, is a set sum of money that a borrower pays each month to repay a debt. The amount of EMI is determined by several factors, including:
1. Loan amount: The greater the loan amount, the more the EMI.
2. Interest rate: A higher interest rate leads to a higher monthly installment.
3. Loan term: A longer loan tenure lowers EMI, whilst a shorter loan tenure raises it.
4. Down payment: A bigger down payment reduces the loan amount and, as a result, the EMI.
5. Credit score: A higher credit score might lead to a cheaper interest rate and, as a result, a lower EMI.
6. Income: A higher income can lead to a larger loan amount and, consequently, a higher EMI.
Determining your EMI before taking out a loan is critical since it allows you to organise your finances and make informed decisions. Here are some of the benefits of calculating your EMI:
To calculate EMI, many people turn to formulae and online calculators. The simplest way to calculate how much monthly payment you owe to your lender is to do it through Excel sheets. You can use the PMT function or the monthly payment for a loan.
To make it even easier, you may simply visit the online website of an EMI calculator that takes in parameters like your income, interest rate, tenure, and line of work. If you talk about SMFG India Credit’s calculator, you can drag and drop the option given and find out the dynamic results of the EMI obligation.
Calculating loan EMI in Excel is a straightforward process, and it involves using the PMT function. Here are the steps to follow:
This will be even more straightforward with an online calculator to do the calculations for you.
An important factor to understand is that when you are paying your EMI you are repaying a part of the main personal loan amount due, also known as the principal, and also paying the interest due on the loan amount. Personal loan EMIs are the monthly repayment you make to repay the loan over the tenure of the loan. Usually, when you start making EMI payments, you contribute more to interest as compared to the principal. However, as you keep getting closer to the end tenure of the loan, your EMIs contribute more to the principal amount than interest payments
As a rule of thumb, market experts advise that your EMI amount for any loan, including a personal loan should not be more than 40% of your monthly income. This is because most people have a relatively fixed income every month and have other expenses and financial obligations to account for. Additionally, there is always unpredictability about income if you are a self-employed businessman and unpredictability about losing your job or getting a salary cut if you are a salaried individual. Hence, being on the safer side and ensuring that your EMI payments don’t exceed 40% of your monthly income is the financially prudent decision to take.
One of the key factors that influence the amount of EMI you pay every month is the rate of interest on your personal loan. The interest rate that you will be charged depends on a range of factors including your income, credit history, amount being borrowed, age amongst several others. Your credit history is one of the most important factors influencing the amount. Your credit history is mainly influenced by your repayment of past or current loans and repayment of your credit card bills. Typically, lenders and banking institutions will offer more lucrative personal loan interest rates to customers they perceive as being low credit risk - that is those who have repaid their previous loans and bills on time.
Must Read: How to Apply for a Personal Loan Online
Hence, when you are calculating your personal loan EMI ensure you are strategic and take into consideration the impact that this will have on your monthly and overall financial budget. Your repayment capacity is greatly influenced by your other fixed monthly expenses and you should take those into consideration before making your decision.
The Excel formula for EMI calculation is =PMT(rate, nper, pv) where rate is the interest rate per period, nper is the number of periods, and pv is the present value or loan amount. You can do this manually over any excel sheet that you open on your laptop.
To calculate monthly interest on a loan in Excel, use the "PMT" function. The formula is "=PMT(interest rate/12, number of payments, loan amount)". This will give you the monthly payment, which includes principal and interest. To calculate the interest only, subtract the principal from the total payment.
The Excel formula for EMI calculation is =PMT(rate, nper, pv) where rate is the interest rate per period, nper is the number of periods, and pv is the present value or loan amount. This calculates the monthly payment of the loans to be made.
The EMI (Equated Monthly Installment) on a personal loan is calculated based on the loan amount, the interest rate, and the loan tenure. The formula used is (P x R x (1+R)^N) / ((1+R)^N-1), where P is the loan amount, R is the monthly interest rate, and N is the number of months.
To calculate EMI using an EMI calculator:
The calculator will show you the EMI amount.
The two methods of EMI (Equated Monthly Installment) are the Flat Interest Rate method and the Reducing Balance Method. In the Flat Interest Rate method, the interest is calculated on the entire loan amount throughout the loan tenure. In the Reducing Balance Method, the interest is calculated on the outstanding balance after each payment.
To calculate the monthly interest rate, divide the annual interest rate by 12 (the number of months in a year). For example, if the annual interest rate is 6%, the monthly interest rate would be 0.5% (6% divided by 12). The formula to calculate the monthly interest rate is:
Monthly interest rate = (Annual interest rate / 12)
Where the interest rate is expressed as a decimal.
The benefits of using an EMI calculator include:
No, prepayment does not reduce the EMI (Equated Monthly Installment) amount. However, prepayment reduces the outstanding loan amount and the interest payable on it. This results in either a reduction in the loan tenure or a reduction in the total interest payable over the loan tenure, or both.
It depends on the terms and conditions of the loan agreement. Some lenders may offer an option to pause EMI payments for a few months, while others may not. It's best to check with your lender and understand the terms and conditions of your loan agreement regarding pausing or deferring EMI payments.
*Terms and conditions apply
**Subject to foreclosure charges. Terms and conditions applicable.
Was this helpful?
*Terms and Conditions apply. Loans are disbursed at the discretion of SMFG India Credit.