EIR / Data EIR
| Ang ke- |
Baki debet |
Angsuran pokok |
bunga kontraktual |
Angsuran |
bunga efektif |
amortisasi |
Nilai belum diamortisasi |
Nilai bersih |
Cashflow |
|
4,000,000.00 |
|
|
|
|
|
160,000.00 |
3,840,000.00 |
3,840,000.00 |
| 1 |
3,860,304.00 |
139,696.00 |
60,000.00 |
199,696.00 |
71,216.00 |
11,216.00 |
148,784.00 |
3,711,520.00 |
199,696.00 |
| 2 |
3,718,513.00 |
141,791.00 |
57,905.00 |
199,696.00 |
68,833.00 |
10,928.00 |
137,856.00 |
3,580,657.00 |
199,696.00 |
| 3 |
3,574,595.00 |
143,918.00 |
55,778.00 |
199,696.00 |
66,406.00 |
10,628.00 |
127,228.00 |
3,447,367.00 |
199,696.00 |
| 4 |
3,428,518.00 |
146,077.00 |
53,619.00 |
199,696.00 |
63,934.00 |
10,315.00 |
116,913.00 |
3,311,605.00 |
199,696.00 |
| 5 |
3,280,250.00 |
148,268.00 |
51,428.00 |
199,696.00 |
61,416.00 |
9,988.00 |
106,925.00 |
3,173,325.00 |
199,696.00 |
| 6 |
3,129,758.00 |
150,492.00 |
49,204.00 |
199,696.00 |
58,852.00 |
9,648.00 |
97,277.00 |
3,032,481.00 |
199,696.00 |
| 7 |
2,977,008.00 |
152,750.00 |
46,946.00 |
199,696.00 |
56,240.00 |
9,294.00 |
87,983.00 |
2,889,025.00 |
199,696.00 |
| 8 |
2,821,967.00 |
155,041.00 |
44,655.00 |
199,696.00 |
53,579.00 |
8,924.00 |
79,059.00 |
2,742,908.00 |
199,696.00 |
| 9 |
2,664,600.00 |
157,367.00 |
42,330.00 |
199,697.00 |
50,870.00 |
8,540.00 |
70,519.00 |
2,594,081.00 |
199,696.00 |
| 10 |
2,504,873.00 |
159,727.00 |
39,969.00 |
199,696.00 |
48,109.00 |
8,140.00 |
62,379.00 |
2,442,494.00 |
199,696.00 |
| 11 |
2,342,750.00 |
162,123.00 |
37,573.00 |
199,696.00 |
45,298.00 |
7,725.00 |
54,654.00 |
2,288,096.00 |
199,696.00 |
| 12 |
2,178,195.00 |
164,555.00 |
35,141.00 |
199,696.00 |
42,435.00 |
7,294.00 |
47,360.00 |
2,130,835.00 |
199,696.00 |
| 13 |
2,011,172.00 |
167,023.00 |
32,673.00 |
199,696.00 |
39,518.00 |
6,845.00 |
40,515.00 |
1,970,657.00 |
199,696.00 |
| 14 |
1,841,644.00 |
169,528.00 |
30,168.00 |
199,696.00 |
36,547.00 |
6,379.00 |
34,136.00 |
1,807,508.00 |
199,696.00 |
| 15 |
1,669,573.00 |
172,071.00 |
27,625.00 |
199,696.00 |
33,522.00 |
5,897.00 |
28,239.00 |
1,641,334.00 |
199,696.00 |
| 16 |
1,494,921.00 |
174,652.00 |
25,044.00 |
199,696.00 |
30,440.00 |
5,396.00 |
22,843.00 |
1,472,078.00 |
199,696.00 |
| 17 |
1,317,649.00 |
177,272.00 |
22,424.00 |
199,696.00 |
27,301.00 |
4,877.00 |
17,966.00 |
1,299,683.00 |
199,696.00 |
| 18 |
1,137,718.00 |
179,931.00 |
19,765.00 |
199,696.00 |
24,104.00 |
4,339.00 |
13,627.00 |
1,124,091.00 |
199,696.00 |
| 19 |
955,088.00 |
182,630.00 |
17,066.00 |
199,696.00 |
20,847.00 |
3,781.00 |
9,846.00 |
945,242.00 |
199,696.00 |
| 20 |
769,718.00 |
185,370.00 |
14,326.00 |
199,696.00 |
17,530.00 |
3,204.00 |
6,642.00 |
763,076.00 |
199,696.00 |
| 21 |
581,568.00 |
188,150.00 |
11,546.00 |
199,696.00 |
14,152.00 |
2,606.00 |
4,036.00 |
577,532.00 |
199,696.00 |
| 22 |
390,595.00 |
190,973.00 |
8,724.00 |
199,697.00 |
10,711.00 |
1,987.00 |
2,049.00 |
388,546.00 |
199,696.00 |
| 23 |
196,758.00 |
193,837.00 |
5,859.00 |
199,696.00 |
7,206.00 |
1,347.00 |
702.00 |
196,056.00 |
199,696.00 |
| 24 |
13.00 |
196,745.00 |
2,951.00 |
199,696.00 |
3,636.00 |
685.00 |
17.00 |
-4.00 |
199,696.00 |