E2020 = E2014 x 1.013 koreksi = 1.

12

Harga satuan, Total Harga Total Harga

Kode Jumlah Nama Alat
USD (2014), USD (2020), USD
P-01 2 Pompa Metanol 4,900.00 9,800.00 10,976.00
P-02 2 Pompa Dowterm 4,900.00 9,800.00 10,976.00
P-03 2 Pompa Urea Formaldehid 4,900.00 9,800.00 10,976.00
P-04 2 Pompa Urea 4,900.00 9,800.00 10,976.00
P-05 2 Pompa Air 4,900.00 9,800.00 10,976.00
PU 7 Pompa Utilitas 4,900.00 34,300.00 38,416.00
B-01 2 Air Blower 23,300.00 46,600.00 52,192.00
F-01 2 Air Filter 86,500.00 173,000.00 193,760.00
V-01 1 Methanol Vaporizer 431,832.00 431,832.00 483,651.84
R-01 1 Reaktor 278,400.00 278,400.00 311,808.00
A-01 1 Absorber 13,500.00 13,500.00 15,120.00
WHB-01 1 WHB 224,400.00 224,400.00 251,328.00
CI-01 1 Catalytic Increator 595,800.00 595,800.00 667,296.00
M-01 1 Mixer Tank 42,000.00 42,000.00 47,040.00
Total Pembelian Alat dari Luar Negeri 2,115,491.84
Harga satuan, Total Harga Total Harga
Kode Jumlah Nama Alat
USD (2014), USD (2020), USD
T-01 1 Tangki Metanol 397,600.00 397,600.00 445,312.00
T-02 1 Tangki Dowterm 45,200.00 45,200.00 50,624.00
T-03 1 Tangki Urea 169,900.00 169,900.00 190,288.00
T-04 1 Tangki Urea Formaldehid 172,000.00 172,000.00 192,640.00
T-05 1 Tangki Air 105,800.00 105,800.00 118,496.00
HE-01 1 Methanol Heater 94,000.00 94,000.00 105,280.00
HE-02 1 Air Heater 94,000.00 94,000.00 105,280.00
HE-03 1 Cooler masuk Absorber 94,000.00 94,000.00 105,280.00
HE-04 1 Cooler Masuk Tangki Produk 94,000.00 94,000.00 105,280.00
Total Pembelian Alat dari Dalam Negeri 1,418,480.00
S-01 1 Gudang Urea 167500 167500 187600
1606080
 14355 rp/USD
PEC
Harga % EC Biaya, USD
Harga alat (Equipment Cost, EC) 100 2,115,491.84
Biaya pengangkutan sampai pelabuhan 15 317,323.78
Biaya pengangkutan sampai lokasi 15 317,323.78
Provisi Bank 0.5 10,577.46
EMKL 1 21,154.92
Asuransi Pengangkutan 1 21,154.92
Pajak Impor 20 423,098.37
Total PEC Impor 3,226,125.06

Harga % EC Biaya, USD

Harga alat (Equipment Cost, EC) 100 1,606,080.00
Biaya pengangkutan 15 240,912.00
Provisi Bank 0.2 3,212.16
EMKL 0.2 3,212.16
Asuransi Pengangkutan 0.5 8,030.40
Total PEC Lokal 1,861,446.72

Total PEC 5,087,571.78

1.1.1. Biaya Pemasangan Alat (Equipment Installation Cost)

material 559632.89536
buruh 1628022.96832
Total 2187655.86368

1.1.1. Biaya Pemipaan (Piping Cost)

material 2492910.17024
buruh 1882401.55712
Total 4375311.72736

1.1.1. Biaya Instrumentasi (Instrumentation Cost)

material 1221017.22624
buruh 305254.30656
Total 1526271.5328

jumlah manhour 5700.978006208 750000

TKA 2850.489003104
TKI 302403.8175569
TOTAL 1526271.5328

1.1.1. Biaya Insulasi (Insulation Cost)

 material 152627.15328
buruh 254378.5888
Total 407005.74208

1.1.1. Biaya Listrik (Electrical Cost)

material 457881.45984
buruh 305254.30656
Total 763135.7664

1.1.1. Biaya Bangunan

Perkiraan luas bangunan 5100 m2
Perkiraan harga bangunan 5000000 rp/m2
Harga bangunan total 25500000000 rp
1776384.535005
1.1.1. Biaya Tanah
Perkiraan luas tanah 24000 m2
Harga tanah per meter 4,000,000 rp/m2
Harga tanah total 96000000000 rp
6687565.308255
1.1.1. Biaya Utilitas 2035028.7104

