The EMI formula
EMI = P × r × (1 + r)ⁿ ÷ [(1 + r)ⁿ − 1]
- P = loan amount
- r = monthly rate = annual rate ÷ 12 ÷ 100
- n = number of monthly instalments
Working it out by hand
৳5 lakh, 12% a year, 60 months:
- Monthly rate r = 12 ÷ 12 ÷ 100 = 0.01.
- (1 + r)ⁿ = (1.01)⁶⁰ ≈ 1.8167.
- EMI = 5,00,000 × 0.01 × 1.8167 ÷ (1.8167 − 1) ≈ ৳11,122.
- Month 1: interest = 5,00,000 × 0.01 = ৳5,000. Principal repaid = 11,122 − 5,000 = ৳6,122. Balance ≈ ৳4,93,878.
- Month 2: interest = 4,93,878 × 0.01 ≈ ৳4,939. Principal repaid ≈ ৳6,183. Balance ≈ ৳4,87,694.
- This goes on for 60 months. The calculator shows every instalment equal and, in the last month, squares away the tiny rounding remainder so the loan ends at zero. Total interest = total paid − loan = (60 × 11,122.22) − 5,00,000 ≈ ৳1,67,333.
Examples
Personal loan: ৳5 lakh at 12% for 5 years (60 instalments) → EMI ৳11,122. The first instalment is ৳5,000 interest and ৳6,122 principal. Total interest ৳1,67,333.
Home loan, shorter tenure: ৳30 lakh at 9%.
| Tenure | EMI | Total interest |
|---|---|---|
| 20 years | ৳26,992 | ৳34,78,027 |
| 15 years | ৳30,428 | ৳24,77,040 |
Paying ৳3,436 more a month and finishing 5 years earlier saves about ৳10 lakh in interest.
3, 5 or 7 years? ৳10 lakh at 12%.
| Tenure | EMI | Total interest |
|---|---|---|
| 3 years | ৳33,214 | ৳1,95,715 |
| 5 years | ৳22,244 | ৳3,34,667 |
| 7 years | ৳17,653 | ৳4,82,830 |
Moving from 3 to 7 years lowers the EMI sharply but adds about ৳2.87 lakh of interest.
How the first instalment splits on a big home loan: ৳50 lakh at 10% for 20 years. The EMI is ৳48,251. In the first instalment ৳41,667 is interest and only ৳6,584 repays principal (about 14%). After year 1 the balance has only fallen from ৳50 lakh to ৳49,17,263. Over the whole term the interest comes to ৳65,80,260, more than the loan itself, for a total payment of ৳1,15,80,260.
Common mistakes and tips
- Don’t enter a flat rate here. A “10% flat” quote is not the same as a 10% reducing rate: on ৳1 lakh for a year, 10% flat costs ৳10,000 interest and 10% reducing ৳5,499. To compare two quotes use the flat vs reducing rate calculator.
- Check the tenure unit. Typing “5” with Months selected calculates 5 instalments, not 5 years. 5 years = 60 months.
- The rate is annual. 1% a month means 12% a year here, because the monthly rate is the annual rate ÷ 12.
- Don’t pick a long tenure just for the low EMI. Going from 3 to 7 years on ৳10 lakh at 12% cuts the EMI but adds about ৳2.87 lakh of interest. Use “Compare with another plan” to see two tenures side by side.
- Add fees separately. Processing fee, insurance and documentation charges are not in the EMI. Get the bank’s written list and add the real costs.
- Spare cash changes the picture. For the interest and months saved by part or full prepayment, use the loan prepayment calculator.
- Eligibility is a different question. Once you know the EMI, the home loan eligibility calculator compares it with your income.
What to know in Bangladesh
- Rates are market-based: they vary by bank and loan type, so compare several offers.
- Watch for flat rates: many NGOs and microfinance lenders quote flat rates, which cost roughly twice as much as the same reducing rate. Compare two quotes with the flat vs reducing rate calculator.
- Prepaying: if you get extra cash, the loan prepayment calculator shows how much interest and how many months you save.
- Card instalments: for shopping put on a credit card instalment plan, the credit card EMI calculator includes the processing fee in the real cost.
- Extra costs: processing fees, documentation, insurance and prepayment fees are not in the EMI. Ask the bank for a written list.
- Islamic banks: use profit or rent structures (e.g. HPSM) instead of interest; the monthly figure is often similar but the method differs.
More: what is inside each instalment
Each month the bank first takes that month’s interest on the outstanding balance; the rest of the instalment repays principal. The chart above shows how the split changes year by year. A common rule of thumb is to keep all loan instalments below one-third of monthly income.