simulasi kredit

24
Schedule Angsuran Plafond Rp 2,200,000 Jumlah Periode 6 effektif rate 60.00% Tanggal Realisasi 3/10/2016 Jatuh Tempo 8/10/2016 Angs. Pokok Grand Total Rp 2,200,000 Angs. Schedule Angs. ke Pembayaran Pokok 1 1 2016-03-10 Rp 366,667 2 2 2016-04-10 Rp 366,667 3 3 2016-05-10 Rp 366,667 4 4 2016-06-10 Rp 366,667 5 5 2016-07-10 Rp 366,667 6 6 2016-08-10 Rp 366,667 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Upload: aak-nok

Post on 13-Jul-2016

40 views

Category:

Documents


4 download

DESCRIPTION

rumus menghitung kredit

TRANSCRIPT

Page 1: simulasi kredit

Schedule Angsuran - effektif Rate

Plafond Rp 2,200,000 Jumlah Periode 6effektif rate 60.00%Tanggal Realisasi 3/10/2016Jatuh Tempo 8/10/2016

Angs.Pokok

Grand Total Rp 2,200,000

Angs. Schedule Angs.ke Pembayaran Pokok

1 1 2016-03-10 Rp 366,667 2 2 2016-04-10 Rp 366,667 3 3 2016-05-10 Rp 366,667 4 4 2016-06-10 Rp 366,667 5 5 2016-07-10 Rp 366,667 6 6 2016-08-10 Rp 366,667 789

101112131415161718192021222324

Page 2: simulasi kredit

252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869

Page 3: simulasi kredit

707172737475767778798081828384858687888990919293949596979899

100101102103104105106107108109110111112113114

Page 4: simulasi kredit

115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159

Page 5: simulasi kredit

160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204

Page 6: simulasi kredit

205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249

Page 7: simulasi kredit

250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294

Page 8: simulasi kredit

295296297298299300301302303304305306307

Page 9: simulasi kredit

Schedule Angsuran - effektif Rate

Pinjaman pokokx Angsuran

Suku bunga flate/ tahunTanggal Realisasi Kredit

Tanggal Jatuh Tempo Pelunasan

Angs. Total Bunga Angsuran

Rp 385,000 Rp 2,585,000

Angs. Total Sisa Bunga Angsuran Pinjaman pokok

Rp 110,000 Rp 476,667 Rp 1,833,333 Rp 91,667 Rp 458,333 Rp 1,466,667 Rp 73,333 Rp 440,000 Rp 1,100,000 Rp 55,000 Rp 421,667 Rp 733,333 Rp 36,667 Rp 403,333 Rp 366,667 Rp 18,333 Rp 385,000 Rp -

Page 10: simulasi kredit
Page 11: simulasi kredit
Page 12: simulasi kredit
Page 13: simulasi kredit
Page 14: simulasi kredit
Page 15: simulasi kredit
Page 16: simulasi kredit
Page 17: simulasi kredit
Page 18: simulasi kredit
Page 19: simulasi kredit
Page 20: simulasi kredit
Page 21: simulasi kredit
Page 22: simulasi kredit
Page 23: simulasi kredit
Page 24: simulasi kredit