Home Loan EMI Calculator

Plan your finances with accurate monthly EMI estimates and detailed repayment schedules.

Customer & Loan Details

Customer Name

Loan Amount (₹)

Interest Rate (% p.a.)

Period (Years)

Processing Fees (₹)

Date (DD/MM/YY)

EMI Details & Summary● LIVE CALCULATION

Customer NameCustomer

Loan Amount₹ 45,00,000

Interest Rate8.50% p.a.

Tenure240 Months (20 yrs)

Processing Fees₹ 0

Prepared ByNilesh Kute

Monthly EMI₹ 39,052

Principal Loan Amount

₹ 45,00,000

Total Interest Payable

₹ 48,72,491

Total Amount (Principal + Interest)

₹ 93,72,491

✦ Monthly Repayment Schedule

Month	Principal (₹)	Interest (₹)	Balance (₹)
1	7,177	31,875	44,92,823
2	7,228	31,824	44,85,595
3	7,279	31,773	44,78,316
4	7,331	31,721	44,70,985
5	7,383	31,669	44,63,603
6	7,435	31,617	44,56,168
7	7,488	31,565	44,48,680
8	7,541	31,511	44,41,140
9	7,594	31,458	44,33,546
10	7,648	31,404	44,25,898
11	7,702	31,350	44,18,196
12	7,756	31,296	44,10,440
Year 1	89,560	3,79,064	44,10,440
13	7,811	31,241	44,02,628
14	7,867	31,185	43,94,761
15	7,922	31,130	43,86,839
16	7,979	31,073	43,78,860
17	8,035	31,017	43,70,825
18	8,092	30,960	43,62,733
19	8,149	30,903	43,54,584
20	8,207	30,845	43,46,377
21	8,265	30,787	43,38,112
22	8,324	30,728	43,29,788
23	8,383	30,669	43,21,405
24	8,442	30,610	43,12,963
Year 2	97,477	3,71,148	43,12,963
25	8,502	30,550	43,04,461
26	8,562	30,490	42,95,899
27	8,623	30,429	42,87,276
28	8,684	30,368	42,78,592
29	8,745	30,307	42,69,847
30	8,807	30,245	42,61,040
31	8,870	30,182	42,52,170
32	8,933	30,120	42,43,238
33	8,996	30,056	42,34,242
34	9,059	29,993	42,25,182
35	9,124	29,928	42,16,059
36	9,188	29,864	42,06,870
Year 3	1,06,093	3,62,532	42,06,870
37	9,253	29,799	41,97,617
38	9,319	29,733	41,88,298
39	9,385	29,667	41,78,913
40	9,451	29,601	41,69,462
41	9,518	29,534	41,59,943
42	9,586	29,466	41,50,358
43	9,654	29,398	41,40,704
44	9,722	29,330	41,30,982
45	9,791	29,261	41,21,191
46	9,860	29,192	41,11,331
47	9,930	29,122	41,01,401
48	10,000	29,052	40,91,400
Year 4	1,15,470	3,53,154	40,91,400
49	10,071	28,981	40,81,329
50	10,143	28,909	40,71,186
51	10,214	28,838	40,60,972
52	10,287	28,765	40,50,685
53	10,360	28,692	40,40,325
54	10,433	28,619	40,29,892
55	10,507	28,545	40,19,385
56	10,581	28,471	40,08,804
57	10,656	28,396	39,98,147
58	10,732	28,320	39,87,416
59	10,808	28,244	39,76,608
60	10,884	28,168	39,65,723
Year 5	1,25,677	3,42,948	39,65,723
61	10,962	28,091	39,54,762
62	11,039	28,013	39,43,723
63	11,117	27,935	39,32,605
64	11,196	27,856	39,21,409
65	11,275	27,777	39,10,134
66	11,355	27,697	38,98,778
67	11,436	27,616	38,87,343
68	11,517	27,535	38,75,826
69	11,598	27,454	38,64,228
70	11,680	27,372	38,52,547
71	11,763	27,289	38,40,784
72	11,846	27,206	38,28,938
Year 6	1,36,786	3,31,839	38,28,938
73	11,930	27,122	38,17,007
74	12,015	27,037	38,04,992
75	12,100	26,952	37,92,892
76	12,186	26,866	37,80,707
77	12,272	26,780	37,68,435
78	12,359	26,693	37,56,076
79	12,447	26,606	37,43,629
80	12,535	26,517	37,31,094
81	12,623	26,429	37,18,471
82	12,713	26,339	37,05,758
83	12,803	26,249	36,92,955
84	12,894	26,158	36,80,062
Year 7	1,48,876	3,19,748	36,80,062
85	12,985	26,067	36,67,077
86	13,077	25,975	36,54,000
87	13,170	25,882	36,40,830
88	13,263	25,789	36,27,567
89	13,357	25,695	36,14,211
90	13,451	25,601	36,00,759
91	13,547	25,505	35,87,213
92	13,643	25,409	35,73,570
93	13,739	25,313	35,59,831
94	13,837	25,215	35,45,994
95	13,935	25,117	35,32,059
96	14,033	25,019	35,18,026
Year 8	1,62,035	3,06,589	35,18,026
97	14,133	24,919	35,03,893
98	14,233	24,819	34,89,661
99	14,334	24,718	34,75,327
100	14,435	24,617	34,60,892
101	14,537	24,515	34,46,355
102	14,640	24,412	34,31,714
103	14,744	24,308	34,16,970
104	14,849	24,204	34,02,122
105	14,954	24,098	33,87,168
106	15,060	23,992	33,72,108
107	15,166	23,886	33,56,942
108	15,274	23,778	33,41,668
Year 9	1,76,358	2,92,267	33,41,668
109	15,382	23,670	33,26,286
110	15,491	23,561	33,10,796
111	15,601	23,451	32,95,195
112	15,711	23,341	32,79,484
113	15,822	23,230	32,63,662
114	15,934	23,118	32,47,727
115	16,047	23,005	32,31,680
116	16,161	22,891	32,15,519
117	16,275	22,777	31,99,243
118	16,391	22,661	31,82,853
119	16,507	22,545	31,66,346
120	16,624	22,428	31,49,722
Year 10	1,91,946	2,76,678	31,49,722
121	16,742	22,311	31,32,981
122	16,860	22,192	31,16,120
123	16,980	22,073	30,99,141
124	17,100	21,952	30,82,041
125	17,221	21,831	30,64,820
126	17,343	21,709	30,47,477
127	17,466	21,586	30,30,012
128	17,589	21,463	30,12,422
129	17,714	21,338	29,94,708
130	17,840	21,213	29,76,868
131	17,966	21,086	29,58,903
132	18,093	20,959	29,40,809
Year 11	2,08,913	2,59,712	29,40,809
133	18,221	20,831	29,22,588
134	18,350	20,702	29,04,238
135	18,480	20,572	28,85,757
136	18,611	20,441	28,67,146
137	18,743	20,309	28,48,403
138	18,876	20,176	28,29,527
139	19,010	20,042	28,10,518
140	19,144	19,908	27,91,373
141	19,280	19,772	27,72,094
142	19,416	19,636	27,52,677
143	19,554	19,498	27,33,123
144	19,692	19,360	27,13,431
Year 12	2,27,379	2,41,246	27,13,431
145	19,832	19,220	26,93,599
146	19,972	19,080	26,73,627
147	20,114	18,938	26,53,513
148	20,256	18,796	26,33,256
149	20,400	18,652	26,12,857
150	20,544	18,508	25,92,312
151	20,690	18,362	25,71,622
152	20,836	18,216	25,50,786
153	20,984	18,068	25,29,802
154	21,133	17,919	25,08,669
155	21,282	17,770	24,87,387
156	21,433	17,619	24,65,954
Year 13	2,47,477	2,21,148	24,65,954
157	21,585	17,467	24,44,369
158	21,738	17,314	24,22,631
159	21,892	17,160	24,00,740
160	22,047	17,005	23,78,693
161	22,203	16,849	23,56,490
162	22,360	16,692	23,34,130
163	22,519	16,533	23,11,611
164	22,678	16,374	22,88,933
165	22,839	16,213	22,66,094
166	23,001	16,052	22,43,094
167	23,163	15,889	22,19,930
168	23,328	15,725	21,96,603
Year 14	2,69,351	1,99,273	21,96,603
169	23,493	15,559	21,73,110
170	23,659	15,393	21,49,451
171	23,827	15,225	21,25,624
172	23,996	15,057	21,01,628
173	24,166	14,887	20,77,463
174	24,337	14,715	20,53,126
175	24,509	14,543	20,28,617
176	24,683	14,369	20,03,934
177	24,858	14,195	19,79,077
178	25,034	14,018	19,54,043
179	25,211	13,841	19,28,832
180	25,389	13,663	19,03,443
Year 15	2,93,160	1,75,465	19,03,443
181	25,569	13,483	18,77,874
182	25,750	13,302	18,52,123
183	25,933	13,119	18,26,190
184	26,117	12,936	18,00,074
185	26,302	12,751	17,73,772
186	26,488	12,564	17,47,284
187	26,675	12,377	17,20,609
188	26,864	12,188	16,93,745
189	27,055	11,997	16,66,690
190	27,246	11,806	16,39,444
191	27,439	11,613	16,12,004
192	27,634	11,418	15,84,371
Year 16	3,19,072	1,49,552	15,84,371
193	27,829	11,223	15,56,541
194	28,027	11,025	15,28,515
195	28,225	10,827	15,00,289
196	28,425	10,627	14,71,865
197	28,626	10,426	14,43,238
198	28,829	10,223	14,14,409
199	29,033	10,019	13,85,376
200	29,239	9,813	13,56,137
201	29,446	9,606	13,26,691
202	29,655	9,397	12,97,036
203	29,865	9,187	12,67,171
204	30,076	8,976	12,37,095
Year 17	3,47,275	1,21,349	12,37,095
205	30,289	8,763	12,06,806
206	30,504	8,548	11,76,302
207	30,720	8,332	11,45,582
208	30,938	8,115	11,14,645
209	31,157	7,895	10,83,488
210	31,377	7,675	10,52,111
211	31,600	7,452	10,20,511
212	31,823	7,229	9,88,688
213	32,049	7,003	9,56,639
214	32,276	6,776	9,24,363
215	32,504	6,548	8,91,858
216	32,735	6,317	8,59,124
Year 18	3,77,971	90,653	8,59,124
217	32,967	6,085	8,26,157
218	33,200	5,852	7,92,957
219	33,435	5,617	7,59,522
220	33,672	5,380	7,25,850
221	33,911	5,141	6,91,939
222	34,151	4,901	6,57,788
223	34,393	4,659	6,23,395
224	34,636	4,416	5,88,759
225	34,882	4,170	5,53,877
226	35,129	3,923	5,18,749
227	35,378	3,674	4,83,371
228	35,628	3,424	4,47,743
Year 19	4,11,381	57,244	4,47,743
229	35,881	3,172	4,11,862
230	36,135	2,917	3,75,728
231	36,391	2,661	3,39,337
232	36,648	2,404	3,02,689
233	36,908	2,144	2,65,781
234	37,169	1,883	2,28,611
235	37,433	1,619	1,91,179
236	37,698	1,354	1,53,481
237	37,965	1,087	1,15,516
238	38,234	818	77,282
239	38,505	547	38,777
240	38,777	275	0
Year 20	4,47,743	20,882	0

Nilesh Kute | Home Loan Consultant | 8356008675 • www.loanwithnilesh.co.in
Indicative calculation only. Actual EMI, interest, fees, and schedule may vary based on lender policies and credit approval.