Loan Amortization Calculator

A loan amortisation schedule breaks every EMI into the principal component that reduces outstanding balance and the interest component that is the lender’s revenue. In early years, most of the EMI is interest; later years the principal portion grows. The schedule helps with year-wise tax deductions and partial-prepayment decisions.

Each month, interest = outstanding principal × monthly rate (annual rate / 12 / 100). Principal portion = EMI - Interest. The outstanding balance for the next month = previous outstanding balance - principal portion. Calculator applies this formula for every EMI.

For a 20-year home loan, principal exceeds interest around month 130-150 (year 11-12). For shorter-tenure loans (5-7 years), the crossover happens earlier (year 2-3). Calculator highlights the crossover month and aggregates the principal-payout milestone year-by-year.

For home loan tax planning, Section 24(b) interest is deductible only on actual interest outflow during the year. Year-by-year aggregations match the deduction claim with actual cash outflow — keeping auditors happy and IT notices away.

Yes — copy the table from the calculator page into Excel / Sheets for further analysis. Many banks also provide the amortisation schedule PDF in the loan account portal. Calculator output is illustrative — cross-check with bank statements before filing ITR.

Prepayment reduces the outstanding principal; subsequent EMIs recalculate on the lower balance, resulting in lower EMI or shorter tenure. Calculator models the post-prepayment schedule and surfaces new principal/interest split for every year after the prepayment month.