calculate-loan

01 Loan payments

Loan EMI Amortization Schedule Calculator

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

Monthly payment 405.53
Total interest
4,331.80
= Monthly payment × 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 payment, 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 amortization schedule shows each monthly payment split between interest and principal, along with the balance remaining after each payment. Enter the loan amount, annual interest rate, and term to calculate the fixed monthly payment and total interest, then use the schedule method below to understand how the balance changes over time.

Formula

The monthly payment is calculated using the standard fixed-payment loan formula, with the result rounded to the nearest cent:

Payment = round[P × r ÷ (1 − (1 + r)−n), 2]

  • P is the starting loan principal, in your currency.
  • r is the monthly interest rate as a decimal: annual APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200.
  • n is the number of monthly payments: loan term in years × 12.

Total interest in this calculator is monthly payment × number of payments − principal. Because the payment is rounded to the nearest cent first, this total uses that rounded payment. An actual lender may calculate or collect the final payment differently because of daily interest, payment dates, rounding, or other contract details.

Worked Example

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

  1. Convert APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667.
  2. Find the number of monthly payments: n = 5 × 12 = 60.
  3. Substitute into the payment formula: 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
  4. Round the calculated payment to cents: **Monthly payment = 405.53** in your currency.
  5. Calculate total interest using the rounded payment: 405.53 × 60 − 20,000 = **4,331.80** in your currency.

The payment is the fixed amount used in this estimate. An amortization schedule adds the interest and principal portions for each month; it does not mean the same portion of every payment goes to principal.

How an EMI Amortization Schedule Works

EMI means equated monthly instalment: a scheduled monthly payment that stays level when the rate and payment terms are fixed. For each period, interest is calculated on the outstanding balance. The remainder of the payment reduces principal.

For a monthly schedule, the basic calculation is:

  • Monthly interest = opening balance × monthly rate.
  • Principal repaid = monthly payment − monthly interest.
  • Closing balance = opening balance − principal repaid.

For example, at the start of the default loan, one month’s estimated interest is 20,000 × 0.0066667, or about 133.33. Of the 405.53 payment, about 272.20 therefore reduces principal, leaving a balance near 19,727.80. Small differences can occur if calculations use more precise rates or round each monthly line separately.

As the balance falls, the interest charge generally falls too, so more of a level payment can go toward principal. This is why early payments on a fully amortizing loan often contain a larger interest share than later payments. The final scheduled payment should bring the balance to zero, subject to the lender’s precise rounding and payment conventions.

How to Read the Schedule and Use It

A full schedule typically has one row per payment and columns for payment number or date, opening balance, payment, interest, principal, and closing balance. Check that the opening balance in each row matches the prior row’s closing balance. The principal column should reduce the balance, while interest is a cost for that period rather than a reduction in what is owed.

Use an amortization schedule to see the projected payoff path, estimate cumulative interest over a period, or understand how much principal remains at a particular payment number. To create a row-by-row schedule, repeat the monthly interest, principal, and closing-balance calculations for each payment. Use the lender’s statement for the actual balance on a specific date; a monthly estimate may not account for accrued interest between payment dates.

This calculator gives the regular payment and total interest over the stated term. It does not display every monthly row, so the schedule’s individual figures require applying the row calculations above. A payment schedule can also differ from the amortization schedule if a contract includes irregular payment dates or other charges.

Common Misunderstandings and Limits

  • EMI is not the same as principal repayment. It is the whole payment, including both interest and principal.
  • Equal payments do not mean equal interest charges. The interest portion changes as the outstanding balance changes.
  • APR must be entered as a percentage, not a decimal. Enter 8 for 8%, not 0.08. The formula converts the annual percentage to a monthly rate.
  • The estimate assumes a fixed rate and monthly payments. A variable rate, payment holiday, skipped payment, or extra payment changes the schedule.
  • Fees and related charges are outside the calculation. The payment and interest results do not automatically include origination costs, taxes, insurance, escrow, or other amounts unless they are included in the loan principal or entered separately.

When a quoted APR includes costs that are not charged as interest on the outstanding balance, using that APR in a simple amortization formula may not reproduce the lender’s payment calculation. Confirm which rate the contract uses for periodic interest and whether charges are financed.

Frequently Asked Questions

What does a loan EMI amortization schedule show?
It shows each scheduled payment divided into interest and principal, plus the outstanding balance after that payment. It helps explain how a level payment changes the debt over time.

How do I calculate the interest part of an EMI?
Multiply the opening balance for the month by the monthly interest rate. Subtract that interest from the scheduled payment to estimate the principal repaid in that month.

Why does the principal portion increase over time?
With a fixed rate and level payments, the balance generally declines. Interest is calculated on that lower balance, leaving more of each later payment to reduce principal.

Does this calculator include fees or insurance?
No. It estimates principal-and-interest payments from the amount, APR, and term entered. Check the lender’s figures for additional charges and any payment components not modelled here.

Can I use the schedule for a variable-rate loan?
Only as an estimate for a period when a particular rate applies. A rate change alters the interest calculation and may change the payment or payoff timeline, depending on the loan terms.

Assumptions

  • The interest rate is fixed for the entire term.
  • Payments are equal, made monthly, and paid at the end of each period.
  • Interest is compounded monthly using APR ÷ 12 as the periodic rate.
  • Fees, taxes, insurance, PMI, and escrow are not included unless financed in the entered principal.

This result is an estimate; 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 payment | - | 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 →