Personal Loan EMI Calculation – Formula, Examples and EXCEL

Every month, lakhs of Indians pay their personal loan EMIs without really understanding how that number was arrived at. You applied for a loan, the bank told you your EMI, and you just started paying. But do you know how much of that EMI is actually going towards your principal component? And how much is pure interest? And more importantly, do you know how much total interest you will end up paying over the full tenure?

Understanding personal loan EMI calculation is not just a math exercise. It helps you compare loan offers, negotiate better, and make smarter decisions before you sign on the dotted line.

We will understand everything about Personal Loan in this article along with Calculation examples, excel formula and lot more

Table of Contents

Personal Loan EMI Calculator Video

Watch more Videos on YouTube Channel

What is Personal Loan EMI?

EMI stands for Equated Monthly Instalment. It is the fixed amount you pay every month to repay your personal loan. This amount remains the same throughout your loan tenure, but what changes every month is how much of it goes toward interest and how much goes toward the principal component.

In the initial months, a larger portion of your EMI goes toward interest
As months pass, the interest component decreases and the principal component increases
By the last few EMIs, almost the entire amount goes toward clearing your principal

This is the same principle I have explained in home loan EMI calculation as well — and it applies identically to personal loans.

Personal Loan EMI Calculation Formula

The formula used to calculate personal loan EMI is:

EMI = P × r × (1 + r)^n / [(1 + r)^n – 1]

Where:

P = Principal loan amount
r = Monthly interest rate (Annual interest rate divided by 12, divided by 100)
n = Loan tenure in months

This is the same formula used in the PMT function in Excel. If you want to calculate your personal loan EMI in Excel, use:

= PMT(r, n, -P)

Where r is the monthly interest rate, n is the number of months, and P is the loan amount.

To make it easy for you, I have created a Personal Loan EMI Calculator in Excel with required formula. You can download the excel calculator using below button:

Personal Loan EMI Calculation Example

Let me walk you through a practical example that most borrowers can relate to.

Assumption: Loan Amount = Rs. 5,00,000 | Interest Rate = 14% per year | Tenure = 3 years (36 months)

Monthly interest rate = 14 / 12 / 100 = 0.01167

EMI = 5,00,000 × 0.01167 × (1.01167)^36 / [(1.01167)^36 – 1]

EMI = Rs. 17,090 per month (approx.)


Loan Amount	Rs. 5,00,000
Interest Rate	14% per year
Tenure	36 months
Monthly EMI	Rs. 17,090
Total Amount Paid	Rs. 6,15,197
Total Interest Paid	Rs. 1,15,197

You borrowed Rs. 5 Lakh but ended up paying Rs. 6.15 Lakh. That Rs. 1.15 Lakh is the cost of borrowing (paid as interest amount along with EMIs) — and most people never calculate this before taking a loan.

You can also use the Online Personal Loan EMI Calculator to quickly calculate above numbers:

Personal Loan EMI for Different Loan Amounts

Here is a quick reference table for EMI at 14% interest rate across different loan amounts and tenures:

Loan Amount	1 Year EMI	2 Year EMI	3 Year EMI	5 Year EMI
Rs. 1,00,000	Rs. 8,979	Rs. 4,801	Rs. 3,418	Rs. 2,327
Rs. 2,00,000	Rs. 17,957	Rs. 9,603	Rs. 6,835	Rs. 4,654
Rs. 3,00,000	Rs. 26,936	Rs. 14,404	Rs. 10,253	Rs. 6,981
Rs. 5,00,000	Rs. 44,893	Rs. 24,006	Rs. 17,088	Rs. 11,636
Rs. 10,00,000	Rs. 89,786	Rs. 48,013	Rs. 34,178	Rs. 23,268

Below are few insights based on the above summary of EMI Calculation:

Shorter tenure = higher EMI but much lower total interest paid
Longer tenure = lower EMI but significantly higher total interest paid
Always calculate total interest paid, not just monthly EMI, before choosing tenure

ALSO READ: 7 Home Loan Mistakes your Should Avoid

How Interest and Principal Split in Each EMI

This is the part most borrowers never look at — the amortisation schedule, which is also included in above excel calculator as well. Let me show you the first few months and last few months for the Rs. 5 Lakh example above.

First 3 months:

