CONTOH PROGRAM

MENU SIMULASI TOLBerikut ini merupakan tombol yang disediakan pada program ini dan dibagi menjadi 3 bagian, yaitu pada tombol Konstruksi, Operasi dan Laporan. Simulasi dapat di input pada cell berwarna kuning dengan tulisan (font) merah. Asumsi adalah cell berwarna kuning dengan tulisan (font) merah.

KONSTRUKSI

OPERASI

LAPORAN

KATEGORI KONSTRUKSIKonstruksi yang merupakan kategori asumsi perencanaan pembangunan TOL ( Investasi, Network Diagram, Jalur Kritis, Bar

Chart, Alokasi Dana Pembangunan, Skedul Penarikan Dana (%), Skedul Penarikan Dana (Rp) & Biaya Operasi ).

Back to Menu

BiayaBanyaknya Waktu Biaya/Unit Biaya Setelah Mark-up

Unit (Bulan) (Rp) (Rp) (Rp)1 Pembebasan Lahan A 1 6 500,000,000,000 500,000,000,000 550,000,000,0002 Cut & Fill B M 1 6 250,000,000,000 250,000,000,000 275,000,000,0003 Pemadatan Tanah C B 1 8 150,000,000,000 150,000,000,000 165,000,000,0004 Pembangunan Jembatan D C 5 8 35,000,000,000 175,000,000,000 192,500,000,0005 Pembangunan Fly over E C 4 10 25,000,000,000 100,000,000,000 110,000,000,0006 Pengecoran F C 1 8 400,000,000,000 400,000,000,000 440,000,000,0007 Pengaspalan G C, D, E, F 1 18 250,000,000,000 250,000,000,000 275,000,000,0008 Pemagaran H G 1 4 20,000,000,000 20,000,000,000 22,000,000,0009 Marka jalan dan rambu-rambu lalu lintas I G 1 3 10,000,000,000 10,000,000,000 11,000,000,00010 Pintu Tol J H 20 1 250,000,000 5,000,000,000 5,500,000,00011 Pemasangan Lampu K J 1 2 20,000,000,000 20,000,000,000 22,000,000,00012 Kendaraan Proyek L A 2 1 500,000,000 1,000,000,000 1,100,000,00013 Bangunan Kantor M L 1 3 2,000,000,000 2,000,000,000 2,200,000,00014 Furniture & Peralatan Kantor N M 1 1 1,000,000,000 1,000,000,000 1,100,000,00015 Kendaraan Operasi O J, N 5 1 1,000,000,000 5,000,000,000 5,500,000,00016 Mobil Derek P J 2 1 500,000,000 1,000,000,000 1,100,000,00017 Genset Q J 1 1 200,000,000 200,000,000 220,000,000

Total 1,890,200,000,000 2,079,220,000,000

Total Biaya Investasi/KmPROYEK PEMBANGUNAN JALAN TOL 100 KM 2,079,220,000,000 20,792,200,000Kenaikan investasi Fixex Asset (Mark-up) 10.0%Tahun mulai beroperasi (komersial) 2018

PredecessorKodeKegiatanNo.

Kembali ke Menu

D 28 Dummy I 41 Dummy8 38 0 3 45 0

EST EFT0 A 6 B 12 C 20 G 38 H 42 J 43 K 45 Dummy 450 6 6 6 12 8 20 18 38 4 42 1 43 2 45 0 45

LST LFT

F 28 Dummy Dummy P 44 Dummy8 38 0 0 1 45 0

L1 E 30 Dummy

10 38 0 Q 44 Dummy1 45 0

7 M 10 N 43 O 44 Dummy40 3 43 1 44 1 45 0

Kembali ke Menu

EST+Float Waktu Float Jalur(Bulan) (Bulan) (Bulan) Kritis

1 Pembebasan Lahan 0 6 0 A Jalur Kritis2 Cut & Fill 6 6 0 B Jalur Kritis3 Pemadatan Tanah 12 8 0 C Jalur Kritis4 Pembangunan Jembatan 20 8 105 Pembangunan Fly over 20 10 86 Pengecoran 20 8 107 Pengaspalan 20 18 0 G Jalur Kritis8 Pemagaran 38 4 0 H Jalur Kritis9 Marka jalan dan rambu-rambu lalu lintas 38 3 410 Pintu Tol 42 1 0 J Jalur Kritis11 Pemasangan Lampu 43 2 0 K Jalur Kritis12 Kendaraan Proyek 6 1 3313 Bangunan Kantor 7 3 3314 Furniture & Peralatan Kantor 10 1 3315 Kendaraan Operasi 43 1 116 Mobil Derek 43 1 117 Genset 43 1 1

No. Kegiatan Keterangan

Kembali ke Menu

Float Pemanfatan(Bulan) Float

1 Pembebasan Lahan 0 0.0%2 Cut & Fill 0 0.0%3 Pemadatan Tanah 0 0.0%4 Pembangunan Jembatan 10 0.0%5 Pembangunan Fly over 8 0.0%6 Pengecoran 10 0.0%7 Pengaspalan 0 0.0%8 Pemagaran 0 0.0%9 Marka jalan dan rambu-rambu lalu lintas 4 0.0%10 Pintu Tol 0 0.0%11 Pemasangan Lampu 0 0.0%12 Kendaraan Proyek 33 0.0%13 Bangunan Kantor 33 0.0%14 Furniture & Peralatan Kantor 33 0.0%15 Kendaraan Operasi 1 0.0%16 Mobil Derek 1 0.0%17 Genset 1 0.0%

KegiatanNo.

0 5 10 15 20 25 30 35 40 45 50

Pembebasan LahanCut & Fill

Pemadatan TanahPembangunan Jembatan

Pembangunan Fly overPengecoran

PengaspalanPemagaran

Marka jalan dan rambu-rambu lalu lintasPintu Tol

Pemasangan LampuKendaraan ProyekBangunan Kantor

Furniture & Peralatan KantorKendaraan Operasi

Mobi l DerekGenset

Kembali ke Menu

