EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
4,500,000.00 |
|
|
|
|
|
100,000.00 |
4,400,000.00 |
4,600,000.00 |
| 1 |
4,352,080.00 |
147,920.00 |
90,000.00 |
237,920.00 |
79,504.00 |
-10,496.00 |
89,504.00 |
4,441,584.00 |
237,920.00 |
| 2 |
4,201,202.00 |
150,878.00 |
87,042.00 |
237,920.00 |
80,256.00 |
-6,786.00 |
82,718.00 |
4,283,920.00 |
237,920.00 |
| 3 |
4,047,306.00 |
153,896.00 |
84,024.00 |
237,920.00 |
77,407.00 |
-6,617.00 |
76,101.00 |
4,123,407.00 |
237,920.00 |
| 4 |
3,890,332.00 |
156,974.00 |
80,946.00 |
237,920.00 |
74,506.00 |
-6,440.00 |
69,661.00 |
3,959,993.00 |
237,920.00 |
| 5 |
3,730,219.00 |
160,113.00 |
77,807.00 |
237,920.00 |
71,554.00 |
-6,253.00 |
63,408.00 |
3,793,627.00 |
237,920.00 |
| 6 |
3,566,903.00 |
163,316.00 |
74,604.00 |
237,920.00 |
68,548.00 |
-6,056.00 |
57,352.00 |
3,624,255.00 |
237,920.00 |
| 7 |
3,400,321.00 |
166,582.00 |
71,338.00 |
237,920.00 |
65,487.00 |
-5,851.00 |
51,501.00 |
3,451,822.00 |
237,920.00 |
| 8 |
3,230,407.00 |
169,914.00 |
68,006.00 |
237,920.00 |
62,372.00 |
-5,634.00 |
45,867.00 |
3,276,274.00 |
237,920.00 |
| 9 |
3,057,095.00 |
173,312.00 |
64,608.00 |
237,920.00 |
59,200.00 |
-5,408.00 |
40,459.00 |
3,097,554.00 |
237,920.00 |
| 10 |
2,880,317.00 |
176,778.00 |
61,142.00 |
237,920.00 |
55,970.00 |
-5,172.00 |
35,287.00 |
2,915,604.00 |
237,920.00 |
| 11 |
2,700,003.00 |
180,314.00 |
57,606.00 |
237,920.00 |
52,683.00 |
-4,923.00 |
30,364.00 |
2,730,367.00 |
237,920.00 |
| 12 |
2,516,083.00 |
183,920.00 |
54,000.00 |
237,920.00 |
49,335.00 |
-4,665.00 |
25,699.00 |
2,541,782.00 |
237,920.00 |
| 13 |
2,328,485.00 |
187,598.00 |
50,322.00 |
237,920.00 |
45,928.00 |
-4,394.00 |
21,305.00 |
2,349,790.00 |
237,920.00 |
| 14 |
2,137,135.00 |
191,350.00 |
46,570.00 |
237,920.00 |
42,459.00 |
-4,111.00 |
17,194.00 |
2,154,329.00 |
237,920.00 |
| 15 |
1,941,958.00 |
195,177.00 |
42,743.00 |
237,920.00 |
38,927.00 |
-3,816.00 |
13,378.00 |
1,955,336.00 |
237,920.00 |
| 16 |
1,742,877.00 |
199,081.00 |
38,839.00 |
237,920.00 |
35,331.00 |
-3,508.00 |
9,870.00 |
1,752,747.00 |
237,920.00 |
| 17 |
1,539,815.00 |
203,062.00 |
34,858.00 |
237,920.00 |
31,671.00 |
-3,187.00 |
6,683.00 |
1,546,498.00 |
237,920.00 |
| 18 |
1,332,691.00 |
207,124.00 |
30,796.00 |
237,920.00 |
27,944.00 |
-2,852.00 |
3,831.00 |
1,336,522.00 |
237,920.00 |
| 19 |
1,121,425.00 |
211,266.00 |
26,654.00 |
237,920.00 |
24,150.00 |
-2,504.00 |
1,327.00 |
1,122,752.00 |
237,920.00 |
| 20 |
905,933.00 |
215,492.00 |
22,429.00 |
237,921.00 |
20,287.00 |
-2,142.00 |
815.00 |
905,118.00 |
237,920.00 |
| 21 |
686,132.00 |
219,801.00 |
18,119.00 |
237,920.00 |
16,355.00 |
-1,764.00 |
2,579.00 |
683,553.00 |
237,920.00 |
| 22 |
461,935.00 |
224,197.00 |
13,723.00 |
237,920.00 |
12,351.00 |
-1,372.00 |
3,951.00 |
457,984.00 |
237,920.00 |
| 23 |
233,254.00 |
228,681.00 |
9,239.00 |
237,920.00 |
8,275.00 |
-964.00 |
4,915.00 |
228,339.00 |
237,920.00 |
| 24 |
-1.00 |
233,255.00 |
4,665.00 |
237,920.00 |
4,126.00 |
-539.00 |
5,454.00 |
-5,455.00 |
237,920.00 |