Top Banner
Pembangunan Proyek Rumah LOKASI : LINGKAR TIMUR Gresik - JAWA TIMUR TABEL 1 LOKASI DAN PENGGUNAAN LAHAN 1. LOKASI Kelurahan : Morowudi Kecamatan : Krian Kabupaten : Sidoarjo Propinsi : Jawa Timur 2. PENGGUNAAN LAHAN No Peruntukan Luas Satuan 1 Perumahan 5,712 m2 2 Fasilitas Umum 1,428 m2 Total 7,140 m2 A. Perincian Penggunaan Kavling Tanah Matang (Lahan efektif) No Type Rumah Prosentase Jumlah Luas Tanah Luas Tot Unit Bangunan L. Tanah 1 Type 29/72 65% 32 72 29 3,713 2 Type 36 / 84 35% 17 84 36 1,999 Total 100% 49 5,712
38

Hitung Detail

Dec 29, 2015

Download

Documents

bangunan
Welcome message from author
This document is posted to help you gain knowledge. Please leave a comment to let me know what you think about it! Share it to your friends and learn new things together.
Transcript
Page 1: Hitung Detail

Pembangunan Proyek Rumah LOKASI : LINGKAR TIMURGresik - JAWA TIMUR

TABEL 1LOKASI DAN PENGGUNAAN LAHAN

1. LOKASIKelurahan : MorowudiKecamatan : KrianKabupaten : SidoarjoPropinsi : Jawa Timur

2. PENGGUNAAN LAHAN

No Peruntukan Luas Satuan1 Perumahan 5,712 m2 2 Fasilitas Umum 1,428 m2

Total 7,140 m2

A. Perincian Penggunaan Kavling Tanah Matang (Lahan efektif)

No Type Rumah Prosentase Jumlah Luas Tanah Luas TotalUnit Bangunan L. Tanah L. Bangunan

1 Type 29/72 65% 32 72 29 3,713 924 2 Type 36 / 84 35% 17 84 36 1,999 617

Total 100% 49 5,712 1,541

Page 2: Hitung Detail

HPP tanah/ unitNO TYPE LUAS TANAH HPP tanah Jumlah

1 29 99.0 105,164 10,411,240 2 36 84.0 105,164 8,833,780

HPP Bangunan/ unitNO TYPE Luas Bangunan HPP Bang. Jumlah

1 29 29 700,000 20,300,000 2 36 36 750,000 27,000,000

Harga jual tanah/unitNO TYPE LUAS TANAH Harga Jual Jumlah

1 29 72.0 250,000 18,000,000 2 36 84.0 250,000 21,000,000

Harga jual bangunan/ unitNO TYPE LUAS Harga Jual Jumlah

Bangunan Bangunan 1 29 29 750,000 21,750,000 2 36 36 850,000 30,600,000

HPP Rumah/unitNO TYPE HPP

1 29 30,711,240 2 36 35,833,780

Harga jual rumah/ unitNO TYPE Harga Jual

1 29 39,750,000 12,799,500,000 2 36 51,600,000

287,884,494 1,308,596,284 1,596,480,779

Page 3: Hitung Detail

DAFTAR HARGA DAN RENCANA ANGSURAN

NO TYPE HARGA JUAL Uang Muka Rencana RENCANA ANGSURAN /BULAN DGN SUKU BUNGA 17 %Min. 20 % KPR 80 % 20 Th Gaji Min 15 Th Gaji Min 10 Th Gaji Min 5 Th Gaji Min

1 29 39,750,000 7,950,000 31,800,000 2 36 51,600,000 15,480,000 36,120,000

Total 91,350,000 23,430,000 67,920,000

DAFTAR HARGA RENCANA PENJUALAN

NO TYPE Unit HARGA JUAL Total Uang Muka Uang Muka SISA RencanaPenjualan Min. 25% Pertama UANG MUKA KPR 70 %

