Analisa Keuangan Tambang-2

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 33

Kebutuhan Investasi

Deskripsi
A Pra - Konstruksi
- Biaya Pra Penambangan

B Investasi
- Biaya Masa Konstruksi
- Biaya Penunjang Konstruksi

C Biaya Pekerjaan
- Upah/Gaji Karyawan Tetap
Pembelian Suku Cadang
-
(5% x Biaya Pembelian Alat)
Perawatan dan Pemeliharaan Alat
-
(5% x Biaya Pembelian Alat)
- Biaya Pembelian Alat
- Dana CSR
D Jaminan Reklamasi & Mine Closure
Total

Biaya Produksi
A Biaya Tetap
Gaji Karyawan Tetap
- Biaya Pembelian BBM & Pelumas
- Biaya Pembelian Suku Cadang
(5% x Pembelian Peralatan)
- Biaya Perawatan Alat
(5% x Pembelian Peralatan)
Total
B Biaya Berubah
- Asuransi tenaga kerja
(5% x Gaji Karyawan)
- Biaya Operasional Kantor
Dana CSR
- Biaya Sarana Lingkungan K-3
Total
Total Biaya Produksi
Biaya Produksi per m3

DESKRIPSI GAJI

SENIOR STAFF

Head Mining Operation* 7,000,000.00


Deputy Manager* 6,500,000.00
Planning Manager* 5,500,000.00
Production Manager* 5,500,000.00
Contract Manager* 5,500,000.00
Plant Manager* 5,500,000.00
Finance Manager* 5,500,000.00
HRGA Manager* 5,500,000.00
Safety Manager* 5,500,000.00

OPERATION

Mine Engineer & Geologist** 4,500,000.00


Supervisor* 5,000,000.00
Foreman** 3,000,000.00
Operators** 3,500,000.00
K-3 Staff** 3,250,000.00
Community Development Staff** 3,500,000.00
Environmentalist** 3,250,000.00
Safety Personnel** 3,250,000.00
IT Engineer** 3,000,000.00

SURVEYOR
SURVEYOR

Chief Surveyor* 4,750,000.00


Surveyor** 3,350,000.00
Draftman** 3,250,000.00

FIXED PLANT MECHANICS

Supervisor* 5,000,000.00
Mechanic** 3,500,000.00
Welder** 3,250,000.00
Electrician** 3,250,000.00

ADMINISTRATION

Payroll Supervisor* 4,750,000.00


Personnel Supervisor* 3,250,000.00
Secretary** 3,125,000.00
Clerk** 3,000,000.00
Security** 3,000,000.00
Jumlah
Biaya

250,000,000.00

Rp 692,500,000.00
Rp 135,000,000.00

Rp 325,800,000.00
Rp 850,236,620.37

Rp 850,236,620.37

Rp 17,004,732,407.44 Rp 18,705,205,648.19 21,147,705,648.19


Rp 117,000,000.00
Rp 1,500,000,000.00
Rp 21,725,505,648.19

Biaya
Rp 325,800,000.00
Rp 4,988,767,680.00
Rp 850,236,620.37

Rp 850,236,620.37

Rp 7,015,040,920.74 Rp 4,059.63

Rp 16,290,000.00

Rp 75,000,000.00
Rp 112,500,000.00
Rp 25,000,000.00
Rp 228,790,000.00
Rp 7,243,830,920.74 3,621,915,460.37
Rp 1,676.81

JUMLAH PEKERJA TOTAL GAJI

STAFF

1 7,000,000.00
1 6,500,000.00
1 5,500,000.00
1 5,500,000.00
1 5,500,000.00
1 5,500,000.00
1 5,500,000.00
1 5,500,000.00
1 5,500,000.00
52,000,000.00
ATION
207,250,000.00
3 13,500,000.00 24,650,000.00
4 20,000,000.00 28,500,000.00
10 30,000,000.00 13,400,000.00
30 105,000,000.00
3 9,750,000.00
1 3,500,000.00
2 6,500,000.00
4 13,000,000.00
2 6,000,000.00

EYOR
EYOR

1 4,750,000.00
4 13,400,000.00
2 6,500,000.00

MECHANICS

1 5,000,000.00
3 10,500,000.00
2 6,500,000.00
2 6,500,000.00

TRATION

