EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
7,000,000.00 |
|
|
|
|
|
280,000.00 |
6,720,000.00 |
6,720,000.00 |
| 1 |
6,755,531.00 |
244,469.00 |
105,000.00 |
349,469.00 |
124,630.00 |
19,630.00 |
260,370.00 |
6,495,161.00 |
349,469.00 |
| 2 |
6,507,395.00 |
248,136.00 |
101,333.00 |
349,469.00 |
120,460.00 |
19,127.00 |
241,243.00 |
6,266,152.00 |
349,469.00 |
| 3 |
6,255,537.00 |
251,858.00 |
97,611.00 |
349,469.00 |
116,213.00 |
18,602.00 |
222,641.00 |
6,032,896.00 |
349,469.00 |
| 4 |
5,999,901.00 |
255,636.00 |
93,833.00 |
349,469.00 |
111,887.00 |
18,054.00 |
204,587.00 |
5,795,314.00 |
349,469.00 |
| 5 |
5,740,431.00 |
259,470.00 |
89,999.00 |
349,469.00 |
107,480.00 |
17,481.00 |
187,106.00 |
5,553,325.00 |
349,469.00 |
| 6 |
5,477,068.00 |
263,363.00 |
86,106.00 |
349,469.00 |
102,992.00 |
16,886.00 |
170,220.00 |
5,306,848.00 |
349,469.00 |
| 7 |
5,209,755.00 |
267,313.00 |
82,156.00 |
349,469.00 |
98,421.00 |
16,265.00 |
153,955.00 |
5,055,800.00 |
349,469.00 |
| 8 |
4,938,432.00 |
271,323.00 |
78,146.00 |
349,469.00 |
93,765.00 |
15,619.00 |
138,336.00 |
4,800,096.00 |
349,469.00 |
| 9 |
4,663,039.00 |
275,393.00 |
74,076.00 |
349,469.00 |
89,023.00 |
14,947.00 |
123,389.00 |
4,539,650.00 |
349,469.00 |
| 10 |
4,383,516.00 |
279,523.00 |
69,946.00 |
349,469.00 |
84,193.00 |
14,247.00 |
109,142.00 |
4,274,374.00 |
349,469.00 |
| 11 |
4,099,800.00 |
283,716.00 |
65,753.00 |
349,469.00 |
79,273.00 |
13,520.00 |
95,622.00 |
4,004,178.00 |
349,469.00 |
| 12 |
3,811,828.00 |
287,972.00 |
61,497.00 |
349,469.00 |
74,262.00 |
12,765.00 |
82,857.00 |
3,728,971.00 |
349,469.00 |
| 13 |
3,519,536.00 |
292,292.00 |
57,177.00 |
349,469.00 |
69,158.00 |
11,981.00 |
70,876.00 |
3,448,660.00 |
349,469.00 |
| 14 |
3,222,860.00 |
296,676.00 |
52,793.00 |
349,469.00 |
63,959.00 |
11,166.00 |
59,710.00 |
3,163,150.00 |
349,469.00 |
| 15 |
2,921,734.00 |
301,126.00 |
48,343.00 |
349,469.00 |
58,664.00 |
10,321.00 |
49,389.00 |
2,872,345.00 |
349,469.00 |
| 16 |
2,616,091.00 |
305,643.00 |
43,826.00 |
349,469.00 |
53,271.00 |
9,445.00 |
39,944.00 |
2,576,147.00 |
349,469.00 |
| 17 |
2,305,863.00 |
310,228.00 |
39,241.00 |
349,469.00 |
47,777.00 |
8,536.00 |
31,408.00 |
2,274,455.00 |
349,469.00 |
| 18 |
1,990,982.00 |
314,881.00 |
34,588.00 |
349,469.00 |
42,182.00 |
7,594.00 |
23,814.00 |
1,967,168.00 |
349,469.00 |
| 19 |
1,671,378.00 |
319,604.00 |
29,865.00 |
349,469.00 |
36,483.00 |
6,618.00 |
17,196.00 |
1,654,182.00 |
349,469.00 |
| 20 |
1,346,980.00 |
324,398.00 |
25,071.00 |
349,469.00 |
30,679.00 |
5,608.00 |
11,588.00 |
1,335,392.00 |
349,469.00 |
| 21 |
1,017,716.00 |
329,264.00 |
20,205.00 |
349,469.00 |
24,766.00 |
4,561.00 |
7,027.00 |
1,010,689.00 |
349,469.00 |
| 22 |
683,513.00 |
334,203.00 |
15,266.00 |
349,469.00 |
18,744.00 |
3,478.00 |
3,549.00 |
679,964.00 |
349,469.00 |
| 23 |
344,297.00 |
339,216.00 |
10,253.00 |
349,469.00 |
12,611.00 |
2,358.00 |
1,191.00 |
343,106.00 |
349,469.00 |
| 24 |
-8.00 |
344,305.00 |
5,164.00 |
349,469.00 |
6,363.00 |
1,199.00 |
8.00 |
0.00 |
349,469.00 |