KINGSTON EDUCATIONAL INSTITUTE
REPAYMENT SCHEDULE OF TERM LOAN:
The Loan to be repaid in 84 months which is calculated as below,
Loan Amount 1920,38,000.00
ROI (p.a.) 10.00%
Term in years 7
EMI (monthly rest) 31,88,058
Amortization schedule
Months Opening Interest Principal Closing 0.00833333
1 192038000 1600317 1587742 190450258 84
2 190450258 1587085 1600973 188849286
3 188849286 1573744 1614314 187234972
4 187234972 1560291 1627767 185607205
5 185607205 1546727 1641331 183965873
6 183965873 1533049 1655009 182310864
7 182310864 1519257 1668801 180642063
8 180642063 1505351 1682708 178959356
9 178959356 1491328 1696730 177262625
10 177262625 1477189 1710870 175551756
11 175551756 1462931 1725127 173826629 Interest 183,05,824.06
12 173826629 1448555 1739503 172087126 Principal 199,50,874.08
13 172087126 1434059 1753999 170333127
14 170333127 1419443 1768615 168564512
15 168564512 1404704 1783354 166781158
16 166781158 1389843 1798215 164982943
17 164982943 1374858 1813200 163169742
18 163169742 1359748 1828310 161341432
19 161341432 1344512 1843546 159497886
20 159497886 1329149 1858909 157638977
21 157638977 1313658 1874400 155764576
22 155764576 1298038 1890020 153874556
23 153874556 1282288 1905770 151968786 Interest 162,16,706.84
24 151968786 1266407 1921652 150047135 Principal 220,39,991.30
25 150047135 1250393 1937665 148109469
26 148109469 1234246 1953813 146155657
27 146155657 1217964 1970094 144185562
28 144185562 1201546 1986512 142199050
29 142199050 1184992 2003066 140195984
30 140195984 1168300 2019758 138176226
31 138176226 1151469 2036590 136139636
32 136139636 1134497 2053561 134086075
33 134086075 1117384 2070674 132015401
34 132015401 1100128 2087930 129927471
35 129927471 1082729 2105329 127822142 Interest 139,08,831.74
36 127822142 1065185 2122874 125699268 Principal 243,47,866.39
37 125699268 1047494 2140564 123558704
38 123558704 1029656 2158402 121400302
39 121400302 1011669 2176389 119223913
40 119223913 993533 2194526 117029387
41 117029387 975245 2212813 114816574
42 114816574 956805 2231253 112585320
43 112585320 938211 2249847 110335473
44 110335473 919462 2268596 108066877
45 108066877 900557 2287501 105779376
46 105779376 881495 2306563 103472813
47 103472813 862273 2325785 101147028 Interest 113,59,291.97
48 101147028 842892 2345166 98801862 Principal 268,97,406.17
49 98801862 823349 2364709 96437153
50 96437153 803643 2384415 94052737
51 94052737 783773 2404285 91648452
52 91648452 763737 2424321 89224131
53 89224131 743534 2444524 86779607
54 86779607 723163 2464895 84314713
Months Opening Interest Principal Closing 0.00833333
55 84314713 702623 2485436 81829277
56 81829277 681911 2506148 79323129
57 79323129 661026 2527032 76796097
58 76796097 639967 2548091 74248007
59 74248007 618733 2569325 71678682 Interest 85,42,782.06
60 71678682 597322 2590736 69087946 Principal 297,13,916.08
61 69087946 575733 2612325 66475621
62 66475621 553964 2634095 63841526
63 63841526 532013 2656045 61185481
64 61185481 509879 2678179 58507301
65 58507301 487561 2700497 55806804
66 55806804 465057 2723001 53083803
67 53083803 442365 2745693 50338109
68 50338109 419484 2768574 47569535
69 47569535 396413 2791645 44777890
70 44777890 373149 2814909 41962981
71 41962981 349692 2838367 39124614 Interest 54,31,346.76
72 39124614 326038 2862020 36262595 Principal 328,25,351.37
73 36262595 302188 2885870 33376725
74 33376725 278139 2909919 30466806
75 30466806 253890 2934168 27532638
76 27532638 229439 2958620 24574018
77 24574018 204783 2983275 21590744
78 21590744 179923 3008135 18582608
79 18582608 154855 3033203 15549405
80 15549405 129578 3058480 12490925
81 12490925 104091 3083967 9406958
82 9406958 78391 3109667 6297291
83 6297291 52477 3135581 3161711 Interest 19,94,103.53
84 3161711 26348 3161711 0 Principal 362,62,594.61
85 0 0 0 0
1 2 3 4 5 6 7
Interest 183.06 162.17 139.09 113.59 85.43 54.31 19.94
Principal 199.51 220.40 243.48 268.97 297.14 328.25 362.63
Total 382.57 382.57 382.57 382.57 382.57 382.57 382.57
1 2 3 4 5 6 7
ST 199.51 220.40 243.48 268.97 297.14 328.25 362.63
LT 1720.87 1500.47 1256.99 988.02 690.88 362.63 0.00
1920.38
***moratorium one year including principal and emi
