EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
2,000,000.00 |
|
|
|
|
|
80,000.00 |
1,920,000.00 |
1,920,000.00 |
| 1 |
1,930,152.00 |
69,848.00 |
30,000.00 |
99,848.00 |
35,608.00 |
5,608.00 |
74,392.00 |
1,855,760.00 |
99,848.00 |
| 2 |
1,859,256.00 |
70,896.00 |
28,952.00 |
99,848.00 |
34,417.00 |
5,465.00 |
68,927.00 |
1,790,329.00 |
99,848.00 |
| 3 |
1,787,297.00 |
71,959.00 |
27,889.00 |
99,848.00 |
33,203.00 |
5,314.00 |
63,613.00 |
1,723,684.00 |
99,848.00 |
| 4 |
1,714,258.00 |
73,039.00 |
26,809.00 |
99,848.00 |
31,967.00 |
5,158.00 |
58,455.00 |
1,655,803.00 |
99,848.00 |
| 5 |
1,640,124.00 |
74,134.00 |
25,714.00 |
99,848.00 |
30,708.00 |
4,994.00 |
53,461.00 |
1,586,663.00 |
99,848.00 |
| 6 |
1,564,878.00 |
75,246.00 |
24,602.00 |
99,848.00 |
29,426.00 |
4,824.00 |
48,637.00 |
1,516,241.00 |
99,848.00 |
| 7 |
1,488,503.00 |
76,375.00 |
23,473.00 |
99,848.00 |
28,120.00 |
4,647.00 |
43,990.00 |
1,444,513.00 |
99,848.00 |
| 8 |
1,410,983.00 |
77,520.00 |
22,328.00 |
99,848.00 |
26,790.00 |
4,462.00 |
39,528.00 |
1,371,455.00 |
99,848.00 |
| 9 |
1,332,300.00 |
78,683.00 |
21,165.00 |
99,848.00 |
25,435.00 |
4,270.00 |
35,258.00 |
1,297,042.00 |
99,848.00 |
| 10 |
1,252,436.00 |
79,864.00 |
19,985.00 |
99,849.00 |
24,055.00 |
4,070.00 |
31,188.00 |
1,221,248.00 |
99,848.00 |
| 11 |
1,171,375.00 |
81,061.00 |
18,787.00 |
99,848.00 |
22,649.00 |
3,862.00 |
27,326.00 |
1,144,049.00 |
99,848.00 |
| 12 |
1,089,098.00 |
82,277.00 |
17,571.00 |
99,848.00 |
21,217.00 |
3,646.00 |
23,680.00 |
1,065,418.00 |
99,848.00 |
| 13 |
1,005,586.00 |
83,512.00 |
16,336.00 |
99,848.00 |
19,759.00 |
3,423.00 |
20,257.00 |
985,329.00 |
99,848.00 |
| 14 |
920,822.00 |
84,764.00 |
15,084.00 |
99,848.00 |
18,274.00 |
3,190.00 |
17,067.00 |
903,755.00 |
99,848.00 |
| 15 |
834,786.00 |
86,036.00 |
13,812.00 |
99,848.00 |
16,761.00 |
2,949.00 |
14,118.00 |
820,668.00 |
99,848.00 |
| 16 |
747,460.00 |
87,326.00 |
12,522.00 |
99,848.00 |
15,220.00 |
2,698.00 |
11,420.00 |
736,040.00 |
99,848.00 |
| 17 |
658,824.00 |
88,636.00 |
11,212.00 |
99,848.00 |
13,650.00 |
2,438.00 |
8,982.00 |
649,842.00 |
99,848.00 |
| 18 |
568,858.00 |
89,966.00 |
9,882.00 |
99,848.00 |
12,052.00 |
2,170.00 |
6,812.00 |
562,046.00 |
99,848.00 |
| 19 |
477,543.00 |
91,315.00 |
8,533.00 |
99,848.00 |
10,424.00 |
1,891.00 |
4,921.00 |
472,622.00 |
99,848.00 |
| 20 |
384,858.00 |
92,685.00 |
7,163.00 |
99,848.00 |
8,765.00 |
1,602.00 |
3,319.00 |
381,539.00 |
99,848.00 |
| 21 |
290,783.00 |
94,075.00 |
5,773.00 |
99,848.00 |
7,076.00 |
1,303.00 |
2,016.00 |
288,767.00 |
99,848.00 |
| 22 |
195,297.00 |
95,486.00 |
4,362.00 |
99,848.00 |
5,355.00 |
993.00 |
1,023.00 |
194,274.00 |
99,848.00 |
| 23 |
98,378.00 |
96,919.00 |
2,929.00 |
99,848.00 |
3,603.00 |
674.00 |
349.00 |
98,029.00 |
99,848.00 |
| 24 |
6.00 |
98,372.00 |
1,476.00 |
99,848.00 |
1,818.00 |
342.00 |
7.00 |
-1.00 |
99,848.00 |