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 |
|
|
|
|
|
60,000.00 |
1,940,000.00 |
1,940,000.00 |
| 1 |
1,930,152.00 |
69,848.00 |
30,000.00 |
99,848.00 |
34,221.00 |
4,221.00 |
55,779.00 |
1,874,373.00 |
99,848.00 |
| 2 |
1,859,256.00 |
70,896.00 |
28,952.00 |
99,848.00 |
33,063.00 |
4,111.00 |
51,668.00 |
1,807,588.00 |
99,848.00 |
| 3 |
1,787,297.00 |
71,959.00 |
27,889.00 |
99,848.00 |
31,885.00 |
3,996.00 |
47,672.00 |
1,739,625.00 |
99,848.00 |
| 4 |
1,714,258.00 |
73,039.00 |
26,809.00 |
99,848.00 |
30,686.00 |
3,877.00 |
43,795.00 |
1,670,463.00 |
99,848.00 |
| 5 |
1,640,124.00 |
74,134.00 |
25,714.00 |
99,848.00 |
29,467.00 |
3,753.00 |
40,042.00 |
1,600,082.00 |
99,848.00 |
| 6 |
1,564,878.00 |
75,246.00 |
24,602.00 |
99,848.00 |
28,225.00 |
3,623.00 |
36,419.00 |
1,528,459.00 |
99,848.00 |
| 7 |
1,488,503.00 |
76,375.00 |
23,473.00 |
99,848.00 |
26,962.00 |
3,489.00 |
32,930.00 |
1,455,573.00 |
99,848.00 |
| 8 |
1,410,983.00 |
77,520.00 |
22,328.00 |
99,848.00 |
25,676.00 |
3,348.00 |
29,582.00 |
1,381,401.00 |
99,848.00 |
| 9 |
1,332,300.00 |
78,683.00 |
21,165.00 |
99,848.00 |
24,368.00 |
3,203.00 |
26,379.00 |
1,305,921.00 |
99,848.00 |
| 10 |
1,252,436.00 |
79,864.00 |
19,985.00 |
99,849.00 |
23,036.00 |
3,051.00 |
23,328.00 |
1,229,108.00 |
99,848.00 |
| 11 |
1,171,375.00 |
81,061.00 |
18,787.00 |
99,848.00 |
21,681.00 |
2,894.00 |
20,434.00 |
1,150,941.00 |
99,848.00 |
| 12 |
1,089,098.00 |
82,277.00 |
17,571.00 |
99,848.00 |
20,302.00 |
2,731.00 |
17,703.00 |
1,071,395.00 |
99,848.00 |
| 13 |
1,005,586.00 |
83,512.00 |
16,336.00 |
99,848.00 |
18,899.00 |
2,563.00 |
15,140.00 |
990,446.00 |
99,848.00 |
| 14 |
920,822.00 |
84,764.00 |
15,084.00 |
99,848.00 |
17,471.00 |
2,387.00 |
12,753.00 |
908,069.00 |
99,848.00 |
| 15 |
834,786.00 |
86,036.00 |
13,812.00 |
99,848.00 |
16,018.00 |
2,206.00 |
10,547.00 |
824,239.00 |
99,848.00 |
| 16 |
747,460.00 |
87,326.00 |
12,522.00 |
99,848.00 |
14,539.00 |
2,017.00 |
8,530.00 |
738,930.00 |
99,848.00 |
| 17 |
658,824.00 |
88,636.00 |
11,212.00 |
99,848.00 |
13,035.00 |
1,823.00 |
6,707.00 |
652,117.00 |
99,848.00 |
| 18 |
568,858.00 |
89,966.00 |
9,882.00 |
99,848.00 |
11,503.00 |
1,621.00 |
5,086.00 |
563,772.00 |
99,848.00 |
| 19 |
477,543.00 |
91,315.00 |
8,533.00 |
99,848.00 |
9,945.00 |
1,412.00 |
3,674.00 |
473,869.00 |
99,848.00 |
| 20 |
384,858.00 |
92,685.00 |
7,163.00 |
99,848.00 |
8,359.00 |
1,196.00 |
2,478.00 |
382,380.00 |
99,848.00 |
| 21 |
290,783.00 |
94,075.00 |
5,773.00 |
99,848.00 |
6,745.00 |
972.00 |
1,506.00 |
289,277.00 |
99,848.00 |
| 22 |
195,297.00 |
95,486.00 |
4,362.00 |
99,848.00 |
5,103.00 |
741.00 |
765.00 |
194,532.00 |
99,848.00 |
| 23 |
98,378.00 |
96,919.00 |
2,929.00 |
99,848.00 |
3,431.00 |
502.00 |
263.00 |
98,115.00 |
99,848.00 |
| 24 |
6.00 |
98,372.00 |
1,476.00 |
99,848.00 |
1,731.00 |
255.00 |
8.00 |
-2.00 |
99,848.00 |