Ebg.xlsx

Pengelompokan Biaya Pengelompokkan Biaya Harga Barang (Rp) 12

10

8

Pengelompokan Biaya Pengelompokkan Biaya Harga Barang (Rp) 6

4

2

0

Pengelompokan Biaya Pengelompokkan Biaya Harga Barang (Rp) 12

10

8

Pengelompokan Biaya Pengelompokkan Biaya Harga Barang (Rp) 6

4

2

0

Pengelompokan Biaya Pengelompokkan Biaya Harga Barang (Rp) 12

10

8

Pengelompokan Biaya Pengelompokkan Biaya Harga Barang (Rp) 6

4

2

0

TABEL BIAYA WAWANCARA (2018) PT. BATU API, NAVIGASI, JL JENDRAL SOEDIRMAN Pengelompokkan Biaya Plat Betel Bulat Linggis Palu Hamal (20 kg) Kapak Besi (12 ) Besi (8)

Pengelompokan Biaya 1 2 3 4 5 6 7 8

Modal

Total Pengelompokan Biaya Ongkos Produksi Biaya Operasi Ongkos Perawatan

Pengelompokkan Biaya Kayu Besi / 6 Bulan Minyak Tanah / Bulan Betel Bulat / Bulan Linggis / 4 Tahun sejak 2006 Total

Pengelompokan Biaya Bongkah (30cm - 50cm) Pemasaran Kerakal (3cm - 6cm)

Pengelompokkan Biaya Ukuran 80 kg (Truck) / 2 Bulan Ukuran 50 kg (45 Karung / Tahun) Total

NCARA (2018) NDRAL SOEDIRMAN Harga Barang (Rp) 50000 100000 150000 15000 200000 120000 91000 65000 791000

Jumlah Barang 4 2 1 2 1 1 1 1 13

Jumlah Harga (Rp) 200000 200000 150000 30000 200000 120000 91000 65000 1056000

Harga Barang (Rp) 1500000 6000 30000 50000 1586000

Harga Barang / Tahun 3000000 72000 360000 4166.67 3436166.66666667

Jumlah Barang 1 1 2 1 5

Jumlah Harga (Rp) 3000000 72000 720000 4166.667 3796166.66666667

Harga Barang (Rp) 900000 15000 915000

Harga Barang / Tahun 5400000.00

Jumlah Barang (Tahun) 1 45 46

Jumlah Harga (Rp) 5400000.00 675000.00 6075000.00

5400000.00

Modal Awal Laba Bersih Interest

1056000 2278833.33 5.75%

Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Prediksi Kas Masuk IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00 22,900,000.00

IDR IDR IDR IDR IDR

PV (1,052,000.00) 21,848,000.00 44,748,000.00 67,648,000.00 90,548,000.00 ### ### ### ### ### ### ### ### ### ### ### ### ###

IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

BP (Tahun) BP (Tahun)

0.95 0.54

NPV

Prediksi Kas Masuk

21,654,846.34 20,477,396.06 19,363,967.91 18,311,080.76 17,315,442.80 16,373,941.18 15,483,632.33 14,641,732.70 13,845,610.11 13,092,775.52 12,380,875.20 11,707,683.40 11,071,095.42 10,469,120.96 9,899,877.98 9,361,586.74 8,852,564.29

IDR 243,251,229.70

IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

2,278,833.33 2,278,833.33 2,278,833.33 2,278,833.33 2,278,833.33 2,278,833.33 2,278,833.33 2,278,833.33 2,278,833.33 2,278,833.33 2,278,833.33 2,278,833.33 NPV

11.45 6.44

343.46 193.18

PV IDR (1,056,000.00) IDR 1,222,833.33 IDR 3,501,666.67 IDR 5,780,500.00 IDR 8,059,333.33 IDR 10,338,166.67 IDR 12,617,000.00 IDR 14,895,833.33 IDR 17,174,666.67 IDR 19,453,500.00 IDR 21,732,333.33 IDR 24,011,166.67 IDR 26,290,000.00

NPV 2154925.13790386 2037754.26752138 1926954.39009114 1822179.09228477 1723100.79648678 1629409.73663052 1540812.98972153 1457033.56002036 1377809.51302162 1302893.15652163 1232050.2662143 1165059.35339414

$19,369,982.26

IDR 18,313,982.26