Loan Prepayment Calculator
Month-by-month comparison
Loan Prepayment Calculator — every row, computed from the calculator's stated formula.
Rows show the loan WITH the ₹5.00 L prepayment applied; “Interest avoided” compares each month against the same loan without it, which runs all 240 months. At the unchanged EMI it clears in month 159 — every later row’s interest is avoided entirely.
| Year | Interest paid | Interest avoided | Balance |
|---|---|---|---|
| 1 | ₹18,750 | ₹3,750 | ₹24.92 L |
| 2 | ₹18,688 | ₹3,778 | ₹24.83 L |
| 3 | ₹18,626 | ₹3,806 | ₹24.75 L |
| 4 | ₹18,563 | ₹3,835 | ₹24.67 L |
| 5 | ₹18,500 | ₹3,864 | ₹24.58 L |
| 6 | ₹18,436 | ₹3,893 | ₹24.50 L |
| 7 | ₹18,372 | ₹3,922 | ₹24.41 L |
| 8 | ₹18,307 | ₹3,951 | ₹24.32 L |
| 9 | ₹18,242 | ₹3,981 | ₹24.24 L |
| 10 | ₹18,177 | ₹4,011 | ₹24.15 L |
| 11 | ₹18,111 | ₹4,041 | ₹24.06 L |
| 12 | ₹18,044 | ₹4,071 | ₹23.97 L |
| 13 | ₹17,977 | ₹4,102 | ₹23.88 L |
| 14 | ₹17,909 | ₹4,133 | ₹23.79 L |
| 15 | ₹17,841 | ₹4,164 | ₹23.70 L |
| 16 | ₹17,773 | ₹4,195 | ₹23.60 L |
| 17 | ₹17,703 | ₹4,226 | ₹23.51 L |
| 18 | ₹17,634 | ₹4,258 | ₹23.42 L |
| 19 | ₹17,564 | ₹4,290 | ₹23.32 L |
| 20 | ₹17,493 | ₹4,322 | ₹23.23 L |
| 21 | ₹17,422 | ₹4,354 | ₹23.13 L |
| 22 | ₹17,350 | ₹4,387 | ₹23.04 L |
| 23 | ₹17,277 | ₹4,420 | ₹22.94 L |
| 24 | ₹17,205 | ₹4,453 | ₹22.84 L |
| 25 | ₹17,131 | ₹4,487 | ₹22.74 L |
| 26 | ₹17,057 | ₹4,520 | ₹22.64 L |
| 27 | ₹16,983 | ₹4,554 | ₹22.54 L |
| 28 | ₹16,908 | ₹4,588 | ₹22.44 L |
| 29 | ₹16,832 | ₹4,623 | ₹22.34 L |
| 30 | ₹16,756 | ₹4,657 | ₹22.24 L |
| 31 | ₹16,679 | ₹4,692 | ₹22.14 L |
| 32 | ₹16,602 | ₹4,727 | ₹22.03 L |
| 33 | ₹16,524 | ₹4,763 | ₹21.93 L |
| 34 | ₹16,445 | ₹4,799 | ₹21.82 L |
| 35 | ₹16,366 | ₹4,835 | ₹21.72 L |
| 36 | ₹16,287 | ₹4,871 | ₹21.61 L |
| 37 | ₹16,206 | ₹4,907 | ₹21.50 L |
| 38 | ₹16,125 | ₹4,944 | ₹21.39 L |
| 39 | ₹16,044 | ₹4,981 | ₹21.28 L |
| 40 | ₹15,962 | ₹5,019 | ₹21.17 L |
| 41 | ₹15,879 | ₹5,056 | ₹21.06 L |
| 42 | ₹15,796 | ₹5,094 | ₹20.95 L |
| 43 | ₹15,712 | ₹5,132 | ₹20.84 L |
| 44 | ₹15,627 | ₹5,171 | ₹20.72 L |
| 45 | ₹15,542 | ₹5,210 | ₹20.61 L |
| 46 | ₹15,456 | ₹5,249 | ₹20.49 L |
| 47 | ₹15,369 | ₹5,288 | ₹20.38 L |
| 48 | ₹15,282 | ₹5,328 | ₹20.26 L |
| 49 | ₹15,194 | ₹5,368 | ₹20.14 L |
| 50 | ₹15,106 | ₹5,408 | ₹20.02 L |
| 51 | ₹15,017 | ₹5,449 | ₹19.90 L |
| 52 | ₹14,927 | ₹5,489 | ₹19.78 L |
| 53 | ₹14,837 | ₹5,531 | ₹19.66 L |
| 54 | ₹14,745 | ₹5,572 | ₹19.54 L |
| 55 | ₹14,654 | ₹5,614 | ₹19.41 L |
| 56 | ₹14,561 | ₹5,656 | ₹19.29 L |
| 57 | ₹14,468 | ₹5,698 | ₹19.17 L |
| 58 | ₹14,374 | ₹5,741 | ₹19.04 L |
| 59 | ₹14,279 | ₹5,784 | ₹18.91 L |
| 60 | ₹14,184 | ₹5,828 | ₹18.78 L |
| 61 | ₹14,088 | ₹5,871 | ₹18.65 L |
| 62 | ₹13,991 | ₹5,915 | ₹18.52 L |
| 63 | ₹13,893 | ₹5,960 | ₹18.39 L |
| 64 | ₹13,795 | ₹6,004 | ₹18.26 L |
| 65 | ₹13,696 | ₹6,049 | ₹18.13 L |
| 66 | ₹13,597 | ₹6,095 | ₹17.99 L |
| 67 | ₹13,496 | ₹6,141 | ₹17.86 L |
| 68 | ₹13,395 | ₹6,187 | ₹17.72 L |
| 69 | ₹13,293 | ₹6,233 | ₹17.59 L |
| 70 | ₹13,190 | ₹6,280 | ₹17.45 L |
| 71 | ₹13,087 | ₹6,327 | ₹17.31 L |
| 72 | ₹12,982 | ₹6,374 | ₹17.17 L |
| 73 | ₹12,877 | ₹6,422 | ₹17.03 L |
| 74 | ₹12,771 | ₹6,470 | ₹16.89 L |
| 75 | ₹12,665 | ₹6,519 | ₹16.74 L |
| 76 | ₹12,557 | ₹6,568 | ₹16.60 L |
| 77 | ₹12,449 | ₹6,617 | ₹16.45 L |
| 78 | ₹12,340 | ₹6,667 | ₹16.31 L |
| 79 | ₹12,230 | ₹6,717 | ₹16.16 L |
| 80 | ₹12,119 | ₹6,767 | ₹16.01 L |
| 81 | ₹12,008 | ₹6,818 | ₹15.86 L |
| 82 | ₹11,895 | ₹6,869 | ₹15.71 L |
| 83 | ₹11,782 | ₹6,920 | ₹15.56 L |
| 84 | ₹11,668 | ₹6,972 | ₹15.40 L |
| 85 | ₹11,553 | ₹7,025 | ₹15.25 L |
| 86 | ₹11,437 | ₹7,077 | ₹15.09 L |
| 87 | ₹11,321 | ₹7,130 | ₹14.94 L |
| 88 | ₹11,203 | ₹7,184 | ₹14.78 L |
| 89 | ₹11,085 | ₹7,238 | ₹14.62 L |
| 90 | ₹10,966 | ₹7,292 | ₹14.46 L |
| 91 | ₹10,845 | ₹7,347 | ₹14.30 L |
| 92 | ₹10,724 | ₹7,402 | ₹14.14 L |
| 93 | ₹10,602 | ₹7,457 | ₹13.97 L |
| 94 | ₹10,479 | ₹7,513 | ₹13.81 L |
| 95 | ₹10,356 | ₹7,569 | ₹13.64 L |
| 96 | ₹10,231 | ₹7,626 | ₹13.47 L |
| 97 | ₹10,105 | ₹7,683 | ₹13.30 L |
| 98 | ₹9,978 | ₹7,741 | ₹13.13 L |
| 99 | ₹9,851 | ₹7,799 | ₹12.96 L |
| 100 | ₹9,722 | ₹7,858 | ₹12.79 L |
| 101 | ₹9,593 | ₹7,917 | ₹12.62 L |
| 102 | ₹9,462 | ₹7,976 | ₹12.44 L |
| 103 | ₹9,331 | ₹8,036 | ₹12.26 L |
| 104 | ₹9,198 | ₹8,096 | ₹12.09 L |
| 105 | ₹9,065 | ₹8,157 | ₹11.91 L |
| 106 | ₹8,930 | ₹8,218 | ₹11.73 L |
| 107 | ₹8,795 | ₹8,280 | ₹11.54 L |
| 108 | ₹8,658 | ₹8,342 | ₹11.36 L |
| 109 | ₹8,521 | ₹8,404 | ₹11.18 L |
| 110 | ₹8,382 | ₹8,467 | ₹10.99 L |
| 111 | ₹8,243 | ₹8,531 | ₹10.80 L |
| 112 | ₹8,102 | ₹8,595 | ₹10.61 L |
| 113 | ₹7,961 | ₹8,659 | ₹10.42 L |
| 114 | ₹7,818 | ₹8,724 | ₹10.23 L |
| 115 | ₹7,674 | ₹8,790 | ₹10.04 L |
| 116 | ₹7,529 | ₹8,855 | ₹9.84 L |
| 117 | ₹7,383 | ₹8,922 | ₹9.65 L |
| 118 | ₹7,236 | ₹8,989 | ₹9.45 L |
| 119 | ₹7,088 | ₹9,056 | ₹9.25 L |
| 120 | ₹6,939 | ₹9,124 | ₹9.05 L |
| 121 | ₹6,788 | ₹9,193 | ₹8.85 L |
| 122 | ₹6,637 | ₹9,262 | ₹8.65 L |
| 123 | ₹6,484 | ₹9,331 | ₹8.44 L |
| 124 | ₹6,330 | ₹9,401 | ₹8.23 L |
| 125 | ₹6,175 | ₹9,471 | ₹8.03 L |
| 126 | ₹6,019 | ₹9,543 | ₹7.82 L |
| 127 | ₹5,862 | ₹9,614 | ₹7.60 L |
| 128 | ₹5,703 | ₹9,686 | ₹7.39 L |
| 129 | ₹5,544 | ₹9,759 | ₹7.18 L |
| 130 | ₹5,383 | ₹9,832 | ₹6.96 L |
| 131 | ₹5,221 | ₹9,906 | ₹6.74 L |
| 132 | ₹5,058 | ₹9,980 | ₹6.52 L |
| 133 | ₹4,893 | ₹10,055 | ₹6.30 L |
| 134 | ₹4,727 | ₹10,130 | ₹6.08 L |
| 135 | ₹4,560 | ₹10,206 | ₹5.86 L |
| 136 | ₹4,392 | ₹10,283 | ₹5.63 L |
| 137 | ₹4,223 | ₹10,360 | ₹5.40 L |
| 138 | ₹4,052 | ₹10,438 | ₹5.17 L |
| 139 | ₹3,880 | ₹10,516 | ₹4.94 L |
| 140 | ₹3,706 | ₹10,595 | ₹4.71 L |
| 141 | ₹3,532 | ₹10,674 | ₹4.47 L |
| 142 | ₹3,356 | ₹10,754 | ₹4.24 L |
| 143 | ₹3,179 | ₹10,835 | ₹4.00 L |
| 144 | ₹3,000 | ₹10,916 | ₹3.76 L |
| 145 | ₹2,820 | ₹10,998 | ₹3.52 L |
| 146 | ₹2,639 | ₹11,081 | ₹3.27 L |
| 147 | ₹2,456 | ₹11,164 | ₹3.03 L |
| 148 | ₹2,272 | ₹11,247 | ₹2.78 L |
| 149 | ₹2,087 | ₹11,332 | ₹2.53 L |
| 150 | ₹1,900 | ₹11,417 | ₹2.28 L |
| 151 | ₹1,712 | ₹11,502 | ₹2.03 L |
| 152 | ₹1,522 | ₹11,589 | ₹1.77 L |
| 153 | ₹1,331 | ₹11,676 | ₹1.52 L |
| 154 | ₹1,139 | ₹11,763 | ₹1.26 L |
| 155 | ₹945 | ₹11,851 | ₹99,910 |
| 156 | ₹749 | ₹11,940 | ₹73,668 |
| 157 | ₹553 | ₹12,030 | ₹47,228 |
| 158 | ₹354 | ₹12,120 | ₹20,591 |
| 159 | ₹154 | ₹12,211 | ₹0 |
| 160 | ₹0 | ₹12,256 | ₹0 |
| 161 | ₹0 | ₹12,145 | ₹0 |
| 162 | ₹0 | ₹12,034 | ₹0 |
| 163 | ₹0 | ₹11,922 | ₹0 |
| 164 | ₹0 | ₹11,809 | ₹0 |
| 165 | ₹0 | ₹11,695 | ₹0 |
| 166 | ₹0 | ₹11,580 | ₹0 |
| 167 | ₹0 | ₹11,464 | ₹0 |
| 168 | ₹0 | ₹11,348 | ₹0 |
| 169 | ₹0 | ₹11,231 | ₹0 |
| 170 | ₹0 | ₹11,112 | ₹0 |
| 171 | ₹0 | ₹10,993 | ₹0 |
| 172 | ₹0 | ₹10,873 | ₹0 |
| 173 | ₹0 | ₹10,752 | ₹0 |
| 174 | ₹0 | ₹10,631 | ₹0 |
| 175 | ₹0 | ₹10,508 | ₹0 |
| 176 | ₹0 | ₹10,384 | ₹0 |
| 177 | ₹0 | ₹10,260 | ₹0 |
| 178 | ₹0 | ₹10,134 | ₹0 |
| 179 | ₹0 | ₹10,008 | ₹0 |
| 180 | ₹0 | ₹9,880 | ₹0 |
| 181 | ₹0 | ₹9,752 | ₹0 |
| 182 | ₹0 | ₹9,623 | ₹0 |
| 183 | ₹0 | ₹9,493 | ₹0 |
| 184 | ₹0 | ₹9,361 | ₹0 |
| 185 | ₹0 | ₹9,229 | ₹0 |
| 186 | ₹0 | ₹9,096 | ₹0 |
| 187 | ₹0 | ₹8,962 | ₹0 |
| 188 | ₹0 | ₹8,826 | ₹0 |
| 189 | ₹0 | ₹8,690 | ₹0 |
| 190 | ₹0 | ₹8,553 | ₹0 |
| 191 | ₹0 | ₹8,415 | ₹0 |
| 192 | ₹0 | ₹8,275 | ₹0 |
| 193 | ₹0 | ₹8,135 | ₹0 |
| 194 | ₹0 | ₹7,994 | ₹0 |
| 195 | ₹0 | ₹7,851 | ₹0 |
| 196 | ₹0 | ₹7,707 | ₹0 |
| 197 | ₹0 | ₹7,563 | ₹0 |
| 198 | ₹0 | ₹7,417 | ₹0 |
| 199 | ₹0 | ₹7,270 | ₹0 |
| 200 | ₹0 | ₹7,122 | ₹0 |
| 201 | ₹0 | ₹6,973 | ₹0 |
| 202 | ₹0 | ₹6,823 | ₹0 |
| 203 | ₹0 | ₹6,672 | ₹0 |
| 204 | ₹0 | ₹6,520 | ₹0 |
| 205 | ₹0 | ₹6,366 | ₹0 |
| 206 | ₹0 | ₹6,211 | ₹0 |
| 207 | ₹0 | ₹6,055 | ₹0 |
| 208 | ₹0 | ₹5,898 | ₹0 |
| 209 | ₹0 | ₹5,740 | ₹0 |
| 210 | ₹0 | ₹5,581 | ₹0 |
| 211 | ₹0 | ₹5,420 | ₹0 |
| 212 | ₹0 | ₹5,259 | ₹0 |
| 213 | ₹0 | ₹5,096 | ₹0 |
| 214 | ₹0 | ₹4,931 | ₹0 |
| 215 | ₹0 | ₹4,766 | ₹0 |
| 216 | ₹0 | ₹4,599 | ₹0 |
| 217 | ₹0 | ₹4,431 | ₹0 |
| 218 | ₹0 | ₹4,262 | ₹0 |
| 219 | ₹0 | ₹4,092 | ₹0 |
| 220 | ₹0 | ₹3,920 | ₹0 |
| 221 | ₹0 | ₹3,747 | ₹0 |
| 222 | ₹0 | ₹3,572 | ₹0 |
| 223 | ₹0 | ₹3,397 | ₹0 |
| 224 | ₹0 | ₹3,220 | ₹0 |
| 225 | ₹0 | ₹3,041 | ₹0 |
| 226 | ₹0 | ₹2,862 | ₹0 |
| 227 | ₹0 | ₹2,681 | ₹0 |
| 228 | ₹0 | ₹2,499 | ₹0 |
| 229 | ₹0 | ₹2,315 | ₹0 |
| 230 | ₹0 | ₹2,130 | ₹0 |
| 231 | ₹0 | ₹1,943 | ₹0 |
| 232 | ₹0 | ₹1,755 | ₹0 |
| 233 | ₹0 | ₹1,566 | ₹0 |
| 234 | ₹0 | ₹1,375 | ₹0 |
| 235 | ₹0 | ₹1,183 | ₹0 |
| 236 | ₹0 | ₹990 | ₹0 |
| 237 | ₹0 | ₹795 | ₹0 |
| 238 | ₹0 | ₹598 | ₹0 |
| 239 | ₹0 | ₹400 | ₹0 |
| 240 | ₹0 | ₹201 | ₹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.