Month	EMI	Interest Component	Principal Component	Balance Remaining
1	Rs. 17,090	Rs. 5,833	Rs. 11,257	Rs. 4,88,743
2	Rs. 17,090	Rs. 5,702	Rs. 11,388	Rs. 4,77,355
3	Rs. 17,090	Rs. 5,570	Rs. 11,520	Rs. 4,65,835

Last 3 months:

Month	EMI	Interest Component	Principal Component	Balance Remaining
34	Rs. 17,090	Rs. 588	Rs. 16,502	Rs. 33,904
35	Rs. 17,090	Rs. 396	Rs. 16,694	Rs. 17,210
36	Rs. 17,090	Rs. 201	Rs. 16,889	Rs. 0

In month 1, Rs. 5,833 out of Rs. 17,090 was pure interest — that is 34% of your EMI going to the bank, not toward your loan. By month 36, only Rs. 201 is interest. This pattern is why prepaying early saves much more interest compared to prepaying later.

ALSO READ: Home Loan Prepayment to Save Interest Amount

Factors That Affect Personal Loan EMI

Two things control your EMI — interest rate and tenure. Your loan amount is usually fixed based on your need, but these two factors are where you have some control.

Interest Rate:

Higher the interest rate, higher the EMI and higher the total interest paid
Personal loan interest rates in India typically range from 10.5% to 24% depending on your credit score, income, employer, and lender
A difference of just 2% in interest rate can save you thousands over the full tenure
Always compare rates from at least 3 to 4 lenders before finalizing

Tenure:

Longer tenure reduces your monthly EMI but increases total interest paid significantly
Shorter tenure increases EMI but saves a large amount in total interest
Choose the shortest tenure where the EMI remains comfortably within 30% to 40% of your monthly take-home salary, so you can cover your monthly expenses as well

Let me show you what a difference tenure makes on the same Rs. 5 Lakh loan at 14%:

Tenure	Monthly EMI	Total Interest Paid
1 Year	Rs. 44,893	Rs. 38,716
2 Years	Rs. 24,006	Rs. 76,144
3 Years	Rs. 17,090	Rs. 1,15,240
4 Years	Rs. 13,634	Rs. 1,54,432
5 Years	Rs. 11,636	Rs. 1,98,160

Choosing 5 years over 1 year saves you Rs. 33,000 per month in EMI — but costs you Rs. 1,59,444 extra in total interest. This is a trade-off only you can decide based on your cash flow and financial situation.

Personal Loan EMI Calculation for Different Interest Rates

Here is how much EMI and total interest changes on a Rs. 5 Lakh loan for 3 years at different interest rates:

Interest Rate	Monthly EMI	Total Interest Paid
10.5%	Rs. 16,248	Rs. 84,928
12%	Rs. 16,607	Rs. 97,852
14%	Rs. 17,090	Rs. 1,15,240
16%	Rs. 17,582	Rs. 1,32,952
18%	Rs. 18,083	Rs. 1,50,988
20%	Rs. 18,595	Rs. 1,69,420

Getting your interest rate reduced from 18% to 14% on a Rs. 5 Lakh loan saves you Rs. 35,748 in total interest over 3 years. This is why your credit score matters — a higher CIBIL score directly translates into a lower interest rate offer from lenders.

How to Calculate Personal Loan EMI in Excel

If you want to calculate your personal loan EMI yourself in Excel, here is how:

Open a new Excel sheet
Enter your loan amount in cell A1 (example: 500000)
Enter your annual interest rate in cell A2 (example: 14)
Enter your tenure in months in cell A3 (example: 36)
In cell A4, enter the formula: =PMT(A2/12/100, A3, -A1)
A4 will show your monthly EMI

PMT function takes 3 inputs — monthly interest rate (annual rate divided by 12 divided by 100), number of months, and the negative of your principal amount. The negative sign is used because the loan amount is a cash inflow and EMI is a cash outflow.

You can also download my Personal Loan Excel Calculator for a full amortization schedule showing month-by-month principal and interest breakup.

How to Reduce Personal Loan EMI

There are 3 ways to reduce your personal loan EMI:

1. Negotiate a Lower Interest Rate

Your CIBIL score is the biggest factor — a score above 750 gives you negotiating power
Salaried employees at large companies get preferential rates from most banks
Check pre-approved loan offers from your existing bank — these usually come at lower rates
Compare offers from NBFCs and digital lenders who sometimes offer lower rates than traditional banks

2. Choose a Longer Tenure

This directly reduces your monthly EMI
But remember — you pay significantly more total interest as shown in the table above
Only choose longer tenure if your cash flow genuinely requires it, not just to get a lower EMI number