1 29 32 39,750,000 1,266,037,500 316,509,375 189,905,625.00 126,603,750.00 949,528,125 2 36 17 51,600,000 884,940,000 221,235,000 132,741,000.00 88,494,000.00 663,705,000

Total 49 91,350,000 2,150,977,500 537,744,375 322,646,625 215,097,750 1,613,233,125

Page 4: Hitung Detail

PROYEKSI RENCANA PENERIMAAN UANG MUKA

NO TYPE STOK HARGA TOTAL OMZET 2 OMZET SISA 3 OMZET SISAAWAL JUAL UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK

1 29 32 39,750,000 1,266,037,500 1 39,750,000 9,937,500.0 30.85 2 79,500,000 19,875,000.0 28.852 36 17 51,600,000 884,940,000 0 - - 17.15 1 51,600,000 12,900,000.0 16.15

49 91,350,000 2,150,977,500 1 39,750,000 9,937,500 48 3 131,100,000 32,775,000 45

Page 5: Hitung Detail

4 OMZET SISA 5 OMZET SISA 6 OMZET SISA 7 OMZET SISAUNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK

4 159,000,000 39,750,000.0 24.85 4 159,000,000 39,750,000.0 20.85 4 159,000,000 39,750,000.0 16.85 4 159,000,000 39,750,000.0 12.852 103,200,000 25,800,000.0 14.15 2 103,200,000 25,800,000.0 12.15 2 103,200,000 25,800,000.0 10.15 2 103,200,000 25,800,000.0 8.15

6 262,200,000 65,550,000 39 6 262,200,000 65,550,000 33 6 262,200,000 65,550,000 27 6 262,200,000 65,550,000 21

Page 6: Hitung Detail

8 OMZET SISA 9 OMZET SISA 10 OMZET SISA 11 OMZET SISAUNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK

4 159,000,000 39,750,000.0 8.85 4 159,000,000 39,750,000.0 4.85 5 198,750,000 49,687,500.0 -0.15 - - -0.152 103,200,000 25,800,000.0 6.15 2 103,200,000 25,800,000.0 4.15 4 206,400,000 51,600,000.0 0.15 - - 0.15

6 262,200,000 65,550,000 15 6 262,200,000 65,550,000 9 9 405,150,000 101,287,500 - - - - -

Page 7: Hitung Detail

12 OMZET SISA 13 OMZET SISA 14 OMZET SISA 15 OMZET SISAUNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK

- - - - 0 - - 0 - - 0 - - - - 0 - - 0 - - 0

- - - - - - - - - - - - - - - -

Page 8: Hitung Detail

16 OMZET SISA 17 OMZET SISA 18 OMZET SISA 19 OMZET SISAUNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK

- - 0 - - 0 - - 0 - - 0 - - 0 - - 0 - - 0 - - 0

- - - - - - - - - - - - - - - -

Page 9: Hitung Detail

20 OMZET SISA 21 OMZET SISA 22 OMZET SISA 23 OMZET SISAUNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK

- - 0 - - 0 - - 0 - - 0 - - 0 - - 0 - - 0 - - 0

- - - - - - - - - - - - - - - -

Page 10: Hitung Detail

24 OMZET SISA 25 OMZET SISAUNIT OMZET UANG MUKA STOK UNIT OMZET UANG MUKA STOK

- - 0 0 - - 0 - - 0 - -

- - - - - - - -

Page 11: Hitung Detail

Rekapitulasi Biaya

No Uraian Volume Satuan Harga Sat JumlahA Tanah

1 Pembebasan Tanah 7,140 M2 20,000 142,800,000 2 Pematangan lahan 7,140 M2 5,000 35,700,000

Sub Total 178,500,000 B Perijinan

