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