NOTE 1.
Yellow Cell is RATE OF INTEREST - change according to what your banker says
2.Blue Cell shows the tallying of EMI & Rate of Interest - it should come in between -30 to +30
3. Green Cell is the EMI Amount - change accordingly till you get desired range in Blue Cell
4.Red Cell is Loan amount is 8Lakhs - change as per your requirement
5. Here Interest rate taken as 9.5% for 3Y, 9.75% for 4Y and 10% for 5Y loan term
3 YEARS LOAN TERM 4 YEARS LOA
0.007917 25626 14.91907
1 800000 6333.333 806333.3 25626 780707.3 1 800000
2 780707.3 6180.6 786887.9 25626 761261.9 2 786306
3 761261.9 6026.657 767288.6 25626 741662.6 3 772500.7
4 741662.6 5871.496 747534.1 25626 721908.1 4 758583.3
5 721908.1 5715.106 727623.2 25626 701997.2 5 744552.8
6 701997.2 5557.478 707554.7 25626 681928.7 6 730408.3
7 681928.7 5398.602 687327.3 25626 661701.3 7 716148.9
8 661701.3 5238.468 666939.7 25626 641313.7 8 701773.6
9 641313.7 5077.067 646390.8 25626 620764.8 9 687281.5
10 620764.8 4914.388 625679.2 25626 600053.2 10 672671.6
11 600053.2 4750.421 604803.6 25626 579177.6 11 657943.1
12 579177.6 4585.156 583762.8 25626 558136.8 12 643094.9
13 558136.8 4418.583 562555.4 25626 536929.4 13 628126
14 536929.4 4250.691 541180 25626 515554 14 613035.5
15 515554 4081.47 519635.5 25626 494009.5 15 597822.5
16 494009.5 3910.909 497920.4 25626 472294.4 16 582485.8
17 472294.4 3738.998 476033.4 25626 450407.4 17 567024.5
18 450407.4 3565.725 453973.1 25626 428347.1 18 551437.5
19 428347.1 3391.082 431738.2 25626 406112.2 19 535724
20 406112.2 3215.055 409327.3 25626 383701.3 20 519882.7
21 383701.3 3037.635 386738.9 25626 361112.9 21 503912.8
22 361112.9 2858.811 363971.7 25626 338345.7 22 487813.1
23 338345.7 2678.57 341024.3 25626 315398.3 23 471582.5
24 315398.3 2496.903 317895.2 25626 292269.2 24 455220.2
25 292269.2 2313.798 294583 25626 268957 25 438724.8
26 268957 2129.243 271086.2 25626 245460.2 26 422095.5
27 245460.2 1943.227 247403.5 25626 221777.5 27 405331
28 221777.5 1755.738 223533.2 25626 197907.2 28 388430.3
29 197907.2 1566.765 199474 25626 173848 29 371392.3
30 173848 1376.296 175224.3 25626 149598.3 30 354215.9
31 149598.3 1184.32 150782.6 25626 125156.6 31 336899.9
32 125156.6 990.823 126147.4 25626 100521.4 32 319443.2
33 100521.4 795.7945 101317.2 25626 75691.21 33 301844.6
34 75691.21 599.2221 76290.43 25626 50664.43 34 284103.1
35 50664.43 401.0934 51065.52 25626 25439.52 35 266217.5
36 25439.52 201.3962 25640.92 25626 14.91907 36 248186.5
37 230009
38 211683.8
39 193209.8
40 174585.6
41 155810.1
42 136882.1
43 117800.2
44 98563.35
45 79170.18
46 59619.43
47 39909.84
48 20040.11
4 YEARS LOAN TERM 5 YEARS LOAN TERM
0.008125 20194 8.934583 0.008333 16998
6500 806500 20194 786306 1 800000 6666.667 806666.7
6388.736 792694.7 20194 772500.7 2 789668.7 6580.572 796249.2
6276.568 778777.3 20194 758583.3 3 779251.2 6493.76 785745
6163.489 764746.8 20194 744552.8 4 768747 6406.225 775153.2
6049.491 750602.3 20194 730408.3 5 758155.2 6317.96 764473.2
5934.567 736342.9 20194 716148.9 6 747475.2 6228.96 753704.1
5818.709 721967.6 20194 701773.6 7 736706.1 6139.218 742845.4
5701.91 707475.5 20194 687281.5 8 725847.4 6048.728 731896.1
5584.162 692865.6 20194 672671.6 9 714898.1 5957.484 720855.6
5465.457 678137.1 20194 657943.1 10 703857.6 5865.48 709723.1
5345.788 663288.9 20194 643094.9 11 692725.1 5772.709 698497.8
5225.146 648320 20194 628126 12 681499.8 5679.165 687178.9
5103.524 633229.5 20194 613035.5 13 670180.9 5584.841 675765.8
4980.914 618016.5 20194 597822.5 14 658767.8 5489.731 664257.5
4857.308 602679.8 20194 582485.8 15 647259.5 5393.829 652653.3
4732.697 587218.5 20194 567024.5 16 635655.3 5297.128 640952.5
4607.074 571631.5 20194 551437.5 17 623954.5 5199.62 629154.1
4480.43 555918 20194 535724 18 612156.1 5101.301 617257.4
4352.757 540076.7 20194 519882.7 19 600259.4 5002.161 605261.5
4224.047 524106.8 20194 503912.8 20 588263.5 4902.196 593165.7
4094.291 508007.1 20194 487813.1 21 576167.7 4801.398 580969.1
3963.481 491776.5 20194 471582.5 22 563971.1 4699.759 568670.9
3831.608 475414.2 20194 455220.2 23 551672.9 4597.274 556270.2
3698.664 458918.8 20194 438724.8 24 539272.2 4493.935 543766.1
3564.639 442289.5 20194 422095.5 25 526768.1 4389.734 531157.8
3429.526 425525 20194 405331 26 514159.8 4284.665 518444.5
3293.314 408624.3 20194 388430.3 27 501446.5 4178.721 505625.2
3155.996 391586.3 20194 371392.3 28 488627.2 4071.894 492699.1
3017.562 374409.9 20194 354215.9 29 475701.1 3964.176 479665.3
2878.004 357093.9 20194 336899.9 30 462667.3 3855.561 466522.9
2737.311 339637.2 20194 319443.2 31 449524.9 3746.04 453270.9
2595.476 322038.6 20194 301844.6 32 436272.9 3635.607 439908.5
2452.488 304297.1 20194 284103.1 33 422910.5 3524.254 426434.8
2308.338 286411.5 20194 266217.5 34 409436.8 3411.973 412848.7
2163.017 268380.5 20194 248186.5 35 395850.7 3298.756 399149.5
2016.515 250203 20194 230009 36 382151.5 3184.596 385336.1
1868.823 231877.8 20194 211683.8 37 368338.1 3069.484 371407.6
1719.931 213403.8 20194 193209.8 38 354409.6 2953.413 357363
1569.829 194779.6 20194 174585.6 39 340365 2836.375 343201.4
1418.508 176004.1 20194 155810.1 40 326203.4 2718.361 328921.7
1265.957 157076.1 20194 136882.1 41 311923.7 2599.364 314523.1
1112.167 137994.2 20194 117800.2 42 297525.1 2479.376 300004.5
957.1268 118757.3 20194 98563.35 43 283006.5 2358.387 285364.8
800.8272 99364.18 20194 79170.18 44 268366.8 2236.39 270603.2
643.2577 79813.43 20194 59619.43 45 253605.2 2113.377 255718.6
484.4079 60103.84 20194 39909.84 46 238720.6 1989.338 240709.9
324.2675 40234.11 20194 20040.11 47 223711.9 1864.266 225576.2
162.8259 20202.93 20194 8.934583 48 208578.2 1738.152 210316.4
49 193318.4 1610.986 194929.3
50 177931.3 1482.761 179414.1
51 162416.1 1353.468 163769.6
52 146771.6 1223.096 147994.7
53 130996.7 1091.639 132088.3
54 115090.3 959.0859 116049.4
55 99051.4 825.4283 99876.83
56 82878.83 690.6569 83569.48
57 66571.48 554.7624 67126.25
58 50128.25 417.7354 50545.98
59 33547.98 279.5665 33827.55
60 16829.55 140.2462 16969.8
ARS LOAN TERM
-28.20498
16998 789668.7
16998 779251.2
16998 768747
16998 758155.2
16998 747475.2
16998 736706.1
16998 725847.4
16998 714898.1
16998 703857.6
16998 692725.1
16998 681499.8
16998 670180.9
16998 658767.8
16998 647259.5
16998 635655.3
16998 623954.5
16998 612156.1
16998 600259.4
16998 588263.5
16998 576167.7
16998 563971.1
16998 551672.9
16998 539272.2
16998 526768.1
16998 514159.8
16998 501446.5
16998 488627.2
16998 475701.1
16998 462667.3
16998 449524.9
16998 436272.9
16998 422910.5
16998 409436.8
16998 395850.7
16998 382151.5
16998 368338.1
16998 354409.6
16998 340365
16998 326203.4
16998 311923.7
16998 297525.1
16998 283006.5
16998 268366.8
16998 253605.2
16998 238720.6
16998 223711.9
16998 208578.2
16998 193318.4
16998 177931.3
16998 162416.1
16998 146771.6
16998 130996.7
16998 115090.3
16998 99051.4
16998 82878.83
16998 66571.48
16998 50128.25
16998 33547.98
16998 16829.55
16998 -28.20498
