Nama : Bayu Moerdianto Wahid
NRP : 4106.100.038
Spesifikasi teknis
Jenis Kapal Self Unloader
Tenaga Tug Boat HP 4,800
Kapasitas
Muatan Batu Bara
DWT ton 8,000
Muatan Bersih ton 80,000
Kecepatan
Isi Knot 10.0
Kosong Knot 13.0
Konsumsi BBM MDF/HSD MFO
Layar Lt/hari 12,712 -
Labuh Lt/hari 2,800 -
Konsumsi Pelumas
Layar Lt/hari 125
Labuh Lt/hari 20
Investasi
Harga Kapal J Rp 93,750.0 ==> Pinjaman J Rp 70,312.5 75%
Bunga Pinjaman per thn 8%
Masa Pinjaman tahun 10
Grace Period tahun 0 ==>
Pembayaran per Tahun kali/thn 1
Angsuran per Tahun J Rp 13,971.5
Umur Ekonomis tahun 15
Nilai Akhir Kapal J Rp 0
Depresiasi J Rp 6,250.0
Operasional Rute Tarahan - Suralaya
Jarak pelayaran nMile 60
Comm. Days hari 330 35
Produktifitas
Muat (Tarahan) ton/jam 2,000
Bongkar (Suralaya) ton/jam 1,500
Sea Time
Isi hari 0.25
Kosong hari 0.19
Port Time
Muat hari 1.67
Bongkar hari 2.22
Tunggu B/M hari 0.30 toleransi
RTD hari 4.63
Jumlah Shipment per Thn Trip 72
Logistik Kapal
HSD (solar) Lt/Trip 17,352 MFO (Marine Fuel Oil = Minyak bakar) Lt/Trip - HEATER
Pelumas Lt/Trip 139
Tahun 2010 2011Tahun ke - 0 1
Operasi 100%
Asumsi BiayaKenaikan Biaya
Asumsi Biaya Operasional :Gaji Crew + Insentif J Rp 412.9 Perawatan J Rp 340.0 Asuransi J Rp 1.25% 656.6 Permakanan J Rp 83.3 Perlengkapan/S.Part J Rp 510.0 Dokumen/Sertifikat J Rp 30.0 Biaya alur J Rp - Biaya pemasaran J Rp - Air tawar J Rp 45.6 Pelabuhan J Rp 792.0
Asumsi Harga BBM & Pelumas :Kenaikan BBM
Bahan bakar HSD Rp/Lt 1,700 Bahan bakar MFO Rp/Lt -
Kenaikan Pelumas
Pelumas Rp/Lt 15,000
PendapatanJumlah Muatan per Tahun Ton 5,760,000
Asumsi Tarif Muatan :Kenaikan Tarif
Unit Tarif Rp/Ton 18,000
Total Pendapatan J Rp 103,680.0
BiayaPengembalian Pinjaman J Rp 13,971.5
Biaya Operasional Tetap J Rp 2,032.7 Gaji Crew + Insentif J Rp 412.9 Perawatan J Rp 340.0 Assuransi J Rp 656.6 Permakanan J Rp 83.3 Perlengkapan/S.Part J Rp 510.0 Dokumen/Sertifikat J Rp 30.0 Biaya alur J Rp - Biaya pemasaran J Rp -
Biaya Operasional Variabel J Rp 3,111.6 Bahan bakar J Rp 2,123.8 Pelumas J Rp 150.2 Air tawar J Rp 45.6 Pelabuhan J Rp 792.0
Operasi J Rp 2.50% 128.6
Mgt.cost/Overhead J Rp 2.50% 131.8
Total Biaya J Rp 19,376.3
Earning Before Tax J Rp 84,303.7 Taxable Income J Rp 78,053.7
Tax (30% Taxable Income) J Rp 23,416.1
Net-Cash Flows = Earning Aft. Tax J Rp (70,313) 60,888
Cum. Cash J Rp (70,313) (9,425)
Control BEP -
Investment Criteria Value Criteria
Present Worth ( PW atau NPV ) J Rp 652,353 Ok
Present Worth Index (NPVI) kali 927.8% Ok
IRR % 92.0% Ok
IRR Index ( IRRI = IRR / MARR ) kali 13.14 Ok
BEP from year - 2 Ok
Accum Cash on BEP J Rp 51,381 Ok
Annual Discount Rate %/thn 6.0%
MARR (Min Attrac. Rate of Rtn ) %/thn 7.0%
SensitifitasSensPengembalian Grace Period Bunga
ctrl + shift + n 0 8%
var. Grace Period (0-3)
SensTarif Tarif
ctrl + shift + b 6,070 20%
var. Kenaikan /3 thn (10%-22%)
SensBungaTarifPW0 Bunga Tarif
ctrl + shift + i 8% 6,070
var. Grace Period cell E115
Kenaikan /3 thn
10.0 Juta USD (Kurs = 9,375)
selama masa konstruksi
2012 2013 2014 2015 2016 2017 20182 3 4 5 6 7 8
100% 100% 100% 100% 100% 100% 100%
5% 5% 5% 5%
Asumsi Biaya Operasional : 433.5 433.5 455.2 455.2 477.9 477.9 501.8
357.0 357.0 374.9 374.9 393.6 393.6 413.3
656.6 656.6 656.6 656.6 656.6 656.6 656.6
87.4 87.4 91.8 91.8 96.4 96.4 101.2
535.5 535.5 562.3 562.3 590.4 590.4 619.9
31.5 31.5 33.1 33.1 34.7 34.7 36.5
- - - - - - -
- - - - - - -
47.9 47.9 50.3 50.3 52.8 52.8 55.5
831.6 831.6 873.2 873.2 916.8 916.8 962.7
Asumsi Harga BBM & Pelumas :10% 10%
1,700 1,870 1,870 1,870 2,057 2,057 2,057
- - - - - - -
10% 10% 15,000 16,500 16,500 16,500 18,150 18,150 18,150
5,760,000 5,760,000 5,760,000 5,760,000 5,760,000 5,760,000 5,760,000
Asumsi Tarif Muatan :20% -2%
18,000 21,600 21,600 21,600 21,168 21,168 21,168
103,680.0 124,416.0 124,416.0 124,416.0 121,927.7 121,927.7 121,927.7
13,971.5 13,971.5 13,971.5 13,971.5 13,971.5 13,971.5 13,971.5
2,101.5 2,101.5 2,173.8 2,173.8 2,249.6 2,249.6 2,329.3 433.5 433.5 455.2 455.2 477.9 477.9 501.8 357.0 357.0 374.9 374.9 393.6 393.6 413.3 656.6 656.6 656.6 656.6 656.6 656.6 656.6 87.4 87.4 91.8 91.8 96.4 96.4 101.2 535.5 535.5 562.3 562.3 590.4 590.4 619.9 31.5 31.5 33.1 33.1 34.7 34.7 36.5 - - - - - - - - - - - - - -
3,153.5 3,380.9 3,424.9 3,424.9 3,721.2 3,721.2 3,769.7 2,123.8 2,336.2 2,336.2 2,336.2 2,569.8 2,569.8 2,569.8 150.2 165.2 165.2 165.2 181.7 181.7 181.7 47.9 47.9 50.3 50.3 52.8 52.8 55.5 831.6 831.6 873.2 873.2 916.8 916.8 962.7
131.4 137.1 140.0 140.0 149.3 149.3 152.5
134.7 140.5 143.5 143.5 153.0 153.0 156.3
19,492.6 19,731.5 19,853.6 19,853.6 20,244.6 20,244.6 20,379.3
84,187.4 104,684.5 104,562.4 104,562.4 101,683.0 101,683.0 101,548.4 77,937.4 98,434.5 98,312.4 98,312.4 95,433.0 95,433.0 95,298.4
23,381.2 29,530.3 29,493.7 29,493.7 28,629.9 28,629.9 28,589.5
60,806 75,154 75,069 75,069 73,053 73,053 72,959
51,381 126,535 201,604 276,673 349,726 422,779 495,738
BEP - - - - - -
Min Remarks
0 Positive Incr. Wealth
0.0% Null
0.0% MARR
0 Null
1 Construction Period
0 Positive Accum Cash
PW Bunga Min Bunga Max Incremental
652,353 6% 20% 2%
PW Tarif Min Tarif Max Incremental
652,353 10,000 22,000 2,000
Bunga Min Bunga Max Incremental
0 6% 20% 2%
Grace Period
2019 2020 2021 2022 2023 2024 20259 10 11 12 13 14 15
100% 100% 100% 100% 100% 100% 100%
5% 5% 5%
Asumsi Biaya Operasional : 501.8 526.9 526.9 553.3 553.3 580.9 580.9
413.3 433.9 433.9 455.6 455.6 478.4 478.4
656.6 656.6 656.6 656.6 656.6 656.6 656.6
101.2 106.3 106.3 111.6 111.6 117.1 117.1
619.9 650.9 650.9 683.4 683.4 717.6 717.6
36.5 38.3 38.3 40.2 40.2 42.2 42.2
- - - - - - -
- - - - - - -
55.5 58.2 58.2 61.1 61.1 64.2 64.2
962.7 1,010.8 1,010.8 1,061.4 1,061.4 1,114.4 1,114.4
Asumsi Harga BBM & Pelumas :10% 10% 10%
2,263 2,263 2,263 2,489 2,489 2,489 2,738
- - - - - - -
10% 10% 10% 19,965 19,965 19,965 21,962 21,962 21,962 24,158
5,760,000 5,760,000 5,760,000 5,760,000 5,760,000 5,760,000 5,760,000
Asumsi Tarif Muatan :5% -4% 4%
22,226 22,226 22,226 21,337 21,337 21,337 22,191
128,024.1 128,024.1 128,024.1 122,903.1 122,903.1 122,903.1 127,819.2
13,971.5 13,971.5 - - - - -
2,329.3 2,412.9 2,412.9 2,500.7 2,500.7 2,592.9 2,592.9 501.8 526.9 526.9 553.3 553.3 580.9 580.9 413.3 433.9 433.9 455.6 455.6 478.4 478.4 656.6 656.6 656.6 656.6 656.6 656.6 656.6 101.2 106.3 106.3 111.6 111.6 117.1 117.1 619.9 650.9 650.9 683.4 683.4 717.6 717.6 36.5 38.3 38.3 40.2 40.2 42.2 42.2 - - - - - - - - - - - - - -
4,044.9 4,095.8 4,095.8 4,451.9 4,451.9 4,508.0 4,840.9 2,826.8 2,826.8 2,826.8 3,109.5 3,109.5 3,109.5 3,420.4 199.9 199.9 199.9 219.9 219.9 219.9 241.9 55.5 58.2 58.2 61.1 61.1 64.2 64.2 962.7 1,010.8 1,010.8 1,061.4 1,061.4 1,114.4 1,114.4
159.4 162.7 162.7 173.8 173.8 177.5 185.8
163.3 166.8 166.8 178.2 178.2 182.0 190.5
20,668.3 20,809.7 6,838.2 7,304.6 7,304.6 7,460.4 7,810.2
107,355.7 107,214.4 121,185.9 115,598.5 115,598.5 115,442.7 120,009.0 101,105.7 100,964.4 114,935.9 109,348.5 109,348.5 109,192.7 113,759.0
30,331.7 30,289.3 34,480.8 32,804.6 32,804.6 32,757.8 34,127.7
77,024 76,925 86,705 82,794 82,794 82,685 85,881
572,762 649,687 736,392 819,186 901,980 984,665 1,070,546
- - - - - - -
86,400,000
1,826,991.8
139,715.1
34,754.3
58,197.1
2,323.8
2,381.9
237,372.3