1 Ijin Prinsip/ fatwa bupati 7,140 M2 800 5,712,000 2 Ijin lokasi 7,140 M2 800 5,712,000 3 Peninjauan lokasi 7,140 M2 250 1,785,000 4 Pengukuran & pembuatan site plan 7,140 M2 300 2,142,000 5 Ijin site plan 7,140 M2 1,000 7,140,000 6 Ijin klas jalan / Konpensasi pengurukan 7,140 M2 1,000 7,140,000 7 IMB induk 3,528 M2 5,000 17,640,000 8 IMB splitzing 49 unit 40,000 1,960,000 9 Ijin pengeringan 7,140 M2 300 2,142,000

10 Ijin pelaksanaan pembangunan 3,528 M2 2,000 7,056,000 11 PPAT 49 unit 175,000 8,575,000 12 SK Pendaftaran 7,140 M2 500 3,570,000 13 HGB induk - 14 HGB splitzing 49 M2 600,000 29,400,000 15 Peil banjir 7,140 M2 200 1,428,000

Sub Total 101,402,000 C Sarana Prasarana

1 Paving stone 2,142 M2 39,000 83,538,000 2 Saluran 536 M2 85,000 45,517,500 3 Gorong-gorong 18 M2 250,000 4,462,500 4 Bak sampah 49 unit 60,000 2,940,000 5 Pohon peneduh 49 unit 25,000 1,225,000 6 Patok batas kavling 49 unit 6,000 294,000 7 Plat nomor rumah 49 unit 4,000 196,000 8 Musholla - unit 50,000 - 9 Pos jaga - unit 20,000 -

10 Taman 1,071 M2 750 803,250 11 Papan nama 7,140 M2 300 2,142,000 12 Pintu gerbang 7,140 M2 1,500 10,710,000 13 Jaringan induk listrik 49 unit 2,970,000 145,530,000 14 BP dan UJL 49 unit 1,900,000 93,100,000 15 Biaya jaminan dan gambar 49 unit 50,000 2,450,000 16 PJU 49 unit 200,000 9,800,000 17 Telkom 49 unit - 18 Jaringan induk PDAM unit 150,000 - 19 SR PDAM - unit 696,000 - 19 TPS unit 20,000,000 -

Sub Total 402,708,250 Total 682,610,250 Harga / M2 tanah 105,164

Page 12: Hitung Detail

PROYEKSI RENCANA PENERIMAAN KPR DAN RETENSINO URAIAN JUMLAH 1 2 3 4 5 6 7

1 Omzet 2,150,977,500 39,750,000 131,100,000 262,200,000 262,200,000 262,200,000 262,200,000

2 Proyeksi uang muka (25%) 537,300,000 9,937,500 32,775,000 65,550,000 65,550,000 65,550,000 65,550,000 3 Proyeksi KPR 1,371,625,875 25,340,625 83,576,250 167,152,500 4 Retensi 242,051,625

TOTAL 9,937,500 32,775,000 65,550,000 90,890,625 149,126,250 232,702,500

Page 13: Hitung Detail

8 9 10 11 12 13 14 15 262,200,000 262,200,000 405,150,000 - - - - -

65,550,000 65,550,000 101,287,500 - - - - - 167,152,500 167,152,500 167,152,500 167,152,500 167,152,500 258,283,125 - - 4,471,875 14,748,750 29,497,500 29,497,500 29,497,500 29,497,500 29,497,500 29,497,500 237,174,375 247,451,250 297,937,500 196,650,000 196,650,000 287,780,625 29,497,500 29,497,500

Page 14: Hitung Detail

16 17 18 19 20 21 22 23 24 25 - - - - - - - - - -

- - - - - - - - - - - - - - - - - - - - 45,579,375 - - - - - - - - - 45,579,375 - - - - - - - - -

Page 15: Hitung Detail

26 27 28 29 30 31

- - - - - - - - - - - - - - - - - -

Page 16: Hitung Detail

HARGA POKOK BANGUNANNO TYPE TOTAL LUAS HPP/M2 JUMLAH

