Analisa Kelayakan Kingrenov - FINAL BRAND

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 22

Rincian Biaya Investasi Brand Renov

Peralatan
No. Keterangan Banyak Satuan Harga
1 Laptop 5 unit Rp 7,000,000
2 Software 3 unit Rp 1,000,000
3 Handphone 1 unit Rp 3,000,000
4 Papan Tulis 1 unit Rp 850,000
5 Alat Tulis 5 unit Rp 100,000
6 Mesin Printer 2 unit Rp 2,800,000
7 Mesin Fotocopy 1 unit Rp 21,000,000
8 Telepon 1 unit Rp 200,000
9 Steger 20 set Rp 1,500,000
10 Palu 9 bh Rp 50,000
11 Palu Karet 5 bh Rp 10,000
12 Meteran 9 bh Rp 13,000
13 Waterpass 6 bh Rp 65,000
14 Sekop 4 bh Rp 50,000
15 Cangkul 4 bh Rp 50,000
16 Ember 20 bh Rp 30,000
17 Sendok Spesi 10 bh Rp 45,000
18 Kuas 10 bh Rp 9,000
19 Kuas Rol 4 bh Rp 14,000
20 Gergaji 6 bh Rp 40,000
21 Ayakan Agregat 2 bh Rp 40,000
22 Ruskam 6 bh Rp 35,000
23 Kape 10 bh Rp 12,000
24 Gerobak Sorong 2 bh Rp 275,000
25 Sarung Tangan Bintik 20 bh Rp 5,000
26 Selang Air 4 bh Rp 66,000
27 Helm Proyek 15 bh Rp 20,000
28 Mesin Abrasive 1 bh Rp 20,000
29 Gunting Pelat 5 Set Rp 20,000
Total

Bahan
No. Keterangan Banyak Satuan Harga
1 Paku 15 kg Rp 25,000
2 Kayu Kaso 5/7 30 btg Rp 60,000
3 Kayu Papan 2/20 30 btg Rp 65,000
4 Balok 8/15 30 btg Rp 165,000
5 Benang 30 bh Rp 3,000
6 Semen 35 zak Rp 65,000
7 Pasir 40 m3 Rp 275,000
8 Split 35 m3 Rp 240,000
Total

Perlengkapan
No. Keterangan Banyak Satuan Harga
1 Dispenser 1 unit Rp 150,000
2 Karpet 1 bh Rp 200,000
3 Meja Kerja 4 unit Rp 1,200,000
4 Kursi 10 unit Rp 250,000
5 Rak Buku 5 unit Rp 500,000
6 TV 1 unit Rp 3,000,000
Total

Kas Perusahaan
Total Investasi
i Brand Renov

Total
Rp 35,000,000
Rp 3,000,000
Rp 3,000,000
Rp 850,000
Rp 500,000
Rp 5,600,000
Rp 21,000,000
Rp 200,000
Rp 30,000,000
Rp 450,000
Rp 50,000
Rp 117,000
Rp 390,000
Rp 200,000
Rp 200,000
Rp 600,000
Rp 450,000
Rp 90,000
Rp 56,000
Rp 240,000
Rp 50,000
Rp 210,000
Rp 45,000
Rp 550,000
Rp 100,000
Rp 264,000
Rp 300,000
Rp 4,008,000
Rp 100,000
Rp 107,620,000

Total
Rp 375,000
Rp 1,800,000
Rp 1,950,000
Rp 4,950,000
Rp 90,000
Rp 2,275,000
Rp 11,000,000
Rp 8,400,000
Rp 30,840,000

Total
Rp 150,000
Rp 200,000
Rp 4,800,000
Rp 2,500,000
Rp 2,500,000
Rp 3,000,000
Rp 13,150,000

Rp 2,000,000
Rp 153,610,000
BIAYA OPERASIONAL
Biaya Operasional
No Keterangan Banyak Satuan Biaya
1 Sewa Mobil Pick up 1 unit/bln Rp 2,000,000
2 Sewa Kantor 1 unit/bln Rp 2,500,000
Total

Upah
No Keterangan Banyak Satuan Biaya
1 Admin 1 org/bln Rp 2,500,000
2 Keuangan 1 org/bln Rp 2,500,000
3 Drafter 1 org/bln Rp 3,500,000
4 Pengawas 1 org/bln Rp 3,800,000
5 Mandor 1 org/bln Rp 3,200,000
6 Tukang 5 org/bln Rp 3,000,000
7 Pekerja/Knek 9 org/bln Rp 2,800,000
Total