1 4,750,000.00
1 3,250,000.00
5 15,625,000.00
3 9,000,000.00
4 12,000,000.00
325,800,000.00
Biaya Konstruksi
No Uraian Luas (m2) Biaya
1 Jalan Tambang 15 x 3000 Rp 250,000,000.00
2 Stockpile 100 x 25 Rp 85,000,000.00
3 Workshop 15 x 15 Rp 50,000,000.00
4 Kantor Lapangan 30 x 25 Rp 125,000,000.00
5 Instalasi Rp 10,000,000.00
6 Rumah Genset 5 x 10 Rp 15,000,000.00
7 Gudang Bahan bakar + Pelumas 10 x 10 Rp 35,000,000.00
8 Mess Karyawan 10 x 25 Rp 75,000,000.00
9 Klinik 10 x 8 Rp 25,000,000.00
10 Pos Keamanan 4x4 Rp 15,000,000.00
11 Sumur & Pompa Air Rp 7,500,000.00
Total Rp 692,500,000.00
URAIAN Keterangan
Sisa Cadangan
Produksi Andesit
Produksi Andesit
Produksi Tailing (Pasir)
Harga Jual Andesit
Harga Jual Tailing (Pasir)
Pendapatan Penjualan
Total Pendapatan Kotor
Revenue
Investment
Total Pendapatan
BIAYA
Biaya per m3
Depresiasi Lahan & Peralatan
Total Biaya produksi
Total Biaya
Keuntungan sebelum ppn
Pajak Bahan Galian Andesit perbup no 13 tahun 2020
Iuran Eksplorasi/Produksi Andesit kepmen no. 2338 tahun 1994
Total Biaya Pajak
Keuntungan Bersih
Biaya Reklamasi
Net Cash Flow
Kumulatif Cash Flow
Total
discount rate risk
TAHUN KE-0 TAHUN KE-1 TAHUN KE-2
98,543,287.50 94,223,287.50 89,903,287.50
4,320,000.00 4,320,000.00
4,104,000.00 4,104,000.00
216,000.00 216,000.00
Rp 60,000.00 Rp 60,000.00 Rp 60,000.00
Rp 45,000.00 Rp 45,000.00 Rp 45,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 21,725,505,648.19
Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 1,676.81 Rp 1,760.65
Rp 11,128,695,652.17 Rp 11,128,695,652.17
Rp 6,881,639,374.71 Rp 7,225,721,343.44
Rp 18,010,335,026.88 Rp 18,354,416,995.62
Rp 237,949,664,973.12 Rp 237,605,583,004.38
Rp 12,960,000,000.00 Rp 12,960,000,000.00
Rp 6,607,440,000.00 Rp 6,607,440,000.00
Rp 19,567,440,000.00 Rp 19,567,440,000.00
Rp 218,382,224,973.12 Rp 218,038,143,004.38
Rp 1,500,000,000.00 Rp 2,173,913,043.47 Rp 2,173,913,043.47
-Rp 20,225,505,648.19 Rp 216,208,311,929.65 Rp 215,864,229,960.91
-$20,225,505,648.19 $195,982,806,281.46 $411,847,036,242.38
Rp 58,226,885,941,044.60 211,181,654,868.67
20%

Faktor Diskonto 20% 0.012579115212475 0.01509493825497


CF x FD Rp 2,465,290,299.88 Rp 6,216,805,582.57
NPV 15,841,085,496,206.90

rata-rata variabel 3,020.48


harga jual Rp 200,000.00
Rp 0.02
TAHUN KE 3 TAHUN KE 4 TAHUN KE 5
85,583,287.50 81,263,287.50 76,943,287.50
4,320,000.00 4,320,000.00 4,320,000.00
4,104,000.00 4,104,000.00 4,104,000.00
216,000.00 216,000.00 216,000.00
Rp 60,000.00 Rp 60,000.00 Rp 60,000.00
Rp 45,000.00 Rp 45,000.00 Rp 45,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 1,848.69 Rp 1,941.12 Rp 2,038.18