3. Make Partial Prepayments

Most personal loans allow prepayment after 6 to 12 EMIs
Making a partial prepayment reduces your outstanding principal
After prepayment, ask your lender to reduce tenure rather than EMI — this saves maximum interest
Even one extra EMI paid per year can significantly reduce your total interest burden

Home Loan Prepayment Examples Video

Personal Loan EMI vs Home Loan EMI – Key Differences

	Personal Loan	Home Loan
Interest Rate	10.5% – 24%	8.5% – 10.5%
Typical Tenure	1 – 5 years	10 – 30 years
Collateral	Not required	Property as security
Tax Benefit	None	Yes – Section 24 and 80C
Processing Time	Fast (hours to days)	Slower (1–2 weeks)
Prepayment Charges	Usually 2%–5% of outstanding	Usually nil for floating rate

Personal loans cost more than home loans because they are unsecured — the bank takes on higher risk with no collateral. This is why using a personal loan to fund long-term goals is expensive. It makes sense only for short-term needs where you can repay within 2 to 3 years.

Things to Check Before Taking a Personal Loan

Processing fee — Usually 1% to 3% of the loan amount. This increases your effective cost of borrowing
Prepayment charges — Check if your lender charges a penalty for early repayment and after how many EMIs prepayment is allowed
Effective interest rate vs flat rate — Some lenders advertise flat rate interest which looks lower but is actually much higher in effective terms. Always ask for the reducing balance rate (also called effective rate or APR)
Insurance bundling — Some lenders push loan protection insurance along with the personal loan. This is optional — do not let it be added without your consent
Foreclosure charges — If you plan to close the loan early, check the foreclosure charges before taking the loan

Frequently Asked Questions

What is the EMI for a Rs. 1 Lakh personal loan?

At 14% interest for 2 years, the EMI is approximately Rs. 4,801 per month. For 1 year, it is approximately Rs. 8,979 per month. Use the calculator above to calculate for your exact interest rate and tenure.

Does prepayment reduce EMI or tenure?

Your lender gives you the choice. Always choose to reduce tenure rather than EMI if your goal is to save maximum interest. Reducing tenure saves more interest compared to reducing EMI.

What CIBIL score is needed for a personal loan?

Most banks and NBFCs require a minimum CIBIL score of 700 to 750 for personal loan approval. A score above 750 increases your chances of approval and helps you get a lower interest rate.

Is personal loan interest tax deductible?

Generally no — personal loan interest does not qualify for any tax deduction. The only exception is if you use the personal loan amount specifically for home renovation or purchase, in which case the interest may be claimed under Section 24(b) of the Income Tax Act.

What is the maximum tenure for a personal loan in India?

Most lenders offer personal loans up to 5 years tenure. Some lenders offer up to 7 years for higher loan amounts, but longer tenure means significantly more total interest paid.

Conclusion

Before taking a personal loan, always calculate the total interest you will pay over the full tenure — not just the monthly EMI. A small difference in interest rate or tenure can save or cost you tens of thousands of rupees. Use the personal loan EMI calculator above to calculate your exact EMI, total interest, and full amortization schedule before finalizing your loan.

Some more Reading:

Save Home Loan Interest Amount!

Use Home Loan Excel Calculator that will help you to Save Interest Amount on Home Loan EMI.
Click below button to download Home Loan EMI and Prepayment Calculator in Excel:

Watch how Home Loan Calculator in Excel Works

Income Tax Calculator App – FinCalC

For Income Tax Calculation on your mobile device, you can Download my Android App “FinCalC” which I have developed for you to make your income tax calculation easy.

What you can do with this mobile App?

Calculate Income Tax for FY 2025-26 and previous FY 2024-25
Enter estimated Investments to check income tax with Old and New Tax Regime
Save income tax details and track regularly
Know how much to invest more to save income tax
More calculators including PPF, SIP returns, Savings account interest and lot more

Download Income Tax Calculator APP from play store

Use Popular Calculators:

I’d love to hear from you if you have any queries about Personal Finance and Money Management.

JOIN Telegram Group and stay updated with latest Personal Finance News and Topics.

Download our Free Android App – FinCalC to Calculate Income Tax and Interest on various small Saving Schemes in India including PPF, NSC, SIP and lot more.

Follow the Blog and Subscribe to YouTube Channel to stay updated about Personal Finance and Money Management topics.