UNIT BANG.1 29 32 924 700,000 646,555,000 2 36 17 617 750,000 463,050,000

total 49 1,541 1,109,605,000

HARGA JUAL BANGUNANNO TYPE TOTAL TOTAL HARGA JUMLAH

UNIT BANG. JUAL/M21 29 32 924 750,000 692,737,500 2 36 17 617 850,000 524,790,000

total 49 1,541 1,217,527,500

Selisih harga jual & HPP Bangunan 107,922,500

Page 17: Hitung Detail

RENCANA BIAYA KONSTRUKSI

NO URAIAN UNIT RAB JUMLAH 2 3 4 5 6 7 8Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit

1 29 32 25,200,000 802,620,000 1 25,200,000 2 50,400,000 4 100,800,000 4 100,800,000 4 100,800,000 4 100,800,000 4

2 36 17 33,750,000 578,812,500 - - 1 33,750,000 2 67,500,000 2 67,500,000 2 67,500,000 2 67,500,000 2 TOTAL 49 58,950,000 1,381,432,500 1 25,200,000 3 84,150,000 6 168,300,000 6 168,300,000 6 168,300,000 6 168,300,000 6

Page 18: Hitung Detail

8 9 10 11 12 13 14 15 16 17Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit

100,800,000 4 100,800,000 5 126,000,000 - - - - - - - - - - - - -

67,500,000 2 67,500,000 4 135,000,000 - - - - - - - - - - - - - 168,300,000 6 168,300,000 9 261,000,000 - - - - - - - - - - - - -

Page 19: Hitung Detail

17 18 19 20 21 22 23 24 25Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah Unit Jumlah

- - - - - - - - - - - - - - - - -

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Page 20: Hitung Detail

PROYEKSI RENCANA BIAYA KONSTRUKSI

NO URAIAN 2 3 4 5 6 7 8 9 10

I TOTAL 25,200,000 84,150,000 168,300,000 168,300,000 168,300,000 168,300,000 168,300,000 168,300,000 261,000,000 II Pembayaran

Termijn I (35 %) 8,820,000 29,452,500 58,905,000 58,905,000 58,905,000 58,905,000 58,905,000 Termijn II (60 %) 15,120,000 50,490,000 100,980,000 100,980,000 100,980,000 100,980,000 Retensi (5 %) 1,260,000 4,207,500 8,415,000 JUMLAH - - 8,820,000 44,572,500 109,395,000 159,885,000 161,145,000 164,092,500 168,300,000

Page 21: Hitung Detail

11 12 13 14 15 16 17 18 19 20 21 22

- - - - - - - - - - - -

58,905,000 91,350,000 - - - - - - - - - - 100,980,000 100,980,000 156,600,000 - - - - - - - - - 8,415,000 8,415,000 8,415,000 8,415,000 8,415,000 13,050,000 - - - - - - 168,300,000 200,745,000 165,015,000 8,415,000 8,415,000 13,050,000 - - - - - -

Page 22: Hitung Detail

23 24 25 26 27 28 29 30 31

- - -

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Page 23: Hitung Detail

PROYEKSI BIAYA OPERASIONAL

NO URAIAN JUMLAHI Biaya Kesejahteraan Karyawan

Gaji dan Honor 31 bln 84,500,000 -

II Biaya Operasional Kantor - Bahan bakar Operasional 9,000,000 Fotocopy dan Cetakan 4,500,000 Listrik, telephone dan Air 6,750,000 Biaya operasional lainnya 1,350,000

- III Biaya perjalanan dinas -

- IV Biaya Pemeliharaan Kantor 900,000

- V Biaya Kesehatan & Astek -

TOTAL 107,000,000

Catatan daftar gaji:1. Direktur 2,500,000 2. GM 1,000,000 3. SM 1,000,000 4. Pengawas Lapangan (2 org) 750,000 5. Admn. & Kasir 1,000,000 6. Akuntansi 1,500,000 7. Drafter