Beban - Beban
No Keterangan Banyak Satuan Biaya
1 Beban Air & Listrik 1 bln Rp 500,000
2 Beban Wi-Fi 1 bln Rp 400,000
2 BBM Mobil Pick up 1 ls Rp 1,500,000
3 Galon 90 gln Rp 7,500
Total

Total Biaya Operasional Per-bulan


ONAL

Total Biaya Per-bulan


Rp 2,000,000
Rp 2,500,000
Rp 4,500,000

Total Biaya Per-bulan


Rp 2,500,000
Rp 2,500,000
Rp 3,500,000
Rp 3,800,000
Rp 3,200,000
Rp 15,000,000
Rp 25,200,000
Rp 55,700,000

Total Biaya Per-bulan


Rp 500,000
Rp 400,000
Rp 1,500,000
Rp 675,000
Rp 3,075,000

Rp 63,275,000
Biaya Marketing
Percetakan
No Keterangan Banyak Sat Biaya Total Biaya Per-bulan
1 Cetak Leaflet 200 lbr/bln Rp 5,000 Rp 1,000,000
2 Cetak Brosur 300 lbr/bln Rp 4,000 Rp 1,200,000
3 Transportasi 1 ls Rp 600,000 Rp 600,000
4 Sosial Media 3 Rp - Rp -
Total Rp 2,800,000
Upah
No Keterangan Banyak Sat Biaya Total Biaya Per-bulan
1 Marketing 1 org/bln Rp 5,000,000 Rp 5,000,000
Total Rp 5,000,000

Total Biaya Marketing Per-bulan Rp 7,800,000


Rincian Laba King Renov

Pemasukan
No Jenis Produk Jumlah Satuan
1 Client 4 /bln
TOTAL

Laba Bersih
No Keterangan Pendapatan Pengeluaran
1 Total Pemasukan 120,000,000.00
2 Biaya Operasional 63,275,000.00
3 Biaya Marketing 7,800,000.00
4 Zakat/Infak 2,5% 3,000,000.000
TOTAL

Presentase Biaya
No Keterangan Presentase Satuan
1 Biaya Operasional 52.73 %
2 Biaya Marketing 6.50 %
3 Zakat/Infak 2,5% 2.50 %
4 Laba Bersih 38.27 %
TOTAL 100.00 %

Bagi Hasil
No Keterangan Persentase Nominal
1 Investor 60.00 27,555,000.00
2 Pengelola 35.00 16,073,750.00
3 Kas/Dana Cadangan 5.00 2,296,250.00
TOTAL 100.00 45,925,000.00

Bagi Hasil
No Keterangan
Per-hari Per-bulan
1 Investor 918,500.00 27,555,000.00
2 Pengelola 535,791.67 16,073,750.00
3 Kas/Dana Cadangan 76,541.67 2,296,250.00

Biaya Investasi = 153,610,000.00


Laba Investor Per-bulan = 27,555,000.00
Break Event Point = 5.575
Modal yang diberikan investor akan kemba
Kesimpulan = waktu tersebut juga investor sudah menda
a King Renov

Biaya Total Biaya


30,000,000.00 120,000,000.00
120,000,000.00

Saldo
120,000,000.00
56,725,000.00
48,925,000.00
45,925,000.00
45,925,000.00

Bagi Hasil
Per-tahun
330,660,000.00
192,885,000.00
27,555,000.00

ang diberikan investor akan kembali dalam jangka waktu 5 bulan 17 hari, dalam
ersebut juga investor sudah mendapatkan keuntungan
Tahun Investasi Biaya Operasi Biaya Marketing

0 Rp 153,610,000.00 -
1 - Rp 759,300,000.00 Rp 93,600,000.00
2 - Rp 759,300,000.00 Rp 93,600,000.00
3 - Rp 759,300,000.00 Rp 93,600,000.00
4 - Rp 759,300,000.00 Rp 93,600,000.00
5 - Rp 759,300,000.00 Rp 93,600,000.00
6 - Rp 759,300,000.00 Rp 93,600,000.00
7 - Rp 759,300,000.00 Rp 93,600,000.00
8 - Rp 759,300,000.00 Rp 93,600,000.00
9 - Rp 759,300,000.00 Rp 93,600,000.00
10 - Rp 759,300,000.00 Rp 93,600,000.00
TOTAL

