EMI Calculation Table: Monthly Payments and Interest

An EMI calculation table shows the fixed monthly instalment for a loan at a stated principal, annual interest rate, and repayment term. Use the calculator below to enter those three figures and see the monthly payment and total interest; its estimate assumes a fixed rate and monthly payments.

Formula

For a standard fully amortizing loan with equal monthly payments, EMI is calculated as:

EMI = round[P × r × (1 + r)ⁿ ÷ ((1 + r)ⁿ − 1), 2]

• P is the amount borrowed, entered in your currency.
• r is the monthly interest rate as a decimal: annual APR ÷ 12 ÷ 100.
• n is the total number of monthly payments: loan term in years × 12.
• EMI is the monthly instalment, rounded to two decimal places in your currency.

The calculator uses the equivalent expression P × r ÷ [1 − (1 + r)⁻ⁿ]. Total interest is calculated as the rounded EMI multiplied by the number of payments, minus the original principal. This convention makes the displayed total consistent with the displayed monthly amount; actual loan schedules can differ slightly due to payment dates, rounding, or lender-specific calculations.

Worked Example

Using the calculator’s defaults: a principal of 20,000 in your currency, an APR of 8%, and a five-year term.

1. Convert the annual rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066667 (approximately).
2. Find the number of payments: n = 5 × 12 = 60 months.
3. Apply EMI = P × r ÷ [1 − (1 + r)⁻ⁿ]: 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
4. Round the monthly amount to two decimal places: EMI = 405.53 in your currency.
5. Calculate total interest using the rounded payment: 405.53 × 60 − 20,000 = 4,331.80 in your currency.

Assumptions

• The interest rate remains fixed for the entire term.
• Payments are equal, made monthly, and begin one month after the loan starts.
• Interest compounds monthly at APR ÷ 12.
• Fees, taxes, insurance, escrow, and other charges are not included.

How to Read an EMI Calculation Table

A conventional EMI table puts loan amounts in rows and interest rates or terms in columns. The value where a row and column meet is the estimated payment for that combination. For example, a table might hold the term at five years and show separate columns for several APRs. Because a longer term spreads principal across more payments, its monthly EMI is generally lower at the same principal and rate, while total interest is generally higher. A higher APR generally raises both the payment and the total interest when the other inputs stay unchanged.

Tables are useful for quick comparisons, but they only answer the question represented by their assumptions. A table headed “per 10,000 borrowed,” for instance, is a scale reference, not the payment on every loan. To estimate another principal under the same rate and term, the payment scales proportionally in this standard formula. Check the heading, currency, payment frequency, APR, and term before relying on a printed figure.

Using the Calculator and Comparing Scenarios

Enter the principal, annual percentage rate, and term in years. The first result is the regular monthly instalment; the second is the estimated interest paid over the full term, using that rounded instalment. To understand how assumptions affect the result, change one input at a time and note the difference. Comparing several combinations can reveal whether a lower monthly payment comes from a lower rate, a longer repayment period, or both.

The APR must be entered as a percentage, such as 8 for eight percent, not as 0.08. The calculator converts it to a monthly decimal internally. Enter the full amount borrowed, not a monthly amount or a balance already converted to another currency. Use the same currency consistently for the principal and reported results.

Common Mistakes and Limits

• Confusing APR with the monthly rate: the input is annual APR. Dividing by 12 and converting percent to a decimal are both part of the formula.
• Mixing years and months: this calculator accepts years and multiplies by 12. A term entered as 60 would mean 60 years, not 60 months.
• Treating the estimate as a complete bill: the payment shown excludes fees and other charges unless they are included in the amount borrowed or represented by a separate input.
• Assuming every loan has a fixed EMI: a variable rate, irregular payment schedule, balloon payment, or changing balance does not match this fixed-payment calculation.
• Overlooking rounding: the calculator rounds the payment to two decimal places before calculating total interest. A lender’s exact schedule may use different rounding or payment-date conventions.

At a zero interest rate, the payment would simply be principal divided by the number of months, but the calculator requires an APR of at least 0.01% because its standard expression divides by the monthly rate. The result is also a mathematical estimate, not a prediction of approval, a quoted offer, or a measure of what a person can afford. Rates and any fees should be obtained from the lender for the particular loan being considered.

Frequently Asked Questions

What does EMI mean?
EMI means equated monthly instalment. It is a scheduled monthly payment that, in a standard fixed-rate amortizing loan, combines interest and repayment of principal.

How do I calculate EMI from a table?
Find the row for the loan amount and the column for the relevant rate and term, then read their intersection. Confirm whether the table gives an actual payment or a payment per fixed amount borrowed.

Does a longer loan term reduce EMI?
With the same principal and rate, extending the term generally lowers the monthly payment because repayment is spread over more months. It generally increases total interest because the balance remains outstanding for longer.

Is EMI the same as total interest?
No. EMI is the amount paid each month. Total interest is the interest accumulated across the repayment schedule; the principal is repaid as part of the instalments too.

Why might a lender’s EMI differ from this result?
The lender may use a different rate convention, payment date, rounding method, or repayment structure. Fees or other financed amounts can also change the calculation. Compare the same principal, APR, term, and payment assumptions.

This result is an estimate for educational use, and the lender’s disclosure gives the exact figures.

Related

• Current PF Interest Rate: EPF Rate and How It Works
• Periodic Interest Rate: Examples and How to Calculate It
• Current G Fund Interest Rate: How It’s Set

in p | Loan amount | - | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly EMI | - | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | - | pmt * yrs * 12 - p | 2