EMI Amortization Schedule Calculator and Guide

An EMI amortization schedule shows how each equal monthly instalment (EMI) is divided between interest and loan principal, and how the remaining balance declines over time. Enter the loan amount, annual interest rate and term below to estimate the monthly payment, total interest and total paid.

Formula

This calculator uses the standard fixed-payment amortizing-loan formula. It first finds the level monthly payment, rounds that payment to the nearest cent, then estimates total paid using the rounded monthly amount.

• EMI = P × r ÷ [1 − (1 + r)⁻ⁿ], rounded to two decimal places.
• Total paid = EMI × n.
• Total interest = Total paid − P.

P is the original principal, in the currency you enter. r is the monthly interest rate as a decimal, calculated here as APR ÷ 1,200. n is the number of monthly payments, calculated as years × 12. APR is entered as a percentage per year. The displayed EMI is a monthly amount in your currency.

Worked Example

Using the calculator’s default inputs—principal of 20,000, APR of 8%, and a five-year term—the monthly rate is 0.08 ÷ 12 = 0.0066667, and the number of payments is 5 × 12 = 60.

1. Insert those values into the payment formula: 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
2. The monthly EMI is approximately 405.53, rounded to two decimal places.
3. Total paid is 405.53 × 60 = 24,331.80.
4. Total interest is 24,331.80 − 20,000 = 4,331.80.

The calculator reports the monthly payment first, followed by the estimated interest and total paid. The schedule below explains how to work out the principal and interest portions of each instalment.

How an EMI Amortization Schedule Works

For a conventional amortizing loan with a fixed rate and regular monthly payments, interest is calculated on the outstanding principal. Early in the term, the balance is larger, so more of the payment generally goes to interest. As the balance falls, the interest portion shrinks and more of each unchanged payment reduces principal. This gradual repayment is called amortization.

For a particular month, a simplified schedule uses these steps:

1. Multiply the opening balance by the monthly rate to estimate that month’s interest.
2. Subtract that interest from the EMI to find the principal repaid.
3. Subtract the principal repaid from the opening balance to find the closing balance.

For example, at the start of the default loan, estimated monthly interest is 20,000 × 0.08 ÷ 12, or about 133.33. From an EMI of 405.53, about 272.20 goes to principal, leaving an estimated balance of 19,727.80. Actual lender schedules may differ slightly because of payment dates, daily interest calculations, rounding conventions or fees.

Reading and Using a Schedule

A full amortization table usually includes the payment number or date, opening balance, payment, interest, principal and closing balance. Check that the opening balance of each row matches the previous row’s closing balance. Across the schedule, principal repaid should approximately equal the original amount borrowed, while the interest column adds up to the total interest—subject to rounding and any changes in loan terms.

The calculator gives summary figures rather than every row of a schedule. To create a row-by-row estimate, repeatedly apply the monthly steps above, carrying each closing balance forward as the next opening balance. A final payment can be adjusted by a lender to clear a small remaining balance caused by rounding.

An amortization schedule is useful for understanding the time pattern of repayment and checking how a payment is allocated. It does not establish the exact amount due on a particular date or account for a lender’s servicing rules. Use the loan documents or lender-provided schedule for contractual figures.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal monthly instalments, paid at the end of each monthly period.
• Interest compounds monthly at APR divided by 12.
• Fees, taxes, insurance, PMI and escrow are not included.
• The calculation assumes the loan is fully amortized through the stated number of payments, with no missed payments or extra principal payments.

Common Mistakes and Limits

A frequent mistake is entering the interest rate as a decimal when the field expects a percentage: enter 8 for 8%, not 0.08. Another is confusing the loan term in years with the number of monthly payments; a five-year term means 60 payments under this model. The schedule also assumes APR can be represented by a monthly rate of APR ÷ 12. Some products calculate interest differently or have variable rates, irregular payment dates, introductory periods or a final balloon payment, so this estimate may not reproduce their schedules.

Rounding matters. The calculator rounds the EMI to cents before multiplying by the number of payments, so its total paid uses that rounded payment. A lender may calculate interest and round each period independently, causing small differences. A payment schedule also does not necessarily show the payoff amount today: accrued interest, fees or other account-specific items can affect that figure.

Extra payments can reduce principal sooner and change future interest, but the amount of the change depends on when payments are applied and how the loan handles them. This calculator has no extra-payment input and therefore does not estimate that effect. To model a changing rate or payment, calculate separate periods using the applicable terms rather than treating the result as a complete loan quote.

Frequently Asked Questions

What is an EMI amortization schedule?
An EMI amortization schedule is a payment-by-payment breakdown showing how each instalment is split between interest and principal, alongside the balance remaining after each payment.

How do I calculate the interest part of an EMI?
For this monthly model, multiply the opening balance for that month by APR divided by 12. Subtract the resulting interest from the EMI to estimate the principal portion.

Why does the principal portion increase over time?
With a fixed rate and equal payments, interest is calculated on a declining balance. As the balance gets smaller, less of the payment covers interest, leaving more to reduce principal.

Does EMI include fees, taxes or insurance?
Not in this calculator. It estimates principal-and-interest payments only; charges or insurance may be separate or handled differently in a lender’s payment figures.

Why might my lender’s schedule differ?
Differences can result from payment dates, daily rather than monthly interest calculations, rounding, fees, rate changes or other loan-specific terms. The lender’s documents provide the applicable figures.

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

Related

• Amortization Schedule Calculator With Balloon Payment
• Car Loan Amortization Schedule Calculator
• Amortization Schedule by Year: Calculate Annual Totals

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
out tot | Total paid | - | pmt * yrs * 12 | 2