1.1.1. Biaya Perawatan Lingkungan (Environmental Cost)

1017514.3552 >AWALNYA 0,1
No Physical Plant Cost USD
1 Purchased Equipment Cost 5,087,571.78
2 Instalasi Alat 2,187,655.86
3 Pemipaan 4,375,311.73
4 Instrumentasi 1,526,271.53
5 Insulasi 407,005.74
6 Listrik 763,135.77
7 Bangunan 1,776,384.54
8 Tanah 6,687,565.31
9 Utilitas 2,035,028.71
10 Environment 1,017,514.36
Total Physical Cost 25,863,445.32

1.1.1. Engineering and Construction (ECC) 5172689.06343604

DPC 31,036,134.38
1.1.1. Contractor’s Fee 1551806.71903081
1.1.1. Contingency 7759033.59515406
Fixed Capital Invesment 40,346,974.69
rp 50 USD
1.1.1. Raw Material Inventory
metanol
dipersiapkan untuk 14 hari
harga metanol per kg
biaya metanol

katalis
Dipersiapkan untuk 1 thn
Harga katalis per kg
Biaya katalis
Total raw material inventory

1.1.1. In Process Inventory

waktu operasi 1 jam
1 HARI 24 JAM
1 TAHUN 330 HARI
MANUFACTURING COST 24,892,107.39 USD
biaya dalam operasi 1571.4714259081 USD/TAHUN

1.1.1. Product Inventory

MANUFACTURING COST 24,892,107.39 USD
PRODUCT INVENTORY 2262918.85330766 USD

1.1.1. Extended Credit 4525837.70661532 USD

1.1.1. Available Cash 2262918.85330766 USD

No Working Capital Investment Biaya, USD

1 Raw Material Inventory 1,006,973.58
2 In Process Inventory 1571.471425908
3 Product Inventory 2,262,918.85
4 Extended Credit 4,525,837.71
5 Available Cash 2,262,918.85
Total 10,060,220.47
TOTAL WCI 10,060,220.47 USD

1.1.1. Plant Start Up

FCI 40,346,974.69 USD
Start up 4034697.46948011 USD

1.1.1. Pajak Pembangunan (Interest During Construction / IDC)

FCI 40,346,974.69 USD
IDC 4034697.46948011 USD

Total Capital Invesment

No Total Capital Investment USD
1 Fixed Capital Invesment (FCI) 40,346,974.69
2 Working Capital InvesmentI (WCI) 10,060,220.47
3 Plant Start Up 4,034,697.47
4 Interest During Construction (IDC) 4,034,697.47
Total 58,476,590.10
TOTAL TCI 58,476,590.10 USD
 5585.11 kg/jam 1876597 kg/minggu 44,234,071.20 kg/tahum Urea
0.23 USD/kg price
431617.3008 USD per minggu
10173836.376 USD per tahun

1866.406 kg
23.99 USD/kg
44775.07994 USD
1006973.58048 USD

>awalnya 1/12

>AWALNYA DPHARUSE FCI

>AWLANYA DPC

syarat pabrik berdiri

WCI/TCI kurang dari 15% atau sama dengan 15%
0.1720384251 17.203843 %
6586.038 2212908.768 kg 52161420.96
0.26 575356.2797 USD/ming 13561969.4496 USD/thn
 2.1.1. Bahan baku
Kapasitas
durasi operasi 1 tahun
pendirian pabrik
kebutuhan bahan baku dan katalis untuk satu tahun :
metanol
Urea
katalis
biaya metanol
biaya Urea
biaya katalis
Total biaya

2.1.1. Biaya Pekerja

Jabatan Jumlah
Karyawan Prose 60
Karyawan Labor 12
Karyawan HSE 16
Karyawan Utilit 64
Karyawan Renda 12
Karyawan Meka 5
Karyawan Listrik 5
Total (Rp) 174
Total (USD)
labor cost 1,340,647.86

2.1.1. Supervisi
Jabatan Jumlah
Manajer Operasi 1
Manajer Labora 1
Manajer Utilitas 1
Manajer Pemelih 1
Manajer Pengem 1
Manager HSE 1
Manager
1
Pengadaan
 Kepala Bagian
Perencanaan
dan 1
Pengendalian
Produksi
Kepala Bagian
1
Teknik
Total (Rp)
Total (USD)
Supervisi Cost
122,780

2.1.1. Maintenance
maintenance cost

2.1.1. Plant Supplies

2.1.1. Royalties and Patent

2.1.1. Biaya Utilit

Direct
No Manufacturin Total (USD)
g Cost
Raw Material
1 13,561,969.45
Cost
2 Labor Cost 1,340,647.86
3 Supervisi Cost 122,780
4 Maintenance 2017348.73474006
5 Plant Supplies 302602.310211008

