Download - Bisnis Plan Suta Biz Park
-
8/10/2019 Bisnis Plan Suta Biz Park
1/65
-
8/10/2019 Bisnis Plan Suta Biz Park
2/65
= RENCANA PENERIMAAN - RENCANA PENGELUARAN : Rp.
MANAGEMENT FEE
Direktur 5% & Project Manager 5% : Rp.
LABA - MANAGEMENT FEE : Rp.
MODAL
I BIAYA PENGADAAN LAHAN 30%
BIAYA PERIJINAN : 100%
BIAYA PEMATANGAN LAHAN 65%
BIAYA OVER HEAD COST 30%
BIAYA BANGUNAN : 10%
KOMPOSISI PEMBAGIAN LABA
PROSENTASE
INVESTOR : Rp.
PENGELOLA : Rp.
82%
18%
-
8/10/2019 Bisnis Plan Suta Biz Park
3/65
12,408,000,000
2,016,750,000
6,771,000,0008,104,800,000
5,437,200,000
3,458,200,000
1,149,200,000
39,345,150,000
786,903,000
1,967,257,500
42,099,310,500
8,839,733,500
405,492,000
2,646,515,000
400,000,000
153,750,000
873,000,000
122,400,000
322,250,000
45,000,000
-
8/10/2019 Bisnis Plan Suta Biz Park
4/65
9,475,109,500
947,510,950
8,527,598,550
2,842,532,850.00Rp
405,492,000.00Rp
1,720,234,750.00Rp
574,920,000.00Rp
1,472,915,000.00Rp
7,016,094,600.00Rp
KEWAJIBAN RASIO INVESTASI
7,000,000,000 7,000,000,000.00Rp 100%
1,527,598,550 - -
H A K
-
8/10/2019 Bisnis Plan Suta Biz Park
5/65
-
8/10/2019 Bisnis Plan Suta Biz Park
6/65
1.00
-
8/10/2019 Bisnis Plan Suta Biz Park
7/65
-
8/10/2019 Bisnis Plan Suta Biz Park
8/65
-
8/10/2019 Bisnis Plan Suta Biz Park
9/65
39,345,150,000
38,195,950,000
1,149,200,000
-
8/10/2019 Bisnis Plan Suta Biz Park
10/65
ACTION PLANNama Proyek : Suta Biz ParkLokasi : Jl Soekarno Hatta Palembang
Kota : PALEMBANG
A BIAYA PEROLEHAN LAHAN
A.1. Pembelian Lahan
1 Luas Lahan (Brutto) : 15,541 m22 Efektivitas Lahan : 57.98 %
3 Luas Lahan (Netto) : 9,010 m2
4 Harga Lahan Brutto per m2 : Rp. 500,000 /m2
5 Harga Lahan Netto per m2 : Rp. 862,431 /m2
6 Nilai Lahan keseluruhan : Rp. 7,770,500,000
7 Kompensasi dll (jika ada) Rp. 30,000,000
8 Fee Mediator (perantara) : - %9 Nilai Fee Mediator (perantara) : Rp. -
Sub Total A.1 : Rp. 7,800,500,000
A.2. Legal Pembelian Lahan1 Pengecekan Sertipikat : Rp. 500,000
2 AJB PPAT : Rp. 5,000,000
3 Akta PPJB Notariil : Rp. 7,500,0004 Akta Kuasa Menjual : Rp. 1,500,000
5 Akta Kuasa Membangun : Rp. 1,500,000
6 Akta Kuasa Mengurus : Rp. 1,500,000
7 Akta Kuasa Memecahkan Sertipikat : Rp. 1,500,000
8 Akta Pelepasan Hak Notariil : Rp. -
11 Dokumen lain-lain (jika ada) : Rp. 1,000,000
Sub Total A.2 Rp. 20,000,000
A.3. Sertifikasi Lahan
-
8/10/2019 Bisnis Plan Suta Biz Park
11/65
3 Pajak waris Rp. 38,552,500
4 PBB10 th + 1 th kedapan Rp. 169,631,000
5 PPH Rp. 388,525,000
6 BPHTB : Rp. 385,525,000
Sub Total A.4 : Rp. 982,233,500
TOTAL ( A.1 + A.2 + A.3 + A.4 ) : Rp. 8,839,733,500
PEMBEBANAN (A) : Rp. 981,102 /m2
B BIAYA PERIJINANB.1. Perijinan Di Pemerintah Daerah
1 Rekomendasi / Sosialisasi Warga : Rp. 20,000,000
2 Rekomendasi Pengaplingan : Rp. 10,000,000
3 Ijin Lokasi : Rp. 155,410,000
4 Ijin Pemanfaatan Tanah (IPT) / Ijin : Rp. 20,000,000
Penggunaan Ruang (IPR)
5 Rekomendasi Lahan Tanah Makam : Rp. 31,082,0005.a. Pembelian Lahan : Rp. -
5.b. SPH / AJB PPAT : Rp. -
5.c. Kompensasi untuk TPU Warga : Rp. -
5.d. BPHTB : Rp. -
5.e. Serah Terima Lahan Makam : Rp. -
6 Siteplan / Keterangan Rencana Kota : Rp. 35,000,000
7 Peil Banjir (Dinas PSDA) : Rp. 5,000,000
8 Amdal / UKL UPL : Rp. 35,000,0009 Amdal Lalu Lintas : Rp. 10,000,000
10 Rekomendasi khusus (dekat rel, : Rp. 15,000,000
sungai, bandara, dll)
11 Dokumen lain-lain : Rp. 10,000,000
Sub Total B.1 : Rp. 346,492,000
B.2. Perijinan Di Kantor Pertanahan1 Rekomendasi Aspek TGT : Rp. 5,000,000
2 P i ( t i j di R 17 000 000
-
8/10/2019 Bisnis Plan Suta Biz Park
12/65
C BIAYA PEMATANGAN LAHAN
C.1. Infrastruktur1 Striping dan Pembersihan Lahan : Rp. 5,000,0002 Pembebasan Lahan akses masuk : Rp. 280,000,000
3 Cut and Fill : Rp. 1,398,690,000
4 Gerbang Masuk / Pos Jaga : Rp. 15,000,000
5 Sculture (land mark) : Rp. 5,000,000
6 Pagar Kelil ing
5.1. Pagar Panel Beton : Rp. 68,750,000
5.2. Pagar BRC : Rp. -7 Saluran Air Kotor
6.a. Saluran diameter 40 cm : Rp. -
6.b. Saluran diameter 60 cm : Rp. -
6.c. Saluran diameter 80 cm : Rp. -
6.d. Saluran diameter 100cm : Rp. 65,625,000
8 Jalan Lingkungan
7.1. Aspal penetrasi : Rp. -
7.2. Aspal Hotmix : Rp. -
7.3. Beton K225 : Rp. 338,100,000
9 Kansteen : Rp. 10,200,000
10 Deucker (crossing saluran) : Rp. 82,000,000
11 Taman Berm dan Pohon Peneduh : Rp. 24,000,000
12 Taman Lingkungan : Rp. 30,000,000
13 Dinding Penahan Tanah (Talud) : Rp. -
14 Stree Furniture : Rp. 10,000,000
15 Lain - Lain (biaya tak terduga) : Rp. 15,000,000
Sub Total C.1 : Rp. 2,347,365,000
C.2. Utilitas1 Jaringan Listrik Induk :
1.a. Gardu Induk : Rp.
1.b. Perijinan 98000 w : Rp. 95,000,000
1.c. Tiang dan JT Menengah (JTM) : Rp. 5,000,0001.d. Tiang dan JT Rendah (JTR) : Rp. -
1.e. PJU (Penerangan Jalan Umum) : Rp. 17,500,000
2 Jaringan Air Bersih Induk : Rp 18 400 000
-
8/10/2019 Bisnis Plan Suta Biz Park
13/65
5 Kolam Renang : Rp. -
6 centre plant : Rp. 20,000,000
7 Operasional dan pemeliharaan : Rp. 12,000,000
8 Lain - lain : Rp. -
Sub Total C.3 : Rp. 92,000,000
C.4. Pemeliharaan dan Pembinaan Lingkungan1 Pembinaan Lingkungan (Polsek, : Rp. 15,000,000
Danramil, Kelurahan, Preman dll)
2 Petugas Kebersihan (sampah) : Rp. 11,250,000
3 Petugas Keamanan (satpam) : Rp. 22,500,000
4 Tukang Taman : Rp. 22,500,000
5 Lain - lain : Rp. -
Sub Total C.4 : Rp. 71,250,000
TOTAL ( C.1 + C.2 + C.3 + C.4 ) : Rp. 2,646,515,000
PEMBEBANAN (C) : Rp. 293,731 /m2
D BIAYA DIBAYAR DIMUKA (OHC)
D.1. Persiapan Kantor dan Inventaris1 Sewa Tempat Untuk Kantor : Rp. 50,000,000
2 Perbaikan Dan Renovasi : Rp. 5,000,000
3 Partisi, Panel, dan Backdrop : Rp. 10,000,000
4 Perlengkapan Kantor :4.1. Meja, kursi, lemari, dll : Rp. 15,000,000
4.2. Komputer, printer, fax, UPS, dll : Rp. 60,000,000
4.3. AC, kipas angin, dll : Rp. 6,000,000
4.4. Lain-lain : Rp. 1,000,000
5 Mobil, sepeda motor, sepeda : Rp. 250,000,000
6 Lain - lain : Rp. 3,000,000
Sub Total D.1 : Rp. 400,000,000
D.2. Operasional Kantor
-
8/10/2019 Bisnis Plan Suta Biz Park
14/65
3 Finance Accounting & Tax Officer : Rp. 90,000,000 9,989
4 Staf Finance Accounting & Tax : Rp. 52,500,000 5,827
5 Project Officer : Rp. 90,000,000 9,989
6 Staf Project : Rp. 52,500,000 5,827
7 Marketing Officer : Rp. 90,000,000 9,989
8 Sales A : Rp. 45,000,000 -9 Sales B : Rp. 45,000,000 -
10 General Affair / Office Boy : Rp. 33,000,000 3,663
Sub Total D.3 : Rp. 873,000,000
D.4. Bonus Karyawan1 Direktur : Rp. - -
2 Project Manager : Rp. - -
3 Finance Accounting & Tax Officer : Rp. 27,000,000 2,997
4 Staf Finance Accounting & Tax : Rp. 15,750,000 1,748
5 Project Officer : Rp. 27,000,000 2,997
6 Staf Project : Rp. 15,750,000 1,748
7 Marketing Officer : Rp. 27,000,000 2,997
8 Sales A : Rp. - -
9 Sales B : Rp. - -
10 General Affair / Office Boy : Rp. 9,900,000 1,099
Sub Total D.4 : Rp. 122,400,000
D.5. Promosi1 Cetak Brosur, Flyer, Leaflet : Rp. 75,000,000
2 Billboard, Signboard : Rp. 60,000,000
3 Iklan di surat kabar : Rp. 82,500,000
4 Pameran : Rp. 36,000,000
5 Spanduk : Rp. 18,750,000
6 Event, Open House dll : Rp. 40,000,000
7 Lain - Lain : Rp. 10,000,000
Sub Total D.5 : Rp. 322,250,000
D.6. Kesejahteraan1 Asuransi Kesehatan : Rp. 5,000,000
2 Training, Outbond, Team Building : Rp. 25,000,000
3 Sumbangan sumbangan : Rp. 15,000,000
-
8/10/2019 Bisnis Plan Suta Biz Park
15/65
E.1. Pinjaman Pemegang Saham (Share Holder Loan)1 Bunga Pinjaman : Rp. 53,000,000
2 Lain - Lain : Rp. -
Sub Total E.1 : Rp. 53,000,000
E.2. Kredit Dari Perbankan1 Biaya Apraisal : Rp. 10,000,000
2 Biaya Pembuatan Neraca L/R : Rp. 5,000,000
3 Provisi, Administrasi : Rp. 20,000,000
4 Biaya Akta Notariil dll : Rp. 7,500,000
5 Bunga Pinjaman : Rp. 47,250,000
Sub Total E.2 : Rp. 89,750,000
TOTAL ( E.1 + E.2 ) : Rp. 142,750,000
PEMBEBANAN (E) : Rp. 15,844 /m2
R E K A P I T U L A S I ;
A BIAYA PEROLEHAN LAHAN 981,102 /m2
B BIAYA PERIJINAN 45,005 /m2
C BIAYA PEMATANGAN LAHAN 293,731 /m2
D BIAYA DIBAYAR DIMUKA (OHC) 212,697 /m2
E BIAYA BUNGA 15,844 /m2
Rp. 1,548,379 /m2
Rp. 1,051,621 /m2
HARGA POKOK TANAH (HPT)
TARGET LABA
-
8/10/2019 Bisnis Plan Suta Biz Park
16/65
-
8/10/2019 Bisnis Plan Suta Biz Park
17/65
-
8/10/2019 Bisnis Plan Suta Biz Park
18/65
Volume Satuan Harga Sub Total
Satuan
1.00 ls 5,000,000 5,000,000
700 m2 400,000 280,000,000
9,325 m2 150,000 1,398,690,000
1.00 ls 15,000,000 15,000,000
1.00 ls 5,000,000 5,000,000
250.00 m1 275,000 68,750,000
m1 225,000 -
m1 40,000 -
m1 60,000 -
m1 80,000 -
375.00 m1 175,000 65,625,000
- m2 - -
- m2 - -
169 m3 2,000,000 338,100,000
510.00 m1 20,000 10,200,000
410.00 m2 200,000 82,000,000
400.00 ls 60,000 24,000,000
400.00 ls 75,000 30,000,000
m3 500,000 -
1.00 ls 10,000,000 10,000,000
1.00 ls 15,000,000 15,000,000
Volume Satuan Harga Sub Total
Satuan
1.00 unit 8,000,000 8,000,000
1.00 unit 45,000,000 45,000,000
11.00 tiang 3,500,000 38,500,000
- tiang - -
10.00 titik 1,750,000 17,500,000
460 00 m1 40 000 18 400 000
-
8/10/2019 Bisnis Plan Suta Biz Park
19/65
Volume Satuan Harga Sub Total
Satuan
15.00 bulan 1,000,000 15,000,000
15.00 bulan 750,000 11,250,000
15.00 bulan 1,500,000 22,500,000
15.00 bulan 1,500,000 22,500,000
- bulan - -
Volume Satuan Harga Sub Total
Satuan
-
8/10/2019 Bisnis Plan Suta Biz Park
20/65
-
8/10/2019 Bisnis Plan Suta Biz Park
21/65
Rate Besar Modal Kerja
12 % 1,000,000,000
Rate Nilai Kredit Konstruksi
19 % 3,000,000
37.73 % 8,839,733,500
1.73 % 405,492,000
11.30 % 2,646,515,000
8.18 % 1,916,400,000
0.61 % 142,750,000
13,950,890,500
40.45 %
-
8/10/2019 Bisnis Plan Suta Biz Park
22/65
-
8/10/2019 Bisnis Plan Suta Biz Park
23/65
-
8/10/2019 Bisnis Plan Suta Biz Park
24/65
Keterangan
Keterangan
-
8/10/2019 Bisnis Plan Suta Biz Park
25/65
Keterangan
Keterangan
-
8/10/2019 Bisnis Plan Suta Biz Park
26/65
Keterangan
Keterangan
-
8/10/2019 Bisnis Plan Suta Biz Park
27/65
HITUNG HARGA JUAL
LUAS HARGA SUB TOTAL LUAS HARGA
BANG SATUAN HARGA TANAH SATUANBANG BANGUNAN TANAH
GRADE I aBAGUNAN PERTOKOAN
1 RUKO
TYPE A 120.00 2,250,000 270,000,000 100.00 2,080,000
TYPE B 145.00 2,250,000 326,250,000 120.00 2,080,000
BANGUNAN PERGUDANGAN1 Type Varian A 570.00 1,300,000 741,000,000 570.00 2,080,000
2 Type Varian B 684.00 1,300,000 889,200,000 684.00 2,080,000
3 Type Varian C 456.00 1,300,000 592,800,000 456.00 2,080,000
4 Type Varian D 878.00 1,300,000 1,141,400,000 878.00 2,080,000
LUAS HARGA SUB TOTAL LUAS HARGABANG SATUAN HARGA TANAH SATUAN
BANG BANGUNAN TANAH
GRADE II aBANGUNAN PERTOKOAN
1 RUKO
TYPE A 120.00 2,250,000 270,000,000 100.00 2,340,000
TYPE B 145.00 2,250,000 326,250,000 120.00 2,340,000
BANGUNAN PERGUDANGAN
1 Type Varian A 570.00 1,300,000 741,000,000 570.00 2,340,000
2 Type Varian B 684.00 1,300,000 889,200,000 684.00 2,340,000
3 Type Varian C 456.00 1,300,000 592,800,000 456.00 2,340,000
4 Type Varian D 878.00 1,300,000 1,141,400,000 878.00 2,340,000
LUAS HARGA SUB TOTAL LUAS HARGA
BANG SATUAN HARGA TANAH SATUAN
-
8/10/2019 Bisnis Plan Suta Biz Park
28/65
3 Type Varian C 456.00 1,300,000 592,800,000 456.00 2,600,000
4 Type Varian D 878.00 1,300,000 1,141,400,000 878.00 2,600,000
4,428.00
LUAS HARGA SUB TOTAL LUAS HARGA
BANG SATUAN HARGA TANAH SATUAN
BANG BANGUNAN TANAH
GRADE IV aBANGUNAN PERTOKOAN
1 RUKO
TYPE A 120.00 2,250,000 270,000,000 100.00 2,860,000
TYPE B 145.00 2,250,000 326,250,000 120.00 2,860,000
BANGUNAN PERGUDANGAN
1 Type Varian A 570.00 1,300,000 741,000,000 570.00 2,860,000
2 Type Varian B 684.00 1,300,000 889,200,000 684.00 2,860,000
3 Type Varian C 456.00 1,300,000 592,800,000 456.00 2,860,000
4 Type Varian D 878.00 1,300,000 1,141,400,000 878.00 2,860,000
LUAS HARGA SUB TOTAL LUAS HARGA
BANG SATUAN HARGA TANAH SATUAN
BANG BANGUNAN TANAH
GRADE V aBANGUNAN PERTOKOAN
1 RUKO
TYPE A 120.00 2,250,000 270,000,000 100.00 3,120,000
TYPE B 145.00 2,250,000 326,250,000 120.00 3,120,000
BANGUNAN PERUMAHAN
1 Type Varian A 570.00 1,300,000 741,000,000 570.00 3,120,000
2 Type Varian B 684.00 1,300,000 889,200,000 684.00 3,120,000
3 Type Varian C 456.00 1,300,000 592,800,000 456.00 3,120,000
4 Type Varian D 878.00 1,300,000 1,141,400,000 878.00 3,120,000
-
8/10/2019 Bisnis Plan Suta Biz Park
29/65
SUB TOTAL LAIN LAIN TOTAL UP 2% UP 5%
HARGA GIMMICK PPH FINAL
TANAH
b c a + b + c
208,000,000 34,000,000 512,000,000 10,240,000 25,600,000
249,600,000 34,000,000 609,850,000 12,197,000 30,492,500
1,185,600,000 34,000,000 1,960,600,000 39,212,000 98,030,000
1,422,720,000 34,000,000 2,345,920,000 46,918,400 117,296,000
948,480,000 34,000,000 1,575,280,000 31,505,600 78,764,000
1,826,240,000 34,000,000 3,001,640,000 60,032,800 150,082,000
SUB TOTAL LAIN LAIN TOTAL UP 2% UP 5%HARGA GIMMICK PPH FINAL
TANAH
b c a + b + c
234,000,000 34,000,000 538,000,000 10,760,000 26,900,000
280,800,000 34,000,000 641,050,000 12,821,000 32,052,500
1,333,800,000 34,000,000 2,108,800,000 42,176,000 105,440,000
1,600,560,000 34,000,000 2,523,760,000 50,475,200 126,188,000
1,067,040,000 34,000,000 1,693,840,000 33,876,800 84,692,000
2,054,520,000 34,000,000 3,229,920,000 64,598,400 161,496,000
SUB TOTAL LAIN LAIN TOTAL UP 2% UP 5%
HARGA GIMMICK PPH FINAL
-
8/10/2019 Bisnis Plan Suta Biz Park
30/65
1,185,600,000 34,000,000 1,812,400,000 36,248,000 90,620,000
2,282,800,000 34,000,000 3,458,200,000 69,164,000 172,910,000
SUB TOTAL LAIN LAIN TOTAL UP 2% UP 5%
HARGA GIMMICK PPH FINAL
TANAH
b c a + b + c
286,000,000 34,000,000 590,000,000 11,800,000 29,500,000
343,200,000 34,000,000 703,450,000 14,069,000 35,172,500
1,630,200,000 34,000,000 2,405,200,000 48,104,000 120,260,000
1,956,240,000 34,000,000 2,879,440,000 57,588,800 143,972,000
1,304,160,000 34,000,000 1,930,960,000 38,619,200 96,548,000
2,511,080,000 34,000,000 3,686,480,000 73,729,600 184,324,000
SUB TOTAL LAIN LAIN TOTAL UP 2% UP 5%
HARGA GIMMICK PPH FINAL
TANAH
b c a + b + c
312,000,000 34,000,000 616,000,000 12,320,000 30,800,000
374,400,000 34,000,000 734,650,000 14,693,000 36,732,500
1,778,400,000 34,000,000 2,553,400,000 51,068,000 127,670,000
2,134,080,000 34,000,000 3,057,280,000 61,145,600 152,864,000
1,422,720,000 34,000,000 2,049,520,000 40,990,400 102,476,000
2,739,360,000 34,000,000 3,914,760,000 78,295,200 195,738,000
-
8/10/2019 Bisnis Plan Suta Biz Park
31/65
GRAND TOTAL PPN HARGA + HARGA +
HARGA 10% PPN 10% PPN 10%
(Pembulatan)
547,840,000 54,784,000 602,624,000 602,600,000 300.00
652,539,500 65,253,950 717,793,450 717,800,000 120.00
-
-2,097,842,000 209,784,200 2,307,626,200 2,307,600,000 -
2,510,134,400 251,013,440 2,761,147,840 2,761,100,000 -
1,685,549,600 168,554,960 1,854,104,560 1,854,100,000 456.00
3,211,754,800 321,175,480 3,532,930,280 3,532,900,000 -
876.00
GRAND TOTAL PPN HARGA + HARGA +HARGA 10% PPN 10% PPN 10%
(Pembulatan)
575,660,000 57,566,000 633,226,000 633,200,000 300.00
685,923,500 68,592,350 754,515,850 754,500,000 -
--
2,256,416,000 225,641,600 2,482,057,600 2,482,100,000 570.00
2,700,423,200 270,042,320 2,970,465,520 2,970,500,000 -
1,812,408,800 181,240,880 1,993,649,680 1,993,600,000 -
3,456,014,400 345,601,440 3,801,615,840 3,801,600,000 -
870.00
GRAND TOTAL PPN HARGA + HARGA +
HARGA 10% PPN 10% PPN 10%
-
8/10/2019 Bisnis Plan Suta Biz Park
32/65
1,939,268,000 193,926,800 2,133,194,800 2,133,200,000 456.00
3,700,274,000 370,027,400 4,070,301,400 4,070,300,000 878.00
5,462.00
GRAND TOTAL PPN HARGA + HARGA +
HARGA 10% PPN 10% PPN 10%
(Pembulatan)
631,300,000 63,130,000 694,430,000 694,400,000
752,691,500 75,269,150 827,960,650 828,000,000 120.00
-
-
2,573,564,000 257,356,400 2,830,920,400 2,830,900,000 -
3,081,000,800 308,100,080 3,389,100,880 3,389,100,000 684.00
2,066,127,200 206,612,720 2,272,739,920 2,272,700,000 -
3,944,533,600 394,453,360 4,338,986,960 4,339,000,000
804.00
GRAND TOTAL PPN HARGA + HARGA +
HARGA 10% PPN 10% PPN 10%
(Pembulatan)
659,120,000 65,912,000 725,032,000 725,000,000 100.00
786,075,500 78,607,550 864,683,050 864,700,000 -
-
-
2,732,138,000 273,213,800 3,005,351,800 3,005,400,000 -
3,271,289,600 327,128,960 3,598,418,560 3,598,400,000 -
2,192,986,400 219,298,640 2,412,285,040 2,412,300,000 456.00
4,188,793,200 418,879,320 4,607,672,520 4,607,700,000 -
556.00
-
8/10/2019 Bisnis Plan Suta Biz Park
33/65
3 1,536,000,000
1 609,850,000
1 1,575,280,000
3 1,614,000,000
1 2,108,800,000
-
8/10/2019 Bisnis Plan Suta Biz Park
34/65
1 1,812,400,000
1 3,458,200,000
100,129,200,000
0
1 703,450,000
0 -
1 2,879,440,000
1 616,000,000
0
0
0
1 2,049,520,000
0
35 12 226 000 000
-
8/10/2019 Bisnis Plan Suta Biz Park
35/65
N O T A S I : Perlu diisi
: Sudah memakai formula
Sudah memakai formula
: Sudah memakai formula
: FONT Tidak masuk penjumlahan
: FONT Masuk penjumlahan
Nama Proyek : SUTA BIZ PARK
Lokasi : JL SOEKARNO HATTA
Kota : PALEMBANG
F OMSET BANGUNAN
F.1. Bangunan Komersial
Type Harga Harga Borongan Jumlah Sub Total
R U K O Satuan 1 unit Unit Omset Bangunan
1 Ruko TYPE A 120.00 2,250,000 270,000,000 22 5,940,000,000
2 Ruko TYPE B 145.00 2,250,000 326,250,000 3 978,750,000
Sub Total 25
Sub Total F.1 Rp. 6,918,750,000
Ukuran
-
8/10/2019 Bisnis Plan Suta Biz Park
36/65
F.2. Bangunan gudang
Type Harga Harga Borongan Jumlah Sub Total
gudang Satuan 1 unit Unit Omset Bangunan
1 gudang A 570.00 1,300,000 741,000,000 3 2,223,000,000
2 gudang B 684.00 1,300,000 889,200,000 3 2,667,600,0003 gudang C 456.00 1,300,000 592,800,000 3 1,778,400,000
4 gudang D 878.00 1,300,000 1,141,400,000 1 1,141,400,000
Sub Total 10
Sub Total F.2 Rp. 7,810,400,000
TOTAL ( F.1 + F.2 ) Rp. 14,729,150,000
OMSET (F) Rp.
G OMSET TANAH
HARGA JUAL TANAH RATA - RATA / m2
GRADUAL 10.0 %
GRADE HARGA JUAL
I 2,080,000 901 m2
0.8
II 2,340,000 901 m2
0.9III 2,600,000 5,406 m2 Harga rata-rata
IV 2,860,000 901 m2
1.1
V 3,120,000 901 m2
1.2
Ukuran
14,729,150,000
2,108,340,000
14,055,600,000
2,576,860,000
2,811,120,000
2,600,000
LUAS OMSET TANAH
1,874,080,000
-
8/10/2019 Bisnis Plan Suta Biz Park
37/65
T O T A L 9,010 m2
OMSET (G) Rp.
H OMSET LAIN LAIN
Pembebanan Per Unit Bangunan1 Biaya Sambung Listrik (PLN) 10,000,000
2 Biaya Sambung Air Bersih [ ] PDAM [ ] Sumur + Pompa 3,000,000
3 Biaya Spl itsing Sertipikat 2,250,000
4 Biaya IMB (incl. Retribusinya) 3,000,000
5 Biaya Extra Provisi (pengurusan KPR) 1,000,000
6 Fee Sales / Mediator 14,000,000
7 Biaya Maintenance (sebelum STB) 500,000 13,139,5838 Biaya Pembuatan Perabot Rumah Contoh -
9 Biaya Pembuatan Taman Halaman Depan -
10 Biaya Desain 250,000
BIAYA PER UNIT BANGUNAN 34,000,000
JUMLAH UNIT BANGUNAN 35
OMSET (H) Rp.
R E K A P I T U L A S I ;
F OMSET BANGUNAN
G OMSET TANAH
1,190,000,000
14,729,150,000
23,426,000,000
23,426,000,000
23,426,000,000
-
8/10/2019 Bisnis Plan Suta Biz Park
38/65
H OMSET LAIN LAIN
CHECK AND BALANCE
1
TARGET LABA : 24.08 %
TOTAL OMSET :
2
TOTAL OHC : 4.87 %
TOTAL OMSET :
3
HARGA PEROLEHAN : 5.20 x
HARGA JUAL :
1,916,400,000
39,345,150,000
500,000
2,600,000
TOTAL OMSET 39,345,150,000
9,475,109,500
39,345,150,000
1,190,000,000
-
8/10/2019 Bisnis Plan Suta Biz Park
39/65
-
8/10/2019 Bisnis Plan Suta Biz Park
40/65
-
8/10/2019 Bisnis Plan Suta Biz Park
41/65
-
8/10/2019 Bisnis Plan Suta Biz Park
42/65
39,345,150,000
PROYEKSI PENJUALAN
-
8/10/2019 Bisnis Plan Suta Biz Park
43/65
PROYEKSI PENJUALANJumlah Luas Luas
Unit Bang Tanah Des Jan Feb Mar Apr Mei Jun Jul Agu Sep Okt Nov Des Jan
1 2 3 4 5 6 7 8 9 10 11 12 13 14
A Bangunan Pertokoan
- Ruko TYPE A 22 120.00 100.00 0 0 0 3 3 3 3 3 3 3 1 0 0 0
- Ruko TYPE B 3 145.00 120.00 0 0 0 1 1 1 0 0 0 0 0 0 0 0
B Bangunan Pergudangan
Gudang Type A 3 570.00 570.00 0 0 0 1 0 0 0 0 1 0 1 0 0 0
Gudang Type B 3 684.00 684.00 0 0 0 0 1 0 0 0 0 1 1 0 0 0
Gudang Type C 3 456.00 456.00 0 0 0 0 0 1 1 1 0 0 0 0 0 0
Gudang Type D 1 878.00 878.00 0 0 0 0 0 0 0 0 0 0 0 0 1 0
35 0 0 0 5 5 5 4 4 4 4 3 0 1 0
A Bangunan pertokoan Harga Jual (exc PPN)
- Ruko TYPE A 22 120.00 100.00
- Ruko TYPE B 3 145.00 120.00
B Bangunan Pergudangan
- Gudang TYPE A 3 570.00 570.00
- Gudang TYPE B 3 684.00 684.00
- Gudang TYPE C 3 456.00 456.00
- Gudang TYPE D 1 878.00 878.00
PROYEKSI OMSET PENJUALAN
1 Desember
2 Januari
3 Februari
- Gudang TYPE D
-
-
-
- Gudang TYPE C
-
-
-
564,000,000
672,250,000
2,257,000,000
2,701,600,000
- Ruko TYPE A
-
1,812,400,000
3,458,200,000
-
-
- Ruko TYPE B
-
-
-
- Gudang TYPE A
-
-
-
- Gudang TYPE B
-
-
-
4 Maret 1 692 000 000 672 250 000 2 257 000 000
-
8/10/2019 Bisnis Plan Suta Biz Park
44/65
4 Maret
5 April
6 Mei
7 Juni
8 Juli
9 Agustus10 September
11 Oktober
12 November
13 Desember
14 Januari
15 Februari
PROYEKSI BUKA SPK BANGUNAN
1 Desember
2 Januari
3 Februari
4 Maret
5 April
6 Mei
7 Juni
8 Juli9 Agustus
10 September
11 Oktober
12 November
13 Desember
14 Januari
15 Februari
-
-
1,778,400,000 1,141,400,000
--
-
-
-
1,141,400,000
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
592,800,000
592,800,000
-
5,437,200,000 3,458,200,000
- Gudang TYPE C - Gudang TYPE D
- -
-
--
-
-
3,458,200,000
-
-
-
-
-
-
1,812,400,000
1,812,400,000
1,812,400,000
--
-
-
-
1,692,000,000
1,692,000,000
-
672,250,000
672,250,000
1,692,000,000
1,692,000,000
1,692,000,000
--
-
-
-
-
1,692,000,0001,692,000,000
564,000,000
-
2,257,000,000
-
672,250,000
-
-
-
-
-
2,257,000,000-
2,257,000,000
-
-
-
-
6,771,000,00012,408,000,000 2,016,750,000
-
-
-
2,701,600,000
2,701,600,000
-
2,701,600,000
8,104,800,000
-
-
-
-
-
-
-
-
-
-
-
- Ruko TYPE A - Ruko TYPE B - Gudang TYPE A - Gudang TYPE B
- -
- - - -
- - - -
- -
810,000,000 326,250,000 741,000,000 -
- -
810,000,000 326,250,000 - 889,200,000
810,000,000 - - -
810,000,000 326,250,000
810,000,000 - - - 592,800,000-
- 889,200,000
810,000,000 - 741,000,000 -
270,000,000 - 741,000,000 889,200,000
810,000,000 -
- - - -
- -
- - - -
- - - -
- -
5,940,000,000 978,750,000 2,223,000,000 2,667,600,000
-
8/10/2019 Bisnis Plan Suta Biz Park
45/65
Feb TOTAL Des Jan Feb Mar Apr
15 1 2 3 4 5
0 22 - - - 300 300-
0 3 - - - 120 120
-
-
0 3 - - - 570 -
-
0 3 - - - - 684
-
0 3 -
-0 1 -
-
-
0 35 - - - 990 1,104
-
- - - 396,000,000 441,600,000
- - - - -
- - - 396,000,000 441,600,000
-
-
-
SUB TOTAL Kelebihan Tanah
- -
-
T O T A L
- -
-
4,621,250,000 143,000,000 4,764,250,000
-
8/10/2019 Bisnis Plan Suta Biz Park
46/65
4,621,250,000
5,065,850,000
4,176,650,000
3,458,200,000
-
-
38,195,950,000
3,504,400,000
3,504,400,000
3,949,000,0004,393,600,000
5,522,600,000
-
143,000,000
-
-
-
1,006,200,000-
-
-
-
1,149,200,000
4,764,250,000
5,065,850,000
4,176,650,000
3,504,400,000
3,504,400,000
4,955,200,0004,393,600,000
5,522,600,000
-
3,458,200,000
-
-
39,345,150,000
- -
SUB TOTAL
- -
T O T A L
-
-
- - -
- 2,025,450,000
1,877,250,000 -
1,729,050,000 -
1,877,250,000
2,025,450,000
1,729,050,000
1,402,800,000 - 1,402,800,000
- 1,551,000,0001,402,800,000 -
1,699,200,000 -
1,402,800,0001,551,000,000
1,699,200,000
1,900,200,000 - 1,900,200,000
- 1,141,400,000
- -
- -
-
1,141,400,000
-
- - -
14,729,150,00014,729,150,000 -
-
8/10/2019 Bisnis Plan Suta Biz Park
47/65
1,692,000,000 672,250,000 2,257,000,000 - 4,621,250,000
-
8/10/2019 Bisnis Plan Suta Biz Park
48/65
1,692,000,000 672,250,000 - 2,701,600,000 5,065,850,000
1,692,000,000 672,250,000 - - 4,176,650,000
1,692,000,000 - - - 3,504,400,000
1,692,000,000 - - - 3,504,400,000
1,692,000,000 - 2,257,000,000 - 3,949,000,000
1,692,000,000 - - 2,701,600,000 4,393,600,000
564,000,000 - 2,257,000,000 2,701,600,000 5,522,600,000
- - - - -
- - - - 3,458,200,000
- - - - -
- - - - -
12,408,000,000 2,016,750,000 6,771,000,000 8,104,800,000 38,195,950,000
-
8/10/2019 Bisnis Plan Suta Biz Park
49/65
TOTAL
8,568 3,427,200,000
210 84,000,000
3,427,200,000
- 36,000,000
3,427,200,000
- -
- -
- -
143,000,000 4,764,250,000
-
8/10/2019 Bisnis Plan Suta Biz Park
50/65
- 5,065,850,000
- 4,176,650,000
- 3,504,400,000
- 3,504,400,000
1,006,200,000 4,955,200,000
- 4,393,600,000
- 5,522,600,000
- -
- 3,458,200,000
- -
- -
1,149,200,000 39,345,150,000 39,345,150,000
1,149,200,000
114,920,000
-
8/10/2019 Bisnis Plan Suta Biz Park
51/65
BUDGET BIAYA LAIN LAINJul Agt Sep
1 2 3
- - -
-
8/10/2019 Bisnis Plan Suta Biz Park
52/65
PEMBAYARAN BIAYA BANGUNANDes Jan Feb
1 2 3
- -
375,450,000
- - 375,450,000
-
8/10/2019 Bisnis Plan Suta Biz Park
53/65
Okt Nop Des Jan Peb Mar Apr Mei Jun Jul Agt Sep
4 5 6 7 8 9 10 11 12 13 14 15
55,000,000 55,000,000 55,000,000 44,000,000 44,000,000 44,000,000 44,000,000 33,000,000 - 11,000,000 - -
-
8/10/2019 Bisnis Plan Suta Biz Park
54/65
Mar Apr Mel Jun Jul Agu Sep Okt Nov Des Jan Feb
4 5 6 7 8 9 10 11 12 13 14 15
- - - -
469,312,500 469,312,500 469,312,500 46,931,250 46,931,250
405,090,000 506,362,500 506,362,500 506,362,500 50,636,250 50,636,250
345,810,000 432,262,500 432,262,500 432,262,500 43,226,250 43,226,250
280,560,000 350,700,000 350,700,000 350,700,000 35,070,000 35,070,000
280,560,000 350,700,000 350,700,000 350,700,000 35,070,000 35,070,000310,200,000 387,750,000 387,750,000 387,750,000 38,775,000 38,775,000
509,760,000 594,720,000 509,760,000 42,480,000 42,480,000
570,060,000 665,070,000 570,060,000 47,505,000 47,505,000
- - - - -
342,420,000 399,490,000 342,420,000 57,070,000
874,402,500 ########### ########### ########### ########### ########### ########### ########### ########### 528,250,000 389,925,000 57,070,000
-
8/10/2019 Bisnis Plan Suta Biz Park
55/65
TOTAL
385,000,000
-
8/10/2019 Bisnis Plan Suta Biz Park
56/65
TOTAL
-
-
1,877,250,000
2,025,450,000
1,729,050,000
1,402,800,000
1,402,800,0001,551,000,000
1,699,200,000
1,900,200,000
-
1,141,400,000
-
-
14,729,150,000
-
-
PROYEKSI CASH FLOWSUTA BIZ PARK
-
8/10/2019 Bisnis Plan Suta Biz Park
57/65
SUTA BIZ PARK
Des Jan Feb Mar Apr Mei Jun
1 2 3 4 5 6 7
RENCANA PENERIMAAN
A PENJUALAN RUKO & GUDANG
A.1. Penjualan Ruko TYPE A - - - 1,692,000,000 1,692,000,000 1,692,000,000 1,692,000,000
A.2. Penjualan Ruko TYPE B - - - 672,250,000 672,250,000 672,250,000 -
A.3. Penjualan GUDANG TYPE A - - - 2,257,000,000 - - -
A.5. Penjualan GUDANG TYPE B 2,701,600,000 - -
A.6. Penjualan GUDANG TYPE C 1,812,400,000 1,812,400,000
A.7. Penjualan GUDANG TYPE D - - - - - - -
A.7. Penerimaan Kelebihan Tanah - - - - 143,000,000 - -
B PENERIMAAN TITIPAN
B.1. Titipan Gimmick - - - 92,425,000 104,177,000 83,533,000 70,088,000
B.2. Titipan PPH Final - - - 231,062,500 260,442,500 208,832,500 175,220,000
B.3. Titipan PPN - - - 494,473,750 557,346,950 446,901,550 374,970,800
C PENERIMAAN MODAL KERJA
C.1. Pinjaman dari Pemegang Saham (SHL) 3,500,000,000 2,500,000,000 1,000,000,000 - - - -
C.2. Kredit dari Perbankan - - -
TOTAL PENERIMAAN 3,500,000,000 2,500,000,000 1,000,000,000 5,439,211,250 6,130,816,450 4,915,917,050 4,124,678,800
Des Jan Feb Mar Apr Mei Jun
1 2 3 4 5 6 7
RENCANA PENGELUARAN
A BIAYA PEROLEHAN LAHAN
A.1. Pembelian Lahan 807,050,000 - - 6,993,450,000
A.2. Legal Pembelian Lahan 20,000,000 - - - - - -
A.3. Sertifikasi Lahan 37,000,000 - - - - - -
-
8/10/2019 Bisnis Plan Suta Biz Park
58/65
A.4. Pajak Pajak 982,233,500 - - - - - -
- - - - - - -
B BIAYA PERIJINAN - - - - - - -
B.1. Perijinan Di Pemerintah Daerah 346,492,000 - - - - - -B.2. Perijinan Di Kantor Pertanahan 59,000,000 - - - - - -
- - - - - - -
C BIAYA PEMATANGAN LAHAN - - - - - - -
C.1. Infrastruktur - 1,877,892,000 48,550,000 48,550,000 48,550,000 48,550,000 48,550,000
C.2. Utilitas - 18,400,000 98,500,000 19,000,000 - - -
C.3. Fasilitas Sosial / Umum - - 25,500,000 - 25,500,000 - 25,500,000
C.4. Pemeliharaan dan Pembinaan Lingkungan 2,000,000 2,000,000 2,000,000 6,750,000 6,750,000 6,750,000 6,750,000
D BIAYA DIBAYAR DIMUKA (OHC) - - - - - - -
D.1. Persiapan Kantor dan Inventaris 400,000,000 - - - - - -D.2. Operasional Kantor 10,250,000 10,250,000 10,250,000 10,250,000 10,250,000 10,250,000 10,250,000
D.3. Gaji Karyawan 58,200,000 58,200,000 58,200,000 58,200,000 58,200,000 58,200,000 58,200,000
D.4. Bonus Karyawan - - - - - - -
D.5. Promosi - 30,000,000 30,000,000 30,000,000 30,000,000 30,000,000 30,000,000
D.6. Kesejahteraan 6,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000
- - - - - - -
E BIAYA BUNGA
E.1. Pinjaman Pemegang Saham (SHL) -
E.2. Kredit Dari Perbankan - - 42,500,000 3,375,000 3,375,000 6,750,000 6,750,000
- - - - - - -
F BIAYA BANGUNAN - - - - - - -
F.1. Bangunan Ruko & Gudang - - 375,450,000 874,402,500 1,321,485,000 1,688,497,500 1,616,816,250
- - - - - - -
H BIAYA LAIN - LAIN - - - - - - -
H.1. Bangunan Ruko & Gudang 708,750,000 - 68,750,000 68,750,000 68,750,000 55,000,000
- - - - - - -
I PENGELUARAN TITIPAN - - - - - - -
I.1. Titipan Gimmick - - - 92,425,000 104,177,000 83,533,000 70,088,000
I.2. Titipan PPH Final - - - 231,062,500 260,442,500 208,832,500 175,220,000
I.3. Titipan PPN - - - 494,473,750 557,346,950 446,901,550 374,970,800
- - - - - - -
J PENGEMBALIAN MODAL KERJA - - - - - - -
J.1. Pinjaman dari Pemegang Saham (SHL) - - - - -
J.2. Kredit dari Perbankan - -
- - - - - - -
TOTAL PENGELUARAN 3,430,975,500 2,002,742,000 693,950,000 1,940,238,750 2,497,826,450 2,660,014,550 9,474,545,050
-
8/10/2019 Bisnis Plan Suta Biz Park
59/65
- - - - - - -
PENERIMAAN - PENGELUARAN 69,024,500 497,258,000 306,050,000 3,498,972,500 3,632,990,000 2,255,902,500 (5,349,866,250)
Akumulasi Saldo 69,024,500 566,282,500 872,332,500 4,371,305,000 8,004,295,000 10,260,197,500 4,910,331,250
- - - - - - -
-
8/10/2019 Bisnis Plan Suta Biz Park
60/65
Jul Agus Sept Okt Nov Des Jan Feb SUB TOTAL
8 9 10 11 12 13 14 15
1,692,000,000 1,692,000,000 1,692,000,000 564,000,000 - - - - 12,408,000,000
- - - - - - - - 2,016,750,000
- 2,257,000,000 - 2,257,000,000 - - - - 6,771,000,000
- - 2,701,600,000 2,701,600,000 - - - - 8,104,800,000
1,812,400,000 5,437,200,000
- - - - - 3,458,200,000 - - 3,458,200,000
- 1,006,200,000 - - - - - - 1,149,200,000
70,088,000 99,104,000 87,872,000 110,452,000 - 69,164,000 - - 786,903,000
175,220,000 247,760,000 219,680,000 276,130,000 - 172,910,000 - - 1,967,257,500
374,970,800 530,206,400 470,115,200 590,918,200 - 370,027,400 - - 4,209,931,050
- - - - - - - - 7,000,000,000
- - - - - - - - -
4,124,678,800 5,832,270,400 5,171,267,200 6,500,100,200 - 4,070,301,400 - - 53,309,241,550
Jul Agus Sept Okt Nov Des Jan Feb SUB TOTAL
8 9 10 11 12 13 14 15
- - 7,800,500,000
- - - - - - - - 20,000,000
- - - - - - - - 37,000,000
982 233 500
-
8/10/2019 Bisnis Plan Suta Biz Park
61/65
- - - - - - - - 982,233,500
- - - - - - - - -
- - - - - - - - -
- - - - - - - - 346,492,000
- - - - - - - - 59,000,000
- - - - - - - - -
- - - - - - - - -
48,550,000 48,550,000 48,550,000 48,550,000 32,523,000 - - - 2,347,365,000
- - - - - - - - 135,900,000
- 15,500,000 - - - - - - 92,000,000
4,750,000 4,750,000 4,750,000 4,750,000 4,750,000 4,750,000 4,750,000 5,000,000 71,250,000
- - - - - - - - -
- - - - - - - - 400,000,000
10,250,000 10,250,000 10,250,000 10,250,000 10,250,000 10,250,000 10,250,000 10,250,000 153,750,000
58,200,000 58,200,000 58,200,000 58,200,000 58,200,000 58,200,000 58,200,000 58,200,000 873,000,000
- - - - - - - 122,400,000 122,400,000
30,000,000 30,000,000 30,000,000 30,000,000 22,250,000 322,250,000
3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 45,000,000
- - - - - - - - -
- - - - - 53,000,000
6,750,000 6,750,000 6,750,000 3,375,000 3,375,000 - - - 89,750,000
- - - - - - - - -
- - - - - - - - -
1,541,430,000 1,692,772,500 1,981,526,250 1,632,720,000 1,028,805,000 528,250,000 389,925,000 57,070,000 14,729,150,000
- - - - - - - - -
- - - - - - - - -
55,000,000 55,000,000 55,000,000 41,250,000 13,750,000 1,190,000,000
- - - - - - - - -
- - - - - - - - -
70,088,000 99,104,000 87,872,000 110,452,000 - 69,164,000 - - 786,903,000
175,220,000 247,760,000 219,680,000 276,130,000 - 172,910,000 - - 1,967,257,500
374,970,800 530,206,400 470,115,200 590,918,200 - 370,027,400 - - 4,209,931,050
- - - - - - - - -
- - - - - - - - -
4,000,000,000 3,000,000,000 - - - - 7,000,000,000
-
- - - - - - - - -
2,378,208,800 2,801,842,900 6,975,693,450 5,809,595,200 1,163,153,000 1,230,301,400 466,125,000 255,920,000 43,834,132,050
- - - - - - - - -
-
8/10/2019 Bisnis Plan Suta Biz Park
62/65
1,746,470,000 3,030,427,500 (1,804,426,250) 690,505,000 (1,163,153,000) 2,840,000,000 (466,125,000) (255,920,000) 9,475,109,500
6,656,801,250 9,687,228,750 7,882,802,500 8,573,307,500 7,410,154,500 10,250,154,500 9,784,029,500 9,528,109,500
- - - - - - - - -
-
8/10/2019 Bisnis Plan Suta Biz Park
63/65
T O T A L
39,345,150,000
6,964,091,550
7,000,000,000
53,309,241,550
T O T A L
-
-
-
-
-
8/10/2019 Bisnis Plan Suta Biz Park
64/65
8,839,733,500
-
-
-
405,492,000
-
-
- -
-
-
2,646,515,000
-
-
-
-
-
-
-
1,916,400,000
-
-
-
142,750,000
-
-
14,729,150,000
-
-
1,190,000,000
-
-
-
-
6,964,091,550
-
-
-
7,000,000,000
-
43,834,132,050
-
-
8/10/2019 Bisnis Plan Suta Biz Park
65/65
9,475,109,500
-
-