Rp 11,128,695,652.17 Rp 11,128,695,652.17 Rp 11,128,695,652.17
Rp 7,587,007,410.61 Rp 7,966,357,781.15 Rp 8,364,675,670.20
Rp 18,715,703,062.79 Rp 19,095,053,433.32 Rp 19,493,371,322.38
Rp 237,244,296,937.21 Rp 236,864,946,566.68 Rp 236,466,628,677.62
Rp 12,960,000,000.00 Rp 12,960,000,000.00 Rp 12,960,000,000.00
Rp 6,607,440,000.00 Rp 6,607,440,000.00 Rp 6,607,440,000.00
Rp 19,567,440,000.00 Rp 19,567,440,000.00 Rp 19,567,440,000.00
Rp 217,676,856,937.21 Rp 217,297,506,566.68 Rp 216,899,188,677.62
Rp 2,173,913,043.47 Rp 2,173,913,043.47 Rp 2,173,913,043.47
Rp 215,502,943,893.74 Rp 215,123,593,523.21 Rp 214,725,275,634.15
$627,349,980,136.12 $842,473,573,659.33 $1,057,198,849,293.48

0.018113925905965 0.021736711087157 0.026084053304589


Rp 11,363,771,057.29 Rp 18,312,604,669.20 Rp 27,576,031,138.52
TAHUN KE 6 TAHUN KE 7 TAHUN KE 8
72,623,287.50 68,303,287.50 63,983,287.50
4,320,000.00 4,320,000.00 4,320,000.00
4,104,000.00 4,104,000.00 4,104,000.00
216,000.00 216,000.00 216,000.00
Rp 60,000.00 Rp 60,000.00 Rp 60,000.00
Rp 45,000.00 Rp 45,000.00 Rp 45,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 2,140.09 Rp 2,247.09 Rp 2,359.44


Rp 11,128,695,652.17 Rp 11,128,695,652.17 Rp 11,128,695,652.17
Rp 8,782,909,453.71 Rp 9,222,054,926.40 Rp 9,683,157,672.72
Rp 19,911,605,105.89 Rp 20,350,750,578.57 Rp 20,811,853,324.89
Rp 236,048,394,894.11 Rp 235,609,249,421.43 Rp 235,148,146,675.11
Rp 12,960,000,000.00 Rp 12,960,000,000.00 Rp 12,960,000,000.00
Rp 6,607,440,000.00 Rp 6,607,440,000.00 Rp 6,607,440,000.00
Rp 19,567,440,000.00 Rp 19,567,440,000.00 Rp 19,567,440,000.00
Rp 216,480,954,894.11 Rp 216,041,809,421.43 Rp 215,580,706,675.11
Rp 2,173,913,043.47 Rp 2,173,913,043.47 Rp 2,173,913,043.47
Rp 214,307,041,850.64 Rp 213,867,896,377.96 Rp 213,406,793,631.64
$1,271,505,891,144.13 $1,485,373,787,522.09 $1,698,780,581,153.72

0.031300863965507 0.037561036758608 0.04507324411033


Rp 39,799,232,930.04 Rp 55,792,179,433.39 Rp 76,569,551,824.23
TAHUN KE 9 TAHUN KE 10 TAHUN KE 11
59,663,287.50 55,343,287.50 51,023,287.50
4,320,000.00 4,320,000.00 4,320,000.00
4,104,000.00 4,104,000.00 4,104,000.00
216,000.00 216,000.00 216,000.00
Rp 60,000.00 Rp 60,000.00 Rp 60,000.00
Rp 45,000.00 Rp 45,000.00 Rp 45,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 2,477.42 Rp 2,601.29 Rp 2,731.35


Rp 11,128,695,652.17 Rp 11,128,695,652.17 Rp 11,128,695,652.17
Rp 10,167,315,556.35 Rp 10,675,681,334.17 Rp 11,209,465,400.88
Rp 21,296,011,208.53 Rp 21,804,376,986.35 Rp 22,338,161,053.05
Rp 234,663,988,791.47 Rp 234,155,623,013.66 Rp 233,621,838,946.95
Rp 12,960,000,000.00 Rp 12,960,000,000.00 Rp 12,960,000,000.00
Rp 6,607,440,000.00 Rp 6,607,440,000.00 Rp 6,607,440,000.00
Rp 19,567,440,000.00 Rp 19,567,440,000.00 Rp 19,567,440,000.00
Rp 215,096,548,791.47 Rp 214,588,183,013.66 Rp 214,054,398,946.95
Rp 2,173,913,043.47 Rp 2,173,913,043.47 Rp 2,173,913,043.47
Rp 212,922,635,748.00 Rp 212,414,269,970.19 Rp 211,880,485,903.48
$1,911,703,216,901.73 $2,124,117,486,871.91 $2,335,997,972,775.39

