EMI / Loan Calculator
Work out the monthly instalment (EMI) for a reducing-balance or flat-rate loan, the total interest and the full month-by-month schedule, with CSV download.
Loan instalment schedule
Principal vs interest
Paid each year
Tap or hover a bar to see that year.
How to use
- 1Choose how the lender charges interest: “Reducing balance” (banks, home and car loans) or “Flat rate” (many consumer, motorcycle and microfinance loans). Ask the lender if you're not sure.
- 2Enter the loan amount, the interest rate per year and the tenure in years or months. The amount is shown in words so you can check the zeros.
- 3Read the monthly instalment (EMI), total interest and total payable, and see how much of what you pay is interest in the charts.
- 4Scroll the schedule month by month, or switch to “Yearly”. Download it as CSV for Excel, or press “Print / PDF” to save or print it.
FAQ
How is the EMI calculated?
On a reducing balance, EMI = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), where P is the loan amount, r is the yearly rate ÷ 12 ÷ 100 and n is the number of months. For example, ৳5,00,000 at 9% for 60 months gives an EMI of ৳10,379.18. Each month the interest is worked out on the balance still owed, and the rest of the EMI repays the loan.
What is the difference between a flat rate and a reducing balance?
With a flat rate, interest is charged on the full loan amount for the whole term: ৳1,00,000 at 10% flat for one year costs ৳10,000 interest, even though you repay part of the loan every month. On a reducing balance, interest is charged only on what you still owe, so the same 10% costs only about ৳5,500. A flat 10% for a year is about 18% on a reducing balance; the calculator shows this comparison for your own numbers.
Why is the last instalment slightly different?
Each amount in the schedule is rounded to paisa. The last instalment absorbs those few paisa so that the loan ends at exactly zero. Banks do the same, and some round the EMI to whole taka, so their figures can differ by a few taka.
Does this include processing fees, insurance or VAT?
No. It shows the instalment for the loan amount and interest rate you enter. Lenders may add a processing fee, insurance, excise duty or late-payment charges, and some charge weekly instead of monthly instalments. Ask for the full cost in writing and compare it with this schedule.
Can I open the schedule in Excel?
Yes. Press “CSV” to download the full month-by-month schedule. It opens in Excel, Google Sheets or LibreOffice, with plain numbers you can add up or chart.
Is my loan information sent anywhere?
No. Everything is calculated in your browser. The last amount, rate and tenure you used are remembered only on this device to save typing next time.