HomeArticlesHow ToHow to Calculate Loan Amortization
HOW TO

How to Calculate Loan Amortization

Understand loan amortization step by step — how each EMI splits into principal and interest, how to read an amortization schedule, and how prepayments accelerate payoff.

Updated 2026-06-26

Overview

Amortization is the process of repaying a loan through a series of fixed periodic payments, where each payment covers both interest owed and a portion of the principal. The key feature: the payment amount stays constant, but the split between interest and principal shifts with every instalment. Early payments are heavily weighted toward interest; later payments shift toward principal repayment.

Understanding this split matters because it tells you exactly how much of your money is building equity versus paying the lender's cost of credit — and it shows you precisely where a prepayment delivers the most savings.

What You Need

Before building an amortization schedule, gather three numbers:

  • Loan principal (P): The amount borrowed — for example, Rs 50,00,000.
  • Annual interest rate: The reducing-balance rate quoted by your lender — for example, 8.5% per annum.
  • Tenure in months (n): Total number of EMIs — for example, 20 years = 240 months.

Step 1: Calculate the Monthly Interest Rate

Annual rates must be converted to a monthly rate before applying the EMI formula.

Formula:

r = Annual Rate / 12 / 100

Example — 8.5% annual rate:

r = 8.5 / 12 / 100 = 0.007083

This means each rupee of outstanding balance costs Rs 0.007083 in interest every month.

Step 2: Calculate the EMI

The standard reducing-balance EMI formula is:

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

Example — Rs 50,00,000 at 8.5% for 240 months:

(1 + 0.007083)^240 = 5.3175
EMI = 50,00,000 × 0.007083 × 5.3175 / (5.3175 − 1)
    = 50,00,000 × 0.007083 × 5.3175 / 4.3175
    = Rs 43,391

Every month, Rs 43,391 leaves your account. The proportion going to interest versus principal is what changes.

Use the loan-amortization-calculator-india to get this figure instantly without manual computation, and to generate the full schedule automatically.

Step 3: Build Month 1 of the Schedule

With principal, rate, and EMI in hand, month 1 is straightforward:

Field Calculation Amount
Opening balance Rs 50,00,000
Interest 50,00,000 × 0.007083 Rs 35,417
Principal 43,391 − 35,417 Rs 7,974
Closing balance 50,00,000 − 7,974 Rs 49,92,026

In month 1, only Rs 7,974 of your Rs 43,391 payment reduces your debt. Rs 35,417 — over 81% — goes to interest.

Step 4: Build Month 2 and Continue the Pattern

Month 2 starts from the closing balance of month 1:

Field Calculation Amount
Opening balance Rs 49,92,026
Interest 49,92,026 × 0.007083 Rs 35,360
Principal 43,391 − 35,360 Rs 8,031
Closing balance 49,92,026 − 8,031 Rs 49,83,995

The interest dropped by Rs 57 and the principal repaid increased by Rs 57. This shift is small each month but compounds over time. Repeat this for all 240 rows and you have a complete amortization schedule.

Step 5: Read the Full Schedule

Manually building 240 rows is tedious. The loan-amortization-calculator-india generates the complete schedule in seconds and lets you download it.

To see how dramatically the split changes over time, look at month 100 of the same Rs 50,00,000 loan:

Metric Month 1 Month 100 Month 200
Opening balance Rs 50,00,000 Rs 41,80,000 Rs 22,50,000
Interest portion Rs 35,417 Rs 29,600 Rs 15,940
Principal portion Rs 7,974 Rs 13,791 Rs 27,451

By month 200 of 240, more than 63% of each EMI is retiring principal. This is why the final years of a loan "feel faster" — you are actually making meaningful progress on the debt.

Step 6: Model Prepayments

A prepayment is any lump-sum payment made over and above the regular EMI. Because it directly reduces the outstanding principal, every future month's interest is recalculated on a lower base.

