EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
8,000,000.00 |
|
|
|
|
|
320,000.00 |
7,680,000.00 |
7,680,000.00 |
| 1 |
7,889,409.00 |
110,591.00 |
132,000.00 |
242,591.00 |
141,758.00 |
9,758.00 |
310,242.00 |
7,579,167.00 |
242,591.00 |
| 2 |
7,776,993.00 |
112,416.00 |
130,175.00 |
242,591.00 |
139,896.00 |
9,721.00 |
300,521.00 |
7,476,472.00 |
242,591.00 |
| 3 |
7,662,722.00 |
114,271.00 |
128,320.00 |
242,591.00 |
138,001.00 |
9,681.00 |
290,840.00 |
7,371,882.00 |
242,591.00 |
| 4 |
7,546,566.00 |
116,156.00 |
126,435.00 |
242,591.00 |
136,070.00 |
9,635.00 |
281,205.00 |
7,265,361.00 |
242,591.00 |
| 5 |
7,428,493.00 |
118,073.00 |
124,518.00 |
242,591.00 |
134,104.00 |
9,586.00 |
271,619.00 |
7,156,874.00 |
242,591.00 |
| 6 |
7,308,472.00 |
120,021.00 |
122,570.00 |
242,591.00 |
132,102.00 |
9,532.00 |
262,087.00 |
7,046,385.00 |
242,591.00 |
| 7 |
7,186,471.00 |
122,001.00 |
120,590.00 |
242,591.00 |
130,062.00 |
9,472.00 |
252,615.00 |
6,933,856.00 |
242,591.00 |
| 8 |
7,062,457.00 |
124,014.00 |
118,577.00 |
242,591.00 |
127,985.00 |
9,408.00 |
243,207.00 |
6,819,250.00 |
242,591.00 |
| 9 |
6,936,397.00 |
126,060.00 |
116,531.00 |
242,591.00 |
125,870.00 |
9,339.00 |
233,868.00 |
6,702,529.00 |
242,591.00 |
| 10 |
6,808,257.00 |
128,140.00 |
114,451.00 |
242,591.00 |
123,715.00 |
9,264.00 |
224,604.00 |
6,583,653.00 |
242,591.00 |
| 11 |
6,678,002.00 |
130,255.00 |
112,336.00 |
242,591.00 |
121,521.00 |
9,185.00 |
215,419.00 |
6,462,583.00 |
242,591.00 |
| 12 |
6,545,598.00 |
132,404.00 |
110,187.00 |
242,591.00 |
119,287.00 |
9,100.00 |
206,319.00 |
6,339,279.00 |
242,591.00 |
| 13 |
6,411,009.00 |
134,589.00 |
108,002.00 |
242,591.00 |
117,011.00 |
9,009.00 |
197,310.00 |
6,213,699.00 |
242,591.00 |
| 14 |
6,274,200.00 |
136,809.00 |
105,782.00 |
242,591.00 |
114,693.00 |
8,911.00 |
188,399.00 |
6,085,801.00 |
242,591.00 |
| 15 |
6,135,133.00 |
139,067.00 |
103,524.00 |
242,591.00 |
112,332.00 |
8,808.00 |
179,591.00 |
5,955,542.00 |
242,591.00 |
| 16 |
5,993,772.00 |
141,361.00 |
101,230.00 |
242,591.00 |
109,928.00 |
8,698.00 |
170,893.00 |
5,822,879.00 |
242,591.00 |
| 17 |
5,850,078.00 |
143,694.00 |
98,897.00 |
242,591.00 |
107,479.00 |
8,582.00 |
162,311.00 |
5,687,767.00 |
242,591.00 |
| 18 |
5,704,013.00 |
146,065.00 |
96,526.00 |
242,591.00 |
104,985.00 |
8,459.00 |
153,852.00 |
5,550,161.00 |
242,591.00 |
| 19 |
5,555,538.00 |
148,475.00 |
94,116.00 |
242,591.00 |
102,445.00 |
8,329.00 |
145,523.00 |
5,410,015.00 |
242,591.00 |
| 20 |
5,404,613.00 |
150,925.00 |
91,666.00 |
242,591.00 |
99,858.00 |
8,192.00 |
137,331.00 |
5,267,282.00 |
242,591.00 |
| 21 |
5,251,198.00 |
153,415.00 |
89,176.00 |
242,591.00 |
97,224.00 |
8,048.00 |
129,283.00 |
5,121,915.00 |
242,591.00 |
| 22 |
5,095,252.00 |
155,946.00 |
86,645.00 |
242,591.00 |
94,540.00 |
7,895.00 |
121,388.00 |
4,973,864.00 |
242,591.00 |
| 23 |
4,936,733.00 |
158,519.00 |
84,072.00 |
242,591.00 |
91,808.00 |
7,736.00 |
113,652.00 |
4,823,081.00 |
242,591.00 |
| 24 |
4,775,598.00 |
161,135.00 |
81,456.00 |
242,591.00 |
89,025.00 |
7,569.00 |
106,083.00 |
4,669,515.00 |
242,591.00 |
| 25 |
4,611,804.00 |
163,794.00 |
78,797.00 |
242,591.00 |
86,190.00 |
7,393.00 |
98,690.00 |
4,513,114.00 |
242,591.00 |
| 26 |
4,445,308.00 |
166,496.00 |
76,095.00 |
242,591.00 |
83,303.00 |
7,208.00 |
91,482.00 |
4,353,826.00 |
242,591.00 |
| 27 |
4,276,065.00 |
169,243.00 |
73,348.00 |
242,591.00 |
80,363.00 |
7,015.00 |
84,467.00 |
4,191,598.00 |
242,591.00 |
| 28 |
4,104,029.00 |
172,036.00 |
70,555.00 |
242,591.00 |
77,369.00 |
6,814.00 |
77,653.00 |
4,026,376.00 |
242,591.00 |
| 29 |
3,929,154.00 |
174,875.00 |
67,716.00 |
242,591.00 |
74,319.00 |
6,603.00 |
71,050.00 |
3,858,104.00 |
242,591.00 |
| 30 |
3,751,394.00 |
177,760.00 |
64,831.00 |
242,591.00 |
71,213.00 |
6,382.00 |
64,668.00 |
3,686,726.00 |
242,591.00 |
| 31 |
3,570,701.00 |
180,693.00 |
61,898.00 |
242,591.00 |
68,050.00 |
6,152.00 |
58,516.00 |
3,512,185.00 |
242,591.00 |
| 32 |
3,387,027.00 |
183,674.00 |
58,917.00 |
242,591.00 |
64,828.00 |
5,911.00 |
52,605.00 |
3,334,422.00 |
242,591.00 |
| 33 |
3,200,322.00 |
186,705.00 |
55,886.00 |
242,591.00 |
61,547.00 |
5,661.00 |
46,944.00 |
3,153,378.00 |
242,591.00 |
| 34 |
3,010,536.00 |
189,786.00 |
52,805.00 |
242,591.00 |
58,205.00 |
5,400.00 |
41,544.00 |
2,968,992.00 |
242,591.00 |
| 35 |
2,817,619.00 |
192,917.00 |
49,674.00 |
242,591.00 |
54,802.00 |
5,128.00 |
36,416.00 |
2,781,203.00 |
242,591.00 |
| 36 |
2,621,519.00 |
196,100.00 |
46,491.00 |
242,591.00 |
51,336.00 |
4,845.00 |
31,571.00 |
2,589,948.00 |
242,591.00 |
| 37 |
2,422,183.00 |
199,336.00 |
43,255.00 |
242,591.00 |
47,805.00 |
4,550.00 |
27,021.00 |
2,395,162.00 |
242,591.00 |
| 38 |
2,219,558.00 |
202,625.00 |
39,966.00 |
242,591.00 |
44,210.00 |
4,244.00 |
22,777.00 |
2,196,781.00 |
242,591.00 |
| 39 |
2,013,590.00 |
205,968.00 |
36,623.00 |
242,591.00 |
40,548.00 |
3,925.00 |
18,852.00 |
1,994,738.00 |
242,591.00 |
| 40 |
1,804,223.00 |
209,367.00 |
33,224.00 |
242,591.00 |
36,819.00 |
3,595.00 |
15,257.00 |
1,788,966.00 |
242,591.00 |
| 41 |
1,591,402.00 |
212,821.00 |
29,770.00 |
242,591.00 |
33,021.00 |
3,251.00 |
12,006.00 |
1,579,396.00 |
242,591.00 |
| 42 |
1,375,069.00 |
216,333.00 |
26,258.00 |
242,591.00 |
29,153.00 |
2,895.00 |
9,111.00 |
1,365,958.00 |
242,591.00 |
| 43 |
1,155,167.00 |
219,902.00 |
22,689.00 |
242,591.00 |
25,213.00 |
2,524.00 |
6,587.00 |
1,148,580.00 |
242,591.00 |
| 44 |
931,636.00 |
223,531.00 |
19,060.00 |
242,591.00 |
21,201.00 |
2,141.00 |
4,446.00 |
927,190.00 |
242,591.00 |
| 45 |
704,417.00 |
227,219.00 |
15,372.00 |
242,591.00 |
17,114.00 |
1,742.00 |
2,704.00 |
701,713.00 |
242,591.00 |
| 46 |
473,449.00 |
230,968.00 |
11,623.00 |
242,591.00 |
12,952.00 |
1,329.00 |
1,375.00 |
472,074.00 |
242,591.00 |
| 47 |
238,670.00 |
234,779.00 |
7,812.00 |
242,591.00 |
8,714.00 |
902.00 |
473.00 |
238,197.00 |
242,591.00 |
| 48 |
17.00 |
238,653.00 |
3,938.00 |
242,591.00 |
4,397.00 |
459.00 |
14.00 |
3.00 |
242,591.00 |