EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
15,000,000.00 |
|
|
|
|
|
600,000.00 |
14,400,000.00 |
14,400,000.00 |
| 1 |
14,749,603.00 |
250,397.00 |
247,500.00 |
497,897.00 |
269,149.00 |
21,649.00 |
578,351.00 |
14,171,252.00 |
497,897.00 |
| 2 |
14,495,074.00 |
254,529.00 |
243,368.00 |
497,897.00 |
264,873.00 |
21,505.00 |
556,846.00 |
13,938,228.00 |
497,897.00 |
| 3 |
14,236,346.00 |
258,728.00 |
239,169.00 |
497,897.00 |
260,518.00 |
21,349.00 |
535,497.00 |
13,700,849.00 |
497,897.00 |
| 4 |
13,973,349.00 |
262,997.00 |
234,900.00 |
497,897.00 |
256,081.00 |
21,181.00 |
514,316.00 |
13,459,033.00 |
497,897.00 |
| 5 |
13,706,012.00 |
267,337.00 |
230,560.00 |
497,897.00 |
251,561.00 |
21,001.00 |
493,315.00 |
13,212,697.00 |
497,897.00 |
| 6 |
13,434,264.00 |
271,748.00 |
226,149.00 |
497,897.00 |
246,957.00 |
20,808.00 |
472,507.00 |
12,961,757.00 |
497,897.00 |
| 7 |
13,158,032.00 |
276,232.00 |
221,665.00 |
497,897.00 |
242,267.00 |
20,602.00 |
451,905.00 |
12,706,127.00 |
497,897.00 |
| 8 |
12,877,243.00 |
280,789.00 |
217,108.00 |
497,897.00 |
237,489.00 |
20,381.00 |
431,524.00 |
12,445,719.00 |
497,897.00 |
| 9 |
12,591,821.00 |
285,422.00 |
212,475.00 |
497,897.00 |
232,621.00 |
20,146.00 |
411,378.00 |
12,180,443.00 |
497,897.00 |
| 10 |
12,301,689.00 |
290,132.00 |
207,765.00 |
497,897.00 |
227,663.00 |
19,898.00 |
391,480.00 |
11,910,209.00 |
497,897.00 |
| 11 |
12,006,770.00 |
294,919.00 |
202,978.00 |
497,897.00 |
222,612.00 |
19,634.00 |
371,846.00 |
11,634,924.00 |
497,897.00 |
| 12 |
11,706,985.00 |
299,785.00 |
198,112.00 |
497,897.00 |
217,467.00 |
19,355.00 |
352,491.00 |
11,354,494.00 |
497,897.00 |
| 13 |
11,402,253.00 |
304,732.00 |
193,165.00 |
497,897.00 |
212,225.00 |
19,060.00 |
333,431.00 |
11,068,822.00 |
497,897.00 |
| 14 |
11,092,493.00 |
309,760.00 |
188,137.00 |
497,897.00 |
206,886.00 |
18,749.00 |
314,682.00 |
10,777,811.00 |
497,897.00 |
| 15 |
10,777,622.00 |
314,871.00 |
183,026.00 |
497,897.00 |
201,447.00 |
18,421.00 |
296,261.00 |
10,481,361.00 |
497,897.00 |
| 16 |
10,457,556.00 |
320,066.00 |
177,831.00 |
497,897.00 |
195,906.00 |
18,075.00 |
278,186.00 |
10,179,370.00 |
497,897.00 |
| 17 |
10,132,209.00 |
325,347.00 |
172,550.00 |
497,897.00 |
190,261.00 |
17,711.00 |
260,475.00 |
9,871,734.00 |
497,897.00 |
| 18 |
9,801,493.00 |
330,716.00 |
167,181.00 |
497,897.00 |
184,511.00 |
17,330.00 |
243,145.00 |
9,558,348.00 |
497,897.00 |
| 19 |
9,465,321.00 |
336,172.00 |
161,725.00 |
497,897.00 |
178,654.00 |
16,929.00 |
226,216.00 |
9,239,105.00 |
497,897.00 |
| 20 |
9,123,602.00 |
341,719.00 |
156,178.00 |
497,897.00 |
172,687.00 |
16,509.00 |
209,707.00 |
8,913,895.00 |
497,897.00 |
| 21 |
8,776,244.00 |
347,358.00 |
150,539.00 |
497,897.00 |
166,609.00 |
16,070.00 |
193,637.00 |
8,582,607.00 |
497,897.00 |
| 22 |
8,423,155.00 |
353,089.00 |
144,808.00 |
497,897.00 |
160,416.00 |
15,608.00 |
178,029.00 |
8,245,126.00 |
497,897.00 |
| 23 |
8,064,240.00 |
358,915.00 |
138,982.00 |
497,897.00 |
154,109.00 |
15,127.00 |
162,902.00 |
7,901,338.00 |
497,897.00 |
| 24 |
7,699,403.00 |
364,837.00 |
133,060.00 |
497,897.00 |
147,683.00 |
14,623.00 |
148,279.00 |
7,551,124.00 |
497,897.00 |
| 25 |
7,328,546.00 |
370,857.00 |
127,040.00 |
497,897.00 |
141,137.00 |
14,097.00 |
134,182.00 |
7,194,364.00 |
497,897.00 |
| 26 |
6,951,570.00 |
376,976.00 |
120,921.00 |
497,897.00 |
134,469.00 |
13,548.00 |
120,634.00 |
6,830,936.00 |
497,897.00 |
| 27 |
6,568,374.00 |
383,196.00 |
114,701.00 |
497,897.00 |
127,676.00 |
12,975.00 |
107,659.00 |
6,460,715.00 |
497,897.00 |
| 28 |
6,178,855.00 |
389,519.00 |
108,378.00 |
497,897.00 |
120,756.00 |
12,378.00 |
95,281.00 |
6,083,574.00 |
497,897.00 |
| 29 |
5,782,909.00 |
395,946.00 |
101,951.00 |
497,897.00 |
113,707.00 |
11,756.00 |
83,525.00 |
5,699,384.00 |
497,897.00 |
| 30 |
5,380,430.00 |
402,479.00 |
95,418.00 |
497,897.00 |
106,526.00 |
11,108.00 |
72,417.00 |
5,308,013.00 |
497,897.00 |
| 31 |
4,971,310.00 |
409,120.00 |
88,777.00 |
497,897.00 |
99,211.00 |
10,434.00 |
61,983.00 |
4,909,327.00 |
497,897.00 |
| 32 |
4,555,440.00 |
415,870.00 |
82,027.00 |
497,897.00 |
91,760.00 |
9,733.00 |
52,250.00 |
4,503,190.00 |
497,897.00 |
| 33 |
4,132,708.00 |
422,732.00 |
75,165.00 |
497,897.00 |
84,169.00 |
9,004.00 |
43,246.00 |
4,089,462.00 |
497,897.00 |
| 34 |
3,703,001.00 |
429,707.00 |
68,190.00 |
497,897.00 |
76,436.00 |
8,246.00 |
35,000.00 |
3,668,001.00 |
497,897.00 |
| 35 |
3,266,204.00 |
436,797.00 |
61,100.00 |
497,897.00 |
68,558.00 |
7,458.00 |
27,542.00 |
3,238,662.00 |
497,897.00 |
| 36 |
2,822,199.00 |
444,005.00 |
53,892.00 |
497,897.00 |
60,533.00 |
6,641.00 |
20,901.00 |
2,801,298.00 |
497,897.00 |
| 37 |
2,370,868.00 |
451,331.00 |
46,566.00 |
497,897.00 |
52,359.00 |
5,793.00 |
15,108.00 |
2,355,760.00 |
497,897.00 |
| 38 |
1,912,090.00 |
458,778.00 |
39,119.00 |
497,897.00 |
44,031.00 |
4,912.00 |
10,196.00 |
1,901,894.00 |
497,897.00 |
| 39 |
1,445,742.00 |
466,348.00 |
31,549.00 |
497,897.00 |
35,548.00 |
3,999.00 |
6,197.00 |
1,439,545.00 |
497,897.00 |
| 40 |
971,700.00 |
474,042.00 |
23,855.00 |
497,897.00 |
26,906.00 |
3,051.00 |
3,146.00 |
968,554.00 |
497,897.00 |
| 41 |
489,836.00 |
481,864.00 |
16,033.00 |
497,897.00 |
18,103.00 |
2,070.00 |
1,076.00 |
488,760.00 |
497,897.00 |
| 42 |
21.00 |
489,815.00 |
8,082.00 |
497,897.00 |
9,135.00 |
1,053.00 |
23.00 |
-2.00 |
497,897.00 |