8. Office Boy 700,000 Total 8,450,000

Page 24: Hitung Detail

PROYEKSI INVESTASI AKTIVA TETAP & INVENTARIS

NO URAIAN JUMLAH 2 3 4 5 6 7 8 9 10 11 12I Sewa kantor 3,500,000 5,000,000

II KendaraanMobil Operasional - - - Sepeda motor 12,000,000 6,000,000 6,000,000

- III Inventaris Kantor 15,000,000 5,000,000 800,000 800,000 800,000 800,000 800,000 800,000 800,000 800,000 800,000 800,000

- IV Perlengkapan Proyek 5,000,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000

-

TOTAL 35,500,000 16,500,000 1,300,000 1,300,000 7,300,000 1,300,000 1,300,000 1,300,000 1,300,000 1,300,000 1,300,000 1,300,000

Page 25: Hitung Detail

13 14 15 16 17 18

800,000 800,000 800,000 800,000 800,000 800,000

500,000 500,000 500,000 500,000 500,000 500,000

1,300,000 1,300,000 1,300,000 1,300,000 1,300,000 1,300,000

Page 26: Hitung Detail

NO URAIAN JUMLAHI SaldoII Sumber Dana

1. Uang muka 537,300,000 2. KPR 1,371,625,875 3. Retensi 242,051,625 4. Modal Kerja 140,000,000 5. Pinjaman Bank - Jumlah Dana 2,290,977,500

III Penggunaan Dana1. Pembebasan Tanah 142,800,000 2. Perijinan 101,402,000 3. Pematangan Lahan 35,700,000 4. Sarana Prasarana 402,708,250 5. Konstruksi 1,109,605,000 6. Biaya Overhead/operasional 107,000,000 7. Investasi ATB 35,500,000 8. Pemasaran & Promosi 53,730,000 Jumlah Pemakaian Dana 1,988,445,250 Tersedia utk Pelunasan 302,532,250

IV Pelunasan1. Bunga Kredit (18%)2. Pelunasan Kredit3. BPHTB (5%)4. PPN (10%)5. Pengembalian Modal Kerja 140,000,000 Jumlah Pelunasan 140,000,000

V Saldo Akhir 162,532,250

1 2 3 4 106,000,000 92,888,563 71,710,821

9,937,500 32,775,000 65,550,000

106,000,000 30,000,000

106,000,000 145,937,500 125,663,563 137,260,821

25,350,500.00 26,996,875.00 26,996,875.00

13,886,491.38 13,886,491.38 8,820,000.00

10,950,000.00 10,950,000.00 10,950,000.00 16,500,000.00 1,300,000.00 1,300,000.00 248,437.50 819,375 1,638,750

- 53,048,938 53,952,741 63,592,116 106,000,000 92,888,563 71,710,821 73,668,705

- - - - 106,000,000 92,888,563 71,710,821 73,668,705

Page 27: Hitung Detail

NO URAIAN JUMLAHI SaldoII Sumber Dana

1. Uang muka 537,300,000 2. KPR 1,371,625,875 3. Retensi 242,051,625 4. Modal Kerja 140,000,000 5. Pinjaman Bank - Jumlah Dana 2,290,977,500

III Penggunaan Dana1. Pembebasan Tanah 142,800,000 2. Perijinan 101,402,000 3. Pematangan Lahan 35,700,000 4. Sarana Prasarana 402,708,250 5. Konstruksi 1,109,605,000 6. Biaya Overhead/operasional 107,000,000 7. Investasi ATB 35,500,000 8. Pemasaran & Promosi 53,730,000 Jumlah Pemakaian Dana 1,988,445,250 Tersedia utk Pelunasan 302,532,250

IV Pelunasan1. Bunga Kredit (18%)2. Pelunasan Kredit3. BPHTB (5%)4. PPN (10%)5. Pengembalian Modal Kerja 140,000,000 Jumlah Pelunasan 140,000,000