Royalties and
6 450000
Patent
7 Utilitas 1939758.39878852
Total DMC 19,735,106.27
TOTAL DMC 19,735,106.27
 45000 ton/tahun
330 hari
2020

44,234,071.20 kg/tahum
52161420.96 kg/thn
1866.406 kg
10173836.376 USD/thn
13561969.4496 USD/thn
44775.07994 USD/thn
23780580.90554

14000
Gaji/bulan (Rp) Gaji/tahun per karyawan (RP) Gaji/ tahun (Rp)
7,500,000.00 112,500,000.00 6750000000
7,500,000.00 112,500,000.00 1350000000
7,500,000.00 112,500,000.00 1800000000
7,500,000.00 112,500,000.00 7200000000
6,500,000.00 97,500,000.00 1170000000
6,500,000.00 97,500,000.00 487500000
6,500,000.00 97,500,000.00 487500000
49,500,000.00 742,500,000.00 19245000000
3,448.28 51,724.14 1340647.85788924

Gaji/bulan (Rp) Gaji/tahun (Rp)

12,500,000 187,500,000
12,500,000 187,500,000
12,500,000 187,500,000
12,500,000 187,500,000
12,500,000 187,500,000
12,500,000 187,500,000
12,500,000 187,500,000
 15,000,000.00 225,000,000

15,000,000.00 225,000,000
117,500,000 1,762,500,000
8,185 122,780

2.1.1. Maintenance Cost

2017348.73474006 USD >AWALNYA 2 PERSEN JADI 5 PERSEN

2.1.1. Plant Supplies Cost 302602.310211008 USD

es and Patent >AWALNYA GAADA

450000
2.1.1. Biaya Utilitas 1939758.39878852 USD
Rupiah = 1 USD

>AWALNYA 1
14000
SEN JADI 5 PERSEN
LABOR 1,340,647.86
SUPERVISION 122,780

2.1.1. Payroll Overhead 219514.11

2.1.1. Biaya Laboratorium (Laboratory Cost) 146342.74
2.1.1. Plant Overhead 731713.69
Packaging and Shipping Cost 1800000

No Indirect Manufacturing Cost Biaya, USD

1 Payroll 219,514.11
2 Laboratorium 146,342.74
3 Plant overhead 731,713.69
4 Packaging dan Shipping 1,800,000.00
Total 2,897,570.53

TOTAL IMC 2,897,570.53 USD

FCI 40,346,974.69 USD

2.1.1. Depresiasi 4034697.46948 USD

n= 25
Depresiasi tiap tahun 1452491.089013 USD

2.1.1. Property Taxes 403469.746948 USD

2.1.1. Asuransi 403469.746948 USD

No Fixed Manufacturing Cost Biaya, USD

1 Depresiasi 1,452,491.09
2 Property Taxes 403,469.75
3 Asuransi 403,469.75
Total 2,259,430.58
TOTAL FMC= 2,259,430.58 USD

No Manufacturing Cost Biaya, USD

1 Direct Manufacturing Cost 19,735,106.27
2 Indirect Manufacturing Cost 2,897,570.53
3 Fixed Manufacturing Cost 2,259,430.58
Total Manufacturing Cost 24,892,107.39
TOTAL MANUFACTURING COST 24,892,107.39 USD
 3.1. Administration
3.1.1. Management Salaries
No Jabatan Jumlah
1 Direktur Utama 1
2 Direktur Produksi 1
3 Direktur Keuangan 1
4 Dewan Komisaris 3
5 Staf Ahli 2
8 Staf Audit 2
9 Kepala Bagian Keuangan 1
12 Sekretaris 8
13 Kepala Seksi 7
14 Ketua Regu 20
15 Kepala Bagian Pemasaran 1
16 Kepala Bagian SDM 1
17 Karyawan Pemasaran 6
18 Dokter 2
19 Karyawan Keuangan 10
20 Karyawan SDM 9
21 Pesuruh 8
22 Karyawan Keamanan dan Sopir 16
23 Perawat 4
24 Karyawan Kebersihan 8
Total (Rp) 111
Total (USD)
TOTAL GAJI PER TAHUN 13,620,000,000.00
948,798

3.1.1. Legal and Auditing Fee

 Labor 1,340,647.86
Supervision 122,780
maintenance cost 2017348.73474006
L&A Fee 104423.283358816

3.1.1. Peralatan Kantor