Investasi Waktu Keterangan Bulan(Rp) (Bulan) 1 2 3 4 5 6 7 8 9 10 11 12

1 Pembebasan Lahan 550,000,000,000 6 100% OK 10% 10% 20% 20% 20% 20%2 Cut & Fill 275,000,000,000 6 100% OK 10% 20% 30% 20% 10% 10%3 Pemadatan Tanah 165,000,000,000 8 100% OK 10% 10% 20% 20% 10% 10% 10% 10%4 Pembangunan Jembatan 192,500,000,000 8 100% OK 10% 10% 20% 20% 10% 10% 10% 10%5 Pembangunan Fly over 110,000,000,000 10 100% OK 10% 10% 10% 10% 10% 10% 10% 10% 10% 10%6 Pengecoran 440,000,000,000 8 100% OK 10% 10% 20% 20% 10% 10% 10% 10%7 Pengaspalan 275,000,000,000 18 100% OK 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5%8 Pemagaran 22,000,000,000 4 100% OK 20% 30% 30% 20%9 Marka jalan dan rambu-rambu lalu lintas 11,000,000,000 3 100% OK 30% 40% 30%

10 Pintu Tol 5,500,000,000 1 100% OK 100%11 Pemasangan Lampu 22,000,000,000 2 100% OK 60% 40%12 Kendaraan Proyek 1,100,000,000 1 100% OK 100%13 Bangunan Kantor 2,200,000,000 3 100% OK 20% 50% 30%14 Furniture & Peralatan Kantor 1,100,000,000 1 100% OK 100%15 Kendaraan Operasi 5,500,000,000 1 100% OK 100%16 Mobil Derek 1,100,000,000 1 100% OK 100%17 Genset 220,000,000 1 100% OK 100%

Total 2,079,220,000,000

TotalKegiatanNo.

Kembali ke Menu

Waktu Bulan(Bulan) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

1 Pembebasan Lahan 0 6 10% 10% 20% 20% 20% 20% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%2 Cut & Fill 6 6 0% 0% 0% 0% 0% 0% 10% 20% 30% 20% 10% 10% 0% 0% 0% 0% 0% 0% 0% 0%3 Pemadatan Tanah 12 8 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 10% 10% 20% 20% 10% 10% 10% 10%4 Pembangunan Jembatan 20 8 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%5 Pembangunan Fly over 20 10 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%6 Pengecoran 20 8 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%7 Pengaspalan 20 18 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%8 Pemagaran 38 4 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%9 Marka jalan dan rambu-rambu lalu lintas 38 3 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%

10 Pintu Tol 42 1 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%11 Pemasangan Lampu 43 2 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%12 Kendaraan Proyek 6 1 0% 0% 0% 0% 0% 0% 100% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%13 Bangunan Kantor 7 3 0% 0% 0% 0% 0% 0% 0% 20% 50% 30% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%14 Furniture & Peralatan Kantor 10 1 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 100% 0% 0% 0% 0% 0% 0% 0% 0% 0%15 Kendaraan Operasi 43 1 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%16 Mobil Derek 43 1 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%17 Genset 43 1 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%

EST+FloatKegiatanNo.

Kembali ke Menu

Investasi BulanFixed Assets 1 2 3 4 5 6

1 Pembebasan Lahan 550,000,000,000 55,000,000,000 55,000,000,000 110,000,000,000 110,000,000,000 110,000,000,000 110,000,000,000 2 Cut & Fill 275,000,000,000 - - - - - - 3 Pemadatan Tanah 165,000,000,000 - - - - - - 4 Pembangunan Jembatan 192,500,000,000 - - - - - - 5 Pembangunan Fly over 110,000,000,000 - - - - - - 6 Pengecoran 440,000,000,000 - - - - - - 7 Pengaspalan 275,000,000,000 - - - - - - 8 Pemagaran 22,000,000,000 - - - - - - 9 Marka jalan dan rambu-rambu lalu lintas 11,000,000,000 - - - - - -

10 Pintu Tol 5,500,000,000 - - - - - - 11 Pemasangan Lampu 22,000,000,000 - - - - - - 12 Kendaraan Proyek 1,100,000,000 - - - - - - 13 Bangunan Kantor 2,200,000,000 - - - - - - 14 Furniture & Peralatan Kantor 1,100,000,000 - - - - - - 15 Kendaraan Operasi 5,500,000,000 - - - - - - 16 Mobil Derek 1,100,000,000 - - - - - - 17 Genset 220,000,000 - - - - - -

Total 2,079,220,000,000 55,000,000,000 55,000,000,000 110,000,000,000 110,000,000,000 110,000,000,000 110,000,000,000

Pembayaran (%) 2.6% 2.6% 5.3% 5.3% 5.3% 5.3%Akumulasi Pembayaran (%) 2.6% 5.3% 10.6% 15.9% 21.2% 26.5%

FINANCING Proporsi TotalEkuitas 30.0% 623,766,000,000 16,500,000,000 16,500,000,000 33,000,000,000 33,000,000,000 33,000,000,000 33,000,000,000Pinjaman Bank 20.0% 415,844,000,000 11,000,000,000 11,000,000,000 22,000,000,000 22,000,000,000 22,000,000,000 22,000,000,000Obligasi 50.0% 1,039,610,000,000 27,500,000,000 27,500,000,000 55,000,000,000 55,000,000,000 55,000,000,000 55,000,000,000Total 100.0% 2,079,220,000,000 55,000,000,000 55,000,000,000 110,000,000,000 110,000,000,000 110,000,000,000 110,000,000,000

Masa Konstruksi 45 Bulan

BUNGA PERIODE KONSTRUKSI Suku Bunga Tenor Total 45 44 43 42 41 40Biaya Bunga Pinjaman Bank 12.0% 10 117,721,340,000 4,950,000,000 4,840,000,000 9,460,000,000 9,240,000,000 9,020,000,000 8,800,000,000Bunga Obligasi 291,090,800,000 0 0 0 0 0 41,584,400,000Total Biaya Bunga 408,812,140,000 4,950,000,000 4,840,000,000 9,460,000,000 9,240,000,000 9,020,000,000 50,384,400,000