V Saldo Akhir 162,532,250

5 6 7 8 73,668,705 40,731,198 (2,699,075) (288,832,504)

65,550,000 65,550,000 65,550,000 65,550,000 25,340,625 83,576,250 167,152,500 167,152,500

4,471,875

164,559,330 189,857,448 230,003,425 (51,658,129)

26,996,875.00 26,996,875.00 26,996,875.00 26,996,875 17,850,000.00 17,850,000.00 13,886,491.38 13,886,491.38 13,886,491.38 13,886,491 44,572,500.00 109,395,000.00 159,885,000.00 161,145,000 10,950,000.00 19,400,000.00 10,950,000.00 10,950,000 7,300,000.00 1,300,000.00 1,300,000.00 1,300,000.00 2,272,266 3,728,156 5,817,563 5,929,359 123,828,132 192,556,523 218,835,929 220,207,726 40,731,198 (2,699,075) 11,167,496 (271,865,855)

300,000,000 - - 300,000,000 - 40,731,198 (2,699,075) (288,832,504) (271,865,855)

Page 28: Hitung Detail

NO URAIAN JUMLAHI SaldoII Sumber Dana

1. Uang muka 537,300,000 2. KPR 1,371,625,875 3. Retensi 242,051,625 4. Modal Kerja 140,000,000 5. Pinjaman Bank - Jumlah Dana 2,290,977,500

III Penggunaan Dana1. Pembebasan Tanah 142,800,000 2. Perijinan 101,402,000 3. Pematangan Lahan 35,700,000 4. Sarana Prasarana 402,708,250 5. Konstruksi 1,109,605,000 6. Biaya Overhead/operasional 107,000,000 7. Investasi ATB 35,500,000 8. Pemasaran & Promosi 53,730,000 Jumlah Pemakaian Dana 1,988,445,250 Tersedia utk Pelunasan 302,532,250

IV Pelunasan1. Bunga Kredit (18%)2. Pelunasan Kredit3. BPHTB (5%)4. PPN (10%)5. Pengembalian Modal Kerja 140,000,000 Jumlah Pelunasan 140,000,000

V Saldo Akhir 162,532,250

9 10 11 12 (271,865,855) (247,826,752) (178,771,056) (197,520,672)

65,550,000 101,287,500 - - 167,152,500 167,152,500 167,152,500 167,152,500 14,748,750 29,497,500 29,497,500 29,497,500

(24,414,605) 50,110,748 17,878,944 (870,672)

26,996,875 26,996,875 26,996,875 26,996,875

13,886,491 13,886,491 13,886,491 13,886,491 164,092,500 168,300,000 168,300,000 200,745,000 10,950,000 10,950,000 - - 1,300,000.00 1,300,000.00 1,300,000.00 1,300,000.00 6,186,281 7,448,438 4,916,250 4,916,250 223,412,148 228,881,804 215,399,616 247,844,616 (247,826,752) (178,771,056) (197,520,672) (248,715,289)

- - - - (247,826,752) (178,771,056) (197,520,672) (248,715,289)

Page 29: Hitung Detail

NO URAIAN JUMLAHI SaldoII Sumber Dana

1. Uang muka 537,300,000 2. KPR 1,371,625,875 3. Retensi 242,051,625 4. Modal Kerja 140,000,000 5. Pinjaman Bank - Jumlah Dana 2,290,977,500

III Penggunaan Dana1. Pembebasan Tanah 142,800,000 2. Perijinan 101,402,000 3. Pematangan Lahan 35,700,000 4. Sarana Prasarana 402,708,250 5. Konstruksi 1,109,605,000 6. Biaya Overhead/operasional 107,000,000 7. Investasi ATB 35,500,000 8. Pemasaran & Promosi 53,730,000 Jumlah Pemakaian Dana 1,988,445,250 Tersedia utk Pelunasan 302,532,250