Anggaran utk perlatan kantor 70000000
No Administrasi Total (USD)
1 Management Salaries 948,798.33
2 Legal Fee's and Auditing 104,423.28
3 Peralatan Kantor dan Komunikasi 4,876.35
Total 1,058,097.96
TOTAL ADMINISTRATION COST 1,058,097.96

3.1. Sales Expense

HARGA PENJUALAN 45000000
SALES EXPENSES 3150000

3.1. Research and Development Cost

MANUFACTURING COST 24,892,107.39
RnD 995684.295455371

TOTAL GENERAL EXPENSES(GE)

No General Expense Total (USD)

1 Administrasi 1,058,097.96
2 Sales Expense 3,150,000.00
3 Research and Development 995,684.30
Total 5,203,782.26
TOTAL G 5,203,782.26 USD

TOTAL PRODUCTION COST

No Production Cost Total (USD)
1 Manufacturing Cost 24,892,107.39
2 General Expense 5,203,782.26
Total 30,095,889.64
TOTAL PC 30,095,889.64 USD
300.9588964301 USD/TON.THN
 Gaji/bulan (Rp) Gaji/tahun per karyawan (Rp) Gaji/tahun (Rp)
40,000,000.00 600,000,000.00 600000000
35,000,000.00 525,000,000.00 525000000
35,000,000.00 525,000,000.00 525000000
38,000,000.00 570,000,000.00 1710000000
20,000,000.00 300,000,000.00 600000000
20,000,000.00 300,000,000.00 600000000
15,000,000.00 225,000,000.00 225000000
5,000,000.00 75,000,000.00 600000000
12,500,000.00 187,500,000.00 1312500000
8,000,000.00 120,000,000.00 2400000000
15,000,000.00 225,000,000.00 225000000
15,000,000.00 225,000,000.00 225000000
6,500,000.00 97,500,000.00 585000000
6,500,000.00 97,500,000.00 195000000
6,500,000.00 97,500,000.00 975000000
6,500,000.00 97,500,000.00 877500000
2,000,000.00 30,000,000.00 240000000
3,000,000.00 45,000,000.00 720000000
4,000,000.00 60,000,000.00 240000000
2,000,000.00 30,000,000.00 240000000
295,500,000.00 4,432,500,000.00 13,620,000,000.00
20,585 308,777 948,798
RUPIAH
USD
USD
USD
USD
USD

rupiah 4876.3497039359 USD

USD

USD/TAHUN
USD

USD
USD
 Produk Utama = Urea Formaldehid
Produksi 100,000 ton/tahun
Harga 450 USD/ton
penjualan per tahun (SALES) 45000000 USD
biaya produksi 30,095,889.64 USD
depresiasi 1452491.089013 USD
Keuntungan = Penjualan - biaya produksi - depresiasi
keuntungan sebelum pajak 13,451,619.27 USD
total pajak (25%PBT) 3362904.816994 USD
keuntungan sesudah pajak 10,088,714.45 USD
Persen Profit on sales (POS) = x 100%

POS Sebelum pajak= 29.8924872622 %

POS Setelah pajak= 22.4193654466 %
 4.1. Return on Invesment (ROI)
ROI =

FCI = 40,346,974.69 USD

WCI 10,060,220.47 USD
Plant start up 4,034,697.47 USD
MASA PEMBANGUNAN 2
IDC 2017348.73474006 USD/tahun
TCI 58,476,590.10 USD
Depresiasi 1,452,491.09 USD

loan(bunga pinjaman 6 %) =TCI(A/P,6%,6) > kok n nya 6 tahun kenapa ya? Inya 6 % darimana?
Dari tabel interest (A/P,6%,6) = 0.2034 0.1434
loan 11894138.4261158
472.5

Tahun Annual Sales (ton) Selling Price ($/ton) Total Operating Expenses ($/ton)

-2 - - -
-1 - - -
0 - - -
1 80,000 450 300.96
2 90,000 450 300.96
3 90,000 470 305.96
4 100,000 470 305.96
5 100,000 490 310.96
6 100,000 490 310.96
7 100,000 490 310.96
8 100,000 510 315.96
9 100,000 510 315.96
10 100,000 510 315.96
11 100,000 530 320.96
12 100,000 530 320.96
13 100,000 530 320.96
14 100,000 530 320.96
15 100,000 550 325.96
16 100,000 550 325.96
17 100,000 550 325.96
18 100,000 550 325.96
19 100,000 550 325.96
20 100,000 570 330.96
21 100,000 570 330.96
22 100,000 570 330.96
23 100,000 570 330.96
24 100,000 570 330.96
25 100,000 570 330.96

98400

1587849.07
793924.535

