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,846,640.00 |
153,360.00 |
30,000.00 |
183,360.00 |
38,653.00 |
8,653.00 |
51,347.00 |
1,795,293.00 |
183,360.00 |
| 2 |
1,690,980.00 |
155,660.00 |
27,700.00 |
183,360.00 |
35,769.00 |
8,069.00 |
43,278.00 |
1,647,702.00 |
183,360.00 |
| 3 |
1,532,985.00 |
157,995.00 |
25,365.00 |
183,360.00 |
32,829.00 |
7,464.00 |
35,814.00 |
1,497,171.00 |
183,360.00 |
| 4 |
1,372,620.00 |
160,365.00 |
22,995.00 |
183,360.00 |
29,830.00 |
6,835.00 |
28,979.00 |
1,343,641.00 |
183,360.00 |
| 5 |
1,209,849.00 |
162,771.00 |
20,589.00 |
183,360.00 |
26,771.00 |
6,182.00 |
22,797.00 |
1,187,052.00 |
183,360.00 |
| 6 |
1,044,637.00 |
165,212.00 |
18,148.00 |
183,360.00 |
23,651.00 |
5,503.00 |
17,294.00 |
1,027,343.00 |
183,360.00 |
| 7 |
876,947.00 |
167,690.00 |
15,670.00 |
183,360.00 |
20,469.00 |
4,799.00 |
12,495.00 |
864,452.00 |
183,360.00 |
| 8 |
706,741.00 |
170,206.00 |
13,154.00 |
183,360.00 |
17,223.00 |
4,069.00 |
8,426.00 |
698,315.00 |
183,360.00 |
| 9 |
533,982.00 |
172,759.00 |
10,601.00 |
183,360.00 |
13,913.00 |
3,312.00 |
5,114.00 |
528,868.00 |
183,360.00 |
| 10 |
358,632.00 |
175,350.00 |
8,010.00 |
183,360.00 |
10,537.00 |
2,527.00 |
2,587.00 |
356,045.00 |
183,360.00 |
| 11 |
180,651.00 |
177,981.00 |
5,379.00 |
183,360.00 |
7,094.00 |
1,715.00 |
872.00 |
179,779.00 |
183,360.00 |
| 12 |
1.00 |
180,650.00 |
2,710.00 |
183,360.00 |
3,582.00 |
872.00 |
0.00 |
1.00 |
183,360.00 |