Loan EMI Calculator: Amortization Schedule & Prepayment Savings

How Equated Monthly Installments (EMI) are calculated

An Equated Monthly Installment (EMI) is a fixed monthly payment made by a borrower to a lender to repay a debt over an agreed loan term. Each monthly payment consists of two parts: interest on the outstanding principal balance and a principal repayment component that reduces the debt.

This calculator computes your exact monthly installment, total interest obligations, and full amortization schedule. All calculations run client-side in your browser, keeping your loan balances, income, and debt amounts private.

The reducing-balance EMI formula

$$\text{EMI} = \frac{P \times r \times (1 + r)^n}{(1 + r)^n - 1}$$

Variable definitions:

• $P$ (Loan Principal): The total capital borrowed from the financial institution.
• $r$ (Monthly Interest Rate): Annual nominal interest rate divided by 12 months and 100 (e.g., $9% \text{ per year} \rightarrow r = \frac{0.09}{12} = 0.0075$).
• $n$ (Loan Tenure in Months): The total repayment period expressed in monthly payment cycles ($\text{Tenure in Years} \times 12$).

Worked example: $1,000,000 mortgage at 9.0% over 20 years

Consider a commercial property mortgage or home loan with the following terms:

• Principal Borrowed ($P$): $1,000,000
• Annual Interest Rate: 9.0%
• Loan Duration: 20 years ($n = 240$ months)

Step-by-step arithmetic:

1. Monthly Interest Rate ($r$): $\frac{0.09}{12} = \mathbf{0.0075}$
2. Compounding Factor $(1 + r)^n$: $(1.0075)^{240} \approx \mathbf{6.00915}$
3. Numerator: $$1,000,000 \times 0.0075 \times 6.00915 = \mathbf{$45,068.64}$
4. Denominator: $6.00915 - 1 = \mathbf{5.00915}$
5. Monthly EMI Payment: $\frac{$45,068.64}{5.00915} = \mathbf{$8,997.26}$ per month
6. Total Cumulative Payments: $$8,997.26 \times 240 = \mathbf{$2,159,342.40}$
7. Total Lifetime Interest Paid: $$2,159,342.40 - $1,000,000 = \mathbf{$1,159,342.40}$

Over 20 years, interest charges exceed the original principal borrowed by $159,342.40. This occurs because the initial balance is large, compounding interest substantially during the first decade.

The amortization schedule shift: Interest vs. Principal

In a reducing-balance loan, every monthly payment is divided between interest and principal:

• Month 1:
  • Interest: $$1,000,000 \times 0.0075 = \mathbf{$7,500.00}$ (83.4% of your payment)
  • Principal Repaid: $$8,997.26 - $7,500.00 = \mathbf{$1,497.26}$ (16.6% of your payment)
  • Remaining Balance: $$1,000,000 - $1,497.26 = \mathbf{$998,502.74}$
• Month 120 (Year 10):
  • Remaining Balance: Approx. $$731,800$
  • Interest: Approx. $$5,488$ (61% of payment)
  • Principal Repaid: Approx. $$3,509$ (39% of payment)
• Month 240 (Final Payment):
  • Interest: Approx. $$67$ (0.7% of payment)
  • Principal Repaid: Approx. $$8,930$ (99.3% of payment)

How extra monthly prepayments save massive interest

Making extra principal prepayments bypasses future compounding interest completely. In the example above:

Adding just $500 per month toward principal pays off the loan nearly 3 years early and saves $213,630 in bank interest.

Frequently asked questions

Does EMI change if interest rates rise on a floating-rate loan?

Yes. On floating-rate or adjustable-rate loans, lenders typically increase the loan duration rather than the monthly payment. However, if the rate rises substantially, the monthly installment itself may increase.

What is the difference between a flat-rate and reducing-balance loan?

Flat-rate loans calculate interest on the full original principal for the entire duration, making them significantly more expensive than reducing-balance loans, where interest drops as the principal is repaid.

Can I prepay my loan at any time?

Most residential mortgages allow penalty-free prepayments, but some commercial or personal loans impose prepayment penalty fees during early lock-in periods. Always verify your lending agreement.