Amortization Table in INR: Calculate Your EMI

An amortization table in INR shows how each loan payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount in rupees, annual interest rate, and term to estimate the monthly EMI and total interest; the formula below assumes a fixed rate and monthly payments.

Formula

The monthly payment is calculated using the standard fixed-payment loan formula:

EMI = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the amount borrowed, entered in INR.
• r is the monthly interest rate as a decimal: annual rate (%) ÷ 1,200.
• n is the total number of monthly payments: loan term in years × 12.
• EMI is the level monthly payment, rounded to two decimal places in the calculator. Its unit is INR per month.

Total interest in this calculator is the rounded EMI multiplied by the number of payments, minus the original principal: Total interest = EMI × n − P. Since payments are rounded to paise, this is an estimate of interest over the full schedule.

Worked Example

Using the calculator’s default values—INR 2,000,000 borrowed, 8% annual interest, and a five-year term:

1. Convert the annual percentage rate to a monthly decimal: 8 ÷ 1,200 = 0.0066667.
2. Find the number of payments: 5 × 12 = 60.
3. Substitute into the formula: EMI = 2,000,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)⁻⁶⁰].
4. The unrounded result is about INR 40,553.31; rounded to two decimal places, the monthly EMI is INR 40,553.31.
5. Total of rounded payments = INR 40,553.31 × 60 = INR 2,433,198.60. Estimated total interest = INR 2,433,198.60 − INR 2,000,000 = INR 433,198.60.

What an Amortization Table Shows

An amortization table, also called an amortization schedule, lays out a loan’s repayment period by period. Each row commonly shows the payment number or date, opening balance, payment, interest, principal repaid, and closing balance. The calculator above returns the EMI and total interest; it does not print every row of the schedule.

For a fixed-rate loan with monthly payments, the interest portion of a period is generally calculated from the balance at the start of that period and the monthly rate. The principal portion is the payment minus that interest. The new balance is the previous balance minus principal repaid. At the start of repayment, the balance is large, so interest often takes a larger share of the payment. As principal is repaid, the interest share falls and the principal share rises.

How to Read the INR Results

INR is the currency code for Indian rupees. The calculator uses “-” for the currency unit because the calculator interface can label the output in your currency; interpret the payment and interest outputs here as rupees. The result is not a quotation from a lender. Use the loan amount, rate, and term stated in the relevant loan disclosure to produce an estimate based on those inputs.

• Monthly EMI: the same scheduled payment each month under the formula’s assumptions.
• Total interest: the estimated interest component across all scheduled payments.
• Total paid: EMI multiplied by the number of payments. In this example, it is INR 2,433,198.60.

A longer term generally means more payment periods and can increase total interest, even though the monthly payment may be lower. A shorter term means fewer periods, but the required monthly payment may be higher. These are mathematical effects of the entered assumptions, not a recommendation about which term to choose.

When This Estimate Helps—and What It Leaves Out

An amortization calculation can help you understand how principal and interest relate, compare hypothetical combinations of loan amount, rate, and term, or check whether a quoted EMI is broadly consistent with those inputs. For a full schedule, calculate each month separately: multiply the opening balance by the monthly rate for interest, subtract interest from the payment to get principal repaid, then subtract principal from the opening balance to get the next balance.

Actual loan schedules may differ because of payment dates, rate changes, fees added to the balance, payment rounding, or a lender’s specific calculation conventions. This calculator assumes one fixed annual rate and the same payment every month. It does not include processing charges, taxes, insurance, prepayments, late charges, or changes in the rate. A floating-rate loan can have a changing EMI, term, or both, depending on the loan arrangement; a fixed-rate formula cannot forecast those changes.

Common Errors and Limits

• Entering 8 instead of 0.08 in a hand calculation: the formula expects a monthly decimal rate. For an 8% annual rate, use 8 ÷ 1,200, not 8 ÷ 12.
• Confusing rate and term: enter the annual rate as a percentage and the term in years. Do not enter the term in months in the years field.
• Assuming EMI equals principal divided by months: that ignores interest. The formula accounts for both interest and repayment of principal.
• Expecting the final schedule row to match perfectly: rounding each payment to paise can leave a small residual balance. A lender may adjust the final instalment to clear it.

The formula requires a positive loan amount, a positive interest rate, and a positive term. It describes level payments on a fully amortizing loan; it does not model interest-only periods, balloon payments, irregular instalments, or a changing rate. To check an actual offer, compare the assumptions and payment details in the lender’s disclosure rather than relying on this estimate alone.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal monthly instalments, made at the end of each monthly period.
• Interest compounds monthly at the annual rate divided by 12.
• Fees, taxes, insurance, prepayments, and other charges are not included.

Frequently Asked Questions

What does an amortization table in INR mean?
An amortization table is a period-by-period repayment schedule. “In INR” means its money amounts are expressed in Indian rupees.

How do I calculate EMI from an amortization formula?
Convert the annual rate to a monthly decimal by dividing the percentage by 1,200, multiply the term in years by 12, and use those values with the principal in the fixed-payment formula above.

Does every EMI reduce the loan balance?
In a standard fully amortizing loan, each payment covers the period’s interest and pays down principal. If a payment does not cover accrued interest, the balance may not fall as this formula assumes.

Why does the interest portion change when EMI stays the same?
Interest is calculated on the outstanding balance. As the balance declines, the interest portion usually declines too, leaving more of a level payment to repay principal.

Is the calculator’s total interest the lender’s exact figure?
No. It is an estimate based on fixed-rate monthly payments and the entered values. Rounding, payment dates, fees, rate changes, and lender-specific terms can alter the actual schedule.

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

Related

• SC Qualified Retirement Income Deduction: Rules and Limits
• Section 8 Qualifying Income Level Explained
• Qualifying Income Trust: Meaning and Tax Basics

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