0.054087892932395 0.064905471518875 0.077886565822649


Rp 103,399,998,914.30 Rp 137,866,847,046.91 Rp 181,942,859,868.15
TAHUN KE 12 TAHUN KE 13 TAHUN KE 14
46,703,287.50 42,383,287.50 38,063,287.50
4,320,000.00 4,320,000.00 4,320,000.00
4,104,000.00 4,104,000.00 4,104,000.00
216,000.00 216,000.00 216,000.00
Rp 60,000.00 Rp 60,000.00 Rp 60,000.00
Rp 45,000.00 Rp 45,000.00 Rp 45,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 2,867.92 Rp 3,011.31 Rp 3,161.88


Rp 11,128,695,652.17 Rp 11,128,695,652.17 Rp 11,128,695,652.17
Rp 11,769,938,670.92 Rp 12,358,435,604.47 Rp 12,976,357,384.69
Rp 22,898,634,323.10 Rp 23,487,131,256.64 Rp 24,105,053,036.87
Rp 233,061,365,676.90 Rp 232,472,868,743.36 Rp 231,854,946,963.13
Rp 12,960,000,000.00 Rp 12,960,000,000.00 Rp 12,960,000,000.00
Rp 6,607,440,000.00 Rp 6,607,440,000.00 Rp 6,607,440,000.00
Rp 19,567,440,000.00 Rp 19,567,440,000.00 Rp 19,567,440,000.00
Rp 213,493,925,676.90 Rp 212,905,428,743.36 Rp 212,287,506,963.13
Rp 2,173,913,043.47 Rp 2,173,913,043.47 Rp 2,173,913,043.47
Rp 211,320,012,633.43 Rp 210,731,515,699.89 Rp 210,113,593,919.66
$2,547,317,985,408.82 $2,758,049,501,108.70 $2,968,163,095,028.36

0.093463878987179 0.112156654784615 0.134587985741538


Rp 238,082,219,930.12 Rp 309,333,605,774.73 Rp 399,479,092,312.24
TAHUN KE 15 TAHUN KE 16 TAHUN KE 17
33,743,287.50 29,423,287.50 25,103,287.50
4,320,000.00 4,320,000.00 4,320,000.00
4,104,000.00 4,104,000.00 4,104,000.00
216,000.00 216,000.00 216,000.00
Rp 60,000.00 Rp 60,000.00 Rp 60,000.00
Rp 45,000.00 Rp 45,000.00 Rp 45,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 3,319.97 Rp 3,485.97 Rp 3,660.27


Rp 11,128,695,652.17 Rp 11,128,695,652.17 Rp 11,128,695,652.17
Rp 13,625,175,253.93 Rp 14,306,434,016.63 Rp 15,021,755,717.46
Rp 24,753,870,906.10 Rp 25,435,129,668.80 Rp 26,150,451,369.63
Rp 231,206,129,093.90 Rp 230,524,870,331.20 Rp 229,809,548,630.37
Rp 12,960,000,000.00 Rp 12,960,000,000.00 Rp 12,960,000,000.00
Rp 6,607,440,000.00 Rp 6,607,440,000.00 Rp 6,607,440,000.00
Rp 19,567,440,000.00 Rp 19,567,440,000.00 Rp 19,567,440,000.00
Rp 211,638,689,093.90 Rp 210,957,430,331.20 Rp 210,242,108,630.37
Rp 2,173,913,043.47 Rp 2,173,913,043.47 Rp 2,173,913,043.47
Rp 209,464,776,050.43 Rp 208,783,517,287.73 Rp 208,068,195,586.90
$3,177,627,871,078.79 $3,386,411,388,366.52 $3,594,479,583,953.42

0.161505582889846 0.193806699467815 0.232568039361378


Rp 513,204,641,525.60 Rp 656,309,214,219.54 Rp 835,961,069,364.55
TAHUN KE 18 TAHUN KE 19 TAHUN KE 20
20,783,287.50 16,463,287.50 12,143,287.50
4,320,000.00 4,320,000.00 4,320,000.00
4,104,000.00 4,104,000.00 4,104,000.00
216,000.00 216,000.00 216,000.00
Rp 60,000.00 Rp 60,000.00 Rp 60,000.00
Rp 45,000.00 Rp 45,000.00 Rp 45,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 255,960,000,000.00