Porsi Nilai(%) (Rp)

Dibayar pada Periode Konstruksi 30.0% 35,316,402,000Dibayar pada Periode Komersial 70.0% 82,404,938,000Total 100.0% 117,721,340,000Biaya provisi kredit Bank 1.0% 4,158,440,000Biaya issue obligasi 0.50% 5,198,050,000Pendapatan Bunga (Obligasi) 6.00% 91,958,625,000

No. Kegiatan

GRACE PERIOD BUNGA PINJAMAN BANK

Kembali ke Menu

0.0%

10.0%

20.0%

30.0%

40.0%

50.0%

60.0%

70.0%

80.0%

90.0%

100.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

Akum

ulas

i Pen

arik

an D

ana

(%)

Bulan

S-CURVE

Bulan1 2 3 4 5 6 7 8 9 10 11 12

1 Biaya Administrasi 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2 Biaya Konsultan 10,000,000,000 5,000,000,000 5,000,000,000 3 Biaya Perizinan 20,000,000,000 20,000,000,000 20,000,000,000 4 Biaya Lain-lain 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

Total 32,025,000,000 22,025,000,000 22,025,000,000 2,025,000,000 2,025,000,000 7,025,000,000 2,025,000,000 2,025,000,000 2,025,000,000 2,025,000,000 2,025,000,000 7,025,000,000Amortized? Penyelesaian Proyek

(0 = No, 1 = Yes) 45 1 2 3 4 5 6 7 8 9 10 11 121 Biaya Administrasi 90,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2,000,000,000 2 Biaya Konsultan 45,000,000,000 10,000,000,000 - - - - 5,000,000,000 - - - - - 5,000,000,000 3 Biaya Perizinan 1 - - - - - - - - - - - - - 4 Biaya Lain-lain 1,125,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

Total 136,125,000,000 12,025,000,000 2,025,000,000 2,025,000,000 2,025,000,000 2,025,000,000 7,025,000,000 2,025,000,000 2,025,000,000 2,025,000,000 2,025,000,000 2,025,000,000 7,025,000,000BIAYA PRA-OPERASI YANG DIAMORTISASI

Uraian Total 1 2 3 4 5 6 7 8 9 10 11 12Biaya Perizinan 60,000,000,000 20,000,000,000 20,000,000,000 20,000,000,000 - - - - - - - - -

Uraian

No. Uraian

Kembali ke Menu

KATEGORI OPERASIKemudian pada tombol Operasi yang merupakan kategori asumsi input dalam operasional pembangunan TOL ( Pendapatan, Biaya Penyusutan, Biaya Asuransi & Sewa, Biaya Operasi, Modal Kerja, Bunga & Cicilan dan Cost of Capital ).

PENDAPATANBIAYA PENYUSUTAN

BIAYA ASURANSI & SEWABIAYA OPERASI

BUNGA DAN CICILANMODAL KERJA

COST OF CAPITAL

Back to Menu

Tarif Tol Tarif Tol Tarif TolGolongan 1 Golongan 2 Golongan 3 Kenaikan Tarif

(Rp) (Rp) (Rp) Per Tahun1 Pintu Tol 1 2,000 2,000 17,250 5.0%2 Pintu Tol 2 2,500 3,000 17,250 5.0%3 Pintu Tol 3 3,000 4,000 15,000 5.0%4 Pintu Tol 4 3,000 3,000 15,000 5.0%5 Pintu Tol 5 4,000 2,000 14,500 5.0%6 Pintu Tol 6 5,000 2,500 14,000 5.0%7 Pintu Tol 7 5,000 2,000 11,500 5.0%8 Pintu Tol 8 5,000 3,000 11,500 5.0%9 Pintu Tol 9 2,000 4,000 8,000 5.0%10 Pintu Tol 10 2,000 4,000 8,000 5.0%

Volume Volume VolumeGolongan 1 Golongan 2 Golongan 3(Unit/Hari) (Unit/Hari) (Unit/Hari)

1 Pintu Tol 1 1,000 1,500 2502 Pintu Tol 2 2,000 2,000 5003 Pintu Tol 3 4,000 5,000 1,0004 Pintu Tol 4 3,000 4,000 1,0005 Pintu Tol 5 5,000 6,000 7506 Pintu Tol 6 7,000 8,000 1,0007 Pintu Tol 7 7,000 5,000 7508 Pintu Tol 8 7,000 5,000 1,0009 Pintu Tol 9 7,000 5,000 50010 Pintu Tol 10 7,000 5,000 500

Total 50,000 46,500 7,250

Kenaikan Volume Kendaraan Golongan 1 5.0%Kenaikan Volume Kendaraan Golongan 2 5.0%Kenaikan Volume Kendaraan Golongan 3 5.0%

TARIF JALAN TOL Golongan 1Tarif Tol

Golongan 1(Rp) Per Tahun 2018 2019 2020 2021 2022 2023

1 Pintu Tol 1 2,000 2,100 2,205 2,315 2,431 2,553 2,680 2,8142 Pintu Tol 2 2,500 2,625 2,756 2,894 3,039 3,191 3,350 3,5183 Pintu Tol 3 3,000 3,150 3,308 3,473 3,647 3,829 4,020 4,2214 Pintu Tol 4 3,000 3,150 3,308 3,473 3,647 3,829 4,020 4,2215 Pintu Tol 5 4,000 4,200 4,410 4,631 4,862 5,105 5,360 5,6286 Pintu Tol 6 5,000 5,250 5,513 5,788 6,078 6,381 6,700 7,0367 Pintu Tol 7 5,000 5,250 5,513 5,788 6,078 6,381 6,700 7,0368 Pintu Tol 8 5,000 5,250 5,513 5,788 6,078 6,381 6,700 7,0369 Pintu Tol 9 2,000 2,100 2,205 2,315 2,431 2,553 2,680 2,81410 Pintu Tol 10 2,000 2,100 2,205 2,315 2,431 2,553 2,680 2,814

