Tugas 1.2.xlsx

TEMPAT KURSUS BAHASA INGGRIS periode jumlah kelas jumlah murid 15/ kelas jumlah pegawai administrasi jumlah guru mengajar

10 tahun 12 180 4 12

i=

0.15

investasi

harga satuan 50,000,000 1,000,000 20,000,000 100,000 350,000 500,000 200,000 200,000

sewa tempat/tahun renovasi izin kursi dan meja belajar kursi dan meja administrasi papan iklan papan tulis spidol dan penghapus total

biaya

gaji karyawan administrasi gaji guru mengajar listrik total

lain - lain

modul belajar/3 bulan total

benefit

jasa kursus per 3 bulannya

tahun

25,000

500,000

DF 1 2 3 4 5 6 7 8 9 10

TOTAL

500,000 1,000,000 5,000,000

0.8695652174 0.7561436673 0.6575162324 0.5717532456 0.4971767353 0.4323275959 0.3759370399 0.3269017738 0.284262412 0.2471847061

investasi 92,250,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000

Untung / Rugi

NPV benefit - NPV cost 1333384704.42342

jumlah 50,000,000 1,000,000 20,000,000 18000000 350,000 500,000 2,400,000 200,000 92,250,000

2000000 12000000 5,000,000 19000000 4500000 4500000 90000000

om

lain-lain 19000000 19000000 19000000 19000000 19000000 19000000 19000000 19000000 19000000 19000000

total cost 18000000 18000000 18000000 18000000 18000000 18000000 18000000 18000000 18000000 18000000

benefit 129,250,000 87,000,000 87,000,000 87,000,000 87,000,000 87,000,000 87,000,000 87,000,000 87,000,000 87,000,000

360000000 360000000 360000000 360000000 360000000 360000000 360000000 360000000 360000000 360000000

NPV benefit NPV cost 313043478.26087 112391304.347826 272211720.226843 65784499.0548204 236705843.675516 57203912.221583 205831168.413492 49742532.3665939 178983624.707384 43254375.9709512 155637934.52816 37612500.8443054 135337334.372313 32706522.4733091 117684638.58462 28440454.3246166 102334468.334452 24730829.8474927 88986494.2038717 21505069.4326023 1806756705.30752 473372000.884101

TEMPAT LES MATEMATIKA