simulasi kpr konvensional & syariah

9
KONVENSIONAL PLAFOND PINJAMAN 200,000,000 JANGKA WAKTU (bulan) 120 bulan SUKU BUNGA 14.00% CICILAN 3,105,329 MINIMAL THP 9,315,986 Pokok Bunga Angsuran Sisa Pinjaman 200,000,000 1 771,995 2,333,333 3,105,329 199,228,005 2 781,002 2,324,327 3,105,329 198,447,003 3 790,114 2,315,215 3,105,329 197,656,889 4 799,332 2,305,997 3,105,329 196,857,557 5 808,657 2,296,672 3,105,329 196,048,900 6 818,092 2,287,237 3,105,329 195,230,809 7 827,636 2,277,693 3,105,329 194,403,173 8 837,292 2,268,037 3,105,329 193,565,881 9 847,060 2,258,269 3,105,329 192,718,821 10 856,942 2,248,386 3,105,329 191,861,878 11 866,940 2,238,389 3,105,329 190,994,938 12 877,054 2,228,274 3,105,329 190,117,884 13 887,287 2,218,042 3,105,329 189,230,597 14 897,638 2,207,690 3,105,329 188,332,959 15 908,111 2,197,218 3,105,329 187,424,848 16 918,705 2,186,623 3,105,329 186,506,142 17 929,424 2,175,905 3,105,329 185,576,719 18 940,267 2,165,062 3,105,329 184,636,452 19 951,237 2,154,092 3,105,329 183,685,215 20 962,335 2,142,994 3,105,329 182,722,880 21 973,562 2,131,767 3,105,329 181,749,319 22 984,920 2,120,409 3,105,329 180,764,399 23 996,411 2,108,918 3,105,329 179,767,988 24 1,008,036 2,097,293 3,105,329 178,759,952 25 1,019,796 2,085,533 3,105,329 177,740,157 26 1,031,694 2,073,635 3,105,329 176,708,463 27 1,043,730 2,061,599 3,105,329 175,664,733 28 1,055,907 2,049,422 3,105,329 174,608,826 29 1,068,226 2,037,103 3,105,329 173,540,601 30 1,080,688 2,024,640 3,105,329 172,459,912 31 1,093,296 2,012,032 3,105,329 171,366,616 32 1,106,052 1,999,277 3,105,329 170,260,564 33 1,118,955 1,986,373 3,105,329 169,141,609 34 1,132,010 1,973,319 3,105,329 168,009,599 35 1,145,217 1,960,112 3,105,329 166,864,382 36 1,158,578 1,946,751 3,105,329 165,705,805 37 1,172,094 1,933,234 3,105,329 164,533,710 38 1,185,769 1,919,560 3,105,329 163,347,942 39 1,199,603 1,905,726 3,105,329 162,148,339 40 1,213,598 1,891,731 3,105,329 160,934,741 Angs. Ke-

Upload: anggara-mukti-putra

Post on 24-Nov-2015

42 views

Category:

Documents


9 download

DESCRIPTION

Hitung Perkiraan Angsuran KPR Anda, baik secara konvensional maupun syariah.

TRANSCRIPT

Sheet1KONVENSIONALSYARIAH

PLAFOND PINJAMAN200,000,000JANGKA WAKTU (bulan)120 bulanSUKU BUNGA14.00%MARGIN8.63%CICILAN3,105,329CICILAN3,105,329MINIMAL THP9,315,986MINIMAL THP7,763,322