VOLUME KENDARAAN Golongan 1Volume Volume

Golongan 1 Golongan 1(Unit/Hari) (Unit/Tahun)

1 Pintu Tol 1 1,000 365,000 383,250 402,413 422,533 443,660 465,843 489,135 513,5922 Pintu Tol 2 2,000 730,000 766,500 804,825 845,066 887,320 931,686 978,270 1,027,1833 Pintu Tol 3 4,000 1,460,000 1,533,000 1,609,650 1,690,133 1,774,639 1,863,371 1,956,540 2,054,3674 Pintu Tol 4 3,000 1,095,000 1,149,750 1,207,238 1,267,599 1,330,979 1,397,528 1,467,405 1,540,7755 Pintu Tol 5 5,000 1,825,000 1,916,250 2,012,063 2,112,666 2,218,299 2,329,214 2,445,675 2,567,9586 Pintu Tol 6 7,000 2,555,000 2,682,750 2,816,888 2,957,732 3,105,618 3,260,899 3,423,944 3,595,1427 Pintu Tol 7 7,000 2,555,000 2,682,750 2,816,888 2,957,732 3,105,618 3,260,899 3,423,944 3,595,1428 Pintu Tol 8 7,000 2,555,000 2,682,750 2,816,888 2,957,732 3,105,618 3,260,899 3,423,944 3,595,1429 Pintu Tol 9 7,000 2,555,000 2,682,750 2,816,888 2,957,732 3,105,618 3,260,899 3,423,944 3,595,14210 Pintu Tol 10 7,000 2,555,000 2,682,750 2,816,888 2,957,732 3,105,618 3,260,899 3,423,944 3,595,142

Total 50,000 18,250,000 19,162,500 20,120,625 21,126,656 22,182,989 23,292,139 24,456,745 25,679,583

PENDAPATAN JALAN TOL Golongan 1No. Per Tahun 2018 2019 2020 2021 2022 20231 Pintu Tol 1 804,825,000 887,319,563 978,269,818 1,078,542,474 1,189,093,078 1,310,975,118 1,445,350,0682 Pintu Tol 2 2,012,062,500 2,218,298,906 2,445,674,544 2,696,356,185 2,972,732,694 3,277,437,795 3,613,375,1693 Pintu Tol 3 4,828,950,000 5,323,917,375 5,869,618,906 6,471,254,844 7,134,558,465 7,865,850,708 8,672,100,4064 Pintu Tol 4 3,621,712,500 3,992,938,031 4,402,214,179 4,853,441,133 5,350,918,849 5,899,388,031 6,504,075,3045 Pintu Tol 5 8,048,250,000 8,873,195,625 9,782,698,177 10,785,424,740 11,890,930,775 13,109,751,180 14,453,500,6766 Pintu Tol 6 14,084,437,500 15,528,092,344 17,119,721,809 18,874,493,294 20,809,128,857 22,942,064,565 25,293,626,1837 Pintu Tol 7 14,084,437,500 15,528,092,344 17,119,721,809 18,874,493,294 20,809,128,857 22,942,064,565 25,293,626,1838 Pintu Tol 8 14,084,437,500 15,528,092,344 17,119,721,809 18,874,493,294 20,809,128,857 22,942,064,565 25,293,626,1839 Pintu Tol 9 5,633,775,000 6,211,236,938 6,847,888,724 7,549,797,318 8,323,651,543 9,176,825,826 10,117,450,47310 Pintu Tol 10 5,633,775,000 6,211,236,938 6,847,888,724 7,549,797,318 8,323,651,543 9,176,825,826 10,117,450,473

Total 72,836,662,500 80,302,420,406 88,533,418,498 97,608,093,894 107,612,923,518 118,643,248,179 130,804,181,117

202320222021202020192018Per Tahun

Uraian

No. Uraian

UraianNo.

UraianNo.

UraianNo.

Kembali ke Menu

Umur BiayaInvestasi Ekonomis Penyusutan

Fixed Assets (Tahun) Per Tahun1 Pembebasan Lahan 550,000,000,000 0 0 0 0 0 02 Cut & Fill 275,000,000,000 50 5,500,000,000 5,500,000,000 5,500,000,000 5,500,000,000 5,500,000,0003 Pemadatan Tanah 165,000,000,000 50 3,300,000,000 3,300,000,000 3,300,000,000 3,300,000,000 3,300,000,0004 Pembangunan Jembatan 192,500,000,000 50 3,850,000,000 3,850,000,000 3,850,000,000 3,850,000,000 3,850,000,0005 Pembangunan Fly over 110,000,000,000 50 2,200,000,000 2,200,000,000 2,200,000,000 2,200,000,000 2,200,000,0006 Pengecoran 440,000,000,000 50 8,800,000,000 8,800,000,000 8,800,000,000 8,800,000,000 8,800,000,0007 Pengaspalan 275,000,000,000 20 13,750,000,000 13,750,000,000 13,750,000,000 13,750,000,000 13,750,000,0008 Pemagaran 22,000,000,000 10 2,200,000,000 2,200,000,000 2,200,000,000 2,200,000,000 2,200,000,0009 Marka jalan dan rambu-rambu lalu lintas 11,000,000,000 5 2,200,000,000 2,200,000,000 2,200,000,000 2,200,000,000 2,200,000,00010 Pintu Tol 5,500,000,000 20 275,000,000 275,000,000 275,000,000 275,000,000 275,000,00011 Pemasangan Lampu 22,000,000,000 20 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,00012 Kendaraan Proyek 1,100,000,000 5 220,000,000 220,000,000 220,000,000 220,000,000 220,000,00013 Bangunan Kantor 2,200,000,000 40 55,000,000 55,000,000 55,000,000 55,000,000 55,000,00014 Furniture & Peralatan Kantor 1,100,000,000 5 220,000,000 220,000,000 220,000,000 220,000,000 220,000,00015 Kendaraan Operasi 5,500,000,000 5 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,00016 Mobil Derek 1,100,000,000 5 220,000,000 220,000,000 220,000,000 220,000,000 220,000,00017 Genset 220,000,000 8 27,500,000 27,500,000 27,500,000 27,500,000 27,500,000

