EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
6,000,000.00 |
|
|
|
|
|
180,000.00 |
5,820,000.00 |
5,820,000.00 |
| 1 |
5,539,920.00 |
460,080.00 |
90,000.00 |
550,080.00 |
115,958.00 |
25,958.00 |
154,042.00 |
5,385,878.00 |
550,080.00 |
| 2 |
5,072,939.00 |
466,981.00 |
83,099.00 |
550,080.00 |
107,308.00 |
24,209.00 |
129,833.00 |
4,943,106.00 |
550,080.00 |
| 3 |
4,598,953.00 |
473,986.00 |
76,094.00 |
550,080.00 |
98,486.00 |
22,392.00 |
107,441.00 |
4,491,512.00 |
550,080.00 |
| 4 |
4,117,857.00 |
481,096.00 |
68,984.00 |
550,080.00 |
89,489.00 |
20,505.00 |
86,936.00 |
4,030,921.00 |
550,080.00 |
| 5 |
3,629,545.00 |
488,312.00 |
61,768.00 |
550,080.00 |
80,312.00 |
18,544.00 |
68,392.00 |
3,561,153.00 |
550,080.00 |
| 6 |
3,133,908.00 |
495,637.00 |
54,443.00 |
550,080.00 |
70,952.00 |
16,509.00 |
51,883.00 |
3,082,025.00 |
550,080.00 |
| 7 |
2,630,837.00 |
503,071.00 |
47,009.00 |
550,080.00 |
61,406.00 |
14,397.00 |
37,486.00 |
2,593,351.00 |
550,080.00 |
| 8 |
2,120,220.00 |
510,617.00 |
39,463.00 |
550,080.00 |
51,670.00 |
12,207.00 |
25,279.00 |
2,094,941.00 |
550,080.00 |
| 9 |
1,601,943.00 |
518,277.00 |
31,803.00 |
550,080.00 |
41,740.00 |
9,937.00 |
15,342.00 |
1,586,601.00 |
550,080.00 |
| 10 |
1,075,892.00 |
526,051.00 |
24,029.00 |
550,080.00 |
31,611.00 |
7,582.00 |
7,760.00 |
1,068,132.00 |
550,080.00 |
| 11 |
541,950.00 |
533,942.00 |
16,138.00 |
550,080.00 |
21,281.00 |
5,143.00 |
2,617.00 |
539,333.00 |
550,080.00 |
| 12 |
-1.00 |
541,951.00 |
8,129.00 |
550,080.00 |
10,746.00 |
2,617.00 |
0.00 |
-1.00 |
550,080.00 |