IV Pelunasan1. Bunga Kredit (18%)2. Pelunasan Kredit3. BPHTB (5%)4. PPN (10%)5. Pengembalian Modal Kerja 140,000,000 Jumlah Pelunasan 140,000,000

V Saldo Akhir 162,532,250

13 14 15 16 (248,715,289) (575,327,546) (597,165,850) (619,004,154)

- - - - 258,283,125 - - - 29,497,500 29,497,500 29,497,500 45,579,375

39,065,336 (545,830,046) (567,668,350) (573,424,779)

26,996,875 26,996,875 26,996,875 26,996,875

13,886,491 13,886,491 13,886,491 13,886,491 165,015,000 8,415,000 8,415,000 13,050,000 - - - - 1,300,000.00 1,300,000.00 1,300,000.00 1,300,000.00 7,194,516 737,438 737,438 1,139,484 214,392,882 51,335,804 51,335,804 56,372,851 (175,327,546) (597,165,850) (619,004,154) (629,797,629)

400,000,000 400,000,000 - - - (575,327,546) (597,165,850) (619,004,154) (629,797,629)

Page 30: Hitung Detail

NO URAIAN JUMLAHI SaldoII Sumber Dana

1. Uang muka 537,300,000 2. KPR 1,371,625,875 3. Retensi 242,051,625 4. Modal Kerja 140,000,000 5. Pinjaman Bank - Jumlah Dana 2,290,977,500

III Penggunaan Dana1. Pembebasan Tanah 142,800,000 2. Perijinan 101,402,000 3. Pematangan Lahan 35,700,000 4. Sarana Prasarana 402,708,250 5. Konstruksi 1,109,605,000 6. Biaya Overhead/operasional 107,000,000 7. Investasi ATB 35,500,000 8. Pemasaran & Promosi 53,730,000 Jumlah Pemakaian Dana 1,988,445,250 Tersedia utk Pelunasan 302,532,250

IV Pelunasan1. Bunga Kredit (18%)2. Pelunasan Kredit3. BPHTB (5%)4. PPN (10%)5. Pengembalian Modal Kerja 140,000,000 Jumlah Pelunasan 140,000,000

V Saldo Akhir 162,532,250

17 18 19 20 (629,797,629) (671,980,996) (952,810,612) (967,997,103)

- - - - - - - - - - - -

(629,797,629) (671,980,996) (952,810,612) (967,997,103)

26,996,875 15,643,125

13,886,491 13,886,491 13,886,491 13,886,491 - - - - - - - - 1,300,000.00 1,300,000.00 1,300,000.00 1,300,000.00 - - - - 42,183,366 30,829,616 15,186,491 15,186,491 (671,980,996) (702,810,612) (967,997,103) (983,183,595)

250,000,000 - 250,000,000 - - (671,980,996) (952,810,612) (967,997,103) (983,183,595)

Page 31: Hitung Detail

NO URAIAN JUMLAHI SaldoII Sumber Dana

1. Uang muka 537,300,000 2. KPR 1,371,625,875 3. Retensi 242,051,625 4. Modal Kerja 140,000,000 5. Pinjaman Bank - Jumlah Dana 2,290,977,500

III Penggunaan Dana1. Pembebasan Tanah 142,800,000 2. Perijinan 101,402,000 3. Pematangan Lahan 35,700,000 4. Sarana Prasarana 402,708,250 5. Konstruksi 1,109,605,000 6. Biaya Overhead/operasional 107,000,000 7. Investasi ATB 35,500,000 8. Pemasaran & Promosi 53,730,000 Jumlah Pemakaian Dana 1,988,445,250 Tersedia utk Pelunasan 302,532,250

IV Pelunasan1. Bunga Kredit (18%)2. Pelunasan Kredit3. BPHTB (5%)4. PPN (10%)5. Pengembalian Modal Kerja 140,000,000 Jumlah Pelunasan 140,000,000