Rp 3,843.29 Rp 4,035.45 Rp 4,237.22


Rp 11,128,695,652.17 Rp 11,128,695,652.17 Rp 11,128,695,652.17
Rp 15,772,843,503.33 Rp 16,561,485,678.50 Rp 17,389,559,962.42
Rp 26,901,539,155.50 Rp 27,690,181,330.67 Rp 28,518,255,614.59
Rp 229,058,460,844.50 Rp 228,269,818,669.33 Rp 227,441,744,385.41
Rp 12,960,000,000.00 Rp 12,960,000,000.00 Rp 12,960,000,000.00
Rp 6,607,440,000.00 Rp 6,607,440,000.00 Rp 6,607,440,000.00
Rp 19,567,440,000.00 Rp 19,567,440,000.00 Rp 19,567,440,000.00
Rp 209,491,020,844.50 Rp 208,702,378,669.33 Rp 207,874,304,385.41
Rp 2,173,913,043.47 Rp 2,173,913,043.47 Rp 2,173,913,043.47
Rp 207,317,107,801.03 Rp 206,528,465,625.86 Rp 205,700,391,341.94
$3,801,796,691,754.45 $4,008,325,157,380.31 $4,214,025,548,722.25

0.279081647233653 0.334897976680384 0.401877572016461


Rp 1,061,011,683,182.29 Rp 1,342,379,985,083.75 Rp 1,693,522,355,935.83
TAHUN KE 21 TAHUN KE 22 TAHUN KE 23
7,823,287.50 3,503,287.50 3,503,287.50
4,320,000.00 4,320,000.00 3,503,287.50
4,104,000.00 4,104,000.00 3,328,123.13
216,000.00 216,000.00 175,164.38
Rp 60,000.00 Rp 60,000.00 Rp 60,000.00
Rp 45,000.00 Rp 45,000.00 Rp 45,000.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 207,569,784,375.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 207,569,784,375.00
Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 207,569,784,375.00

Rp 255,960,000,000.00 Rp 255,960,000,000.00 Rp 207,569,784,375.00

Rp 4,449.08 Rp 4,671.54 Rp 4,905.11


Rp 11,128,695,652.17 Rp 11,128,695,652.17 Rp 9,024,773,233.70
Rp 18,259,037,960.54 Rp 19,171,989,858.57 Rp 16,324,824,546.93
Rp 29,387,733,612.72 Rp 30,300,685,510.74 Rp 25,349,597,780.62
Rp 226,572,266,387.29 Rp 225,659,314,489.26 Rp 182,220,186,594.38
Rp 12,960,000,000.00 Rp 12,960,000,000.00 Rp 10,509,862,500.00
Rp 6,607,440,000.00 Rp 6,607,440,000.00 Rp 5,358,278,231.25
Rp 19,567,440,000.00 Rp 19,567,440,000.00 Rp 15,868,140,731.25
Rp 207,004,826,387.29 Rp 206,091,874,489.26 Rp 166,352,045,863.13
Rp 2,173,913,043.47 Rp 2,173,913,043.47 Rp 2,173,913,043.47
Rp 204,830,913,343.82 Rp 203,917,961,445.79 Rp 164,178,132,819.66
$4,418,856,462,066.06 $4,622,774,423,511.85 $4,786,952,556,331.50

0.482253086419753 0.578703703703704 0.694444444444444


Rp 2,131,007,167,277.23 Rp 2,675,216,680,273.06 Rp 3,324,272,608,563.54
Periode Nilai
0 -Rp20,225,505,648.19
5 Rp1,057,198,849,293.48
10 Rp2,124,117,486,871.91
15 Rp3,177,627,871,078.79
20 Rp4,214,025,548,722.25
23 Rp4,786,952,556,331.50
Kumulatif Rp58,226,885,941,044.60
Total Pendapatan Rp 58,226,885,941,044.60
Asumsi Suku Bunga Bank 20%
NPV Rp 58,205,160,435,396.40
IRR 27.18%
Payback Periode Tahun 0.19

You might also like