Car Loan Amortisation Schedule in India — Reading Every Column, Timing Your Pre-Payment

An amortisation schedule is a table that shows, for every month of the loan, four things: the opening balance (also called outstanding principal at start of month), the EMI amount, the split of that EMI into interest and principal repayments, and the closing balance (outstanding principal at end of month). Some schedules add columns for cumulative interest, cumulative principal, and the sanctioned EMI number for sequencing.

The schedule is computed using the reducing-balance method — the standard across Indian retail car loans from SBI, HDFC Bank, ICICI Bank, Axis Bank, Kotak Mahindra Bank, Bank of Baroda, Union Bank and every meaningful Indian NBFC (Mahindra Finance, Tata Capital, Chola, Shriram). The formula is straightforward: interest for a month equals the opening principal balance multiplied by the monthly interest rate (annual rate divided by 12). The principal repayment for that month is the EMI minus the interest. The closing balance is the opening balance minus the principal repayment.

That single calculation, repeated 60 times (for a 5-year loan) or 84 times (for a 7-year loan), produces the entire schedule. The magic — and the asymmetry — comes from the fact that as the principal balance falls, the interest portion of each subsequent EMI also falls, which means a bigger chunk of the same fixed EMI goes to principal repayment.

Most Indian bank amortisation schedules have the following eight columns, in approximately this order.

1. Month / Instalment Number — numbered 1 through 60 (or 84, or whatever your tenure is). This is the sequence of your EMI payments.

2. Payment Due Date — the date your bank will debit the EMI from your linked account (usually 5th, 7th, 10th or 15th of each month, depending on the auto-debit mandate you signed).

3. Opening Principal Balance — the outstanding principal at the start of the month before the EMI is paid. In month 1 this equals your loan amount. In each subsequent month it equals the closing balance of the previous month.

4. EMI Amount — your fixed monthly payment, calculated by the bank using the formula P × r × (1+r)^n / ((1+r)^n − 1) where P is loan amount, r is monthly rate, n is number of months.

5. Interest Component — opening balance × monthly interest rate. This is the portion of the EMI that pays for the use of the outstanding money; it is income to the bank.

6. Principal Component — EMI minus interest component. This is the portion that actually reduces your debt.

7. Closing Principal Balance — opening balance minus principal component. This becomes the opening balance of the next month.

8. Cumulative Interest Paid (running total) — the sum of interest components from month 1 through this month. This is the most important column for judging the true cost of the loan at any point.

Some schedules add a ninth column for Cumulative Principal Paid, which when added to Closing Balance should exactly equal the original loan amount — a quick arithmetic check that the schedule is internally consistent.

Take a 2026 representative Indian car loan. Loan amount ₹8 Lakh (typical for a mid-range hatchback or compact SUV after down payment). Tenure 60 months. Interest rate 9.5 percent reducing balance. No processing fee assumed for simplicity. EMI works out to ₹16790.

Total amount paid over 60 months = 60 × 16790 = ₹10,07,380.

Total interest paid = ₹10,07,380 − ₹8,00,000 = ₹2,07,380.

So on an ₹8 Lakh loan you pay ₹2.07 Lakh in interest over 5 years — about 25.9 percent of the principal in total interest. Now look at how that ₹2.07 Lakh is distributed across the 60 months.

Notice the pattern. In month 1 you pay ₹6333 of interest and ₹10457 of principal — the interest is 37.7 percent of your EMI. By month 24, interest has fallen to ₹4001 (23.8 percent). By month 48, interest is only ₹1115 (6.6 percent). By month 60, interest is a rounding error (₹131).

Total interest in year 1 of the loan = approximately ₹67800. Total interest in year 5 of the loan = approximately ₹8800. Year 1 pays roughly 7.7 times more interest than year 5 — that is what 'front-loaded' means in concrete rupees.

The front-loading is not a bank trick or an Indian-specific quirk. It is a direct arithmetic consequence of reducing-balance amortisation.

At the start of month 1, the bank is lending you ₹8 Lakh. For the full month, you are using the bank's ₹8 Lakh. The interest for that month — at an annual rate of 9.5 percent or a monthly rate of 0.7917 percent — is 0.7917 percent of ₹8 Lakh = ₹6333. That is the price of having ₹8 Lakh of the bank's money for a month.

At the start of month 59 (near end of loan), you have only ₹33000-odd outstanding. For that month you are using only ₹33000 of the bank's money. The interest is 0.7917 percent of ₹33000 = roughly ₹262. The price of having ₹33000 for a month is obviously much less than the price of having ₹8 Lakh for a month.

