perhitungan bunga
DESCRIPTION
bunga bankTRANSCRIPT
Sheet1Plafon Kredit6,000,000Jangka Waktu6Bunga12%TABEL ANGSURAN DEBITUR C dengan perhitungan buanga secara Flat
BlnSaldoAngsuran PokokAngsuran BungaJumlh AngsuranBaki Debet16,000,0001,000,00060,0001,060,0005,000,00025,000,0001,000,00060,0001,060,0004,000,00034,000,0001,000,00060,0001,060,0003,000,00043,000,0001,000,00060,0001,060,0002,000,00052,000,0001,000,00060,0001,060,0001,000,00061,000,0001,000,00060,0001,060,0000Jumlah6,000,000360,0006,360,000TABEL ANGSURAN DEBITUR C dengan perhitungan buanga secara EfektifBlnSaldoAngsuran PokokAngsuran BungaJumlh AngsuranBaki Debet16,000,0001,000,00060,0001,060,0005,000,00025,000,0001,000,00050,0001,050,0004,000,00034,000,0001,000,00040,0001,040,0003,000,00043,000,0001,000,00030,0001,030,0002,000,00052,000,0001,000,00020,0001,020,0001,000,00061,000,0001,000,00010,0001,010,0000Jumlah6,000,000210,0006,210,000TABEL ANGSURAN DEBITUR C dengan perhitungan buanga secara AnuitetBlnSaldoAngsuran PokokAngsuran BungaJumlh AngsuranBaki Debet16,000,000975,29060,0001,035,2905,024,71025,024,710985,04350,2471,035,2904,039,66734,039,667994,89440,3971,035,2903,044,77343,044,7731,004,84230,4481,035,2902,039,93152,039,9311,014,89120,3991,035,2901,025,04061,025,0401,025,04010,2501,035,2900Jumlah6,000,000211,7416,211,741Plafon Kredit6,000,000Jangka Waktu6Bunga12%TABEL ANGSURAN DEBITUR C dengan perhitungan buanga secara Flat
BlnSaldoAngsuran PokokAngsuran BungaJumlh AngsuranBaki Debet16,000,0001,000,00060,0001,060,0005,000,00025,000,0001,000,00060,0001,060,0004,000,00034,000,0001,000,00060,0001,060,0003,000,00043,000,0001,000,00060,0001,060,0002,000,00052,000,0001,000,00060,0001,060,0001,000,00061,000,0001,000,00060,0001,060,0000Jumlah6,000,000360,0006,360,000TABEL ANGSURAN DEBITUR C dengan perhitungan buanga secara EfektifBlnSaldoAngsuran PokokAngsuran BungaJumlh AngsuranBaki Debet16,000,0001,000,00060,0001,060,0005,000,00025,000,0001,000,00050,0001,050,0004,000,00034,000,0001,000,00040,0001,040,0003,000,00043,000,0001,000,00030,0001,030,0002,000,00052,000,0001,000,00020,0001,020,0001,000,00061,000,0001,000,00010,0001,010,0000Jumlah6,000,000210,0006,210,000TABEL ANGSURAN DEBITUR C dengan perhitungan buanga secara AnuitetBlnSaldoAngsuran PokokAngsuran BungaJumlh AngsuranBaki Debet16,000,000975,29060,0001,035,2905,024,71025,024,710985,04350,2471,035,2904,039,66734,039,667994,89440,3971,035,2903,044,77343,044,7731,004,84230,4481,035,2902,039,93152,039,9311,014,89120,3991,035,2901,025,04061,025,0401,025,04010,2501,035,2900Jumlah6,000,000211,7416,211,741
Sheet2
Sheet3