EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
6,750,000.00 |
|
|
|
|
|
100,000.00 |
6,650,000.00 |
6,850,000.00 |
| 1 |
6,528,120.00 |
221,880.00 |
135,000.00 |
356,880.00 |
124,395.00 |
-10,605.00 |
89,395.00 |
6,617,515.00 |
356,880.00 |
| 2 |
6,301,802.00 |
226,318.00 |
130,562.00 |
356,880.00 |
123,787.00 |
-6,775.00 |
82,620.00 |
6,384,422.00 |
356,880.00 |
| 3 |
6,070,958.00 |
230,844.00 |
126,036.00 |
356,880.00 |
119,427.00 |
-6,609.00 |
76,011.00 |
6,146,969.00 |
356,880.00 |
| 4 |
5,835,497.00 |
235,461.00 |
121,419.00 |
356,880.00 |
114,985.00 |
-6,434.00 |
69,577.00 |
5,905,074.00 |
356,880.00 |
| 5 |
5,595,327.00 |
240,170.00 |
116,710.00 |
356,880.00 |
110,460.00 |
-6,250.00 |
63,327.00 |
5,658,654.00 |
356,880.00 |
| 6 |
5,350,354.00 |
244,973.00 |
111,907.00 |
356,880.00 |
105,851.00 |
-6,056.00 |
57,271.00 |
5,407,625.00 |
356,880.00 |
| 7 |
5,100,481.00 |
249,873.00 |
107,007.00 |
356,880.00 |
101,155.00 |
-5,852.00 |
51,419.00 |
5,151,900.00 |
356,880.00 |
| 8 |
4,845,611.00 |
254,870.00 |
102,010.00 |
356,880.00 |
96,372.00 |
-5,638.00 |
45,781.00 |
4,891,392.00 |
356,880.00 |
| 9 |
4,585,643.00 |
259,968.00 |
96,912.00 |
356,880.00 |
91,498.00 |
-5,414.00 |
40,367.00 |
4,626,010.00 |
356,880.00 |
| 10 |
4,320,476.00 |
265,167.00 |
91,713.00 |
356,880.00 |
86,534.00 |
-5,179.00 |
35,188.00 |
4,355,664.00 |
356,880.00 |
| 11 |
4,050,006.00 |
270,470.00 |
86,410.00 |
356,880.00 |
81,477.00 |
-4,933.00 |
30,255.00 |
4,080,261.00 |
356,880.00 |
| 12 |
3,774,126.00 |
275,880.00 |
81,000.00 |
356,880.00 |
76,325.00 |
-4,675.00 |
25,580.00 |
3,799,706.00 |
356,880.00 |
| 13 |
3,492,729.00 |
281,397.00 |
75,483.00 |
356,880.00 |
71,077.00 |
-4,406.00 |
21,174.00 |
3,513,903.00 |
356,880.00 |
| 14 |
3,205,704.00 |
287,025.00 |
69,855.00 |
356,880.00 |
65,731.00 |
-4,124.00 |
17,050.00 |
3,222,754.00 |
356,880.00 |
| 15 |
2,912,938.00 |
292,766.00 |
64,114.00 |
356,880.00 |
60,285.00 |
-3,829.00 |
13,221.00 |
2,926,159.00 |
356,880.00 |
| 16 |
2,614,317.00 |
298,621.00 |
58,259.00 |
356,880.00 |
54,737.00 |
-3,522.00 |
9,699.00 |
2,624,016.00 |
356,880.00 |
| 17 |
2,309,723.00 |
304,594.00 |
52,286.00 |
356,880.00 |
49,085.00 |
-3,201.00 |
6,498.00 |
2,316,221.00 |
356,880.00 |
| 18 |
1,999,037.00 |
310,686.00 |
46,194.00 |
356,880.00 |
43,327.00 |
-2,867.00 |
3,631.00 |
2,002,668.00 |
356,880.00 |
| 19 |
1,682,138.00 |
316,899.00 |
39,981.00 |
356,880.00 |
37,462.00 |
-2,519.00 |
1,112.00 |
1,683,250.00 |
356,880.00 |
| 20 |
1,358,901.00 |
323,237.00 |
33,643.00 |
356,880.00 |
31,487.00 |
-2,156.00 |
1,044.00 |
1,357,857.00 |
356,880.00 |
| 21 |
1,029,199.00 |
329,702.00 |
27,178.00 |
356,880.00 |
25,400.00 |
-1,778.00 |
2,822.00 |
1,026,377.00 |
356,880.00 |
| 22 |
692,903.00 |
336,296.00 |
20,584.00 |
356,880.00 |
19,199.00 |
-1,385.00 |
4,207.00 |
688,696.00 |
356,880.00 |
| 23 |
349,881.00 |
343,022.00 |
13,858.00 |
356,880.00 |
12,883.00 |
-975.00 |
5,182.00 |
344,699.00 |
356,880.00 |
| 24 |
-1.00 |
349,882.00 |
6,998.00 |
356,880.00 |
6,448.00 |
-550.00 |
5,732.00 |
-5,733.00 |
356,880.00 |