NPV =
Perhitungan NVP

Biaya Infaq Total Biaya Pendapatan Keuntungan Bersih

Rp 153,610,000.00 - Rp (153,610,000.00)
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
TOTAL

Rp 4,153,979,199.36 > 1
Nilai Sekarang
D.F. 4,75%
Total Biaya Pendapatan Keuntungan Bersih
1.00 Rp 153,610,000.00 - Rp (153,610,000.00)
0.95 Rp 848,591,885.44 Rp 1,374,701,671 Rp 526,109,785.20
0.91 Rp 810,111,585.15 Rp 1,312,364,363 Rp 502,252,778.24
0.87 Rp 773,376,214.94 Rp 1,252,853,808 Rp 479,477,592.59
0.83 Rp 738,306,649.11 Rp 1,196,041,821 Rp 457,735,171.92
0.79 Rp 704,827,349.98 Rp 1,141,806,034 Rp 436,978,684.41
0.76 Rp 672,866,205.23 Rp 1,090,029,627 Rp 417,163,421.87
0.72 Rp 642,354,372.54 Rp 1,040,601,076 Rp 398,246,703.46
0.69 Rp 613,226,131.30 Rp 993,413,915 Rp 380,187,783.73
0.66 Rp 585,418,741.10 Rp 948,366,506 Rp 362,947,764.90
0.63 Rp 558,872,306.54 Rp 905,361,820 Rp 346,489,513.03
Rp 7,101,561,441.32 Rp 11,255,540,641 Rp 4,153,979,199

Usaha Layak
Tahun Investasi Biaya Operasi Biaya Marketing

0 Rp 153,610,000.00 -
1 - Rp 759,300,000.00 Rp 93,600,000.00
2 - Rp 759,300,000.00 Rp 93,600,000.00
3 - Rp 759,300,000.00 Rp 93,600,000.00
4 - Rp 759,300,000.00 Rp 93,600,000.00
5 - Rp 759,300,000.00 Rp 93,600,000.00
6 - Rp 759,300,000.00 Rp 93,600,000.00
7 - Rp 759,300,000.00 Rp 93,600,000.00
8 - Rp 759,300,000.00 Rp 93,600,000.00
9 - Rp 759,300,000.00 Rp 93,600,000.00
10 - Rp 759,300,000.00 Rp 93,600,000.00
TOTAL

Kesimpulan =

Dengan demikian waktu pelunasan investasi tercapai pada tahun pertama, Tepatnya, jangka waktu pe
Perhitungan Payback Period

Biaya Infaq Total Biaya Pendapatan Keuntungan Bersih

Rp 153,610,000.00 - Rp (153,610,000.00)
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
TOTAL

Proyek mampu membayar kembali investasi karena keuntungan bersih (kumulatif) pada tahun
pertama telah mencapai nilai (positif) Rp. 421.759.928

= 0.29
a tahun pertama, Tepatnya, jangka waktu pelunasan adalah
k Period

Nilai Sekarang
D.F. 4,75%
Total Biaya Pendapatan Keuntungan Bersih
1.00 Rp 153,610,000.00 - Rp (153,610,000.00)
0.95 Rp 848,591,885.44 Rp 1,374,701,671 Rp 526,109,785.20
0.91 Rp 810,111,585.15 Rp 1,312,364,363 Rp 502,252,778.24
0.87 Rp 773,376,214.94 Rp 1,252,853,808 Rp 479,477,592.59
0.83 Rp 738,306,649.11 Rp 1,196,041,821 Rp 457,735,171.92
0.79 Rp 704,827,349.98 Rp 1,141,806,034 Rp 436,978,684.41
0.76 Rp 672,866,205.23 Rp 1,090,029,627 Rp 417,163,421.87
0.72 Rp 642,354,372.54 Rp 1,040,601,076 Rp 398,246,703.46
0.69 Rp 613,226,131.30 Rp 993,413,915 Rp 380,187,783.73
0.66 Rp 585,418,741.10 Rp 948,366,506 Rp 362,947,764.90
0.63 Rp 558,872,306.54 Rp 905,361,820 Rp 346,489,513.03
Rp 7,101,561,441.32 Rp 11,255,540,641 Rp 4,153,979,199