Total 2,079,220,000,000 45,017,500,000 45,017,500,000 45,017,500,000 45,017,500,000 45,017,500,000BIAYA AMORTISASI

Umur BiayaInvestasi Ekonomis Amortisasi

Uraian Lain-lain (Tahun) Per Tahun 2018 2019 2020 2021Biaya Perizinan 60,000,000,000 10 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000

No. Uraian 2018 2019 2020 2021

Kembali ke Menu

BIAYA ASURANSIPremi Biaya

Investasi Asuransi AsuransiFixed Assets (Tahun) 2018

Nilai Pertanggungan 1,089,220,000,000 2.0% 21,784,400,000 21,784,400,000 21,784,400,000 21,784,400,000 21,784,400,000

BIAYA SEWA KANTORUraian 2018 2019 2020 2021 2022

Sewa Kantor 100,000,000 0 100,000,000 0 100,000,000Pembayaran 200,000,000 200,000,000 200,000,000Biaya Sewa Expired 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000

BIAYA SEWA KENDARAANUraian 2018 2019 2020 2021 2022

Sewa Kendaraan 25,000,000 0 25,000,000 0 25,000,000Pembayaran 50,000,000 50,000,000 50,000,000Biaya Sewa Expired 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

2019 2020 2021 2022Uraian

Kembali ke Menu

Biaya/Tahun Kenaikan Biaya (%/Tahun)(Rp) Per Tahun

1 Biaya Gaji 4,000,000,000 5.0%2 Biaya Perawatan Jalan 5,000,000,000 5.0%3 Biaya Perawatan Kantor 1,000,000,000 5.0%4 Biaya Perawatan Kendaraan 500,000,000 5.0%5 Biaya Listrik 10,000,000,000 5.0%6 Biaya Transportasi 100,000,000 5.0%7 Biaya Administrasi Kantor 250,000,000 5.0%8 Biaya Pertamanan 2,000,000,000 5.0%

BIAYA OPERASIONALNo. Uraian Per Tahun 2018 2019 2020 20211 Biaya Gaji 4,200,000,000 4,410,000,000 4,630,500,000 4,862,025,000 5,105,126,2502 Biaya Perawatan Jalan 5,250,000,000 5,512,500,000 5,788,125,000 6,077,531,250 6,381,407,8133 Biaya Perawatan Kantor 1,050,000,000 1,102,500,000 1,157,625,000 1,215,506,250 1,276,281,5634 Biaya Perawatan Kendaraan 525,000,000 551,250,000 578,812,500 607,753,125 638,140,7815 Biaya Listrik 10,500,000,000 11,025,000,000 11,576,250,000 12,155,062,500 12,762,815,6256 Biaya Sewa Kantor 100,000,000 100,000,000 100,000,000 100,000,000 100,000,0007 Biaya Sewa Kendaraan 25,000,000 25,000,000 25,000,000 25,000,000 25,000,0008 Biaya Transportasi 105,000,000 110,250,000 115,762,500 121,550,625 127,628,1569 Biaya Administrasi Kantor 262,500,000 275,625,000 289,406,250 303,876,563 319,070,391

10 Biaya Pertamanan 2,100,000,000 2,205,000,000 2,315,250,000 2,431,012,500 2,552,563,12511 Biaya Penyusutan 45,017,500,000 45,017,500,000 45,017,500,000 45,017,500,000 45,017,500,00012 Biaya Amortisasi 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,00013 Biaya Asuransi 21,784,400,000 21,784,400,000 21,784,400,000 21,784,400,000 21,784,400,000

Total 96,919,400,000 98,119,025,000 99,378,631,250 100,701,217,813 102,089,933,703

UraianNo.

Kembali ke Menu

KREDIT PENJUALAN DAN PEMBELIANTOP

Piutang Usaha 0 HariUtang Usaha 30 HariKebutuhan kas Operasional 1.2 kali Utang Usaha

KEBUTUHAN MODAL KERJAUraian 2018 2019 2020 2021 2022

HARTA LANCARKas 4,577,690,000 4,697,652,500 4,823,613,125 4,955,871,781 5,094,743,370Piutang Usaha 0 0 0 0 0Total 4,577,690,000 4,697,652,500 4,823,613,125 4,955,871,781 5,094,743,370

UTANG LANCARUtang Usaha 3,814,741,667 3,914,710,417 4,019,677,604 4,129,893,151 4,245,619,475Kebutuhan Modal Kerja 762,948,333 782,942,083 803,935,521 825,978,630 849,123,895Perubahan Modal Kerja 762,948,333 19,993,750 783,941,771 42,036,859 807,087,036

FINANCINGPendanaan modal kerja dengan dana internal 0 0 = No, 1 = Yes

Modal Sendiri 30% 228,884,500 234,882,625 241,180,656 247,793,589 254,737,169Pinjaman 70% 534,063,833 548,059,458 562,754,865 578,185,041 594,386,727Total 100% 762,948,333 782,942,083 803,935,521 825,978,630 849,123,895

Biaya Bunga 15% 80,109,575 82,208,919 84,413,230 86,727,756 89,158,009Provisi Kredit Modal Kerja 1% 5,340,638 5,480,595 5,627,549 5,781,850 5,943,867

Perubahan Modal Sendiri dan UtangModal Sendiri 228,884,500 5,998,125 6,298,031 6,612,933 6,943,579Pinjaman 534,063,833 13,995,625 14,695,406 15,430,177 16,201,685Total 762,948,333 19,993,750 20,993,438 22,043,109 23,145,265

Kembali ke Menu

BIAYA BUNGA DAN CICILAN PINJAMAN BARUUraian

Biaya Bunga 11.0% per tahunCicilan 10 TahunPendapatan Bunga 8.0% per tahunOBLIGASIPrincipal 1,039,610,000,000Kupon 8% per tahunMaturity 30 TahunTingkat bunga pasar 8% per tahunPembayaran Kupon 2 Kali setahunMaturity 60 Periode

