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, and how prepayments accelerate your payoff timeline.

Reviewed by the thecalcu.com team · Last updated August 4, 2026

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 payment amount stays constant, but the split between interest and principal shifts with every instalment: early payments lean heavily 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. What changes is the proportion going to interest versus principal.

The loan-amortization-calculator-india gets you this figure instantly without manual computation, and generates 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 (starting figure) 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 (from month 1 closing) 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

Interest dropped by Rs 57 and the principal repaid increased by Rs 57. The shift is small each month, but it 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 gets tedious fast. 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. That's why the final years of a loan feel faster: you're actually making meaningful progress on the debt by then.

Step 6: Model Prepayments

A prepayment is any lump-sum payment made over and above the regular EMI. Since it directly reduces the outstanding principal, every future month's interest gets 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 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

The loan-prepayment-calculator-india models 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 isn't arbitrary; it's a mathematical consequence of charging interest on the outstanding balance. When the balance sits at its maximum in month 1, the largest possible interest amount gets deducted first, leaving the smallest slice for principal reduction. As the balance shrinks, interest shrinks with it, and the principal portion grows.

There's a practical implication here: 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 the month-12 prepayment eliminates interest that would have compounded over 228 remaining months, versus only 120 months for the later one.

This also explains why borrowers who refinance a 10-year-old home loan to a lower rate sometimes feel disappointed. A large share of the interest on that loan was already paid off in the first decade, so the remaining balance is smaller, and the absolute saving from a lower rate shrinks along with it.

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 show up in specialised products occasionally:

  • Interest-only payments: The borrower pays only interest each month, and the full principal comes due at maturity. Common in some overdraft products and construction-phase loans. No amortization occurs here; 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 runs higher early but falls over time.

For virtually all retail home, car, and personal loans in India, you're 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

Why is most of my EMI going towards interest in the early months?
Your outstanding loan balance is at its highest in the early months, 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 instead. By the final few years of a 20-year loan, the split has reversed completely, with principal making up over 90% of each EMI.
How do I create a loan amortization schedule in Excel?
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, and use the PMT function to calculate EMI automatically: =PMT(annual_rate/12, tenure_months, -loan_amount).
Does making a prepayment reduce my EMI or my tenure?
Most Indian lenders offer both options. Reducing tenure keeps your EMI the same but clears the loan earlier and saves more interest, which is usually the better financial choice. Reducing EMI lowers your monthly outflow but keeps the loan running longer. Choose EMI reduction if cash flow is your constraint, and tenure reduction if you want to minimise total interest paid. The [loan-prepayment-calculator-india](/in/loan-prepayment-calculator/) compares both scenarios with exact numbers.
How does a rate hike mid-loan affect my amortization schedule?
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 stops being accurate from that point on. You need a fresh schedule starting from the revised outstanding balance, the new rate, and the remaining tenure. The [loan-amortization-calculator-india](/in/loan-amortization-calculator/) lets you recalculate at any point by entering your current outstanding balance as the principal.
What is the difference between partial prepayment and full prepayment?
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 and ending the loan. Partial prepayments suit a bonus or windfall situation, when you want to cut the loan burden without fully draining your savings. Most banks charge a prepayment penalty only on fixed-rate loans; floating-rate home loans in India are exempt under RBI guidelines.
How is amortization calculated for a flat-rate loan?
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 gets divided equally across all EMIs. A 10% flat-rate loan works out roughly equivalent to an 18 to 19% reducing-balance rate, which makes flat-rate loans considerably more expensive than they first appear. Convert a flat rate to its effective reducing-balance equivalent before comparing loan offers. The [home-loan-emi-calculator-india](/in/home-loan-emi-calculator/) uses the reducing-balance method, standard for home loans in India.
Does paying EMI earlier in the month save interest?
For most Indian bank loans, EMIs run on a monthly cycle with interest charged on the outstanding balance at the start of each month, so paying a few days early within the same billing month typically doesn't reduce interest. Some lenders do credit an earlier payment and charge interest only until the payment date, though, if you pay before the interest accrual date rather than the due date. Check your loan agreement or contact your lender to confirm the exact calculation method.
Can I claim a tax deduction on the interest shown in my amortization schedule?
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 under Section 80C, subject to the Rs 1.5 lakh combined limit, and your lender also issues an annual interest certificate matching these figures.
How does amortization work for a home loan in India specifically?
Indian home loans almost always run on a reducing-balance basis with monthly rests, meaning interest gets computed on the outstanding balance at the start of each month. The EMI stays fixed unless the rate changes, and the principal-interest split shifts over time exactly as the standard amortization formula describes. For loans under the Pradhan Mantri Awas Yojana (PMAY), subsidy amounts get credited upfront, reducing the principal and every future interest charge along with it, which effectively creates a new, lower amortization schedule.
How is car loan amortization different from home loan amortization?
The mechanics are identical: the same EMI formula applies, and each payment splits into interest and principal on a reducing balance. The differences show up in practice. Car loans run shorter tenures, 3 to 7 years versus 10 to 30 years for home loans, so the interest-to-principal flip happens much faster, and car loans are also typically fixed-rate, so the schedule stays unchanged for the full tenure. Some car financiers use flat-rate interest too, which inflates the effective cost, so always confirm with your dealer or lender.
What happens to my amortization schedule after a moratorium period?
During a moratorium, EMI payments stop but interest keeps accruing on the outstanding balance. That accumulated interest either gets added to your principal, increasing your loan amount, or gets recovered through additional EMIs once the moratorium ends. Both options extend the effective tenure or increase EMI. Request a fresh amortization schedule from your lender after a moratorium, based on the revised outstanding balance, since your original schedule won't be accurate anymore.
How does a step-up EMI loan show up in an amortization schedule?
A step-up loan has EMIs that increase at fixed intervals, say 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, since 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