| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | |||||||
2 | |||||||
3 | |||||||
4 | TABEL ANGSURAN KTA PAYROLL | ||||||
5 | Setara dengan: | 16.00% | p.a. effektif floating | ||||
6 | 1.33% | ||||||
7 | PLAFOND | JANGKA WAKTU KREDIT | |||||
8 | 1 | 2 | 3 | 4 | 5 | ||
9 | 12 | 24 | 36 | 48 | 60 | ||
10 | 8.03% | 7.90% | 7.97% | 8.09% | 8.12% | ||
11 | 10,000,000 | 907,309 | 489,631 | 351,570 | 283,403 | 243,181 | |
12 | 15,000,000 | 1,360,963 | 734,447 | 527,355 | 425,104 | 364,771 | |
13 | 20,000,000 | 1,814,617 | 979,262 | 703,141 | 566,806 | 486,361 | |
14 | 25,000,000 | 2,268,271 | 1,224,078 | 878,926 | 708,507 | 607,951 | |
15 | 30,000,000 | 2,721,926 | 1,468,893 | 1,054,711 | 850,208 | 729,542 | |
16 | 35,000,000 | 3,175,580 | 1,713,709 | 1,230,496 | 991,910 | 851,132 | |
17 | 40,000,000 | 3,629,234 | 1,958,524 | 1,406,281 | 1,133,611 | 972,722 | |
18 | 45,000,000 | 4,082,889 | 2,203,340 | 1,582,066 | 1,275,313 | 1,094,313 | |
19 | 50,000,000 | 4,536,543 | 2,448,156 | 1,757,852 | 1,417,014 | 1,215,903 | |
20 | 55,000,000 | 4,990,197 | 2,692,971 | 1,933,637 | 1,558,715 | 1,337,493 | |
21 | 60,000,000 | 5,443,851 | 2,937,787 | 2,109,422 | 1,700,417 | 1,459,083 | |
22 | 65,000,000 | 5,897,506 | 3,182,602 | 2,285,207 | 1,842,118 | 1,580,674 | |
23 | 70,000,000 | 6,351,160 | 3,427,418 | 2,460,992 | 1,983,820 | 1,702,264 | |
24 | 75,000,000 | 6,804,814 | 3,672,233 | 2,636,777 | 2,125,521 | 1,823,854 | |
25 | 80,000,000 | 7,258,469 | 3,917,049 | 2,812,563 | 2,267,222 | 1,945,445 | |
26 | 85,000,000 | 7,712,123 | 4,161,864 | 2,988,348 | 2,408,924 | 2,067,035 | |
27 | 90,000,000 | 8,165,777 | 4,406,680 | 3,164,133 | 2,550,625 | 2,188,625 | |
28 | 95,000,000 | 8,619,431 | 4,651,495 | 3,339,918 | 2,692,327 | 2,310,215 | |
29 | 100,000,000 | 9,073,086 | 4,896,311 | 3,515,703 | 2,834,028 | 2,431,806 | |
30 | 105,000,000 | 9,526,740 | 5,141,127 | 3,691,488 | 2,975,729 | 2,553,396 | |
31 | 110,000,000 | 9,980,394 | 5,385,942 | 3,867,274 | 3,117,431 | 2,674,986 | |
32 | 115,000,000 | 10,434,049 | 5,630,758 | 4,043,059 | 3,259,132 | 2,796,577 | |
33 | 120,000,000 | 10,887,703 | 5,875,573 | 4,218,844 | 3,400,834 | 2,918,167 | |
34 | 125,000,000 | 11,341,357 | 6,120,389 | 4,394,629 | 3,542,535 | 3,039,757 | |
35 | 130,000,000 | 11,795,012 | 6,365,204 | 4,570,414 | 3,684,237 | 3,161,347 | |
36 | 135,000,000 | 12,248,666 | 6,610,020 | 4,746,199 | 3,825,938 | 3,282,938 | |
37 | 140,000,000 | 12,702,320 | 6,854,835 | 4,921,985 | 3,967,639 | 3,404,528 | |
38 | 145,000,000 | 13,155,974 | 7,099,651 | 5,097,770 | 4,109,341 | 3,526,118 | |
39 | 150,000,000 | 13,609,629 | 7,344,467 | 5,273,555 | 4,251,042 | 3,647,709 | |
40 | 155,000,000 | 14,063,283 | 7,589,282 | 5,449,340 | 4,392,744 | 3,769,299 | |
41 | 160,000,000 | 14,516,937 | 7,834,098 | 5,625,125 | 4,534,445 | 3,890,889 | |
42 | 165,000,000 | 14,970,592 | 8,078,913 | 5,800,910 | 4,676,146 | 4,012,479 | |
43 | 170,000,000 | 15,424,246 | 8,323,729 | 5,976,696 | 4,817,848 | 4,134,070 | |
44 | 175,000,000 | 15,877,900 | 8,568,544 | 6,152,481 | 4,959,549 | 4,255,660 | |
45 | 180,000,000 | 16,331,554 | 8,813,360 | 6,328,266 | 5,101,251 | 4,377,250 | |
46 | 200,000,000 | 18,146,172 | 9,792,622 | 7,031,407 | 5,668,056 | 4,863,611 | |
47 | KOEFISIEN ANGSURAN PINJAMAN | ||||||
48 | JANGKA WAKTU (TAHUN) | ||||||
49 | JANGKA WAKTU (THN) | 1 | 2 | 3 | 4 | 5 | |
50 | NILAI KOEFISIEN | 0.09073085786 | 0.04896311052 | 0.03515703304 | 0.0283402808 | 0.02431805712 | |
51 | |||||||
52 | #REF! | ||||||
53 | |||||||
54 | |||||||
55 | |||||||
56 | |||||||
57 | |||||||
58 | |||||||
59 | |||||||