EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
5,000,000.00 |
|
|
|
|
|
200,000.00 |
4,800,000.00 |
4,800,000.00 |
| 1 |
4,825,379.00 |
174,621.00 |
75,000.00 |
249,621.00 |
89,022.00 |
14,022.00 |
185,978.00 |
4,639,401.00 |
249,621.00 |
| 2 |
4,648,139.00 |
177,240.00 |
72,381.00 |
249,621.00 |
86,043.00 |
13,662.00 |
172,316.00 |
4,475,823.00 |
249,621.00 |
| 3 |
4,468,240.00 |
179,899.00 |
69,722.00 |
249,621.00 |
83,009.00 |
13,287.00 |
159,029.00 |
4,309,211.00 |
249,621.00 |
| 4 |
4,285,643.00 |
182,597.00 |
67,024.00 |
249,621.00 |
79,919.00 |
12,895.00 |
146,134.00 |
4,139,509.00 |
249,621.00 |
| 5 |
4,100,307.00 |
185,336.00 |
64,285.00 |
249,621.00 |
76,772.00 |
12,487.00 |
133,647.00 |
3,966,660.00 |
249,621.00 |
| 6 |
3,912,191.00 |
188,116.00 |
61,505.00 |
249,621.00 |
73,566.00 |
12,061.00 |
121,586.00 |
3,790,605.00 |
249,621.00 |
| 7 |
3,721,253.00 |
190,938.00 |
58,683.00 |
249,621.00 |
70,301.00 |
11,618.00 |
109,968.00 |
3,611,285.00 |
249,621.00 |
| 8 |
3,527,451.00 |
193,802.00 |
55,819.00 |
249,621.00 |
66,976.00 |
11,157.00 |
98,811.00 |
3,428,640.00 |
249,621.00 |
| 9 |
3,330,742.00 |
196,709.00 |
52,912.00 |
249,621.00 |
63,588.00 |
10,676.00 |
88,135.00 |
3,242,607.00 |
249,621.00 |
| 10 |
3,131,082.00 |
199,660.00 |
49,961.00 |
249,621.00 |
60,138.00 |
10,177.00 |
77,958.00 |
3,053,124.00 |
249,621.00 |
| 11 |
2,928,427.00 |
202,655.00 |
46,966.00 |
249,621.00 |
56,624.00 |
9,658.00 |
68,300.00 |
2,860,127.00 |
249,621.00 |
| 12 |
2,722,732.00 |
205,695.00 |
43,926.00 |
249,621.00 |
53,044.00 |
9,118.00 |
59,182.00 |
2,663,550.00 |
249,621.00 |
| 13 |
2,513,952.00 |
208,780.00 |
40,841.00 |
249,621.00 |
49,399.00 |
8,558.00 |
50,624.00 |
2,463,328.00 |
249,621.00 |
| 14 |
2,302,040.00 |
211,912.00 |
37,709.00 |
249,621.00 |
45,685.00 |
7,976.00 |
42,648.00 |
2,259,392.00 |
249,621.00 |
| 15 |
2,086,950.00 |
215,090.00 |
34,531.00 |
249,621.00 |
41,903.00 |
7,372.00 |
35,276.00 |
2,051,674.00 |
249,621.00 |
| 16 |
1,868,633.00 |
218,317.00 |
31,304.00 |
249,621.00 |
38,051.00 |
6,747.00 |
28,529.00 |
1,840,104.00 |
249,621.00 |
| 17 |
1,647,041.00 |
221,592.00 |
28,029.00 |
249,621.00 |
34,127.00 |
6,098.00 |
22,431.00 |
1,624,610.00 |
249,621.00 |
| 18 |
1,422,126.00 |
224,915.00 |
24,706.00 |
249,621.00 |
30,130.00 |
5,424.00 |
17,007.00 |
1,405,119.00 |
249,621.00 |
| 19 |
1,193,837.00 |
228,289.00 |
21,332.00 |
249,621.00 |
26,060.00 |
4,728.00 |
12,279.00 |
1,181,558.00 |
249,621.00 |
| 20 |
962,124.00 |
231,713.00 |
17,908.00 |
249,621.00 |
21,913.00 |
4,005.00 |
8,274.00 |
953,850.00 |
249,621.00 |
| 21 |
726,935.00 |
235,189.00 |
14,432.00 |
249,621.00 |
17,690.00 |
3,258.00 |
5,016.00 |
721,919.00 |
249,621.00 |
| 22 |
488,218.00 |
238,717.00 |
10,904.00 |
249,621.00 |
13,389.00 |
2,485.00 |
2,531.00 |
485,687.00 |
249,621.00 |
| 23 |
245,920.00 |
242,298.00 |
7,323.00 |
249,621.00 |
9,008.00 |
1,685.00 |
846.00 |
245,074.00 |
249,621.00 |
| 24 |
-12.00 |
245,932.00 |
3,689.00 |
249,621.00 |
4,545.00 |
856.00 |
10.00 |
-2.00 |
249,621.00 |