V Saldo Akhir 162,532,250

21 22 23 24 (983,183,595) (998,370,086) (1,013,556,578) (1,028,743,069)

- - - - - - - - - - - -

(983,183,595) (998,370,086) (1,013,556,578) (1,028,743,069)

13,886,491 13,886,491 13,886,491 13,886,491 - - - - - - - - 1,300,000.00 1,300,000.00 1,300,000.00 1,300,000.00 - - - - 15,186,491 15,186,491 15,186,491 15,186,491 (998,370,086) (1,013,556,578) (1,028,743,069)

400,000,000.00 - - - 400,000,000.00 (998,370,086) (1,013,556,578) (1,028,743,069) (1,443,929,560)

Page 32: Hitung Detail

NO URAIAN JUMLAHI SaldoII Sumber Dana

1. Uang muka 537,300,000 2. KPR 1,371,625,875 3. Retensi 242,051,625 4. Modal Kerja 140,000,000 5. Pinjaman Bank - Jumlah Dana 2,290,977,500

III Penggunaan Dana1. Pembebasan Tanah 142,800,000 2. Perijinan 101,402,000 3. Pematangan Lahan 35,700,000 4. Sarana Prasarana 402,708,250 5. Konstruksi 1,109,605,000 6. Biaya Overhead/operasional 107,000,000 7. Investasi ATB 35,500,000 8. Pemasaran & Promosi 53,730,000 Jumlah Pemakaian Dana 1,988,445,250 Tersedia utk Pelunasan 302,532,250

IV Pelunasan1. Bunga Kredit (18%)2. Pelunasan Kredit3. BPHTB (5%)4. PPN (10%)5. Pengembalian Modal Kerja 140,000,000 Jumlah Pelunasan 140,000,000

V Saldo Akhir 162,532,250

25 26 27 28 (1,443,929,560) (1,459,116,052) (1,474,302,543) (1,489,489,034)

- - - - - - - - - - - -

(1,443,929,560) (1,459,116,052) (1,474,302,543) (1,489,489,034)

13,886,491 13,886,491 13,886,491 13,886,491 - - - - - - - - 1,300,000.00 1,300,000.00 1,300,000.00 1,300,000.00 - - - - 15,186,491 15,186,491 15,186,491 15,186,491

(1,459,116,052) (1,474,302,543) (1,489,489,034) (1,504,675,526)

Page 33: Hitung Detail

NO URAIAN JUMLAHI SaldoII Sumber Dana

1. Uang muka 537,300,000 2. KPR 1,371,625,875 3. Retensi 242,051,625 4. Modal Kerja 140,000,000 5. Pinjaman Bank - Jumlah Dana 2,290,977,500

III Penggunaan Dana1. Pembebasan Tanah 142,800,000 2. Perijinan 101,402,000 3. Pematangan Lahan 35,700,000 4. Sarana Prasarana 402,708,250 5. Konstruksi 1,109,605,000 6. Biaya Overhead/operasional 107,000,000 7. Investasi ATB 35,500,000 8. Pemasaran & Promosi 53,730,000 Jumlah Pemakaian Dana 1,988,445,250 Tersedia utk Pelunasan 302,532,250

IV Pelunasan1. Bunga Kredit (18%)2. Pelunasan Kredit3. BPHTB (5%)4. PPN (10%)5. Pengembalian Modal Kerja 140,000,000 Jumlah Pelunasan 140,000,000

V Saldo Akhir 162,532,250

29 30 31 (1,504,675,526) (1,519,862,017) (1,535,048,509)

- - - - - - - - -

(1,504,675,526) (1,519,862,017) (1,535,048,509)

142,800,000

13,886,491 13,886,491 13,886,491 - - - - - - 1,300,000.00 1,300,000.00 1,300,000.00 - - 0 15,186,491 15,186,491 157,986,491

(1,519,862,017) (1,535,048,509) (1,693,035,000)