Your EMI stays fixed at ₹16790 throughout because the bank smoothed the repayment curve. Mathematically the bank could charge you ₹22800 in month 1 and ₹17050 by month 60 (equal monthly principal payments with varying EMI), but that would be a nightmare to budget. Fixed EMI is a borrower-friendly convenience, not a magic trick.

What front-loading really means is simple — you pay more interest early because you owe more early. Every rupee you pre-pay early saves the compounded interest on that rupee for the rest of the tenure. Every rupee pre-paid late saves less because there is less tenure left over which interest could have accrued.

This is why pre-payment timing matters so much, and why lenders welcome early pre-payments (they have already earned most of the interest) but less keenly welcome late pre-payments (the borrower is swapping low-future-interest for a capital return).

If you receive a bonus, a tax refund, a windfall or any chunk of money and want to use it wisely on the car loan, the best return on that money is in the first half of your tenure.

The mechanics: a ₹1 Lakh part-payment made in month 12 of our example loan saves roughly ₹23000 in total interest over the remaining life of the loan. The same ₹1 Lakh part-payment made in month 36 saves roughly ₹8500. The same ₹1 Lakh part-payment made in month 54 saves roughly ₹1200. The earlier you pre-pay, the longer the interest savings run.

Month 12 to month 30 is where the combination of remaining tenure (48 to 30 months left) and your outstanding principal (still 7.2 Lakh to 4.4 Lakh) gives the sweet spot — both levers work in your favour.

Month 1 to month 6 is marginally better than month 12 to 30 on pure interest arithmetic, but you have just bought the car and usually do not have disposable lump sums then.

Month 45 onwards the incremental benefit of pre-payment drops sharply. By month 54 your outstanding balance is around 1 Lakh — a 1 Lakh pre-payment clears the loan but saves only a month or two of the remaining interest. You are better off keeping that cash working elsewhere.

When you make a part-payment (any lump sum smaller than the full outstanding), RBI's Master Circular allows the bank to give you two options — reduce the remaining EMI keeping the tenure fixed, or keep the EMI fixed and reduce the remaining tenure. The choice is yours and is material.

Reduce tenure option — your EMI stays at ₹16790. Your remaining tenure drops. You save more total interest because the loan ends earlier and each remaining month has a full EMI of which a bigger chunk now goes to principal. This is the default most financial planners recommend.

Reduce EMI option — your EMI drops to a new smaller number. Your tenure stays the same. Your cash-flow improves but your total interest saving is smaller because the loan runs the same number of months with a slightly-bigger-interest accumulation.

On our ₹8 Lakh loan with a ₹1 Lakh pre-payment at month 24, the reduce-tenure option saves around ₹14500 of interest. The reduce-EMI option saves around ₹7000 of interest. Identical pre-payment, materially different savings.

Always ask the bank which default they will apply. Many banks pick reduce-EMI silently unless you tell them otherwise because it reduces your monthly outflow (which keeps borrowers happier) and retains more interest for the bank. Specify reduce-tenure in writing if that is your preference.

For the separate fee question — whether the bank will charge you to make this part-payment — RBI's rules on floating-rate vehicle loans prohibit pre-payment charges. Fixed-rate loans may carry 2-5 percent pre-payment penalty plus 18 percent GST. Read your sanction letter carefully; covered in depth in our guide to car loan pre-closure charges and RBI rules.

Indian retail car lending is governed by RBI's Master Circular on Retail Advances, the Banking Regulation Act 1949 Section 21 (which empowers RBI to regulate lending terms), the Consumer Protection Act 2019 (for fair-dealing obligations), and the Fair Practices Code that every bank and NBFC must adopt.

Under these frameworks, the following must be disclosed in writing at sanction — the effective interest rate (not just the nominal rate), the full amortisation schedule, every fee and charge separately itemised, the pre-payment and foreclosure terms including any charges, and the formal grievance-redress procedure.

RBI circulars after 2014 specifically prohibit banks and NBFCs from levying pre-payment penalties on floating-rate vehicle loans. Fixed-rate vehicle loans may carry a pre-payment charge but it must be disclosed upfront.

Your KFS (Key Facts Statement) is the summary document that RBI requires since 2024 to accompany any retail-lending sanction. It is a one-page summary of rate, tenure, EMI, total cost, pre-payment terms and grievance contact. Read it before signing anything else.

If the bank refuses to provide a printed amortisation schedule or KFS, you have two escalation paths. First, raise it internally through the bank's grievance-redressal contact. Second, escalate to the Banking Ombudsman under the Reserve Bank Integrated Ombudsman Scheme 2021. The RBI Ombudsman is free to approach and handles car-loan disputes routinely.

