EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
4,000,000.00 |
|
|
|
|
|
40,000.00 |
3,960,000.00 |
4,040,000.00 |
| 1 |
3,864,457.00 |
135,543.00 |
70,000.00 |
205,543.00 |
65,873.00 |
-4,127.00 |
35,873.00 |
3,900,330.00 |
205,543.00 |
| 2 |
3,726,542.00 |
137,915.00 |
67,628.00 |
205,543.00 |
64,880.00 |
-2,748.00 |
33,125.00 |
3,759,667.00 |
205,543.00 |
| 3 |
3,586,213.00 |
140,329.00 |
65,214.00 |
205,543.00 |
62,540.00 |
-2,674.00 |
30,451.00 |
3,616,664.00 |
205,543.00 |
| 4 |
3,443,429.00 |
142,784.00 |
62,759.00 |
205,543.00 |
60,162.00 |
-2,597.00 |
27,854.00 |
3,471,283.00 |
205,543.00 |
| 5 |
3,298,146.00 |
145,283.00 |
60,260.00 |
205,543.00 |
57,743.00 |
-2,517.00 |
25,337.00 |
3,323,483.00 |
205,543.00 |
| 6 |
3,150,321.00 |
147,825.00 |
57,718.00 |
205,543.00 |
55,285.00 |
-2,433.00 |
22,904.00 |
3,173,225.00 |
205,543.00 |
| 7 |
2,999,909.00 |
150,412.00 |
55,131.00 |
205,543.00 |
52,785.00 |
-2,346.00 |
20,558.00 |
3,020,467.00 |
205,543.00 |
| 8 |
2,846,864.00 |
153,045.00 |
52,498.00 |
205,543.00 |
50,244.00 |
-2,254.00 |
18,304.00 |
2,865,168.00 |
205,543.00 |
| 9 |
2,691,141.00 |
155,723.00 |
49,820.00 |
205,543.00 |
47,661.00 |
-2,159.00 |
16,145.00 |
2,707,286.00 |
205,543.00 |
| 10 |
2,532,693.00 |
158,448.00 |
47,095.00 |
205,543.00 |
45,034.00 |
-2,061.00 |
14,084.00 |
2,546,777.00 |
205,543.00 |
| 11 |
2,371,472.00 |
161,221.00 |
44,322.00 |
205,543.00 |
42,365.00 |
-1,957.00 |
12,127.00 |
2,383,599.00 |
205,543.00 |
| 12 |
2,207,430.00 |
164,042.00 |
41,501.00 |
205,543.00 |
39,650.00 |
-1,851.00 |
10,276.00 |
2,217,706.00 |
205,543.00 |
| 13 |
2,040,517.00 |
166,913.00 |
38,630.00 |
205,543.00 |
36,891.00 |
-1,739.00 |
8,537.00 |
2,049,054.00 |
205,543.00 |
| 14 |
1,870,683.00 |
169,834.00 |
35,709.00 |
205,543.00 |
34,085.00 |
-1,624.00 |
6,913.00 |
1,877,596.00 |
205,543.00 |
| 15 |
1,697,877.00 |
172,806.00 |
32,737.00 |
205,543.00 |
31,233.00 |
-1,504.00 |
5,409.00 |
1,703,286.00 |
205,543.00 |
| 16 |
1,522,047.00 |
175,830.00 |
29,713.00 |
205,543.00 |
28,333.00 |
-1,380.00 |
4,029.00 |
1,526,076.00 |
205,543.00 |
| 17 |
1,343,140.00 |
178,907.00 |
26,636.00 |
205,543.00 |
25,386.00 |
-1,250.00 |
2,779.00 |
1,345,919.00 |
205,543.00 |
| 18 |
1,161,102.00 |
182,038.00 |
23,505.00 |
205,543.00 |
22,389.00 |
-1,116.00 |
1,663.00 |
1,162,765.00 |
205,543.00 |
| 19 |
975,878.00 |
185,224.00 |
20,319.00 |
205,543.00 |
19,342.00 |
-977.00 |
686.00 |
976,564.00 |
205,543.00 |
| 20 |
787,413.00 |
188,465.00 |
17,078.00 |
205,543.00 |
16,245.00 |
-833.00 |
147.00 |
787,266.00 |
205,543.00 |
| 21 |
595,650.00 |
191,763.00 |
13,780.00 |
205,543.00 |
13,096.00 |
-684.00 |
831.00 |
594,819.00 |
205,543.00 |
| 22 |
400,531.00 |
195,119.00 |
10,424.00 |
205,543.00 |
9,895.00 |
-529.00 |
1,360.00 |
399,171.00 |
205,543.00 |
| 23 |
201,997.00 |
198,534.00 |
7,009.00 |
205,543.00 |
6,640.00 |
-369.00 |
1,729.00 |
200,268.00 |
205,543.00 |
| 24 |
-11.00 |
202,008.00 |
3,535.00 |
205,543.00 |
3,331.00 |
-204.00 |
1,933.00 |
-1,944.00 |
205,543.00 |