{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["PINJAMAN KREDIT BALLOON PAYMENT"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"PINJAMAN KREDIT BALLOON PAYMENT","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[1,1,1,2],[6,1,6,2]]}
["                                                                                                                                                                                                                                                                                                                                                            ","PINJAMAN KREDIT BALLOON PAYMENT","TANGGAL"]
[null,"ASUMSI"]
[null,"JUMLAH PINJAMAN POKOK",{"v":10000,"d":"Rp10,000.00"}]
[null,"SUKU BUNGA TAHUNAN",{"v":0.0585,"d":"5.85%"}]
[null,"PERIODE AMORTISASI (DALAM TAHUN)",15]
[null,"TAHUN HINGGA BALLOON PAYMENT",5]
[null,"DATA KEUANGAN UTAMA"]
[null,"ANGSURAN BULANAN",{"$f":"IFERROR(IF(SUM(Asumsi)>0,ROUND(PMT(SukuBunga/12,Periode*12,-Principal),2),\"\"),\"\")","v":{"v":83.58,"d":"Rp83.58"}}]
[null,"TOTAL ANGSURAN BULANAN",{"$f":"IFERROR(IF(AND(AngsuranBulanan>0,TahunHinggaPembayaran>0),TahunHinggaPembayaran*12*AngsuranBulanan,\"\"),\"\")","v":{"v":5014.8,"d":"Rp5,014.80"}}]
[null,"JUMLAH TOTAL PEMBAYARAN",{"$f":"IFERROR(IF(AND(AngsuranBulanan>0,TahunHinggaPembayaran>0),TotalAngsuranBulanan+BalloonPayment,\"\"),\"\")","v":{"v":12594.464455242689,"d":"Rp12,594.46"}}]
[null,"TOTAL BUNGA",{"$f":"IFERROR(IF(OR(TotalJumlahPembayaran>0,TahunHinggaPembayaran>0),TotalJumlahPembayaran-Principal,\"\"),\"\")","v":{"v":2594.464455242689,"d":"Rp2,594.46"}}]
[null,"KREDIT BALLOON PAYMENT",{"$f":"IFERROR(IF(AND(SUM(Asumsi2)>0,SUM(AngsuranBulanan)>0),PV(SukuBunga/12,(Periode-TahunHinggaPembayaran)*12,-AngsuranBulanan),\"\"),\"\")","v":{"v":7579.664455242689,"d":"Rp7,579.66"}}]