EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
12,000,000.00 |
|
|
|
|
|
480,000.00 |
11,520,000.00 |
11,520,000.00 |
| 1 |
11,580,911.00 |
419,089.00 |
180,000.00 |
599,089.00 |
213,650.00 |
33,650.00 |
446,350.00 |
11,134,561.00 |
599,089.00 |
| 2 |
11,155,536.00 |
425,375.00 |
173,714.00 |
599,089.00 |
206,501.00 |
32,787.00 |
413,563.00 |
10,741,973.00 |
599,089.00 |
| 3 |
10,723,780.00 |
431,756.00 |
167,333.00 |
599,089.00 |
199,220.00 |
31,887.00 |
381,676.00 |
10,342,104.00 |
599,089.00 |
| 4 |
10,285,548.00 |
438,232.00 |
160,857.00 |
599,089.00 |
191,804.00 |
30,947.00 |
350,729.00 |
9,934,819.00 |
599,089.00 |
| 5 |
9,840,742.00 |
444,806.00 |
154,283.00 |
599,089.00 |
184,251.00 |
29,968.00 |
320,761.00 |
9,519,981.00 |
599,089.00 |
| 6 |
9,389,264.00 |
451,478.00 |
147,611.00 |
599,089.00 |
176,557.00 |
28,946.00 |
291,815.00 |
9,097,449.00 |
599,089.00 |
| 7 |
8,931,014.00 |
458,250.00 |
140,839.00 |
599,089.00 |
168,721.00 |
27,882.00 |
263,933.00 |
8,667,081.00 |
599,089.00 |
| 8 |
8,465,890.00 |
465,124.00 |
133,965.00 |
599,089.00 |
160,740.00 |
26,775.00 |
237,158.00 |
8,228,732.00 |
599,089.00 |
| 9 |
7,993,789.00 |
472,101.00 |
126,988.00 |
599,089.00 |
152,610.00 |
25,622.00 |
211,536.00 |
7,782,253.00 |
599,089.00 |
| 10 |
7,514,607.00 |
479,182.00 |
119,907.00 |
599,089.00 |
144,330.00 |
24,423.00 |
187,113.00 |
7,327,494.00 |
599,089.00 |
| 11 |
7,028,237.00 |
486,370.00 |
112,719.00 |
599,089.00 |
135,896.00 |
23,177.00 |
163,936.00 |
6,864,301.00 |
599,089.00 |
| 12 |
6,534,572.00 |
493,665.00 |
105,424.00 |
599,089.00 |
127,305.00 |
21,881.00 |
142,055.00 |
6,392,517.00 |
599,089.00 |
| 13 |
6,033,502.00 |
501,070.00 |
98,019.00 |
599,089.00 |
118,555.00 |
20,536.00 |
121,519.00 |
5,911,983.00 |
599,089.00 |
| 14 |
5,524,916.00 |
508,586.00 |
90,503.00 |
599,089.00 |
109,644.00 |
19,141.00 |
102,378.00 |
5,422,538.00 |
599,089.00 |
| 15 |
5,008,701.00 |
516,215.00 |
82,874.00 |
599,089.00 |
100,566.00 |
17,692.00 |
84,686.00 |
4,924,015.00 |
599,089.00 |
| 16 |
4,484,742.00 |
523,959.00 |
75,131.00 |
599,090.00 |
91,321.00 |
16,190.00 |
68,496.00 |
4,416,246.00 |
599,089.00 |
| 17 |
3,952,924.00 |
531,818.00 |
67,271.00 |
599,089.00 |
81,904.00 |
14,633.00 |
53,863.00 |
3,899,061.00 |
599,089.00 |
| 18 |
3,413,129.00 |
539,795.00 |
59,294.00 |
599,089.00 |
72,312.00 |
13,018.00 |
40,845.00 |
3,372,284.00 |
599,089.00 |
| 19 |
2,865,237.00 |
547,892.00 |
51,197.00 |
599,089.00 |
62,542.00 |
11,345.00 |
29,500.00 |
2,835,737.00 |
599,089.00 |
| 20 |
2,309,127.00 |
556,110.00 |
42,979.00 |
599,089.00 |
52,592.00 |
9,613.00 |
19,887.00 |
2,289,240.00 |
599,089.00 |
| 21 |
1,744,675.00 |
564,452.00 |
34,637.00 |
599,089.00 |
42,456.00 |
7,819.00 |
12,068.00 |
1,732,607.00 |
599,089.00 |
| 22 |
1,171,756.00 |
572,919.00 |
26,170.00 |
599,089.00 |
32,133.00 |
5,963.00 |
6,105.00 |
1,165,651.00 |
599,089.00 |
| 23 |
590,243.00 |
581,513.00 |
17,576.00 |
599,089.00 |
21,618.00 |
4,042.00 |
2,063.00 |
588,180.00 |
599,089.00 |
| 24 |
8.00 |
590,235.00 |
8,854.00 |
599,089.00 |
10,908.00 |
2,054.00 |
9.00 |
-1.00 |
599,089.00 |