EMI Calculator With Amortization Schedule

An EMI calculator with an amortization schedule estimates your fixed monthly instalment and shows how each payment is divided between interest and principal over time. Enter the loan amount, annual interest rate, and term to see the monthly payment, total interest, and a payment-by-payment balance schedule.

Formula

The calculator uses the standard fixed-payment loan formula. The monthly instalment is EMI = P × r ÷ [1 − (1 + r)⁻ⁿ], where P is the starting loan principal in your currency, r is the monthly interest rate as a decimal, and n is the number of monthly payments. Here, r = APR ÷ 1200 when APR is entered as a percentage per year, and n = loan term in years × 12. The payment is rounded to two decimal places; total interest is calculated as the rounded EMI multiplied by the number of payments, minus principal.

The schedule follows the same monthly calculation. For each period, interest is the opening balance multiplied by r; principal repaid is the EMI minus that interest; and the closing balance is the opening balance minus principal repaid. In symbols, I_k = B_k−1 × r, C_k = EMI − I_k, and B_k = B_k−1 − C_k. B is the balance, I the period’s interest, C the principal component, and k the payment number. The final payment may differ slightly in a real repayment schedule because of cent rounding and lender adjustments.

Worked Example

Using the defaults above: principal P = 20,000 in your currency, APR = 8%, and term = 5 years.

1. Convert APR to a monthly decimal rate: r = 8 ÷ 1200 = 0.0066666667.
2. Convert the term to payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: EMI = 20,000 × 0.0066666667 ÷ [1 − (1.0066666667)⁻⁶⁰].
4. The unrounded monthly payment is about 405.5277; rounded to cents, the displayed EMI is 405.53 in your currency.
5. Total of the rounded payments = 405.53 × 60 = 24,331.80. Estimated total interest = 24,331.80 − 20,000 = 4,331.80 in your currency.

For an illustrative first schedule row, first-month interest is 20,000 × 0.0066666667 = 133.33. Principal repaid is 405.53 − 133.33 = 272.20, leaving an estimated balance of 19,727.80. Subsequent rows repeat the calculation using the new opening balance. A full schedule lists each month, its opening balance, payment, interest, principal repaid, and closing balance.

Assumptions

• The interest rate remains fixed for the entire repayment term.
• Payments are equal monthly instalments, made at the end of each monthly period.
• Interest is calculated monthly using APR divided by 12; this is a simplified monthly-rate model.
• Fees, taxes, insurance, PMI, and escrow are not included. Get the applicable rate and charges from the lender.

How to Read an Amortization Schedule

An amortization schedule makes the path of the balance visible. Early in a level-payment loan, the balance is relatively high, so the interest portion is larger. As principal is repaid, the interest charged each month generally falls, and more of the same EMI goes toward principal. The total payment stays level under the calculator’s assumptions, but its internal split changes.

Use the opening balance to see what is owed before a payment, the interest column to understand the financing cost for that period, and the closing balance to track the remaining principal afterward. The balance is not necessarily the exact payoff amount on a particular date: a payoff quote can account for accrued interest, payment dates, fees, or other contract terms not represented here.

When to Use It and What It Leaves Out

This estimate is useful for understanding the arithmetic of a fixed-rate, monthly-payment loan, comparing different principal, rate, or term inputs on a like-for-like basis, and seeing how repayments progress. It does not determine whether a loan will be approved or whether a payment fits a personal budget. APR, fees, and other lender-specific figures should be entered from an actual disclosure rather than assumed.

A variable-rate loan, a loan with irregular payments, a deferred-payment period, or a structure with a balloon payment will not follow this simple schedule throughout its life. Extra payments also change the balance and future interest; this calculator does not model them. For an actual account, the lender’s schedule and contract terms control the amounts and dates.

Common Mistakes and Limits

• Entering the rate in the wrong format: enter 8 for an annual rate of 8%, not 0.08. The formula converts the percentage to a monthly decimal.
• Confusing years and months: the term input is in years, and the calculation multiplies it by 12. A five-year term means 60 monthly payments.
• Treating EMI as the full cost: the payment result excludes charges not included as inputs. It is not automatically the amount due on a lender statement.
• Expecting every displayed figure to match a lender schedule exactly: rounding, payment dates, daily interest methods, and contract-specific adjustments can create differences.

The formula assumes a positive APR, level monthly instalments, and no changes to principal beyond those instalments. The schedule is an estimate, and the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What does EMI mean?
EMI means equated monthly instalment: a regular payment that, in a standard fixed-rate amortizing loan, covers interest for the period and repays part of the principal.

Does an amortization schedule show the remaining loan balance?
Yes. Each row estimates the balance after a payment by subtracting the principal portion from the previous balance. It may not equal a dated payoff quote.

Why does the interest portion fall over time?
Interest is calculated on the outstanding balance. As scheduled payments reduce that balance, the interest component generally declines, leaving more of a level payment for principal.

Is the EMI the same as the total monthly loan cost?
Not always. This estimate covers principal and interest only. Fees, insurance, taxes, or other charges may be billed separately or included in a lender’s payment figure.

Can I use this calculator for a variable-rate loan?
It can estimate payments for one assumed rate, but it cannot project future instalments if the rate changes. A changing-rate loan needs a schedule that reflects the lender’s rate-reset terms.

Related

• Market Interest Rate: Meaning and How It Works
• Savings Interest Calculator: Estimate Your Earnings
• MA Interest Rates: Estimate a Loan Payment

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