Example: A Rs 1,00,000 prepayment at month 12 on the same Rs 50,00,000 loan.

  • Outstanding balance at month 12 before prepayment: approximately Rs 49,04,000
  • After prepayment: Rs 48,04,000
  • All future interest is now calculated on Rs 48,04,000 instead of Rs 49,04,000
  • Estimated interest saving: approximately Rs 2.8 lakh over the remaining tenure
  • Estimated tenure reduction: approximately 18 months

Use the loan-prepayment-calculator-india to model exact savings for your loan amount, rate, and prepayment timing. Earlier prepayments save more because the interest clock runs longest on any amount prepaid early.

Why Amortization Front-Loads Interest

The front-loading of interest is not arbitrary — it is a mathematical consequence of charging interest on the outstanding balance. When the balance is at its maximum (month 1), the largest possible interest amount is deducted first, leaving the smallest slice for principal reduction. As the balance shrinks, interest shrinks, and the principal portion grows.

This has a practical implication: refinancing or making prepayments early in the loan tenure delivers the biggest savings. A prepayment at month 12 saves more than the same prepayment at month 120, because month-12 prepayment eliminates interest that would have compounded over 228 remaining months, versus only 120 months.

It also explains why borrowers who refinance a 10-year-old home loan to a lower rate are sometimes disappointed — a large share of the interest on that loan was already paid in the first decade. The remaining balance is smaller, so the absolute saving from a lower rate is reduced.

EMI vs Principal-Only vs Interest-Only Payments

Standard Indian home loans use the reducing-balance EMI method described above — the same fixed payment every month, with a shifting split. Two alternative structures sometimes appear in specialised products:

  • Interest-only payments: The borrower pays only interest each month; the full principal is due at maturity. Common in some overdraft products and construction-phase loans. No amortization occurs — the outstanding balance stays unchanged.
  • Principal-only payments: Rare in retail lending. If structured this way, each payment reduces the balance by a fixed principal amount, while the interest portion decreases every month. Total outflow is higher early but falls over time.

For virtually all retail home, car, and personal loans in India, you are on the standard EMI amortization schedule described in this guide.

Key Terms

  • Amortization — The process of paying off a debt through scheduled periodic payments that cover both interest and principal.
  • EMI — Equated Monthly Instalment; the fixed monthly payment amount calculated using the reducing-balance formula.
  • Principal — The original loan amount borrowed, or the outstanding balance yet to be repaid at any point in time.
  • Prepayment — A lump-sum payment made in addition to regular EMIs, which directly reduces the outstanding principal and future interest.

Related Tools

Frequently Asked Questions

