calculate-loan

01 Loan payments

Loan EMI Schedule: Payments, Interest and Balance

Calculator No. 01-15310 · Updated · Formula and assumptions shown below

Monthly EMI 405.53
Total interest
4,331.80
= Monthly emi × loan term × 12 − loan amount
Loan amount
20000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount, Interest rate (APR) (%), Loan term (years)
You get
Monthly EMI, Total interest
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A loan EMI schedule is a month-by-month breakdown of each equal monthly instalment (EMI), showing how much goes toward interest, how much reduces principal, and what balance remains. Enter the loan amount, annual interest rate and term to estimate the monthly payment and total interest; the figures are in your currency and use a fixed-rate, monthly-payment calculation.

Formula

For a fixed-rate loan with equal monthly payments, the EMI is calculated using the amortizing-payment formula:

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

  • P is the amount borrowed, in your currency.
  • r is the monthly interest rate as a decimal: annual APR (%) ÷ 1,200.
  • n is the number of monthly payments: loan term in years × 12.

The calculator rounds the monthly EMI to two decimal places, then estimates total interest as EMI × n − P. This means the interest estimate uses the rounded monthly payment, as a real payment schedule generally does. The formula assumes a positive rate; the stated minimum rate keeps the division and payment calculation defined.

Worked Example

Using the defaults—loan amount 20,000, APR 8%, and term 5 years—the schedule has 5 × 12 = 60 monthly payments. The monthly rate is 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.

Substitute those values into the formula:

EMI = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60]
Unrounded payment ≈ 405.53; rounded to cents, the monthly EMI is 405.53.

Total of scheduled payments = 405.53 × 60 = 24,331.80.
Estimated total interest = 24,331.80 − 20,000 = 4,331.80.

These are the same quantities returned by the calculator. The total interest can differ slightly from a lender’s final figure if payment dates, rounding, fees, rate changes or the loan’s calculation method differ.

Assumptions

  • The interest rate stays fixed for the full term.
  • Payments are made monthly, on schedule, with the first payment one month after borrowing.
  • Interest compounds monthly at APR ÷ 12; the APR is treated as a nominal annual rate.
  • Fees, taxes, insurance, PMI and escrow are not included.

How to Read an EMI Schedule

Each row in a full amortization schedule normally identifies the payment period, opening balance, payment amount, interest charged, principal repaid and closing balance. In a standard fixed-rate schedule, the EMI stays level while its components change over time.

For each period, interest is calculated on the remaining balance. The amount left from the EMI after paying that interest reduces principal. Because the balance usually declines, the interest portion tends to fall and the principal portion tends to rise. For example, if a period begins with a balance of 20,000 and monthly interest is 0.66667%, interest for that period is about 133.33. From an EMI of 405.53, roughly 272.20 would reduce principal, leaving a lower balance for the next period. This illustration ignores any lender-specific rounding or date conventions.

The schedule’s final balance should reach zero after the agreed number of payments, apart from small rounding adjustments. A lender may adjust the final instalment by a few cents to settle the account precisely. An EMI schedule is therefore more informative than the monthly payment alone: it shows the timing of interest costs and how quickly principal is repaid.

When to Use It and What It Does Not Show

Use an EMI estimate to understand the arithmetic of a proposed fixed-rate loan, compare different loan amounts or terms using figures supplied by lenders, or check how a stated payment relates to a stated principal and duration. Treat the APR and term as inputs to verify, not as predictions. The calculator does not establish what rate, fee, loan amount or terms any lender will offer.

This calculator returns the level monthly payment and total interest estimate, not a row-by-row schedule. To create a schedule manually, start with the original principal and repeat these steps for each month:

  1. Multiply the opening balance by the monthly rate to estimate that month’s interest.
  2. Subtract the interest from the EMI to find the principal repaid.
  3. Subtract principal repaid from the opening balance to find the closing balance.
  4. Use that closing balance as the next month’s opening balance, repeating until repayment.

If the rate is variable, the payment or term may change, so a single fixed-rate schedule will not represent all future instalments. Extra payments, payment holidays, late payments and fees can also change the balance or payoff date. A lender’s actual schedule should be used for account-level figures.

Common Errors and Related Questions

  • Confusing annual and monthly rates: this formula converts APR from a percentage per year to a monthly decimal by dividing by 1,200. Entering 8 instead of 8% as a decimal, or dividing by 12 without converting the percentage, produces a wrong result.
  • Assuming every payment is principal: the interest share is part of the EMI, especially early in the repayment period.
  • Ignoring rounding: rounding each monthly payment can make a small difference to cumulative totals and the last payment.
  • Treating EMI as the full cost of borrowing: the displayed interest estimate excludes fees and other charges unless they are explicitly included in the loan amount or rate.

A longer term generally spreads repayment across more instalments and changes both the monthly payment and total interest, assuming the same principal and rate. The formula itself does not decide whether a particular payment fits a personal budget or whether a loan should be taken.

Frequently Asked Questions

What does EMI mean?
EMI means equated monthly instalment: a scheduled monthly payment intended to remain level under the loan’s stated repayment assumptions. It generally includes both interest and principal.

Is an EMI schedule the same as an amortization schedule?
They commonly refer to the same kind of breakdown: payments over time, with each payment divided between interest and principal and the remaining balance shown.

Why does the interest portion decrease over time?
With a standard fixed-rate amortizing loan, interest for each period is based on the outstanding balance. As principal is repaid and the balance falls, less interest accrues in later periods.

Does a lower monthly EMI mean less interest overall?
Not necessarily. A lower EMI may result from a longer repayment term, which can mean more payments and a higher total interest amount. Compare the term and total repayment as well as the monthly figure.

Why does my lender’s EMI differ from this estimate?
Possible reasons include a different APR or term, fees included in the financed amount, daily rather than monthly interest calculations, payment-date conventions, variable rates, or rounding. Check the loan disclosure for its exact inputs and method.

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

Related

Formula used
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

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →