simulasi-angsuran-kpr.xls

9
CONTOH PERHITUNGAN ANGSURAN (ANUITAS) In Arrear = Angsuran mulai dibayar bulan berikutnya In Advance Angsuran / bln Angsuran / Ingat! Dalam perhitungan suku bunga harus dibagi 12 Ingat! Dalam Pokok 200,000,000 Angsuran/Bln 7,031,407 Pokok Tenor (Bln 36 Tot P+B ### Tenor (Bln Int (eff) 16% Tot Bunga 53,130,638 Int (eff) Bulan AngKe O/S Pokok AngPokok Angs Bunga Angsuran AngKe 0 0 200,000,000 - - 1 1 1 195,635,260 4,364,740 2,666,667 7,031,407 2 2 2 191,212,324 4,422,936 2,608,470 7,031,407 3 3 3 186,730,415 4,481,909 2,549,498 7,031,407 4 4 4 182,188,747 4,541,668 2,489,739 7,031,407 5 5 5 177,586,524 4,602,223 2,429,183 7,031,407 6 6 6 172,922,937 4,663,586 2,367,820 7,031,407 7 7 7 168,197,170 4,725,767 2,305,639 7,031,407 8 8 8 163,408,392 4,788,778 2,242,629 7,031,407 9 9 9 158,555,764 4,852,628 2,178,779 7,031,407 10 10 10 153,638,434 4,917,330 2,114,077 7,031,407 11 11 11 148,655,540 4,982,894 2,048,512 7,031,407 12 12 12 143,606,207 5,049,333 1,982,074 7,031,407 13 13 13 138,489,550 5,116,657 1,914,749 7,031,407 14 14 14 133,304,671 5,184,879 1,846,527 7,031,407 15 15 15 128,050,660 5,254,011 1,777,396 7,031,407 16 16 16 122,726,596 5,324,064 1,707,342 7,031,407 17 17 17 117,331,544 5,395,052 1,636,355 7,031,407 18 18 18 111,864,558 5,466,986 1,564,421 7,031,407 19 19 19 106,324,678 5,539,879 1,491,527 7,031,407 20 20 20 100,710,934 5,613,744 1,417,662 7,031,407 21 21 21 95,022,340 5,688,594 1,342,812 7,031,407 22 22 22 89,257,898 5,764,442 1,266,965 7,031,407 23 23 23 83,416,597 5,841,301 1,190,105 7,031,407 24 24 24 77,497,411 5,919,185 1,112,221 7,031,407 25 25 25 71,499,303 5,998,108 1,033,299 7,031,407 26 26 26 65,421,221 6,078,083 953,324 7,031,407 27 27 27 59,262,097 6,159,124 872,283 7,031,407 28 28 28 53,020,852 6,241,245 790,161 7,031,407 29 29 29 46,696,390 6,324,462 706,945 7,031,407 30 30 30 40,287,602 6,408,788 622,619 7,031,407 31 31 31 33,793,363 6,494,239 537,168 7,031,407 32 1 - Pinjaman x suku bunga 1 - 1 (1 + suku bunga) Tenor pokok x suku bunga 12 VARIABEL YANG DAPAT DIUBAH BERTANDA BIRU

Upload: sigitmd81

Post on 30-Nov-2015

462 views

Category:

Documents


102 download

TRANSCRIPT

Page 1: simulasi-angsuran-KPR.xls

CONTOH PERHITUNGAN ANGSURAN (ANUITAS)

In Arrear = Angsuran mulai dibayar bulan berikutnya In Advance =angsuran dibayar pada saat awal (DP dibayar)

Angsuran / bln Angsuran / bln

Ingat! Dalam perhitungan suku bunga harus dibagi 12 Ingat! Dalam perhitungan suku bunga harus dibagi 12

Pokok 200,000,000 Angsuran/Bln 7,031,407 Pokok 200,000,000

Tenor (Bln) 36 Tot P+B 253,130,638 Tenor (Bln) 36

Int (eff) 16% Tot Bunga 53,130,638 Int (eff) 16%

Bulan AngKe O/S Pokok AngPokok Angs Bunga Angsuran AngKe O/S Pokok

0 0 200,000,000 - - 1 193,061,112

1 1 195,635,260 4,364,740 2,666,667 7,031,407 2 188,696,372

2 2 191,212,324 4,422,936 2,608,470 7,031,407 3 184,273,435

3 3 186,730,415 4,481,909 2,549,498 7,031,407 4 179,791,527

4 4 182,188,747 4,541,668 2,489,739 7,031,407 5 175,249,859

5 5 177,586,524 4,602,223 2,429,183 7,031,407 6 170,647,635

6 6 172,922,937 4,663,586 2,367,820 7,031,407 7 165,984,049

7 7 168,197,170 4,725,767 2,305,639 7,031,407 8 161,258,282

8 8 163,408,392 4,788,778 2,242,629 7,031,407 9 156,469,504

9 9 158,555,764 4,852,628 2,178,779 7,031,407 10 151,616,876

10 10 153,638,434 4,917,330 2,114,077 7,031,407 11 146,699,546

11 11 148,655,540 4,982,894 2,048,512 7,031,407 12 141,716,652

12 12 143,606,207 5,049,333 1,982,074 7,031,407 13 136,667,319

13 13 138,489,550 5,116,657 1,914,749 7,031,407 14 131,550,662

14 14 133,304,671 5,184,879 1,846,527 7,031,407 15 126,365,783

15 15 128,050,660 5,254,011 1,777,396 7,031,407 16 121,111,772

16 16 122,726,596 5,324,064 1,707,342 7,031,407 17 115,787,707

17 17 117,331,544 5,395,052 1,636,355 7,031,407 18 110,392,655

18 18 111,864,558 5,466,986 1,564,421 7,031,407 19 104,925,669

19 19 106,324,678 5,539,879 1,491,527 7,031,407 20 99,385,790

20 20 100,710,934 5,613,744 1,417,662 7,031,407 21 93,772,046

21 21 95,022,340 5,688,594 1,342,812 7,031,407 22 88,083,452

22 22 89,257,898 5,764,442 1,266,965 7,031,407 23 82,319,010

23 23 83,416,597 5,841,301 1,190,105 7,031,407 24 76,477,708

24 24 77,497,411 5,919,185 1,112,221 7,031,407 25 70,558,523

25 25 71,499,303 5,998,108 1,033,299 7,031,407 26 64,560,415

26 26 65,421,221 6,078,083 953,324 7,031,407 27 58,482,333

27 27 59,262,097 6,159,124 872,283 7,031,407 28 52,323,209

28 28 53,020,852 6,241,245 790,161 7,031,407 29 46,081,964

29 29 46,696,390 6,324,462 706,945 7,031,407 30 39,757,502

30 30 40,287,602 6,408,788 622,619 7,031,407 31 33,348,714

31 31 33,793,363 6,494,239 537,168 7,031,407 32 26,854,475

11 - (1+suku bunga)

Pinjaman x suku bungaPinjaman x suku bunga

1 - 1

(1 + suku bunga)Tenor

pokok x suku bunga12

VARIABEL YANG DAPAT DIUBAHBERTANDA BIRU

Page 2: simulasi-angsuran-KPR.xls

32 32 27,212,535 6,580,828 450,578 7,031,407 33 20,273,647

33 33 20,543,962 6,668,573 362,834 7,031,407 34 13,605,074

34 34 13,786,475 6,757,487 273,919 7,031,407 35 6,847,587

35 35 6,938,888 6,847,587 183,820 7,031,407 36 0

36 36 0 6,938,888 92,519 7,031,407 37 (6,938,888)

37 37 (7,031,407) 7,031,407 0 7,031,407 38 (13,970,295)

38 38 (14,156,565) 7,125,159 (93,752) 7,031,407 39 (21,095,453)

39 39 (21,376,726) 7,220,161 (188,754) 7,031,407 40 (28,315,614)

40 40 (28,693,156) 7,316,430 (285,023) 7,031,407 41 (35,632,044)

41 41 (36,107,138) 7,413,982 (382,575) 7,031,407 42 (43,046,026)

42 42 (43,619,973) 7,512,835 (481,429) 7,031,407 43 (50,558,861)

43 43 (51,232,979) 7,613,006 (581,600) 7,031,407 44 (58,171,867)

44 44 (58,947,492) 7,714,513 (683,106) 7,031,407 45 (65,886,380)

45 45 (66,764,865) 7,817,373 (785,967) 7,031,407 46 (73,703,753)

46 46 (74,686,470) 7,921,605 (890,198) 7,031,407 47 (81,625,358)

47 47 (82,713,696) 8,027,226 (995,820) 7,031,407 48 (89,652,584)

48 48 (90,847,952) 8,134,256 (1,102,849) 7,031,407 49 (97,786,840)

49 49 (99,090,665) 8,242,713 (1,211,306) 7,031,407 50 (106,029,553)

50 50 (107,443,280) 8,352,615 (1,321,209) 7,031,407 51 (114,382,168)

51 51 (115,907,264) 8,463,984 (1,432,577) 7,031,407 52 (122,846,152)

52 52 (124,484,101) 8,576,837 (1,545,430) 7,031,407 53 (131,422,989)

53 53 (133,175,295) 8,691,195 (1,659,788) 7,031,407 54 (140,114,183)

54 54 (141,982,373) 8,807,077 (1,775,671) 7,031,407 55 (148,921,261)

55 55 (150,906,878) 8,924,505 (1,893,098) 7,031,407 56 (157,845,766)

56 56 (159,950,376) 9,043,498 (2,012,092) 7,031,407 57 (166,889,264)

57 57 (169,114,454) 9,164,078 (2,132,672) 7,031,407 58 (176,053,342)

58 58 (178,400,720) 9,286,266 (2,254,859) 7,031,407 59 (185,339,608)

59 59 (187,810,803) 9,410,083 (2,378,676) 7,031,407 60 (194,749,691)

60 60 (197,346,354) 9,535,551 (2,504,144) 7,031,407 61 (204,285,242)

61 61 (207,009,045) 9,662,691 (2,631,285) 7,031,407 62 (213,947,933)

62 62 (216,800,572) 9,791,527 (2,760,121) 7,031,407 63 (223,739,460)

63 63 (226,722,653) 9,922,081 (2,890,674) 7,031,407 64 (233,661,541)

64 64 (236,777,028) 10,054,375 (3,022,969) 7,031,407 65 (243,715,916)

65 65 (246,965,462) 10,188,434 (3,157,027) 7,031,407 66 (253,904,350)

66 66 (257,289,741) 10,324,279 (3,292,873) 7,031,407 67 (264,228,630)

67 67 (267,751,678) 10,461,936 (3,430,530) 7,031,407 68 (274,690,566)

68 68 (278,353,107) 10,601,429 (3,570,022) 7,031,407 69 (285,291,995)

69 69 (289,095,888) 10,742,781 (3,711,375) 7,031,407 70 (296,034,776)

70 70 (299,981,907) 10,886,018 (3,854,612) 7,031,407 71 (306,920,795)

71 71 (311,013,072) 11,031,165 (3,999,759) 7,031,407 72 (317,951,960)

72 72 (322,191,320) 11,178,248 (4,146,841) 7,031,407 73 (329,130,208)

73 73 (333,518,611) 11,327,291 (4,295,884) 7,031,407 74 (340,457,499)

74 74 (344,996,932) 11,478,321 (4,446,915) 7,031,407 75 (351,935,820)

75 75 (356,628,298) 11,631,366 (4,599,959) 7,031,407 76 (363,567,186)

76 76 (368,414,748) 11,786,451 (4,755,044) 7,031,407 77 (375,353,636)

77 77 (380,358,351) 11,943,603 (4,912,197) 7,031,407 78 (387,297,240)

78 78 (392,461,203) 12,102,851 (5,071,445) 7,031,407 79 (399,400,091)

79 79 (404,725,425) 12,264,223 (5,232,816) 7,031,407 80 (411,664,314)

80 80 (417,153,171) 12,427,746 (5,396,339) 7,031,407 81 (424,092,059)

81 81 (429,746,620) 12,593,449 (5,562,042) 7,031,407 82 (436,685,508)

Page 3: simulasi-angsuran-KPR.xls

82 82 (442,507,981) 12,761,362 (5,729,955) 7,031,407 83 (449,446,870)

83 83 (455,439,494) 12,931,513 (5,900,106) 7,031,407 84 (462,378,383)

84 84 (468,543,428) 13,103,933 (6,072,527) 7,031,407 85 (475,482,316)

85 85 (481,822,080) 13,278,652 (6,247,246) 7,031,407 86 (488,760,968)

86 86 (495,277,781) 13,455,701 (6,424,294) 7,031,407 87 (502,216,669)

87 87 (508,912,891) 13,635,110 (6,603,704) 7,031,407 88 (515,851,779)

88 88 (522,729,803) 13,816,912 (6,785,505) 7,031,407 89 (529,668,691)

89 89 (536,730,940) 14,001,137 (6,969,731) 7,031,407 90 (543,669,829)

90 90 (550,918,760) 14,187,819 (7,156,413) 7,031,407 91 (557,857,648)

91 91 (565,295,750) 14,376,990 (7,345,583) 7,031,407 92 (572,234,638)

92 92 (579,864,433) 14,568,683 (7,537,277) 7,031,407 93 (586,803,321)

93 93 (594,627,365) 14,762,932 (7,731,526) 7,031,407 94 (601,566,253)

94 94 (609,587,137) 14,959,771 (7,928,365) 7,031,407 95 (616,526,025)

95 95 (624,746,372) 15,159,235 (8,127,828) 7,031,407 96 (631,685,260)

96 96 (640,107,730) 15,361,358 (8,329,952) 7,031,407 97 (647,046,618)

97 97 (655,673,907) 15,566,176 (8,534,770) 7,031,407 98 (662,612,795)

98 98 (671,447,632) 15,773,725 (8,742,319) 7,031,407 99 (678,386,520)

99 99 (687,431,674) 15,984,042 (8,952,635) 7,031,407 100 (694,370,562)

100 100 (703,628,836) 16,197,162 (9,165,756) 7,031,407 101 (710,567,724)

101 101 (720,041,960) 16,413,124 (9,381,718) 7,031,407 102 (726,980,848)

102 102 (736,673,926) 16,631,966 (9,600,559) 7,031,407 103 (743,612,814)

103 103 (753,527,652) 16,853,726 (9,822,319) 7,031,407 104 (760,466,540)

104 104 (770,606,094) 17,078,442 (10,047,035) 7,031,407 105 (777,544,982)

105 105 (787,912,248) 17,306,155 (10,274,748) 7,031,407 106 (794,851,137)

106 106 (805,449,152) 17,536,903 (10,505,497) 7,031,407 107 (812,388,040)

107 107 (823,219,880) 17,770,729 (10,739,322) 7,031,407 108 (830,158,768)

108 108 (841,227,552) 18,007,672 (10,976,265) 7,031,407 109 (848,166,440)

109 109 (859,475,326) 18,247,774 (11,216,367) 7,031,407 110 (866,414,214)

110 110 (877,966,404) 18,491,078 (11,459,671) 7,031,407 111 (884,905,292)

111 111 (896,704,029) 18,737,625 (11,706,219) 7,031,407 112 (903,642,917)

112 112 (915,691,489) 18,987,460 (11,956,054) 7,031,407 113 (922,630,377)

113 113 (934,932,116) 19,240,626 (12,209,220) 7,031,407 114 (941,871,004)

114 114 (954,429,284) 19,497,168 (12,465,762) 7,031,407 115 (961,368,172)

115 115 (974,186,414) 19,757,130 (12,725,724) 7,031,407 116 (981,125,302)

116 116 (994,206,973) 20,020,559 (12,989,152) 7,031,407 117 (1,001,145,861)

117 117 (1,014,494,473) 20,287,500 (13,256,093) 7,031,407 118 (1,021,433,361)

118 118 (1,035,052,472) 20,558,000 (13,526,593) 7,031,407 119 (1,041,991,360)

119 119 (1,055,884,578) 20,832,106 (13,800,700) 7,031,407 120 (1,062,823,467)

120 120 (1,076,994,446) 21,109,868 (14,078,461) 7,031,407

1,276,994,446 (433,225,653) 843,768,793

Page 4: simulasi-angsuran-KPR.xls

In Advance =angsuran dibayar pada saat awal (DP dibayar)

Ingat! Dalam perhitungan suku bunga harus dibagi 12

Angsuran/Bln 6,938,888

Tot P+B 249,799,972

Tot Bunga 49,799,972

AngPokok Bunga Angsuran

6,938,888 - 6,938,888

4,364,740 2,574,148 6,938,888

4,422,936 2,515,952 6,938,888

4,481,909 2,456,979 6,938,888

4,541,668 2,397,220 6,938,888

4,602,223 2,336,665 6,938,888

4,663,586 2,275,302 6,938,888

4,725,767 2,213,121 6,938,888

4,788,778 2,150,110 6,938,888

4,852,628 2,086,260 6,938,888

4,917,330 2,021,558 6,938,888

4,982,894 1,955,994 6,938,888

5,049,333 1,889,555 6,938,888

5,116,657 1,822,231 6,938,888

5,184,879 1,754,009 6,938,888

5,254,011 1,684,877 6,938,888

5,324,064 1,614,824 6,938,888

5,395,052 1,543,836 6,938,888

5,466,986 1,471,902 6,938,888

5,539,879 1,399,009 6,938,888

5,613,744 1,325,144 6,938,888

5,688,594 1,250,294 6,938,888

5,764,442 1,174,446 6,938,888

5,841,301 1,097,587 6,938,888

5,919,185 1,019,703 6,938,888

5,998,108 940,780 6,938,888

6,078,083 860,806 6,938,888

6,159,124 779,764 6,938,888

6,241,245 697,643 6,938,888

6,324,462 614,426 6,938,888

6,408,788 530,100 6,938,888

6,494,239 444,650 6,938,888

Tenor(1+suku bunga)

Pinjaman x suku bunga

X (1+suku bunga)

pokok x suku bunga12

Page 5: simulasi-angsuran-KPR.xls

6,580,828 358,060 6,938,888

6,668,573 270,315 6,938,888

6,757,487 181,401 6,938,888

6,847,587 91,301 6,938,888

6,938,888 0 6,938,888

7,031,407 (92,519) 6,938,888

7,125,159 (186,271) 6,938,888

7,220,161 (281,273) 6,938,888

7,316,430 (377,542) 6,938,888

7,413,982 (475,094) 6,938,888

7,512,835 (573,947) 6,938,888

7,613,006 (674,118) 6,938,888

7,714,513 (775,625) 6,938,888

7,817,373 (878,485) 6,938,888

7,921,605 (982,717) 6,938,888

8,027,226 (1,088,338) 6,938,888

8,134,256 (1,195,368) 6,938,888

8,242,713 (1,303,825) 6,938,888

8,352,615 (1,413,727) 6,938,888

8,463,984 (1,525,096) 6,938,888

8,576,837 (1,637,949) 6,938,888

8,691,195 (1,752,307) 6,938,888

8,807,077 (1,868,189) 6,938,888

8,924,505 (1,985,617) 6,938,888

9,043,498 (2,104,610) 6,938,888

9,164,078 (2,225,190) 6,938,888

9,286,266 (2,347,378) 6,938,888

9,410,083 (2,471,195) 6,938,888

9,535,551 (2,596,663) 6,938,888

9,662,691 (2,723,803) 6,938,888

9,791,527 (2,852,639) 6,938,888

9,922,081 (2,983,193) 6,938,888

10,054,375 (3,115,487) 6,938,888

10,188,434 (3,249,546) 6,938,888

10,324,279 (3,385,391) 6,938,888

10,461,936 (3,523,048) 6,938,888

10,601,429 (3,662,541) 6,938,888

10,742,781 (3,803,893) 6,938,888

10,886,018 (3,947,130) 6,938,888

11,031,165 (4,092,277) 6,938,888

11,178,248 (4,239,359) 6,938,888

11,327,291 (4,388,403) 6,938,888

11,478,321 (4,539,433) 6,938,888

11,631,366 (4,692,478) 6,938,888

11,786,451 (4,847,562) 6,938,888

11,943,603 (5,004,715) 6,938,888

12,102,851 (5,163,963) 6,938,888

12,264,223 (5,325,335) 6,938,888

12,427,746 (5,488,858) 6,938,888

12,593,449 (5,654,561) 6,938,888

Page 6: simulasi-angsuran-KPR.xls

12,761,362 (5,822,473) 6,938,888

12,931,513 (5,992,625) 6,938,888

13,103,933 (6,165,045) 6,938,888

13,278,652 (6,339,764) 6,938,888

13,455,701 (6,516,813) 6,938,888

13,635,110 (6,696,222) 6,938,888

13,816,912 (6,878,024) 6,938,888

14,001,137 (7,062,249) 6,938,888

14,187,819 (7,248,931) 6,938,888

14,376,990 (7,438,102) 6,938,888

14,568,683 (7,629,795) 6,938,888

14,762,932 (7,824,044) 6,938,888

14,959,771 (8,020,883) 6,938,888

15,159,235 (8,220,347) 6,938,888

15,361,358 (8,422,470) 6,938,888

15,566,176 (8,627,288) 6,938,888

15,773,725 (8,834,837) 6,938,888

15,984,042 (9,045,154) 6,938,888

16,197,162 (9,258,274) 6,938,888

16,413,124 (9,474,236) 6,938,888

16,631,966 (9,693,078) 6,938,888

16,853,726 (9,914,838) 6,938,888

17,078,442 (10,139,554) 6,938,888

17,306,155 (10,367,266) 6,938,888

17,536,903 (10,598,015) 6,938,888

17,770,729 (10,831,841) 6,938,888

18,007,672 (11,068,784) 6,938,888

18,247,774 (11,308,886) 6,938,888

18,491,078 (11,552,190) 6,938,888

18,737,625 (11,798,737) 6,938,888

18,987,460 (12,048,572) 6,938,888

19,240,626 (12,301,738) 6,938,888

19,497,168 (12,558,280) 6,938,888

19,757,130 (12,818,242) 6,938,888

20,020,559 (13,081,671) 6,938,888

20,287,500 (13,348,611) 6,938,888

20,558,000 (13,619,111) 6,938,888

20,832,106 (13,893,218) 6,938,888

1,262,823,467 (430,156,895) 832,666,572

Page 7: simulasi-angsuran-KPR.xls

Contoh perhitungan Angsuran FLAT

Pokok 100,000,000 Bunga 120,000,000

Tenor (Bln) 120 P+B 220,000,000

Int (Flat) 12% Angsuran/bln 1,833,333

Bulan AngKe O/S Pokok AngPokok Angs Bunga Angsuran

0 0 100,000,000

1 1 99,166,667 833,333 1,000,000 1,833,333

2 2 98,333,333 833,333 1,000,000 1,833,333

3 3 97,500,000 833,333 1,000,000 1,833,333

4 4 96,666,667 833,333 1,000,000 1,833,333

5 5 95,833,333 833,333 1,000,000 1,833,333

6 6 95,000,000 833,333 1,000,000 1,833,333

7 7 94,166,667 833,333 1,000,000 1,833,333

8 8 93,333,333 833,333 1,000,000 1,833,333

9 9 92,500,000 833,333 1,000,000 1,833,333

10 10 91,666,667 833,333 1,000,000 1,833,333

11 11 90,833,333 833,333 1,000,000 1,833,333

12 12 90,000,000 833,333 1,000,000 1,833,333

13 13 89,166,667 833,333 1,000,000 1,833,333

14 14 88,333,333 833,333 1,000,000 1,833,333

15 15 87,500,000 833,333 1,000,000 1,833,333

16 16 86,666,667 833,333 1,000,000 1,833,333

17 17 85,833,333 833,333 1,000,000 1,833,333

18 18 85,000,000 833,333 1,000,000 1,833,333

19 19 84,166,667 833,333 1,000,000 1,833,333

20 20 83,333,333 833,333 1,000,000 1,833,333

21 21 82,500,000 833,333 1,000,000 1,833,333

22 22 81,666,667 833,333 1,000,000 1,833,333

23 23 80,833,333 833,333 1,000,000 1,833,333

24 24 80,000,000 833,333 1,000,000 1,833,333

25 25 79,166,667 833,333 1,000,000 1,833,333

26 26 78,333,333 833,333 1,000,000 1,833,333

27 27 77,500,000 833,333 1,000,000 1,833,333

28 28 76,666,667 833,333 1,000,000 1,833,333

29 29 75,833,333 833,333 1,000,000 1,833,333

30 30 75,000,000 833,333 1,000,000 1,833,333

31 31 74,166,667 833,333 1,000,000 1,833,333

32 32 73,333,333 833,333 1,000,000 1,833,333

33 33 72,500,000 833,333 1,000,000 1,833,333

34 34 71,666,667 833,333 1,000,000 1,833,333

35 35 70,833,333 833,333 1,000,000 1,833,333

36 36 70,000,000 833,333 1,000,000 1,833,333

37 37 69,166,667 833,333 1,000,000 1,833,333

38 38 68,333,333 833,333 1,000,000 1,833,333

39 39 67,500,000 833,333 1,000,000 1,833,333

40 40 66,666,667 833,333 1,000,000 1,833,333

41 41 65,833,333 833,333 1,000,000 1,833,333

42 42 65,000,000 833,333 1,000,000 1,833,333

43 43 64,166,667 833,333 1,000,000 1,833,333

44 44 63,333,333 833,333 1,000,000 1,833,333

45 45 62,500,000 833,333 1,000,000 1,833,333

Page 8: simulasi-angsuran-KPR.xls

46 46 61,666,667 833,333 1,000,000 1,833,333

47 47 60,833,333 833,333 1,000,000 1,833,333

48 48 60,000,000 833,333 1,000,000 1,833,333

49 49 59,166,667 833,333 1,000,000 1,833,333

50 50 58,333,333 833,333 1,000,000 1,833,333

51 51 57,500,000 833,333 1,000,000 1,833,333

52 52 56,666,667 833,333 1,000,000 1,833,333

53 53 55,833,333 833,333 1,000,000 1,833,333

54 54 55,000,000 833,333 1,000,000 1,833,333

55 55 54,166,667 833,333 1,000,000 1,833,333

56 56 53,333,333 833,333 1,000,000 1,833,333

57 57 52,500,000 833,333 1,000,000 1,833,333

58 58 51,666,667 833,333 1,000,000 1,833,333

59 59 50,833,333 833,333 1,000,000 1,833,333

60 60 50,000,000 833,333 1,000,000 1,833,333

61 61 49,166,667 833,333 1,000,000 1,833,333

62 62 48,333,333 833,333 1,000,000 1,833,333

63 63 47,500,000 833,333 1,000,000 1,833,333

64 64 46,666,667 833,333 1,000,000 1,833,333

65 65 45,833,333 833,333 1,000,000 1,833,333

66 66 45,000,000 833,333 1,000,000 1,833,333

67 67 44,166,667 833,333 1,000,000 1,833,333

68 68 43,333,333 833,333 1,000,000 1,833,333

69 69 42,500,000 833,333 1,000,000 1,833,333

70 70 41,666,667 833,333 1,000,000 1,833,333

71 71 40,833,333 833,333 1,000,000 1,833,333

72 72 40,000,000 833,333 1,000,000 1,833,333

73 73 39,166,667 833,333 1,000,000 1,833,333

74 74 38,333,333 833,333 1,000,000 1,833,333

75 75 37,500,000 833,333 1,000,000 1,833,333

76 76 36,666,667 833,333 1,000,000 1,833,333

77 77 35,833,333 833,333 1,000,000 1,833,333

78 78 35,000,000 833,333 1,000,000 1,833,333

79 79 34,166,667 833,333 1,000,000 1,833,333

80 80 33,333,333 833,333 1,000,000 1,833,333

81 81 32,500,000 833,333 1,000,000 1,833,333

82 82 31,666,667 833,333 1,000,000 1,833,333

83 83 30,833,333 833,333 1,000,000 1,833,333

84 84 30,000,000 833,333 1,000,000 1,833,333

85 85 29,166,667 833,333 1,000,000 1,833,333

86 86 28,333,333 833,333 1,000,000 1,833,333

87 87 27,500,000 833,333 1,000,000 1,833,333

88 88 26,666,667 833,333 1,000,000 1,833,333

89 89 25,833,333 833,333 1,000,000 1,833,333

90 90 25,000,000 833,333 1,000,000 1,833,333

91 91 24,166,667 833,333 1,000,000 1,833,333

92 92 23,333,333 833,333 1,000,000 1,833,333

93 93 22,500,000 833,333 1,000,000 1,833,333

94 94 21,666,667 833,333 1,000,000 1,833,333

95 95 20,833,333 833,333 1,000,000 1,833,333

96 96 20,000,000 833,333 1,000,000 1,833,333

97 97 19,166,667 833,333 1,000,000 1,833,333

98 98 18,333,333 833,333 1,000,000 1,833,333

99 99 17,500,000 833,333 1,000,000 1,833,333

Page 9: simulasi-angsuran-KPR.xls

100 100 16,666,667 833,333 1,000,000 1,833,333

101 101 15,833,333 833,333 1,000,000 1,833,333

102 102 15,000,000 833,333 1,000,000 1,833,333

103 103 14,166,667 833,333 1,000,000 1,833,333

104 104 13,333,333 833,333 1,000,000 1,833,333

105 105 12,500,000 833,333 1,000,000 1,833,333

106 106 11,666,667 833,333 1,000,000 1,833,333

107 107 10,833,333 833,333 1,000,000 1,833,333

108 108 10,000,000 833,333 1,000,000 1,833,333

109 109 9,166,667 833,333 1,000,000 1,833,333

110 110 8,333,333 833,333 1,000,000 1,833,333

111 111 7,500,000 833,333 1,000,000 1,833,333

112 112 6,666,667 833,333 1,000,000 1,833,333

113 113 5,833,333 833,333 1,000,000 1,833,333

114 114 5,000,000 833,333 1,000,000 1,833,333

115 115 4,166,667 833,333 1,000,000 1,833,333

116 116 3,333,333 833,333 1,000,000 1,833,333

117 117 2,500,000 833,333 1,000,000 1,833,333

118 118 1,666,667 833,333 1,000,000 1,833,333

119 119 833,333 833,333 1,000,000 1,833,333

120 120 0 833,333 1,000,000 1,833,333

100,000,000 120,000,000 220,000,000