Scribd
Upload
109 views25 pages

Rincian Biaya Investasi dan Proyeksi Laba

This document lists the components and costs of investment for a construction project. It includes 33 line items for costs such as land, buildings, machinery, furniture, vehicles, and equipment. It provides the quantity, unit price and total price for each item. The total initial investment cost is Rp1,219,559,250. It then provides projections for analysis of profits and losses over 5 years, including revenue, expenses, depreciation, interest, taxes and net income. The net income as a percentage of sales is projected to be 25.55% in year 1.

Uploaded by

Khaerul Irfan
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
109 views25 pages

Rincian Biaya Investasi dan Proyeksi Laba

This document lists the components and costs of investment for a construction project. It includes 33 line items for costs such as land, buildings, machinery, furniture, vehicles, and equipment. It provides the quantity, unit price and total price for each item. The total initial investment cost is Rp1,219,559,250. It then provides projections for analysis of profits and losses over 5 years, including revenue, expenses, depreciation, interest, taxes and net income. The net income as a percentage of sales is projected to be 25.55% in year 1.

Uploaded by

Khaerul Irfan
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

No.

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

Komponen Biaya Investasi


Tanah
Bagian Tertutup
Bagian Terbuka
troli
meja fabrikasi
mesin potong
mesin kompresor
meja ass
meja amplas
generator
meja kerja
komputer
printer
kursi
sofa
meja rapat
meja kantin
bangku
telepon
AC
instalasi listrik + telepon
instalasi air
perlengkapan toilet (toilet duduk + wastafel)
perlengkapan mushola
penerangan
mobil pickup
perlengkapan taman
perlengkapan satpam
Dispenser

Jumlah
929.39
605.39
324
6
1
2
1
1
1
1
6
6
2
17
1
1
2
10
6
1
1
1
3
1
1
1
1
3
6

30
31
32
33

ATK
lemari
Kipas Angin
alat pemadam api

Modal Sendiri 75% (Rp)


Modal Pinjaman 25% (Rp)

5
6
5
2
Total
Rp
Rp

Proyeksi Analisis Rugi

81428669.49
ICF

2105558723.30

Satuan
m2
m2
m2
unit
unit
unit
unit
unit
unit
unit
unit
unit
unit
unit
set
unit
unit
unit
unit
unit
unit
unit
set
set
set
unit
set
set
unit

Harga/unit (Rp)
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

75,000.00
1,500,000
500,000
800,000
300,000
600,000
700,000
300,000
300,000
4,000,000
150,000
2,500,000
300,000
150,000
1,500,000
800,000
300,000
50,000
45,000
2,100,000
1,350,000
1,250,000
250,000
250,000
300,000
35,000,000
200,000
150,000
125,000

Total Harga (Rp)


Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

69,704,250
908,085,000
162,000,000
4,800,000
300,000
1,200,000
700,000
300,000
300,000
4,000,000
900,000
15,000,000
600,000
2,550,000
1,500,000
800,000
600,000
500,000
270,000
2,100,000
1,350,000
1,250,000
750,000
250,000
300,000
35,000,000
200,000
450,000
750,000

set
unit
unit
set

Rp
Rp
Rp
Rp

50,000
250,000
200,000
150,000

Total

Rp
Rp
Rp
Rp
Rp

250,000
1,500,000
1,000,000
300,000
1,219,559,250

Proyeksi Analisis Rugi Laba

TCF

1000984973.30

59.62352551

83.35989
291
405
78
857.35989

Umur (Thn)

Nilai Sisa (Rp)


50
50
10
10
10
10
10
10
10
10
5
5
5
5
5
5
5
5
10
10
10
1
5
3
5
5
2
3

Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

90,808,500
16,200,000
480,000
30,000
120,000
70,000
30,000
30,000
400,000
90,000
1,500,000
60,000
255,000
150,000
80,000
60,000
50,000
27,000
210,000
135,000
125,000
75,000
25,000
30,000
3,500,000
20,000
45,000
75,000