Angs. Ke-PokokBungaAngsuranSisa PinjamanAngs. Ke-PokokMarginAngsuranSisa PinjamanBankTenorMarginSetara Suku Bunga200,000,000200,000,000BRI SYARIAH5 tahun7.30%13.00%1771,9952,333,3333,105,329199,228,00511,666,6671,438,6623,105,329198,333,33310 tahun8.63%14.00%2781,0022,324,3273,105,329198,447,00321,666,6671,438,6623,105,329196,666,66715 tahun10.13%15.00%3790,1142,315,2153,105,329197,656,88931,666,6671,438,6623,105,329195,000,0004799,3322,305,9973,105,329196,857,55741,666,6671,438,6623,105,329193,333,3335808,6572,296,6723,105,329196,048,90051,666,6671,438,6623,105,329191,666,6676818,0922,287,2373,105,329195,230,80961,666,6671,438,6623,105,329190,000,0007827,6362,277,6933,105,329194,403,17371,666,6671,438,6623,105,329188,333,3338837,2922,268,0373,105,329193,565,88181,666,6671,438,6623,105,329186,666,6679847,0602,258,2693,105,329192,718,82191,666,6671,438,6623,105,329185,000,00010856,9422,248,3863,105,329191,861,878101,666,6671,438,6623,105,329183,333,33311866,9402,238,3893,105,329190,994,938111,666,6671,438,6623,105,329181,666,66712877,0542,228,2743,105,329190,117,884121,666,6671,438,6623,105,329180,000,00013887,2872,218,0423,105,329189,230,597131,666,6671,438,6623,105,329178,333,33314897,6382,207,6903,105,329188,332,959141,666,6671,438,6623,105,329176,666,66715908,1112,197,2183,105,329187,424,848151,666,6671,438,6623,105,329175,000,00016918,7052,186,6233,105,329186,506,142161,666,6671,438,6623,105,329173,333,33317929,4242,175,9053,105,329185,576,719171,666,6671,438,6623,105,329171,666,66718940,2672,165,0623,105,329184,636,452181,666,6671,438,6623,105,329170,000,00019951,2372,154,0923,105,329183,685,215191,666,6671,438,6623,105,329168,333,33320962,3352,142,9943,105,329182,722,880201,666,6671,438,6623,105,329166,666,66721973,5622,131,7673,105,329181,749,319211,666,6671,438,6623,105,329165,000,00022984,9202,120,4093,105,329180,764,399221,666,6671,438,6623,105,329163,333,33323996,4112,108,9183,105,329179,767,988231,666,6671,438,6623,105,329161,666,667241,008,0362,097,2933,105,329178,759,952241,666,6671,438,6623,105,329160,000,000251,019,7962,085,5333,105,329177,740,157251,666,6671,438,6623,105,329158,333,333261,031,6942,073,6353,105,329176,708,463261,666,6671,438,6623,105,329156,666,667271,043,7302,061,5993,105,329175,664,733271,666,6671,438,6623,105,329155,000,000281,055,9072,049,4223,105,329174,608,826281,666,6671,438,6623,105,329153,333,333291,068,2262,037,1033,105,329173,540,601291,666,6671,438,6623,105,329151,666,667301,080,6882,024,6403,105,329172,459,912301,666,6671,438,6623,105,329150,000,000311,093,2962,012,0323,105,329171,366,616311,666,6671,438,6623,105,329148,333,333321,106,0521,999,2773,105,329170,260,564321,666,6671,438,6623,105,329146,666,667331,118,9551,986,3733,105,329169,141,609331,666,6671,438,6623,105,329145,000,000341,132,0101,973,3193,105,329168,009,599341,666,6671,438,6623,105,329143,333,333351,145,2171,960,1123,105,329166,864,382351,666,6671,438,6623,105,329141,666,667361,158,5781,946,7513,105,329165,705,805361,666,6671,438,6623,105,329140,000,000371,172,0941,933,2343,105,329164,533,710371,666,6671,438,6623,105,329138,333,333381,185,7691,919,5603,105,329163,347,942381,666,6671,438,6623,105,329136,666,667391,199,6031,905,7263,105,329162,148,339391,666,6671,438,6623,105,329135,000,000401,213,5981,891,7313,105,329160,934,741401,666,6671,438,6623,105,329133,333,333411,227,7571,877,5723,105,329159,706,984411,666,6671,438,6623,105,329131,666,667421,242,0811,863,2483,105,329158,464,903421,666,6671,438,6623,105,329130,000,000431,256,5711,848,7573,105,329157,208,332431,666,6671,438,6623,105,329128,333,333441,271,2311,834,0973,105,329155,937,100441,666,6671,438,6623,105,329126,666,667451,286,0631,819,2663,105,329154,651,038451,666,6671,438,6623,105,329125,000,000461,301,0671,804,2623,105,329153,349,971461,666,6671,438,6623,105,329123,333,333471,316,2461,789,0833,105,329152,033,726471,666,6671,438,6623,105,329121,666,667481,331,6021,773,7273,105,329150,702,124481,666,6671,438,6623,105,329120,000,000491,347,1371,758,1913,105,329149,354,986491,666,6671,438,6623,105,329118,333,333501,362,8541,742,4753,105,329147,992,133501,666,6671,438,6623,105,329116,666,667511,378,7541,726,5753,105,329146,613,379511,666,6671,438,6623,105,329115,000,000521,394,8391,710,4893,105,329145,218,540521,666,6671,438,6623,105,329113,333,333531,411,1121,694,2163,105,329143,807,427531,666,6671,438,6623,105,329111,666,667541,427,5751,677,7533,105,329142,379,852541,666,6671,438,6623,105,329110,000,000551,444,2301,661,0983,105,329140,935,621551,666,6671,438,6623,105,329108,333,333561,461,0801,644,2493,105,329139,474,541561,666,6671,438,6623,105,329106,666,667571,478,1261,627,2033,105,329137,996,416571,666,6671,438,6623,105,329105,000,000581,495,3711,609,9583,105,329136,501,045581,666,6671,438,6623,105,329103,333,333591,512,8171,592,5123,105,329134,988,229591,666,6671,438,6623,105,329101,666,667601,530,4661,574,8633,105,329133,457,763601,666,6671,438,6623,105,329100,000,000611,548,3211,557,0073,105,329131,909,441611,666,6671,438,6623,105,32998,333,333621,566,3851,538,9433,105,329130,343,056621,666,6671,438,6623,105,32996,666,667631,584,6601,520,6693,105,329128,758,396631,666,6671,438,6623,105,32995,000,000641,603,1471,502,1813,105,329127,155,249641,666,6671,438,6623,105,32993,333,333651,621,8511,483,4783,105,329125,533,398651,666,6671,438,6623,105,32991,666,667661,640,7721,464,5563,105,329123,892,626661,666,6671,438,6623,105,32990,000,000671,659,9151,445,4143,105,329122,232,711671,666,6671,438,6623,105,32988,333,333681,679,2801,426,0483,105,329120,553,431681,666,6671,438,6623,105,32986,666,667691,698,8721,406,4573,105,329118,854,559691,666,6671,438,6623,105,32985,000,000701,718,6921,386,6373,105,329117,135,866701,666,6671,438,6623,105,32983,333,333711,738,7441,366,5853,105,329115,397,123711,666,6671,438,6623,105,32981,666,667721,759,0291,346,3003,105,329113,638,094721,666,6671,438,6623,105,32980,000,000731,779,5511,325,7783,105,329111,858,543731,666,6671,438,6623,105,32978,333,333741,800,3121,305,0163,105,329110,058,231741,666,6671,438,6623,105,32976,666,667751,821,3161,284,0133,105,329108,236,915751,666,6671,438,6623,105,32975,000,000761,842,5651,262,7643,105,329106,394,350761,666,6671,438,6623,105,32973,333,333771,864,0611,241,2673,105,329104,530,289771,666,6671,438,6623,105,32971,666,667781,885,8091,219,5203,105,329102,644,480781,666,6671,438,6623,105,32970,000,000791,907,8101,197,5193,105,329100,736,670791,666,6671,438,6623,105,32968,333,333801,930,0681,175,2613,105,32998,806,603801,666,6671,438,6623,105,32966,666,667811,952,5851,152,7443,105,32996,854,018811,666,6671,438,6623,105,32965,000,000821,975,3651,129,9643,105,32994,878,652821,666,6671,438,6623,105,32963,333,333831,998,4111,106,9183,105,32992,880,241831,666,6671,438,6623,105,32961,666,667842,021,7261,083,6033,105,32990,858,515841,666,6671,438,6623,105,32960,000,000852,045,3131,060,0163,105,32988,813,203851,666,6671,438,6623,105,32958,333,333862,069,1751,036,1543,105,32986,744,028861,666,6671,438,6623,105,32956,666,667872,093,3151,012,0143,105,32984,650,713871,666,6671,438,6623,105,32955,000,000882,117,737987,5923,105,32982,532,976881,666,6671,438,6623,105,32953,333,333892,142,444962,8853,105,32980,390,532891,666,6671,438,6623,105,32951,666,667902,167,439937,8903,105,32978,223,093901,666,6671,438,6623,105,32950,000,000912,192,726912,6033,105,32976,030,367911,666,6671,438,6623,105,32948,333,333922,218,308887,0213,105,32973,812,059921,666,6671,438,6623,105,32946,666,667932,244,188861,1413,105,32971,567,871931,666,6671,438,6623,105,32945,000,000942,270,370834,9583,105,32969,297,501941,666,6671,438,6623,105,32943,333,333952,296,858808,4713,105,32967,000,643951,666,6671,438,6623,105,32941,666,667962,323,655781,6743,105,32964,676,989961,666,6671,438,6623,105,32940,000,000972,350,764754,5653,105,32962,326,225971,666,6671,438,6623,105,32938,333,333982,378,189727,1393,105,32959,948,035981,666,6671,438,6623,105,32936,666,667992,405,935699,3943,105,32957,542,100991,666,6671,438,6623,105,32935,000,0001002,434,004671,3253,105,32955,108,0961001,666,6671,438,6623,105,32933,333,3331012,462,401642,9283,105,32952,645,6951011,666,6671,438,6623,105,32931,666,6671022,491,129614,2003,105,32950,154,5661021,666,6671,438,6623,105,32930,000,0001032,520,192585,1373,105,32947,634,3741031,666,6671,438,6623,105,32928,333,3331042,549,594555,7343,105,32945,084,7801041,666,6671,438,6623,105,32926,666,6671052,579,340525,9893,105,32942,505,4401051,666,6671,438,6623,105,32925,000,0001062,609,432495,8973,105,32939,896,0081061,666,6671,438,6623,105,32923,333,3331072,639,875465,4533,105,32937,256,1331071,666,6671,438,6623,105,32921,666,6671082,670,674434,6553,105,32934,585,4591081,666,6671,438,6623,105,32920,000,0001092,701,832403,4973,105,32931,883,6281091,666,6671,438,6623,105,32918,333,3331102,733,353371,9763,105,32929,150,2751101,666,6671,438,6623,105,32916,666,6671112,765,242340,0873,105,32926,385,0321111,666,6671,438,6623,105,32915,000,0001122,797,503307,8253,105,32923,587,5291121,666,6671,438,6623,105,32913,333,3331132,830,141275,1883,105,32920,757,3881131,666,6671,438,6623,105,32911,666,6671142,863,159242,1703,105,32917,894,2291141,666,6671,438,6623,105,32910,000,0001152,896,563208,7663,105,32914,997,6661151,666,6671,438,6623,105,3298,333,3331162,930,356174,9733,105,32912,067,3101161,666,6671,438,6623,105,3296,666,6671172,964,543140,7853,105,3299,102,7671171,666,6671,438,6623,105,3295,000,0001182,999,130106,1993,105,3296,103,6371181,666,6671,438,6623,105,3293,333,3331193,034,12071,2093,105,3293,069,5181191,666,6671,438,6623,105,3291,666,6671203,069,51835,8113,105,329(0)1201,666,6671,438,6623,105,32901213,105,329(0)3,105,329(3,105,329)1211,666,6671,438,6623,105,329(1,666,667)1223,141,558(36,229)3,105,329(6,246,886)1221,666,6671,438,6623,105,329(3,333,333)1233,178,209(72,880)3,105,329(9,425,095)1231,666,6671,438,6623,105,329(5,000,000)1243,215,288(109,959)3,105,329(12,640,383)1241,666,6671,438,6623,105,329(6,666,667)1253,252,800(147,471)3,105,329(15,893,183)1251,666,6671,438,6623,105,329(8,333,333)1263,290,749(185,420)3,105,329(19,183,932)1261,666,6671,438,6623,105,329(10,000,000)1273,329,141(223,813)3,105,329(22,513,074)1271,666,6671,438,6623,105,329(11,666,667)1283,367,981(262,653)3,105,329(25,881,055)1281,666,6671,438,6623,105,329(13,333,333)1293,407,274(301,946)3,105,329(29,288,329)1291,666,6671,438,6623,105,329(15,000,000)1303,447,026(341,697)3,105,329(32,735,355)1301,666,6671,438,6623,105,329(16,666,667)1313,487,241(381,912)3,105,329(36,222,596)1311,666,6671,438,6623,105,329(18,333,333)1323,527,926(422,597)3,105,329(39,750,522)1321,666,6671,438,6623,105,329(20,000,000)1333,569,085(463,756)3,105,329(43,319,607)1331,666,6671,438,6623,105,329(21,666,667)1343,610,724(505,395)3,105,329(46,930,331)1341,666,6671,438,6623,105,329(23,333,333)1353,652,849(547,521)3,105,329(50,583,180)1351,666,6671,438,6623,105,329(25,000,000)1363,695,466(590,137)3,105,329(54,278,646)1361,666,6671,438,6623,105,329(26,666,667)1373,738,580(633,251)3,105,329(58,017,225)1371,666,6671,438,6623,105,329(28,333,333)1383,782,196(676,868)3,105,329(61,799,422)1381,666,6671,438,6623,105,329(30,000,000)1393,826,322(720,993)3,105,329(65,625,744)1391,666,6671,438,6623,105,329(31,666,667)1403,870,962(765,634)3,105,329(69,496,706)1401,666,6671,438,6623,105,329(33,333,333)1413,916,124(810,795)3,105,329(73,412,830)1411,666,6671,438,6623,105,329(35,000,000)1423,961,812(856,483)3,105,329(77,374,641)1421,666,6671,438,6623,105,329(36,666,667)1434,008,033(902,704)3,105,329(81,382,674)1431,666,6671,438,6623,105,329(38,333,333)1444,054,793(949,465)3,105,329(85,437,468)1441,666,6671,438,6623,105,329(40,000,000)1454,102,099(996,770)3,105,329(89,539,567)1451,666,6671,438,6623,105,329(41,666,667)1464,149,957(1,044,628)3,105,329(93,689,524)1461,666,6671,438,6623,105,329(43,333,333)1474,198,373(1,093,044)3,105,329(97,887,897)1471,666,6671,438,6623,105,329(45,000,000)1484,247,354(1,142,025)3,105,329(102,135,251)1481,666,6671,438,6623,105,329(46,666,667)1494,296,907(1,191,578)3,105,329(106,432,158)1491,666,6671,438,6623,105,329(48,333,333)1504,347,037(1,241,709)3,105,329(110,779,195)1501,666,6671,438,6623,105,329(50,000,000)1514,397,753(1,292,424)3,105,329(115,176,947)1511,666,6671,438,6623,105,329(51,666,667)1524,449,060(1,343,731)3,105,329(119,626,007)1521,666,6671,438,6623,105,329(53,333,333)1534,500,965(1,395,637)3,105,329(124,126,973)1531,666,6671,438,6623,105,329(55,000,000)1544,553,477(1,448,148)3,105,329(128,680,449)1541,666,6671,438,6623,105,329(56,666,667)1554,606,601(1,501,272)3,105,329(133,287,050)1551,666,6671,438,6623,105,329(58,333,333)1564,660,344(1,555,016)3,105,329(137,947,394)1561,666,6671,438,6623,105,329(60,000,000)1574,714,715(1,609,386)3,105,329(142,662,109)1571,666,6671,438,6623,105,329(61,666,667)1584,769,720(1,664,391)3,105,329(147,431,829)1581,666,6671,438,6623,105,329(63,333,333)1594,825,367(1,720,038)3,105,329(152,257,196)1591,666,6671,438,6623,105,329(65,000,000)1604,881,663(1,776,334)3,105,329(157,138,859)1601,666,6671,438,6623,105,329(66,666,667)1614,938,615(1,833,287)3,105,329(162,077,474)1611,666,6671,438,6623,105,329(68,333,333)1624,996,233(1,890,904)3,105,329(167,073,707)1621,666,6671,438,6623,105,329(70,000,000)1635,054,522(1,949,193)3,105,329(172,128,228)1631,666,6671,438,6623,105,329(71,666,667)1645,113,491(2,008,163)3,105,329(177,241,720)1641,666,6671,438,6623,105,329(73,333,333)1655,173,149(2,067,820)3,105,329(182,414,869)1651,666,6671,438,6623,105,329(75,000,000)1665,233,502(2,128,173)3,105,329(187,648,371)1661,666,6671,438,6623,105,329(76,666,667)1675,294,560(2,189,231)3,105,329(192,942,930)1671,666,6671,438,6623,105,329(78,333,333)1685,356,330(2,251,001)3,105,329(198,299,260)1681,666,6671,438,6623,105,329(80,000,000)1695,418,820(2,313,491)3,105,329(203,718,080)1691,666,6671,438,6623,105,329(81,666,667)1705,482,040(2,376,711)3,105,329(209,200,120)1701,666,6671,438,6623,105,329(83,333,333)1715,545,997(2,440,668)3,105,329(214,746,116)1711,666,6671,438,6623,105,329(85,000,000)1725,610,700(2,505,371)3,105,329(220,356,817)1721,666,6671,438,6623,105,329(86,666,667)1735,676,158(2,570,830)3,105,329(226,032,975)1731,666,6671,438,6623,105,329(88,333,333)1745,742,380(2,637,051)3,105,329(231,775,355)1741,666,6671,438,6623,105,329(90,000,000)1755,809,375(2,704,046)3,105,329(237,584,729)1751,666,6671,438,6623,105,329(91,666,667)1765,877,151(2,771,822)3,105,329(243,461,880)1761,666,6671,438,6623,105,329(93,333,333)1775,945,717(2,840,389)3,105,329(249,407,597)1771,666,6671,438,6623,105,329(95,000,000)1786,015,084(2,909,755)3,105,329(255,422,681)1781,666,6671,438,6623,105,329(96,666,667)1796,085,260(2,979,931)3,105,329(261,507,941)1791,666,6671,438,6623,105,329(98,333,333)1806,156,255(3,050,926)3,105,329(267,664,196)1801,666,6671,438,6623,105,329(100,000,000)SUM200,000,000172,639,444372,639,44486%SUM200,000,000172,639,444372,639,44486%

Sheet2

Sheet3