Smart Loan EMI Calculator & Amortization Matrix

Retail banks in India (SBI, HDFC, ICICI, etc.) calculate EMI using the compound reducing balance formula: EMI = [P × R × (1+R)^N] / [(1+R)^N – 1], where P is Principal, R is the monthly interest rate (Annual Rate / 12 / 100), and N is the total tenure in months. With each payment, interest is charged only on the diminishing balance.

Under Reducing Balance (mandatory for retail bank loans), interest decreases as you repay principal. Under Flat Rate (often advertised by auto dealers or NBFCs), interest is calculated on the original loan amount for the entire tenure. An 8% flat rate is equivalent to an effective reducing rate (APR) of ~14.5% to 15.2%.

Prepayments go 100% towards reducing your principal balance immediately. For example, paying just one extra EMI per year or adding ₹5,000/month on a 20-year ₹50 Lakh home loan can save ₹12 Lakhs to ₹18 Lakhs in interest and shorten your tenure by over 4 to 6 years.

A moratorium is an interest-only grace period (typically 6 to 36 months) during property under-construction or education courses. The borrower pays only the interest charged on disbursed funds, deferring principal amortization until completion or regular employment begins.

A Balloon loan features significantly lower monthly installments during the loan tenure, with a predetermined lump-sum (bullet) balance paid at the maturity date. This structure is ideal for businesses expecting milestone capital receivables or automobile upgrade schemes.

Homebuyers under the Old Tax Regime can deduct up to ₹2,00,000 annually on interest payments under Section 24(b) for self-occupied properties, and claim up to ₹1,50,000 annually on principal repayment under Section 80C. Additional deductions may apply under Section 80EEA for eligible affordable homes.

Yes. Under Section 37(1) of the Income Tax Act, 1961, 100% of the interest paid on business working capital, machinery, and term loans is fully tax-deductible as an operational business revenue expense, directly reducing corporate taxable profits.

FOIR evaluates the percentage of your net monthly income already committed to existing and proposed loan EMIs. Most Indian lenders cap permissible FOIR between 40% and 55% of your net verifiable monthly income to ensure comfortable debt service capacity.

Under RBI Master Directions, banks and NBFCs cannot levy any prepayment penalties or foreclosure fees on floating-rate term loans granted to individual borrowers for non-business purposes. Fixed-rate loans or corporate business facilities may attract a 2% to 4% charge.

You can click 'CSV' to download a complete Microsoft Excel-ready file with UTF-8 BOM encoding and 13 columns of monthly amortization, or click 'PDF' to generate an official loan statement with SRI FILING letterhead, KPI badges, and RBI compliance stamps.