Susut/Thn (Rp)
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

16,345,530
2,916,000
432,000
27,000
108,000
63,000
27,000
27,000
360,000
81,000
2,700,000
108,000
459,000
270,000
144,000
108,000
90,000
48,600
189,000
121,500
112,500
675,000
45,000
90,000
6,300,000
36,000
202,500
225,000

1
5
1

Rp
Rp
Rp
Rp
Rp

25,000
150,000
100,000
30,000
114,985,500

Rp
Rp

225,000
270,000

Rp
270,000
Rp 33,075,630
914,669,437.50
304,889,812.50
###############

60450815.4
48360652.3
36270489.2
24180326.2
12090163.1

ICF
TCF

25.24184214

291

526389680.83

549552867.319

2105558723.30
1000984973.30

149947200

97200000

885999473.3

harga jual

Rp

1,314,454,090.43

HPP/unit

Rp

117,782.62

harga jual/unit

Rp

182,563.07

keuntungan

45%

Komponen Biaya
A. Biaya Tetap
1. PBB
Tanah
Bangunan Tertutup
2. Penyusutan
3. Tenaga Kerja Tak Lgsg Perkantoran
B. Biaya Variabel
Biaya Bahan Langsung
Kaki

Tahun 0

Rp
Rp
Rp

348,521.25
4,540,425.00
33,075,630

Tahun 1

Rp
348,521.25
Rp
4,540,425.00
Rp
33,075,630
Rp 276,000,000.00

Rp
Rp
Rp
Rp
Rp
Rp
Rp

Beton Pendek
Beton Panjang
Reng
List Pendek
List panjang
triplek

43,200,000.00
24,004,800.00
42,004,800.00
11,030,400.00
10,800,000.00
18,907,200.00
23,630,400.00

Biaya Bahan Tak langsung


Paku Besar
Lem Fox
Paku Kecil

Biaya Overhead Pabrik


OMH
Gaji Tenaga Kerja Langsung
Gaji T.K Tak lgsg Non Perkantoran
Total Modal Kerja
Modal Sendiri 75%
Modal Pinjaman 25%

Rp 37,964,576.25
Rp
Rp

Rp 36,000,000.00
Rp 43,200,000.00
Rp 18,000,000.00
Rp 50,000,000.00
Rp
8,092,720.80
Rp 86,400,000.00
Rp 118,800,000.00
Rp 848,034,897.05

Rp
885,999,473.30
Rp 2,105,558,723.30
Rp 1,000,984,973.30

Tahun 2

Tahun 3

Tahun 4

Tahun 5

Rp
348,521.25
Rp
4,540,425.00
Rp
33,075,630
Rp 276,000,000.00

Rp
348,521.25
Rp
4,540,425.00
Rp
33,075,630
Rp 276,000,000.00

Rp
348,521.25
Rp
4,540,425.00
Rp
33,075,630
Rp 276,000,000.00

Rp
348,521.25
Rp
4,540,425.00
Rp
33,075,630
Rp 276,000,000.00

Rp
Rp
Rp
Rp
Rp
Rp
Rp

Rp
Rp
Rp
Rp
Rp
Rp
Rp

Rp
Rp
Rp
Rp
Rp
Rp
Rp

Rp
Rp
Rp
Rp
Rp
Rp
Rp

43,200,000.00
24,004,800.00
42,004,800.00
11,030,400.00
10,800,000.00
18,907,200.00
23,630,400.00

Rp 36,000,000.00
Rp 43,200,000.00
Rp 18,000,000.00
Rp 55,000,000.00
Rp
8,092,720.80
Rp 86,400,000.00
Rp 118,800,000.00
Rp 853,034,897.05

43,200,000.00
24,004,800.00
42,004,800.00
11,030,400.00
10,800,000.00
18,907,200.00
23,630,400.00

