Loan EMI Repayment Schedule Calculator and Guide

A loan EMI repayment schedule shows each monthly instalment and how much goes toward interest and principal, along with the balance left after each payment. Enter the loan amount, annual interest rate, and term to estimate the monthly payment and total interest; the schedule itself can then be built month by month from those figures.

Formula

For a fixed-rate loan repaid in equal monthly instalments, the payment is calculated as:

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

• P is the original loan principal, in your currency.
• r is the monthly interest rate, calculated as annual APR ÷ 1,200 when APR is entered as a percentage.
• n is the number of monthly payments: loan term in years × 12.
• EMI is the monthly payment, rounded to two decimal places.

The calculator’s total-interest estimate is the rounded monthly EMI multiplied by the number of payments, minus the original principal. It assumes every scheduled payment is made in full and on time. The entered APR is used as the annual rate for this arithmetic; lender-specific conventions or charges may change an actual payment.

Worked Example

Using the calculator’s default values—principal of 20,000 in your currency, APR of 8%, and a five-year term:

1. Convert the annual APR to a monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
2. Find the number of payments: 5 × 12 = 60.
3. Apply the payment formula: 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ 405.527. Rounded to cents, the monthly EMI is 405.53.
4. Use that rounded payment to estimate total interest: 405.53 × 60 − 20,000 = 4,331.80.

This is an estimate from a rounded, level-payment calculation. A lender’s schedule may differ slightly if it uses different rounding, payment dates, day-count conventions, fees, or rate terms.

Assumptions

• The interest rate is fixed for the entire example; no rate changes are modelled.
• Payments are equal and made monthly, with the first payment one month after the loan begins.
• Interest is treated as compounding monthly at APR ÷ 12.
• Fees, taxes, insurance, PMI, escrow, late charges, and other costs are not included.
• The displayed total uses the monthly payment rounded to the nearest cent.

How an EMI Repayment Schedule Works

An EMI, or equated monthly instalment, is a level payment intended to cover both interest and principal. The payment amount usually stays the same for a fixed-rate, fully amortizing loan, but its components change over time. Interest for a period is calculated on the outstanding balance. The portion left after that interest is paid reduces principal.

A simplified month-by-month schedule follows these steps:

1. Start with the balance at the beginning of the month.
2. Calculate that month’s interest by multiplying the balance by the monthly rate.
3. Subtract the interest from the EMI to find the principal repaid.
4. Subtract principal repaid from the starting balance to get the new balance.

For example, with a balance of 20,000 and a monthly rate of 0.66667%, one month’s interest is about 133.33. From a 405.53 payment, about 272.20 goes toward principal, leaving a balance near 19,727.80. Real schedules may differ by a few cents because of the lender’s rounding and payment-date methods.

Early in a standard amortizing loan, the balance is larger, so the interest portion tends to be larger too. As principal is paid down, later instalments generally contain less interest and more principal. This does not mean the EMI itself declines; under the fixed-rate assumptions, it remains level.

Reading and Using the Schedule

A complete repayment schedule normally has one row per payment period. Common columns include the payment number or date, opening balance, scheduled payment, interest, principal, and closing balance. Check that the closing balance moves toward zero and that the final payment clears the loan; rounding can make the last row differ slightly.

Use the estimate to understand the mechanics or to check a lender-provided illustration, not as a substitute for the contract’s payment schedule. To create a row for each month, apply the interest-and-principal steps above repeatedly, using the previous month’s closing balance as the next month’s opening balance. The calculator reports the payment and aggregate interest, not a full dated table.

Inputs should match the loan terms: use the amount actually borrowed, enter the APR as a percentage such as 8 for 8%, and enter the repayment term in years. If a loan quotes a monthly rate rather than an annual APR, do not enter it as though it were an annual percentage. Obtain the applicable payment rate and any charges from the lender’s disclosure.

Costs, Variations, and Common Mistakes

The EMI is not necessarily the full amount leaving a borrower’s account. A loan may have separate fees or other items, and this calculator does not include them. A variable-rate loan can also have a changing payment or repayment period, depending on its terms; a single fixed APR cannot represent those changes.

• Confusing payment with principal repayment: the EMI includes interest, so the full payment does not reduce the balance.
• Mixing annual and monthly rates: the formula divides an APR percentage by 1,200 to obtain a monthly decimal rate.
• Rounding too early: rounding intermediate values can shift a schedule by cents. The calculator rounds the payment to cents and uses that rounded amount for total interest.
• Assuming the schedule includes every cost: check the lender’s disclosure for fees and any other amounts outside principal and interest.
• Expecting an early payoff to match scheduled interest: paying ahead can change interest and balances, but the effect depends on payment timing and loan terms and is not modelled here.

For a more exact comparison, use the lender’s stated payment amount, rate method, payment dates, and any charges. A schedule based on a nominal APR and monthly compounding is a useful mathematical model, not a guarantee of the final amount due.

Frequently Asked Questions

What does a loan EMI repayment schedule show?
A schedule breaks each planned instalment into interest and principal and shows the balance remaining after payment. It may also list payment dates and cumulative amounts.

Does the EMI stay the same every month?
It generally stays level in this calculation because it assumes a fixed rate, equal monthly payments, and no extra charges or changes. A lender’s terms may produce a different pattern, especially if the rate changes.

Why does the interest portion fall over time?
Interest is calculated on the outstanding balance. As principal is repaid, the balance falls, so the interest portion tends to shrink while more of a level payment goes toward principal.

Is EMI the same as the total monthly loan cost?
No. EMI here means principal-and-interest payment only. Separate fees, insurance, taxes, or other charges are not included in this estimate.

Can I use this schedule for a variable-rate loan?
Only as a snapshot using one assumed rate. If the rate changes, the payment or remaining repayment pattern may change, so a fixed-rate estimate will not represent the full schedule.

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

Related

• Auto Loan With No Down Payment? Estimate the Cost
• Auto Loans 93592: No Down Payment Calculator
• Auto Loan No Credit, No Down Payment? What to Know

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