EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
2,500,000.00 |
|
|
|
|
|
87,500.00 |
2,412,500.00 |
2,412,500.00 |
| 1 |
2,377,986.00 |
122,014.00 |
37,500.00 |
159,514.00 |
45,849.00 |
8,349.00 |
79,151.00 |
2,298,835.00 |
159,514.00 |
| 2 |
2,254,142.00 |
123,844.00 |
35,670.00 |
159,514.00 |
43,689.00 |
8,019.00 |
71,132.00 |
2,183,010.00 |
159,514.00 |
| 3 |
2,128,440.00 |
125,702.00 |
33,812.00 |
159,514.00 |
41,487.00 |
7,675.00 |
63,457.00 |
2,064,983.00 |
159,514.00 |
| 4 |
2,000,853.00 |
127,587.00 |
31,927.00 |
159,514.00 |
39,244.00 |
7,317.00 |
56,140.00 |
1,944,713.00 |
159,514.00 |
| 5 |
1,871,352.00 |
129,501.00 |
30,013.00 |
159,514.00 |
36,959.00 |
6,946.00 |
49,194.00 |
1,822,158.00 |
159,514.00 |
| 6 |
1,739,908.00 |
131,444.00 |
28,070.00 |
159,514.00 |
34,629.00 |
6,559.00 |
42,635.00 |
1,697,273.00 |
159,514.00 |
| 7 |
1,606,493.00 |
133,415.00 |
26,099.00 |
159,514.00 |
32,256.00 |
6,157.00 |
36,478.00 |
1,570,015.00 |
159,514.00 |
| 8 |
1,471,076.00 |
135,417.00 |
24,097.00 |
159,514.00 |
29,838.00 |
5,741.00 |
30,737.00 |
1,440,339.00 |
159,514.00 |
| 9 |
1,333,628.00 |
137,448.00 |
22,066.00 |
159,514.00 |
27,373.00 |
5,307.00 |
25,430.00 |
1,308,198.00 |
159,514.00 |
| 10 |
1,194,118.00 |
139,510.00 |
20,004.00 |
159,514.00 |
24,862.00 |
4,858.00 |
20,572.00 |
1,173,546.00 |
159,514.00 |
| 11 |
1,052,516.00 |
141,602.00 |
17,912.00 |
159,514.00 |
22,303.00 |
4,391.00 |
16,181.00 |
1,036,335.00 |
159,514.00 |
| 12 |
908,790.00 |
143,726.00 |
15,788.00 |
159,514.00 |
19,695.00 |
3,907.00 |
12,274.00 |
896,516.00 |
159,514.00 |
| 13 |
762,908.00 |
145,882.00 |
13,632.00 |
159,514.00 |
17,038.00 |
3,406.00 |
8,868.00 |
754,040.00 |
159,514.00 |
| 14 |
614,838.00 |
148,070.00 |
11,444.00 |
159,514.00 |
14,330.00 |
2,886.00 |
5,982.00 |
608,856.00 |
159,514.00 |
| 15 |
464,547.00 |
150,291.00 |
9,223.00 |
159,514.00 |
11,571.00 |
2,348.00 |
3,634.00 |
460,913.00 |
159,514.00 |
| 16 |
312,001.00 |
152,546.00 |
6,968.00 |
159,514.00 |
8,759.00 |
1,791.00 |
1,843.00 |
310,158.00 |
159,514.00 |
| 17 |
157,167.00 |
154,834.00 |
4,680.00 |
159,514.00 |
5,894.00 |
1,214.00 |
629.00 |
156,538.00 |
159,514.00 |
| 18 |
10.00 |
157,157.00 |
2,358.00 |
159,515.00 |
2,975.00 |
617.00 |
12.00 |
-2.00 |
159,514.00 |