ROI
TCI 58,476,590.10 USD
KEUNNTUNGAN SEBELUM PAJAK 13,451,619.27
KEUTUNGA SETELAH PAJAK 10,088,714.45
ROI SEBELUM PAJAK 33.3398460968 %
ROI SETELAH PAJAK 25.0048845726 %
OI)
x 100%

TAHUN > KITA JUGA 2 TAHUN???

napa ya? Inya 6 % darimana?

>A/F

biaya operasi cash revenue R-C

Total Biaya ($) Sales ($) Depresiasi ($) Income ($)

- - - -
- - - -
- - - -
24,076,711.71 36,000,000.00 1,452,491.09 11,923,288.29
27,086,300.68 40,500,000.00 1,452,491.09 13,413,699.32
27,536,300.68 42,300,000.00 1,452,491.09 14,763,699.32
30,595,889.64 47,000,000.00 1,452,491.09 16,404,110.36
31,095,889.64 49,000,000.00 1,452,491.09 17,904,110.36
31,095,889.64 49,000,000.00 1,452,491.09 17,904,110.36
31,095,889.64 49,000,000.00 1,452,491.09 17,904,110.36
31,595,889.64 51,000,000.00 1,452,491.09 19,404,110.36
31,595,889.64 51,000,000.00 1,452,491.09 19,404,110.36
31,595,889.64 51,000,000.00 1,452,491.09 19,404,110.36
32,095,889.64 53,000,000.00 1,452,491.09 20,904,110.36
32,095,889.64 53,000,000.00 1,452,491.09 20,904,110.36
32,095,889.64 53,000,000.00 1,452,491.09 20,904,110.36
32,095,889.64 53,000,000.00 1,452,491.09 20,904,110.36
32,595,889.64 55,000,000.00 1,452,491.09 22,404,110.36
32,595,889.64 55,000,000.00 1,452,491.09 22,404,110.36
32,595,889.64 55,000,000.00 1,452,491.09 22,404,110.36
32,595,889.64 55,000,000.00 1,452,491.09 22,404,110.36
32,595,889.64 55,000,000.00 1,452,491.09 22,404,110.36
33,095,889.64 57,000,000.00 1,452,491.09 23,904,110.36
33,095,889.64 57,000,000.00 1,452,491.09 23,904,110.36
33,095,889.64 57,000,000.00 1,452,491.09 23,904,110.36
33,095,889.64 57,000,000.00 1,452,491.09 23,904,110.36
33,095,889.64 57,000,000.00 1,452,491.09 23,904,110.36
33,095,889.64 57,000,000.00 1,452,491.09 23,904,110.36

rata-rata gross profit =

 17,318,072.96 8659036.48
4,713,133.80 6,300,982.87
1,587,849.07 793924.535

-41557383.9356452
TAX=10% 5
R-C-D T%*(R-C-D) (1-T)*(R-C-D) PAT+D
Profit Before Taxes ($) Taxes ($) Profit After Taxes ($) Cashflow Before Loan ($)

- - - -20,173,487.35
- - - -20,173,487.35
- - - -14,094,917.93
10,470,797.20 1,047,079.72 9,423,717.48 10,876,208.57
11,961,208.23 1,196,120.82 10,765,087.41 12,217,578.50
13,311,208.23 1,331,120.82 11,980,087.41 13,432,578.50
14,951,619.27 1,495,161.93 13,456,457.34 14,908,948.43
16,451,619.27 1,645,161.93 14,806,457.34 16,258,948.43
16,451,619.27 1,645,161.93 14,806,457.34 16,258,948.43
16,451,619.27 1,645,161.93 14,806,457.34 16,258,948.43
17,951,619.27 1,795,161.93 16,156,457.34 17,608,948.43
17,951,619.27 1,795,161.93 16,156,457.34 17,608,948.43
17,951,619.27 1,795,161.93 16,156,457.34 17,608,948.43
19,451,619.27 1,945,161.93 17,506,457.34 18,958,948.43
19,451,619.27 1,945,161.93 17,506,457.34 18,958,948.43
19,451,619.27 1,945,161.93 17,506,457.34 18,958,948.43
19,451,619.27 1,945,161.93 17,506,457.34 18,958,948.43
20,951,619.27 2,095,161.93 18,856,457.34 20,308,948.43
20,951,619.27 2,095,161.93 18,856,457.34 20,308,948.43
20,951,619.27 2,095,161.93 18,856,457.34 20,308,948.43
20,951,619.27 2,095,161.93 18,856,457.34 20,308,948.43
20,951,619.27 2,095,161.93 18,856,457.34 20,308,948.43
22,451,619.27 2,245,161.93 20,206,457.34 21,658,948.43
22,451,619.27 2,245,161.93 20,206,457.34 21,658,948.43
22,451,619.27 2,245,161.93 20,206,457.34 21,658,948.43
22,451,619.27 2,245,161.93 20,206,457.34 21,658,948.43
22,451,619.27 2,245,161.93 20,206,457.34 21,658,948.43
 22,451,619.27 2,245,161.93 20,206,457.34 21,658,948.43
