Loan Balance Calculator

Payment schedule

Loan Balance Calculator — every row, computed from the calculator's stated formula.

You are 60 EMIs in (year 5 of 20) — rows up to month 60 are already paid; the rest is what remains.

Year Principal Interest Balance
1 ₹6,380 ₹28,333 ₹39.94 L
2 ₹6,425 ₹28,288 ₹39.87 L
3 ₹6,470 ₹28,243 ₹39.81 L
4 ₹6,516 ₹28,197 ₹39.74 L
5 ₹6,562 ₹28,151 ₹39.68 L
6 ₹6,609 ₹28,104 ₹39.61 L
7 ₹6,656 ₹28,057 ₹39.54 L
8 ₹6,703 ₹28,010 ₹39.48 L
9 ₹6,750 ₹27,963 ₹39.41 L
10 ₹6,798 ₹27,915 ₹39.34 L
11 ₹6,846 ₹27,867 ₹39.27 L
12 ₹6,895 ₹27,818 ₹39.20 L
13 ₹6,943 ₹27,769 ₹39.13 L
14 ₹6,993 ₹27,720 ₹39.06 L
15 ₹7,042 ₹27,671 ₹38.99 L
16 ₹7,092 ₹27,621 ₹38.92 L
17 ₹7,142 ₹27,571 ₹38.85 L
18 ₹7,193 ₹27,520 ₹38.78 L
19 ₹7,244 ₹27,469 ₹38.71 L
20 ₹7,295 ₹27,418 ₹38.63 L
21 ₹7,347 ₹27,366 ₹38.56 L
22 ₹7,399 ₹27,314 ₹38.49 L
23 ₹7,451 ₹27,262 ₹38.41 L
24 ₹7,504 ₹27,209 ₹38.34 L
25 ₹7,557 ₹27,156 ₹38.26 L
26 ₹7,611 ₹27,102 ₹38.19 L
27 ₹7,665 ₹27,048 ₹38.11 L
28 ₹7,719 ₹26,994 ₹38.03 L
29 ₹7,774 ₹26,939 ₹37.95 L
30 ₹7,829 ₹26,884 ₹37.88 L
31 ₹7,884 ₹26,829 ₹37.80 L
32 ₹7,940 ₹26,773 ₹37.72 L
33 ₹7,996 ₹26,717 ₹37.64 L
34 ₹8,053 ₹26,660 ₹37.56 L
35 ₹8,110 ₹26,603 ₹37.48 L
36 ₹8,167 ₹26,546 ₹37.39 L
37 ₹8,225 ₹26,488 ₹37.31 L
38 ₹8,283 ₹26,429 ₹37.23 L
39 ₹8,342 ₹26,371 ₹37.15 L
40 ₹8,401 ₹26,312 ₹37.06 L
41 ₹8,461 ₹26,252 ₹36.98 L
42 ₹8,521 ₹26,192 ₹36.89 L
43 ₹8,581 ₹26,132 ₹36.81 L
44 ₹8,642 ₹26,071 ₹36.72 L
45 ₹8,703 ₹26,010 ₹36.63 L
46 ₹8,765 ₹25,948 ₹36.55 L
47 ₹8,827 ₹25,886 ₹36.46 L
48 ₹8,889 ₹25,824 ₹36.37 L
49 ₹8,952 ₹25,761 ₹36.28 L
50 ₹9,016 ₹25,697 ₹36.19 L
51 ₹9,080 ₹25,633 ₹36.10 L
52 ₹9,144 ₹25,569 ₹36.01 L
53 ₹9,209 ₹25,504 ₹35.91 L
54 ₹9,274 ₹25,439 ₹35.82 L
55 ₹9,340 ₹25,373 ₹35.73 L
56 ₹9,406 ₹25,307 ₹35.63 L
57 ₹9,472 ₹25,241 ₹35.54 L
58 ₹9,539 ₹25,174 ₹35.44 L
59 ₹9,607 ₹25,106 ₹35.35 L
60 ₹9,675 ₹25,038 ₹35.25 L
61 ₹9,744 ₹24,969 ₹35.15 L
62 ₹9,813 ₹24,900 ₹35.06 L
63 ₹9,882 ₹24,831 ₹34.96 L
64 ₹9,952 ₹24,761 ₹34.86 L
65 ₹10,023 ₹24,690 ₹34.76 L
66 ₹10,094 ₹24,619 ₹34.66 L
67 ₹10,165 ₹24,548 ₹34.55 L
68 ₹10,237 ₹24,476 ₹34.45 L
69 ₹10,310 ₹24,403 ₹34.35 L
70 ₹10,383 ₹24,330 ₹34.24 L
71 ₹10,456 ₹24,257 ₹34.14 L
72 ₹10,530 ₹24,183 ₹34.04 L
73 ₹10,605 ₹24,108 ₹33.93 L
74 ₹10,680 ₹24,033 ₹33.82 L
75 ₹10,756 ₹23,957 ₹33.71 L
76 ₹10,832 ₹23,881 ₹33.61 L
77 ₹10,908 ₹23,804 ₹33.50 L
78 ₹10,986 ₹23,727 ₹33.39 L
79 ₹11,064 ₹23,649 ₹33.28 L
80 ₹11,142 ₹23,571 ₹33.17 L
81 ₹11,221 ₹23,492 ₹33.05 L
82 ₹11,300 ₹23,413 ₹32.94 L
83 ₹11,380 ₹23,333 ₹32.83 L
84 ₹11,461 ₹23,252 ₹32.71 L
85 ₹11,542 ₹23,171 ₹32.60 L
86 ₹11,624 ₹23,089 ₹32.48 L
87 ₹11,706 ₹23,007 ₹32.36 L
88 ₹11,789 ₹22,924 ₹32.25 L
89 ₹11,873 ₹22,840 ₹32.13 L
90 ₹11,957 ₹22,756 ₹32.01 L
91 ₹12,041 ₹22,671 ₹31.89 L
92 ₹12,127 ₹22,586 ₹31.77 L
93 ₹12,213 ₹22,500 ₹31.64 L
94 ₹12,299 ₹22,414 ₹31.52 L
95 ₹12,386 ₹22,327 ₹31.40 L
96 ₹12,474 ₹22,239 ₹31.27 L
97 ₹12,562 ₹22,151 ₹31.15 L
98 ₹12,651 ₹22,062 ₹31.02 L
99 ₹12,741 ₹21,972 ₹30.89 L
100 ₹12,831 ₹21,882 ₹30.76 L
101 ₹12,922 ₹21,791 ₹30.63 L
102 ₹13,014 ₹21,699 ₹30.50 L
103 ₹13,106 ₹21,607 ₹30.37 L
104 ₹13,199 ₹21,514 ₹30.24 L
105 ₹13,292 ₹21,421 ₹30.11 L
106 ₹13,386 ₹21,327 ₹29.97 L
107 ₹13,481 ₹21,232 ₹29.84 L
108 ₹13,577 ₹21,136 ₹29.70 L
109 ₹13,673 ₹21,040 ₹29.57 L
110 ₹13,770 ₹20,943 ₹29.43 L
111 ₹13,867 ₹20,846 ₹29.29 L
112 ₹13,965 ₹20,748 ₹29.15 L
113 ₹14,064 ₹20,649 ₹29.01 L
114 ₹14,164 ₹20,549 ₹28.87 L
115 ₹14,264 ₹20,449 ₹28.73 L
116 ₹14,365 ₹20,348 ₹28.58 L
117 ₹14,467 ₹20,246 ₹28.44 L
118 ₹14,570 ₹20,143 ₹28.29 L
119 ₹14,673 ₹20,040 ₹28.15 L
120 ₹14,777 ₹19,936 ₹28.00 L
121 ₹14,881 ₹19,832 ₹27.85 L
122 ₹14,987 ₹19,726 ₹27.70 L
123 ₹15,093 ₹19,620 ₹27.55 L
124 ₹15,200 ₹19,513 ₹27.40 L
125 ₹15,307 ₹19,405 ₹27.24 L
126 ₹15,416 ₹19,297 ₹27.09 L
127 ₹15,525 ₹19,188 ₹26.93 L
128 ₹15,635 ₹19,078 ₹26.78 L
129 ₹15,746 ₹18,967 ₹26.62 L
130 ₹15,857 ₹18,856 ₹26.46 L
131 ₹15,970 ₹18,743 ₹26.30 L
132 ₹16,083 ₹18,630 ₹26.14 L
133 ₹16,197 ₹18,516 ₹25.98 L
134 ₹16,311 ₹18,401 ₹25.82 L
135 ₹16,427 ₹18,286 ₹25.65 L
136 ₹16,543 ₹18,170 ₹25.49 L
137 ₹16,661 ₹18,052 ₹25.32 L
138 ₹16,779 ₹17,934 ₹25.15 L
139 ₹16,897 ₹17,816 ₹24.98 L
140 ₹17,017 ₹17,696 ₹24.81 L
141 ₹17,138 ₹17,575 ₹24.64 L
142 ₹17,259 ₹17,454 ₹24.47 L
143 ₹17,381 ₹17,332 ₹24.29 L
144 ₹17,504 ₹17,209 ₹24.12 L
145 ₹17,628 ₹17,085 ₹23.94 L
146 ₹17,753 ₹16,960 ₹23.77 L
147 ₹17,879 ₹16,834 ₹23.59 L
148 ₹18,006 ₹16,707 ₹23.41 L
149 ₹18,133 ₹16,580 ₹23.23 L
150 ₹18,262 ₹16,451 ₹23.04 L
151 ₹18,391 ₹16,322 ₹22.86 L
152 ₹18,521 ₹16,192 ₹22.67 L
153 ₹18,652 ₹16,061 ₹22.49 L
154 ₹18,785 ₹15,928 ₹22.30 L
155 ₹18,918 ₹15,795 ₹22.11 L
156 ₹19,052 ₹15,661 ₹21.92 L
157 ₹19,187 ₹15,526 ₹21.73 L
158 ₹19,322 ₹15,390 ₹21.53 L
159 ₹19,459 ₹15,254 ₹21.34 L
160 ₹19,597 ₹15,116 ₹21.14 L
161 ₹19,736 ₹14,977 ₹20.95 L
162 ₹19,876 ₹14,837 ₹20.75 L
163 ₹20,017 ₹14,696 ₹20.55 L
164 ₹20,158 ₹14,555 ₹20.35 L
165 ₹20,301 ₹14,412 ₹20.14 L
166 ₹20,445 ₹14,268 ₹19.94 L
167 ₹20,590 ₹14,123 ₹19.73 L
168 ₹20,736 ₹13,977 ₹19.53 L
169 ₹20,882 ₹13,830 ₹19.32 L
170 ₹21,030 ₹13,683 ₹19.11 L
171 ₹21,179 ₹13,534 ₹18.89 L
172 ₹21,329 ₹13,384 ₹18.68 L
173 ₹21,480 ₹13,232 ₹18.47 L
174 ₹21,633 ₹13,080 ₹18.25 L
175 ₹21,786 ₹12,927 ₹18.03 L
176 ₹21,940 ₹12,773 ₹17.81 L
177 ₹22,096 ₹12,617 ₹17.59 L
178 ₹22,252 ₹12,461 ₹17.37 L
179 ₹22,410 ₹12,303 ₹17.15 L
180 ₹22,568 ₹12,145 ₹16.92 L
181 ₹22,728 ₹11,985 ₹16.69 L
182 ₹22,889 ₹11,824 ₹16.46 L
183 ₹23,051 ₹11,662 ₹16.23 L
184 ₹23,215 ₹11,498 ₹16.00 L
185 ₹23,379 ₹11,334 ₹15.77 L
186 ₹23,545 ₹11,168 ₹15.53 L
187 ₹23,712 ₹11,001 ₹15.29 L
188 ₹23,879 ₹10,833 ₹15.06 L
189 ₹24,049 ₹10,664 ₹14.82 L
190 ₹24,219 ₹10,494 ₹14.57 L
191 ₹24,391 ₹10,322 ₹14.33 L
192 ₹24,563 ₹10,150 ₹14.08 L
193 ₹24,737 ₹9,976 ₹13.84 L
194 ₹24,912 ₹9,800 ₹13.59 L
195 ₹25,089 ₹9,624 ₹13.34 L
196 ₹25,267 ₹9,446 ₹13.08 L
197 ₹25,446 ₹9,267 ₹12.83 L
198 ₹25,626 ₹9,087 ₹12.57 L
199 ₹25,807 ₹8,906 ₹12.31 L
200 ₹25,990 ₹8,723 ₹12.05 L
201 ₹26,174 ₹8,539 ₹11.79 L
202 ₹26,360 ₹8,353 ₹11.53 L
203 ₹26,546 ₹8,167 ₹11.26 L
204 ₹26,734 ₹7,978 ₹11.00 L
205 ₹26,924 ₹7,789 ₹10.73 L
206 ₹27,115 ₹7,598 ₹10.46 L
207 ₹27,307 ₹7,406 ₹10.18 L
208 ₹27,500 ₹7,213 ₹9.91 L
209 ₹27,695 ₹7,018 ₹9.63 L
210 ₹27,891 ₹6,822 ₹9.35 L
211 ₹28,089 ₹6,624 ₹9.07 L
212 ₹28,287 ₹6,425 ₹8.79 L
213 ₹28,488 ₹6,225 ₹8.50 L
214 ₹28,690 ₹6,023 ₹8.22 L
215 ₹28,893 ₹5,820 ₹7.93 L
216 ₹29,098 ₹5,615 ₹7.64 L
217 ₹29,304 ₹5,409 ₹7.34 L
218 ₹29,511 ₹5,202 ₹7.05 L
219 ₹29,720 ₹4,993 ₹6.75 L
220 ₹29,931 ₹4,782 ₹6.45 L
221 ₹30,143 ₹4,570 ₹6.15 L
222 ₹30,356 ₹4,357 ₹5.85 L
223 ₹30,571 ₹4,142 ₹5.54 L
224 ₹30,788 ₹3,925 ₹5.23 L
225 ₹31,006 ₹3,707 ₹4.92 L
226 ₹31,226 ₹3,487 ₹4.61 L
227 ₹31,447 ₹3,266 ₹4.30 L
228 ₹31,669 ₹3,043 ₹3.98 L
229 ₹31,894 ₹2,819 ₹3.66 L
230 ₹32,120 ₹2,593 ₹3.34 L
231 ₹32,347 ₹2,366 ₹3.02 L
232 ₹32,576 ₹2,137 ₹2.69 L
233 ₹32,807 ₹1,906 ₹2.36 L
234 ₹33,039 ₹1,673 ₹2.03 L
235 ₹33,274 ₹1,439 ₹1.70 L
236 ₹33,509 ₹1,204 ₹1.36 L
237 ₹33,747 ₹966 ₹1.03 L
238 ₹33,986 ₹727 ₹68,695
239 ₹34,226 ₹487 ₹34,469
240 ₹34,469 ₹244 ₹0

For information and education only; it is not investment advice and not a recommendation. The lender’s terms decide the actual figures. Every row is computed solely from the calculator’s stated formula and assumptions and the inputs you entered.