how to calculate EMI on a personal loan?

equated monthly instalment: that is what EMI stands for. a fixed amount paid every month until the loan gets fully repaid. each payment covers both the principal borrowed and the interest charged.

early in the loan term, interest takes up a large part of each EMI. as months pass, the interest portion shrinks. the principal portion grows. by the final months, almost the entire payment goes toward the principal.

this structure follows the reducing-balance method. standard for personal loans across India. the EMI stays constant throughout, giving borrowers predictable monthly outgo.

the EMI formula

here is the formula lenders use:

EMI = [P x R x (1+R)^N] / [(1+R)^N-1]

the variables:

• P = Principal loan amount
• R = Monthly interest rate (annual rate ÷ 12 ÷ 100)
• N = Loan tenure in months

working through an example

take a ₹5 lakh loan at 12% per annum for 24 months:

• P = ₹5,00,000
• R = 12% ÷ 12 ÷ 100 = 0.01
• N = 24 months

EMI = [5,00,000 x 0.01 x (1+0.01)^24] / [(1+0.01)^24 to 1]

EMI = ₹23,537

that is the monthly payment required to clear the loan in 24 months.

what changes the EMI amount

the principal

borrow more, pay more each month. simple math. if the rate and tenure stay fixed, a higher principal means a higher EMI. borrow only what is genuinely needed.

the interest rate

rates vary widely. Bajaj Finance charges between 10% and 30% per annum depending on the borrower's profile. a lower rate means lower equated monthly instalments (EMIs). a strong credit score helps secure better rates.

the tenure

this one cuts both ways:

real numbers: A ₹10 lakh loan at 12% over 3 years gives an EMI of roughly ₹33,214. stretch it to 8 years, and the EMI drops to about ₹16,253. monthly outgo gets cut in half. but total interest paid over the loan term climbs significantly.

credit score

a high score can unlock lower rates. lower rates mean lower EMIs. lenders see high scores as signs of reliability.

income and foire

financial advisors suggest keeping total EMIs under 40 to 50% of monthly income. this leaves room for daily expenses, savings, and unexpected costs.

using online EMI calculators

bank websites and financial portals offer free EMI calculators. the process takes seconds:

1. type in the loan amount
2. enter the interest rate
3. pick the tenure

the tool instantly shows the EMI, total interest, and total repayment. borrowers can tweak the numbers, change the amount, adjust the tenure, try different rates, until the EMI fits their budget.

fi Money's calculator lets users experiment with different combinations. free, fast, and accurate.

calculating EMI in excel

excel offers a built-in function called PMT. here is how to use it:

step 1: set up the sheet

create columns for:

• loan Amount
• interest Rate
• loan Tenure (in years)
• number of Monthly Instalments

step 2: find the monthly rate

divide the annual rate by 12. A 12% annual rate becomes 1% monthly: 0.01 in decimal.

step 3: count total payments

multiply years by 12. three years means 36 payments.

step 4: enter the pmt formula

in the cell where the EMI should appear, type:

=PMT(monthly rate, total payments, -loan amount)

example: =PMT(0.01, 36, -100000) gives the EMI for a ₹1 lakh loan at 12% over 3 years.

step 5: test different scenarios

change any variable: amount, rate, tenure and the PMT function updates automatically.

the amortisation schedule explained

an amortisation schedule shows the breakdown of every EMI: how much goes to interest and how much to principal each month. this gives borrowers a clear picture of their repayment journey.

bank of Baroda's calculator provides a sample schedule for a ₹5 lakh loan at 10.7% over 18 months:

interest drops month by month. principal rises. by month 18, the borrower is paying off mostly principal.

reducing balance vs flat rate: know the difference

most personal loans in India use the reducing-balance method. interest gets recalculated each month on the outstanding amount. both principal and interest decrease over time.

flat rate is different. interest gets calculated on the full principal for the entire tenure: even after the borrower has repaid part of it. this usually results in much higher total interest.

the reducing-balance method is the industry standard for personal loans. borrowers should always confirm which method the lender uses.

mistakes that cost money

choosing tenure only for the lowest EMI

longer tenure means lower monthly payments. but total interest paid over the loan term can be significantly higher. match tenure to actual repayment capacity, not just the lowest possible EMI.

overlooking the processing fee

A 1 to 3% processing fee on a ₹3 lakh loan adds ₹3,000 to 9,000 plus goods and services tax (GST). easy to miss when comparing rates.

ignoring existing obligations

EMIs should stay within 40 to 50% of monthly income. overestimating what can be afforded leads to financial stress.

manual calculation errors

doing the math by hand takes time and invites mistakes. online calculators or Excel's PMT function are faster and more reliable.

frequently asked questions

1. what is the formula for calculating EMI on a personal loan?

EMI = [P x R x (1+R)^N] / [(1+R)^N-1]. P is the principal, R is the monthly interest rate, and N is the tenure in months. A ₹5 lakh loan at 12% for 24 months gives an EMI of ₹23,537.

2. how does loan tenure impact the EMI amount?

longer tenures reduce the monthly EMI but increase total interest paid. A ₹10 lakh loan at 12% has an EMI of ₹33,214 over 3 years and ₹16,253 over 8 years. the choice depends on balancing affordability with total interest cost.

3. what is the ideal EMI-to-income ratio?

financial experts recommend keeping total EMIs within 40% to 50% of monthly income. this ensures enough room for daily expenses, savings, and unexpected costs.

4. how can I quickly calculate my personal loan EMI?

use an online EMI calculator on any bank website or financial portal. enter the loan amount, interest rate, and tenure: the calculator instantly shows the EMI, total interest, and total repayment. excel's PMT function is another fast option.

5. what is an amortisation schedule and why is it useful?

an amortisation schedule breaks down each EMI into interest and principal components month by month. it shows how interest decreases and principal increases over time. this helps borrowers track their repayment progress.