Perhitungan Okfix.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Perhitungan Okfix.xlsx as PDF for free.
More details
- Words: 648
- Pages: 9
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) Seng Kayu (5x5) Kayu (5x10) Paku 7 (1/2 kg) Paku 5 (1 kg) Paku Seng (1/2 kg)
Pengelompokan Biaya 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Modal
Total Pengelompokan Biaya Ongkos Produksi Biaya Operasi Ongkos Perawatan
Pengelompokkan Biaya Kayu Besi / Tahun Minyak Tanah / Bulan Betel Bulat / Bulan Linggis / 4 Tahun Total
Pengelompokan Biaya Bongkah (30cm - 50cm) Pemasaran Kerakal (3cm - 6cm)
Pengelompokkan Biaya Ukuran 80 kg (Truck) / 2 Bulan Ukuran 50 kg (45 Karung / Bulan) Total
NCARA (2018) NDRAL SOEDIRMAN Harga Barang (Rp) 50,000.00 100,000.00 150,000.00 15,000.00 200,000.00 120,000.00 91,000.00 65,000.00 52,000.00 40,000.00 50,000.00 3,000.00 5,000.00 12,000.00 953,000.00
Jumlah Barang 4.00 2.00 1.00 2.00 1.00 1.00 1.00 1.00 7.00 7.00 5.00 1.00 1.00 1.00 35.00
Harga Barang (Rp) Harga Barang / Tahun 1,500,000.00 1,500,000.00 6,000.00 72,000.00 30,000.00 360,000.00 12,500.00 1,536,000.00 1,944,500.00
Jumlah Harga (Rp) 200,000.00 200,000.00 150,000.00 30,000.00 200,000.00 120,000.00 91,000.00 65,000.00 364,000.00 280,000.00 250,000.00 3,000.00 5,000.00 12,000.00 1,970,000.00 Jumlah Barang 1.00 1.00 2.00 1.00 5.00
Jumlah Harga (Rp) 1,500,000.00 72,000.00 720,000.00 12,500.00 2,304,500.00
Harga Barang (Rp) Harga Barang / Tahun Jumlah Barang (Tahun) 900,000.00 5,400,000.00 15,000.00 45.00 915,000.00 5,400,000.00 45.00
Jumlah Harga (Rp) 5,400,000.00 8,100,000.00 13,500,000.00
Modal Awal Laba Bersih Interest Tahun ke2006 1 2 3 4 5 6 7 8 9 10 11 12
1970000 11,195,500.00 5.75
6
Prediksi Kas Masuk IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00
NPV ROR PBP NAV NFV
IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
IDR
IDR IDR
Pendapatan Bersih (1,970,000.00) 9,225,500.00 20,421,000.00 31,616,500.00 42,812,000.00 54,007,500.00 65,203,000.00 76,398,500.00 87,594,000.00 98,789,500.00 109,985,000.00 121,180,500.00 132,376,000.00
IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
NPV 5.75% 8,723,877.07 18,260,650.87 26,734,536.74 34,232,925.31 40,836,846.16 46,621,401.18 51,656,169.62 56,005,586.63 59,729,296.96 62,882,485.40 65,516,185.45 67,677,567.60
IDR
538,877,529.00
536,907,529.00 5.88 0.82 109,357,810.20 849,609,000.00
Keuntungan Tetap Selama 1 Tahun 12 THN IDR 134,346,000.00 NPVK IDR 1,139,965,041.33 NPVB IDR 1,124,365,898.01 IDR NAV IDR 134,114,234.08 IDR NFV IDR 2,229,749,349.20
% (Layak) 9.89
5.88 932,958.33 38,873.26
NAV IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
9,225,500.00 9,925,151.88 9,955,424.71 9,822,836.73 9,628,680.54 9,406,708.05 9,171,371.26 8,929,882.44 8,686,234.28 8,442,807.94 8,201,104.07 7,962,108.32 ###
237.32
ROR IDR (1,037,041.67) IDR 155,493.06 IDR 1,088,451.39
NFV
PV
IDR 9,225,500.00 IDR 20,421,000.00 IDR 31,616,500.00 IDR 42,812,000.00 IDR 54,007,500.00 IDR 65,203,000.00 IDR 76,398,500.00 IDR 87,594,000.00 IDR 98,789,500.00 IDR 109,985,000.00 IDR 121,180,500.00 IDR 132,376,000.00
0.95 0.89 0.85 0.80 0.76 0.72 0.68 0.64 0.60 0.57 0.54 0.51 0.50
Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12
IDR 849,609,000.00 IDR
65,707,567.60
IDR
8.38 1,124,365,898.01
Hari
IDR IDR IDR
(104,083.33) IDR 116,619.79 IDR 12,536.46 IDR
1,865,916.67 116,619.79 1,982,536.46
IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
NPV 6.00% 8,703,301.89 18,174,617.30 26,545,823.06 33,911,113.91 40,357,545.77 45,965,542.12 50,809,365.90 54,957,559.26 58,473,353.26 61,415,049.54 63,836,375.72 65,786,816.47
NAV IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
9,225,500.00 20,421,000.00 31,616,500.00 42,812,000.00 54,007,500.00 65,203,000.00 76,398,500.00 87,594,000.00 98,789,500.00 109,985,000.00 121,180,500.00 132,376,000.00
IDR 526,966,464.20 IDR 108,618,485.41 IDR
849,609,000.00
IDR
67,756,816.47
IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
9,225,500.00 9,913,106.80 9,931,052.90 9,786,458.97 9,580,736.10 9,347,673.46 9,101,736.68 8,850,142.36 8,596,883.08 8,344,337.38 8,094,001.64 7,846,856.04
NFV
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
900000000.00
800000000.00
700000000.00
600000000.00
500000000.00 IDR 536,907,529.00 5.88 % (Layak) 400000000.00
300000000.00
200000000.00
100000000.00
0.00 PBP
NAV
NFV
Pengelompokan Biaya 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Modal
Total Pengelompokan Biaya Ongkos Produksi Biaya Operasi Ongkos Perawatan
Pengelompokkan Biaya Kayu Besi / Tahun Minyak Tanah / Bulan Betel Bulat / Bulan Linggis / 4 Tahun Total
Pengelompokan Biaya Bongkah (30cm - 50cm) Pemasaran Kerakal (3cm - 6cm)
Pengelompokkan Biaya Ukuran 80 kg (Truck) / 2 Bulan Ukuran 50 kg (45 Karung / Bulan) Total
NCARA (2018) NDRAL SOEDIRMAN Harga Barang (Rp) 50,000.00 100,000.00 150,000.00 15,000.00 200,000.00 120,000.00 91,000.00 65,000.00 52,000.00 40,000.00 50,000.00 3,000.00 5,000.00 12,000.00 953,000.00
Jumlah Barang 4.00 2.00 1.00 2.00 1.00 1.00 1.00 1.00 7.00 7.00 5.00 1.00 1.00 1.00 35.00
Harga Barang (Rp) Harga Barang / Tahun 1,500,000.00 1,500,000.00 6,000.00 72,000.00 30,000.00 360,000.00 12,500.00 1,536,000.00 1,944,500.00
Jumlah Harga (Rp) 200,000.00 200,000.00 150,000.00 30,000.00 200,000.00 120,000.00 91,000.00 65,000.00 364,000.00 280,000.00 250,000.00 3,000.00 5,000.00 12,000.00 1,970,000.00 Jumlah Barang 1.00 1.00 2.00 1.00 5.00
Jumlah Harga (Rp) 1,500,000.00 72,000.00 720,000.00 12,500.00 2,304,500.00
Harga Barang (Rp) Harga Barang / Tahun Jumlah Barang (Tahun) 900,000.00 5,400,000.00 15,000.00 45.00 915,000.00 5,400,000.00 45.00
Jumlah Harga (Rp) 5,400,000.00 8,100,000.00 13,500,000.00
Modal Awal Laba Bersih Interest Tahun ke2006 1 2 3 4 5 6 7 8 9 10 11 12
1970000 11,195,500.00 5.75
6
Prediksi Kas Masuk IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00 11,195,500.00
NPV ROR PBP NAV NFV
IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
IDR
IDR IDR
Pendapatan Bersih (1,970,000.00) 9,225,500.00 20,421,000.00 31,616,500.00 42,812,000.00 54,007,500.00 65,203,000.00 76,398,500.00 87,594,000.00 98,789,500.00 109,985,000.00 121,180,500.00 132,376,000.00
IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
NPV 5.75% 8,723,877.07 18,260,650.87 26,734,536.74 34,232,925.31 40,836,846.16 46,621,401.18 51,656,169.62 56,005,586.63 59,729,296.96 62,882,485.40 65,516,185.45 67,677,567.60
IDR
538,877,529.00
536,907,529.00 5.88 0.82 109,357,810.20 849,609,000.00
Keuntungan Tetap Selama 1 Tahun 12 THN IDR 134,346,000.00 NPVK IDR 1,139,965,041.33 NPVB IDR 1,124,365,898.01 IDR NAV IDR 134,114,234.08 IDR NFV IDR 2,229,749,349.20
% (Layak) 9.89
5.88 932,958.33 38,873.26
NAV IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
9,225,500.00 9,925,151.88 9,955,424.71 9,822,836.73 9,628,680.54 9,406,708.05 9,171,371.26 8,929,882.44 8,686,234.28 8,442,807.94 8,201,104.07 7,962,108.32 ###
237.32
ROR IDR (1,037,041.67) IDR 155,493.06 IDR 1,088,451.39
NFV
PV
IDR 9,225,500.00 IDR 20,421,000.00 IDR 31,616,500.00 IDR 42,812,000.00 IDR 54,007,500.00 IDR 65,203,000.00 IDR 76,398,500.00 IDR 87,594,000.00 IDR 98,789,500.00 IDR 109,985,000.00 IDR 121,180,500.00 IDR 132,376,000.00
0.95 0.89 0.85 0.80 0.76 0.72 0.68 0.64 0.60 0.57 0.54 0.51 0.50
Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12
IDR 849,609,000.00 IDR
65,707,567.60
IDR
8.38 1,124,365,898.01
Hari
IDR IDR IDR
(104,083.33) IDR 116,619.79 IDR 12,536.46 IDR
1,865,916.67 116,619.79 1,982,536.46
IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
NPV 6.00% 8,703,301.89 18,174,617.30 26,545,823.06 33,911,113.91 40,357,545.77 45,965,542.12 50,809,365.90 54,957,559.26 58,473,353.26 61,415,049.54 63,836,375.72 65,786,816.47
NAV IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
9,225,500.00 20,421,000.00 31,616,500.00 42,812,000.00 54,007,500.00 65,203,000.00 76,398,500.00 87,594,000.00 98,789,500.00 109,985,000.00 121,180,500.00 132,376,000.00
IDR 526,966,464.20 IDR 108,618,485.41 IDR
849,609,000.00
IDR
67,756,816.47
IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR
9,225,500.00 9,913,106.80 9,931,052.90 9,786,458.97 9,580,736.10 9,347,673.46 9,101,736.68 8,850,142.36 8,596,883.08 8,344,337.38 8,094,001.64 7,846,856.04
NFV
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
900000000.00
800000000.00
700000000.00
600000000.00
500000000.00 IDR 536,907,529.00 5.88 % (Layak) 400000000.00
300000000.00
200000000.00
100000000.00
0.00 PBP
NAV
NFV
Related Documents
Perhitungan
October 2019 55
Perhitungan
April 2020 44
Perhitungan Korosi.docx
December 2019 37
Perhitungan Okfix.xlsx
August 2019 45
Perhitungan Sample.docx
December 2019 32
Perhitungan Dossis.xlsx
June 2020 27More Documents from "ANita"
Perhitungan Okfix.xlsx
August 2019 45
Iii Hasil Dan Pembahasan.docx
August 2019 33
Bab Iii Dasar Teori Peirisan Air.pdf
August 2019 40
Ok Fix.docx
August 2019 41
Fix Betul
August 2019 51