an bersih (kumulatif) pada tahun

Tahun → 3 bulan
15 hari
Keuntungan Bersih (Kumulatif)
Rp (153,610,000)
Rp 372,499,785
Rp 874,752,563
Rp 1,354,230,156
Rp 1,811,965,328
Rp 2,248,944,012
Rp 2,666,107,434
Rp 3,064,354,138
Rp 3,444,541,921
Rp 3,807,489,686
Rp 4,153,979,199
Rp 23,645,254,224
Tahun Investasi Biaya Operasi Biaya Marketing

0 Rp 153,610,000.00 -
0 1 - Rp 759,300,000.00 Rp 93,600,000.00
2 - Rp 759,300,000.00 Rp 93,600,000.00
3 - Rp 759,300,000.00 Rp 93,600,000.00
4 - Rp 759,300,000.00 Rp 93,600,000.00
5 - Rp 759,300,000.00 Rp 93,600,000.00
6 - Rp 759,300,000.00 Rp 93,600,000.00
7 - Rp 759,300,000.00 Rp 93,600,000.00
8 - Rp 759,300,000.00 Rp 93,600,000.00
9 - Rp 759,300,000.00 Rp 93,600,000.00
10 - Rp 759,300,000.00 Rp 93,600,000.00
TOTAL

Net BCR =

Gross BCR =
Perhitungan BCR

Biaya Infaq Total Biaya Pendapatan Keuntungan Bersih

Rp 153,610,000.00 - Rp (153,610,000.00)
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
Rp 36,000,000.00 Rp 888,900,000.00 Rp 1,440,000,000.00 Rp 551,100,000.00
TOTAL

Rp 4,307,589,199 = 28.042
Rp 153,610,000

Rp 11,255,540,641 = 1.585
Rp 7,101,561,441.32
Nilai Sekarang
D.F. 4,75%
Total Biaya Pendapatan Keuntungan Bersih
1.00 Rp 153,610,000.00 - Rp (153,610,000.00)
0.95 Rp 848,591,885.44 Rp 1,374,701,671 Rp 526,109,785.20
0.91 Rp 810,111,585.15 Rp 1,312,364,363 Rp 502,252,778.24
0.87 Rp 773,376,214.94 Rp 1,252,853,808 Rp 479,477,592.59
0.83 Rp 738,306,649.11 Rp 1,196,041,821 Rp 457,735,171.92
0.79 Rp 704,827,349.98 Rp 1,141,806,034 Rp 436,978,684.41
0.76 Rp 672,866,205.23 Rp 1,090,029,627 Rp 417,163,421.87
0.72 Rp 642,354,372.54 Rp 1,040,601,076 Rp 398,246,703.46
0.69 Rp 613,226,131.30 Rp 993,413,915 Rp 380,187,783.73
0.66 Rp 585,418,741.10 Rp 948,366,506 Rp 362,947,764.90
0.63 Rp 558,872,306.54 Rp 905,361,820 Rp 346,489,513.03
Rp 7,101,561,441.32 Rp 11,255,540,641 Rp 4,153,979,199

> 1
Usaha Layak

> 1
Usaha Layak
i1 4.75%

Tahun Investasi Biaya Operasi Cost

0 Rp 153,610,000.00 Rp - Rp 153,610,000
1 Rp - Rp 759,300,000 Rp 759,300,000
2 Rp - Rp 759,300,000 Rp 759,300,000
3 Rp - Rp 759,300,000 Rp 759,300,000
4 Rp - Rp 759,300,000 Rp 759,300,000
5 Rp - Rp 759,300,000 Rp 759,300,000
6 Rp - Rp 759,300,000 Rp 759,300,000
7 Rp - Rp 759,300,000 Rp 759,300,000
8 Rp - Rp 759,300,000 Rp 759,300,000
9 Rp - Rp 759,300,000 Rp 759,300,000
10 Rp - Rp 759,300,000 Rp 759,300,000
Total Rp 7,746,610,000

i2 20%

Tahun Investasi Biaya Operasi Cost