Rp 36,000,000.00
Rp 43,200,000.00
Rp 18,000,000.00
Rp 60,500,000.00
Rp
8,092,720.80
Rp 86,400,000.00
Rp 118,800,000.00
Rp 858,534,897.05

43,200,000.00
24,004,800.00
42,004,800.00
11,030,400.00
10,800,000.00
18,907,200.00
23,630,400.00

Rp 36,000,000.00
Rp 43,200,000.00
Rp 18,000,000.00
Rp 66,550,000.00
Rp
8,092,720.80
Rp 86,400,000.00
Rp 118,800,000.00
Rp 864,584,897.05

43,200,000.00
24,004,800.00
42,004,800.00
11,030,400.00
10,800,000.00
18,907,200.00
23,630,400.00

Rp 36,000,000.00
Rp 43,200,000.00
Rp 18,000,000.00
Rp 73,205,000.00
Rp
8,092,720.80
Rp 86,400,000.00
Rp 118,800,000.00
Rp 871,239,897.05
664,499,604.98
221,499,868.33

No.

Komponen Biaya
1
2
3
4
5
6
7
8
9

PBB
Penyusutan
Biaya Bahan Langsung
Biaya Bahan Tidak Langsung
Biaya Overhead Pabrik
OMH
Gaji Tenaga Kerja Tak Langsung Perkantoran
Gaji Tenaga Kerja Langsung
Gaji Tenaga Kerja Tak Langsung Non Perkantoran
Biaya Fabrikasi Total

Biaya (Rp)
4,888,946.25
33,075,630
173,577,600.00
97,200,000.00
50,000,000.00
8,092,720.80
276,000,000.00
86,400,000.00
118,800,000.00
848,034,897.05
848,034,897.05
848,034,897.05
848,034,897.05
848,034,897.05

Harga Pokok Penjualan (HPP)

Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

harga jual
HPP/Unit
harga jual

Rp 1,356,855,835.28
Rp
117,782.62
Rp
188,452.20

10 Ditambah Persediaan WIP 1 Januari (th 1)


Total
Dikurangi Persediaan WIP 31 Desember (th 1)
Harga Pokok Produksi

11 Ditambah Persediaan Barang Jadi 1 Januari (th 1)


Total
Dikurangi Persediaan Barang Jadi 31 Desember (th 1)

Angs. Pokok (Rp)


Bunga Bank (Rp)
TAHUN Hutang Bank (Rp)
Rp 526,389,680.83
0
Rp 421,111,744.66 Rp 105,277,936.17 Rp 57,902,864.89
1
Rp 315,833,808.50 Rp 105,277,936.17 Rp 46,322,291.91
2
Rp 210,555,872.33 Rp 105,277,936.17 Rp 34,741,718.93
3
Rp 105,277,936.17 Rp 105,277,936.17 Rp 23,161,145.96
4
Rp
Rp 105,277,936.17 Rp 11,580,572.98
5

Rp
Rp

241,422,313.69
190,641,041.69

Pembayaran ke Bank (Rp)


Rp
Rp
Rp
Rp
Rp

163,180,801.06
151,600,228.08
140,019,655.10
128,439,082.12
116,858,509.14

No.
1
2
3
4
5
6
7
8
9
10

Komponen Analisis
Total Penjualan
Biaya Produksi (Operasional)
Pendapatan Kotor
Penyusutan Biaya Investasi
Pendapatan (Sebelum Bunga dan Pajak)
Bunga Kredit 11%
Pendapatan (sebelum Pajak)
Pajak
Pendapatan Bersih (setelah Pajak)
Profit on Sales (%)

Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

Tahun 1 (Rp)
1,356,855,835.28
885,999,473.30
470,856,361.98
33,075,630.00
437,780,731.98
57,902,864.89
379,877,867.09
33,152,482.76
346,725,384.33
0.255535905

Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

Tahun 2 (Rp)
1,356,855,835.28
885,999,473.30
470,856,361.98
33,075,630.00
437,780,731.98
46,322,291.91
391,458,440.07
34,310,540.06
357,147,900.01
0.263217278

Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

