A friend of mine took a ₹3 lakh personal loan for a wedding in the family. Nice, quick approval, money in the account the same day. Then the first EMI hit and she told me, “I didn’t think it would be this much.” She had never worked it out beforehand. She just trusted that it would “be fine.”
It was fine. Eventually. But she spent about six months cutting down on everything else to make room for it.
You can avoid that surprise with five minutes and a basic calculator.
First, what you’re actually calculating
An EMI is the fixed amount you pay your lender every month until the loan is gone. Part of it pays the interest, part of it pays back what you borrowed.
Three things set the amount: the loan size, the interest rate, and how many months you take to repay. That’s it. Everything else is detailed.
The formula (it looks worse than it is)
EMI = P × r × (1 + r)ⁿ ÷ [(1 + r)ⁿ − 1]
P is the amount you borrow. n is the number of months. And r is the monthly interest rate, which is where most people slip up. If the lender says 14% a year, you divide by 12 to get the monthly rate, so r is about 0.011667. Not 0.14.
Let’s use real numbers. Say you borrow ₹3,00,000 at 14% for 2 years (24 months).
- P = 3,00,000
- r = 0.011667
- n = 24
Work through it and the EMI comes to roughly ₹14,400. You’ll repay about ₹3,45,700 in total, so the interest is around ₹45,700.
That’s your answer before anyone has called you, pitched you, or asked for a document.
Where your first EMI actually goes
Here’s something that surprised me when I first saw it. In the first month of that loan, the interest portion is 3,00,000 × 0.011667, which is about ₹3,500. The rest, around ₹10,900, reduces your loan.
Next month the interest is calculated on a slightly smaller balance, so a little less goes to interest and a little more goes to the principal. The shift is slow but steady. By the end, almost your entire EMI is chipping away at the loan itself.
Why does this matter? Because if you want to prepay or close early, doing it in the first year saves you much more interest than doing it in the last. That’s when the interest is heaviest.
Don’t want to do the formula? Use a spreadsheet
Open Excel or Google Sheets and type:
=PMT(14%/12, 24, -300000)
Press enter. You get the EMI. Change the rate or the months and it updates instantly, which is the real use of it. You can try ten combinations in a minute.
Online personal loan EMI calculator do the same thing, and it is fine for a quick check. I’d just say, do the formula by hand once. After that you’ll understand what the calculator is telling you instead of treating it like a black box.
Play with tenure, but know what it costs
Here’s the same ₹3 lakh at 14%, with only the time changed:
| Tenure | EMI | Total interest |
| 2 years | ₹14,400 | ₹45,700 |
| 4 years | ₹8,200 | ₹93,600 |
Double the time and the EMI nearly halves. Lovely. But you pay roughly twice the interest.
Banks like to push long tenures because the monthly figure looks small and manageable. I’d say pick the shortest tenure you can handle comfortably, not the longest one the lender will give you.
The interest rate matters more than it looks
A few percentage points sounds like nothing. It isn’t.
Take ₹5 lakh over 3 years. At 11%, the EMI is about ₹16,370. At 16%, it’s about ₹17,580. That’s only ₹1,200 a month more, which doesn’t sound dramatic. But over 36 months it adds up to roughly ₹43,000. For nothing.
So don’t accept the first offer. Check two or three lenders, and if your credit score is decent, ask for a lower rate. Banks do negotiate, especially for salaried customers with a good record.
What the formula won’t tell you
The EMI calculation covers principal and interest. Real loans have other costs hiding around them.
- Processing fee. Usually 1% to 3% of the loan, plus GST. On ₹5 lakh, that could be ₹10,000 or more.
- Foreclosure charges. Some lenders charge a penalty if you repay early. Ask before signing.
- Late fees. Small each time, painful in total, and bad for your credit score too.
- Bundled insurance. Occasionally added without much explanation. Read the sanction letter.
Also check whether the quoted rate is “flat” or “reducing balance.” A flat rate charges interest on the full original amount for the whole period, so a flat 9% costs far more than a reducing 9%. When a rate looks suspiciously low, that’s often why.
A good habit: ask the lender for the total amount you’ll repay over the full tenure, fees included. Then compare that number across offers. It’s the cleanest way to see which loan is actually cheaper.
Now the important question: can you afford it?
Getting the EMI figure is only half the job. The other half is being honest about your own money.
Banks usually allow all your EMIs combined to take up to 40% to 50% of your monthly income. That’s their comfort level, not necessarily yours. I’d aim for 30% or less if you can.
Try this. Write down your monthly take-home pay. Subtract rent, food, bills, school fees, any existing EMIs, and a little buffer for things that go wrong. What remains is what you can really give to a new loan.
If the new EMI eats most of that, wait or borrow less. Life has a way of adding expenses right after you’ve signed.
One last thing before you apply
Run the numbers at the amount you actually need, not the amount you’re approved for. Banks will often sanction more than you asked, and it’s tempting. Don’t. Extra borrowed money doesn’t feel like debt on day one. It feels like debt every month after that.
So work out the EMI, add the fees, compare two or three lenders, and check it against your budget. If it still feels comfortable, go ahead and apply. If it doesn’t, you’ve just saved yourself a very long few years.
Add Business Connect magazine to your Google News feed
