EXECUTIVE SUMMARY Proyek SUTA BIZ PARK Palembang MODAL 7 MILYAR POTENSI LABA 7 MILYAR (Nett) UMUR PROYEK 3 + 12 BULAN A. RENCANA PENERIMAAN I
II
Penjualan Ruko TYPE A Penjualan Ruko TYPE B Penjualan Gudang Type A Penjualan Gudang Type B Penjualan Gudang Type C Penjualan Gudang Type D Pener nerimaan aan Kelebih bihan Tanah nah
: :
:
Rp Rp. Rp R p. Rp. Rp. Rp. Rp. Rp.
TOTAL OMSET
:
Rp.
TITIPAN GIMMICK TITIPAN PPH FINAL
: :
Rp. Rp.
TOTAL PENERIMAAN
:
Rp.
:
Rp.
:
Rp.
B. RENCANA PENGELUARAN I
BIAYA PEROLEHAN LAHAN (termasuk fee perantara, kompensasi, sertifikasi, pajak dll)
II
BIAYA PERIJINAN (di kantor Pemda dan Kantor Pertanahan)
III
BIAYA PEMATANGAN LAHAN
Rp.
:
Rp.
Direktur 5% & Project Manager 5%
:
LABA - MANAGEMENT FEE
:
Rp. Rp.
= RENCANA PENERIMAAN - REN CANA PENGELUARAN
MANAGEMENT FEE
MODAL I
BIAYA PENGADAAN LAHAN BIAYA PERIJINAN BIAYA PEMATANGAN LAHAN BIAYA OVER HEAD COST BIAYA BANGUNAN
:
:
30% 100% 65% 30% 10%
KOMPOSISI PEMBAGIAN LABA INVESTOR PENGELOLA
: :
PROSENTASE 82% 18%
Rp. Rp.
12,408,000,000 2,016,750,000 6,771,000,000 8,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
9,475,109,500 947,510,950 8,527,598,550
Rp Rp Rp Rp Rp Rp
2,842,532,850.00 405,492,000.00 1,720,234,750.00 574,920,000.00 1,472,915,000.00 7,016,094,600.00
HAK 7,000,000,000 1,527,598,550
Rp
KEWAJIBAN 7,000,000,000.00 -
RASIO INVESTASI 100% -
1.00
39,345,150,000
38,195,950,000 1,149,200,000
ACTION PLAN Nama Proyek Lokasi Kota
:
Suta Biz Park
: Jl Soekarno Hatta Palembang : PALEMBANG
A BIAYA PEROLEHAN LAHAN A.1. Pembelian Lahan 1 2 3 4 5
Luas Lahan (Brutto) Efektivitas Lahan Luas Lahan (Netto) Harga Lahan Brutto per m2 Harga Lahan Netto per m2
: : : : :
6 7 8 9
Nilai Lahan keseluruhan Kompensasi dll (jika ada) Fee Mediator (perantara) Nilai Fee Mediator (perantara)
: : :
Sub Total A.1 :
15,541 m2 57.98 % 9,010 m2 Rp. Rp.
500,000 /m2 862,431 /m2
Rp. Rp. - % Rp.
7,770,500,000 30,000,000
Rp.
7,800,500,000
Rp. Rp. Rp. Rp.
500,000 5,000,000 7,500,000 1,500,000
-
A.2. Legal Pembelian Lahan 1 2 3 4
Pengecekan Sertipikat AJB PPAT Akta PPJB Notariil Akta Kuasa Menjual
: : : :
3 4 5 6
Pajak waris PBB10 th + 1 th kedapan PPH BPHTB
:
Rp. Rp. Rp. Rp.
38,552,500 169,631,000 388,525,000 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
: : : :
Rp. Rp. Rp. Rp.
20,000,000 10,000,000 155,410,000 20,000,000
: : : : : : : : : :
Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp.
31,082,000 35,000,000 5,000,000 35,000,000 10,000,000
B BIAYA PERIJINAN B.1. Perijinan Di Pemerintah Daerah 1 2 3 4 5
6 7 8 9
Rekomendasi / Sosialisasi Warga Rekomendasi Pengaplingan Ijin Lokasi Ijin Pemanfaatan Tanah (IPT) / Ijin Penggunaan Ruang (IPR) Rekomendasi Lahan Tanah Makam 5.a. Pembelian Lahan 5.b. SPH / AJB PPAT 5.c. Kompensasi untuk TPU Warga 5.d. BPHTB 5.e. Serah Terima Lahan Makam Siteplan / Keterangan Rencana Kota Peil Banjir (Dinas PSDA) Amdal / UKL UPL Amdal Lalu Lintas
/m2
C BIAYA PEMATANGAN LAHAN C.1. Infrastruktur 1 2 3 4 5 6
7
8
9 10 11 12 13 14 15
Striping dan Pembersihan Lahan Pembebasan Lahan akses masuk Cut and Fill Gerbang Masuk / Pos Jaga Sculture (land mark) Pagar Keliling 5.1. Pagar Panel Beton 5.2. Pagar BRC Saluran Air Kotor 6.a. Saluran diameter 40 cm 6.b. Saluran diameter 60 cm 6.c. Saluran diameter 80 cm 6.d. Saluran diameter 100cm Jalan Lingkungan 7.1. Aspal penetrasi 7.2. Aspal Hotmix 7.3. Beton K225 Kansteen Deucker (crossing saluran) Taman Berm dan Pohon Peneduh Taman Lingkungan Dinding Penahan Tanah (Talud) Stree Furniture Lain - Lain (biaya tak terduga)
: : : : :
Rp. Rp. Rp. Rp. Rp.
5,000,000 280,000,000 1,398,690,000 15,000,000 5,000,000
: :
Rp. Rp.
68,750,000 -
: : : :
Rp. Rp. Rp. Rp.
65,625,000
: : : : : : : : : :
Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp.
338,100,000 10,200,000 82,000,000 24,000,000 30,000,000 10,000,000 15,000,000
5 6 7 8
Kolam Renang centre plant Operasional dan pemeliharaan Lain - lain
: : : :
Rp. Rp. Rp. Rp.
20,000,000 12,000,000 -
Sub Total C.3 :
Rp.
92,000,000
C.4. Pemeliharaan dan Pembinaan Lingkungan 1 Pembinaan Lingkungan (Polsek, Danramil, Kelurahan, Preman dll) 2 Petugas Kebersihan (sampah) 3 Petugas Keamanan (satpam) 4 Tukang Taman 5 Lain - lain
:
Rp.
15,000,000
: : : :
Rp. Rp. Rp. Rp.
11,250,000 22,500,000 22,500,000 -
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
D BIAYA DIBAYAR DIMUKA (OHC) D.1. Persiapan Kantor dan Inventaris 1 2 3 4
Sewa Tempat Untuk Kantor Perbaikan Dan Renovasi Partisi, Panel, dan Backdrop Perlengkapan Kantor 4.1. Meja, kursi, lemari, dll
: : : : :
Rp. Rp. Rp.
50,000,000 5,000,000 10,000,000
Rp.
15,000,000
/m2
3 4 5 6 7 8 9 10
Finance Accounting & Tax Officer Staf Finance Accounting & Tax Project Officer Staf Project Marketing Officer Sales A Sales B General Affair / Office Boy
: : : : : : : :
Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp.
90,000,000 52,500,000 90,000,000 52,500,000 90,000,000 45,000,000 45,000,000 33,000,000
Sub Total D.3 :
Rp.
873,000,000
: : : : : : : : : :
Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp. Rp.
27,000,000 15,750,000 27,000,000 15,750,000 27,000,000 9,900,000
Sub Total D.4 :
Rp.
122,400,000
: : : : :
Rp. Rp. Rp. Rp. Rp
75,000,000 60,000,000 82,500,000 36,000,000 18,750,000
9,989 5,827 9,989 5,827 9,989 3,663
D.4. Bonus Karyawan 1 2 3 4 5 6 7 8 9 10
Direktur Project Manager Finance Accounting & Tax Officer Staf Finance Accounting & Tax Project Officer Staf Project Marketing Officer Sales A Sales B General Affair / Office Boy
D.5. Promosi 1 2 3 4 5
Cetak Brosur, Flyer, Leaflet Billboard, Signboard Iklan di surat kabar Pameran Spanduk
2,997 1,748 2,997 1,748 2,997 1,099
E.1. Pinjaman Pemegang Saham (Share Holder Loan) 1 Bunga Pinjaman 2 Lain - Lain
: :
Rp. Rp.
53,000,000 -
Sub Total E.1 :
Rp.
53,000,000
: : : : :
Rp. Rp. Rp. Rp. Rp.
10,000,000 5,000,000 20,000,000 7,500,000 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
981,102
/m2
45,005
/m2
C BIAYA PEMATANGAN LAHAN
293,731
/m2
D BIAYA DIBAYAR DIMUKA (OHC)
212 697
/m2
E.2. Kredit Dari Perbankan 1 2 3 4 5
Biaya Apraisal Biaya Pembuatan Neraca L/R Provisi, Administrasi Biaya Akta Notariil dll Bunga Pinjaman
REKAPITULASI; A BIAYA PEROLEHAN LAHAN B BIAYA PERIJINAN
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
-
175,000
65,625,000
375.00
m1
-
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
500,000
-
m3
1.00
ls
10,000,000
10,000,000
1.00
ls
15,000,000
15,000,000
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
-
-
/ m2
15.00
bulan
6,000,000
90,000,000
/ m2
15.00
bulan
3,500,000
52,500,000
/ m2
15.00
bulan
6,000,000
90,000,000
/ m2
15.00
bulan
3,500,000
52,500,000
/ m2
15.00
bulan
6,000,000
90,000,000
/ m2
15.00
bulan
3,000,000
45,000,000
/ m2
15.00
bulan
3,000,000
45,000,000
/ m2
15.00
bulan
2,200,000
33,000,000
58,200,000
Koefisien Bonus / m2
30.00
%
/ m2 / m2 / m2 / m2 / m2 / m2 / m2 / m2 / m2
Volume
Satuan
Harga
Sub Total
Satuan
15.00
bulan
5,000,000
75,000,000
2.00
ls
30,000,000
60,000,000
15.00
bulan
5,500,000
82,500,000
6.00
kali
6,000,000
36,000,000
15.00
bulan
1 250 000
18,750,000
Rate
Besar Modal Kerja 12 %
Rate
Nilai Kredit Konstruksi 19 %
37.73 %
8,839,733,500
1.73 %
405,492,000
11.30 %
2,646,515,000
8 18 %
1,916,400,000
1,000,000,000
3,000,000
Keterangan
Keterangan
Keterangan
HITUNG HARGA JUAL LUAS BANG
HARGA SATUAN BANG
GRADE I BAGUNAN PERTOKOAN 1 RUKO TYPE A TYPE B
120.00 145.00
LUAS BANG
2,250,000 2,250,000
1,300,000 1,300,000 1,300,000 1,300,000
HARGA SATUAN BANG
GRADE II
BANGUNAN PERGUDANGAN
LUAS TANAH
HARGA SATUAN TANAH
270,000,000 326,250,000
100.00 120.00
2,080,000 2,080,000
741,000,000 889,200,000 592,800,000 1,141,400,000
570.00 684.00 456.00 878.00
2,080,000 2,080,000 2,080,000 2,080,000
a
BANGUNAN PERGUDANGAN 1 Type Varian A 570.00 2 Type Varian B 684.00 3 Type Varian C 456.00 4 Type Varian D 878.00
BANGUNAN PERTOKOAN 1 RUKO TYPE A TYPE B
SUB TOTAL HARGA BANGUNAN
SUB TOTAL HARGA BANGUNAN
LUAS TANAH
HARGA SATUAN TANAH
100.00 120.00
2,340,000 2,340,000
a
120.00 145.00
2,250,000 2,250,000
270,000,000 326,250,000
3 Type Varian C 4 Type Varian D
456.00 878.00
1,300,000 1,300,000
592,800,000 1,141,400,000
456.00 878.00
2,600,000 2,600,000
4,428.00 LUAS BANG
HARGA SATUAN BANG
GRADE IV BANGUNAN PERTOKOAN 1 RUKO TYPE A TYPE B
LUAS TANAH
HARGA SATUAN TANAH
270,000,000 326,250,000
100.00 120.00
2,860,000 2,860,000
741,000,000 889,200,000 592,800,000 1,141,400,000
570.00 684.00 456.00 878.00
2,860,000 2,860,000 2,860,000 2,860,000
a
120.00 145.00
BANGUNAN PERGUDANGAN 1 Type Varian A 570.00 2 Type Varian B 684.00 3 Type Varian C 456.00 4 Type Varian D 878.00
LUAS BANG
2,250,000 2,250,000
1,300,000 1,300,000 1,300,000 1,300,000
HARGA SATUAN BANG
GRADE V BANGUNAN PERTOKOAN 1 RUKO TYPE A
SUB TOTAL HARGA BANGUNAN
SUB TOTAL HARGA BANGUNAN
LUAS TANAH
HARGA SATUAN TANAH
100.00
3,120,000
a
120.00
2,250,000
270,000,000
SUB TOTAL HARGA TANAH
LAIN LAIN
TOTAL
b
c
a+b+c
UP 2% GIMMICK
UP 5% PPH FINAL
208,000,000 249,600,000
34,000,000 34,000,000
512,000,000 609,850,000
10,240,000 12,197,000
25,600,000 30,492,500
1,185,600,000 1,422,720,000 948,480,000 1,826,240,000
34,000,000 34,000,000 34,000,000 34,000,000
1,960,600,000 2,345,920,000 1,575,280,000 3,001,640,000
39,212,000 46,918,400 31,505,600 60,032,800
98,030,000 117,296,000 78,764,000 150,082,000
UP 2% GIMMICK
SUB TOTAL HARGA TANAH
LAIN LAIN
TOTAL
b
c
a+b+c
234,000,000 280,800,000
34,000,000 34,000,000
538,000,000 641,050,000
10,760,000 12,821,000
UP 5% PPH FINAL
26,900,000 32,052,500
1,185,600,000 2,282,800,000
34,000,000 34,000,000
1,812,400,000 3,458,200,000
36,248,000 69,164,000
UP 2% GIMMICK
SUB TOTAL HARGA TANAH
LAIN LAIN
TOTAL
b
c
a+b+c
90,620,000 172,910,000
UP 5% PPH FINAL
286,000,000 343,200,000
34,000,000 34,000,000
590,000,000 703,450,000
11,800,000 14,069,000
29,500,000 35,172,500
1,630,200,000 1,956,240,000 1,304,160,000 2,511,080,000
34,000,000 34,000,000 34,000,000 34,000,000
2,405,200,000 2,879,440,000 1,930,960,000 3,686,480,000
48,104,000 57,588,800 38,619,200 73,729,600
120,260,000 143,972,000 96,548,000 184,324,000
UP 2% GIMMICK
SUB TOTAL HARGA TANAH
LAIN LAIN
TOTAL
b
c
a+b+c
312,000,000
34,000,000
616,000,000
12,320,000
UP 5% PPH FINAL
30,800,000
GRAND TOTAL HARGA
PPN 10%
HARGA + PPN 10%
HARGA + PPN 10% (Pembulatan)
547,840,000 652,539,500
54,784,000 65,253,950
602,624,000 717,793,450
602,600,000 717,800,000
2,097,842,000 2,510,134,400 1,685,549,600 3,211,754,800
209,784,200 251,013,440 168,554,960 321,175,480
2,307,626,200 2,761,147,840 1,854,104,560 3,532,930,280
2,307,600,000 2,761,100,000 1,854,100,000 3,532,900,000
GRAND TOTAL HARGA
575,660,000 685,923,500
PPN 10%
57,566,000 68,592,350
HARGA + PPN 10%
633,226,000 754,515,850
300.00 120.00 456.00 876.00
HARGA + PPN 10% (Pembulatan)
633,200,000 754,500,000
300.00 -
1,939,268,000 3,700,274,000
GRAND TOTAL HARGA
193,926,800 370,027,400
PPN 10%
2,133,194,800 4,070,301,400
HARGA + PPN 10%
2,133,200,000 4,070,300,000
456.00 878.00 5,462.00
HARGA + PPN 10% (Pembulatan)
631,300,000 752,691,500
63,130,000 75,269,150
694,430,000 827,960,650
694,400,000 828,000,000
2,573,564,000 3,081,000,800 2,066,127,200 3,944,533,600
257,356,400 308,100,080 206,612,720 394,453,360
2,830,920,400 3,389,100,880 2,272,739,920 4,338,986,960
2,830,900,000 3,389,100,000 2,272,700,000 4,339,000,000
120.00 684.00 804.00
GRAND TOTAL HARGA
659,120,000
PPN 10%
65,912,000
HARGA + PPN 10%
725,032,000
HARGA + PPN 10% (Pembulatan)
725,000,000
100.00
3 1
1,536,000,000 609,850,000
1
1,575,280,000
3
1,614,000,000
1 1
1,812,400,000 3,458,200,000 100,129,200,000
0 1
703,450,000
0 1
2,879,440,000
1
616,000,000
NOTASI
:
Perlu diisi
:
Sudah memakai formula Sudah memakai formula
:
Nama Proyek Lokasi Kota
F
Sudah memakai formula
:
FONT
Tidak masuk penjumlahan
:
FONT
Masuk penjumlahan
:
SUTA BIZ PARK
: JL SOEKARNO HATTA : PALEMBANG
OMSET BANGUNAN
F.1. Bangunan Komersial Ukuran
Type
Harga
120.00 145.00
Satuan 2,250,000 2,250,000
RUKO 1 2
Ruko TYPE A Ruko TYPE B
Harga Borongan 1 unit 270,000,000 326,250,000
Sub Total Sub Total F.1
Jumlah
Sub Total
Unit Omset Bangunan 22 5,940,000,000 3 978,750,000 25 Rp. 6,918,750,000
F.2. Bangunan gudang Ukuran
Type
Harga
gudang 1 2 3 4
gudang A gudang B gudang C gudang D
570.00 684.00 456.00 878.00
Harga Borongan
Satuan 1,300,000 1,300,000 1,300,000 1,300,000
Jumlah
Sub Total
Unit
Omset Bangunan 2,223,000,000 2,667,600,000 1,778,400,000 1,141,400,000
1 unit 741,000,000 889,200,000 592,800,000 1,141,400,000 Sub Total F.2
3 3 3 1 10 Rp.
TOTAL ( F.1 + F.2 )
Rp.
Sub Total
OMSET (F)
G
Rp.
2,600,000 / m2 GRADUAL
GRADE
HARGA JUAL
I II III IV V
2,080,000 0.8 2,340,000 0.9 2,600,000 2,860,000 1.1 3,120,000 1.2
LUAS
10.0
%
OMSET TANAH
901 m2
1,874,080,000
901 m2
2,108,340,000
5,406 m2
14,055,600,000
901 m2
2,576,860,000
901 m2
2,811,120,000
14,729,150,000
14,729,150,000
OMSET TANAH
HARGA JUAL TANAH RATA - RATA
7,810,400,000
Harga rata-rata
TOTAL
9,010 m2
OMSET (G)
H
23,426,000,000
Rp.
23,426,000,000
OMSET LAIN LAIN
Pembebanan Per Unit Bangunan 1 2 3 4 5 6 7 8 9 10
Biaya Sambung Listrik (PLN) Biaya Sambung Air Bersih [ ] PDAM [ Biaya Splitsing Sertipikat Biaya IMB (incl. Retribusinya) Biaya Extra Provisi (pengurusan KPR) Fee Sales / Mediator Biaya Maintenance (sebelum STB) Biaya Pembuatan Perabot Rumah Contoh Biaya Pembuatan Taman Halaman Depan Biaya Desain
10,000,000 3,000,000 2,250,000 3,000,000 1,000,000 14,000,000 500,000 250,000
] Sumur + Pompa
BIAYA PER UNIT BANGUNAN
34,000,000
JUMLAH UNIT BANGUNAN
OMSET (H)
Rp.
35
1,190,000,000
REKAPITULASI; F
OMSET BANGUNAN
14,729,150,000
G
OMSET TANAH
23,426,000,000
13,139,583
H
OMSET LAIN LAIN
1,190,000,000 TOTAL OMSET
39,345,150,000
CHECK AND BALANCE 1 TARGET LABA TOTAL OMSET
: :
9,475,109,500 39,345,150,000
24.08 %
TOTAL OHC TOTAL OMSET
: :
1,916,400,000 39,345,150,000
4.87 %
HARGA PEROLEHAN HARGA JUAL
: :
500,000 2,600,000
2
3 5.20 x
39,345,150,000
PROYEKSI PENJUALAN Jumlah Unit A Bangunan Pertokoan - Ruko TYPE A
Luas Bang
Luas Tanah
Des 1
Jan 2
Feb 3
Mar 4
Apr 5
Mei 6
Jun 7
Jul 8
Agu 9
Sep 10
Okt 11
Nov 12
Des 13
22
120.00
100.00
0
0
0
3
3
3
3
3
3
3
1
0
0
0
3
145.00
120.00
0
0
0
1
1
1
0
0
0
0
0
0
0
0
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
0
0
0
5
5
5
4
4
4
4
3
0
1
0
- Ruko TYPE B B Bangunan Pergudangan Gudang Type A
35
A Bangunan pertokoan - Ruko TYPE A - Ruko TYPE B B Bangunan Pergudangan - Gudang TYPE A - Gudang TYPE B - Gudang TYPE C - Gudang TYPE D
22 3
3 3 3 1
120.00 145.00
100.00 120.00
Harga Jual (exc PPN) 564,000,000 672,250,000
570.00 684.00 456.00 878.00
570.00 684.00 456.00 878.00
2,257,000,000 2,701,600,000 1,812,400,000 3,458,200,000
PROYEKSI OMSET PENJUALAN - Ruko TYPE A 1 2 3
Jan 14
Desember Januari Februari
- Ruko TYPE B -
-
- Gudang TYPE A -
- Gudang TYPE B - Gudang TYPE C - Gudang TYPE D -
4 5 6 7 8 9 10 11 12 13 14 15
Maret April Mei Juni Juli Agustus September Oktober November Desember Januari Februari
1,692,000,000 1,692,000,000 1,692,000,000 1,692,000,000 1,692,000,000 1,692,000,000 1,692,000,000 564,000,000 12,408,000,000
672,250,000 672,250,000 672,250,000 2,016,750,000
2,257,000,000 2,257,000,000 2,257,000,000 6,771,000,000
2,701,600,000 2,701,600,000 2,701,600,000 8,104,800,000
1,812,400,000 1,812,400,000 1,812,400,000 5,437,200,000
3,458,200,000 3,458,200,000
PROYEKSI BUKA SPK BANGUNAN - Ruko TYPE A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Desember Januari Februari Maret April Mei Juni Juli Agustus September Oktober November Desember Januari Februari
810,000,000 810,000,000 810,000,000 810,000,000 810,000,000 810,000,000 810,000,000 270,000,000 5,940,000,000
- Ruko TYPE B
326,250,000 326,250,000 326,250,000 978,750,000
- Gudang TYPE A 741,000,000 741,000,000 741,000,000 2,223,000,000
- Gudang TYPE B - Gudang TYPE C - Gudang TYPE D 889,200,000 592,800,000 592,800,000 592,800,000 889,200,000 889,200,000 1,141,400,000 2,667,600,000 1,778,400,000 1,141,400,000
Feb TOTAL 15 0
Des 1
22
Jan 2 -
Feb 3 -
Mar 4 -
Apr 5 300
300
-
0
3
-
-
-
120
120
-
0
3
-
-
-
570
-
-
0
3
-
-
-
-
684
-
0
3
0
1
-
0
35
-
-
-
990
1,104
-
SUB TOTAL
Kelebihan Tanah -
TOTAL -
-
-
-
-
-
-
-
-
396,000,000
441,600,000
-
-
-
-
396,000,000
441,600,000
4,621,250,000 5,065,850,000 4,176,650,000 3,504,400,000 3,504,400,000 3,949,000,000 4,393,600,000 5,522,600,000 3,458,200,000 38,195,950,000
143,000,000 1,006,200,000 1,149,200,000
SUB TOTAL 1,877,250,000 2,025,450,000 1,729,050,000 1,402,800,000 1,402,800,000 1,551,000,000 1,699,200,000 1,900,200,000 1,141,400,000 14,729,150,000
4,764,250,000 5,065,850,000 4,176,650,000 3,504,400,000 3,504,400,000 4,955,200,000 4,393,600,000 5,522,600,000 3,458,200,000 39,345,150,000
TOTAL
-
1,877,250,000 2,025,450,000 1,729,050,000 1,402,800,000 1,402,800,000 1,551,000,000 1,699,200,000 1,900,200,000 1,141,400,000 14,729,150,000
Mel 6
Jun 7
Jul 8
Agu 9
Sep 10
Okt 11
Nov 12
Des 13
Jan 14
Feb 15
300
300
300
300
300
100
-
-
-
-
120
-
-
-
-
-
-
-
-
-
-
-
-
570.00
-
570.00
-
-
-
-
-
-
-
-
684
684
-
-
-
-
456
456
456 878
876
756
756
870
350,400,000
302,400,000
302,400,000
-
-
-
350,400,000
302,400,000
302,400,000
984
1,354
-
878
-
-
348,000,000
393,600,000
541,600,000
-
-
-
-
351,200,000
-
-
-
-
-
-
348,000,000
393,600,000
541,600,000
-
351,200,000
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
1,692,000,000
1,692,000,000
672,250,000
2,257,000,000
-
4,621,250,000
-
2,701,600,000
1,692,000,000
5,065,850,000
672,250,000
-
-
4,176,650,000
1,692,000,000
-
-
-
3,504,400,000
1,692,000,000
-
-
-
3,504,400,000
-
2,257,000,000
-
3,949,000,000
1,692,000,000
1,692,000,000
-
-
2,701,600,000
4,393,600,000
-
2,257,000,000
2,701,600,000
5,522,600,000
-
-
-
-
-
-
-
-
-
-
12,408,000,000
2,016,750,000
6,771,000,000
564,000,000
672,250,000
-
-
-
3,458,200,000
-
-
-
-
-
-
8,104,800,000
38,195,950,000
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
-
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
BUDGET BIAYA LAIN LAIN Jul 1
Agt 2 -
Sep 3 -
-
PEMBAYARAN BIAYA BANGUNAN
Des 1
Jan 2
Feb 3
-
375,450,000
-
-
375,450,000
Okt 4
Nop 5
Des 6
Jan 7
Peb 8
Mar 9
Apr 10
55,000,000
55,000,000
55,000,000
44,000,000
44,000,000
44,000,000
44,000,000
Mei 11 33,000,000
Jun 12
Jul 13 -
11,000,000
Agt 14
Sep 15 -
-
Mar 4
Apr 5
Mel 6
Jun 7
Jul 8
Agu 9
Sep 10
Okt 11
Nov 12
Des 13
Jan 14
Feb 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,000
310,200,000
387,750,000
387,750,000
387,750,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
-
-
-
-
-
342,420,000
399,490,000
342,420,000
57,070,000
# ## ## ### ## # 5 28 ,25 0,0 00 389,925,000
57,070,000
874,402,500
## ## ## ### ##
## ## ### ## ##
## ## ### ## ##
## ## ### ## ##
## ### ## ### #
## ### ## ### #
# ## ## ### ## #
38,775,000 47,505,000
TOTAL
385,000,000
TOTAL
-
1,877,250,000 2,025,450,000 1,729,050,000 1,402,800,000 1,402,800,000 1,551,000,000 1,699,200,000 1,900,200,000 1,141,400,000 14,729,150,000 -
PROYEKSI CASH FLOW SUTA BIZ PARK Des 1
Jan 2
Feb 3
Mar 4
Apr 5
Mei 6
Jun 7
-
1,692,000,000 672,250,000 2,257,000,000
1,692,000,000 672,250,000 2,701,600,000
-
-
143,000,000
1,692,000,000 672,250,000 1,812,400,000 -
-
92,425,000 231,062,500 494,473,750
104,177,000 260,442,500 557,346,950
RENCANA PENERIMAAN A PENJUALAN RUKO & GUDANG A.1. Penjualan Ruko TYPE A A.2. Penjualan Ruko TYPE B A.3. Penjualan GUDANG TYPE A A.5. Penjualan GUDANG TYPE B A.6. Penjualan GUDANG TYPE C A.7. Penjualan GUDANG TYPE D A.7. Penerimaan Kelebihan Tanah
-
-
-
-
-
-
3,500,000,000 -
2,500,000,000 -
1,000,000,000
-
3,500,000,000
2,500,000,000
1,000,000,000
Des 1
Jan 2
Feb 3
1,692,000,000 1,812,400,000 -
B PENERIMAAN TITIPAN B.1. Titipan Gimmick B.2. Titipan PPH Final B.3. Titipan PPN
83,533,000 208,832,500 446,901,550
70,088,000 175,220,000 374,970,800
-
-
-
5,439,211,250
6,130,816,450
4,915,917,050
4,124,678,800
Mar 4
Apr 5
Mei 6
C PENERIMAAN MODAL KERJA C.1. Pinjaman dari Pemegang Saham (SHL) C.2. Kredit dari Perbankan
TOTAL PENERIMAAN
Jun 7
RENCANA PENGELUARAN A BIAYA PEROLEHAN LAHAN A.1. Pembelian Lahan
807,050,000
-
-
6,993,450,000
A.2. Legal Pembelian Lahan A.3. Sertifikasi Lahan A.4. Pajak Pajak
B BIAYA PERIJINAN B.1. Perijinan Di Pemerintah Daerah B.2. Perijinan Di Kantor Pertanahan
C BIAYA PEMATANGAN LAHAN C.1. Infrastruktur C.2. Utilitas C.3. Fasilitas Sosial / Umum C.4. Pemeliharaan dan Pembinaan Lingkungan
D BIAYA DIBAYAR DIMUKA (OHC) D.1. Persiapan Kantor dan Inventaris D.2. Operasional Kantor D.3. Gaji Karyawan D.4. Bonus Karyawan D.5. Promosi D.6. Kesejahteraan
20,000,000 37,000,000 982,233,500 346,492,000 59,000,000 2,000,000 400,000,000 10,250,000 58,200,000 -
-
1,877,892,000 18,400,000 2,000,000 10,250,000 58,200,000 30,000,000 6,000,000 -
48,550,000 98,500,000 25,500,000 2,000,000 10,250,000 58,200,000 30,000,000 3,000,000 -
48,550,000 19,000,000 6,750,000 10,250,000 58,200,000 30,000,000 3,000,000 -
48,550,000 25,500,000 6,750,000 10,250,000 58,200,000 30,000,000 3,000,000 -
48,550,000 6,750,000
48,550,000 25,500,000 6,750,000
10,250,000 58,200,000 30,000,000 3,000,000 -
10,250,000 58,200,000 30,000,000 3,000,000 -
6,750,000 1,688,497,500 68,750,000 83,533,000 208,832,500 446,901,550 -
6,750,000 1,616,816,250 55,000,000 70,088,000 175,220,000 374,970,800 -
E BIAYA BUNGA E.1. Pinjaman Pemegang Saham (SHL) E.2. Kredit Dari Perbankan
F BIAYA BANGUNAN F.1. Bangunan Ruko & Gudang
H BIAYA LAIN - LAIN H.1. Bangunan Ruko & Gudang
I
PENGELUARAN TITIPAN
I.1. Titipan Gimmick I.2. Titipan PPH Final I.3. Titipan PPN
J PENGEMBALIAN MODAL KERJA J.1. Pinjaman dari Pemegang Saham (SHL) J.2. Kredit dari Perbankan
708,750,000 -
-
42,500,000 375,450,000 -
-
3,375,000 874,402,500 68,750,000 92,425,000 231,062,500 494,473,750 -
3,375,000 1,321,485,000 68,750,000 104,177,000 260,442,500 557,346,950 -
TOTAL PENGELUARAN PENERIMAAN - PENGELUARAN Akumulasi Saldo
3,430,975,500 69,024,500 69,024,500 -
2,002,742,000 497,258,000 566,282,500 -
693,950,000 306,050,000 872,332,500 -
1,940,238,750 3,498,972,500 4,371,305,000 -
2,497,826,450 3,632,990,000 8,004,295,000 -
2,660,014,550 2,255,902,500 10,260,197,500 -
9,474,545,050 (5,349,866,250) 4,910,331,250 -
Jul 8
Agus 9
Sept 10
1,692,000,000 1,812,400,000 -
1,692,000,000 2,257,000,000 -
1,692,000,000 2,701,600,000
564,000,000 2,257,000,000 2,701,600,000
1,006,200,000
-
-
87,872,000 219,680,000 470,115,200
110,452,000 276,130,000 590,918,200
70,088,000 175,220,000 374,970,800
99,104,000 247,760,000 530,206,400
Okt 11
Nov 12
-
-
-
-
4,124,678,800
5,832,270,400
5,171,267,200
6,500,100,200
Jul 8
Agus 9
Sept 10
Okt 11
Des 13
Jan 14
Feb 15
SUB TOTAL
-
-
-
-
-
3,458,200,000 -
-
-
12,408,000,000 2,016,750,000 6,771,000,000 8,104,800,000 5,437,200,000 3,458,200,000 1,149,200,000
-
69,164,000 172,910,000 370,027,400
-
-
786,903,000 1,967,257,500 4,209,931,050
-
-
-
-
7,000,000,000 -
-
4,070,301,400
-
-
53,309,241,550
Nov 12
Des 13
-
Jan 14
Feb 15
SUB TOTAL
-
7,800,500,000
48,550,000 4,750,000 10,250,000 58,200,000 30,000,000 3,000,000 -
6,750,000 1,541,430,000 55,000,000 70,088,000 175,220,000 374,970,800 -
48,550,000 15,500,000 4,750,000 10,250,000 58,200,000 30,000,000 3,000,000 -
6,750,000 1,692,772,500 55,000,000 99,104,000 247,760,000 530,206,400 -
48,550,000 4,750,000 10,250,000 58,200,000 30,000,000 3,000,000 -
6,750,000 1,981,526,250 55,000,000 87,872,000 219,680,000 470,115,200 4,000,000,000
48,550,000 4,750,000 10,250,000 58,200,000 30,000,000 3,000,000 -
3,375,000 1,632,720,000 41,250,000 110,452,000 276,130,000 590,918,200 3,000,000,000
32,523,000 4,750,000 10,250,000 58,200,000 22,250,000 3,000,000 -
3,375,000 1,028,805,000 -
-
4,750,000 10,250,000 58,200,000 3,000,000 528,250,000 13,750,000 69,164,000 172,910,000 370,027,400 -
4,750,000
10,250,000 58,200,000 -
5,000,000
20,000,000 37,000,000 982,233,500 346,492,000 59,000,000 2,347,365,000 135,900,000 92,000,000 71,250,000
10,250,000 58,200,000 122,400,000
400,000,000 153,750,000 873,000,000 122,400,000 322,250,000 45,000,000 -
3,000,000 -
3,000,000 -
389,925,000 -
57,070,000 -
-
-
53,000,000 89,750,000 14,729,150,000 1,190,000,000 786,903,000 1,967,257,500 4,209,931,050 7,000,000,000 -
2,378,208,800 1,746,470,000 6,656,801,250 -
2,801,842,900 3,030,427,500 9,687,228,750 -
6,975,693,450 (1,804,426,250) 7,882,802,500 -
5,809,595,200 690,505,000 8,573,307,500 -
1,163,153,000 (1,163,153,000) 7,410,154,500 -
1,230,301,400 2,840,000,000 10,250,154,500 -
466,125,000 (466,125,000) 9,784,029,500
255,920,000 (255,920,000) 9,528,109,500
43,834,132,050 9,475,109,500 -
TOTAL
39,345,150,000
6,964,091,550
7,000,000,000 53,309,241,550
TOTAL
-
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
-