EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
3,000,000.00 |
|
|
|
|
|
105,000.00 |
2,895,000.00 |
2,895,000.00 |
| 1 |
2,853,583.00 |
146,417.00 |
45,000.00 |
191,417.00 |
55,019.00 |
10,019.00 |
94,981.00 |
2,758,602.00 |
191,417.00 |
| 2 |
2,704,970.00 |
148,613.00 |
42,804.00 |
191,417.00 |
52,427.00 |
9,623.00 |
85,358.00 |
2,619,612.00 |
191,417.00 |
| 3 |
2,554,128.00 |
150,842.00 |
40,575.00 |
191,417.00 |
49,785.00 |
9,210.00 |
76,148.00 |
2,477,980.00 |
191,417.00 |
| 4 |
2,401,023.00 |
153,105.00 |
38,312.00 |
191,417.00 |
47,093.00 |
8,781.00 |
67,367.00 |
2,333,656.00 |
191,417.00 |
| 5 |
2,245,621.00 |
155,402.00 |
36,015.00 |
191,417.00 |
44,351.00 |
8,336.00 |
59,031.00 |
2,186,590.00 |
191,417.00 |
| 6 |
2,087,888.00 |
157,733.00 |
33,684.00 |
191,417.00 |
41,556.00 |
7,872.00 |
51,159.00 |
2,036,729.00 |
191,417.00 |
| 7 |
1,927,789.00 |
160,099.00 |
31,318.00 |
191,417.00 |
38,708.00 |
7,390.00 |
43,769.00 |
1,884,020.00 |
191,417.00 |
| 8 |
1,765,289.00 |
162,500.00 |
28,917.00 |
191,417.00 |
35,805.00 |
6,888.00 |
36,881.00 |
1,728,408.00 |
191,417.00 |
| 9 |
1,600,351.00 |
164,938.00 |
26,479.00 |
191,417.00 |
32,848.00 |
6,369.00 |
30,512.00 |
1,569,839.00 |
191,417.00 |
| 10 |
1,432,939.00 |
167,412.00 |
24,005.00 |
191,417.00 |
29,834.00 |
5,829.00 |
24,683.00 |
1,408,256.00 |
191,417.00 |
| 11 |
1,263,016.00 |
169,923.00 |
21,494.00 |
191,417.00 |
26,764.00 |
5,270.00 |
19,413.00 |
1,243,603.00 |
191,417.00 |
| 12 |
1,090,544.00 |
172,472.00 |
18,945.00 |
191,417.00 |
23,634.00 |
4,689.00 |
14,724.00 |
1,075,820.00 |
191,417.00 |
| 13 |
915,485.00 |
175,059.00 |
16,358.00 |
191,417.00 |
20,446.00 |
4,088.00 |
10,636.00 |
904,849.00 |
191,417.00 |
| 14 |
737,800.00 |
177,685.00 |
13,732.00 |
191,417.00 |
17,196.00 |
3,464.00 |
7,172.00 |
730,628.00 |
191,417.00 |
| 15 |
557,450.00 |
180,350.00 |
11,067.00 |
191,417.00 |
13,885.00 |
2,818.00 |
4,354.00 |
553,096.00 |
191,417.00 |
| 16 |
374,395.00 |
183,055.00 |
8,362.00 |
191,417.00 |
10,511.00 |
2,149.00 |
2,205.00 |
372,190.00 |
191,417.00 |
| 17 |
188,594.00 |
185,801.00 |
5,616.00 |
191,417.00 |
7,073.00 |
1,457.00 |
748.00 |
187,846.00 |
191,417.00 |
| 18 |
6.00 |
188,588.00 |
2,829.00 |
191,417.00 |
3,570.00 |
741.00 |
7.00 |
-1.00 |
191,417.00 |