Loan EMI calculator with yearly repayment schedule

Monthly EMI

₹9,321

for 240 months

Principal 44.7%Interest 55.3%

Loan amount: ₹10,00,000
Total interest: ₹12,37,115
Total payment: ₹22,37,115

Uses the standard reducing-balance formula. Your lender’s figure may differ slightly because of rounding, fees or the first EMI date.

Year-by-year repayment schedule

Year 1 starts with your first EMI.

Year	Principal paid	Interest paid	Balance at year end	Loan paid off
1	₹17,609	₹94,246	₹9,82,391	2%
2	₹19,357	₹92,499	₹9,63,034	4%
3	₹21,278	₹90,578	₹9,41,755	6%
4	₹23,390	₹88,466	₹9,18,365	8%
5	₹25,711	₹86,144	₹8,92,654	11%
6	₹28,263	₹83,593	₹8,64,391	14%
7	₹31,068	₹80,787	₹8,33,322	17%
8	₹34,152	₹77,704	₹7,99,171	20%
9	₹37,541	₹74,315	₹7,61,629	24%
10	₹41,267	₹70,589	₹7,20,362	28%
11	₹45,363	₹66,493	₹6,75,000	33%
12	₹49,865	₹61,991	₹6,25,135	37%
13	₹54,814	₹57,042	₹5,70,321	43%
14	₹60,254	₹51,602	₹5,10,067	49%
15	₹66,234	₹45,622	₹4,43,833	56%
16	₹72,808	₹39,048	₹3,71,025	63%
17	₹80,034	₹31,822	₹2,90,991	71%
18	₹87,977	₹23,879	₹2,03,015	80%
19	₹96,708	₹15,147	₹1,06,306	89%
20	₹1,06,306	₹5,549	₹0	100%

How EMI is calculated

An equated monthly instalment stays the same every month, but what it pays for changes. Each month the lender charges interest on the balance still outstanding, and the rest of the EMI repays principal. The formula is EMI = P × r × (1 + r)ⁿ ÷ ((1 + r)ⁿ − 1), where P is the loan amount, r the monthly rate (annual rate ÷ 12 ÷ 100) and n the number of months.

For example, a ₹10,00,000 loan at 9.5% for 20 years has an EMI of ₹9,321. Over the full tenure you would pay ₹12,37,115 in interest — more than the loan itself — which is why a shorter tenure or early part-payments save so much.

Ways to reduce the interest you pay

Choose the shortest tenure you can afford. The EMI rises, but total interest falls sharply.
Make part-prepayments early. Money paid in the first years cuts the balance on which most interest is charged.
Compare the full cost, not only the rate. Processing fees, insurance and foreclosure terms change what a loan really costs.

FAQ

Questions about the loan emi calculator

Do this every day?Loan DSA CRM — Leads, bank logins & payouts for loan DSAs.See Loan DSA CRM

How is EMI calculated?

EMI = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), where P is the loan amount, r is the monthly interest rate (annual rate ÷ 12 ÷ 100) and n is the number of monthly instalments.

Why is most of the early EMI interest?

Interest is charged on the outstanding balance. At the start the balance is highest, so interest takes a larger share of each EMI; as the principal reduces, more of every EMI goes towards repaying it.

Does prepaying reduce my EMI or my tenure?

Lenders usually let you choose either. Reducing tenure saves more interest overall, while reducing the EMI eases monthly cash flow. Check your loan agreement for any prepayment terms.

Will my lender’s EMI match this calculator?

It should be very close. Small differences come from rounding, processing fees, insurance added to the loan or the date your first EMI is due. Your sanction letter has the final figures.

More free tools

Rooftop solar subsidy calculatorEstimate the central subsidy, net cost, monthly generation and payback period for a rooftop solar system under PM Surya Ghar. DSA commission calculatorCalculate a loan DSA’s payout on a disbursement, including GST on the invoice, TDS deducted by the lender and the sub-DSA partner’s share. GST invoice generatorCreate a GST tax invoice in your browser with automatic CGST, SGST or IGST, amount in words and GSTIN checks, then print or save it as PDF.

Let’s talk

Stop doing this in spreadsheets. Run it in Loan DSA CRM.

Book a 30-minute walkthrough with a product specialist. We’ll show you your own workflow — not a generic slide deck.

Book a free demo Chat on WhatsApp