NAMA
JUMLAH
HARGA/UNIT
NILAI INVESTASI
UMUR
UNIT
(RP.X1.000)
(RP.X1.000)
EFEKTIF (THN)
PERSIAPAN
Perizinan
buah
15,000
0
AMDAL
buah
35,000
0
1 unit 1 paket
2,500
30
25,000
10
LAHAN (ha) Jumlah A INVESTASI TETAP BANGUNAN (m2)
Kantor
m2
Peralatan kantor Gudang bahan baku
m2
1 unit
2,500
30
Gudang produk jadi
m2
1 unit
2,500
30
Gedung serbaguna
2,500
Generator listrik
unit
10,000,000
Instalasi listrik
unit
5,000,000
Ruang Pengolahan
2,500
30
Pengolahan limbah
2,500
20
Dinding pagar
400
20
Garasi mobil & motor
500
10
Paving halaman
300
10
Rumah pegawai & tamu
unit
40,000
Jalan lingkungan
m2
69.8
Jalan utama
m2
100
Drainase
m2
210
Gorong-gorong
unit
17,000
Sumur bor
unit
250,000
paket
120,000,000
Tempat ibadah
unit
1,400,000
Sekolah
unit
1,200,000
Mesin Produksi (100 ton/hari)
paket
16,000,000
20
Peralatan Pencegah Kebakaran
paket
10,000
5
Peralatan Laboratorium Alat angkut (fork (fork lift) Buldozer Wheel loader Exavator Grader
paket unit unit unit unit unit
20,000 150,000 1,000,000 500,000 300,000 300,000
10 10
unit
250,000
10
Pipa air & mesin pompa
Jumlah B MESIN DAN PERALATAN
Truk Tangki Truk Angkut
unit
225,000
10
Mobil pick up
unit
125,000
10
Mobil Lapangan 4x4
unit
300,000
10
Sepeda motor trail Jumlah C TOTAL BIAYA INVESTASI
unit
15,000
Pipa air & mesin pompa
paket
120,000,000
Tempat ibadah
unit
1,400,000
Sekolah
unit
1,200,000
Mesin Produksi (100 ton/hari)
paket
16,000,000
20
Peralatan Pencegah Kebakaran
paket
10,000
5
Peralatan Laboratorium Alat angkut (fork (fork lift) Buldozer Wheel loader Exavator Grader
paket unit unit unit unit unit
20,000 150,000 1,000,000 500,000 300,000 300,000
10 10
unit
250,000
10
Jumlah B MESIN DAN PERALATAN
Truk Tangki Truk Angkut
unit
225,000
10
Mobil pick up
unit
125,000
10
Mobil Lapangan 4x4
unit
300,000
10
Sepeda motor trail Jumlah C
15,000
unit
TOTAL BIAYA INVESTASI
Tabel 13. Biaya Non tanaman dan Fee Per Hektar
KUD KABUPATEN N Keterangan A Non Tanaman Pemetaan Perijinan Jalan Koleksi dan produksi (35m/ha) Lahan Gedung dan peralatan Biaya pembinaan dan pelatihan B FEE per tahun Direktur Midle manajemen Tenaga administrasi Biaya Operasional Total
Volume
Satuan
1 paket 1 paket 350000 Meter 8000 ha 1 paket 1 pa paket
1 8 8 1
org org org paket
Nilai ( Rp )
Jumlah Biaya ( Rp )
50,000,000 150,000,000 100,000 200,000 200,000,000 75,000,000
50,000,000 150,000,000 35,000,000,000 1,600,000,000 200,000,000 75,000,000 37,075,000,000
60,000,000 36,000,000 24,000,000 72,000,000
60,000,000 288,000,000 192,000,000 72,000,000 612,000,000
Pipa air & mesin pompa
paket
120,000,000
Tempat ibadah
unit
1,400,000
Sekolah
unit
1,200,000
Mesin Produksi (100 ton/hari)
paket
16,000,000
20
Peralatan Pencegah Kebakaran
paket
10,000
5
Peralatan Laboratorium Alat angkut (fork (fork lift) Buldozer Wheel loader Exavator Grader
paket unit unit unit unit unit
20,000 150,000 1,000,000 500,000 300,000 300,000
10 10
unit
250,000
10
Jumlah B MESIN DAN PERALATAN
Truk Tangki Truk Angkut
unit
225,000
10
Mobil pick up
unit
125,000
10
Mobil Lapangan 4x4
unit
300,000
10
Sepeda motor trail Jumlah C
15,000
unit
TOTAL BIAYA INVESTASI
Tabel 13. Biaya Non tanaman dan Fee Per Hektar
KUD KABUPATEN N Keterangan A Non Tanaman Pemetaan Perijinan Jalan Koleksi dan produksi (35m/ha) Lahan Gedung dan peralatan Biaya pembinaan dan pelatihan B FEE per tahun Direktur Midle manajemen Tenaga administrasi Biaya Operasional Total
Volume
Satuan
1 paket 1 paket 350000 Meter 8000 ha 1 paket 1 pa paket
1 8 8 1
org org org paket
Nilai ( Rp )
Jumlah Biaya ( Rp )
50,000,000 150,000,000 100,000 200,000 200,000,000 75,000,000
50,000,000 150,000,000 35,000,000,000 1,600,000,000 200,000,000 75,000,000 37,075,000,000
60,000,000 36,000,000 24,000,000 72,000,000
60,000,000 288,000,000 192,000,000 72,000,000 612,000,000
KUD KABUPATEN N Keterangan A Non Tanaman Pemetaan Perijinan Jalan Koleksi dan produksi (35m/ha) Lahan Gedung dan peralatan Biaya pembinaan dan pelatihan B FEE per tahun Direktur Midle manajemen Tenaga administrasi Biaya Operasional
Volume
Satuan
1 paket 1 paket 350000 Meter 8000 ha 1 paket 1 pa paket
1 8 8 1
Total
org org org paket
Nilai ( Rp )
Jumlah Biaya ( Rp )
50,000,000 150,000,000 100,000 200,000 200,000,000 75,000,000
50,000,000 150,000,000 35,000,000,000 1,600,000,000 200,000,000 75,000,000 37,075,000,000
60,000,000 36,000,000 24,000,000 72,000,000
60,000,000 288,000,000 192,000,000 72,000,000 612,000,000
BIAY BIAYA A PENYU PENYUSU SUTA TAN/T N/THN HN
NILAI NILAI SISA SISA
(RP.X1.000)
(RP.X1.000)
BIAY BIAYA A PENYU PENYUSU SUTA TAN/T N/THN HN
NILAI NILAI SISA SISA
(RP.X1.000)
(RP.X1.000)
Proyeksi Produksi Kelapa Dalam URAIAN Produksi Kelapa (Butir) Produksi Kopra (kg)
5 11,440 2,542
6 11,440 2,542
7 17,160 3,813
STANDAR KONVERSI Produksi Kopra 2,3 ton kopra/ha Konversi 1 kg Kopra 4.5 butir kelapa Produksi 11500 butir/ha
ASUMSI TAHUN TH KE 5-6 Jumlah Tandan Jumlah butir per tandan Perpohon Frekuensi Panen Jlh Pohon PRODUKSI
2 10 20 4 143 11440
tandan butir butir kali pohon butir
8 17,160 3,813
9 17,160 3,813
10 17,160 3,813
11 17,160 3,813
PER POHON PER TAHUN Produksi 90 butir/tahun Jlh Tanda 16 tandan/phn/tahun Jlh Pohon 143 pohon Produksi 12870 butir/tahun Kopra 3.5 ton/tahun
Proyeksi Produksi Kelapa Dalam URAIAN Produksi Kelapa (Butir) Produksi Kopra (kg)
5 11,440 2,542
6 11,440 2,542
7 17,160 3,813
STANDAR KONVERSI Produksi Kopra 2,3 ton kopra/ha Konversi 1 kg Kopra 4.5 butir kelapa Produksi 11500 butir/ha
ASUMSI TAHUN TH KE 5-6 Jumlah Tandan Jumlah butir per tandan Perpohon Frekuensi Panen Jlh Pohon PRODUKSI KOPRA
2 10 20 4 143 11440 2542.222
tandan butir butir kali pohon butir Kg
ASUMSI TAHUN TH KE 7-11 Jumlah Tandan Jumlah butir per tandan Perpohon Frekuensi Panen Jlh Pohon PRODUKSI KOPRA
3 10 30 4 143 17160 3813.333
tandan butir butir kali pohon butir Kg
ASUMSI TAHUN KE 12-40) Jumlah Tandan Jumlah butir per tandan Perpohon Frekuensi Panen Jlh Pohon PRODUKSI KOPRA
3 20 60 4 143 34320 7626.667
tandan butir butir kali pohon butir Kg
ASUMSI TAHUN KE 41-50 Jumlah Tandan Jumlah butir per tandan Perpohon Frekuensi Panen Jlh Pohon PRODUKSI KOPRA
3 15 45 4 143 25740 5720
tandan butir butir kali pohon butir Kg
8 17,160 3,813
9 17,160 3,813
10 17,160 3,813
11 17,160 3,813
PER POHON PER TAHUN Produksi 90 butir/tahun Jlh Tanda 16 tandan/phn/tahun Jlh Pohon 143 pohon Produksi 12870 butir/tahun Kopra 3.5 ton/tahun
12 34,320 7,627
13 34,320 7,627
14 34,320 7,627
15 34,320 7,627
16 34,320 7,627
17 34,320 7,627
18 34,320 7,627
19 34,320 7,627
20 34,320 7,627
21 34,320 7,627
22 34,320 7,627
23 34,320 7,627
24 34,320 7,627
25 34,320 7,627
26 34,320 7,627
27 34,320 7,627
28 34,320 7,627
29 34,320 7,627
30 34,320 7,627
31 34,320 7,627
32 34,320 7,627
33 34,320 7,627
34 34,320 7,627
35 34,320 7,627
36 34,320 7,627
37 34,320 7,627
38 34,320 7,627
39 34,320 7,627
40 34,320 7,627
41 25,740 5,720
42 25,740 5,720
43 25,740 5,720
44 25,740 5,720
45 25,740 5,720
46 25,740 5,720
47 25,740 5,720
48 25,740 5,720
49 25,740 5,720
50 25,740 5,720
Tabel 10. Biaya Pembibitan Per Hektar KUD KABUPATEN No 1 A
B
C
Keterangan 2 Pembibitan ( secara vegetatif ) Tenaga Kerja Pembuatan tempat perkecambahan (seed bad) Pengecambahan/pendederan benih Penyiraman Pematangan atap bedengan Persiapan media pembibitan Pembuatan tempat pembibitan Pengisian campuran media/tanah ke polybag Pemindahan kecambah ke polybag Penyiraman bibit di polybag Pemupukan Pemberantasan hama & penyakit Pembuatan pagar Pembuatan naungan Penyiangan di dalam dan diluar polybag Pembuatan saluran drainase Seleksi Distribusi bibit Sub total
Volume 3
Satuan 4
Nilai ( Rp ) 5
Jumlah Biaya ( Rp ) 6
0.2 3 0.5 0.3 11.1 1
HOK HOK HOK HOK HOK HOK
35000 35000 35000 35000 35000 35000
7,000 105,000 17,500 10,500 388,500 35,000
26.8 10.8 12 8.3 1 1.6 2
HOK HOK HOK HOK HOK HOK HOK
35000 35000 35000 35000 35000 35000 35000
938,000 378,000 420,000 290,500 35,000 56,000 70,000
16.7 0.9 1.7 3.3
HOK HOK HOK HOK
35000 35000 35000 35000
584,500 31,500 59,500 115,500 3,542,000
150 300 7500 120000 4500 750 25000 1500 120000 12000
270,000 540,000 37,500 120,000 9,000 37,500 250,000 45,000 240,000 12,000 1,561,000
7500 2000000 3000 15000
Sub total
15,000 2,000,000 60,000 15,000 2,090,000
TOTAL BIAYA PEMBIBITAN
7,193,000
Bahan Benih Polybag Karung goni Pasir BBM (Solar) Pupuk kandang Bambu Daun pelapah kelapa Terpal Tali Plastik Sub total Peralatan Kran air Pompa air Selang Pipa paralon
Beli bibit
1800 biji 1800 lembar 5 lembar 1 kubik 2 liter 50 kg 10 btg 30 btg 2 buah 1 kg
2 1 20 1
buah buah meter btg
12,100,000 bibit
5750
69,575,000,000
71,930,000,000
Tabel 1. Biaya Penanaman Perhektar Tahun Ke 0 Perhektar No Keterangan Penanaman ( Tahun 0 ) A Upah Tenaga Kerja Land Clearing Pembuatan saluran drainase Pembuatan teras Mengajir Pembuatan lobang tanaman kelapa Penanaman bibit kelapa Angkutan bibit dan bahan tanaman Pemupukan Awal ( Tahun 0 ) Penyulaman
Volume Satuan
3 7 7 5 10 7 2 5 3
Nilai ( Rp ) Jumlah Biaya ( Rp )
HOK HOK HOK HOK HOK HOK HOK HOK HOK
35000 35000 35000 35000 35000 35000 35000 35000 35000
105,000 245,000 245,000 175,000 350,000 245,000 70,000 175,000 105,000 1,715,000
15000
2,400,000
750 1500 2000 2800 3500
37,500 54,000 50,000 140,000 25,025
160000 90000 200000 35000 45000 5000
160,000 180,000 200,000 35,000 450,000 5,000 1,336,525
35000 7500 4000 10000 30000 3500 350000 27500 30000 12000 40000
70,000 15,000 4,000 30,000 60,000 3,500 350,000 137,500 60,000 12,000 80,000 822,000 3,873,525 TBM 0 tahun
Sub total
B Bahan Bibit Pupuk : -Pupuk kandang -Urea -SP 36 -KCl - Keiserite - Borax - RockPhospat Obat-obatan - Sevin 85 WP - Basudin - Bayrusil 25 EC - Round Up BBM Pelumas
160 butir 50 36 25 50 7.15
1 2 1 1 10 1
kg kg kg kg kg
liter liter liter liter liter liter
Sub total
C Peralatan Cangkul Garpu Batu Asah Ember plastik (10 liter) Parang Kikir Sprayer Keranjang Kampak Tali untuk ajir Skop
2 buah 2 buah 1 buah 3 buah 2 buah 1 buah 1 buah 5 buah 2 buah 1 paket 2 buah Sub total
Jumlah
Tabel 2. Biaya Pemeliharaan Tahun Ke 1 Perhektar No Keterangan Volume Satuan Nilai ( Rp ) Jumlah Biaya ( Rp ) Penanaman ( Tahun 0 ) A Upah Tenaga Kerja Pemupukan 5 HOK 35000 175,000 Penyulaman 3 HOK 35000 105,000
Pengendalian HPT Pembumbunan Penyiangan Perempalan
3 5 6 2
HOK HOK HOK HOK
35000 35000 35000 35000
105,000 175,000 210,000 70,000 840,000
750 1500 2000 2800 3500 5000
37,500 54,000 50,000 140,000 50,050 7,150
160000 90000 200000 35000
160,000 180,000 200,000 35,000
Sub total
B Bahan Pupuk : -Pupuk kandang -Urea -SP 36 -KCl - Keiserite - Borax - RockPhospat Obat-obatan - Sevin 85 WP - Basudin - Bayrusil 25 EC - Round Up
50 36 25 50 14.3 1.43
1 2 1 1
Sub total
Jumlah
kg kg kg kg kg kg
liter liter liter liter
913,700 1,753,700 TBM 1 tahun
Tabel 3. Biaya Pemeliharaan Tahun Ke 2 Perhektar No Keterangan Volume Satuan Nilai ( Rp ) Jumlah Biaya ( Rp ) Penanaman ( Tahun 0 ) A Upah Tenaga Kerja Pemupukan 5 HOK 35000 175,000 Pengendalian HPT 3 HOK 35000 105,000 Pembumbunan 5 HOK 35000 175,000 Penyiangan 6 HOK 35000 210,000 Perempalan 2 HOK 35000 70,000 Sub total 735,000 B Bahan Pupuk : -Pupuk kandang 50 kg 750 37,500 -Urea 72 kg 1500 108,000 -SP 36 50 kg 2000 100,000 -KCl 100 kg 2800 280,000 - Keiserite 21.45 kg 3500 75,075 - Borax 2.86 kg 5000 14,300 - RockPhospat Obat-obatan - Sevin 85 WP 1 liter 160000 160,000 - Basudin 2 liter 90000 180,000 - Bayrusil 25 EC 1 liter 200000 200,000 - Round Up 1 liter 35000 35,000
Sub total
Jumlah
1,189,875 1,924,875 TBM 2 tahun
Tabel 4. Biaya Pemeliharaan Tahun Ke 3-4 Perhektar No Keterangan Volume Satuan Nilai ( Rp ) Jumlah Biaya ( Rp ) Penanaman ( Tahun 0 ) A Upah Tenaga Kerja Pemupukan 5 HOK 35000 175,000 Pengendalian HPT 3 HOK 35000 105,000 Pembumbunan 5 HOK 35000 175,000 Penyiangan 6 HOK 35000 210,000 Perempalan 2 HOK 35000 70,000 Sub total 175,000 B Bahan Pupuk : - pupuk Kandang 50 kg 750 37,500 -Urea 100 kg 1500 150,000 -SP 36 71 kg 2000 142,000 -KCl 215 kg 2800 602,000 - Keiserite 29 kg 3500 101,500 - Borax 4.29 kg 5000 21,450 - RockPhospat Obat-obatan - Sevin 85 WP 1 liter 160000 160,000 - Basudin 2 liter 90000 180,000 - Bayrusil 25 EC 1 liter 200000 200,000 - Round Up 1 liter 35000 35,000
Sub total
Jumlah
1,629,450 1,804,450 TBM 3-4 tahun
Tabel 12. Biaya Pemeliharaan Tahun Ke 5 Perhektar No Keterangan Volume Satuan Nilai ( Rp ) Jumlah Biaya ( Rp ) Penanaman ( Tahun 0 ) A Upah Tenaga Kerja Pemupukan 5 HOK 35000 175,000 Pengendalian HPT 3 HOK 35000 105,000 Pembumbunan 5 HOK 35000 175,000 Penyiangan 6 HOK 35000 210,000 Perempalan 2 HOK 35000 70,000 Sub total 175,000 B Bahan Pupuk : -Urea 100 kg 1500 150,000 -SP 36 71 kg 2000 142,000 -KCl 215 kg 2800 602,000 - Keiserite 29 kg 3500 101,500 - Borax 4.29 kg 5000 21,450 - RockPhospat Obat-obatan - Sevin 85 WP 1 liter 160000 160,000 - Basudin 2 liter 90000 180,000 - Bayrusil 25 EC 1 liter 200000 200,000 - Round Up 1 liter 35000 35,000 Sub total 1,591,950 1,766,950
C Peralatan Cangkul Garpu Batu Asah Ember plastik (10 liter) Parang Kikir Sprayer Keranjang Kampak Tali untuk ajir Skop
2 buah 2 buah 1 buah 3 buah 2 buah 1 buah 1 buah 5 buah 2 buah 1 paket 2 buah Sub total
Jumlah
35000 7500 4000 10000 30000 3500 350000 27500 30000 12000 40000
70,000 15,000 4,000 30,000 60,000 3,500 350,000 137,500 60,000 12,000 80,000 822,000
2,588,950 TBM 3-4 tahun
Kimbun (10.000 ha)
17,150,000,000
269,025
1,030,000 13,365,250,000
8,220,000,000 38,735,250,000
Kimbun (10.000 ha)
822,000
8,400,000,000
9,137,000,000 17,537,000,000 17,537,000,000
Kimbun (10.000 ha)
7,350,000,000
11,898,750,000 19,248,750,000 19,248,750,000
Kimbun (10.000 ha)
1,750,000,000
16,294,500,000 18,044,500,000 18,044,500,000
Kimbun (10.000 ha)
1,750,000,000
25,889,500,000 0
TAHUN PANEN
VOLUME (Kg/TAHUN)
Volume (Kg/ha/tahun)
1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
626,851 729,281 885,000 658,868 838,940 1,090,702 1,303,467 1,553,864 1,870,398 1,946,165 2,043,473 2,145,647 2,252,929 2,365,576 2,483,855 22,795,016
HARGA (Rp/Kg)
REVENUE (Rp/ha/tahun)
2
576 670 813 605 770 1,002 1,197 1,427 1,718 1,787 1,876 1,970 2,069 2,172 2,281 20932.06212
5,966.00 7,102.00 8,258.00 9,279.00 10,196.50 11,083.25 11,070.00 12,654.00 13,401.08 14,516.18 15,241.99 16,004.09 16,804.29 17,644.51 17,686.52 186,907.41
910.09
8,900.35
0 0 0 0 0 0 0 0 0 3,434,153 4,756,064 6,711,047 5,613,991 7,855,144 11,100,572 13,250,119 18,055,643 23,016,853 25,942,040 28,601,099 31,532,712 34,764,815 38,328,208 40,340,439 293,302,899
Average
Revenue 1.089 ha 0 0 0 0 0 0 0 0 0 3,739,793,066 5,179,353,662 7,308,330,000 6,113,636,172 8,554,251,710 12,088,522,942 14,429,379,690 19,662,595,056 25,065,353,230 28,250,881,450 31,146,596,798 34,339,122,970 37,858,883,075 41,739,418,590 43,930,738,066 319,406,856,475
Pinjaman ke bank Jumlah Kredit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Angsuran Pokok
Bunga 14%
Total Angsuran
164,459,250,000 164,459,250,000 148,013,325,000
16,445,925,000
23,024,295,000
39,470,220,000
131,567,400,000
16,445,925,000
20,721,865,500
37,167,790,500
115,121,475,000
16,445,925,000
18,419,436,000
34,865,361,000
98,675,550,000
16,445,925,000
16,117,006,500
32,562,931,500
82,229,625,000
16,445,925,000
13,814,577,000
30,260,502,000
65,783,700,000
16,445,925,000
11,512,147,500
27,958,072,500
49,337,775,000
16,445,925,000
9,209,718,000
25,655,643,000
32,891,850,000
16,445,925,000
6,907,288,500
23,353,213,500
16,445,925,000
16,445,925,000
4,604,859,000
21,050,784,000
0
16,445,925,000
2,302,429,500
18,748,354,500
-16,445,925,000
16,445,925,000
0
16,445,925,000
-32,891,850,000
16,445,925,000
-2,302,429,500
14,143,495,500
-49,337,775,000
16,445,925,000
-4,604,859,000
11,841,066,000
-65,783,700,000
16,445,925,000
-6,907,288,500
9,538,636,500
-82,229,625,000
16,445,925,000
-9,209,718,000
7,236,207,000
-98,675,550,000
16,445,925,000
-11,512,147,500
-98,675,550,000 -98,675,550,000 -98,675,550,000 -98,675,550,000 -98,675,550,000
Analisis Finansial Usahatani Kelapa Per hektar URAIAN 0
1
2
3
4
5
6
7
8
1. INFLOW Produksi (kg) Kelapa (butir) Kopra (Kg) Penerimaan
11,440
11,440
17,160
2,542
2,542
3,813
17,160 3,813
17,795,556
17,795,556
26,693,333
26,693,333
17,795,556
17,795,556
Kredit bank TOTAL INFLOW
-
-
-
-
-
26,693,333
26,693,333
3,873,525
1,753,700
1,924,875
1,804,450
1,804,450
2,588,950
1,766,950
1,766,950
1,766,950
3,873,525
1,753,700
1,924,875
1,804,450
1,804,450
2,588,950
1,766,950
1,766,950
1,766,950
2. OUTFLOW A. Biaya investasi
Pemetaan
50,000,000
Perijinan
150,000,000
Lahan
800,000,000
Gedung dan peralatan
200,000,000
- Pembibitan - penanaman Jumlah
1,200,000,000
B. Biaya Operasional - Operasional & Pemeliharaan - Angsuran bank Jumlah Total outflow
1,753,700
1,924,875
1,804,450
1,804,450
2,588,950
1,766,950
1,766,950
1,766,950
NET INFLOW
1,203,873,525
-1,753,700
-1,924,875
-1,804,450
-1,804,450
15,206,606
16,028,606
24,926,383
24,926,383
NET INFLOW KUMULATIF
-1,753,700
-3,678,575
-5,483,025
-7,287,475
7,919,131
23,947,736
48,874,119
73,800,503
-7,287,475
TBM tanaman
Total investasi/
1,203,873,525
0 thn
0
Net B rata-rata
1,211,161,000
1 thn
1,753,700
2,077,199
2 thn
Thn 8 per bulan
583.0742393 PP
7thn 8 bulan
Harga
Bibit kelapa Harga Kelapa (Rp)/butir Harga Kopra (Rp)/kg
1,924,875 1,200,000,000 1,203,678,575
1 ha 15,000
2220 7000
Non tanaman
Biaya per ha 160
2,400,000
10000 ha 24,000,000,000
Harga
1 ha
Bibit kelapa Harga Kelapa (Rp)/butir Harga Kopra (Rp)/kg
9
Biaya per ha
15,000
10
160
2,400,000
10000 ha 24,000,000,000
2220 7000
11
12
13
14
15
16
17
18
19
17,160
17,160
17,160
34,320
34,320
34,320
34,320
34,320
34,320
34,320
3,813
3,813
3,813
7,627
7,627
7,627
7,627
7,627
7,627
7,627
34,320
26,693,333
26,693,333
26,693,333
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
26,693,333
26,693,333
26,693,333
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
7,627
9
10
11
12
13
14
15
16
17
18
19
17,160
17,160
17,160
34,320
34,320
34,320
34,320
34,320
34,320
34,320
3,813
3,813
3,813
7,627
7,627
7,627
7,627
7,627
7,627
7,627
34,320
26,693,333
26,693,333
26,693,333
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
26,693,333
26,693,333
26,693,333
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
7,627
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
24,926,383
24,104,383
24,926,383
51,619,717
51,619,717
51,619,717
50,797,717
51,619,717
51,619,717
51,619,717
51,619,717
98,726,886
122,831,269
147,757,653
199,377,369
250,997,086
302,616,803
353,414,519
405,034,236
456,653,953
508,273,669
559,893,386
20
21
22
23
24
25
26
27
28
29
30
31
32
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
53,386,667
34,320 7,627 53,386,667
20
21
22
23
24
25
26
27
28
29
30
31
32
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
53,386,667
34,320 7,627 53,386,667
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
50,797,717
51,619,717
51,619,717
51,619,717
51,619,717
50,797,717
51,619,717
51,619,717
51,619,717
51,619,717
50,797,717
51,619,717
51,619,717
610,691,103
662,310,819
713,930,536
765,550,253
817,169,969
867,967,686
919,587,403
971,207,119
1,022,826,836
1,074,446,553
1,125,244,269
1,176,863,986
1,228,483,703
33
34
35
36
37
38
39
40
41
42
43
44
45
46
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
25,740
25,740
25,740
25,740
25,740
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
5,720
5,720
5,720
5,720
5,720
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
40,040,000
40,040,000
40,040,000
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
40,040,000
40,040,000
25,740 5,720 40,040,000
33
34
35
36
37
38
39
40
41
42
43
44
45
46
34,320
34,320
34,320
34,320
34,320
34,320
34,320
34,320
25,740
25,740
25,740
25,740
25,740
7,627
7,627
7,627
7,627
7,627
7,627
7,627
7,627
5,720
5,720
5,720
5,720
5,720
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
40,040,000
40,040,000
40,040,000
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
53,386,667
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
40,040,000
40,040,000
25,740 5,720 40,040,000
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
51,619,717
51,619,717
50,797,717
51,619,717
51,619,717
51,619,717
51,619,717
51,619,717
38,273,050
38,273,050
38,273,050
38,273,050
37,451,050
38,273,050
1,280,103,419
1,331,723,136
1,382,520,853
1,434,140,569
1,485,760,286
1,537,380,003
1,588,999,719
1,640,619,436
1,678,892,486
1,717,165,536
1,755,438,586
1,793,711,636
1,831,162,686
1,869,435,736
47
48
49
50
25,740
25,740
25,740
5,720
5,720
5,720
25,740 5,720
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
2,588,950
47
48
49
50
25,740
25,740
25,740
5,720
5,720
5,720
25,740 5,720
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
40,040,000
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
2,588,950
1,766,950
1,766,950
1,766,950
2,588,950
38,273,050
38,273,050
38,273,050
37,451,050
1,907,708,786
1,945,981,836
1,984,254,886
2,021,705,936
1 Tahun 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
Investasi 120,000,000
2 Cost Operasional 3,873,525 1,753,700 1,924,875 1,804,450 1,804,450 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950
3 Total (1+2) 123,873,525 1,753,700 1,924,875 1,804,450 1,804,450 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950
4 Benefit Penerimaan -
17,795,556 17,795,556 26,693,333 26,693,333 26,693,333 26,693,333 26,693,333 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667
5 Gross B-C (4-3) (123,873,525) (1,753,700) (1,924,875) (1,804,450) (1,804,450) 15,206,606 16,028,606 24,926,383 24,926,383 24,926,383 24,104,383 24,926,383 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717
6 Disc.fact. 14.00% 1 0.8772 0.7695 0.6750 0.5921 0.5194 0.4556 0.3996 0.3506 0.3075 0.2697 0.2366 0.2076 0.1821 0.1597 0.1401 0.1229 0.1078 0.0946 0.0829 0.0728 0.0638 0.0560 0.0491 0.0431 0.0378 0.0331
1 Tahun 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
Investasi 120,000,000
Total Average Gross B/C Ratio Net B/C Ratio Profitability Ratio Net Present Value Payback period IRR ROI
2 Cost Operasional 3,873,525 1,753,700 1,924,875 1,804,450 1,804,450 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 1,766,950 99,838,700 1,996,774
3 Total (1+2) 123,873,525 1,753,700 1,924,875 1,804,450 1,804,450 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 2,588,950 1,766,950 1,766,950 1,766,950 1,766,950 1,766,950 219,838,700 9,558,204 9.6328 1.0792 0.0908 10,897,139 7 tahun 8 bulan 35.64 112.53
4 Benefit Penerimaan -
17,795,556 17,795,556 26,693,333 26,693,333 26,693,333 26,693,333 26,693,333 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 53,386,667 40,040,000 40,040,000 40,040,000 40,040,000 40,040,000 40,040,000 40,040,000 40,040,000 40,040,000 40,040,000 2,117,671,111 42,353,422
77,103 3,855
18 Rata-rata
BEP harga pokok (Rp) BEP Produksi (Kg)
2,194.04 1,073.91
3152.523239
5 Gross B-C (4-3) (123,873,525) (1,753,700) (1,924,875) (1,804,450) (1,804,450) 15,206,606 16,028,606 24,926,383 24,926,383 24,926,383 24,104,383 24,926,383 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 38,273,050 38,273,050 38,273,050 38,273,050 37,451,050 38,273,050 38,273,050 38,273,050 38,273,050 38,273,050 1,897,832,411
8,900.35 910.09
6 Disc.fact. 14.00% 1 0.8772 0.7695 0.6750 0.5921 0.5194 0.4556 0.3996 0.3506 0.3075 0.2697 0.2366 0.2076 0.1821 0.1597 0.1401 0.1229 0.1078 0.0946 0.0829 0.0728 0.0638 0.0560 0.0491 0.0431 0.0378 0.0331 0.0291 0.0255 0.0224 0.0196 0.0172 0.0151 0.0132 0.0116 0.0102 0.0089 0.0078 0.0069 0.0060 0.0053 0.0046 0.0041 0.0036 0.0031 0.0027 0.0024 0.0021 0.0019 0.0016 0.0014
7 PV Gr C DF*3 123,873,525 1,538,333 1,481,129 1,217,952 1,068,379 1,344,620 804,999 706,139 619,420 543,351 698,353 418,091 366,747 321,708 282,200 362,703 217,143 190,477 167,085 146,566 188,376 112,777 98,928 86,779 76,122 97,837 58,573 51,380 45,070 39,535 50,813 30,421 26,685 23,408 20,533 26,391 15,800 13,859 12,157 10,664 13,707 8,206 7,198 6,314 5,539 7,119 4,262 3,738 3,279 2,877 2,523 137,519,790
8 PV. Gr B DF*4 -
9,242,454 8,107,416 10,667,652 9,357,590 8,208,412 7,200,361 6,316,107 11,080,889 9,720,078 8,526,384 7,479,284 6,560,776 5,755,066 5,048,304 4,428,337 3,884,506 3,407,461 2,989,001 2,621,931 2,299,939 2,017,491 1,769,729 1,552,394 1,361,749 1,194,516 1,047,821 919,142 806,265 707,250 620,394 544,206 477,373 418,749 367,323 322,213 282,643 185,950 163,114 143,082 125,511 110,097 96,576 84,716 74,312 65,186 57,181 148,416,929
9 10 Net B-C Gross Inv. 8-7 4-2 (123,873,525) (123,873,525) (1,538,333) (1,753,700) (1,481,129) (1,924,875) (1,217,952) (1,804,450) (1,068,379) (1,804,450) 7,897,834 15,206,606 7,302,417 16,028,606 9,961,513 24,926,383 8,738,169 24,926,383 7,665,061 24,926,383 6,502,008 24,104,383 5,898,015 24,926,383 10,714,142 51,619,717 9,398,370 51,619,717 8,244,184 51,619,717 7,116,581 50,797,717 6,343,632 51,619,717 5,564,590 51,619,717 4,881,219 51,619,717 4,281,771 51,619,717 3,696,129 50,797,717 3,294,684 51,619,717 2,890,073 51,619,717 2,535,152 51,619,717 2,223,818 51,619,717 1,919,654 50,797,717 1,711,156 51,619,717 1,501,014 51,619,717 1,316,679 51,619,717 1,154,981 51,619,717 997,008 50,797,717 888,721 51,619,717 779,579 51,619,717 683,842 51,619,717 599,861 51,619,717 517,815 50,797,717 461,574 51,619,717 404,889 51,619,717 355,166 51,619,717 311,549 51,619,717 268,937 50,797,717 177,744 38,273,050 155,916 38,273,050 136,768 38,273,050 119,972 38,273,050 102,978 37,451,050 92,314 38,273,050 80,978 38,273,050 71,033 38,273,050 62,310 38,273,050 54,658 38,273,050 10,897,139 1,897,832,411 PBP 48,659,225 78,554,255 728,181 (125,411,858) 6,553,627 55,212,852 (1) 64,787,148
11 PV. Inv B Operasional 120,000,000 -
12 PV. Gr. B - C (123,873,525) (1,538,333) (1,481,129) (1,217,952) (1,068,379) 7,897,834 7,302,417 9,961,513 8,738,169 7,665,061 6,502,008 5,898,015 10,714,142 9,398,370 8,244,184 7,116,581 6,343,632 5,564,590 4,881,219 4,281,771 3,696,129 3,294,684 2,890,073 2,535,152 2,223,818 1,919,654 1,711,156 1,501,014 1,316,679 1,154,981 997,008 888,721 779,579 683,842 599,861 517,815 461,574 404,889 355,166 311,549 268,937 177,744 155,916 136,768 119,972 102,978 92,314 80,978 71,033 62,310 54,658 10,897,139
120,000,000
ROI IRR
49,387,405 (25,063,327) (3,019,462)
240,000,000 0
120,000,000
21,794,277
13 B-C (123,873,525) (1,753,700) (1,924,875) 15,991,106 15,991,106 24,104,383 24,926,383 24,926,383 24,926,383 24,926,383 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 51,619,717 50,797,717 51,619,717 51,619,717 51,619,717 38,273,050 37,451,050 38,273,050 38,273,050 38,273,050 38,273,050 37,451,050 38,273,050 38,273,050 38,273,050 2,115,904,161 40,586,472 1,897,832,411
14 DF 36% 1 0.7353 0.5407 0.3975 0.2923 0.2149 0.1580 0.1162 0.0854 0.0628 0.0462 0.0340 0.0250 0.0184 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135 0.0135
15 NPV 36% (123,873,525) (1,289,485) (1,040,698) 6,357,140 4,674,368 5,180,856 3,939,361 2,896,589 2,129,845 1,566,063 2,346,687 1,753,427 1,289,284 948,003 697,061 685,961 697,061 697,061 697,061 697,061 685,961 697,061 697,061 697,061 697,061 685,961 697,061 697,061 697,061 697,061 685,961 697,061 697,061 697,061 697,061 685,961 697,061 697,061 697,061 516,831 505,731 516,831 516,831 516,831 516,831 505,731 516,831 516,831 516,831 28,572,700 548,071 (86,173,675)
139391015.6481 112.5269 35.6400 0.091
16 DF 35% 1.0000 0.7407 0.5487 0.4064 0.3011 0.2230 0.1652 0.1224 0.0906 0.0671 0.0497 0.0368 0.0273 0.0202 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150
17 NPV 35% (123,873,525) (1,299,037) (1,056,173) 6,499,459 4,814,414 5,375,603 4,117,719 3,050,162 2,259,379 1,673,614 2,526,426 1,901,709 1,408,674 1,043,462 772,935 760,626 772,935 772,935 772,935 772,935 760,626 772,935 772,935 772,935 772,935 760,626 772,935 772,935 772,935 772,935 760,626 772,935 772,935 772,935 772,935 760,626 772,935 772,935 772,935 573,087 560,778 573,087 573,087 573,087 573,087 560,778 573,087 573,087 573,087 31,682,777 607,727 (83,853,384)
-36.1392
(127,657,854)
21
(12.43)
(118,152,917)
DF= 1/T 1.0000 0.7353 0.5407 0.3975 0.2923 0.2149 0.1580 0.1162 0.0854 0.0628 0.0462 0.0340 0.0250 0.0184 0.0135
1+i^n 1.0000 1.3600 1.8496 2.5155 3.4210 4.6526 6.3275 8.6054 11.7034 15.9166 21.6466 29.4393 40.0375 54.4510 74.0534
14% 1.0000 1.1400 1.2996 1.4815 1.6890 1.9254 2.1950 2.5023 2.8526 3.2519 3.7072 4.2262 4.8179 5.4924 6.2613
DF14% 1.0000 0.8772 0.7695 0.6750 0.5921 0.5194 0.4556 0.3996 0.3506 0.3075 0.2697 0.2366 0.2076 0.1821 0.1597
URAIAN 0
1
2
3
4
5
1. INFLOW Produksi (kg)
4,000,000
6,500,000
9,000,000
Harga
9250
9250
9250
Penerimaan
37,000,000,000
60,125,000,000
83,250,000,000
Modal sendiri Kredit bank
110,310,250,000
TOTAL INFLOW
28,387,000,000
25,762,000,000
28,387,000,000
25,762,000,000
37,000,000,000
60,125,000,000
83,250,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
46,565,520,000
43,849,198,000
41,132,876,000
612,000,000
612,000,000
47,177,520,000
44,461,198,000
41,744,876,000
110,310,250,000
612,000,000
612,000,000
47,177,520,000
44,461,198,000
41,744,876,000
0
27,775,000,000
25,150,000,000
-10,177,520,000
15,663,802,000
41,505,124,000
27,775,000,000
52,925,000,000
42,747,480,000
58,411,282,000
99,916,406,000
110,310,250,000
2. OUTFLOW A. Biaya investasi
Pemetaan
50,000,000
Perijinan
150,000,000
Lahan
1,600,000,000
Gedung dan peralata
200,000,000
- Pembibitan
69,575,000,000
- penanaman
38,735,250,000 Jumlah
110,310,250,000
B. Biaya Operasional - Pemeliharaan - operasional - Angsuran bank Jumlah
Total outflow NET INFLOW NET INFLOW KUMULATIF
6
7
11,000,000 9250
8
12,500,000 9500
9
13,500,000
10
15,000,000
9500
9500
11
16,000,000 9500
18,000,000 9750
101,750,000,000
118,750,000,000
128,250,000,000
142,500,000,000
152,000,000,000
175,500,000,000
101,750,000,000
118,750,000,000
128,250,000,000
142,500,000,000
152,000,000,000
175,500,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
38,416,554,000
35,700,232,000
32,983,910,000
30,267,588,000
27,551,266,000
24,834,944,000
39,028,554,000
36,312,232,000
33,595,910,000
30,879,588,000
28,163,266,000
25,446,944,000
39,028,554,000
36,312,232,000
33,595,910,000
30,879,588,000
28,163,266,000
25,446,944,000
62,721,446,000
82,437,768,000
94,654,090,000
111,620,412,000
123,836,734,000
150,053,056,000
162,637,852,000
245,075,620,000
339,729,710,000
451,350,122,000
575,186,856,000
725,239,912,000
12
13
19,000,000 9750
14
20,000,000 9750
15
20,000,000 9750
16
20,000,000 10000
17
19,000,000
18
18,000,000
10000
10000
17000000 10000
185,250,000,000
195,000,000,000
195,000,000,000
200,000,000,000
190,000,000,000
180,000,000,000
170,000,000,000
185,250,000,000
195,000,000,000
195,000,000,000
200,000,000,000
190,000,000,000
180,000,000,000
170,000,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
22,730,622,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
22,730,622,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
162,519,378,000
194,388,000,000
194,388,000,000
199,388,000,000
189,388,000,000
179,388,000,000
169,388,000,000
887,759,290,000
1,082,147,290,000
1,276,535,290,000
1,475,923,290,000
1,665,311,290,000
1,844,699,290,000
2,014,087,290,000
22,118,622,000
19
20
16000000
21
22
14000000
23
12000000 11500
10000000 11500
8000000
11500
11500
11500
184,000,000,000
161,000,000,000
138,000,000,000
115,000,000,000
92,000,000,000
184,000,000,000
161,000,000,000
138,000,000,000
115,000,000,000
92,000,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
612,000,000
183,388,000,000
160,388,000,000
137,388,000,000
114,388,000,000
91,388,000,000
2,197,475,290,000
2,357,863,290,000
2,495,251,290,000
2,609,639,290,000
2,701,027,290,000
1 Tahun 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
Investasi 126,000,000
2 Cost Operasional 1,841,385 2,021,119 1,894,673 1,894,673 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298
Total Average Gross B/C Ratio Net B/C Ratio Profitability Ratio Net Present Value Payback period IRR ROI
3 Total (1+2) 126,000,000 1,841,385 2,021,119 1,894,673 1,894,673 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 172,354,901 7,493,691 0.0000 0.0000 -1.1082 (139,631,367) 7 tahun 8 bulan #NUM! -2.45
4 Benefit Penerimaan
5 Gross B-C
-
-
Disc.fact. 14.00%
(126,000,000) (1,841,385) (2,021,119) (1,894,673) (1,894,673) (2,718,398) (1,855,298) (1,855,298) (1,855,298) (1,855,298) (2,718,398) (1,855,298) (1,855,298) (1,855,298) (1,855,298) (2,718,398) (1,855,298) (1,855,298) (1,855,298) (1,855,298) (2,718,398) (1,855,298) (1,855,298) (1,855,298) (42,492,398)
1 0.8772 0.7695 0.6750 0.5921 0.5194 0.4556 0.3996 0.3506 0.3075 0.2697 0.2366 0.2076 0.1821 0.1597 0.1401 0.1229 0.1078 0.0946 0.0829 0.0728 0.0638 0.0560 0.0491
-146,867,700,000 -29,806,350,000 -27,050,100,000 -21,066,289,818 1,362,406,000 23,791,101,818 41,826,047,636 61,404,743,455 71,127,189,273 85,480,885,091 95,203,330,909 118,463,276,727 128,423,222,545 138,383,168,364 138,843,114,182 148,803,060,000 139,288,005,818 129,772,951,636 120,257,897,455 118,342,843,273 97,902,789,091 77,462,734,909 57,022,680,727 40,382,626,545
-146,867,700,000 -176,674,050,000 -203,724,150,000 -224,790,439,818 -223,428,033,818 -199,636,932,000 -157,810,884,364 -96,406,140,909 -25,278,951,636 60,201,933,455 155,405,264,364 273,868,541,091 402,291,763,636 540,674,932,000 679,518,046,182 828,321,106,182
Rata-rata BEP harga pokok (Rp) BEP Produksi (Kg)
#REF! 841.95
8,900.35 #REF!
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
6 PV Gr C DF*3 126,000,000 1,615,250 1,555,185 1,278,850 1,121,798 1,411,850 845,249 741,446 650,391 570,519 733,271 438,996 385,084 337,793 296,310 380,838 228,001 200,001 175,439 153,894 197,795 118,416 103,874 91,118 139,631,367
7 PV. Gr B DF*4 -
-
8 9 Net B-C Gross Inv. 7-6 4-2 (126,000,000) (126,000,000) (1,615,250) (1,841,385) (1,555,185) (2,021,119) (1,278,850) (1,894,673) (1,121,798) (1,894,673) (1,411,850) (2,718,398) (845,249) (1,855,298) (741,446) (1,855,298) (650,391) (1,855,298) (570,519) (1,855,298) (733,271) (2,718,398) (438,996) (1,855,298) (385,084) (1,855,298) (337,793) (1,855,298) (296,310) (1,855,298) (380,838) (2,718,398) (228,001) (1,855,298) (200,001) (1,855,298) (175,439) (1,855,298) (153,894) (1,855,298) (197,795) (2,718,398) (118,416) (1,855,298) (103,874) (1,855,298) (91,118) (1,855,298) (139,631,367) (172,354,901) PBP (10,962,805) (10,366,742) (54,199) (127,615,250) (487,794) (11,450,599) (1) 137,450,599
10 11 PV. Inv B PV. Gr. B - C Operasional 126,000,000 (126,000,000) (1,615,250) (1,555,185) (1,278,850) (1,121,798) (1,411,850) (845,249) (741,446) (650,391) (570,519) (733,271) (438,996) (385,084) (337,793) (296,310) (380,838) (228,001) (200,001) (175,439) (153,894) (197,795) (118,416) (103,874) (91,118) 126,000,000 (139,631,367)
252,000,000 0
9 tahun 7,123,407,091
(126,000,000) (1,841,385) (2,021,119) (1,894,673) (1,894,673) (2,718,398) (1,855,298) (1,855,298) (1,855,298) (1,855,298) (2,718,398) (1,855,298) (1,855,298) (1,855,298) (1,855,298) (2,718,398) (1,855,298) (1,855,298) (1,855,298) (1,855,298) (2,718,398) (1,855,298) (1,855,298) (1,855,298) (172,354,901) -3090326.7500 -2.4526 #NUM! (1.108)
ROI IRR
(11,017,004) (417,244,726) (3,170,435)
12 B-C
(279,262,733)
DF 36% 1 0.7353 0.5407 0.3975 0.2923 0.2149 0.1580 0.1162 0.0854 0.0628 0.0462 0.0340 0.0250 0.0184 0.0135
14 NPV 36% (126,000,000) (1,353,960) (1,092,733) (753,212) (553,833) (584,277) (293,211) (215,596) (158,527) (116,564) (125,581) (63,021) (46,339) (34,073) (25,054)
DF 35% 1.0000 0.7407 0.5487 0.4064 0.3011 0.2230 0.1652 0.1224 0.0906 0.0671 0.0497 0.0368 0.0273 0.0202 0.0150
(131,415,979)
NPV 35% (126,000,000) (1,363,989) (1,108,981) (770,075) (570,426) (606,239) (306,486) (227,027) (168,168) (124,569) (135,200) (68,351) (50,630) (37,504) (27,781)
(131,565,425) 880.3556
(262,831,958)
(263,130,849)
DF= 1/T
1+i^n 1.0000 0.7353 0.5407 0.3975 0.2923 0.2149 0.1580 0.1162 0.0854 0.0628 0.0462 0.0340 0.0250 0.0184 0.0135
1.0000 1.3600 1.8496 2.5155 3.4210 4.6526 6.3275 8.6054 11.7034 15.9166 21.6466 29.4393 40.0375 54.4510 74.0534
14% DF14% 1.0000 1.0000 1.1400 0.8772 1.2996 0.7695 1.4815 0.6750 1.6890 0.5921 1.9254 0.5194 2.1950 0.4556 2.5023 0.3996 2.8526 0.3506 3.2519 0.3075 3.7072 0.2697 4.2262 0.2366 4.8179 0.2076 5.4924 0.1821 6.2613 0.1597
1 Tahun 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
Investasi 126,000,000
2 Cost Operasional 1,841,385 2,021,119 1,894,673 1,894,673 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298
Total Average Gross B/C Ratio Net B/C Ratio Profitability Ratio Net Present Value Payback period IRR ROI
3 Total (1+2) 126,000,000 1,841,385 2,021,119 1,894,673 1,894,673 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 1,855,298 2,718,398 1,855,298 1,855,298 1,855,298 172,354,901 7,493,691 17,431.3291 4,351.5793 4,821.2486 607,477,327,298 7 tahun 8 bulan 29,425.99 317,920.83
4 Benefit Penerimaan
Gross B-C -
37,000,000,000 60,125,000,000 83,250,000,000 101,750,000,000 118,750,000,000 128,250,000,000 142,500,000,000 152,000,000,000 175,500,000,000 185,250,000,000 195,000,000,000 195,000,000,000 200,000,000,000 190,000,000,000 180,000,000,000 170,000,000,000 184,000,000,000 161,000,000,000 138,000,000,000 115,000,000,000 92,000,000,000 3,004,375,000,000
(126,000,000) (1,841,385) (2,021,119) 36,998,105,328 60,123,105,328 83,247,281,603 101,748,144,703 118,748,144,703 128,248,144,703 142,498,144,703 151,997,281,603 175,498,144,703 185,248,144,703 194,998,144,703 194,998,144,703 199,997,281,603 189,998,144,703 179,998,144,703 169,998,144,703 183,998,144,703 160,997,281,603 137,998,144,703 114,998,144,703 91,998,144,703 3,004,332,507,603
Rata-rata BEP harga pokok (Rp) BEP Produksi (Kg)
#REF! 841.95
3152.523239
8,900.35 #REF!
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
-146,867,700,000 -29,806,350,000 -27,050,100,000 -19,216,289,818 4,368,656,000 27,953,601,818 46,913,547,636 64,373,493,455 74,333,439,273 89,043,385,091 99,003,330,909 122,963,276,727 133,173,222,545 143,383,168,364 143,843,114,182 149,303,060,000 139,763,005,818 130,222,951,636 120,682,897,455 135,142,843,273 112,602,789,091 90,062,734,909 67,522,680,727 44,982,626,545
5 Disc.fact. 14.00% 1 0.8772 0.7695 0.6750 0.5921 0.5194 0.4556 0.3996 0.3506 0.3075 0.2697 0.2366 0.2076 0.1821 0.1597 0.1401 0.1229 0.1078 0.0946 0.0829 0.0728 0.0638 0.0560 0.0491
6 PV Gr C DF*3 126,000,000 1,615,250 1,555,185 1,278,850 1,121,798 1,411,850 845,249 741,446 650,391 570,519 733,271 438,996 385,084 337,793 296,310 380,838 228,001 200,001 175,439 153,894 197,795 118,416 103,874 91,118 139,631,367
7 PV. Gr B DF*4 -
24,973,946,099 35,598,826,677 43,237,441,308 46,355,931,227 47,456,932,050 44,959,198,785 43,819,881,856 41,001,059,047 41,526,349,623 38,450,323,725 35,503,530,679 31,143,447,964 28,019,296,414 23,349,413,678 19,403,944,885 16,075,392,936 15,262,498,969 11,714,637,367 8,807,998,020 6,438,595,044 4,518,312,311 607,616,958,665
8 9 Net B-C Gross Inv. 7-6 4-2 (126,000,000) (126,000,000) (1,615,250) (1,841,385) (1,555,185) (2,021,119) 24,972,667,250 36,998,105,328 35,597,704,879 60,123,105,328 43,236,029,457 83,247,281,603 46,355,085,978 101,748,144,703 47,456,190,604 118,748,144,703 44,958,548,393 128,248,144,703 43,819,311,338 142,498,144,703 41,000,325,776 151,997,281,603 41,525,910,628 175,498,144,703 38,449,938,641 185,248,144,703 35,503,192,886 194,998,144,703 31,143,151,654 194,998,144,703 28,018,915,576 199,997,281,603 23,349,185,678 189,998,144,703 19,403,744,884 179,998,144,703 16,075,217,497 169,998,144,703 15,262,345,075 183,998,144,703 11,714,439,571 160,997,281,603 8,807,879,604 137,998,144,703 6,438,491,170 114,998,144,703 4,518,221,194 91,998,144,703 607,477,327,298 3,004,202,645,099 PBP 368,918,603,868 #REF! 3,746,545,699 (127,615,250) 33,718,911,295 402,637,515,162 (1) (402,511,515,162)
10 PV. Inv B Operasional 126,000,000 -
126,000,000
372,665,149,567 #REF! (3,170,435)
252,000,000 0
-146,867,700,000
-176,674,050,000 -203,724,150,000 -222,940,439,818 -218,571,783,818 -190,618,182,000 -143,704,634,364 -79,331,140,909 -4,997,701,636 84,045,683,455 7,420,282,091 183,049,014,364 306,012,291,091 439,185,513,636 582,568,682,000 726,411,796,182 875,714,856,182 1,015,477,862,000 1,145,700,813,636 1,266,383,711,091
126,000,000
11 PV. Gr. B - C (126,000,000) (1,615,250) (1,555,185) 24,972,667,250 35,597,704,879 43,236,029,457 46,355,085,978 47,456,190,604 44,958,548,393 43,819,311,338 41,000,325,776 41,525,910,628 38,449,938,641 35,503,192,886 31,143,151,654 28,018,915,576 23,349,185,678 19,403,744,884 16,075,217,497 15,262,345,075 11,714,439,571 8,807,879,604 6,438,491,170 4,518,221,194 607,477,327,298
ROI IRR
12 B-C (126,000,000) 36,998,158,615 60,122,978,881 83,248,105,328 101,748,105,328 118,747,281,603 128,248,144,703 142,498,144,703 151,998,144,703 175,498,144,703 185,247,281,603 194,998,144,703 194,998,144,703 199,998,144,703 189,998,144,703 179,997,281,603 169,998,144,703 183,998,144,703 160,998,144,703 137,998,144,703 114,997,281,603 91,998,144,703 3,004,373,144,703 (1,855,298) 3,004,202,645,099
DF 36% 1 0.7353 0.5407 0.3975 0.2923 0.2149 0.1580 0.1162 0.0854 0.0628 0.0462 0.0340 0.0250 0.0184 0.0135
14 NPV 36% (126,000,000) 27,204,528,393 32,505,935,814 33,094,637,842 29,742,036,167 25,522,848,029 20,268,314,797 16,559,104,671 12,987,543,644 11,026,110,850 8,557,812,363 6,623,727,957 4,870,388,204 3,672,993,486 2,565,692,726
DF 35% 1.0000 0.7407 0.5487 0.4064 0.3011 0.2230 0.1652 0.1224 0.0906 0.0671 0.0497 0.0368 0.0273 0.0202 0.0150
235,075,674,943
400580243006.5830 317,920.8278 29425.9880 4,821.249
NPV 35% (126,000,000) 27,406,043,419 32,989,288,824 33,835,535,367 30,633,121,743 26,482,247,124 21,185,976,204 17,437,042,677 13,777,427,648 11,783,345,536 9,213,277,640 7,183,879,283 5,321,392,061 4,042,843,933 2,844,962,860
244,010,384,318 27.3104
1,214,954,654,596
470,151,349,886
21
27.31
488,020,768,637
DF= 1/T
1+i^n 1.0000 0.7353 0.5407 0.3975 0.2923 0.2149 0.1580 0.1162 0.0854 0.0628 0.0462 0.0340 0.0250 0.0184 0.0135
1.0000 1.3600 1.8496 2.5155 3.4210 4.6526 6.3275 8.6054 11.7034 15.9166 21.6466 29.4393 40.0375 54.4510 74.0534
14% DF14% 1.0000 1.1400 1.2996 1.4815 1.6890 1.9254 2.1950 2.5023 2.8526 3.2519 3.7072 4.2262 4.8179 5.4924 6.2613
1.0000 0.8772 0.7695 0.6750 0.5921 0.5194 0.4556 0.3996 0.3506 0.3075 0.2697 0.2366 0.2076 0.1821 0.1597
Tabel 15. Parameter Teknis Parameter teknis
Rp / Unit
Benih (Biji Kakao) 100 Polybag 350 Karung Goni 2,500 Pasir 12,500 BBM (Solar) 600 Pupuk Kandang 900 Bambu 1,500 Daun Pelepah Kelapa 200 Paku 4,000 Tali Plastik 4,000 Kawat Duri 7,200 Tiang Pagar 1,500 Kran Air 4,000 Pompa Air 4,400,000 Selang 2,500 Tower 1,500,000 Pipa Paralon 4,500 Pupuk (Kg) Urea 450 TSP 675 KCl 1,800 Obat-obatan Fungisida (Dithai 40,000 Herbisida (Grama 50,000 Insektisida (Decis 95,000 Kaptan 300 Taman Pelindung Bibit 800 Pemeliharaan 470 BBM 1,200 Pelumas 5,000 Oli Kotor 1,500 Biaya Panen (Rp/Kg) 15 Biaya Pengangkutan (R 15 Keterangan: merah = dinamis hitam = statis
Parameter teknis
Rp/Unit
Cangkul 14,500 Garpu 5,000 Batu Asah 2,500 Ember Plastik (10 lite 4,000 Parang 30,000 Gunting Pangkas 30,000 Kikir 3,125 Pisau Lapangan 65,000 Keranjang 27,500 San Saw 6,300,000 Kampak 7,500 Tali untuk Air 12,000 Tiang Perancang 1,800 Skop 27,000 Sprayer 135,000 Gelar Ukur 15,500 Gergaji Pangkas 50,000 Tikar ( 4 x 6 m ) 87,500 Gembor 12,500 Peng Hak Tanah 100,000 Pembangunan Jalan: a. Jalan Koleksi 12,500 b. Jalan Produk 30,000 Buruh (HOK) 4,500 Overhead 5.00% Harga jual Kakao keri 15,000 Luas lahan per petani 2 Luas lahan plasma (t 1,000 Jumlah petani plasm 500 Jaminan (Rp/ha) 200,000 Main Fee 5.00% Harga jual Kakao keri 15,000 Luas kebun plasma ( 1,000
