Question 1

What is an amortization schedule?

Accepted Answer

An amortization schedule is a complete month-by-month table showing how each EMI payment is divided between interest and principal repayment, and what your outstanding loan balance is after every payment. It lets you see exactly how much of your money goes toward the lender's profit versus reducing your actual debt. For a typical 20-year home loan in India, the first few years of the schedule will show that well over 70% of each payment is pure interest.

Question 2

Why does so much of my early EMI go toward interest?

Accepted Answer

In the early months of a loan your outstanding principal balance is at its highest, so the interest calculated on it is also at its highest. Since your EMI is fixed, the large interest charge leaves only a small amount to reduce the principal. As you pay down the principal, the monthly interest charge gradually decreases, freeing up more of each EMI to accelerate repayment. This structure — called front-loaded interest — means the actual debt reduction in year one is far smaller than it appears from your EMI amount alone.

Question 3

At what point in the loan does the principal portion exceed the interest portion?

Accepted Answer

The crossover point — where your monthly principal repayment first exceeds the monthly interest charge — occurs roughly at the midpoint of your loan tenure for a standard fixed-rate loan. For a 20-year home loan at 8.5%, this crossover typically happens around month 120 to 130. Before this point, more than half of each EMI is interest; after it, more than half goes toward reducing the principal. Your amortization schedule shows the exact month this shift occurs for your specific loan.

Question 4

How does a rate change affect my amortization schedule?

Accepted Answer

For floating-rate loans — which cover most home loans in India — a change in the benchmark interest rate (linked to RBI's repo rate via EBLR or MCLR) recalculates the interest portion of every future EMI. A 0.5% rate increase on a ₹50 lakh, 20-year home loan adds roughly ₹1,700 to the monthly interest charge in the early years and can increase total interest paid by over ₹4 lakh. The principal repayment portion shrinks proportionally, effectively extending the real cost of your loan even if the tenure stays the same.

Question 5

How do I read an amortization schedule table?

Accepted Answer

Each row in the schedule represents one month. The columns show: (1) the payment number or date, (2) the total EMI paid, (3) how much of that EMI is interest, (4) how much is principal repayment, and (5) the outstanding loan balance remaining after that payment. To find how much you have paid off at any point, subtract the outstanding balance column from your original loan amount. To see your cumulative interest cost to date, add up the interest column from row 1 to the current row.

Question 6

Does making a prepayment update the amortization schedule?

Accepted Answer

Yes — a lump-sum prepayment directly reduces your outstanding principal, which immediately lowers the interest charged in all subsequent months. Your lender will recalculate the schedule from the prepayment date. Depending on what you negotiate, either your EMI drops (same tenure, lower monthly outflow) or your tenure shortens (same EMI, fewer months). Prepaying in the first third of your loan tenure delivers the highest interest savings because the outstanding balance — and therefore the daily interest accumulation — is still very large.

Question 7

What is the total interest-to-principal ratio, and is mine healthy?

Accepted Answer

The interest-to-principal ratio compares the total interest you will pay over the full tenure to the original loan amount. For a ₹30 lakh home loan at 8.5% over 20 years, total interest comes to roughly ₹38.5 lakh — a ratio of about 1.28, meaning you pay back 2.28 times the original amount. Standard financial planning benchmarks treat a ratio below 0.50 as efficient, and above 0.80 as a signal to consider prepayment or a rate negotiation. Shorter tenures and lower rates both reduce this ratio significantly.

Year	Principal Paid	Interest Paid	Balance
Year 1	₹1,29,269	₹1,74,753	₹18,70,732
Year 2	₹1,41,395	₹1,62,626	₹17,29,338
Year 3	₹1,54,656	₹1,49,364	₹15,74,680
Year 4	₹1,69,165	₹1,34,856	₹14,05,515
Year 5	₹1,85,036	₹1,18,987	₹12,20,480
Year 6	₹2,02,392	₹1,01,631	₹10,18,088
Year 7	₹2,21,378	₹82,642	₹7,96,710
Year 8	₹2,42,145	₹61,877	₹5,54,565
Year 9	₹2,64,860	₹39,160	₹2,89,705
Year 10	₹2,89,704	₹14,318	₹0

Amortization Schedule Calculator — View Full Breakdown

Year-by-Year Amortization Schedule