PEMBAYARAN BIAYA BUNGA DAN CICILAN PINJAMAN KREDIT INVESTASIUraian 0 2018 2019 2020 2021 2022

Pinjaman Pokok 415,844,000,000 392,147,477,239 365,607,371,747 335,882,453,596 302,590,545,266 265,303,607,937Bunga + Cicilan 0 73,597,802,761 73,597,802,761 73,597,802,761 73,597,802,761 73,597,802,761Biaya Bunga 0 49,901,280,000 47,057,697,269 43,872,884,610 40,305,894,431 36,310,865,432Cicilan 0 23,696,522,761 26,540,105,492 29,724,918,151 33,291,908,329 37,286,937,329PEMBAYARAN BIAYA BUNGA DAN CICILAN PINJAMAN EX IDC

Uraian 0 2018 2019 2020 2021 2022Pinjaman Pokok 82,404,938,000 77,709,161,485 72,449,891,789 66,559,509,729 59,962,281,822 52,573,386,566Bunga + Cicilan 0 14,584,369,075 14,584,369,075 14,584,369,075 14,584,369,075 14,584,369,075Biaya Bunga 0 9,888,592,560 9,325,099,378 8,693,987,015 7,987,141,168 7,195,473,819Cicilan 0 4,695,776,515 5,259,269,696 5,890,382,060 6,597,227,907 7,388,895,256PEMBAYARAN BIAYA BUNGA DAN CICILAN PINJAMAN KREDIT INVESTASI + IDC

Uraian 0 2018 2019 2020 2021 2022Pinjaman Pokok 498,248,938,000 469,856,638,725 438,057,263,536 402,441,963,325 362,552,827,088 317,876,994,504Bunga + Cicilan 0 88,182,171,835 88,182,171,835 88,182,171,835 88,182,171,835 88,182,171,835Biaya Bunga 0 59,789,872,560 56,382,796,647 52,566,871,624 48,293,035,599 43,506,339,251Cicilan 0 28,392,299,275 31,799,375,189 35,615,300,211 39,889,136,236 44,675,832,585PEMBAYARAN BIAYA BUNGA DAN CICILAN PINJAMAN PINJAMAN BARU

Uraian 2018 2019 2020 2021 2022Pinjaman Pokok 45,829,485,755 84,992,663,636 111,098,210,413 120,338,367,505 110,367,407,975Bunga + Cicilan 0 7,781,912,084 14,897,245,026 20,272,071,276 23,208,179,955Biaya Bunga 0 5,041,243,433 9,349,193,000 12,220,803,145 13,237,220,426Cicilan 0 2,740,668,651 5,548,052,026 8,051,268,131 9,970,959,530PEMBAYARAN BIAYA BUNGA DAN CICILAN PINJAMAN TOTAL

Uraian 0 2018 2019 2020 2021 2022Pinjaman Pokok 498,248,938,000 515,686,124,480 523,049,927,172 513,540,173,738 482,891,194,593 428,244,402,479Biaya Bunga 291,090,800,000 142,958,672,560 144,592,840,080 145,084,864,624 143,682,638,744 139,912,359,676Cicilan 0 28,392,299,275 34,540,043,840 41,163,352,238 47,940,404,367 54,646,792,115OBLIGASI

Uraian 2018 2019 2020 2021 2022Kupon 83,168,800,000 83,168,800,000 83,168,800,000 83,168,800,000 83,168,800,000Principal 1,039,610,000,000 1,039,610,000,000 1,039,610,000,000 1,039,610,000,000 1,039,610,000,000Pembayaran Principal 0 0 0 0 0

Kembali ke Menu

PERHITUNGAN COST OF EQUITYCost of Debt 12.0%Premium (Spread) 10.0%Cost of Ekuitas 22.0%

PERHITUNGAN COST OF CAPITALUraian Proporsi Cost of Capital CoC setelah Pajak Perkalian

Modal Sendiri 30.0% 22.0% 22.0% 6.6%Pinjaman Bank 20.0% 12.0% 9.0% 1.8%Obligasi 50.0% 8.0% 6.0% 3.0%Total 100.0% 0.0% WACC = 11.4%

Kembali ke Menu

KATEGORI LAPORAN

Dan tombol terakhir yaitu Laporan yang merupakan hasil dari asumsi-asumsi yang telah dimasukkan pada kategori Konstruksi dan Operasi sebelumnya (Laporan Laba Rugi, NPV, IRR, Payback, PI, bc Ratio, Laoran Cash Flow, Neraca, Rasio Keuangan dan Monte Carlo Simulation).

Back to Menu

0 2018 2019 2020 2021 2022Pendapatan 0 166,976,036,719 184,091,080,482 202,960,416,232 223,763,858,896 246,699,654,432Biaya Operasional 136,125,000,000 96,919,400,000 98,119,025,000 99,378,631,250 100,701,217,813 102,089,933,703Laba Operasi (136,125,000,000) 70,056,636,719 85,972,055,482 103,581,784,982 123,062,641,083 144,609,720,729Biaya Bunga 408,812,140,000 142,958,672,560 144,592,840,080 145,084,864,624 143,682,638,744 139,912,359,676Pendapatan Bunga 91,958,625,000 0 0 0 0 86,079,733Biaya Lain-lain (Provisi Bank) 9,356,490,000 5,340,638 5,480,595 5,627,549 5,781,850 5,943,867Laba Sebelum Pajak (462,335,005,000) (72,907,376,480) (58,626,265,192) (41,508,707,191) (20,625,779,512) 4,777,496,919Pajak 0 0 0 0 0 1,194,374,230Laba Bersih (462,335,005,000) (72,907,376,480) (58,626,265,192) (41,508,707,191) (20,625,779,512) 3,583,122,689

Tarif Pajak 25%

Kembali ke Menu

Uraian 0 2018 2019 2020 2021 2022CASH INFLOWEBIT(1-t) 0 52,542,477,539 64,479,041,612 77,686,338,736 92,296,980,812 108,457,290,547Biaya Penyusutan dan Amortisasi 0 51,017,500,000 51,017,500,000 51,017,500,000 51,017,500,000 51,017,500,000Nilai Sisa Fixed AssetsNilai Sisa Modal KerjaTotal Cash Inflow 0 103,559,977,539 115,496,541,612 128,703,838,736 143,314,480,812 159,474,790,547