In the early months, your outstanding loan balance is at its highest, so the interest component — calculated as a percentage of that balance — is also at its peak. As you make payments and the principal reduces, less interest accrues each month, and a larger share of the fixed EMI goes toward repaying principal. By the final few years of a 20-year loan, the split reverses completely, with principal making up over 90% of each EMI.
Set up five columns: Month, Opening Balance, EMI, Interest, Principal, and Closing Balance. In row 1, enter your loan amount as the opening balance, calculate interest as Opening Balance × monthly rate, and principal as EMI minus interest. The closing balance is Opening Balance minus Principal. Copy row 1 formulas down for all months, linking each row's opening balance to the previous row's closing balance. Use the PMT function in Excel to calculate your EMI automatically: =PMT(annual_rate/12, tenure_months, -loan_amount).
Most Indian lenders offer both options. Reducing tenure keeps your EMI the same but clears the loan earlier and saves more interest — this is generally the better financial choice. Reducing EMI lowers your monthly outflow but keeps the loan running longer. If cash flow is your constraint, choose EMI reduction; if you want to minimise total interest paid, choose tenure reduction. Use the [loan-prepayment-calculator-india](/loan-prepayment-calculator-india/) to compare both scenarios with exact numbers.
When the interest rate rises on a floating-rate loan, your lender recalculates the EMI (or extends tenure) based on the new rate and the current outstanding balance. Your previous amortization schedule becomes invalid from that point. You need a fresh schedule starting from the revised outstanding balance, the new rate, and the remaining tenure. The [loan-amortization-calculator-india](/loan-amortization-calculator-india/) lets you recalculate at any point by entering your current outstanding balance as the principal.
Partial prepayment means paying an additional lump sum over and above your regular EMI, which reduces the outstanding principal and saves future interest. Full prepayment means closing the entire outstanding balance in one shot, ending the loan. Partial prepayments are useful when you receive a bonus or windfall and want to reduce the loan burden without fully liquidating your savings. Most banks charge a prepayment penalty only on fixed-rate loans; floating-rate home loans in India are exempt from prepayment charges under RBI guidelines.
A flat-rate loan charges interest on the original principal throughout the tenure, not on the reducing balance. Interest = Principal × Annual Rate × Tenure in Years, and this total interest is divided equally across all EMIs. A 10% flat-rate loan is roughly equivalent to an 18–19% reducing-balance rate, making flat-rate loans significantly more expensive than they appear. Always convert a flat rate to its effective reducing-balance equivalent before comparing loan offers. The [home-loan-emi-calculator-india](/home-loan-emi-calculator-india/) uses the reducing-balance method, which is standard for home loans in India.
For most Indian bank loans, EMIs are calculated on a monthly cycle and interest is charged on the outstanding balance at the start of each month, so paying a few days early within the same billing month typically does not reduce interest. However, if you pay before the interest accrual date rather than on the due date, some lenders do credit the earlier payment and charge interest only until the payment date. Check your loan agreement or contact your lender to confirm the exact interest calculation method.
Yes. For a home loan, Section 24(b) of the Income Tax Act allows a deduction of up to Rs 2 lakh per year on interest paid for a self-occupied property, with no cap for let-out properties. Your amortization schedule's annual interest column gives you the exact figure to enter in your tax return. The principal repayment portion qualifies for deduction under Section 80C, subject to the Rs 1.5 lakh combined limit. Your lender also issues an annual interest certificate that matches these figures.
Indian home loans are almost always on a reducing-balance basis with monthly rests, meaning interest is computed on the outstanding balance at the start of each month. The EMI is fixed (unless the rate changes), and the principal-interest split shifts over time exactly as described in the standard amortization formula. For loans under the Pradhan Mantri Awas Yojana (PMAY), subsidy amounts are credited upfront, reducing the principal and therefore reducing every future interest charge — effectively creating a new, lower amortization schedule.
The mechanics are identical — the same EMI formula applies, and each payment splits into interest and principal on a reducing balance. The differences are practical: car loans have shorter tenures (3–7 years vs 10–30 years for home loans), so the interest-to-principal flip happens much faster. Car loans are also typically fixed-rate, so the amortization schedule stays unchanged for the full tenure. Additionally, some car financiers use flat-rate interest, which inflates the effective cost — always confirm with your dealer or lender.
During a moratorium, you stop making EMI payments but interest continues to accrue on the outstanding balance. This accumulated interest is either added to your principal (increasing your loan amount) or recovered through additional EMIs after the moratorium ends. Both options extend the effective loan tenure or increase EMI. After a moratorium, request a fresh amortization schedule from your lender based on the revised outstanding balance, as your original schedule will no longer be accurate.
A step-up loan has EMIs that increase at fixed intervals — for example, rising 5% every year to match expected salary growth. The amortization schedule looks similar to a standard one, but the EMI value changes at each step-up point. Because earlier EMIs are lower, a larger share goes to interest in the first few years compared to a standard equal-EMI loan of the same amount. Step-up loans are common in India for young borrowers; they allow a higher loan amount at the start with manageable early payments.

Related Articles

BEST OF

Best EMI Calculators India 2026

HOW TO

How to Calculate EMI

COMPARISON

Fixed vs Floating Rate Home Loan India

COMPARISON

Loan Prepayment vs Investing the Extra Cash

BEST OF

Best Free Loan Calculators Online 2026