Month-by-Month & Annual Trajectory • Printable Banking Schedule

Loan Amortization Schedule Calculator

Generate complete monthly and yearly repayment schedules with opening balances, monthly EMI, principal component, interest component, and closing balances.

Calendar Dated Installments•Annual & Monthly Views•100% Free & Private (0ms Local Engine)

Presets:

Amortization Inputs

0ms Local Engine

Loan Principal Amount

₹

₹1 Lakh₹25.00 L₹1 Crore

Interest Rate (% p.a.)

Tenure (Years)

Yrs

First EMI Month

First EMI Year

Monthly Loan Installment (EMI)180 Payments Total

₹24,618

Equated Monthly Installment for 15 years (180 months) starting 9/2026.

Total Interest Paid

₹19,31,412

Total Amount Paid

₹44,31,412

Amortization Quick Facts

First Month Interest

₹17,708

First Month Principal

₹6,910

📌 Notice: As shown below, in the final loan year, your monthly interest drops to nearly zero as payments almost entirely liquidate the principal.

Complete Amortization Schedule

Switch between consolidated annual view and detailed monthly installments.

Year	Opening Balance	Principal Paid	Interest Paid	Total EMI Paid	Closing Balance
Year 1	₹25,00,000	₹86,227	₹2,09,189	₹2,95,416	₹24,13,776
Year 2	₹24,13,776	₹93,845	₹2,01,571	₹2,95,416	₹23,19,931
Year 3	₹23,19,931	₹1,02,141	₹1,93,275	₹2,95,416	₹22,17,791
Year 4	₹22,17,791	₹1,11,169	₹1,84,247	₹2,95,416	₹21,06,622
Year 5	₹21,06,622	₹1,20,995	₹1,74,421	₹2,95,416	₹19,85,628
Year 6	₹19,85,628	₹1,31,689	₹1,63,727	₹2,95,416	₹18,53,938
Year 7	₹18,53,938	₹1,43,330	₹1,52,086	₹2,95,416	₹17,10,608
Year 8	₹17,10,608	₹1,55,997	₹1,39,419	₹2,95,416	₹15,54,609
Year 9	₹15,54,609	₹1,69,789	₹1,25,627	₹2,95,416	₹13,84,822
Year 10	₹13,84,822	₹1,84,795	₹1,10,621	₹2,95,416	₹12,00,026
Year 11	₹12,00,026	₹2,01,130	₹94,286	₹2,95,416	₹9,98,897
Year 12	₹9,98,897	₹2,18,908	₹76,508	₹2,95,416	₹7,79,989
Year 13	₹7,79,989	₹2,38,257	₹57,159	₹2,95,416	₹5,41,732
Year 14	₹5,41,732	₹2,59,317	₹36,099	₹2,95,416	₹2,82,415
Year 15	₹2,82,415	₹2,82,415	₹13,177	₹2,95,592	₹0

Understanding Your Amortization Schedule

How to read your repayment schedule and plan for tax savings.

1. The “Tipping Point” in Loan Repayment

Every reducing-balance loan has a crucial milestone called the Amortization Tipping Point. This is the exact month when your monthly principal repayment exceeds the interest component for the first time. For a 20-year home loan at 8.5%, this tipping point typically arrives around Year 9 or 10. After this milestone, your equity growth accelerates rapidly.

2. Tracking Tax Exemption Thresholds

You can use the Year-by-Year Amortization Table to monitor your tax caps under the Old Tax Regime:

Section 24(b) Max ₹2,00,000: In early loan years, annual interest easily exceeds ₹2 Lakhs, enabling you to claim the full deduction.
Section 80C Max ₹1,50,000: In early years, principal repayments are smaller (e.g. ₹60,000–₹90,000), leaving room for PPF and ELSS under your 80C envelope. In later years, principal repayments exceed ₹1.5 Lakhs.

Frequently Asked Questions about Loan Amortization

Mastering the mechanics of loan repayment schedules.

What is a Loan Amortization Schedule?

A loan amortization schedule is an itemized breakdown of every scheduled loan installment throughout its life. It reveals the exact monetary split between principal repayment and interest charges, along with the progressive closing balance after each installment.

Why does interest comprise most of the EMI in early years?

Because interest is computed as a monthly percentage of your remaining principal balance. In the initial loan period, your outstanding principal is at its maximum, resulting in higher monthly interest. As consecutive installments gradually lower the principal, the interest share declines and principal equity surges.

Can I use this amortization schedule to verify my bank interest certificate?

Yes. The annual amortization totals generated by this calculator correspond closely to the provisional and final interest certificates issued by banks (SBI, HDFC, ICICI, etc.) for Section 80C and Section 24(b) income tax filings.

How do interest rate revisions affect the amortization table?

When the RBI changes the repo rate and lenders modify their external benchmark lending rate (EBLR), banks typically adjust the loan tenure (extending or shortening months) rather than altering the monthly EMI. A higher rate shifts the amortization curve, allocating more of each payment to interest.

What is the formula used for each month’s interest calculation?

Monthly Interest = [Outstanding Principal × Annual Interest Rate] ÷ [12 × 100]. Monthly Principal Repayment = [Monthly EMI - Monthly Interest]. The new closing balance equals [Opening Principal - Principal Repayment].

Suite Directory

100% free, privacy-first calculators built for Indian taxpayers, salaried professionals, and investors.

Live Tool

Loans & Credit