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 |
|
|
|
|
|
180,000.00 |
4,320,000.00 |
4,320,000.00 |
| 1 |
4,347,515.00 |
152,485.00 |
78,750.00 |
231,235.00 |
91,112.00 |
12,362.00 |
167,638.00 |
4,179,877.00 |
231,235.00 |
| 2 |
4,192,362.00 |
155,153.00 |
76,082.00 |
231,235.00 |
88,157.00 |
12,075.00 |
155,563.00 |
4,036,799.00 |
231,235.00 |
| 3 |
4,034,493.00 |
157,869.00 |
73,366.00 |
231,235.00 |
85,139.00 |
11,773.00 |
143,790.00 |
3,890,703.00 |
231,235.00 |
| 4 |
3,873,862.00 |
160,631.00 |
70,604.00 |
231,235.00 |
82,058.00 |
11,454.00 |
132,336.00 |
3,741,526.00 |
231,235.00 |
| 5 |
3,710,420.00 |
163,442.00 |
67,793.00 |
231,235.00 |
78,912.00 |
11,119.00 |
121,217.00 |
3,589,203.00 |
231,235.00 |
| 6 |
3,544,117.00 |
166,303.00 |
64,932.00 |
231,235.00 |
75,699.00 |
10,767.00 |
110,450.00 |
3,433,667.00 |
231,235.00 |
| 7 |
3,374,904.00 |
169,213.00 |
62,022.00 |
231,235.00 |
72,419.00 |
10,397.00 |
100,053.00 |
3,274,851.00 |
231,235.00 |
| 8 |
3,202,730.00 |
172,174.00 |
59,061.00 |
231,235.00 |
69,069.00 |
10,008.00 |
90,045.00 |
3,112,685.00 |
231,235.00 |
| 9 |
3,027,543.00 |
175,187.00 |
56,048.00 |
231,235.00 |
65,649.00 |
9,601.00 |
80,444.00 |
2,947,099.00 |
231,235.00 |
| 10 |
2,849,290.00 |
178,253.00 |
52,982.00 |
231,235.00 |
62,156.00 |
9,174.00 |
71,270.00 |
2,778,020.00 |
231,235.00 |
| 11 |
2,667,918.00 |
181,372.00 |
49,863.00 |
231,235.00 |
58,590.00 |
8,727.00 |
62,543.00 |
2,605,375.00 |
231,235.00 |
| 12 |
2,483,372.00 |
184,546.00 |
46,689.00 |
231,235.00 |
54,949.00 |
8,260.00 |
54,283.00 |
2,429,089.00 |
231,235.00 |
| 13 |
2,295,596.00 |
187,776.00 |
43,459.00 |
231,235.00 |
51,231.00 |
7,772.00 |
46,511.00 |
2,249,085.00 |
231,235.00 |
| 14 |
2,104,534.00 |
191,062.00 |
40,173.00 |
231,235.00 |
47,435.00 |
7,262.00 |
39,249.00 |
2,065,285.00 |
231,235.00 |
| 15 |
1,910,128.00 |
194,406.00 |
36,829.00 |
231,235.00 |
43,558.00 |
6,729.00 |
32,520.00 |
1,877,608.00 |
231,235.00 |
| 16 |
1,712,320.00 |
197,808.00 |
33,427.00 |
231,235.00 |
39,600.00 |
6,173.00 |
26,347.00 |
1,685,973.00 |
231,235.00 |
| 17 |
1,511,051.00 |
201,269.00 |
29,966.00 |
231,235.00 |
35,558.00 |
5,592.00 |
20,755.00 |
1,490,296.00 |
231,235.00 |
| 18 |
1,306,259.00 |
204,792.00 |
26,443.00 |
231,235.00 |
31,431.00 |
4,988.00 |
15,767.00 |
1,290,492.00 |
231,235.00 |
| 19 |
1,097,884.00 |
208,375.00 |
22,860.00 |
231,235.00 |
27,217.00 |
4,357.00 |
11,410.00 |
1,086,474.00 |
231,235.00 |
| 20 |
885,862.00 |
212,022.00 |
19,213.00 |
231,235.00 |
22,915.00 |
3,702.00 |
7,708.00 |
878,154.00 |
231,235.00 |
| 21 |
670,130.00 |
215,732.00 |
15,503.00 |
231,235.00 |
18,521.00 |
3,018.00 |
4,690.00 |
665,440.00 |
231,235.00 |
| 22 |
450,622.00 |
219,508.00 |
11,727.00 |
231,235.00 |
14,035.00 |
2,308.00 |
2,382.00 |
448,240.00 |
231,235.00 |
| 23 |
227,273.00 |
223,349.00 |
7,886.00 |
231,235.00 |
9,454.00 |
1,568.00 |
814.00 |
226,459.00 |
231,235.00 |
| 24 |
15.00 |
227,258.00 |
3,977.00 |
231,235.00 |
4,776.00 |
799.00 |
15.00 |
0.00 |
231,235.00 |