471,178,837.56 424,060,953.80 460,373,231.03
18,847,153.50 rata-rata net profit = 16,962,438.15 18,414,929.24

0.314911133 31.4911132983
 A/P
1 1.06 61985185.504832
2 0.5454 31893132.239939
3 0.3741 21876092.355998
4 0.2886 16876343.902542
5 0.2374 13882342.489478
6 0.2034 11894138.426116

-4034697.4695
10 i= 0.1156739 > trial
i= 11.56739 %
Loan or Interest Cummulative
(1+i)^n PW
($) Cashflow ($)
-20,173,487.35 0.803388209 -25,110,509.63
-2,017,348.73 -42,364,323.43 0.896319256 -47,264,769.94
-2,017,348.73 -58,476,590.10 1 -58,476,590.10
-11,894,138.43 -59,494,519.96 1.1156739 -53,326,083.87
-11,894,138.43 -59,171,079.89 1.244728251 -47,537,347.88
-11,894,138.43 -57,632,639.82 1.388710822 -41,500,821.40
-11,894,138.43 -54,617,829.81 1.549348419 -35,252,128.66
-11,894,138.43 -50,253,019.81 1.728567593 -29,072,059.43
-11,894,138.43 -45,888,209.80 1.928517748 -23,794,548.87
0 -29,629,261.37 2.151596917 -13,770,823.49
0 -12,020,312.94 2.400480524 -5,007,461.14
0 5,588,635.49 2.678153468 2,086,749.53 >POT
0 23,197,583.92 2.987945925 7,763,722.81
0 42,156,532.35 3.333573283 12,646,049.38
0 61,115,480.78 3.719180705 16,432,511.79
0 80,074,429.21 4.149392842 19,297,866.52
0 99,033,377.64 4.629369295 21,392,412.51
0 119,342,326.07 5.164866496 23,106,565.52
0 139,651,274.50 5.762306746 24,235,307.26
0 159,960,222.93 6.428855241 24,881,602.86
0 180,269,171.36 7.172505999 25,133,359.44
0 200,578,119.79 8.002177741 25,065,441.72
0 222,237,068.22 8.927820848 24,892,644.24
0 243,896,016.65 9.960536704 24,486,232.41
0 265,554,965.08 11.11271083 23,896,506.36
0 287,213,913.51 12.39816143 23,165,847.22
0 308,872,861.94 13.83230512 22,329,818.44
16,747,785.77 347,279,596.14 15.4323418 22,503,363.44
NPW -36,797,142.96
 11,006,394.85 550.3197425 15500000
15500000 8027200
Tahun Annual Sales (ton) Selling Price ($/ton) Total Operating Expenses ($/ton) Total Biaya ($)

-2 - - - -
-1 - - - -
0 - - - -
1 1 20,000.00 775 401.36
2 2 30,000.00 775 401.36
3 3 30,000.00 785 410.36
4 4 35,000.00 785 410.36
5 5 40,000.00 795 420.36
6 6 40,000.00 795 420.36
7 7 40,000.00 795 420.36
8 8 40,000.00 819 429.36
9 9 40,000.00 819 429.36
10 10 40,000.00 819 429.36
11 11 40,000.00 823 434.36
12 12 40,000.00 823 434.36
13 13 40,000.00 823 434.36
14 14 40,000.00 823 434.36
15 15 40,000.00 828 436.36
16 16 40,000.00 828 436.36
17 17 40,000.00 828 436.36
18 18 40,000.00 828 436.36
19 19 40,000.00 828 436.36
20 20 40,000.00 832 438.36
21 21 40,000.00 832 438.36
22 22 40,000.00 832 438.36
23 23 40,000.00 832 438.36
24 24 40,000.00 832 438.36
25 25 40,000.00 832 438.36
 7,472,751.06
12040800 23250000 7,472,800.00 8,026,847.58
Sales ($) Depresiasi ($) Income ($) Profit Before Taxes ($)

