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 |
|
|
|
|
|
240,000.00 |
5,760,000.00 |
5,760,000.00 |
| 1 |
5,790,455.00 |
209,545.00 |
90,000.00 |
299,545.00 |
106,826.00 |
16,826.00 |
223,174.00 |
5,567,281.00 |
299,545.00 |
| 2 |
5,577,767.00 |
212,688.00 |
86,857.00 |
299,545.00 |
103,251.00 |
16,394.00 |
206,780.00 |
5,370,987.00 |
299,545.00 |
| 3 |
5,361,889.00 |
215,878.00 |
83,667.00 |
299,545.00 |
99,611.00 |
15,944.00 |
190,836.00 |
5,171,053.00 |
299,545.00 |
| 4 |
5,142,772.00 |
219,117.00 |
80,428.00 |
299,545.00 |
95,903.00 |
15,475.00 |
175,361.00 |
4,967,411.00 |
299,545.00 |
| 5 |
4,920,369.00 |
222,403.00 |
77,142.00 |
299,545.00 |
92,126.00 |
14,984.00 |
160,377.00 |
4,759,992.00 |
299,545.00 |
| 6 |
4,694,630.00 |
225,739.00 |
73,806.00 |
299,545.00 |
88,279.00 |
14,473.00 |
145,904.00 |
4,548,726.00 |
299,545.00 |
| 7 |
4,465,504.00 |
229,126.00 |
70,419.00 |
299,545.00 |
84,361.00 |
13,942.00 |
131,962.00 |
4,333,542.00 |
299,545.00 |
| 8 |
4,232,942.00 |
232,562.00 |
66,983.00 |
299,545.00 |
80,370.00 |
13,387.00 |
118,575.00 |
4,114,367.00 |
299,545.00 |
| 9 |
3,996,891.00 |
236,051.00 |
63,494.00 |
299,545.00 |
76,306.00 |
12,812.00 |
105,763.00 |
3,891,128.00 |
299,545.00 |
| 10 |
3,757,299.00 |
239,592.00 |
59,953.00 |
299,545.00 |
72,165.00 |
12,212.00 |
93,551.00 |
3,663,748.00 |
299,545.00 |
| 11 |
3,514,113.00 |
243,186.00 |
56,359.00 |
299,545.00 |
67,948.00 |
11,589.00 |
81,962.00 |
3,432,151.00 |
299,545.00 |
| 12 |
3,267,280.00 |
246,833.00 |
52,712.00 |
299,545.00 |
63,653.00 |
10,941.00 |
71,021.00 |
3,196,259.00 |
299,545.00 |
| 13 |
3,016,744.00 |
250,536.00 |
49,009.00 |
299,545.00 |
59,278.00 |
10,269.00 |
60,752.00 |
2,955,992.00 |
299,545.00 |
| 14 |
2,762,450.00 |
254,294.00 |
45,251.00 |
299,545.00 |
54,822.00 |
9,571.00 |
51,181.00 |
2,711,269.00 |
299,545.00 |
| 15 |
2,504,342.00 |
258,108.00 |
41,437.00 |
299,545.00 |
50,284.00 |
8,847.00 |
42,334.00 |
2,462,008.00 |
299,545.00 |
| 16 |
2,242,362.00 |
261,980.00 |
37,565.00 |
299,545.00 |
45,661.00 |
8,096.00 |
34,238.00 |
2,208,124.00 |
299,545.00 |
| 17 |
1,976,452.00 |
265,910.00 |
33,635.00 |
299,545.00 |
40,952.00 |
7,317.00 |
26,921.00 |
1,949,531.00 |
299,545.00 |
| 18 |
1,706,554.00 |
269,898.00 |
29,647.00 |
299,545.00 |
36,156.00 |
6,509.00 |
20,412.00 |
1,686,142.00 |
299,545.00 |
| 19 |
1,432,607.00 |
273,947.00 |
25,598.00 |
299,545.00 |
31,271.00 |
5,673.00 |
14,739.00 |
1,417,868.00 |
299,545.00 |
| 20 |
1,154,551.00 |
278,056.00 |
21,489.00 |
299,545.00 |
26,296.00 |
4,807.00 |
9,932.00 |
1,144,619.00 |
299,545.00 |
| 21 |
872,324.00 |
282,227.00 |
17,318.00 |
299,545.00 |
21,228.00 |
3,910.00 |
6,022.00 |
866,302.00 |
299,545.00 |
| 22 |
585,864.00 |
286,460.00 |
13,085.00 |
299,545.00 |
16,067.00 |
2,982.00 |
3,040.00 |
582,824.00 |
299,545.00 |
| 23 |
295,107.00 |
290,757.00 |
8,788.00 |
299,545.00 |
10,809.00 |
2,021.00 |
1,019.00 |
294,088.00 |
299,545.00 |
| 24 |
-11.00 |
295,118.00 |
4,427.00 |
299,545.00 |
5,454.00 |
1,027.00 |
8.00 |
-3.00 |
299,545.00 |