Loan EMI Calculator
Estimate Equated Monthly Installments, visualize principal vs. interest ratios, and generate yearly payoff rollups.
How monthly equated installments (EMI) are resolved
Equated Monthly Installment (EMI) represents the periodic payments required to close a loan at standard interest parameters. The index maps: EMI = P·r·(1+r)ⁿ / ((1+r)ⁿ − 1).
Use the sliders to adjust the principal and term, and read the yearly amortisation rollup directly. The CSV export holds every monthly row, written unformatted — no thousands separators and no currency symbol — because a grouped 1,234.56 splits across two columns in a spreadsheet and a currency prefix turns the whole column into text.
Overpaying shortens the term rather than the instalment, and that is where the saving comes from: interest accrues on the balance still outstanding, so clearing balance early removes every future month of interest it would have generated. That is also why the same lump sum saves noticeably more in year one than in year ten — it has more remaining interest to cancel.
One detail worth knowing when you compare this against a lender's own schedule: the final instalment is not exactly the EMI. Interest is rounded to the cent every month, so a few cents of drift accumulate over a long term and the last payment absorbs them — about a pound or two on a 20-year loan. Lenders do the same thing. The alternative is a schedule whose closing balance is -0.03 instead of zero.
Built and maintained by Meet Shah · Last updated
What this tool is used for
- Working out a monthly payment for a loan amount and term.
- Seeing how much of the first payment is interest rather than principal.
- Seeing how a rate change affects the payment.
- Checking an EMI figure a lender quoted against the stated rate and term.
- Working out the total cost of a loan over its life.
Frequently Asked Questions
- What is the EMI formula?
- EMI = P × r × (1+r)ⁿ / ((1+r)ⁿ − 1), where r is the MONTHLY rate and n the number of months. Using the annual rate directly is the classic error and inflates the payment enormously — the annual figure has to be divided by 12 first.
- Why is early repayment mostly interest?
- Because interest is charged on the outstanding balance, which is at its maximum at the start. The payment is constant, so the split shifts gradually — on a long loan the crossover where principal exceeds interest arrives well past the midpoint.
- How much does a prepayment save?
- More than its size, because every unit of principal removed also removes all future interest on it. A single extra payment a year typically cuts several years off a long-term loan, and the earlier it lands the larger the effect.
- Flat rate or reducing balance?
- A flat rate charges interest on the ORIGINAL principal for the whole term, which roughly doubles the effective rate compared with a reducing-balance loan at the same nominal number. Some consumer lenders still quote flat rates, and the comparison is not like for like.
- What does the EMI exclude?
- Processing fees, insurance bundled into the loan, and any prepayment penalty. The APR is meant to capture those and often does not capture all of them, so the total repayable figure is the number worth comparing between offers.
Common errors and gotchas
- Confusing the nominal rate with the effective one, which differ once compounding appears.
- Omitting fees and insurance, which are often a material part of the real cost.
- Assuming the rate is fixed when the product is variable.
- Mixing an annual rate with a monthly term count without converting.
- Treating the estimate as an offer, which only underwriting provides.