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,897,191.00 |
102,809.00 |
82,500.00 |
185,309.00 |
91,204.00 |
8,704.00 |
191,296.00 |
4,705,895.00 |
185,309.00 |
| 2 |
4,792,686.00 |
104,505.00 |
80,804.00 |
185,309.00 |
89,416.00 |
8,612.00 |
182,684.00 |
4,610,002.00 |
185,309.00 |
| 3 |
4,686,456.00 |
106,230.00 |
79,079.00 |
185,309.00 |
87,594.00 |
8,515.00 |
174,169.00 |
4,512,287.00 |
185,309.00 |
| 4 |
4,578,474.00 |
107,982.00 |
77,327.00 |
185,309.00 |
85,737.00 |
8,410.00 |
165,759.00 |
4,412,715.00 |
185,309.00 |
| 5 |
4,468,710.00 |
109,764.00 |
75,545.00 |
185,309.00 |
83,845.00 |
8,300.00 |
157,459.00 |
4,311,251.00 |
185,309.00 |
| 6 |
4,357,135.00 |
111,575.00 |
73,734.00 |
185,309.00 |
81,917.00 |
8,183.00 |
149,276.00 |
4,207,859.00 |
185,309.00 |
| 7 |
4,243,719.00 |
113,416.00 |
71,893.00 |
185,309.00 |
79,953.00 |
8,060.00 |
141,216.00 |
4,102,503.00 |
185,309.00 |
| 8 |
4,128,431.00 |
115,288.00 |
70,021.00 |
185,309.00 |
77,951.00 |
7,930.00 |
133,286.00 |
3,995,145.00 |
185,309.00 |
| 9 |
4,011,241.00 |
117,190.00 |
68,119.00 |
185,309.00 |
75,911.00 |
7,792.00 |
125,494.00 |
3,885,747.00 |
185,309.00 |
| 10 |
3,892,117.00 |
119,124.00 |
66,185.00 |
185,309.00 |
73,832.00 |
7,647.00 |
117,847.00 |
3,774,270.00 |
185,309.00 |
| 11 |
3,771,028.00 |
121,089.00 |
64,220.00 |
185,309.00 |
71,714.00 |
7,494.00 |
110,353.00 |
3,660,675.00 |
185,309.00 |
| 12 |
3,647,941.00 |
123,087.00 |
62,222.00 |
185,309.00 |
69,556.00 |
7,334.00 |
103,019.00 |
3,544,922.00 |
185,309.00 |
| 13 |
3,522,823.00 |
125,118.00 |
60,191.00 |
185,309.00 |
67,356.00 |
7,165.00 |
95,854.00 |
3,426,969.00 |
185,309.00 |
| 14 |
3,395,641.00 |
127,182.00 |
58,127.00 |
185,309.00 |
65,115.00 |
6,988.00 |
88,866.00 |
3,306,775.00 |
185,309.00 |
| 15 |
3,266,360.00 |
129,281.00 |
56,028.00 |
185,309.00 |
62,831.00 |
6,803.00 |
82,063.00 |
3,184,297.00 |
185,309.00 |
| 16 |
3,134,946.00 |
131,414.00 |
53,895.00 |
185,309.00 |
60,504.00 |
6,609.00 |
75,454.00 |
3,059,492.00 |
185,309.00 |
| 17 |
3,001,364.00 |
133,582.00 |
51,727.00 |
185,309.00 |
58,133.00 |
6,406.00 |
69,048.00 |
2,932,316.00 |
185,309.00 |
| 18 |
2,865,577.00 |
135,787.00 |
49,523.00 |
185,310.00 |
55,716.00 |
6,193.00 |
62,855.00 |
2,802,722.00 |
185,309.00 |
| 19 |
2,727,550.00 |
138,027.00 |
47,282.00 |
185,309.00 |
53,254.00 |
5,972.00 |
56,883.00 |
2,670,667.00 |
185,309.00 |
| 20 |
2,587,246.00 |
140,304.00 |
45,005.00 |
185,309.00 |
50,745.00 |
5,740.00 |
51,143.00 |
2,536,103.00 |
185,309.00 |
| 21 |
2,444,627.00 |
142,619.00 |
42,690.00 |
185,309.00 |
48,188.00 |
5,498.00 |
45,645.00 |
2,398,982.00 |
185,309.00 |
| 22 |
2,299,654.00 |
144,973.00 |
40,336.00 |
185,309.00 |
45,583.00 |
5,247.00 |
40,398.00 |
2,259,256.00 |
185,309.00 |
| 23 |
2,152,289.00 |
147,365.00 |
37,944.00 |
185,309.00 |
42,928.00 |
4,984.00 |
35,414.00 |
2,116,875.00 |
185,309.00 |
| 24 |
2,002,493.00 |
149,796.00 |
35,513.00 |
185,309.00 |
40,222.00 |
4,709.00 |
30,705.00 |
1,971,788.00 |
185,309.00 |
| 25 |
1,850,225.00 |
152,268.00 |
33,041.00 |
185,309.00 |
37,465.00 |
4,424.00 |
26,281.00 |
1,823,944.00 |
185,309.00 |
| 26 |
1,695,445.00 |
154,780.00 |
30,529.00 |
185,309.00 |
34,656.00 |
4,127.00 |
22,154.00 |
1,673,291.00 |
185,309.00 |
| 27 |
1,538,111.00 |
157,334.00 |
27,975.00 |
185,309.00 |
31,794.00 |
3,819.00 |
18,335.00 |
1,519,776.00 |
185,309.00 |
| 28 |
1,378,181.00 |
159,930.00 |
25,379.00 |
185,309.00 |
28,877.00 |
3,498.00 |
14,837.00 |
1,363,344.00 |
185,309.00 |
| 29 |
1,215,612.00 |
162,569.00 |
22,740.00 |
185,309.00 |
25,905.00 |
3,165.00 |
11,672.00 |
1,203,940.00 |
185,309.00 |
| 30 |
1,050,361.00 |
165,251.00 |
20,058.00 |
185,309.00 |
22,876.00 |
2,818.00 |
8,854.00 |
1,041,507.00 |
185,309.00 |
| 31 |
882,383.00 |
167,978.00 |
17,331.00 |
185,309.00 |
19,789.00 |
2,458.00 |
6,396.00 |
875,987.00 |
185,309.00 |
| 32 |
711,633.00 |
170,750.00 |
14,559.00 |
185,309.00 |
16,644.00 |
2,085.00 |
4,311.00 |
707,322.00 |
185,309.00 |
| 33 |
538,066.00 |
173,567.00 |
11,742.00 |
185,309.00 |
13,440.00 |
1,698.00 |
2,613.00 |
535,453.00 |
185,309.00 |
| 34 |
361,635.00 |
176,431.00 |
8,878.00 |
185,309.00 |
10,174.00 |
1,296.00 |
1,317.00 |
360,318.00 |
185,309.00 |
| 35 |
182,293.00 |
179,342.00 |
5,967.00 |
185,309.00 |
6,846.00 |
879.00 |
438.00 |
181,855.00 |
185,309.00 |
| 36 |
-8.00 |
182,301.00 |
3,008.00 |
185,309.00 |
3,455.00 |
447.00 |
9.00 |
1.00 |
185,309.00 |