- - - -
- - - -
- - - -
8,027,248.94 15,500,000.00 743,113.37 7,472,751.06
12,040,873.41 23,250,000.00 743,113.37 11,209,126.59
12,310,873.41 23,550,000.00 743,113.37 11,239,126.59
14,362,685.65 27,475,000.00 743,113.37 13,112,314.35
16,814,497.88 31,800,000.00 743,113.37 14,985,502.12
16,814,497.88 31,800,000.00 743,113.37 14,985,502.12
16,814,497.88 31,800,000.00 743,113.37 14,985,502.12
17,174,497.88 32,760,000.00 743,113.37 15,585,502.12
17,174,497.88 32,760,000.00 743,113.37 15,585,502.12
17,174,497.88 32,760,000.00 743,113.37 15,585,502.12
17,374,497.88 32,920,000.00 743,113.37 15,545,502.12
17,374,497.88 32,920,000.00 743,113.37 15,545,502.12
17,374,497.88 32,920,000.00 743,113.37 15,545,502.12
17,374,497.88 32,920,000.00 743,113.37 15,545,502.12
17,454,497.88 33,120,000.00 743,113.37 15,665,502.12
17,454,497.88 33,120,000.00 743,113.37 15,665,502.12
17,454,497.88 33,120,000.00 743,113.37 15,665,502.12
17,454,497.88 33,120,000.00 743,113.37 15,665,502.12
17,454,497.88 33,120,000.00 743,113.37 15,665,502.12
17,534,497.88 33,280,000.00 743,113.37 15,745,502.12
17,534,497.88 33,280,000.00 743,113.37 15,745,502.12
17,534,497.88 33,280,000.00 743,113.37 15,745,502.12
17,534,497.88 33,280,000.00 743,113.37 15,745,502.12
17,534,497.88 33,280,000.00 743,113.37 15,745,502.12
17,534,497.88 33,280,000.00 743,113.37 15,745,502.12
 6,729,637.69 6,850,598.46 1,587,849.07
672963.769 6,056,673.92 6,799,787.29 5,812,656.41
Cashflow Before
Profit Before Taxes ($) Taxes ($) Profit After Taxes ($) Loan or Interest ($)
Loan ($)
- - - -10,321,018.96
- - - -10,321,018.96 793,924.54
- - - -6,300,982.87 793,924.54
6,729,637.69 672,963.77 6,056,673.92 6,799,787.29 5,803,178.93
10,466,013.22 1,046,601.32 9,419,411.90 10,162,525.26 5,803,178.93
10,496,013.22 1,049,601.32 9,446,411.90 10,189,525.26 5,803,178.93
12,369,200.99 1,236,920.10 11,132,280.89 11,875,394.25 5,803,178.93
14,242,388.75 1,424,238.88 12,818,149.88 13,561,263.24 5,803,178.93
14,242,388.75 1,424,238.88 12,818,149.88 13,561,263.24 5,803,178.93
14,242,388.75 1,424,238.88 12,818,149.88 13,561,263.24
14,842,388.75 1,484,238.88 13,358,149.88 14,101,263.24
14,842,388.75 1,484,238.88 13,358,149.88 14,101,263.24
14,842,388.75 1,484,238.88 13,358,149.88 14,101,263.24
14,802,388.75 1,480,238.88 13,322,149.88 14,065,263.24
14,802,388.75 1,480,238.88 13,322,149.88 14,065,263.24
14,802,388.75 1,480,238.88 13,322,149.88 14,065,263.24
14,802,388.75 1,480,238.88 13,322,149.88 14,065,263.24
14,922,388.75 1,492,238.88 13,430,149.88 14,173,263.24
14,922,388.75 1,492,238.88 13,430,149.88 14,173,263.24
14,922,388.75 1,492,238.88 13,430,149.88 14,173,263.24
14,922,388.75 1,492,238.88 13,430,149.88 14,173,263.24
14,922,388.75 1,492,238.88 13,430,149.88 14,173,263.24
15,002,388.75 1,500,238.88 13,502,149.88 14,245,263.24
15,002,388.75 1,500,238.88 13,502,149.88 14,245,263.24
15,002,388.75 1,500,238.88 13,502,149.88 14,245,263.24
15,002,388.75 1,500,238.88 13,502,149.88 14,245,263.24
15,002,388.75 1,500,238.88 13,502,149.88 14,245,263.24
15,002,388.75 1,500,238.88 13,502,149.88 14,245,263.24
351,151,028.87 316,035,926.09
14046041.1548 12641437.0436
 793924.535 -21,435,962.46