CASH OUTFLOWFixed Assets 2,079,220,000,000 0 0 0 0 0Perubahan Modal Kerja 0 762,948,333 19,993,750 783,941,771 42,036,859 807,087,036Total Cash Outflow 2,079,220,000,000 762,948,333 19,993,750 783,941,771 42,036,859 807,087,036

NET CASH FLOW (2,079,220,000,000) 102,797,029,206 115,476,547,862 127,919,896,966 143,272,443,953 158,667,703,511NET CASH FLOW (Dalam Juta) (2,079) 103 115 128 143 159PVIF 11.40% 1.0000 0.8977 0.8058 0.7233 0.6493 0.5829PV (2,079) 92 93 93 93 92

NPV 592 Layak Boss..IRR 13.3%IRR Manual 13.3%Payback Period 11.12 TahunProfitability Index 1.28BC-Ratio 1.28

Kembali ke Menu

Uraian 0 2018 2019 2020 2021 2022PENERIMAANPenjualan Tunai 0 166,976,036,719 184,091,080,482 202,960,416,232 223,763,858,896 246,699,654,432Piutang Usaha 0 0 0 0 0 0Lain-lain 91,958,625,000 0 0 0 0 0Total Penerimaan 91,958,625,000 166,976,036,719 184,091,080,482 202,960,416,232 223,763,858,896 246,699,654,432

PENGELUARANPembayaran Tunai 0 41,962,158,333 43,061,814,583 44,216,453,646 45,428,824,661 46,701,814,228Utang Usaha 0 0 3,814,741,667 3,914,710,417 4,019,677,604 4,129,893,151Biaya Sewa Kantor 0 200,000,000 0 200,000,000 0 200,000,000Biaya Sewa Kendaraan 0 50,000,000 0 50,000,000 0 50,000,000Biaya Bunga 326,407,202,000 142,958,672,560 144,592,840,080 145,084,864,624 143,682,638,744 139,912,359,676Cicilan Pinjaman 0 28,392,299,275 34,540,043,840 41,163,352,238 47,940,404,367 54,646,792,115Biaya Provisi 9,356,490,000 5,340,638 5,480,595 5,627,549 5,781,850 5,943,867pembayaran Obligasi 0 0 0 0 0 0Pajak 0 0 0 0 0 0Biaya Praoperasi 136,125,000,000 0 0 0 0 0Fixed Assets 2,079,220,000,000 0 0 0 0 0Total Pengeluaran 2,611,108,692,000 213,568,470,807 226,014,920,764 234,635,008,473 241,077,327,227 245,646,803,037Selesih Penerimaan dengan Pengeluaran (2,519,150,067,000) (46,592,434,088) (41,923,840,282) (31,674,592,241) (17,313,468,332) 1,052,851,396Kas Awal 0 0 0 0 0 0Kas Sebelum Financing (2,519,150,067,000) (46,592,434,088) (41,923,840,282) (31,674,592,241) (17,313,468,332) 1,052,851,396

FINANCINGPembelian Fixed AssetsModal Sendiri 1,063,696,067,000Pinjaman Bank 415,844,000,000 45,829,485,755 41,903,846,532 31,653,598,804 17,291,425,222 0Obligasi 1,039,610,000,000 0 0 0 0 0

Modal KerjaModal Sendiri 0 228,884,500 5,998,125 6,298,031 6,612,933 6,943,579Pinjaman Bank 0 534,063,833 13,995,625 14,695,406 15,430,177 16,201,685Total Financing 2,519,150,067,000 46,592,434,088 41,923,840,282 31,674,592,241 17,313,468,332 23,145,265

Kas Akhir 0 0 0 0 0 1,075,996,660

Kembali ke Menu

0 0 0 0 0 0Uraian 0 2018 2019 2020 2021 2022

HARTAHARTA LANCARKas 0 0 0 0 0 1,075,996,660Piutang Usaha 0 0 0 0 0 0Biaya Sewa dibayar di muka 0 125,000,000 0 125,000,000 0 125,000,000Pendapatan yang masih harus diterima 0 0 0 0 0 86,079,733Total Harta Lancar 0 125,000,000 0 125,000,000 0 1,287,076,393

HARTA TETAPPembebasan Lahan 550,000,000,000 550,000,000,000 550,000,000,000 550,000,000,000 550,000,000,000 550,000,000,000Cut & Fill 275,000,000,000 275,000,000,000 275,000,000,000 275,000,000,000 275,000,000,000 275,000,000,000Pemadatan Tanah 165,000,000,000 165,000,000,000 165,000,000,000 165,000,000,000 165,000,000,000 165,000,000,000Pembangunan Jembatan 192,500,000,000 192,500,000,000 192,500,000,000 192,500,000,000 192,500,000,000 192,500,000,000Pembangunan Fly over 110,000,000,000 110,000,000,000 110,000,000,000 110,000,000,000 110,000,000,000 110,000,000,000Pengecoran 440,000,000,000 440,000,000,000 440,000,000,000 440,000,000,000 440,000,000,000 440,000,000,000Pengaspalan 275,000,000,000 275,000,000,000 275,000,000,000 275,000,000,000 275,000,000,000 275,000,000,000Pemagaran 22,000,000,000 22,000,000,000 22,000,000,000 22,000,000,000 22,000,000,000 22,000,000,000Marka jalan dan rambu-rambu lalu lintas 11,000,000,000 11,000,000,000 11,000,000,000 11,000,000,000 11,000,000,000 11,000,000,000Pintu Tol 5,500,000,000 5,500,000,000 5,500,000,000 5,500,000,000 5,500,000,000 5,500,000,000Pemasangan Lampu 22,000,000,000 22,000,000,000 22,000,000,000 22,000,000,000 22,000,000,000 22,000,000,000Kendaraan Proyek 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000Bangunan Kantor 2,200,000,000 2,200,000,000 2,200,000,000 2,200,000,000 2,200,000,000 2,200,000,000Furniture & Peralatan Kantor 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000Kendaraan Operasi 5,500,000,000 5,500,000,000 5,500,000,000 5,500,000,000 5,500,000,000 5,500,000,000Mobil Derek 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000Genset 220,000,000 220,000,000 220,000,000 220,000,000 220,000,000 220,000,000Total Harta Tetap 2,079,220,000,000 2,079,220,000,000 2,079,220,000,000 2,079,220,000,000 2,079,220,000,000 2,079,220,000,000Akumulasi Biaya Penyusutan 0 (45,017,500,000) (90,035,000,000) (135,052,500,000) (180,070,000,000) (225,087,500,000)Total Harta Tetap (Bersih) 2,079,220,000,000 2,034,202,500,000 1,989,185,000,000 1,944,167,500,000 1,899,150,000,000 1,854,132,500,000