If you plan to sell your car before the loan is fully repaid, the amortisation schedule is your single most important reference document. Look at the Closing Balance column for the month in which you plan to sell — that is the amount you need to clear with the bank before (or at) the transfer of ownership.

Say you plan to sell your car at month 36 of the 60-month loan. The Closing Balance column for month 36 shows ₹3,17,818. That is what you owe the bank. Your sale process works as follows — you find a buyer willing to pay a price X for the car, X must be at least ₹3,17,818 plus your transfer costs, the buyer pays the bank directly (through the bank's 'Loan Closure and NOC' procedure), the bank issues the No Objection Certificate, and the RC is transferred. In practice banks handle this through a specific Loan Clearance Letter process.

A second use — it gives you the negotiation floor. If the market price for your 36-month-old car is ₹3.5 Lakh and your outstanding is ₹3.17 Lakh, you know you have roughly ₹33000 of room above the loan clearance. Discount anything below that floor and you are paying out of pocket to complete the sale.

For the legal mechanics of selling a car with an active loan on it in India, our guide on how to sell a car with an active loan walks through the documentation sequence — Loan Clearance Letter, Form 28/29/30, NOC from financer — and the typical 2-3 week timeline.

A third use — pre-sale pre-payment. If you plan to sell in month 40 but have ₹1 Lakh of savings in month 32, a pre-payment brings down the outstanding you will need to clear at sale time. This is particularly useful if your car's market value is close to the outstanding — you pre-pay to create headroom.

Before you sign, spot-check the schedule with three quick tests.

Test 1 — EMI formula check. Compute the EMI yourself using the standard formula: EMI = P × r × (1+r)^n / ((1+r)^n − 1), where P is the loan amount, r is monthly rate (annual / 12 / 100), n is number of months. For ₹8 Lakh / 60 months / 9.5 percent, you should get about ₹16790. If the schedule's EMI is materially different, challenge the bank to explain the difference.

Test 2 — Month-1 interest check. Multiply the loan amount by the monthly rate. For ₹8 Lakh and 9.5/12/100 = 0.007917 monthly, the month-1 interest should be ₹8,00,000 × 0.007917 = ₹6333. The schedule's month-1 interest column should match this. If it doesn't, either the rate is higher than quoted or the principal is higher than quoted.

Test 3 — Closing balance check. Sum all the principal-component entries in the schedule. They should add up to the original loan amount. Sum all the interest entries. They should add up to the total interest (difference between total payments and principal). If either test fails the schedule is arithmetically wrong and the bank must reissue it.

Test 4 (dealer-arranged loans specifically) — effective cost check. Some dealer-arranged loans bundle a higher nominal rate with bundled insurance, extended warranty or accessories that inflate the loan amount. Compare the quoted rate with the rate you would get directly from a bank like SBI or HDFC. If the dealer rate is more than 0.5-1 percent above the direct-bank rate, ask for the itemised breakup and consider going direct.

For the broader problem of hidden costs in Indian car financing (beyond just the amortisation), our guide on checking car challan and loan status covers adjacent verifications that matter after the loan has been disbursed.

Indian lenders offer 3, 5 and 7-year car-loan tenures. Some NBFCs and luxury-finance arms offer 8-9 years. The longer the tenure, the smaller the monthly EMI, but the larger the total interest. Amortisation helps you see the trade-off in actual rupees.

Same ₹8 Lakh loan, same 9.5 percent rate, three tenures.

Going from 5 years to 7 years saves you ₹3710 per month in EMI — an attractive 22 percent reduction in monthly cash outflow. But the total interest increases by ₹91580 — a 44 percent jump. The extra 2 years cost you roughly ₹46000 per year of extra interest.

The right tenure is the one that gives you a comfortable EMI (typically not more than 15-20 percent of your monthly take-home) without extending your loan beyond the reasonable useful life of the car. A 7-year loan on a ₹8 Lakh car means you are still paying EMIs in year 7, when the car might already be worth half what it was at purchase and might need an expensive annual service.

5 years is the Indian sweet spot for most buyers — manageable EMI, moderate total interest, loan ends while the car still has meaningful useful life. Only go to 7 years if the EMI in year 1 would otherwise strain your budget and you have a plan to refinance or pre-pay later. Never go to 7 years purely to afford a fancier car; that is how Indian buyers end up underwater on their loans in year 4 or 5.

For the total-cost-of-ownership lens across different Indian fuel types, our petrol vs diesel break-even guide combines loan-interest maths with running-cost maths to give a complete picture.