EMI Calculator
Find the monthly EMI for a home, car, personal or education loan, see how much of it is interest, and get the full repayment schedule month by month, grouped by financial year for your tax papers.
Page updated
Estimates only. These results are for general information and are not financial, investment or tax advice. Check important figures with your bank, the official source or a qualified adviser before you decide. Read the disclaimer.
How to Use
- Pick the loan type, or just enter your own figures.
- Enter the loan amount, the yearly interest rate and the tenure.
- Set the month of your first EMI so the schedule shows real dates.
- Read your EMI and total interest, then open any year in the schedule to see each month.
- Download the schedule as CSV or PDF, or copy a link to these numbers.
Limitations
- Interest is worked out monthly on the reducing balance. Lenders that charge daily interest, or broken-period interest before the first EMI, can differ by a few rupees.
- Processing fees, insurance and GST on fees are not included. Use the Loan Comparison Calculator to compare offers with fees.
- To see the effect of prepayments or rate changes, use the Home Loan Prepayment Calculator.
Frequently Asked Questions
How is the EMI calculated?
With the standard reducing-balance formula P × r × (1 + r)^n ÷ ((1 + r)^n − 1), where P is the loan amount, r the monthly interest rate and n the number of months. It is the same formula as Excel's PMT and the one banks use.
Why is my bank's EMI a rupee or two different?
Banks round the EMI to the rupee in different ways (nearest or up), and some charge interest by the day. The final EMI is then adjusted to close the loan, so the total paid stays the same within a few rupees.
Does a longer tenure cost more?
Yes. A longer tenure lowers the EMI but you pay interest for more years, so the total interest rises, often sharply. Compare the total interest figure as you change the tenure.
Why group the schedule by financial year?
Home-loan tax benefits are claimed per financial year (April to March). Under the old tax regime, the principal repaid can count towards Section 80C and the interest towards Section 24(b), so the yearly totals are the figures you need.
Are the numbers I enter saved or sent anywhere?
No. Everything is calculated in your browser and nothing is stored. A link to your numbers is only created if you click Copy link.
How do I calculate EMI in Excel?
Use =PMT(rate/12, months, -loan). For ₹10 lakh at 9% for 20 years, =PMT(9%/12, 240, -1000000) gives 8,997, the same EMI as this calculator.