Spreadsheet: 98116d1297169909-repayment-template-kumara_faith-hybrid-loan-payment-schedule
Sheet: Amortization

Month | Payment | Interest | Principal | Balance
 |  |  |  | 10000
1 | 66.67 | 66.67 | 0 | 10000
2 | 66.67 | 66.67 | 0 | 10000
3 | 66.67 | 66.67 | 0 | 10000
4 | 66.67 | 66.67 | 0 | 10000
5 | 66.67 | 66.67 | 0 | 10000
6 | 66.67 | 66.67 | 0 | 10000
7 | 66.67 | 66.67 | 0 | 10000
8 | 66.67 | 66.67 | 0 | 10000
9 | 66.67 | 66.67 | 0 | 10000
10 | 66.67 | 66.67 | 0 | 10000
11 | 66.67 | 66.67 | 0 | 10000
12 | 66.67 | 66.67 | 0 | 10000
13 | 66.67 | 66.67 | 0 | 10000
14 | 66.67 | 66.67 | 0 | 10000
15 | 66.67 | 66.67 | 0 | 10000
16 | 66.67 | 66.67 | 0 | 10000
17 | 66.67 | 66.67 | 0 | 10000
18 | 66.67 | 66.67 | 0 | 10000
19 | 66.67 | 66.67 | 0 | 10000
20 | 66.67 | 66.67 | 0 | 10000
21 | 66.67 | 66.67 | 0 | 10000
22 | 66.67 | 66.67 | 0 | 10000
23 | 66.67 | 66.67 | 0 | 10000
24 | 66.67 | 66.67 | 0 | 10000
25 | 66.67 | 66.67 | 0 | 10000
26 | 66.67 | 66.67 | 0 | 10000
27 | 66.67 | 66.67 | 0 | 10000
28 | 66.67 | 66.67 | 0 | 10000
29 | 66.67 | 66.67 | 0 | 10000
30 | 66.67 | 66.67 | 0 | 10000
31 | 66.67 | 66.67 | 0 | 10000
32 | 66.67 | 66.67 | 0 | 10000
33 | 66.67 | 66.67 | 0 | 10000
34 | 66.67 | 66.67 | 0 | 10000
35 | 66.67 | 66.67 | 0 | 10000
36 | 66.67 | 66.67 | 0 | 10000
37 | 244.1292234150266 | 66.67 | 177.4592234150265 | 9822.540776584974
38 | 244.1292234150266 | 65.48 | 178.6492234150265 | 9643.891553169948
39 | 244.1292234150266 | 64.29 | 179.8392234150265 | 9464.05232975492
40 | 244.1292234150266 | 63.09 | 181.0392234150266 | 9283.013106339895
41 | 244.1292234150266 | 61.89 | 182.2392234150266 | 9100.773882924868
42 | 244.1292234150266 | 60.67 | 183.4592234150265 | 8917.314659509842
43 | 244.1292234150266 | 59.45 | 184.6792234150266 | 8732.635436094815
44 | 244.1292234150266 | 58.22 | 185.9092234150266 | 8546.726212679789
45 | 244.1292234150266 | 56.98 | 187.1492234150266 | 8359.576989264762
46 | 244.1292234150266 | 55.73 | 188.3992234150266 | 8171.177765849736
47 | 244.1292234150266 | 54.47 | 189.6592234150266 | 7981.518542434709
48 | 244.1292234150266 | 53.21 | 190.9192234150266 | 7790.599319019682
49 | 244.1292234150266 | 51.94 | 192.1892234150266 | 7598.410095604656
50 | 244.1292234150266 | 50.66 | 193.4692234150266 | 7404.94087218963
51 | 244.1292234150266 | 49.37 | 194.7592234150266 | 7210.181648774604
52 | 244.1292234150266 | 48.07 | 196.0592234150266 | 7014.122425359577
53 | 244.1292234150266 | 46.76 | 197.3692234150266 | 6816.753201944551
54 | 244.1292234150266 | 45.45 | 198.6792234150266 | 6618.073978529525
55 | 244.1292234150266 | 44.12 | 200.0092234150266 | 6418.064755114498
56 | 244.1292234150266 | 42.79 | 201.3392234150266 | 6216.725531699471
57 | 244.1292234150266 | 41.44 | 202.6892234150266 | 6014.036308284444
58 | 244.1292234150266 | 40.09 | 204.0392234150266 | 5809.997084869417
59 | 244.1292234150266 | 38.73 | 205.3992234150266 | 5604.597861454391
60 | 244.1292234150266 | 37.36 | 206.7692234150265 | 5397.828638039365
61 | 244.1292234150266 | 35.99 | 208.1392234150265 | 5189.689414624338
62 | 244.1292234150266 | 34.6 | 209.5292234150266 | 4980.160191209312
63 | 244.1292234150266 | 33.2 | 210.9292234150266 | 4769.230967794286
64 | 244.1292234150266 | 31.79 | 212.3392234150266 | 4556.891744379259
65 | 244.1292234150266 | 30.38 | 213.7492234150266 | 4343.142520964232
66 | 244.1292234150266 | 28.95 | 215.1792234150266 | 4127.963297549206
67 | 244.1292234150266 | 27.52 | 216.6092234150265 | 3911.354074134179
68 | 244.1292234150266 | 26.08 | 218.0492234150266 | 3693.304850719153
69 | 244.1292234150266 | 24.62 | 219.5092234150266 | 3473.795627304126
70 | 244.1292234150266 | 23.16 | 220.9692234150266 | 3252.8264038891
71 | 244.1292234150266 | 21.69 | 222.4392234150266 | 3030.387180474073
72 | 244.1292234150266 | 20.2 | 223.9292234150266 | 2806.457957059047
73 | 244.1292234150266 | 18.71 | 225.4192234150266 | 2581.03873364402
74 | 244.1292234150266 | 17.21 | 226.9192234150266 | 2354.119510228994
75 | 244.1292234150266 | 15.69 | 228.4392234150266 | 2125.680286813968
76 | 244.1292234150266 | 14.17 | 229.9592234150266 | 1895.721063398941
77 | 244.1292234150266 | 12.64 | 231.4892234150266 | 1664.231839983914
78 | 244.1292234150266 | 11.09 | 233.0392234150266 | 1431.192616568888
79 | 244.1292234150266 | 9.54 | 234.5892234150266 | 1196.603393153861
80 | 244.1292234150266 | 7.98 | 236.1492234150266 | 960.4541697388348
81 | 244.1292234150266 | 6.4 | 237.7292234150266 | 722.7249463238082
82 | 244.1292234150266 | 4.82 | 239.3092234150266 | 483.4157229087817
83 | 244.1292234150266 | 3.22 | 240.9092234150266 | 242.5064994937551
84 | 244.1292234150266 | 1.62 | 242.5092234150266 | -0.002723921271439167