Use the MS-Excel formula “PMT” to calculate your loan EMI using an Excel sheet. The complete formula syntax for EMI calculation for Excel is:
PMT (rate, nper, pv)
Where,
rate = Personal loan interest rate (in percentage)
nper = Loan tenure in months, i.e. number of EMIs payable
pv = Loan principal (present value)
While the EMI calculation results will be the same whether you use the online EMI calculator or the Excel formula, the benefit of using the Excel formula is that you can use it offline as well.
Let us check the EMI for Ravi by using the PMT formula.
The rate used should be the monthly interest rate, that is, 8%/12= 0.0066
The number of periods represents the EMIs throughout the tenure.
=PMT(0.0066, 36, 100000)= 3,129.94
When you plan on getting a loan you look for lenders that offer flexible repayment tenure on loans and offer instant funds. Apply for a Bajaj Finserv Personal Loan at Finserv MARKETS. You can avail a Personal Loan at attractive interest rates starting from 12.99% per annum. The online application process for loans is quite simple and you get flexible loan repayment tenure of up to 12 to 60 months, where you can enjoy the freedom of choosing your loan tenure. To calculate your EMIs, you can take the help of a Bajaj Finserv Personal Loan EMI calculator that gives you an accurate monthly outflow of the loan amount. Download the Finserv MARKETS app and avail personalized pre-approved offers. You can also check your CIBIL score before applying for a Bajaj Finserv Personal loan at Finserv MARKETS.
“Finserv MARKETS, a subsidiary of Bajaj Finserv, is a one-stop digital marketplace that has been created for consumers on the go. It offers 500+ financial and lifestyle products, all at one place. At Finserv MARKETS, we understand that every individual is different. And that’s why we have invested in creating a proposition – Offers You Value. A value proposition that ensures you get offers which are tailor made for you. We also offer an amazing product range and unique set of online offers across Loans, Insurance, Investment, Payments and an exclusive EMI store. Be it in helping you achieve your financial life goals or offering you the latest gadgets, we strive to offer what you are looking for. From simple and fast loan application processes to seamless and hassle-free claim-settlements, from no cost EMIs to 4 hours product delivery, we work towards fulfilling all your personal and financial needs. What’s more! Now enjoy the same benefits in just one click with our Finserv MARKETS App.”