{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["MULAI","ALAT ANGGARAN"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"MULAI","index":0,"n_rows":6,"n_cols":2,"rows_kept":6}
[null,"TENTANG TEMPLAT INI"]
[null,"Catat investasi awal pada situs web, keuntungan, dan biayanya menggunakan alat penganggaran situs web ini."]
[null,"Masukkan detail dalam tabel untuk menghitung total dan metrik evaluasi secara otomatis."]
[null,"Catatan:  "]
[null,"Instruksi tambahan telah tersedia di kolom A dalam lembar kerja ALAT ANGGARAN. Teks ini sengaja disembunyikan. Untuk menghapus teks, pilih kolom A, lalu pilih HAPUS. Untuk memperlihatkan teks, pilih kolom A, lalu ubah warna font."]
[null,"Untuk mempelajari selengkapnya tentang tabel dalam lembar kerja, tekan SHIFT kemudian F10 dalam tabel, pilih opsi TABEL, lalu pilih TEKS ALTERNATIF."]

{"sheet":"ALAT ANGGARAN","index":1,"n_rows":43,"n_cols":6,"rows_kept":43}
[]
[null,"Quadrex Hardware"]
[null,"ALAT PENGANGGARAN SITUS WEB"]
[null,"2022-12-01"]
[]
[null,"Data perusahaan","Tarif"]
[null,"Tingkat pengembalian yang diperlukan",{"v":0.1,"d":"10%"}]
[null,"Tarif pajak",{"v":0.3,"d":"30%"}]
[]
[null,"Investasi awal pada situs web","Tahun"]
[null,"Perangkat keras (misalnya, server)",{"v":25000,"d":"Rp25,000.00"}]
[null,"Perangkat lunak (mis. perangkat lunak katalog e-niaga)",{"v":15000,"d":"Rp15,000.00"}]
[null,"Pengembangan (misalnya, rancangan dan pengembangan situs pihak ketiga)",{"v":150000,"d":"Rp150,000.00"}]
[null,"Total investasi awal",{"$f":"SUBTOTAL(109,InvestasiAwal[Tahun])","v":{"v":190000,"d":"Rp190,000.00"}}]
[]
[null,"Keuntungan dari situs web","Tahun 1","Tahun 2","Tahun 3"]
[null,"Penjualan langsung",{"v":15000,"d":"Rp15,000.00"},{"v":50000,"d":"Rp50,000.00"},{"v":75000,"d":"Rp75,000.00"}]
[null,"Penjualan tambahan dari peningkatan efektivitas promosi/staf penjualan",{"v":25000,"d":"Rp25,000.00"},{"v":25000,"d":"Rp25,000.00"},{"v":25000,"d":"Rp25,000.00"}]
[null,"Penjualan tambahan dari peningkatan partisipasi mitra",{"v":25000,"d":"Rp25,000.00"},{"v":25000,"d":"Rp25,000.00"},{"v":25000,"d":"Rp25,000.00"}]
[null,"Pengurangan biaya perjalanan",{"v":25000,"d":"Rp25,000.00"},{"v":25000,"d":"Rp25,000.00"},{"v":25000,"d":"Rp25,000.00"}]
[null,"Pengurangan biaya layanan pelanggan",{"v":50000,"d":"Rp50,000.00"},{"v":50000,"d":"Rp50,000.00"},{"v":50000,"d":"Rp50,000.00"}]
[null,"Total keuntungan",{"$f":"SUBTOTAL(109,Keuntungan[Tahun 1])","v":{"v":140000,"d":"Rp140,000.00"}},{"$f":"SUBTOTAL(109,Keuntungan[Tahun 2])","v":{"v":175000,"d":"Rp175,000.00"}},{"$f":"SUBTOTAL(109,Keuntungan[Tahun 3])","v":{"v":200000,"d":"Rp200,000.00"}}]
[]
[null,"Biaya (di luar investasi modal awal)","TAHUN 1","TAHUN 2","TAHUN 3"]
[null,"Biaya penjualan",{"v":7500,"d":"Rp7,500.00"},{"v":25000,"d":"Rp25,000.00"},{"v":37500,"d":"Rp37,500.00"}]
[null,"Pemeliharaan",{"v":15000,"d":"Rp15,000.00"},{"v":15000,"d":"Rp15,000.00"},{"v":15000,"d":"Rp15,000.00"}]
[null,"Manajemen proyek, dukungan pelanggan",{"v":35000,"d":"Rp35,000.00"},{"v":35000,"d":"Rp35,000.00"},{"v":35000,"d":"Rp35,000.00"}]
[null,"Iklan online, pendaftaran mesin pencari",{"v":10000,"d":"Rp10,000.00"},{"v":10000,"d":"Rp10,000.00"},{"v":10000,"d":"Rp10,000.00"}]
[null,"Depresiasi atas belanja modal (penghitungan menggunakan periode tiga tahun)",{"$f":"InvestasiAwal[[#Totals],[Tahun]]/3","v":{"v":63333.333333333336,"d":"Rp63,333.33"}},{"$f":"InvestasiAwal[[#Totals],[Tahun]]/3","v":{"v":63333.333333333336,"d":"Rp63,333.33"}},{"$f":"InvestasiAwal[[#Totals],[Tahun]]/3","v":{"v":63333.333333333336,"d":"Rp63,333.33"}}]
[null,"Total biaya",{"$f":"SUBTOTAL(109,Biaya[TAHUN 1])","v":{"v":130833.33333333334,"d":"Rp130,833.33"}},{"$f":"SUBTOTAL(109,Biaya[TAHUN 2])","v":{"v":148333.33333333334,"d":"Rp148,333.33"}},{"$f":"SUBTOTAL(109,Biaya[TAHUN 3])","v":{"v":160833.33333333334,"d":"Rp160,833.33"}}]
[]
[null,"Total"," ","Tahun 1","Tahun 2","Tahun 3"]
[null,"Keuntungan bersih (biaya)",null,{"$f":"Keuntungan[[#Totals],[Tahun 1]]-Biaya[[#Totals],[TAHUN 1]]","v":{"v":9166.666666666657,"d":"Rp9,166.67"}},{"$f":"Keuntungan[[#Totals],[Tahun 2]]-Biaya[[#Totals],[TAHUN 2]]","v":{"v":26666.666666666657,"d":"Rp26,666.67"}},{"$f":"Keuntungan[[#Totals],[Tahun 3]]-Biaya[[#Totals],[TAHUN 3]]","v":{"v":39166.66666666666,"d":"Rp39,166.67"}}]
[null,"Pajak",null,{"$f":"D33*TarifPajak","v":{"v":2749.999999999997,"d":"Rp2,750.00"}},{"$f":"E33*TarifPajak","v":{"v":7999.999999999996,"d":"Rp8,000.00"}},{"$f":"F33*TarifPajak","v":{"v":11749.999999999996,"d":"Rp11,750.00"}}]
[null,"Nilai setelah pajak",null,{"$f":"D33-D34","v":{"v":6416.666666666661,"d":"Rp6,416.67"}},{"v":18666.66666666666,"d":"Rp18,666.67"},{"v":27416.66666666666,"d":"Rp27,416.67"}]
[null,"Depresiasi ditambahkan kembali",null,{"$f":"C29","v":{"v":63333.333333333336,"d":"Rp63,333.33"}},{"$f":"D29","v":{"v":63333.333333333336,"d":"Rp63,333.33"}},{"$f":"E29","v":{"v":63333.333333333336,"d":"Rp63,333.33"}}]
[null,"Arus kas",{"$f":"-InvestasiAwal[[#Totals],[Tahun]]","v":{"v":-190000,"d":"-Rp190,000.00"}},{"$f":"D35+D36","v":{"v":69750,"d":"Rp69,750.00"}},{"$f":"E35+E36","v":{"v":82000,"d":"Rp82,000.00"}},{"$f":"F35+F36","v":{"v":90750,"d":"Rp90,750.00"}}]
[null,"Arus kas kumulatif",{"$f":"C37","v":{"v":-190000,"d":"-Rp190,000.00"}},{"$f":"C38+D37","v":{"v":-120250,"d":"-Rp120,250.00"}},{"v":-38250,"d":"-Rp38,250.00"},{"v":52500,"d":"Rp52,500.00"}]
[]
[null,"Metrik evaluasi","Nilai"]
[null,"Nilai bersih saat ini (NPV)",{"$f":"C37+(NPV(ROR,D37:F37))","v":{"v":9359.504132231377,"d":"Rp9,359.50"}}]
[null,"Tingkat pengembalian internal (IRR)",{"$f":"IRR(C37:F37)","v":{"v":0.12655165144706393,"d":"12.66%"}}]
[null,"Periode pengembalian (dalam tahun)",{"$f":"IF(F38<=0,\"Lebih dari 3 tahun\",IF(E38<=0,(F37-F38)/F37+2,IF(D38<=0,(E37-E38)/E37+1,IF(C38<=0,(D37-D38)/D37,\"KOSONG\"))))","v":{"v":2.4214876033057853,"d":"2.42"}}]