Loan Amortization Schedule
Generate an indicative month-by-month principal and interest schedule.
Create ScheduleCalculate monthly installments, total interest, and total payment for any loan — Home, Business, Car, or Personal.
EMI (Equated Monthly Instalment) is the fixed amount you pay your lender every month until the loan is fully repaid. Each EMI consists of two components — a principal portion (repaying the borrowed amount) and an interest portion (cost of borrowing). In the early months of a loan, the interest component is high; as you repay, the principal portion increases and interest decreases.
EMI = P × R × (1+R)N / ((1+R)N – 1)
Loan: ₹10,00,000 at 10% p.a. for 5 years (60 months)
The table below shows the estimated monthly EMI for a ₹10 lakh loan at current typical interest rates from Indian banks.
| Loan Type | Typical Rate | 5-Year EMI (₹10L) |
10-Year EMI (₹10L) |
Total Interest (5 yr) |
|---|---|---|---|---|
| Home Loan | 8.5% – 9.5% | ₹20,517 | ₹12,400 | ₹2.31L |
| Business Loan | 10% – 14% | ₹21,247 | ₹13,215 | ₹2.75L |
| Car Loan | 9% – 12% | ₹20,758 | ₹12,668 | ₹2.45L |
| Personal Loan | 12% – 18% | ₹22,244 | ₹14,347 | ₹3.35L |
| Education Loan | 8% – 12% | ₹20,276 | ₹12,133 | ₹2.17L |
* Rates are indicative. Actual rates vary by bank, credit score, and loan amount. Use the calculator above with your bank's exact rate.
Higher the loan amount, higher the EMI. Doubling the loan amount doubles your EMI, keeping rate and tenure constant.
Even a 1% rate difference significantly impacts total interest. On ₹50L for 20 years, 1% extra = ₹6–7 lakh more interest.
Longer tenure = lower EMI but more total interest paid. Shorter tenure = higher EMI but significant interest savings.
A CIBIL score above 750 gets you lower interest rates. A 750 vs 650 score difference can mean 1–2% rate difference on business loans.
Most banks use the reducing balance method (interest on outstanding principal). Flat rate loans charge interest on the original amount throughout — effectively doubling the real rate.
Lenders often add 0.5–2% processing fees. These aren't included in EMI but increase the effective cost of borrowing.
This quick-reference table shows how changing the tenure affects your monthly EMI and total interest paid on a ₹10 lakh loan at 10% per annum.
| Tenure | Monthly EMI | Total Interest Paid | Total Amount Paid | Interest as % of Loan |
|---|---|---|---|---|
| 1 Year (12 months) | ₹87,916 | ₹54,990 | ₹10,54,990 | 5.5% |
| 2 Years (24 months) | ₹46,145 | ₹1,07,480 | ₹11,07,480 | 10.7% |
| 3 Years (36 months) | ₹32,267 | ₹1,61,620 | ₹11,61,620 | 16.2% |
| 5 Years (60 months) | ₹21,247 | ₹2,74,820 | ₹12,74,820 | 27.5% |
| 7 Years (84 months) | ₹16,601 | ₹3,94,480 | ₹13,94,480 | 39.4% |
| 10 Years (120 months) | ₹13,215 | ₹5,85,840 | ₹15,85,840 | 58.6% |
The shorter the tenure, the more you save in interest — though your monthly cash outflow is higher. Use the calculator above to find your ideal tenure.
Two-scenario comparison
Save the current result as A, change the inputs, then save the new result as B. Nothing is uploaded.
No result saved yet.
No result saved yet.
Transparent calculation
Important assumption: Rates, fees, taxes, timing and rounding can make an actual product result different.
Most calculation and document entries are processed in this browser. HSN search terms are sent to BharatERP only to return matching references. This shared tool layer does not send entered values to analytics.
Avoid entering passwords, bank credentials or unnecessary identity data. Outputs are estimates or editable templates—not legal, tax, investment, lending or accounting advice.
Recommended next step
Use this estimate for planning, then manage actual billing, accounting, inventory and reports in one business workflow. Available features depend on the selected paid plan.
Explore BharatERP PRO Schedule a Demo