Scribd
Upload
48 views1 page

Harga Jual A Pemasukan: Cashflow Projection

The document is a cash flow projection for a housing development project called Perumahan Triji in Sukabumi, Indonesia for the years 2019-2020. It projects revenue from home sales, down payments, certificate receipts, and mortgage loans. It also projects expenses for construction, legal fees, loan payments, operational costs, and investor returns. The projection shows a positive cash flow and balance for most months except for dips in April, June, August, October, and December 2020 when large investor repayments are made.

Uploaded by

bayu tantra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
48 views1 page

Harga Jual A Pemasukan: Cashflow Projection

The document is a cash flow projection for a housing development project called Perumahan Triji in Sukabumi, Indonesia for the years 2019-2020. It projects revenue from home sales, down payments, certificate receipts, and mortgage loans. It also projects expenses for construction, legal fees, loan payments, operational costs, and investor returns. The projection shows a positive cash flow and balance for most months except for dips in April, June, August, October, and December 2020 when large investor repayments are made.

Uploaded by

bayu tantra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

CASHFLOW PROJECTION

PERUMAHAN TRIJI, SUKABUMI


2019 2020
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN JUL
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
HARGA JUAL 137,000,000
UNIT AKAN DIJUAL 168 20 20 20 20 20 20 20 28

A PEMASUKAN
MODAL AWAL INVESTOR 2,400,000,000 1,400,000,000 500,000,000 500,000,000
DP & BIAYA LAIN2 KONSUMEN (ALL IN) 9,000,000 470,400,000 56,000,000 - 56,000,000 - 56,000,000 - 56,000,000 - 56,000,000 - 56,000,000 - 56,000,000 - 78,400,000
PENERIMAAN RETENSI (SERTIFIKAT)* 6,200,000 1,041,600,000 124,000,000 - 124,000,000 - 124,000,000 - 124,000,000 - 124,000,000 - 124,000,000 - 124,000,000 - 173,600,000

KPR BTN 130,150,000 21,865,200,000 2,603,000,000 - 2,603,000,000 - 2,603,000,000 - 2,603,000,000 - 2,603,000,000 - 2,603,000,000 - 2,603,000,000 - 3,644,200,000 - - -
SUB TOTAL : 139,150,000 25,777,200,000 1,400,000,000 2,659,000,000 500,000,000 2,659,000,000 624,000,000 2,659,000,000 124,000,000 2,659,000,000 124,000,000 2,659,000,000 124,000,000 2,659,000,000 124,000,000 2,659,000,000 124,000,000 3,722,600,000 124,000,000 - 173,600,000

B PENGELUARAN -
1 KONSTRUKSI -
BANGUN RUMAH 47,500,000 7,980,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 475,000,000 665,000,000 665,000,000 - - -
BANGUN JALAN & SALURAN (UNIT) 5,000,000 840,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 140,000,000
INFRASTRUKTUR LINGKUNGAN 700,000,000 700,000,000 - - - - - 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000
SUMUR ARTESIS 400,000,000 400,000,000 200,000,000 200,000,000
2 AKAD KPR -
split SHGB 1,500,000 252,000,000 252,000,000
notaris + pajak 8,500,000 1,428,000,000 170,000,000 - 170,000,000 - 170,000,000 - 170,000,000 - 170,000,000 - 170,000,000 - 170,000,000 - 238,000,000 - - - -
SLF 200,000 33,600,000 4,000,000 - 4,000,000 - 4,000,000 - 4,000,000 - 4,000,000 - 4,000,000 - 4,000,000 - 5,600,000 - - - -
LPA 350,000 58,800,000 7,000,000 - 7,000,000 - 7,000,000 - 7,000,000 - 7,000,000 - 7,000,000 - 7,000,000 - 9,800,000 - - - -
split IMB 200,000 33,600,000 4,000,000 - 4,000,000 - 4,000,000 - 4,000,000 - 4,000,000 - 4,000,000 - 4,000,000 - 5,600,000 - - - -
PLN 1,150,000 193,200,000 23,000,000 - 23,000,000 - 23,000,000 - 23,000,000 - 23,000,000 - 23,000,000 - 23,000,000 - 32,200,000 - - - -
sales fee 1,500,000 252,000,000 30,000,000 - 30,000,000 - 30,000,000 - 30,000,000 - 30,000,000 - 30,000,000 - 30,000,000 - 42,000,000 - - - -
3 SISA OUTSTANDING
POKOK KPL & KYG 78,000,000 4,680,000,000 1,560,000,000 - 1,560,000,000 - 1,560,000,000 - - - - - -
BULANAN KPL & KYG 70,000,000 420,000,000 70,000,000 70,000,000 70,000,000 70,000,000 70,000,000 70,000,000 -
PENGEMBALIAN MODAL INVESTOR 2,400,000,000 1,400,000,000 500,000,000 500,000,000 -
PEMBAGIAN LABA INVESTOR 2,154,400,000

4 OPERASIONAL (office & marketing) 720,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 -

SUB TOTAL : 20,391,200,000 1,275,000,000 2,445,000,000 823,000,000 2,245,000,000 823,000,000 2,245,000,000 753,000,000 715,000,000 853,000,000 715,000,000 853,000,000 715,000,000 2,253,000,000 1,215,000,000 1,538,200,000 845,000,000 40,000,000 2,194,400,000 -
-
SALDO 5,386,000,000 125,000,000 214,000,000 (323,000,000) 414,000,000 (199,000,000) 414,000,000 (629,000,000) 1,944,000,000 (729,000,000) 1,944,000,000 (729,000,000) 1,944,000,000 (2,129,000,000) 1,444,000,000 (1,414,200,000) 2,877,600,000 84,000,000 (2,194,400,000) 173,600,000
AKUMULATIF SALDO 3,231,600,000 125,000,000 339,000,000 16,000,000 430,000,000 231,000,000 645,000,000 16,000,000 1,960,000,000 1,231,000,000 3,175,000,000 2,446,000,000 4,390,000,000 2,261,000,000 3,705,000,000 2,290,800,000 5,168,400,000 5,252,400,000 3,058,000,000 3,231,600,000

You might also like