-28,530,869.87 28,530,869.86 5803178.929524
Cummulative
(1+i)^n PW 0.2004633327
Cashflow ($) -27,534,261.50
-10,321,018.96 0.7112 -14,512,882.91 0.69 -14873746.4753305
-21,435,962.45 0.8433 -25,419,004.94 0.83 -25733086.9222272 1.6673790407
-28,530,869.86 1 -28,530,869.86 1.00 -28530869.86
-27,534,261.50 1.1858 -23,219,767.93 1.20 -22936361.9446942
-23,174,915.17 1.4061 -16,481,131.99 1.44 -16081270.3956383
-18,788,568.83 1.6674 -11,268,004.89 1.73 -10860429.5311469
-12,716,353.51 1.9773 -6,431,323.59 2.08 -6123038.5699555
-4,958,269.20 2.3446 -2,114,717.28 2.49 -1988774.78654834
2,799,815.11 2.7803 1,007,015.15 2.99 935483.122817463
16,361,078.35 3.2969 4,962,528.56 3.59 4553754.66086272
30,462,341.59 3.9095 7,791,818.38 4.31 7062721.62116678
44,563,604.83 4.636 9,612,587.23 5.18 8606770.44888872
58,664,868.07 5.4974 10,671,427.55 6.22 9438198.44728274
72,730,131.31 6.5189 11,156,892.17 7.46 9747123.71845561
86,795,394.55 7.7301 11,228,196.07 8.96 9689690.13782842
100,860,657.80 9.1665 11,003,213.62 10.75 9379638.58113882
114,925,921.04 10.8697 10,573,047.50 12.91 8902939.0808047
129,099,184.28 12.8894 10,015,903.48 15.50 8330863.28580669
143,272,447.52 15.2844 9,373,758.38 18.60 7701588.13905707
157,445,710.76 18.1244 8,686,930.58 22.33 7050169.27233892
171,618,974.00 21.4922 7,985,190.11 26.81 6401549.5658607
185,792,237.24 25.4856 7,290,074.48 32.18 5772959.0411256
200,037,500.48 30.2212 6,619,120.12 38.63 5177658.84850419
214,282,763.72 35.8366 5,979,440.17 46.38 4620195.49331975
228,528,026.96 42.4954 5,377,707.76 55.68 4104532.35824925
242,773,290.20 50.3916 4,817,736.84 66.84 3632254.06516641
257,018,553.45 59.7549 4,301,214.36 80.24 3203250.40642414
271,263,816.69 70.858 3,828,273.19 96.32 2816238.19045421
NPW 0 1.20061449707E-05

24,304,372.31
FMC 2,259,430.58
Va
raw material cost 13,561,969.45 6,642,424.66
packanging &shipping 1,800,000.00 1,240,000.00
utilitas 1939758.398789 992,405.67
Va 17,301,727.85 8,874,830.33
Ra
labor 1,340,647.86 1,060,714.29
payroll overhead 219,514.11 187,232.14
supervision 122,780 187,500.00
laboratorium 146,342.74 124,821.43
general expense 5,203,782.26 3,364,571.56
maintenance 2017348.73474 412,840.76
plant supplies 302602.310211 61,926.11
plant overhead 731,713.69 624,107.14
Ra 10,084,731.21 6,023,713.43

sales 45000000

BEP = 25.6061830089 %
SDP= 14.658777957 %

4.1. Discounted cash flow

FCI 40,346,974.69
WCI 10,060,220.47
SV 4034697.4694801
DEPRESIASI 1,452,491.09
UMUR PABRIK (n)= 25
dari hasil trial i= 11.56739 %
Ra
Fa
 50000000
45000000
40000000
35000000
Nilai (USD per tahun)

30000000
25000000 s al es
Va
20000000 Ra
15000000 Fa +0,3Ra
10000000 Fa

5000000
0
0 10 20 30 40 50 60 70 80 90 100
Kapasitas Produksi (%)

%produksi sales Va Ra Sales +Fa

0 0 2,259,430.58 5284849.94642297 8,310,269.31
 100 45,000,000 19,561,158.43 29,645,889.64 31,905,320.23

10,084,731.21
2,259,430.58
 s al es
Va
Ra
Fa +0,3Ra
Fa

0 90 100

Fa
2,259,430.58
2,259,430.58
ARIES NEWTON HALAMAN 195

before 2.3073455
after 2.8567442
9.6
Pb 18,847,153.50
ra 98400
If 40,346,974.69

D= 2.175550481E-05 0.0005439
tahun index
2009 521.9
2010 550.8
2011 585.7
2012 584.6
2013 579.5 640
2014 591.7
620
2015 603.9 f(x) = 11.155952381x - 21872.0916666
600 R² = 0.8320926039
2016 616
580

index
560
540
520
500
480
460
2008 2009 2010 2011 2012 20
tahun
 663.12
f(x) = 11.155952381x - 21872.0916666655 1.1207031
R² = 0.8320926039

09 2010 2011 2012 2013 2014 2015 2016 2017

tahun