Tahun 3 (Rp)
1,356,855,835.28
885,999,473.30
470,856,361.98
33,075,630.00
437,780,731.98
34,741,718.93
403,039,013.05
35,468,597.36
367,570,415.69
0.270898651

Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

Tahun 4 (Rp)
1,356,855,835.28
885,999,473.30
470,856,361.98
33,075,630.00
437,780,731.98
23,161,145.96
414,619,586.02
44,769,521.60
369,850,064.42
0.272578748

Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp
Rp

Tahun 5 (Rp)
1,356,855,835.28
885,999,473.30
470,856,361.98
33,075,630.00
437,780,731.98
11,580,572.98
426,200,159.00
45,927,578.90
380,272,580.10
0.280260121

Tahun Ke1
2
3
4
5
ICF
TCF

PROYEKSI PERKIRAAN ALIRAN KAS


Pendapatan Setelah Pajak
Penyusutan
bunga(1 - pajak)
Rp
346,725,384.33 Rp 33,075,630.00 Rp 52,112,578.40
Rp
357,147,900.01 Rp 33,075,630.00 Rp 41,690,062.72
Rp
367,570,415.69 Rp 33,075,630.00 Rp 31,267,547.04
Rp
369,850,064.42 Rp 33,075,630.00 Rp 20,845,031.36
Rp
380,272,580.10 Rp 33,075,630.00 Rp 10,422,515.68
Rp
Rp

2,105,558,723.30
1,000,984,973.30

Rp
Rp
Rp
Rp
Rp

OCF
431,913,592.73
431,913,592.73
431,913,592.73
423,770,725.78
423,770,725.78

Hasil
Rp 1,673,645,130.57
Rp 1,241,731,537.84
Rp 809,817,945.11
Rp 386,047,219.32
Rp
(37,723,506.46)

Tahun ke1
2
3
4
5

ICF

Rp 2,105,558,723.30

OCF
Rp
Rp
Rp
Rp
Rp

431,913,592.73
431,913,592.73
431,913,592.73
423,770,725.78
423,770,725.78

Hasil
Rp 1,673,645,130.57
Rp 1,241,731,537.84
Rp
809,817,945.11
Rp
386,047,219.32
-37723506.46

PERHITUNGAN BREAK EVENT POINT (BEP)

Tahun ke
1
2
3
4
5

Tahun ke
1
2
3
4
5

Rp
Rp
Rp
Rp
Rp

Fixed Cost
37,964,576.25
313,964,576.25
263,424,393.66
263,424,393.66
263,424,393.66

Variabel Cost
Rp 534,070,320.80
Rp 539,070,320.80
Rp 544,570,320.80
Rp 550,620,320.80
Rp 557,275,320.80

Harga jual/unit
Rp 188,452.20
Rp 188,452.20
Rp 188,452.20
Rp 188,452.20
Rp 188,452.20

Rp
Rp
Rp
Rp
Rp

Fixed Cost
37,964,576.25
313,964,576.25
263,424,393.66
263,424,393.66
263,424,393.66

Variabel Cost
Rp 534,070,320.80
Rp 539,070,320.80
Rp 544,570,320.80
Rp 550,620,320.80
Rp 557,275,320.80

Harga jual/unit
Rp 188,452.20
Rp 188,452.20
Rp 188,452.20
Rp 188,452.20
Rp 188,452.20

T POINT (BEP)

BEP unit
332.22
2,764.23
2,334.96
2,352.48
2,372.06

Rp
Rp
Rp
Rp
Rp

BEP rupiah
62,607,393.92
520,924,692.13
440,028,683.67
443,330,663.66
447,020,555.43

Rp
Rp
Rp
Rp
Rp

BEP rupiah
62,607,393.92
520,924,692.13
440,028,683.67
443,330,663.66
447,020,555.43

BEP unit
333
2765
2335
2353
2373

You might also like