EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
1,200,000.00 |
|
|
|
|
|
42,000.00 |
1,158,000.00 |
1,158,000.00 |
| 1 |
1,141,433.00 |
58,567.00 |
18,000.00 |
76,567.00 |
22,008.00 |
4,008.00 |
37,992.00 |
1,103,441.00 |
76,567.00 |
| 2 |
1,081,987.00 |
59,446.00 |
17,121.00 |
76,567.00 |
20,971.00 |
3,850.00 |
34,142.00 |
1,047,845.00 |
76,567.00 |
| 3 |
1,021,650.00 |
60,337.00 |
16,230.00 |
76,567.00 |
19,914.00 |
3,684.00 |
30,458.00 |
991,192.00 |
76,567.00 |
| 4 |
960,408.00 |
61,242.00 |
15,325.00 |
76,567.00 |
18,838.00 |
3,513.00 |
26,945.00 |
933,463.00 |
76,567.00 |
| 5 |
898,247.00 |
62,161.00 |
14,406.00 |
76,567.00 |
17,741.00 |
3,335.00 |
23,610.00 |
874,637.00 |
76,567.00 |
| 6 |
835,154.00 |
63,093.00 |
13,474.00 |
76,567.00 |
16,623.00 |
3,149.00 |
20,461.00 |
814,693.00 |
76,567.00 |
| 7 |
771,114.00 |
64,040.00 |
12,527.00 |
76,567.00 |
15,483.00 |
2,956.00 |
17,505.00 |
753,609.00 |
76,567.00 |
| 8 |
706,114.00 |
65,000.00 |
11,567.00 |
76,567.00 |
14,322.00 |
2,755.00 |
14,750.00 |
691,364.00 |
76,567.00 |
| 9 |
640,139.00 |
65,975.00 |
10,592.00 |
76,567.00 |
13,139.00 |
2,547.00 |
12,203.00 |
627,936.00 |
76,567.00 |
| 10 |
573,174.00 |
66,965.00 |
9,602.00 |
76,567.00 |
11,934.00 |
2,332.00 |
9,871.00 |
563,303.00 |
76,567.00 |
| 11 |
505,205.00 |
67,969.00 |
8,598.00 |
76,567.00 |
10,706.00 |
2,108.00 |
7,763.00 |
497,442.00 |
76,567.00 |
| 12 |
436,216.00 |
68,989.00 |
7,578.00 |
76,567.00 |
9,454.00 |
1,876.00 |
5,887.00 |
430,329.00 |
76,567.00 |
| 13 |
366,192.00 |
70,024.00 |
6,543.00 |
76,567.00 |
8,178.00 |
1,635.00 |
4,252.00 |
361,940.00 |
76,567.00 |
| 14 |
295,118.00 |
71,074.00 |
5,493.00 |
76,567.00 |
6,879.00 |
1,386.00 |
2,866.00 |
292,252.00 |
76,567.00 |
| 15 |
222,978.00 |
72,140.00 |
4,427.00 |
76,567.00 |
5,554.00 |
1,127.00 |
1,739.00 |
221,239.00 |
76,567.00 |
| 16 |
149,756.00 |
73,222.00 |
3,345.00 |
76,567.00 |
4,205.00 |
860.00 |
879.00 |
148,877.00 |
76,567.00 |
| 17 |
75,435.00 |
74,321.00 |
2,246.00 |
76,567.00 |
2,829.00 |
583.00 |
296.00 |
75,139.00 |
76,567.00 |
| 18 |
0.00 |
75,435.00 |
1,132.00 |
76,567.00 |
1,428.00 |
296.00 |
0.00 |
0.00 |
76,567.00 |