HARTA LAIN-LAINBiaya Perizinan 60,000,000,000 60,000,000,000 60,000,000,000 60,000,000,000 60,000,000,000 60,000,000,000Akumulasi Amortisasi 0 (6,000,000,000) (12,000,000,000) (18,000,000,000) (24,000,000,000) (30,000,000,000)Harta Lain-lain (Net) 60,000,000,000 54,000,000,000 48,000,000,000 42,000,000,000 36,000,000,000 30,000,000,000

TOTAL HARTA 2,139,220,000,000 2,088,327,500,000 2,037,185,000,000 1,986,292,500,000 1,935,150,000,000 1,885,419,576,393

UTANG DAN EKUITASUTANG LANCARUtang Usaha 0 3,814,741,667 3,914,710,417 4,019,677,604 4,129,893,151 4,245,619,475Utang Pajak 0 0 0 0 0 1,194,374,230Utang Bank Jangka Pendek 0 534,063,833 548,059,458 562,754,865 578,185,041 594,386,727Total Utang Lancar 0 4,348,805,500 4,462,769,875 4,582,432,469 4,708,078,192 6,034,380,431

UTANG JANGKA PANJANGUtang Bank Jangka Panjang 415,844,000,000 392,147,477,239 365,607,371,747 335,882,453,596 302,590,545,266 265,303,607,937Utang Bank Jangka Panjang (Ex IDC) 82,404,938,000 77,709,161,485 72,449,891,789 66,559,509,729 59,962,281,822 52,573,386,566Obligasi 1,039,610,000,000 1,039,610,000,000 1,039,610,000,000 1,039,610,000,000 1,039,610,000,000 1,039,610,000,000Utang Baru 0 45,829,485,755 84,992,663,636 111,098,210,413 120,338,367,505 110,367,407,975Total Utang Jangka Panjang 1,537,858,938,000 1,555,296,124,480 1,562,659,927,172 1,553,150,173,738 1,522,501,194,593 1,467,854,402,479Total Utang 1,537,858,938,000 1,559,644,929,980 1,567,122,697,047 1,557,732,606,207 1,527,209,272,785 1,473,888,782,910

EKUITASModal Disetor 623,766,000,000 623,766,000,000 623,766,000,000 623,766,000,000 623,766,000,000 623,766,000,000Tambahan Modal 439,930,067,000 440,158,951,500 440,164,949,625 440,171,247,656 440,177,860,589 440,184,804,169Laba Ditahan 0 (462,335,005,000) (535,242,381,480) (593,868,646,672) (635,377,353,863) (656,003,133,374)Laba tahun Berjalan (462,335,005,000) (72,907,376,480) (58,626,265,192) (41,508,707,191) (20,625,779,512) 3,583,122,689Total Ekuitas 601,361,062,000 528,682,570,020 470,062,302,953 428,559,893,793 407,940,727,215 411,530,793,483

TOTAL UTANG DAN EKUITAS 2,139,220,000,000 2,088,327,500,000 2,037,185,000,000 1,986,292,500,000 1,935,150,000,000 1,885,419,576,393

Cek Balance 0 0 0 0 0 0

Kembali ke Menu

Uraian 2018 2019 2020 2021 2022 2023 2024 2025Current Ratio 0.03 0.00 0.03 0.00 0.21 1.78 3.00 4.11Average Collection Period 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Working Capital Turnover 1,335.81 0.00 1,623.68 0.00 191.67 10.02 4.07 2.27Fixed Asset Turnover 0.08 0.09 0.10 0.12 0.13 0.15 0.17 0.19Total Asset Turnover 0.08 0.09 0.10 0.12 0.13 0.15 0.16 0.18Debt to Equity Ratio 2.95 3.33 3.63 3.74 3.58 3.22 2.72 2.19Debt Ratio 0.75 0.77 0.78 0.79 0.78 0.76 0.73 0.69Time Interest Earned 0.49 0.59 0.71 0.86 1.03 1.29 1.57 1.93Profit Margin -43.66% -31.85% -20.45% -9.22% 1.45% 11.29% 19.50% 27.34%Return on Equity -13.79% -12.47% -9.69% -5.06% 0.87% 6.94% 11.68% 15.29%Return on Asset 3.35% 4.22% 5.21% 6.36% 7.67% 9.25% 10.66% 12.07%

Kembali ke Menu

Aktifkan Monte Carlo? 0 0 = Tidak, 1 = YesTarget NPV Cash Shortage

(Dalam Miliar) 100 100Rata-rata 592 137Deviasi Std 0 0z 11,664,951,877,525.000000 53,765,661,632,451.300000Probabilitas 100.00% 100.00%Kemungkinan tidak tercapai target 0.00%

Kembali ke Menu

0.0%

2.0%

4.0%

6.0%

8.0%

10.0%

12.0%

14.0%

16.0%

18.0%

-1000

0

1000

2000

3000

4000

5000

6000

592592592592592592592592592592592592592592592592592592592

FREQ

UEN

CY

NPV

Probability of Distribution

NPV Probabilitas Poly. (NPV)

~Selesai~