EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
3,500,000.00 |
|
|
|
|
|
140,000.00 |
3,360,000.00 |
3,360,000.00 |
| 1 |
3,377,766.00 |
122,234.00 |
52,500.00 |
174,734.00 |
62,314.00 |
9,814.00 |
130,186.00 |
3,247,580.00 |
174,734.00 |
| 2 |
3,253,698.00 |
124,068.00 |
50,666.00 |
174,734.00 |
60,229.00 |
9,563.00 |
120,623.00 |
3,133,075.00 |
174,734.00 |
| 3 |
3,127,769.00 |
125,929.00 |
48,805.00 |
174,734.00 |
58,105.00 |
9,300.00 |
111,323.00 |
3,016,446.00 |
174,734.00 |
| 4 |
2,999,952.00 |
127,817.00 |
46,917.00 |
174,734.00 |
55,943.00 |
9,026.00 |
102,297.00 |
2,897,655.00 |
174,734.00 |
| 5 |
2,870,217.00 |
129,735.00 |
44,999.00 |
174,734.00 |
53,739.00 |
8,740.00 |
93,557.00 |
2,776,660.00 |
174,734.00 |
| 6 |
2,738,536.00 |
131,681.00 |
43,053.00 |
174,734.00 |
51,495.00 |
8,442.00 |
85,115.00 |
2,653,421.00 |
174,734.00 |
| 7 |
2,604,880.00 |
133,656.00 |
41,078.00 |
174,734.00 |
49,210.00 |
8,132.00 |
76,983.00 |
2,527,897.00 |
174,734.00 |
| 8 |
2,469,219.00 |
135,661.00 |
39,073.00 |
174,734.00 |
46,882.00 |
7,809.00 |
69,174.00 |
2,400,045.00 |
174,734.00 |
| 9 |
2,331,523.00 |
137,696.00 |
37,038.00 |
174,734.00 |
44,511.00 |
7,473.00 |
61,701.00 |
2,269,822.00 |
174,734.00 |
| 10 |
2,191,762.00 |
139,761.00 |
34,973.00 |
174,734.00 |
42,096.00 |
7,123.00 |
54,578.00 |
2,137,184.00 |
174,734.00 |
| 11 |
2,049,904.00 |
141,858.00 |
32,876.00 |
174,734.00 |
39,636.00 |
6,760.00 |
47,818.00 |
2,002,086.00 |
174,734.00 |
| 12 |
1,905,919.00 |
143,985.00 |
30,749.00 |
174,734.00 |
37,130.00 |
6,381.00 |
41,437.00 |
1,864,482.00 |
174,734.00 |
| 13 |
1,759,774.00 |
146,145.00 |
28,589.00 |
174,734.00 |
34,578.00 |
5,989.00 |
35,448.00 |
1,724,326.00 |
174,734.00 |
| 14 |
1,611,437.00 |
148,337.00 |
26,397.00 |
174,734.00 |
31,979.00 |
5,582.00 |
29,866.00 |
1,581,571.00 |
174,734.00 |
| 15 |
1,460,875.00 |
150,562.00 |
24,172.00 |
174,734.00 |
29,332.00 |
5,160.00 |
24,706.00 |
1,436,169.00 |
174,734.00 |
| 16 |
1,308,054.00 |
152,821.00 |
21,913.00 |
174,734.00 |
26,635.00 |
4,722.00 |
19,984.00 |
1,288,070.00 |
174,734.00 |
| 17 |
1,152,941.00 |
155,113.00 |
19,621.00 |
174,734.00 |
23,888.00 |
4,267.00 |
15,717.00 |
1,137,224.00 |
174,734.00 |
| 18 |
995,501.00 |
157,440.00 |
17,294.00 |
174,734.00 |
21,091.00 |
3,797.00 |
11,920.00 |
983,581.00 |
174,734.00 |
| 19 |
835,700.00 |
159,801.00 |
14,933.00 |
174,734.00 |
18,241.00 |
3,308.00 |
8,612.00 |
827,088.00 |
174,734.00 |
| 20 |
673,502.00 |
162,198.00 |
12,536.00 |
174,734.00 |
15,339.00 |
2,803.00 |
5,809.00 |
667,693.00 |
174,734.00 |
| 21 |
508,871.00 |
164,631.00 |
10,103.00 |
174,734.00 |
12,383.00 |
2,280.00 |
3,529.00 |
505,342.00 |
174,734.00 |
| 22 |
341,770.00 |
167,101.00 |
7,633.00 |
174,734.00 |
9,372.00 |
1,739.00 |
1,790.00 |
339,980.00 |
174,734.00 |
| 23 |
172,163.00 |
169,607.00 |
5,127.00 |
174,734.00 |
6,305.00 |
1,178.00 |
612.00 |
171,551.00 |
174,734.00 |
| 24 |
11.00 |
172,152.00 |
2,582.00 |
174,734.00 |
3,182.00 |
600.00 |
12.00 |
-1.00 |
174,734.00 |