XLSDeal Logo XLSDeal Smart office solutions
EMILoan Planning & Amortization ← Back

Loan Parameters

Reducing Balance Method
₹
₹ 50,000₹ 1,00,00,000
%
4%20%
Yrs
1 Yr30 Yrs

Repayment Breakdown

240 Monthly Installments
Monthly EMI
₹ 0
Fixed monthly deduction
Principal Amount
₹ 0
Original borrowing
Total Interest Payable
₹ 0
Total cost of borrowing
Total Payment
₹ 0
Principal + Interest

Yearly Amortization Schedule

Annual principal repayment, interest cost, and remaining outstanding balance
Year Opening Balance Principal Paid Interest Paid Total Payment Ending Balance
EMI Formula, Reducing Balance Method & Home Loan Tax Benefits ▼

Equated Monthly Installment (EMI) is calculated on a reducing monthly balance where the interest is charged only on the remaining unpaid loan balance at the beginning of each month.

EMI = [P * r * (1 + r)^n] / [(1 + r)^n - 1]
Where: P = Principal loan amount, r = Monthly interest rate (annual rate / 12 / 100), n = Total number of monthly installments
  • Front-Loaded Interest: In the initial years of a loan, a massive portion of each EMI goes toward paying off interest rather than principal. As the principal reduces, the interest component decreases and principal repayment speeds up.
  • Section 24(b) Tax Deduction: For self-occupied residential property, you can claim up to ₹2 Lakhs per year as a deduction on home loan interest paid.
  • Section 80C Principal Benefit: Repayment of home loan principal is eligible for tax deduction under Section 80C within the overall ₹1.5 Lakhs limit.