EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
3,000,000.00 |
|
|
|
|
|
120,000.00 |
2,880,000.00 |
2,880,000.00 |
| 1 |
2,895,228.00 |
104,772.00 |
45,000.00 |
149,772.00 |
53,412.00 |
8,412.00 |
111,588.00 |
2,783,640.00 |
149,772.00 |
| 2 |
2,788,884.00 |
106,344.00 |
43,428.00 |
149,772.00 |
51,625.00 |
8,197.00 |
103,391.00 |
2,685,493.00 |
149,772.00 |
| 3 |
2,680,945.00 |
107,939.00 |
41,833.00 |
149,772.00 |
49,805.00 |
7,972.00 |
95,419.00 |
2,585,526.00 |
149,772.00 |
| 4 |
2,571,387.00 |
109,558.00 |
40,214.00 |
149,772.00 |
47,951.00 |
7,737.00 |
87,682.00 |
2,483,705.00 |
149,772.00 |
| 5 |
2,460,186.00 |
111,201.00 |
38,571.00 |
149,772.00 |
46,062.00 |
7,491.00 |
80,191.00 |
2,379,995.00 |
149,772.00 |
| 6 |
2,347,317.00 |
112,869.00 |
36,903.00 |
149,772.00 |
44,139.00 |
7,236.00 |
72,955.00 |
2,274,362.00 |
149,772.00 |
| 7 |
2,232,755.00 |
114,562.00 |
35,210.00 |
149,772.00 |
42,180.00 |
6,970.00 |
65,985.00 |
2,166,770.00 |
149,772.00 |
| 8 |
2,116,474.00 |
116,281.00 |
33,491.00 |
149,772.00 |
40,185.00 |
6,694.00 |
59,291.00 |
2,057,183.00 |
149,772.00 |
| 9 |
1,998,449.00 |
118,025.00 |
31,747.00 |
149,772.00 |
38,152.00 |
6,405.00 |
52,886.00 |
1,945,563.00 |
149,772.00 |
| 10 |
1,878,654.00 |
119,795.00 |
29,977.00 |
149,772.00 |
36,082.00 |
6,105.00 |
46,781.00 |
1,831,873.00 |
149,772.00 |
| 11 |
1,757,062.00 |
121,592.00 |
28,180.00 |
149,772.00 |
33,974.00 |
5,794.00 |
40,987.00 |
1,716,075.00 |
149,772.00 |
| 12 |
1,633,646.00 |
123,416.00 |
26,356.00 |
149,772.00 |
31,826.00 |
5,470.00 |
35,517.00 |
1,598,129.00 |
149,772.00 |
| 13 |
1,508,379.00 |
125,267.00 |
24,505.00 |
149,772.00 |
29,639.00 |
5,134.00 |
30,383.00 |
1,477,996.00 |
149,772.00 |
| 14 |
1,381,233.00 |
127,146.00 |
22,626.00 |
149,772.00 |
27,411.00 |
4,785.00 |
25,598.00 |
1,355,635.00 |
149,772.00 |
| 15 |
1,252,179.00 |
129,054.00 |
20,718.00 |
149,772.00 |
25,141.00 |
4,423.00 |
21,175.00 |
1,231,004.00 |
149,772.00 |
| 16 |
1,121,190.00 |
130,989.00 |
18,783.00 |
149,772.00 |
22,830.00 |
4,047.00 |
17,128.00 |
1,104,062.00 |
149,772.00 |
| 17 |
988,236.00 |
132,954.00 |
16,818.00 |
149,772.00 |
20,476.00 |
3,658.00 |
13,470.00 |
974,766.00 |
149,772.00 |
| 18 |
853,288.00 |
134,948.00 |
14,824.00 |
149,772.00 |
18,078.00 |
3,254.00 |
10,216.00 |
843,072.00 |
149,772.00 |
| 19 |
716,315.00 |
136,973.00 |
12,799.00 |
149,772.00 |
15,635.00 |
2,836.00 |
7,380.00 |
708,935.00 |
149,772.00 |
| 20 |
577,288.00 |
139,027.00 |
10,745.00 |
149,772.00 |
13,148.00 |
2,403.00 |
4,977.00 |
572,311.00 |
149,772.00 |
| 21 |
436,175.00 |
141,113.00 |
8,659.00 |
149,772.00 |
10,614.00 |
1,955.00 |
3,022.00 |
433,153.00 |
149,772.00 |
| 22 |
292,946.00 |
143,229.00 |
6,543.00 |
149,772.00 |
8,033.00 |
1,490.00 |
1,532.00 |
291,414.00 |
149,772.00 |
| 23 |
147,568.00 |
145,378.00 |
4,394.00 |
149,772.00 |
5,405.00 |
1,011.00 |
521.00 |
147,047.00 |
149,772.00 |
| 24 |
10.00 |
147,558.00 |
2,214.00 |
149,772.00 |
2,727.00 |
513.00 |
8.00 |
2.00 |
149,772.00 |