EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
20,000,000.00 |
|
|
|
|
|
800,000.00 |
19,200,000.00 |
19,200,000.00 |
| 1 |
19,588,765.00 |
411,235.00 |
330,000.00 |
741,235.00 |
364,813.00 |
34,813.00 |
765,187.00 |
18,823,578.00 |
741,235.00 |
| 2 |
19,170,745.00 |
418,020.00 |
323,215.00 |
741,235.00 |
357,661.00 |
34,446.00 |
730,741.00 |
18,440,004.00 |
741,235.00 |
| 3 |
18,745,827.00 |
424,918.00 |
316,317.00 |
741,235.00 |
350,373.00 |
34,056.00 |
696,685.00 |
18,049,142.00 |
741,235.00 |
| 4 |
18,313,898.00 |
431,929.00 |
309,306.00 |
741,235.00 |
342,946.00 |
33,640.00 |
663,045.00 |
17,650,853.00 |
741,235.00 |
| 5 |
17,874,842.00 |
439,056.00 |
302,179.00 |
741,235.00 |
335,378.00 |
33,199.00 |
629,846.00 |
17,244,996.00 |
741,235.00 |
| 6 |
17,428,542.00 |
446,300.00 |
294,935.00 |
741,235.00 |
327,667.00 |
32,732.00 |
597,114.00 |
16,831,428.00 |
741,235.00 |
| 7 |
16,974,878.00 |
453,664.00 |
287,571.00 |
741,235.00 |
319,809.00 |
32,238.00 |
564,876.00 |
16,410,002.00 |
741,235.00 |
| 8 |
16,513,728.00 |
461,150.00 |
280,085.00 |
741,235.00 |
311,801.00 |
31,716.00 |
533,160.00 |
15,980,568.00 |
741,235.00 |
| 9 |
16,044,970.00 |
468,758.00 |
272,477.00 |
741,235.00 |
303,642.00 |
31,165.00 |
501,995.00 |
15,542,975.00 |
741,235.00 |
| 10 |
15,568,477.00 |
476,493.00 |
264,742.00 |
741,235.00 |
295,327.00 |
30,585.00 |
471,410.00 |
15,097,067.00 |
741,235.00 |
| 11 |
15,084,122.00 |
484,355.00 |
256,880.00 |
741,235.00 |
286,855.00 |
29,975.00 |
441,435.00 |
14,642,687.00 |
741,235.00 |
| 12 |
14,591,775.00 |
492,347.00 |
248,888.00 |
741,235.00 |
278,221.00 |
29,333.00 |
412,102.00 |
14,179,673.00 |
741,235.00 |
| 13 |
14,091,304.00 |
500,471.00 |
240,764.00 |
741,235.00 |
269,424.00 |
28,660.00 |
383,442.00 |
13,707,862.00 |
741,235.00 |
| 14 |
13,582,576.00 |
508,728.00 |
232,507.00 |
741,235.00 |
260,459.00 |
27,952.00 |
355,490.00 |
13,227,086.00 |
741,235.00 |
| 15 |
13,065,454.00 |
517,122.00 |
224,113.00 |
741,235.00 |
251,324.00 |
27,211.00 |
328,279.00 |
12,737,175.00 |
741,235.00 |
| 16 |
12,539,799.00 |
525,655.00 |
215,580.00 |
741,235.00 |
242,015.00 |
26,435.00 |
301,844.00 |
12,237,955.00 |
741,235.00 |
| 17 |
12,005,471.00 |
534,328.00 |
206,907.00 |
741,235.00 |
232,530.00 |
25,623.00 |
276,221.00 |
11,729,250.00 |
741,235.00 |
| 18 |
11,462,326.00 |
543,145.00 |
198,090.00 |
741,235.00 |
222,864.00 |
24,774.00 |
251,447.00 |
11,210,879.00 |
741,235.00 |
| 19 |
10,910,219.00 |
552,107.00 |
189,128.00 |
741,235.00 |
213,014.00 |
23,886.00 |
227,561.00 |
10,682,658.00 |
741,235.00 |
| 20 |
10,349,003.00 |
561,216.00 |
180,019.00 |
741,235.00 |
202,978.00 |
22,959.00 |
204,602.00 |
10,144,401.00 |
741,235.00 |
| 21 |
9,778,527.00 |
570,476.00 |
170,759.00 |
741,235.00 |
192,751.00 |
21,992.00 |
182,610.00 |
9,595,917.00 |
741,235.00 |
| 22 |
9,198,638.00 |
579,889.00 |
161,346.00 |
741,235.00 |
182,329.00 |
20,983.00 |
161,627.00 |
9,037,011.00 |
741,235.00 |
| 23 |
8,609,181.00 |
589,457.00 |
151,778.00 |
741,235.00 |
171,709.00 |
19,931.00 |
141,696.00 |
8,467,485.00 |
741,235.00 |
| 24 |
8,009,997.00 |
599,184.00 |
142,051.00 |
741,235.00 |
160,888.00 |
18,837.00 |
122,859.00 |
7,887,138.00 |
741,235.00 |
| 25 |
7,400,927.00 |
609,070.00 |
132,165.00 |
741,235.00 |
149,861.00 |
17,696.00 |
105,163.00 |
7,295,764.00 |
741,235.00 |
| 26 |
6,781,807.00 |
619,120.00 |
122,115.00 |
741,235.00 |
138,625.00 |
16,510.00 |
88,653.00 |
6,693,154.00 |
741,235.00 |
| 27 |
6,152,472.00 |
629,335.00 |
111,900.00 |
741,235.00 |
127,175.00 |
15,275.00 |
73,378.00 |
6,079,094.00 |
741,235.00 |
| 28 |
5,512,753.00 |
639,719.00 |
101,516.00 |
741,235.00 |
115,507.00 |
13,991.00 |
59,387.00 |
5,453,366.00 |
741,235.00 |
| 29 |
4,862,478.00 |
650,275.00 |
90,960.00 |
741,235.00 |
103,618.00 |
12,658.00 |
46,729.00 |
4,815,749.00 |
741,235.00 |
| 30 |
4,201,474.00 |
661,004.00 |
80,231.00 |
741,235.00 |
91,503.00 |
11,272.00 |
35,457.00 |
4,166,017.00 |
741,235.00 |
| 31 |
3,529,563.00 |
671,911.00 |
69,324.00 |
741,235.00 |
79,157.00 |
9,833.00 |
25,624.00 |
3,503,939.00 |
741,235.00 |
| 32 |
2,846,566.00 |
682,997.00 |
58,238.00 |
741,235.00 |
66,577.00 |
8,339.00 |
17,285.00 |
2,829,281.00 |
741,235.00 |
| 33 |
2,152,299.00 |
694,267.00 |
46,968.00 |
741,235.00 |
53,758.00 |
6,790.00 |
10,495.00 |
2,141,804.00 |
741,235.00 |
| 34 |
1,446,577.00 |
705,722.00 |
35,513.00 |
741,235.00 |
40,696.00 |
5,183.00 |
5,312.00 |
1,441,265.00 |
741,235.00 |
| 35 |
729,211.00 |
717,366.00 |
23,869.00 |
741,235.00 |
27,385.00 |
3,516.00 |
1,796.00 |
727,415.00 |
741,235.00 |
| 36 |
8.00 |
729,203.00 |
12,032.00 |
741,235.00 |
13,821.00 |
1,789.00 |
7.00 |
1.00 |
741,235.00 |