0 Rp 153,610,000 Rp - Rp 153,610,000
1 Rp - Rp 759,300,000 Rp 759,300,000
2 Rp - Rp 759,300,000 Rp 759,300,000
3 Rp - Rp 759,300,000 Rp 759,300,000
4 Rp - Rp 759,300,000 Rp 759,300,000
5 Rp - Rp 759,300,000 Rp 759,300,000
6 Rp - Rp 759,300,000 Rp 759,300,000
7 Rp - Rp 759,300,000 Rp 759,300,000
8 Rp - Rp 759,300,000 Rp 759,300,000
9 Rp - Rp 759,300,000 Rp 759,300,000
10 Rp - Rp 759,300,000 Rp 759,300,000
Total Rp 7,746,610,000

NVP 1 = Total Net Benefit NVP 1


= Rp 5,166,977,857

NVP 2 = Total Net Benefit NVP 2


= Rp 2,700,205,749

IRR = i2 + ((Total Net Benefit NVP 2/(Total Net Benefit NVP 1-Total Net Benefit
= 0.367 >
Usaha Layak
Nilai Sekarang
Benefit Net Benefit
Cost Benefit
Rp - Rp (153,610,000) Rp 153,610,000 Rp -
Rp 1,440,000,000.00 Rp 680,700,000 Rp 724,868,735 Rp 1,374,701,671
Rp 1,440,000,000.00 Rp 680,700,000 Rp 691,998,792 Rp 1,312,364,363
Rp 1,440,000,000.00 Rp 680,700,000 Rp 660,619,372 Rp 1,252,853,808
Rp 1,440,000,000.00 Rp 680,700,000 Rp 630,662,885 Rp 1,196,041,821
Rp 1,440,000,000.00 Rp 680,700,000 Rp 602,064,807 Rp 1,141,806,034
Rp 1,440,000,000.00 Rp 680,700,000 Rp 574,763,539 Rp 1,090,029,627
Rp 1,440,000,000.00 Rp 680,700,000 Rp 548,700,276 Rp 1,040,601,076
Rp 1,440,000,000.00 Rp 680,700,000 Rp 523,818,879 Rp 993,413,915
Rp 1,440,000,000.00 Rp 680,700,000 Rp 500,065,756 Rp 948,366,506
Rp 1,440,000,000.00 Rp 680,700,000 Rp 477,389,743 Rp 905,361,820
Rp 14,400,000,000 Rp 6,653,390,000 Rp 6,088,562,784 Rp 11,255,540,641

Nilai Sekarang
Benefit Net Benefit
Cost Benefit
Rp - Rp (153,610,000) Rp 153,610,000 Rp -
Rp 1,440,000,000.00 Rp 680,700,000 Rp 632,750,000 Rp 1,200,000,000
Rp 1,440,000,000.00 Rp 680,700,000 Rp 527,291,667 Rp 1,000,000,000
Rp 1,440,000,000.00 Rp 680,700,000 Rp 439,409,722 Rp 833,333,333
Rp 1,440,000,000.00 Rp 680,700,000 Rp 366,174,769 Rp 694,444,444
Rp 1,440,000,000.00 Rp 680,700,000 Rp 305,145,640 Rp 578,703,704
Rp 1,440,000,000.00 Rp 680,700,000 Rp 254,288,034 Rp 482,253,086
Rp 1,440,000,000.00 Rp 680,700,000 Rp 211,906,695 Rp 401,877,572
Rp 1,440,000,000.00 Rp 680,700,000 Rp 176,588,912 Rp 334,897,977
Rp 1,440,000,000.00 Rp 680,700,000 Rp 147,157,427 Rp 279,081,647
Rp 1,440,000,000.00 Rp 680,700,000 Rp 122,631,189 Rp 232,568,039
Rp 14,400,000,000 Rp 6,653,390,000 Rp 3,336,954,055 Rp 6,037,159,803

(Total Net Benefit NVP 1-Total Net Benefit NVP 2))x(i2-i1))


0.05
ekarang
Net Benefit
Rp (153,610,000)
Rp 649,832,936
Rp 620,365,571
Rp 592,234,435
Rp 565,378,936
Rp 539,741,228
Rp 515,266,088
Rp 491,900,800
Rp 469,595,036
Rp 448,300,750
Rp 427,972,077
Rp 5,166,977,857

ekarang
Net Benefit
Rp (153,610,000)
Rp 567,250,000
Rp 472,708,333
Rp 393,923,611
Rp 328,269,676
Rp 273,558,063
Rp 227,965,053
Rp 189,970,877
Rp 158,309,064
Rp 131,924,220
Rp 109,936,850
Rp 2,700,205,748.63

You might also like