Tips, tutorials, and insights about online tools and calculations
To calculate EMI (Equated Monthly Instalment), use the loan amount, monthly interest rate and number of monthly payments. For a standard reducing-balance loan, the EMI formula is:
EMI Formula:
EMI = [P × r × (1 + r)n] / [(1 + r)n − 1]
Where:
You can calculate EMI manually, in Excel, or by using an online EMI calculator. This guide explains the formula with practical examples for home loans, personal loans, car loans and bike loans in India.
EMI stands for Equated Monthly Instalment. It is the regular monthly payment a borrower makes to repay a loan over an agreed period.
An EMI generally consists of two components:
For a fixed-rate reducing-balance loan with no additional charges, the EMI usually remains constant. However, the proportion of principal and interest changes over the repayment period.
Early payments typically contain a larger interest portion, while later payments contain a larger principal portion.
Actual loan payments may differ if the interest rate changes, the lender uses a different calculation convention, or fees and insurance are added.
The commonly used EMI calculation formula is:
EMI = [P × r × (1 + r)n] / [(1 + r)n − 1]
| Symbol | Meaning |
|---|---|
| P | Principal or loan amount |
| r | Monthly interest rate in decimal form |
| n | Total number of monthly instalments |
| EMI | Monthly repayment amount |
If your lender quotes an annual interest rate of 10%, convert it into a monthly decimal rate before using the formula.
Monthly rate = Annual rate ÷ 12 ÷ 100
r = 10 ÷ 12 ÷ 100
r = 0.0083333
Similarly, a five-year loan has:
n = 5 × 12 = 60 months
Important: The formula uses the monthly rate as a decimal, not the annual percentage directly. Confirm how your lender converts its quoted interest rate and applies interest.
Suppose you borrow ₹5,00,000 at an annual interest rate of 10% for 5 years.
| Loan Details | Value |
|---|---|
| Loan amount | ₹5,00,000 |
| Annual interest rate | 10% |
| Monthly interest rate | 0.10 ÷ 12 = 0.0083333 |
| Loan tenure | 5 years = 60 months |
Substitute the values into the EMI formula:
EMI = [500000 × 0.0083333 × (1.0083333)60] / [(1.0083333)60 − 1]
Estimated EMI: approximately ₹10,624 per month.
| Repayment Summary | Approximate Amount |
|---|---|
| Monthly EMI | ₹10,624 |
| Number of EMIs | 60 |
| Total repayment | ₹6,37,440 |
| Total interest | ₹1,37,440 |
These figures are estimates based on a constant interest rate and monthly reducing balance. Lender rounding, payment dates, fees, insurance and rate changes may alter the actual repayment schedule.
You can calculate EMI manually using a scientific calculator:
The exponentiation step can be tedious for long loan tenures. An online EMI calculator or spreadsheet is usually more convenient and reduces arithmetic errors.
Flat-rate and reducing-balance interest are two different ways of calculating loan interest. Do not compare advertised interest rates without checking the calculation method and total repayment.
In a simplified flat-rate loan, interest is calculated on the original principal.
Total Interest = P × (R ÷ 100) × T
EMI = (Principal + Total Interest) ÷ Number of Instalments
Where:
Under a flat-rate calculation, interest is based on the original principal for the full tenure, even as you repay the loan.
For a reducing-balance loan, interest for each period is calculated on the outstanding principal. As the principal is repaid, the interest portion generally decreases.
| Feature | Flat Rate | Reducing Balance |
|---|---|---|
| Interest calculation | Based on original principal | Based on outstanding principal |
| Principal repayment | Principal is repaid, but interest calculation remains based on original amount | Interest base reduces as principal is repaid |
| Interest cost | Can be higher for the same quoted percentage | Typically lower than flat-rate interest at the same nominal rate |
Suppose you borrow ₹1,00,000 for one year at a 12% annual interest rate.
Flat-rate calculation:
Reducing-balance calculation:
This illustration assumes monthly instalments and a constant interest rate. Flat and reducing rates are not equivalent. Compare total repayment, fees and the lender's disclosed terms.
Microsoft Excel provides the PMT function to calculate fixed periodic payments.
Use this formula:
=PMT(annual_interest_rate/12, tenure_years*12, -loan_amount)For a ₹5,00,000 loan at 10% annual interest for five years:
=PMT(10%/12, 5*12, -500000)This calculates an EMI of approximately ₹10,624, assuming a constant rate and equal monthly payments.
| Cell | Input |
|---|---|
| B2 | Loan amount: 500000 |
| B3 | Annual interest rate: 10% |
| B4 | Tenure in years: 5 |
Enter the following formula:
=PMT(B3/12,B4*12,-B2)Excel's PMT function assumes a constant rate and equal periodic payments. If the interest rate changes or payments are irregular, the simple PMT formula may not reflect the actual loan schedule.
The standard reducing-balance EMI formula generally applies to home loans, personal loans, car loans and bike loans. However, the principal, rate, tenure, fees and lender terms vary.
For a home loan, enter:
Home loans often have long tenures and may carry floating interest rates. If the interest rate changes, the lender may adjust EMI, tenure, or both according to the loan terms and applicable rules.
A calculator using today's interest rate provides an estimate, not a guaranteed lifetime payment.
Personal loans may have shorter tenures and comparatively higher interest rates than some secured loans, depending on the borrower and lender.
Use the following inputs:
Check processing fees and other charges separately because they may affect the overall cost of borrowing.
Suppose you take a car loan of ₹8,00,000 at 9% annual interest for five years.
The reducing-balance EMI is approximately ₹16,607 per month.
Treat this as an estimate. The lender's final repayment schedule and charges determine the actual payment.
For a bike loan, use the same formula with the financed amount—not necessarily the full on-road price of the bike.
The financed amount may exclude a down payment or include lender-approved charges. Check the loan agreement to confirm the interest calculation method.
The EMI depends on the tenure and interest calculation method. Assuming ₹1,00,000 principal, 12% nominal annual interest, and monthly reducing-balance calculation:
| Loan Tenure | Approximate Monthly EMI | Approximate Total Interest |
|---|---|---|
| 1 year | ₹8,884.88 | ₹6,618.56 |
| 2 years | ₹4,707.35 | ₹12,976.40 |
| 3 years | ₹3,321.43 | ₹19,571.48 |
A longer tenure generally lowers the monthly EMI but increases the total interest paid when the rate remains unchanged.
A lower EMI may result from a longer tenure. Although this can make monthly payments more manageable, it may increase the total interest paid.
Ask whether the lender quotes a flat or reducing-balance rate. Check the applicable fees, insurance and annualised borrowing cost disclosures.
Borrowing less usually reduces EMI and interest. However, avoid exhausting your emergency savings simply to reduce the loan amount.
A shorter tenure generally means a higher EMI but lower total interest, assuming the rate remains the same.
Leave enough room in your budget for essential expenses, savings and unexpected financial needs.
Ask your lender how extra payments affect the outstanding principal, tenure and applicable charges.
If your loan has a floating interest rate, consider whether your budget could handle a higher rate or longer repayment period.
If your lender permits it and it fits your finances, you may consider:
Ask the lender to confirm how any prepayment will be applied. Reducing tenure can save interest, but maintaining liquidity and emergency savings is also important.
An online EMI calculator helps you compare loan amounts, interest rates and repayment tenures without repeating the formula manually.
Before relying on the result, confirm whether the calculator assumes monthly reducing balance, a fixed interest rate and no additional fees.
Note: Replace the homepage link above with the actual EMI calculator page URL before publishing.
For a standard monthly reducing-balance loan: EMI = [P × r × (1 + r)n] / [(1 + r)n − 1]. Here, P is the principal, r is the monthly decimal interest rate, and n is the number of monthly payments.
Convert the annual interest rate to a monthly decimal, convert the loan tenure into months, and substitute these values and the principal into the EMI formula. A calculator can handle the power calculation.
Use the Excel formula:
=PMT(annual_rate/12, tenure_years*12, -loan_amount)
For example, =PMT(10%/12,5*12,-500000) calculates the
payment for ₹5 lakh at 10% annual interest over five years, assuming
a constant rate.
Not necessarily. Flat-rate interest is calculated on the original principal for the full period, while reducing-balance interest is calculated on the remaining principal. Compare total interest, repayment, fees and the actual disclosed rate—not just the advertised percentage.
Yes, depending on the loan terms. A floating interest rate can change, and the lender may adjust EMI, tenure, or both. Check your loan agreement and lender communications.
You may be able to reduce EMI by borrowing less, negotiating a lower interest rate, extending the tenure, or refinancing. Extending tenure usually increases total interest if the rate is unchanged. Review fees and affordability before making a decision.
The EMI formula helps you estimate monthly repayments and compare loan scenarios before borrowing. Use the reducing-balance formula for a standard amortising loan, verify whether the lender quotes a flat or reducing rate, and review the total cost—not just the monthly instalment.
An online EMI calculator or Excel PMT function can make the calculation quicker, but the lender's loan agreement and repayment schedule remain authoritative.
Simulate SIP compounding, calculate loan EMI amortization, and evaluate stock returns before investing a single penny. 100% free and mobile friendly.
Put your knowledge into practice with our most popular free planning calculators:
Comments
Please login to post a comment.