Perhitungan Iex
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Perhitungan Iex as PDF for free.
More details
- Words: 5,646
- Pages: 28
CASH FLOW PROJECTION OF MCV SELLING PRICE Type of Villas
1 Vila Type A (ex pool)
Cost
Land area Sqm
Unit
Land price Rp.m/sqm
27
3,000
300
-
-
0
Sqm
1 Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance: 1.5% Build+pools 2 Land Cost Macro Cost Micro Infra Cost 3 Others Permits & Licenses Hotel Operator Fee Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
Building area Sqm
8,100 3,240 8,100
Rpm./sqm
0.18 0.05
14,337 5,786
Total Land Sqm
5.5
2006 2Q
32,400 6,480 16,200 3,110 1,166 1,166 583
81,000 115,714
0.6
Total
4 2 2
Building price Rp.m/sqm
3,110
5,627
Total Building Sqm
81,000
8,100
0 81,000
8,100
2006 3Q
2006 4Q
Selling Price Rp.m 5,750 -
2007 1Q
Selling Price US$. Tho
Total Price Rp. M
625
155,250
-
155,250
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
-
960 192 480
1,920 384 960
3,360 672 1,680
4,800 960 2,400
5,760 1,152 2,880
5,700 1,140 2,850
4,740 948 2,370
3,300 660 1,650
1,860 372 930
900 180 450
300 -
620 194 35 17
900 194 69 35
194 121 60
194 173 86
194 207 104
1,290 194 205 103
171 85
119 59
67 33
32 16
14,337 500
500
827
900
900
1,000
1,000
500 388
388 -
388 -
388 -
3,000 3,881 6,210 4,658 500
388 -
500 388 2,484 1,150 250
500 388 1,553 1,150 250
500 388 932 1,725
500 388 1,242 1,725
1,150
500 388 863 863
98,978
15,525
7,770
9,129
10,532
13,369
13,336
15,095
8,702
6,176
3,651
45 1,624
Collection
-
5,750
9,200
15,525
20,700
25,300
25,013
20,988
16,388
10,063
5,463
Net Cash
(15,525)
(2,020)
4,993
7,331
11,964
9,917
12,285
10,211
6,412
3,839
(17,545) -
(17,475) 71
(12,482) 4,993
49,478 3,839
(3,709) 1,284
16,731 4,917 (5,000) 16,160
45,639 6,412
(71) -
6,814 6,964 (5,000) 11,243
39,227 10,211
2,020 -
(5,151) 2,994 (4,337) 4,278
29,016 12,285
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(15,525) 14,337 1,188 -
28,445
38,656
45,068
48,907
Loan At Start Interest Capitalised Repayment Loan At End
1,188 59 1,248
3,268 163 3,431
3,431 172 (71) 3,532
3,532 177 (3,709) -
-
-
-
-
-
-
-
Total
IRR NPV Discount
96% 34,368 15%
71
Sqm Land 1 Land 2 Macro 3 Micro
Rp.m
81,000 81,000
14,337 5,786
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental & set up Developer's Overheads: 2,5 % Sales Promotion & Advertising: 5% of Sales Commision: 5% of Sales Legal & Accounting
8,100 8,100 8,100
32,400 6,480 16,200
4,000 800 2,000
8,100 8,100 8,100 8,100
3,110 1,166 1,166 583
384 144 144 72 7,544
81,000 81,000 81,000 81,000 81,000 81,000 81,000
3,000 1,200 3,881 6,210 4,658 500
37 15 48 77 58 6 240
Profit and Loss per Unit Selling Price (Rp. m)
5,750
Cost Land (Sqm) Building (Sqm) Land Cost (Rp. m) Building Cost (Rp m)
3,000 300 745 2,263
GAE & Marketing per Unit Total Cost per unit
177 71 248
Cost of others expense per sqm
Cost per unit vila (before GAE & marketing)
Rp.th/sqm
3,008 720 3,729
Profit and Loss Before GAE (Rp.m)
2,742 48%
Profit and Loss After GAE (Rp.m)
2,021
35%
CASH FLOW PROJECTION OF ZONE 1 SELLING PRICE Type of Villas
Land area Sqm
Unit
1 Vila Type A 2 Vila Type B 3 Vila Type C
15 50
Building area Sqm
3,000 1,000
Land price Rp.m/sqm
Building price Rp.m/sqm
Total Land Sqm
300 150
45,000 50,000 95,000
65
Cost
Sqm
1 Construction Building Cost Pools Type A Pools Type B FF&E Fees Architect Fee Enginnering Fee, QS CM Insurance: 1.5% Construction Cost 2 Land Cost Macro Micro 3 Others Permits & Licenses Hotel Operator Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
12,000 1,800 2,000 12,000
95,000 135,714
Rpm./sqm
4 2 2 2
0.18 0.05
Total Building Sqm
2005 2Q
Total
48,000 3,600 4,000 24,000
2005 3Q
-
4,500 7,500 12,000 2005 4Q
Selling Price Rp.m 5,750 2,500 -
2006 1Q
Selling Price US$. Tho
Total Price Rp. M
625 272 -
2006 2Q
86,250 125,000 211,250 2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
1,920 144 160 960
3,840 288 320 1,920
5,040 378 420 2,520
6,480 486 540 3,240
7,680 576 640 3,840
6,960 522 580 3,480
5,760 432 480 2,880
4,560 342 380 2,280
3,120 234 260 1,560
1,920 144 160 960
720 54 60 360
600 258 124 58
1000 258 163 76
1,000 258 209 97
1,028 258 248 115
258 224 104
186 86
147 68
101 47
62 29
23 11
900
986
587 863
587 -
-
-
-
4,128 1,548 1,548 720
-
500 258 62 29
16,815 6,786
16,815 500
500
900
700
800
800
900
3,000 5,281 8,450 6,338 500
587 -
500 587 2,535 2,075 250
500 587 1,690 2,075
500 587 1,268 1,288 250
500 587 1,268 1,575
500 587 845 1,325
500 587 845 1,363
134,213
17,902
10,480
13,159
14,446
17,039
18,442
16,323
12,173
9,350
5,321
3,275
1,228
Collection
-
8,300
14,525
17,600
22,613
30,488
32,538
26,825
21,100
16,450
12,050
7,038
Net Cash
(17,902)
(2,180)
1,366
3,154
5,573
12,046
16,214
14,652
11,750
11,129
8,775
5,809
16,815 1,087 -
1,366
3,154
5,573
11,129
8,775
5,809
(1,366) -
(2,410) 744
6,317
6,214 (10,000) 17,762
11,750
2,180 -
5,231 (6,815) 11,548
14,652
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
32,414
44,163
55,292
64,067
69,877
Loan At Start Interest Capitalised Repayment Loan At End
1,087 54 1,141
3,321 166 3,487
3,487 174 (1,366) 2,295
2,295 115 (2,410) -
-
-
-
-
-
-
-
-
Interest Rate
5%
5%
5%
5%
5%
5%
5%
5%
5%
5%
5%
5%
Total
irr NPV Discount
105% 48,130 15%
-
Sqm Land 1 Land 2 Macro 3 Micro
Rp.m
95,000 95,000
Rp.th/sqm
16,815 6,786
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
248
12,000 12,000 12,000
48,000 7,600 24,000
4,000 633 2,000
12,000 12,000 12,000 12,000
4,128 1,548 1,548 720
344 129 129 60 7,295
95,000 95,000 95,000 95,000 95,000 95,000 95,000
3,000 1,200 5,281 8,450 6,338 500
32 13 56 89 67 5
Cost of others expense per sqm
261
Profit and Loss per Unit Type A
Type B
Selling Price (Rp. m)
5,750
2,500
Cost Land (Sqm) Building (Sqm) Land Cost (Rp. m) Building Cost (Rp m)
3,000 300 745 2,189
1,000 150 248 1,094
2,934
1,343
782
261
3,716
1,603
Profit and Loss Before GAE (Rp.m)
2,816 49%
1,157 46%
Profit and Loss After GAE (Rp.m)
2,034
897
Cost per unit vila (before GAE & marketing) GAE & Marketing per Unit Total Cost per unit
177 71
35%
36%
CASH FLOW PROJECTION OF WEST WING Total
2005 2Q
2005 3Q
2005 4Q
2006 1Q
2006 2Q
2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
2009 1Q
Sales (unit) MCV Zone 1 Vila A Vila B Vila C
27
-
4
4
6
6
4
3
-
15 50 -
-
2 12 -
2 12 -
Total
92
-
14
155,250 209,525
-
366,500
-
-
1 8 -
2 8 -
2 6 -
3 4 -
3 -
-
-
-
-
14
9
10
12
11
9
6
4
3
-
-
-
-
-
8,300
14,525
17,600
22,613
5,750 30,488
9,200 32,538
15,525 26,825
20,700 21,100
25,300 16,450
25,013 12,050
20,988 7,038
16,388 1,725
10,063 -
5,463 -
863 -
-
8,300
14,525
17,600
22,613
36,238
41,738
42,350
41,800
41,750
37,063
28,025
18,113
10,063
5,463
863
104,909 139,139
17,902
10,480
13,159
14,446
15,525 17,039
7,770 18,442
9,129 16,323
10,532 12,173
13,369 9,350
13,336 5,321
15,095 3,275
8,702 1,228
6,176 -
3,651 -
1,624 -
-
1,200 600
360 300
60 300
60
60
60
60
60
60
60
60
60
60
60
60
60
2,200 1,100 2,250 251,398
880 440
1,320 660
19,882
12,820
900 14,119
1,350 15,856
32,625
26,272
25,512
22,766
22,779
18,717
18,430
9,990
6,236
3,711
1,684
-
(4,520) (24,401) -
406 (23,996) 406
1,744 (22,252) 1,744
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(19,882) (19,882) 16,815 3,067 -
4,520 -
(406) -
(1,744) -
(10,012) (32,264) 4,325 14,337 (4,325) -
9,965 (22,298) 1,965 (8,000) (1,965) -
16,225 (6,073) 225 (16,000) (225) -
19,584 13,511 12,432 (7,152) (843) 11,589
19,021 32,532 19,021 30,610
23,033 55,565 23,033
18,632 74,197 18,632
18,035 92,232 18,035
11,876 104,109 11,876
6,352
3,779
863
53,643
72,276
90,311
102,187
108,539
112,318
113,180
Loan At Start Interest Capitalised Repayment Loan At End
3,067 153 3,220
7,740 387 8,127
8,127 406 (406) 8,127
8,127 406 (1,744) 6,790
6,790 339 (4,325) 2,804
2,804 140 (1,965) 979
979 49 (225) 803
803 40 (843) -
-
-
-
-
-
-
-
-
Revenue Collection MCV Collection Zone 1 Total Revenue Cost MCV Cost Zone 1 Cost Others Office stet up and rental Master Planning Entrance Gate & Parking Boarding Mock Up: Zone 1 Type A Zone 1 Type B MCV Total Cost Surplus/(defisit)
Sqm Land 1 Land 2 Macro 3 Micro 4 Master Planning
Rp.m
81,000 115,714 81,000
14,337 5,786 276
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Mock Up Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental & set up Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
8,100 3,240 8,100
32,400 6,480 16,200
4,000 2,000 2,000
8,100 8,100 8,100 8,100 8,100
3,110 1,166 1,166 583 2,250
384 144 144 72 278 9,022
81,000 81,000 81,000 81,000 81,000 81,000 81,000
3,000 552 3,881 6,210 4,658 500
37 7 48 77 58 6 232
Profit and Loss per Unit Selling Price (Rp. m)
5,750
Cost Land (Sqm) Building (Sqm) Land Cost (Rp. m) Building Cost (Rp m)
3,000 300 691 2,707
GAE & Marketing per Unit Total Cost per unit Profit and Loss Before GAE (Rp.m)
177 50 3 230
Cost of others expense per sqm
Cost per unit vila (before GAE & marketing)
Rp.th/sqm
3,398 696 4,094 2,352 41%
Profit and Loss After GAE (Rp.m)
1,656 29%
CASH FLOW PROJECTION OF MCV SELLING PRICE Type of Villas
1 Vila Type A (ex pool)
Cost
Land area Sqm
Unit
Land price Rp.m/sqm
27
3,000
300
-
-
0
Sqm
1 Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance: 1.5% Build+pools 2 Land Cost Macro Cost Micro Infra Cost 3 Others Permits & Licenses Hotel Operator Fee Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
Building area Sqm
8,100 3,240 8,100
Rpm./sqm
0.18 0.05
14,337 5,786
Total Land Sqm
5.5
2006 2Q
32,400 6,480 16,200 3,110 1,166 1,166 583
81,000 115,714
0.6
Total
4 2 2
Building price Rp.m/sqm
3,110
5,786
Total Building Sqm
81,000
8,100
0 81,000
8,100
2006 3Q
2006 4Q
Selling Price Rp.m 5,750 -
2007 1Q
Selling Price US$. Tho
Total Price Rp. M
625
155,250
-
155,250
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
-
960 192 480
1,920 384 960
3,360 672 1,680
4,800 960 2,400
5,760 1,152 2,880
5,520 1,104 2,760
4,560 912 2,280
3,120 624 1,560
1,680 336 840
720 144 360
300 -
620 194 35 17
900 194 69 35
194 121 60
194 173 86
194 207 104
1,290 194 199 99
164 82
112 56
60 30
26 13
14,337 500
500
986
900
900
1,000
1,000
3,000 3,881 6,210 4,658 500
388 -
500 388 920 690 250
500 388 920 690 250
500 388 1,380 1,035
500 388 1,380 1,035
500 388 920 690
500 388 690 518
388 -
388 -
388 -
99,478
15,525
5,746
8,196
10,291
12,817
13,796
14,262
8,386
5,861
3,335
1,263
Collection
-
5,750
9,200
15,525
20,700
25,300
25,013
20,988
16,388
10,063
5,463
Net Cash
(15,525)
11,504
10,750
Total
IRR NPV Discount
1,004
5,234
7,883
12,601
10,527
6,728
4,200
(15,521) 4
(14,518) 1,004
(9,284) 5,234
54,910 4,200
(386) 4,848
20,854 5,750 (5,000) 20,649
50,710 6,728
(1,004) -
10,104 6,504 (5,000) 14,899
43,982 10,527
(4) -
(1,400) 3,546 (4,337) 8,394
33,456 12,601
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(15,525) 14,337 1,188 -
33,250
43,777
50,505
54,704
Loan At Start Interest Capitalised Repayment Loan At End
1,188 59 1,248
1,248 62 (4) 1,306
1,306 65 (1,004) 368
368 18 (386) -
-
-
-
-
-
-
-
119% 39,502 15%
4
CASH FLOW PROJECTION OF ZONE 1 SELLING PRICE Type of Villas
Land area Sqm
Unit
1 Vila Type A 2 Vila Type B 3 Vila Type C
15 50
Building area Sqm
3,000 1,000
Land price Rp.m/sqm
Building price Rp.m/sqm
Total Land Sqm
300 150
45,000 50,000 95,000
65
Cost
Sqm
1 Construction Building Cost Pools Type A Pools Type B FF&E Fees Architect Fee Enginnering Fee, QS CM Insurance: 1.5% Construction Cost 2 Land Cost Macro Micro 3 Others Permits & Licenses Hotel Operator Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
12,000 1,800 2,000 12,000
95,000 135,714
Rpm./sqm
4 2 2 2
0.18 0.05
Total Building Sqm
2005 2Q
Total
48,000 3,600 4,000 24,000
2005 3Q
-
4,500 7,500 12,000 2005 4Q
Selling Price Rp.m
Selling Price US$. Tho
5,750 2,500 -
2006 1Q
Total Price Rp. M
625 272 -
2006 2Q
86,250 125,000 211,250 2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
1,920 144 160 960
3,840 288 320 1,920
5,040 378 420 2,520
6,480 486 540 3,240
7,680 576 640 3,840
6,960 522 580 3,480
5,760 432 480 2,880
4,560 342 380 2,280
3,120 234 260 1,560
1,920 144 160 960
720 54 60 360
600 258 124 58
1000 258 163 76
1,000 258 209 97
1,028 258 248 115
258 224 104
186 86
147 68
101 47
62 29
23 11
4,128 1,548 1,548 720
-
500 258 62 29
16,815 6,786
16,815 500
500
900
700
800
800
900
900
786
3,000 5,281 8,450 6,338 500
587 -
500 587 1,660 1,245 250
500 587 1,660 1,245
500 587 1,030 773 250
500 587 1,260 945
500 587 1,060 795
500 587 1,090 818
587 690 518
587 -
-
-
-
134,714
17,902
8,775
12,299
13,693
16,402
18,127
16,023
12,518
9,150
5,321
3,275
1,228
Collection
-
8,300
14,525
17,600
22,613
30,488
32,538
26,825
21,100
16,450
12,050
7,038
Net Cash
(17,902)
(475)
2,226
3,907
6,211
12,361
-
2,226
3,907
6,211
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
16,815 1,087 -
475 -
(1,781) 444
4,351
Loan At Start Interest Capitalised Repayment Loan At End
1,087 54 1,141
1,616 81 1,696
1,696 85 (1,781) -
Interest Rate
5%
5%
5%
Total
irr NPV Discount
118% 53,104 15%
16,514
14,307
11,950
11,129
8,775
5,809
6,514 (10,000) 22,622
14,307
11,950
11,129
8,775
5,809
10,562
5,546 (6,815) 16,107
36,928
48,878
60,007
68,782
74,591
-
-
-
-
-
-
-
-
-
5%
5%
5%
5%
5%
5%
5%
5%
5%
PROFIT & LOSS CALCULATION OF ZONE 1 Standard Cost per Component
TYPE A Sqm
Land 1 Land 2 Macro 3 Micro 4 Master Planning
45,000 64,286 45,000
Rp.m
Rp.th/sqm
7,965 3,214 153
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Mock Up Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
177 50 3.4 230
4,500 1,800 4,500
18,000 3,600 9,000
4,000 2,000 2,000
4,500 4,500 4,500 4,500 4,500
1,548 581 581 270 #VALUE!
344 129 129 60 #VALUE! #VALUE!
45,000 45,000 45,000 45,000 45,000 45,000 45,000
1,421 307 2,502 4,003 3,002 237
32 7 56 89 67 5
Cost of others expense per sqm
255
Profit and Loss per Unit Type A
Type B
Selling Price (Rp. m)
5,750
2,500
Cost Land (Sqm) Building (Sqm)
3,000 300
1,000 150
Land Cost (Rp. m) Building Cost (Rp m)
691 #VALUE!
230 #VALUE!
Cost per unit vila (before GAE & marketing)
#VALUE!
#VALUE!
765
255
#VALUE!
#VALUE!
Profit and Loss Before GAE (Rp.m)
#VALUE! #VALUE!
#VALUE! #VALUE!
Profit and Loss After GAE (Rp.m)
#VALUE! #VALUE!
#VALUE! #VALUE!
GAE & Marketing per Unit Total Cost per unit
FILE A-West wing Menjangan likely scenario.xls HPP Z1 - 1
TYPE B Sqm
50,000 71,429 50,000
Rp.m
8,850 3,572 170
Rp.th/sqm
177 50 3.4 230
7,500 2,000 7,500 7,500 7,500 7,500 7,500 7,500
50,000 50,000 50,000 50,000 50,000 50,000 50,000
30,000 4,000 15,000
4,000 2,000 2,000
2,580 344 968 129 968 129 450 60 #VALUE! #VALUE! #VALUE!
1,579 341 2,780 4,447 3,336 263
32 7 56 89 67 5
255
CASH FLOW PROJECTION OF WEST WING Total
2005 2Q
2005 3Q
2005 4Q
2006 1Q
2006 2Q
2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
2009 1Q
Sales (unit) MCV Zone 1 Vila A Vila B Vila C
27
-
4
4
6
6
4
3
-
15 50 -
-
2 12 -
2 12 -
Total
92
-
14
-
-
-
1 8 -
2 8 -
2 6 -
3 4 -
3 -
-
-
-
-
14
9
10
12
11
9
6
4
3
-
-
-
-
-
8,300
14,525
17,600
22,613
5,750 30,488
9,200 32,538
15,525 26,825
20,700 21,100
25,300 16,450
25,013 12,050
20,988 7,038
16,388 1,725
10,063 -
5,463 -
863 -
-
8,300
14,525
17,600
22,613
36,238
41,738
42,350
41,800
41,750
37,063
28,025
18,113
10,063
5,463
863
17,902
8,775
12,299
13,693
15,525 16,402
5,746 18,127
8,196 16,023
10,291 12,518
12,817 9,150
13,796 5,321
14,262 3,275
8,386 1,228
5,861 -
3,335 -
1,263 -
-
360 300
60 300
60
60
60
60
60
60
60
60
60
60
60
60
60
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE!
#VALUE!
12,359
13,753
31,987
23,933
24,279
22,869
22,027
19,177
17,597
9,674
5,921
3,395
1,323
-
#VALUE! #VALUE! #VALUE!
2,166 #VALUE! 2,166
3,847 #VALUE! 3,847
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
#VALUE! #VALUE! #VALUE! 16,815 #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
(9,375) #VALUE! 4,962 14,337 #VALUE! #VALUE!
12,304 #VALUE! #VALUE! (8,000) #VALUE! #VALUE! #VALUE!
17,458 #VALUE! #VALUE! (16,000) #VALUE! #VALUE! #VALUE!
19,481 #VALUE! #VALUE! (7,152) #VALUE! #VALUE! #VALUE!
19,773 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
22,573 #VALUE! #VALUE!
19,466 #VALUE! #VALUE!
18,351 #VALUE! #VALUE!
12,192 #VALUE! #VALUE!
6,668
4,140
863
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
Loan At Start Interest Capitalised Repayment Loan At End
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
Revenue Collection MCV Collection Zone 1 Total Revenue
155,250 211,250 366,500
Cost MCV Cost Zone 1 Cost Others Office stet up and rental Master Planning Entrance Gate & Parking Boarding Mock Up: Zone 1 Type A Zone 1 Type B MCV Total Cost
99,478 134,714 1,200 600 #VALUE! #VALUE! #VALUE!
Surplus/(defisit)
WIRELESS DATA & VOICE NETWORK WITH CISCO SYSTEM DISTANCE 5000 METER, bandwidth 1 Mbyte RADIO ANTENA (TOWER) TABLE NO KODE GAMBAR
NAMA PRODUK CISCO
KODE PRODUK CISCO
1 A1
2.4 GHz 12 Dbi Omni Mast Mt. Antenna with RP-TNC Connector
AIR-ANT 24120
2 A2
13.5 dBi Yagi Mast Mount Antenna
AIR ANT 1949
3B
50FT Low Loss Cable Assembly with RP-TNC Connectors
AIR -CAB050LL-R
4C
2.4 and 5GHZ Lightning Arrestor RP-TNC Connector
AIR-ACC245LA-R
5D
5FT Low-Loss 2.4GHZ RF Cable with RP-TNC Connectors
AIR–CAB005LL-R
COMPATIBILITY
Cisco Wireless Antennas Cisco Aironet 1300 Series
JUMLAH HARGA SATUAN 1 $461.11 4 $239.74 5 $130.04 5 $137.68 5 $62.90
TOTAL $461.11 $958.96 $650.20 $1,045.00 $314.50 $3,429.77
JUMLAH HARGA SATUAN 5 $741.29 5 $188.91 1 $7,073.78 4 $2,680.26 1 $1,494.85 1 $65.59 1 $105.32
TOTAL $3,706.45 $944.55 $7,073.78 $10,721.04 $1,494.85 $65.59 $105.32 $24,111.58
RADIO NETWORKING (ROUTER) TABLE NO KODE GAMBAR
NAMA PRODUK CISCO
KODE PRODUK CISCO
1E
Aironet 1310 Outdoor AP/BR with RP-TNC Connectors
AIR-BR1310G-A-K9-R
2F
48V Power Injector
AIR-PWRINJ-BLR2
3 G1
3825 Voice Bundle, PVDM2-64, SP Serv, 64F/256D
CISCO3825-V/K9
4 G2
2821 Voice Bundle with PVDM2-32 and IOS SP Services
CISCO2821-V/K9
5H
1841 with WIC-1DSU-T1-V2 Ip Base 32FL 128DR (Router)
CISCO1841-T1
6I
V.35 Cable DTE Male 10-Feet
CAB-V35MT
7J
4-Port 802.3AF Capable Inline Power Module for Hwic-4ESW
ILPM-4
COMPATIBILITY Cisco Aironet 1300 Series
Cisco Router
Fisik Tower Biaya Pembangunan Fisik Tower Rangka Besi
Note: $1 = Rp. 9400,00
5
$5,435.00
TOTAL INVESTASI TOTAL INVESTASI ADD COST MCV ADD COST CFZ1
$27,175.00 $54,716.35 Rp514,333,690.00 236,710,391 277,623,299
CASH FLOW PROJECTION OF MCV SELLING PRICE Type of Villas
1 Vila Type A (ex pool)
Cost
Land area Sqm
Unit
Land price Rp.m/sqm
27
3,000
300
-
-
0
Sqm
1 Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance: 1.5% Build+pools 2 Land Cost Macro Cost Micro Infra Cost 3 Others Permits & Licenses Hotel Operator Fee Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting 4 Network Investment Cost
Building area Sqm
8,100 3,240 8,100
Rpm./sqm
0.18 0.05
14,337 5,786
Total Land Sqm
5.5
2006 2Q
32,400 6,480 16,200 3,110 1,166 1,166 583
81,000 115,714
0.6
Total
4 2 2
Building price Rp.m/sqm
Total Building Sqm
81,000
8,100
0 81,000
8,100
2006 3Q
2006 4Q
Selling Price Rp.m 5,750 -
2007 1Q
Selling Price US$. Tho
Total Price Rp. M
625
155,250
-
155,250
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
-
960 192 480
1,920 384 960
3,360 672 1,680
4,800 960 2,400
5,760 1,152 2,880
5,520 1,104 2,760
4,560 912 2,280
3,120 624 1,560
1,680 336 840
720 144 360
300 -
620 194 35 17
900 194 69 35
194 121 60
194 173 86
194 207 104
1,290 194 199 99
164 82
112 56
60 30
26 13
14,337 500
500
986
900
900
1,000
1,000
500 388 920 690 250
500 388 920 690 250
500 388 1,380 1,035
500 388 1,380 1,035
500 388 920 690
500 388 690 518
388 -
388 -
388 -
237 15,762
5,746
8,196
10,291
12,817
13,796
14,262
8,386
5,861
3,335
1,263
Collection
-
5,750
9,200
15,525
20,700
25,300
25,013
20,988
16,388
10,063
5,463
Net Cash
(15,762)
11,504
10,750
3,110
5,786
3,000 3,881 6,210 4,658 500 237 99,715
388 -
Total
IRR NPV Discount
1,004
5,234
7,883
12,601
10,527
6,728
4,200
(15,758) 4
(14,755) 1,004
(9,521) 5,234
54,673 4,200
(674) 4,560
20,617 5,750 (5,000) 20,361
50,473 6,728
(1,004) -
9,867 6,504 (5,000) 14,610
43,745 10,527
(4) -
(1,637) 3,546 (4,337) 8,106
33,219 12,601
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(15,762) 14,337 1,425 -
32,962
43,489
50,217
54,416
Loan At Start Interest Capitalised Repayment Loan At End
1,425 71 1,496
1,496 75 (4) 1,568
1,568 78 (1,004) 642
642 32 (674) -
-
-
-
-
-
-
-
117% 39,274 15%
4
Sqm Land 1 Land 2 Macro 3 Micro 4 Master Planning
Rp.m
81,000 115,714 81,000
14,337 5,786 276
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Mock Up Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental & set up Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting Network Investment Cost of others expense per sqm
8,100 3,240 8,100
32,400 6,480 16,200
4,000 2,000 2,000
8,100 8,100 8,100 8,100 8,100
3,110 1,166 1,166 583 2,250
384 144 144 72 278 9,022
81,000 81,000 81,000 81,000 81,000 81,000 81,000 81,000
3,000 552 3,881 6,210 4,658 500 237
37 7 48 77 58 6 2.92 235
Selling Price (Rp. m)
5,750
Cost Land (Sqm) Building (Sqm) Land Cost (Rp. m) Building Cost (Rp m)
3,000 300 691 2,707
GAE & Marketing per Unit Total Cost per unit Profit and Loss Before GAE (Rp.m)
177 50 3 230
Profit and Loss per Unit
Cost per unit vila (before GAE & marketing)
Rp.th/sqm
3,398 705 4,103 2,352 41%
Profit and Loss After GAE (Rp.m)
1,647 29%
CASH FLOW PROJECTION OF ZONE 1 SELLING PRICE Type of Villas
Land area Sqm
Unit
1 Vila Type A 2 Vila Type B 3 Vila Type C
15 50
Building area Sqm
3,000 1,000
Land price Rp.m/sqm
Building price Rp.m/sqm
Total Land Sqm
300 150
45,000 50,000 95,000
65
Cost
Sqm
1 Construction Building Cost Pools Type A Pools Type B FF&E Fees Architect Fee Enginnering Fee, QS CM Insurance: 1.5% Construction Cost 2 Land Cost Macro Micro 3 Others Permits & Licenses Hotel Operator Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting 4 Network Investment Cost
12,000 1,800 2,000 12,000
95,000 135,714
Rpm./sqm
4 2 2 2
0.18 0.05
Total Building Sqm
2005 2Q
Total
48,000 3,600 4,000 24,000
2005 3Q
-
4,500 7,500 12,000 2005 4Q
Selling Price Rp.m
Selling Price US$. Tho
5,750 2,500 -
2006 1Q
Total Price Rp. M
625 272 -
2006 2Q
86,250 125,000 211,250 2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
1,920 144 160 960
3,840 288 320 1,920
5,040 378 420 2,520
6,480 486 540 3,240
7,680 576 640 3,840
6,960 522 580 3,480
5,760 432 480 2,880
4,560 342 380 2,280
3,120 234 260 1,560
1,920 144 160 960
720 54 60 360
600 258 124 58
1000 258 163 76
1,000 258 209 97
1,028 258 248 115
258 224 104
186 86
147 68
101 47
62 29
23 11
4,128 1,548 1,548 720
-
500 258 62 29
16,815 6,786
16,815 500
500
900
700
800
800
900
900
786
500 587 1,660 1,245 250
500 587 1,660 1,245
500 587 1,030 773 250
500 587 1,260 945
500 587 1,060 795
500 587 1,090 818
587 690 518
587 -
-
-
-
278 18,180
8,775
12,299
13,693
16,402
18,127
16,023
12,518
9,150
5,321
3,275
1,228
Collection
-
8,300
14,525
17,600
22,613
30,488
32,538
26,825
21,100
16,450
12,050
7,038
Net Cash
(18,180)
(475)
2,226
3,907
6,211
12,361
-
2,226
3,907
6,211
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
16,815 1,365 -
475 -
(2,103) 123
4,029
Loan At Start Interest Capitalised Repayment Loan At End
1,365 68 1,433
1,908 95 2,003
2,003 100 (2,103) -
Interest Rate
5%
5%
5%
3,000 5,281 8,450 6,338 500 278 134,992
587 -
Total
irr NPV Discount
117% 52,836 15%
16,514
14,307
11,950
11,129
8,775
5,809
6,514 (10,000) 22,300
14,307
11,950
11,129
8,775
5,809
10,240
5,546 (6,815) 15,786
36,606
48,556
59,685
68,460
74,269
-
-
-
-
-
-
-
-
-
5%
5%
5%
5%
5%
5%
5%
5%
5%
PROFIT & LOSS CALCULATION OF ZONE 1 Standard Cost per Component
TYPE A Sqm
Land 1 Land 2 Macro 3 Micro 4 Master Planning
45,000 64,286 45,000
Rp.m
Rp.th/sqm
7,965 3,214 153
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Mock Up Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting Network Investment
177 50 3.4 230
4,500 1,800 4,500
18,000 3,600 9,000
4,000 2,000 2,000
4,500 4,500 4,500 4,500 4,500
1,548 581 581 270 #VALUE!
344 129 129 60 #VALUE! #VALUE!
45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000
1,421 307 2,502 4,003 3,002 237 278
32 7 56 89 67 5 6
Cost of others expense per sqm
261
Profit and Loss per Unit Type A
Type B
Selling Price (Rp. m)
5,750
2,500
Cost Land (Sqm) Building (Sqm)
3,000 300
1,000 150
Land Cost (Rp. m) Building Cost (Rp m)
691 #VALUE!
230 #VALUE!
Cost per unit vila (before GAE & marketing)
#VALUE!
#VALUE!
783
261
#VALUE!
#VALUE!
Profit and Loss Before GAE (Rp.m)
#VALUE! #VALUE!
#VALUE! #VALUE!
Profit and Loss After GAE (Rp.m)
#VALUE! #VALUE!
#VALUE! #VALUE!
GAE & Marketing per Unit Total Cost per unit
FILE A-West wing Menjangan likely scenario.xls HPP Z1 - 1
TYPE B Sqm
50,000 71,429 50,000
Rp.m
8,850 3,572 170
Rp.th/sqm
177 50 3.4 230
7,500 2,000 7,500 7,500 7,500 7,500 7,500 7,500
50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000
30,000 4,000 15,000
4,000 2,000 2,000
2,580 344 968 129 968 129 450 60 #VALUE! #VALUE! #VALUE!
1,579 341 2,780 4,447 3,336 263 278
32 7 56 89 67 5 6 260
CASH FLOW PROJECTION OF WEST WING Total
2005 2Q
2005 3Q
2005 4Q
2006 1Q
2006 2Q
2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
2009 1Q
Sales (unit) MCV Zone 1 Vila A Vila B Vila C
27
-
4
4
6
6
4
3
-
15 50 -
-
2 12 -
2 12 -
Total
92
-
14
-
-
-
1 8 -
2 8 -
2 6 -
3 4 -
3 -
-
-
-
-
14
9
10
12
11
9
6
4
3
-
-
-
-
-
8,300
14,525
17,600
22,613
5,750 30,488
9,200 32,538
15,525 26,825
20,700 21,100
25,300 16,450
25,013 12,050
20,988 7,038
16,388 1,725
10,063 -
5,463 -
863 -
-
8,300
14,525
17,600
22,613
36,238
41,738
42,350
41,800
41,750
37,063
28,025
18,113
10,063
5,463
863
17,902
8,775
12,299
13,693
15,525 16,402
5,746 18,127
8,196 16,023
10,291 12,518
12,817 9,150
13,796 5,321
14,262 3,275
8,386 1,228
5,861 -
3,335 -
1,263 -
-
360 300
60 300
60
60
60
60
60
60
60
60
60
60
60
60
60
0
0
18,562
9,135
12,359
13,753
31,987
23,933
24,279
22,869
22,027
19,177
17,597
9,674
5,921
3,395
1,323
-
12,304 (10,969) 4,304 (8,000) 11,724
17,458 6,490 1,458 (16,000) 13,182
19,481 25,970 12,329 (7,152) 25,511
19,773 45,743 19,773 45,284
22,573 68,316 22,573
19,466 87,782 19,466
18,351 106,132 18,351
12,192 118,324 12,192
6,668
4,140
863
67,857
87,322
105,673
117,865
124,533
128,672
129,535
-
-
-
-
-
-
-
-
-
-
-
Revenue Collection MCV Collection Zone 1 Total Revenue
155,250 211,250 366,500
Cost MCV Cost Zone 1 Cost Others Office stet up and rental Master Planning Entrance Gate & Parking Boarding Mock Up: Zone 1 Type A Zone 1 Type B MCV Total Cost
99,478 134,714 1,200 600 235,992
Additional IT Costs
277.62
Surplus/(defisit) Akumulasi Surplus & Defisit
236.71 (835) (19,674) -
2,166 (17,508) 2,166
3,847 (13,662) 3,847
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(18,839) (18,839) 16,815 2,024 -
835 -
(2,166) -
(1,153) 2,694
(9,611) (23,273) 4,726 14,337 7,420
Loan At Start Interest Capitalised Repayment Loan At End
2,024 101 2,126
2,960 148 3,108
3,108 155 (2,166) 1,098
1,098 55 (1,153) -
-
ASUMSI 1 Unit terjual Ket 2006 Q 3 MCV 4
2006 Q 4 4
2007 Q 1 6
2007 Q 2 6
2007 Q 3 4
2007 Q 4 3
Total 27
Ket 2005 Q 3 Z.1 Tipe A 2 Z.1 Tipe B 12
2005 Q 4 2 12
2006 Q 1 1 8
2006 Q 2 2 8
2006 Q 3 2 6
2006 Q 4 3 4
2007 Q 1 3
Total 15 50
2 Pembayaran 2006 Q 3 Termin I 25%
2006 Q 4 2007 Q 1 2007 Q 2 2007 Q 3 2007 Q 4 Termin II Termin III Termin IV Termin V Termin VI 15% 15% 15% 25% 5%
Total 100%
2005 Q 3 Ket Termin I Z.1 Tipe A 20% Z.1 Tipe B 20%
2005 Q 4 2006 Q 1 2006 Q 2 2006 Q 3 2006 Q 4 Termin II Termin III Termin IV Termin V Termin VI 15% 15% 15% 25% 10% 15% 15% 15% 25% 10%
Total 100% 100%
Ket MCV
3 Tingkat bunga bank 5% 4 Pembangunan hotel menggunakan modal sendiri sebesar 14.337 untuk MCV dan 16.815 untuk Z1. 5 Tingkat diskonto 15% 6 General Administrative Expense & Others per unit didasarkan pada luas tanah 7 Net cash positif akan dibayarkan semua untuk pelunasan hutang bank beserta bunganya 8 Profit & loss per unit belum termasuk pembayaran bunga DENGAN SEMUA ASUMSI DI ATAS MAKA PROJECT MJBR (DENGAN INVESTASI TEKNOLOGI VOICE & DATA NETWORKING) AKAN MENCAPAI BEP PADA KUARTER KEEMPAT TAHUN 2006 (PERHITUNGAN DAPAT DILIHAT PADA SHEET RESUME FIX+ADD.COST) BERDASARKAN PERHITUNGAN IRR, PROJECT MJBR (DENGAN INVESTASI TEKNOLOGI VOICE & DATA NETWORKING) DAPAT DITERIMA KRN TINGKAT IRR > DARIPADA TINGKAT BUNGA DISKONTO 15%. PERHITUNGAN NPV PROJECT INI JUGA MENUNJUKKAN HASIL POSITIF. (SEMUA PERHITUNGAN DAPAT DILIHAT PADA SHEET RESUME FIX+ADD.COST)
+ADD.COST)
1 Vila Type A (ex pool)
Cost
Land area Sqm
Unit
Land price Rp.m/sqm
27
3,000
300
-
-
0
Sqm
1 Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance: 1.5% Build+pools 2 Land Cost Macro Cost Micro Infra Cost 3 Others Permits & Licenses Hotel Operator Fee Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
Building area Sqm
8,100 3,240 8,100
Rpm./sqm
0.18 0.05
14,337 5,786
Total Land Sqm
5.5
2006 2Q
32,400 6,480 16,200 3,110 1,166 1,166 583
81,000 115,714
0.6
Total
4 2 2
Building price Rp.m/sqm
3,110
5,627
Total Building Sqm
81,000
8,100
0 81,000
8,100
2006 3Q
2006 4Q
Selling Price Rp.m 5,750 -
2007 1Q
Selling Price US$. Tho
Total Price Rp. M
625
155,250
-
155,250
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
-
960 192 480
1,920 384 960
3,360 672 1,680
4,800 960 2,400
5,760 1,152 2,880
5,700 1,140 2,850
4,740 948 2,370
3,300 660 1,650
1,860 372 930
900 180 450
300 -
620 194 35 17
900 194 69 35
194 121 60
194 173 86
194 207 104
1,290 194 205 103
171 85
119 59
67 33
32 16
14,337 500
500
827
900
900
1,000
1,000
500 388
388 -
388 -
388 -
3,000 3,881 6,210 4,658 500
388 -
500 388 2,484 1,150 250
500 388 1,553 1,150 250
500 388 932 1,725
500 388 1,242 1,725
1,150
500 388 863 863
98,978
15,525
7,770
9,129
10,532
13,369
13,336
15,095
8,702
6,176
3,651
45 1,624
Collection
-
5,750
9,200
15,525
20,700
25,300
25,013
20,988
16,388
10,063
5,463
Net Cash
(15,525)
(2,020)
4,993
7,331
11,964
9,917
12,285
10,211
6,412
3,839
(17,545) -
(17,475) 71
(12,482) 4,993
49,478 3,839
(3,709) 1,284
16,731 4,917 (5,000) 16,160
45,639 6,412
(71) -
6,814 6,964 (5,000) 11,243
39,227 10,211
2,020 -
(5,151) 2,994 (4,337) 4,278
29,016 12,285
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(15,525) 14,337 1,188 -
28,445
38,656
45,068
48,907
Loan At Start Interest Capitalised Repayment Loan At End
1,188 59 1,248
3,268 163 3,431
3,431 172 (71) 3,532
3,532 177 (3,709) -
-
-
-
-
-
-
-
Total
IRR NPV Discount
96% 34,368 15%
71
Sqm Land 1 Land 2 Macro 3 Micro
Rp.m
81,000 81,000
14,337 5,786
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental & set up Developer's Overheads: 2,5 % Sales Promotion & Advertising: 5% of Sales Commision: 5% of Sales Legal & Accounting
8,100 8,100 8,100
32,400 6,480 16,200
4,000 800 2,000
8,100 8,100 8,100 8,100
3,110 1,166 1,166 583
384 144 144 72 7,544
81,000 81,000 81,000 81,000 81,000 81,000 81,000
3,000 1,200 3,881 6,210 4,658 500
37 15 48 77 58 6 240
Profit and Loss per Unit Selling Price (Rp. m)
5,750
Cost Land (Sqm) Building (Sqm) Land Cost (Rp. m) Building Cost (Rp m)
3,000 300 745 2,263
GAE & Marketing per Unit Total Cost per unit
177 71 248
Cost of others expense per sqm
Cost per unit vila (before GAE & marketing)
Rp.th/sqm
3,008 720 3,729
Profit and Loss Before GAE (Rp.m)
2,742 48%
Profit and Loss After GAE (Rp.m)
2,021
35%
CASH FLOW PROJECTION OF ZONE 1 SELLING PRICE Type of Villas
Land area Sqm
Unit
1 Vila Type A 2 Vila Type B 3 Vila Type C
15 50
Building area Sqm
3,000 1,000
Land price Rp.m/sqm
Building price Rp.m/sqm
Total Land Sqm
300 150
45,000 50,000 95,000
65
Cost
Sqm
1 Construction Building Cost Pools Type A Pools Type B FF&E Fees Architect Fee Enginnering Fee, QS CM Insurance: 1.5% Construction Cost 2 Land Cost Macro Micro 3 Others Permits & Licenses Hotel Operator Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
12,000 1,800 2,000 12,000
95,000 135,714
Rpm./sqm
4 2 2 2
0.18 0.05
Total Building Sqm
2005 2Q
Total
48,000 3,600 4,000 24,000
2005 3Q
-
4,500 7,500 12,000 2005 4Q
Selling Price Rp.m 5,750 2,500 -
2006 1Q
Selling Price US$. Tho
Total Price Rp. M
625 272 -
2006 2Q
86,250 125,000 211,250 2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
1,920 144 160 960
3,840 288 320 1,920
5,040 378 420 2,520
6,480 486 540 3,240
7,680 576 640 3,840
6,960 522 580 3,480
5,760 432 480 2,880
4,560 342 380 2,280
3,120 234 260 1,560
1,920 144 160 960
720 54 60 360
600 258 124 58
1000 258 163 76
1,000 258 209 97
1,028 258 248 115
258 224 104
186 86
147 68
101 47
62 29
23 11
900
986
587 863
587 -
-
-
-
4,128 1,548 1,548 720
-
500 258 62 29
16,815 6,786
16,815 500
500
900
700
800
800
900
3,000 5,281 8,450 6,338 500
587 -
500 587 2,535 2,075 250
500 587 1,690 2,075
500 587 1,268 1,288 250
500 587 1,268 1,575
500 587 845 1,325
500 587 845 1,363
134,213
17,902
10,480
13,159
14,446
17,039
18,442
16,323
12,173
9,350
5,321
3,275
1,228
Collection
-
8,300
14,525
17,600
22,613
30,488
32,538
26,825
21,100
16,450
12,050
7,038
Net Cash
(17,902)
(2,180)
1,366
3,154
5,573
12,046
16,214
14,652
11,750
11,129
8,775
5,809
16,815 1,087 -
1,366
3,154
5,573
11,129
8,775
5,809
(1,366) -
(2,410) 744
6,317
6,214 (10,000) 17,762
11,750
2,180 -
5,231 (6,815) 11,548
14,652
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
32,414
44,163
55,292
64,067
69,877
Loan At Start Interest Capitalised Repayment Loan At End
1,087 54 1,141
3,321 166 3,487
3,487 174 (1,366) 2,295
2,295 115 (2,410) -
-
-
-
-
-
-
-
-
Interest Rate
5%
5%
5%
5%
5%
5%
5%
5%
5%
5%
5%
5%
Total
irr NPV Discount
105% 48,130 15%
-
Sqm Land 1 Land 2 Macro 3 Micro
Rp.m
95,000 95,000
Rp.th/sqm
16,815 6,786
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
248
12,000 12,000 12,000
48,000 7,600 24,000
4,000 633 2,000
12,000 12,000 12,000 12,000
4,128 1,548 1,548 720
344 129 129 60 7,295
95,000 95,000 95,000 95,000 95,000 95,000 95,000
3,000 1,200 5,281 8,450 6,338 500
32 13 56 89 67 5
Cost of others expense per sqm
261
Profit and Loss per Unit Type A
Type B
Selling Price (Rp. m)
5,750
2,500
Cost Land (Sqm) Building (Sqm) Land Cost (Rp. m) Building Cost (Rp m)
3,000 300 745 2,189
1,000 150 248 1,094
2,934
1,343
782
261
3,716
1,603
Profit and Loss Before GAE (Rp.m)
2,816 49%
1,157 46%
Profit and Loss After GAE (Rp.m)
2,034
897
Cost per unit vila (before GAE & marketing) GAE & Marketing per Unit Total Cost per unit
177 71
35%
36%
CASH FLOW PROJECTION OF WEST WING Total
2005 2Q
2005 3Q
2005 4Q
2006 1Q
2006 2Q
2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
2009 1Q
Sales (unit) MCV Zone 1 Vila A Vila B Vila C
27
-
4
4
6
6
4
3
-
15 50 -
-
2 12 -
2 12 -
Total
92
-
14
155,250 209,525
-
366,500
-
-
1 8 -
2 8 -
2 6 -
3 4 -
3 -
-
-
-
-
14
9
10
12
11
9
6
4
3
-
-
-
-
-
8,300
14,525
17,600
22,613
5,750 30,488
9,200 32,538
15,525 26,825
20,700 21,100
25,300 16,450
25,013 12,050
20,988 7,038
16,388 1,725
10,063 -
5,463 -
863 -
-
8,300
14,525
17,600
22,613
36,238
41,738
42,350
41,800
41,750
37,063
28,025
18,113
10,063
5,463
863
104,909 139,139
17,902
10,480
13,159
14,446
15,525 17,039
7,770 18,442
9,129 16,323
10,532 12,173
13,369 9,350
13,336 5,321
15,095 3,275
8,702 1,228
6,176 -
3,651 -
1,624 -
-
1,200 600
360 300
60 300
60
60
60
60
60
60
60
60
60
60
60
60
60
2,200 1,100 2,250 251,398
880 440
1,320 660
19,882
12,820
900 14,119
1,350 15,856
32,625
26,272
25,512
22,766
22,779
18,717
18,430
9,990
6,236
3,711
1,684
-
(4,520) (24,401) -
406 (23,996) 406
1,744 (22,252) 1,744
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(19,882) (19,882) 16,815 3,067 -
4,520 -
(406) -
(1,744) -
(10,012) (32,264) 4,325 14,337 (4,325) -
9,965 (22,298) 1,965 (8,000) (1,965) -
16,225 (6,073) 225 (16,000) (225) -
19,584 13,511 12,432 (7,152) (843) 11,589
19,021 32,532 19,021 30,610
23,033 55,565 23,033
18,632 74,197 18,632
18,035 92,232 18,035
11,876 104,109 11,876
6,352
3,779
863
53,643
72,276
90,311
102,187
108,539
112,318
113,180
Loan At Start Interest Capitalised Repayment Loan At End
3,067 153 3,220
7,740 387 8,127
8,127 406 (406) 8,127
8,127 406 (1,744) 6,790
6,790 339 (4,325) 2,804
2,804 140 (1,965) 979
979 49 (225) 803
803 40 (843) -
-
-
-
-
-
-
-
-
Revenue Collection MCV Collection Zone 1 Total Revenue Cost MCV Cost Zone 1 Cost Others Office stet up and rental Master Planning Entrance Gate & Parking Boarding Mock Up: Zone 1 Type A Zone 1 Type B MCV Total Cost Surplus/(defisit)
Sqm Land 1 Land 2 Macro 3 Micro 4 Master Planning
Rp.m
81,000 115,714 81,000
14,337 5,786 276
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Mock Up Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental & set up Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
8,100 3,240 8,100
32,400 6,480 16,200
4,000 2,000 2,000
8,100 8,100 8,100 8,100 8,100
3,110 1,166 1,166 583 2,250
384 144 144 72 278 9,022
81,000 81,000 81,000 81,000 81,000 81,000 81,000
3,000 552 3,881 6,210 4,658 500
37 7 48 77 58 6 232
Profit and Loss per Unit Selling Price (Rp. m)
5,750
Cost Land (Sqm) Building (Sqm) Land Cost (Rp. m) Building Cost (Rp m)
3,000 300 691 2,707
GAE & Marketing per Unit Total Cost per unit Profit and Loss Before GAE (Rp.m)
177 50 3 230
Cost of others expense per sqm
Cost per unit vila (before GAE & marketing)
Rp.th/sqm
3,398 696 4,094 2,352 41%
Profit and Loss After GAE (Rp.m)
1,656 29%
CASH FLOW PROJECTION OF MCV SELLING PRICE Type of Villas
1 Vila Type A (ex pool)
Cost
Land area Sqm
Unit
Land price Rp.m/sqm
27
3,000
300
-
-
0
Sqm
1 Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance: 1.5% Build+pools 2 Land Cost Macro Cost Micro Infra Cost 3 Others Permits & Licenses Hotel Operator Fee Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
Building area Sqm
8,100 3,240 8,100
Rpm./sqm
0.18 0.05
14,337 5,786
Total Land Sqm
5.5
2006 2Q
32,400 6,480 16,200 3,110 1,166 1,166 583
81,000 115,714
0.6
Total
4 2 2
Building price Rp.m/sqm
3,110
5,786
Total Building Sqm
81,000
8,100
0 81,000
8,100
2006 3Q
2006 4Q
Selling Price Rp.m 5,750 -
2007 1Q
Selling Price US$. Tho
Total Price Rp. M
625
155,250
-
155,250
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
-
960 192 480
1,920 384 960
3,360 672 1,680
4,800 960 2,400
5,760 1,152 2,880
5,520 1,104 2,760
4,560 912 2,280
3,120 624 1,560
1,680 336 840
720 144 360
300 -
620 194 35 17
900 194 69 35
194 121 60
194 173 86
194 207 104
1,290 194 199 99
164 82
112 56
60 30
26 13
14,337 500
500
986
900
900
1,000
1,000
3,000 3,881 6,210 4,658 500
388 -
500 388 920 690 250
500 388 920 690 250
500 388 1,380 1,035
500 388 1,380 1,035
500 388 920 690
500 388 690 518
388 -
388 -
388 -
99,478
15,525
5,746
8,196
10,291
12,817
13,796
14,262
8,386
5,861
3,335
1,263
Collection
-
5,750
9,200
15,525
20,700
25,300
25,013
20,988
16,388
10,063
5,463
Net Cash
(15,525)
11,504
10,750
Total
IRR NPV Discount
1,004
5,234
7,883
12,601
10,527
6,728
4,200
(15,521) 4
(14,518) 1,004
(9,284) 5,234
54,910 4,200
(386) 4,848
20,854 5,750 (5,000) 20,649
50,710 6,728
(1,004) -
10,104 6,504 (5,000) 14,899
43,982 10,527
(4) -
(1,400) 3,546 (4,337) 8,394
33,456 12,601
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(15,525) 14,337 1,188 -
33,250
43,777
50,505
54,704
Loan At Start Interest Capitalised Repayment Loan At End
1,188 59 1,248
1,248 62 (4) 1,306
1,306 65 (1,004) 368
368 18 (386) -
-
-
-
-
-
-
-
119% 39,502 15%
4
CASH FLOW PROJECTION OF ZONE 1 SELLING PRICE Type of Villas
Land area Sqm
Unit
1 Vila Type A 2 Vila Type B 3 Vila Type C
15 50
Building area Sqm
3,000 1,000
Land price Rp.m/sqm
Building price Rp.m/sqm
Total Land Sqm
300 150
45,000 50,000 95,000
65
Cost
Sqm
1 Construction Building Cost Pools Type A Pools Type B FF&E Fees Architect Fee Enginnering Fee, QS CM Insurance: 1.5% Construction Cost 2 Land Cost Macro Micro 3 Others Permits & Licenses Hotel Operator Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
12,000 1,800 2,000 12,000
95,000 135,714
Rpm./sqm
4 2 2 2
0.18 0.05
Total Building Sqm
2005 2Q
Total
48,000 3,600 4,000 24,000
2005 3Q
-
4,500 7,500 12,000 2005 4Q
Selling Price Rp.m
Selling Price US$. Tho
5,750 2,500 -
2006 1Q
Total Price Rp. M
625 272 -
2006 2Q
86,250 125,000 211,250 2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
1,920 144 160 960
3,840 288 320 1,920
5,040 378 420 2,520
6,480 486 540 3,240
7,680 576 640 3,840
6,960 522 580 3,480
5,760 432 480 2,880
4,560 342 380 2,280
3,120 234 260 1,560
1,920 144 160 960
720 54 60 360
600 258 124 58
1000 258 163 76
1,000 258 209 97
1,028 258 248 115
258 224 104
186 86
147 68
101 47
62 29
23 11
4,128 1,548 1,548 720
-
500 258 62 29
16,815 6,786
16,815 500
500
900
700
800
800
900
900
786
3,000 5,281 8,450 6,338 500
587 -
500 587 1,660 1,245 250
500 587 1,660 1,245
500 587 1,030 773 250
500 587 1,260 945
500 587 1,060 795
500 587 1,090 818
587 690 518
587 -
-
-
-
134,714
17,902
8,775
12,299
13,693
16,402
18,127
16,023
12,518
9,150
5,321
3,275
1,228
Collection
-
8,300
14,525
17,600
22,613
30,488
32,538
26,825
21,100
16,450
12,050
7,038
Net Cash
(17,902)
(475)
2,226
3,907
6,211
12,361
-
2,226
3,907
6,211
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
16,815 1,087 -
475 -
(1,781) 444
4,351
Loan At Start Interest Capitalised Repayment Loan At End
1,087 54 1,141
1,616 81 1,696
1,696 85 (1,781) -
Interest Rate
5%
5%
5%
Total
irr NPV Discount
118% 53,104 15%
16,514
14,307
11,950
11,129
8,775
5,809
6,514 (10,000) 22,622
14,307
11,950
11,129
8,775
5,809
10,562
5,546 (6,815) 16,107
36,928
48,878
60,007
68,782
74,591
-
-
-
-
-
-
-
-
-
5%
5%
5%
5%
5%
5%
5%
5%
5%
PROFIT & LOSS CALCULATION OF ZONE 1 Standard Cost per Component
TYPE A Sqm
Land 1 Land 2 Macro 3 Micro 4 Master Planning
45,000 64,286 45,000
Rp.m
Rp.th/sqm
7,965 3,214 153
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Mock Up Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting
177 50 3.4 230
4,500 1,800 4,500
18,000 3,600 9,000
4,000 2,000 2,000
4,500 4,500 4,500 4,500 4,500
1,548 581 581 270 #VALUE!
344 129 129 60 #VALUE! #VALUE!
45,000 45,000 45,000 45,000 45,000 45,000 45,000
1,421 307 2,502 4,003 3,002 237
32 7 56 89 67 5
Cost of others expense per sqm
255
Profit and Loss per Unit Type A
Type B
Selling Price (Rp. m)
5,750
2,500
Cost Land (Sqm) Building (Sqm)
3,000 300
1,000 150
Land Cost (Rp. m) Building Cost (Rp m)
691 #VALUE!
230 #VALUE!
Cost per unit vila (before GAE & marketing)
#VALUE!
#VALUE!
765
255
#VALUE!
#VALUE!
Profit and Loss Before GAE (Rp.m)
#VALUE! #VALUE!
#VALUE! #VALUE!
Profit and Loss After GAE (Rp.m)
#VALUE! #VALUE!
#VALUE! #VALUE!
GAE & Marketing per Unit Total Cost per unit
FILE A-West wing Menjangan likely scenario.xls HPP Z1 - 1
TYPE B Sqm
50,000 71,429 50,000
Rp.m
8,850 3,572 170
Rp.th/sqm
177 50 3.4 230
7,500 2,000 7,500 7,500 7,500 7,500 7,500 7,500
50,000 50,000 50,000 50,000 50,000 50,000 50,000
30,000 4,000 15,000
4,000 2,000 2,000
2,580 344 968 129 968 129 450 60 #VALUE! #VALUE! #VALUE!
1,579 341 2,780 4,447 3,336 263
32 7 56 89 67 5
255
CASH FLOW PROJECTION OF WEST WING Total
2005 2Q
2005 3Q
2005 4Q
2006 1Q
2006 2Q
2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
2009 1Q
Sales (unit) MCV Zone 1 Vila A Vila B Vila C
27
-
4
4
6
6
4
3
-
15 50 -
-
2 12 -
2 12 -
Total
92
-
14
-
-
-
1 8 -
2 8 -
2 6 -
3 4 -
3 -
-
-
-
-
14
9
10
12
11
9
6
4
3
-
-
-
-
-
8,300
14,525
17,600
22,613
5,750 30,488
9,200 32,538
15,525 26,825
20,700 21,100
25,300 16,450
25,013 12,050
20,988 7,038
16,388 1,725
10,063 -
5,463 -
863 -
-
8,300
14,525
17,600
22,613
36,238
41,738
42,350
41,800
41,750
37,063
28,025
18,113
10,063
5,463
863
17,902
8,775
12,299
13,693
15,525 16,402
5,746 18,127
8,196 16,023
10,291 12,518
12,817 9,150
13,796 5,321
14,262 3,275
8,386 1,228
5,861 -
3,335 -
1,263 -
-
360 300
60 300
60
60
60
60
60
60
60
60
60
60
60
60
60
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE!
#VALUE!
12,359
13,753
31,987
23,933
24,279
22,869
22,027
19,177
17,597
9,674
5,921
3,395
1,323
-
#VALUE! #VALUE! #VALUE!
2,166 #VALUE! 2,166
3,847 #VALUE! 3,847
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
#VALUE! #VALUE! #VALUE! 16,815 #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
(9,375) #VALUE! 4,962 14,337 #VALUE! #VALUE!
12,304 #VALUE! #VALUE! (8,000) #VALUE! #VALUE! #VALUE!
17,458 #VALUE! #VALUE! (16,000) #VALUE! #VALUE! #VALUE!
19,481 #VALUE! #VALUE! (7,152) #VALUE! #VALUE! #VALUE!
19,773 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
22,573 #VALUE! #VALUE!
19,466 #VALUE! #VALUE!
18,351 #VALUE! #VALUE!
12,192 #VALUE! #VALUE!
6,668
4,140
863
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
Loan At Start Interest Capitalised Repayment Loan At End
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE!
Revenue Collection MCV Collection Zone 1 Total Revenue
155,250 211,250 366,500
Cost MCV Cost Zone 1 Cost Others Office stet up and rental Master Planning Entrance Gate & Parking Boarding Mock Up: Zone 1 Type A Zone 1 Type B MCV Total Cost
99,478 134,714 1,200 600 #VALUE! #VALUE! #VALUE!
Surplus/(defisit)
WIRELESS DATA & VOICE NETWORK WITH CISCO SYSTEM DISTANCE 5000 METER, bandwidth 1 Mbyte RADIO ANTENA (TOWER) TABLE NO KODE GAMBAR
NAMA PRODUK CISCO
KODE PRODUK CISCO
1 A1
2.4 GHz 12 Dbi Omni Mast Mt. Antenna with RP-TNC Connector
AIR-ANT 24120
2 A2
13.5 dBi Yagi Mast Mount Antenna
AIR ANT 1949
3B
50FT Low Loss Cable Assembly with RP-TNC Connectors
AIR -CAB050LL-R
4C
2.4 and 5GHZ Lightning Arrestor RP-TNC Connector
AIR-ACC245LA-R
5D
5FT Low-Loss 2.4GHZ RF Cable with RP-TNC Connectors
AIR–CAB005LL-R
COMPATIBILITY
Cisco Wireless Antennas Cisco Aironet 1300 Series
JUMLAH HARGA SATUAN 1 $461.11 4 $239.74 5 $130.04 5 $137.68 5 $62.90
TOTAL $461.11 $958.96 $650.20 $1,045.00 $314.50 $3,429.77
JUMLAH HARGA SATUAN 5 $741.29 5 $188.91 1 $7,073.78 4 $2,680.26 1 $1,494.85 1 $65.59 1 $105.32
TOTAL $3,706.45 $944.55 $7,073.78 $10,721.04 $1,494.85 $65.59 $105.32 $24,111.58
RADIO NETWORKING (ROUTER) TABLE NO KODE GAMBAR
NAMA PRODUK CISCO
KODE PRODUK CISCO
1E
Aironet 1310 Outdoor AP/BR with RP-TNC Connectors
AIR-BR1310G-A-K9-R
2F
48V Power Injector
AIR-PWRINJ-BLR2
3 G1
3825 Voice Bundle, PVDM2-64, SP Serv, 64F/256D
CISCO3825-V/K9
4 G2
2821 Voice Bundle with PVDM2-32 and IOS SP Services
CISCO2821-V/K9
5H
1841 with WIC-1DSU-T1-V2 Ip Base 32FL 128DR (Router)
CISCO1841-T1
6I
V.35 Cable DTE Male 10-Feet
CAB-V35MT
7J
4-Port 802.3AF Capable Inline Power Module for Hwic-4ESW
ILPM-4
COMPATIBILITY Cisco Aironet 1300 Series
Cisco Router
Fisik Tower Biaya Pembangunan Fisik Tower Rangka Besi
Note: $1 = Rp. 9400,00
5
$5,435.00
TOTAL INVESTASI TOTAL INVESTASI ADD COST MCV ADD COST CFZ1
$27,175.00 $54,716.35 Rp514,333,690.00 236,710,391 277,623,299
CASH FLOW PROJECTION OF MCV SELLING PRICE Type of Villas
1 Vila Type A (ex pool)
Cost
Land area Sqm
Unit
Land price Rp.m/sqm
27
3,000
300
-
-
0
Sqm
1 Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance: 1.5% Build+pools 2 Land Cost Macro Cost Micro Infra Cost 3 Others Permits & Licenses Hotel Operator Fee Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting 4 Network Investment Cost
Building area Sqm
8,100 3,240 8,100
Rpm./sqm
0.18 0.05
14,337 5,786
Total Land Sqm
5.5
2006 2Q
32,400 6,480 16,200 3,110 1,166 1,166 583
81,000 115,714
0.6
Total
4 2 2
Building price Rp.m/sqm
Total Building Sqm
81,000
8,100
0 81,000
8,100
2006 3Q
2006 4Q
Selling Price Rp.m 5,750 -
2007 1Q
Selling Price US$. Tho
Total Price Rp. M
625
155,250
-
155,250
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
-
960 192 480
1,920 384 960
3,360 672 1,680
4,800 960 2,400
5,760 1,152 2,880
5,520 1,104 2,760
4,560 912 2,280
3,120 624 1,560
1,680 336 840
720 144 360
300 -
620 194 35 17
900 194 69 35
194 121 60
194 173 86
194 207 104
1,290 194 199 99
164 82
112 56
60 30
26 13
14,337 500
500
986
900
900
1,000
1,000
500 388 920 690 250
500 388 920 690 250
500 388 1,380 1,035
500 388 1,380 1,035
500 388 920 690
500 388 690 518
388 -
388 -
388 -
237 15,762
5,746
8,196
10,291
12,817
13,796
14,262
8,386
5,861
3,335
1,263
Collection
-
5,750
9,200
15,525
20,700
25,300
25,013
20,988
16,388
10,063
5,463
Net Cash
(15,762)
11,504
10,750
3,110
5,786
3,000 3,881 6,210 4,658 500 237 99,715
388 -
Total
IRR NPV Discount
1,004
5,234
7,883
12,601
10,527
6,728
4,200
(15,758) 4
(14,755) 1,004
(9,521) 5,234
54,673 4,200
(674) 4,560
20,617 5,750 (5,000) 20,361
50,473 6,728
(1,004) -
9,867 6,504 (5,000) 14,610
43,745 10,527
(4) -
(1,637) 3,546 (4,337) 8,106
33,219 12,601
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(15,762) 14,337 1,425 -
32,962
43,489
50,217
54,416
Loan At Start Interest Capitalised Repayment Loan At End
1,425 71 1,496
1,496 75 (4) 1,568
1,568 78 (1,004) 642
642 32 (674) -
-
-
-
-
-
-
-
117% 39,274 15%
4
Sqm Land 1 Land 2 Macro 3 Micro 4 Master Planning
Rp.m
81,000 115,714 81,000
14,337 5,786 276
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Mock Up Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental & set up Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting Network Investment Cost of others expense per sqm
8,100 3,240 8,100
32,400 6,480 16,200
4,000 2,000 2,000
8,100 8,100 8,100 8,100 8,100
3,110 1,166 1,166 583 2,250
384 144 144 72 278 9,022
81,000 81,000 81,000 81,000 81,000 81,000 81,000 81,000
3,000 552 3,881 6,210 4,658 500 237
37 7 48 77 58 6 2.92 235
Selling Price (Rp. m)
5,750
Cost Land (Sqm) Building (Sqm) Land Cost (Rp. m) Building Cost (Rp m)
3,000 300 691 2,707
GAE & Marketing per Unit Total Cost per unit Profit and Loss Before GAE (Rp.m)
177 50 3 230
Profit and Loss per Unit
Cost per unit vila (before GAE & marketing)
Rp.th/sqm
3,398 705 4,103 2,352 41%
Profit and Loss After GAE (Rp.m)
1,647 29%
CASH FLOW PROJECTION OF ZONE 1 SELLING PRICE Type of Villas
Land area Sqm
Unit
1 Vila Type A 2 Vila Type B 3 Vila Type C
15 50
Building area Sqm
3,000 1,000
Land price Rp.m/sqm
Building price Rp.m/sqm
Total Land Sqm
300 150
45,000 50,000 95,000
65
Cost
Sqm
1 Construction Building Cost Pools Type A Pools Type B FF&E Fees Architect Fee Enginnering Fee, QS CM Insurance: 1.5% Construction Cost 2 Land Cost Macro Micro 3 Others Permits & Licenses Hotel Operator Developer's Overheads: 2,5% Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting 4 Network Investment Cost
12,000 1,800 2,000 12,000
95,000 135,714
Rpm./sqm
4 2 2 2
0.18 0.05
Total Building Sqm
2005 2Q
Total
48,000 3,600 4,000 24,000
2005 3Q
-
4,500 7,500 12,000 2005 4Q
Selling Price Rp.m
Selling Price US$. Tho
5,750 2,500 -
2006 1Q
Total Price Rp. M
625 272 -
2006 2Q
86,250 125,000 211,250 2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
1,920 144 160 960
3,840 288 320 1,920
5,040 378 420 2,520
6,480 486 540 3,240
7,680 576 640 3,840
6,960 522 580 3,480
5,760 432 480 2,880
4,560 342 380 2,280
3,120 234 260 1,560
1,920 144 160 960
720 54 60 360
600 258 124 58
1000 258 163 76
1,000 258 209 97
1,028 258 248 115
258 224 104
186 86
147 68
101 47
62 29
23 11
4,128 1,548 1,548 720
-
500 258 62 29
16,815 6,786
16,815 500
500
900
700
800
800
900
900
786
500 587 1,660 1,245 250
500 587 1,660 1,245
500 587 1,030 773 250
500 587 1,260 945
500 587 1,060 795
500 587 1,090 818
587 690 518
587 -
-
-
-
278 18,180
8,775
12,299
13,693
16,402
18,127
16,023
12,518
9,150
5,321
3,275
1,228
Collection
-
8,300
14,525
17,600
22,613
30,488
32,538
26,825
21,100
16,450
12,050
7,038
Net Cash
(18,180)
(475)
2,226
3,907
6,211
12,361
-
2,226
3,907
6,211
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
16,815 1,365 -
475 -
(2,103) 123
4,029
Loan At Start Interest Capitalised Repayment Loan At End
1,365 68 1,433
1,908 95 2,003
2,003 100 (2,103) -
Interest Rate
5%
5%
5%
3,000 5,281 8,450 6,338 500 278 134,992
587 -
Total
irr NPV Discount
117% 52,836 15%
16,514
14,307
11,950
11,129
8,775
5,809
6,514 (10,000) 22,300
14,307
11,950
11,129
8,775
5,809
10,240
5,546 (6,815) 15,786
36,606
48,556
59,685
68,460
74,269
-
-
-
-
-
-
-
-
-
5%
5%
5%
5%
5%
5%
5%
5%
5%
PROFIT & LOSS CALCULATION OF ZONE 1 Standard Cost per Component
TYPE A Sqm
Land 1 Land 2 Macro 3 Micro 4 Master Planning
45,000 64,286 45,000
Rp.m
Rp.th/sqm
7,965 3,214 153
Cost of Land per sqm Construction Cost Building Cost Pools FF&E Fees Architect Fee Enginnering Fee, QS, Landscape CM Insurance Mock Up Cost of Building per sqm GAE & Others Permits & Licenses Hotel Operator Fee Office Rental Developer's Overheads: 2,5 % Sales Promotion & Advertising: 4% of Sales Commision: 3% of Sales Legal & Accounting Network Investment
177 50 3.4 230
4,500 1,800 4,500
18,000 3,600 9,000
4,000 2,000 2,000
4,500 4,500 4,500 4,500 4,500
1,548 581 581 270 #VALUE!
344 129 129 60 #VALUE! #VALUE!
45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000
1,421 307 2,502 4,003 3,002 237 278
32 7 56 89 67 5 6
Cost of others expense per sqm
261
Profit and Loss per Unit Type A
Type B
Selling Price (Rp. m)
5,750
2,500
Cost Land (Sqm) Building (Sqm)
3,000 300
1,000 150
Land Cost (Rp. m) Building Cost (Rp m)
691 #VALUE!
230 #VALUE!
Cost per unit vila (before GAE & marketing)
#VALUE!
#VALUE!
783
261
#VALUE!
#VALUE!
Profit and Loss Before GAE (Rp.m)
#VALUE! #VALUE!
#VALUE! #VALUE!
Profit and Loss After GAE (Rp.m)
#VALUE! #VALUE!
#VALUE! #VALUE!
GAE & Marketing per Unit Total Cost per unit
FILE A-West wing Menjangan likely scenario.xls HPP Z1 - 1
TYPE B Sqm
50,000 71,429 50,000
Rp.m
8,850 3,572 170
Rp.th/sqm
177 50 3.4 230
7,500 2,000 7,500 7,500 7,500 7,500 7,500 7,500
50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000
30,000 4,000 15,000
4,000 2,000 2,000
2,580 344 968 129 968 129 450 60 #VALUE! #VALUE! #VALUE!
1,579 341 2,780 4,447 3,336 263 278
32 7 56 89 67 5 6 260
CASH FLOW PROJECTION OF WEST WING Total
2005 2Q
2005 3Q
2005 4Q
2006 1Q
2006 2Q
2006 3Q
2006 4Q
2007 1Q
2007 2Q
2007 3Q
2007 4Q
2008 1Q
2008 2Q
2008 3Q
2008 4Q
2009 1Q
Sales (unit) MCV Zone 1 Vila A Vila B Vila C
27
-
4
4
6
6
4
3
-
15 50 -
-
2 12 -
2 12 -
Total
92
-
14
-
-
-
1 8 -
2 8 -
2 6 -
3 4 -
3 -
-
-
-
-
14
9
10
12
11
9
6
4
3
-
-
-
-
-
8,300
14,525
17,600
22,613
5,750 30,488
9,200 32,538
15,525 26,825
20,700 21,100
25,300 16,450
25,013 12,050
20,988 7,038
16,388 1,725
10,063 -
5,463 -
863 -
-
8,300
14,525
17,600
22,613
36,238
41,738
42,350
41,800
41,750
37,063
28,025
18,113
10,063
5,463
863
17,902
8,775
12,299
13,693
15,525 16,402
5,746 18,127
8,196 16,023
10,291 12,518
12,817 9,150
13,796 5,321
14,262 3,275
8,386 1,228
5,861 -
3,335 -
1,263 -
-
360 300
60 300
60
60
60
60
60
60
60
60
60
60
60
60
60
0
0
18,562
9,135
12,359
13,753
31,987
23,933
24,279
22,869
22,027
19,177
17,597
9,674
5,921
3,395
1,323
-
12,304 (10,969) 4,304 (8,000) 11,724
17,458 6,490 1,458 (16,000) 13,182
19,481 25,970 12,329 (7,152) 25,511
19,773 45,743 19,773 45,284
22,573 68,316 22,573
19,466 87,782 19,466
18,351 106,132 18,351
12,192 118,324 12,192
6,668
4,140
863
67,857
87,322
105,673
117,865
124,533
128,672
129,535
-
-
-
-
-
-
-
-
-
-
-
Revenue Collection MCV Collection Zone 1 Total Revenue
155,250 211,250 366,500
Cost MCV Cost Zone 1 Cost Others Office stet up and rental Master Planning Entrance Gate & Parking Boarding Mock Up: Zone 1 Type A Zone 1 Type B MCV Total Cost
99,478 134,714 1,200 600 235,992
Additional IT Costs
277.62
Surplus/(defisit) Akumulasi Surplus & Defisit
236.71 (835) (19,674) -
2,166 (17,508) 2,166
3,847 (13,662) 3,847
Funding From Equity Funding From Loan Loan Repayment Net Cash Flow
(18,839) (18,839) 16,815 2,024 -
835 -
(2,166) -
(1,153) 2,694
(9,611) (23,273) 4,726 14,337 7,420
Loan At Start Interest Capitalised Repayment Loan At End
2,024 101 2,126
2,960 148 3,108
3,108 155 (2,166) 1,098
1,098 55 (1,153) -
-
ASUMSI 1 Unit terjual Ket 2006 Q 3 MCV 4
2006 Q 4 4
2007 Q 1 6
2007 Q 2 6
2007 Q 3 4
2007 Q 4 3
Total 27
Ket 2005 Q 3 Z.1 Tipe A 2 Z.1 Tipe B 12
2005 Q 4 2 12
2006 Q 1 1 8
2006 Q 2 2 8
2006 Q 3 2 6
2006 Q 4 3 4
2007 Q 1 3
Total 15 50
2 Pembayaran 2006 Q 3 Termin I 25%
2006 Q 4 2007 Q 1 2007 Q 2 2007 Q 3 2007 Q 4 Termin II Termin III Termin IV Termin V Termin VI 15% 15% 15% 25% 5%
Total 100%
2005 Q 3 Ket Termin I Z.1 Tipe A 20% Z.1 Tipe B 20%
2005 Q 4 2006 Q 1 2006 Q 2 2006 Q 3 2006 Q 4 Termin II Termin III Termin IV Termin V Termin VI 15% 15% 15% 25% 10% 15% 15% 15% 25% 10%
Total 100% 100%
Ket MCV
3 Tingkat bunga bank 5% 4 Pembangunan hotel menggunakan modal sendiri sebesar 14.337 untuk MCV dan 16.815 untuk Z1. 5 Tingkat diskonto 15% 6 General Administrative Expense & Others per unit didasarkan pada luas tanah 7 Net cash positif akan dibayarkan semua untuk pelunasan hutang bank beserta bunganya 8 Profit & loss per unit belum termasuk pembayaran bunga DENGAN SEMUA ASUMSI DI ATAS MAKA PROJECT MJBR (DENGAN INVESTASI TEKNOLOGI VOICE & DATA NETWORKING) AKAN MENCAPAI BEP PADA KUARTER KEEMPAT TAHUN 2006 (PERHITUNGAN DAPAT DILIHAT PADA SHEET RESUME FIX+ADD.COST) BERDASARKAN PERHITUNGAN IRR, PROJECT MJBR (DENGAN INVESTASI TEKNOLOGI VOICE & DATA NETWORKING) DAPAT DITERIMA KRN TINGKAT IRR > DARIPADA TINGKAT BUNGA DISKONTO 15%. PERHITUNGAN NPV PROJECT INI JUGA MENUNJUKKAN HASIL POSITIF. (SEMUA PERHITUNGAN DAPAT DILIHAT PADA SHEET RESUME FIX+ADD.COST)
+ADD.COST)
Related Documents
Perhitungan Iex
July 2020 5
Iex Bulletin
December 2019 7
Perhitungan
October 2019 55
Perhitungan
April 2020 44
Iex Enertia 210809
June 2020 4