Presentation - Kemuning Budget

8/13/2019 Presentation - Kemuning Budget

1/18


2/18

in a thousand rupiah (Rp000,-)

NO SCOPE OF WORK BUDGET (Rp) %

1 LEGAL & LAND 6,932,000.00 13.64%

2 PLANNING & DESIGN 885,000.00 1.74%

3 INTERIOR DESIGN 85,000.00 0.17%

4 CONSTRUCTION PREPARATION 200,000.00 0.39%

5 INFRASTRUCTURE & LANDSCAPPING 2,700,000.00 5.31%

6 BUILDING CONSTRUCTION 29,949,600.00 58.95%

7 PROJECT & CONSTRUCTION MANAGEMENT 768,000.00 1.51%

8 HOTEL MANAGEMENT CONSULTANT 418,000.00 0.82%

9 FIXTURE, FURNITURE & EQUIPMENT (FF&E) 7,169,000.00 14.11%

10 OPERATIONAL PREPARATION 700,000.00 1.38%

11 STOOD CAPITAL 1,000,000.00 1.97%

GRAND TOTAL 50,806,600.00 100%


3/18

# Item Analyzed Result

a. TOTAL INVESTMENT Rp 50,806,600.00 thousands

b. ROOMS AVAILABLE 60 units

c. ROOMS OCCUPANCY @average per year 66.82%

d. ROOM RATE @average per year Rp 932.38 thousands

e. SALES COEFFECIENT @average per year 2.46

f. NUMBER of DAYS per YEAR 365 days

g. ROOM INVESTMENT RATIO Rp 847,000.00 thousands

h. TOTAL REVENUE @average per year Rp 33,760,000.00 100%

i. TOTAL COST & EXPENSES @average per year Rp 19,629,000.00 58.1%

j. NET PROFIT @Before Depr, Fee & Tax average Rp 14,131,000.00 41.9%

k. DEPR, MGT FEE & TAX @average per year Rp 5,656,000.00 16.8%

l. NET PROFIT @average per year Rp 8,443,000.00 25.0%

m. BREAK EVEN POINT @Total Revenue Rp 202,387,000.00 thousands

n. PAYBACK PERIOD (years) 7th


4/18

in a thousand rupiah (Rp000,-)No SCOPE OF WORK SQUARE (m2) PRICE / unit

TOTAL (Rp)

I BUILDING CONSTRUCTION

1 Planning & Design Architecture 6,443.52 1 885,000.00

2 Interior Design 1 85,000.00

3 Construction Management 1 687,000.00

4 Project Management 1 81,000.00

5 Building Construction 6,443.52 1 22,840,600.00

6 Mechanical & Electrical 6,443.52 1 7,309,000.00

[-] Construction Preparation (Point V) (200,000.00)

Subtotal - I 31,687,600.00II

FIXTURE, FURNITURE & EQUIPMENT

(FFE)

1 Guest Room 1.00 935,000 935,000.00

2 Front of the House 1.00 3,277,000 3,277,000.00

3 Back of the House 1.00 787,000 787,000.00

4 Supporting Facilities 1.00 2,170,000 2,170,000.00

Subtotal - II 7,169,000.00III INFRASTRUCTURE & LANDSCAPPING1 Parking Area, Pedestrian, Garden, etc. 4,500.00 1 2,700,000.00

Subtotal - III 2,700,000.00IV LEGAL & LAND

1 Land & Legality (M2) 7,900.00 800 6,320,000.00

2 Ijin Mendirikan Bangunan (IMB) 6,443.52 48.42 312,000.00

3 Land Preparation Lot 1 100,000.00

4 Company Legal (PT) Lot 200,000 200,000.00

Subtotal - IV 6,932,000.00V CONSTRUCTION PREPARATION

1 Survey / Soil Test Lot 30,000 30,000.00

2 Direksi Keet & Warehouse Lot 20,000 20,000.00

3 Temporary Electrical & Water Lot 50,000 50,000.00

4 Mobilisation & Demobilisation Lot 100,000 100,000.00

Subtotal - V 200,000.00VI OPERATIONAL PREPARATION ls 500,000 500,000.00

Subtotal - VI 500,000.00VII STOOD CAPITAL ls 1,000,000 1,000,000.00

Subtotal - VII 1,000,000.00VIII PRE-OPENING PREPARATION ls 200,000 200,000.00

Subtotal - VIII 200,000.00IX HOTEL MANAGEMENT CONSULTANT ls 418,000 418,000.00Subtotal - VII 418,000.00


5/18


SPACESQUARE PRICE

SUBTOTAL(M2) (Rp)

GUEST ROOM 60 UNITS 1,386.00 3,000.00 4,158,000.00FRONT OFFICE 88.26 3,000.23 264,800.00

FOOD AND BEVERAGE OUTLETS 303.80 3,000.00 911,400.00

BANQUETTE AND MEETING ROOM 2,114.50 2,917.24 6,168,500.00

MINOR FACILITIES 26.40 3,000.00 79,200.00

SPORTS INDOOR, AMUSEMENT & HEALTH CENTER 174.10 3,000.00 522,300.00

MANAGEMENT OFFICE 51.40 2,836.58 145,800.00

DEPT. FRONT OFFICE 28.08 2,934.47 82,400.00

DEPT. SALES & MARKETING 51.20 2,953.13 151,200.00

DEPT. HUMAN RESOURCES 34.20 3,000.00 102,600.00

DEPT. FOOD & BEVERAGE 35.60 2,865.17 102,000.00HOUSE KEEPING 29.60 2,675.68 79,200.00

ENGINEERING 23.60 2,898.31 68,400.00

ACCOUNTING 22.00 2,890.91 63,600.00

HOUSE KEEPING 55.60 2,741.01 152,400.00

EMPLOYE ROOM 45.80 3,000.00 137,400.00

FOOD AND BEVERAGE ROOM 44.40 2,891.89 128,400.00

BACK OF THE HOUSE ACCOUNTING 26.00 2,661.54 69,200.00

UTILITY ROOM / ENGINEERING 122.00 2,000.00 244,000.00

TOTAL SPACE 4,662.54 - 13,630,800.00

Sirculation 15 % 699.38 3,000.00 2,099,000.00

TOTAL INDOOR BUILDING 5,361.92 - 15,729,800.00

PARKING SPACE - Semi Basement 1,000.00 3,600.00 3,600,000.00

ROOF OUTDOOR ACTIVITY 81.60 4,470.59 364,800.00

PONDASI DALAM - Kepmen 332/KPTS/M/2002 20% 3,146,000.00

TOTAL BUILDING 6,443.52 - 22,840,600.00

Parking Area, Pedestrian, Garden, etc. 4,500.00 600.00 2,700,000.00

TOTAL BUILDING AREA 10,943.52 - 25,540,600.00


6/18


SPACEFIXTURE &

FURNITUREEQUIPMENT

TOTAL

F, F & EGUEST ROOM 935,000.00 - 935,000.00

Presidential Suites 2 units 100,000.00 - 100,000.00

Junior Suite 3 units 90,000.00 - 90,000.00

Superior Room 15 units 300,000.00 - 300,000.00

Moderate Room 40 units 400,000.00 - 400,000.00

Sirculation (Ls) 15% 45,000.00 - 45,000.00

Total Guest Rooms 935,000.00 - 935,000.00

FRONT OFFICE 88,000.00 48,000.00 136,000.00

FOOD AND BEVERAGE OUTLETS 70,000.00 175,000.00 245,000.00

BANQUETTE AND MEETING ROOM 488,000.00 402,000.00 890,000.00

MINOR FACILITIES 8,000.00 20,000.00 58,000.00

SPORTS INDOOR AND HEALTH CENTER 115,000.00 1,050,000.00 1,165,000.00

GENERAL MANAGER OFFICE 57,000.00 50,000.00 107,000.00

DEPT. FRONT OFFICE 47,000.00 86,000.00 133,000.00

DEPT. SALES & MARKETING 55,000.00 88,000.00 143,000.00

DEPT. HUMAN RESOURCES 42,000.00 40,000.00 82,000.00

DEPT. FOOD & BEVERAGE 41,000.00 42,000.00 83,000.00

HOUSE KEEPING 33,000.00 42,000.00 75,000.00

ENGINEERING 27,000.00 51,000.00 78,000.00

ACCOUNTING 33,000.00 49,000.00 82,000.00

Total Front of The House 1,104,000.00 2,143,000.00 3,277,000.00HOUSE KEEPING (TATA GRAHA) 46,000.00 351,000.00 397,000.00

EMPLOYE ROOM (KARYAWAN) 34,000.00 37,000.00 71,000.00

FOOD AND BEVERRAGE ROOM 18,000.00 222,000.00 240,000.00

BACK OF THE HOUSE ACCOUNTING 31,000.00 48,000.00 79,000.00

UTILITY ROOM / ENGINEERING - - -

Total Back Office 129,000.00 658,000.00 787,000.00

Total Guest Room, Front Office & Back Office 2,168,000.00 2,801,000.00 4,999,000.00

SUPPORTING FACILITIES - VEHICLES - 2,170,000.00 2,170,000.00

TOTAL FIXTURE, FURNITURE & EQUIPMENT 2,168,000.00 4,971,000.00 7,169,000.00


7/18


I Planning & Design

Fee (%) Building Total

3.25% 25,540,600 831,000

% Design Fee Total

1 Architecture 30.00% 831,000 249,000

2 Civil Engineering 22.00% 831,000 183,000

3 Mechanical & Electrical 28.00% 831,000 233,000

4 Interior & Furniture 20.00% 831,000 166,000

Subtotal I 831,000

II Infrastruktur & LandscapeFee (%) Outdoor Total

0.02 2,700,000 54,000

Subtotal II 54,000

III Interior DesignFee (%) Interior Total

3.00% 2,844,303 85,000

Sub Total III 85,000

TOTAL PLANNING/DESIGN FEE 885,000


Item Supervision Fee (%) Building & Outdoor Total

I Construction Management 2.43% 28,240,600 687,000

II Project Management 0.29% 28,240,600 81,000

TOTAL SUPERVISION FEE 768,000

TOTAL PLANNING/DESIGN FEE & SUPERVISION FEE 1,653,000


8/18

ITEMYEAR-1, MONTH -

TOTAL1 2 3 4 5 6 7 8 9 10 11 12

Loan Investment - - - - - - - - - - - - -

Owner Equity 50,806,600 - - - - - - - - - - - 50,806,600

Total Investment 50,806,600 43,080,022 42,678,060 40,850,764 38,438,464 34,498,618 30,193,126 25,887,633 20,684,472 14,018,723 6,977,127 515,394 50,806,600

Building Construction - 1,497,480 2,246,220 3,743,700 3,743,700 3,743,700 3,743,700 3,743,700 3,743,700 3,743,700 - 29,949,600

Fixt, Furniture & Equipment - - - - - 358,450 358,450 358,450 1,792,250 2,150,700 1,792,250 358,450 7,169,000

Infrastruktur & Landscape - - - - - - - 810,000 810,000 540,000 540,000 - 2,700,000

Planning & Design 442,500 309,750 132,750 - - - - - - - - - 885,000

Interior Design - 42,500 42,500 - - - - - - - - - 85,000

Project & Construction Mgt. - - 76,800 76,800 76,800 76,800 76,800 76,800 76,800 76,800 76,800 76,800 768,000

Htl Management Consultnt - 41,800 41,800 41,800 41,800 41,800 41,800 41,800 41,800 41,800 41,800 - 418,000

Legal & Land 6,932,000 - - - - - - - - - - - 6,932,000

Construction Preparation 200,000 - - - - - - - - - - - 200,000

Operational Preparation - - - - - - - 70,000 70,000 350,000 140,000 70,000 700,000

Total 7,574,500 394,050 1,791,330 2,364,820 3,862,300 4,220,750 4,220,750 5,100,750 6,534,550 6,903,000 6,334,550 505,250 49,806,600

Stood capital 152,078 7,912 35,966 47,480 77,546 84,743 84,743 102,411 131,198 138,596 127,183 10,144 1,000,000

Total Allocation 7,726,578 401,962 1,827,296 2,412,300 3,939,846 4,305,493 4,305,493 5,203,161 6,665,748 7,041,596 6,461,733 515,394 50,806,600

Funds Allocation 7,574,500 394,050 1,791,330 2,364,820 3,862,300 4,220,750 4,220,750 5,100,750 6,534,550 6,903,000 6,334,550 505,250 49,806,600

Owner Installment 152,078 7,912 35,966 47,480 77,546 84,743 84,743 102,411 131,198 138,596 127,183 10,144 1,000,000

Cash Out 7,726,578 401,962 1,827,296 2,412,300 3,939,846 4,305,493 4,305,493 5,203,161 6,665,748 7,041,596 6,461,733 515,394 50,806,600

Balance 43,080,022 42,678,060 40,850,764 38,438,464 34,498,618 30,193,126 25,887,633 20,684,472 14,018,723 6,977,127 515,394 - -


9/18


ROOMS TYPE

TOTAL ROOMSOCCUPANCY

RATE

PUBLISHED

ROOM RATE

(Rp)

REVENUE

PROJECTION

(Rp)UNITS

AVAILB

(Month)SOLD

Presidential Suites 2 60 29 48.00% 6,000.00 172,800.00

Junior Suite 3 90 50 55.00% 3,000.00 148,500.00

Superior Room 15 450 279 62.00% 800.00 223,200.00

Moderate Room 40 1,200 780 65.00% 450.00 351,000.00

Total per 30 days 1,800 1,137 63.18% 787.39 895,500.00

Total per 365 days 21,900 13,837 63.18% 787.39 10,895,250.00

Average Discount 15% 1,634,287.50

Revenue 9,260,962.50

Average Room Rate (ARR) 787.39

Net Average Room Rate (NARR) - After Discount 669.28

Net Revenue 60 9,260,962.50

ESTIMATEROOMS

SOLD OCCUPANCY NARRNET REVENUE

GROWTH / YEAR 5-10% RATE 10-1%

Year 01 21,900 13,837 63.18% 669.28 9,260,962.50

Year 02 21,900 14,252 65.08% 736.21 10,492,670.51

Year 03 21,900 14,391 65.71% 802.47 11,548,049.80Year 04 21,900 14,529 66.34% 866.67 12,591,815.84

Year 05 21,900 14,667 66.97% 927.33 13,601,559.55

Year 06 21,900 14,737 67.29% 982.97 14,485,660.92

Year 07 21,900 14,806 67.61% 1,032.12 15,281,352.15

Year 08 21,900 14,875 67.92% 1,073.41 15,966,870.75

Year 09 21,900 15,082 68.87% 1,105.61 16,675,354.23

Year 10 21,900 15,152 69.19% 1,127.72 17,086,883.61

Total / Average 21,900 14,633 66.82% 932.38 136,991,179.85


10/18


OUTLETSCAPACITY

UNITSEAT AVERAGE RATIO MONTH REVENUE

PROJECTION

(Rp)QT SET TO OCCP CH/COV (Rp) FD BV PROD

RESTAURANTS & BANQUETTE

1. Buffet Restaurant 50 pax 1 1 60% 100.00 75 25 30 90,000.00

2. Speciality Resto Music Lounge 200 pax 1 1 60% 150.00 75 25 30 540,000.00

CAFETERIA

1. Open Air Caf 20 Seats 1 1 50% 50.00 75 25 30 15,000.00

2. PoolsideCoffe Shop 10 Seats 1 1 40% 50.00 75 25 30 6,000.00

OTHERS

1. Room Service 60 pax 1 1 30% 80.00 75 25 30 43,200.00

2. Mini Bar 60 rooms 1 1 25% 50.00 20 80 30 22,500.00GROSS REVENUE 716,700.00

21% Government Tax & Service 0.00

NET REVENUE 716,700.00


OUTLETSF & B REVENUE MINOR INCOME ROOMS TO TOTAL

FOOD BEVERAGE SPACE/ROOM OTHERS BREAKFAST F & B REVENUE

RESTAURANTS (Monthly) (Yearly)

1. Buffet Restaurant 67,500.00 22,500.00 90,000.00 1,080,000.00

2. Speciality Resto & Music Lounge 405,000.00 135,000.00 540,000.00 6,480,000.00

CAFETERIA

1. Open Air Caf 14,250.00 750.00 15,000.00 180,000.00

2. PoolsideCoffe Shop 5,700.00 300.00 6,000.00 72,000.00

OTHERS

1. Room Service 41,040.00 2,160.00 43,200.00 518,400.00

2. Mini Bar 21,375.00 1,125.00 22,500.00 270,000.00

GROSS REVENUE 554,865.00 161,835.00 0.00 0.00 0.00 716,700.00 8,600,400.00

21% Government Tax & Service 0.00 0.00 0.00 0.00 0.00 0.00

NET REVENUE 554,865.00 161,835.00 0.00 0.00 0.00 716,700.00 8,600,400.00


Period SALES GROWTH 5% TOTAL

FOOD BEVERAGES F&B REVENUE

Year 01 6,658,380.00 1,942,020.00 8,600,400.00

Year 02 6,991,299.00 2,039,121.00 9,030,420.00

Year 03 7,340,863.95 2,141,077.05 9,481,941.00

Year 04 7,707,907.15 2,248,130.90 9,956,038.05

Year 05 8,093,302.50 2,360,537.45 10,453,839.95

Year 06 8,497,967.63 2,478,564.32 10,976,531.95

Year 07 8,922,866.01 2,602,492.54 11,525,358.55

Year 08 9,369,009.31 2,732,617.16 12,101,626.48

Year 09 9,837,459.78 2,869,248.02 12,706,707.80

Year 10 10,329,332.77 3,012,710.42 13,342,043.19

Year 11 10,845,799.41 3,163,345.94 14,009,145.35

Year 12 11,388,089.38 3,321,513.24 14,709,602.62

Year 14 11,957,493.84 3,487,588.90 15,445,082.75

Year 15 12,555,368.54 3,661,968.35 16,217,336.88

Year 16 13,183,136.96 3,845,066.76 17,028,203.73

Year 17 13,842,293.81 4,037,320.10 17,879,613.91


11/18


No. OUTLETS QTT SET UNITTURN

CHARGE DAYREVENUE

OVER MONTHLY YEARLY

I. Event & Convention:

1 Convention Hall 1 rooms 1 1 30,000.00 4 120,000.00 1,440,000.00

2 Meeting Rooms #200 2 rooms 1 1 8,000.00 4 64,000.00 768,000.00

3 Meeting Rooms #100 6 rooms 1 1 4,000.00 8 192,000.00 2,304,000.00

4 Meeting Rooms #20 8 rooms 1 1 800.00 8 51,200.00 614,400.00

Total 427,200.00 5,126,400.00

Disc 15% 64,080.00 768,960.00

Net Revenue 363,120.00 4,357,440.00

II. Other income:

1 Fitness Center 1 rooms 12 2 50.00 8 9,600.00 115,200.00

2 Amusement, Billiard & Golf Simulator 1 rooms 1 1 300.00 16 4,800.00 57,600.00

3 Gallery & Drugstore 2 rooms 1 1 150.00 24 3,600.00 43,200.00

4 Business & Press Center 1 rooms 15 6 50.00 8 36,000.00 432,000.00

5 Laundry & Valet Service 60 rooms 40% 0.5 50.00 8 4,800.00 57,600.00

6 Fruits & Flower 60 rooms 25% 0.5 100.00 8 6,000.00 72,000.00Total 64,800.00 777,600.00

Disc 15% 9,720.00 116,640.00

Net Revenue 55,080.00 660,960.00

21% Government Tax & Service - -

TOTAL NET REVENUE 418,200.00 5,018,400.00


12/18


POSITION LEVEL TTL SALARY COST UNIFORM MEALS INSURANCE YEARLY OVERTIMEYearly

BonusesTOTAL

TOP LEVEL MANAGEMENT

01. Director 1 16,000.00 16,000.00 1,000.00 50.00 1,550.00 0.06 1.20 212,000.00 - 16,000.00 228,000.00

02. General Manager 1 14,000.00 14,000.00 1,000.00 50.00 1,550.00 0.06 1.20 188,000.00 - 14,000.00 202,000.00

03. Assistance GM 1 10,000.00 10,000.00 1,000.00 50.00 1,550.00 0.06 1.20 140,000.00 - 10,000.00 150,000.00

MIDDLE LEVEL MGMNT

01. Senior Manager 8 8,000.00 64,000.00 4,000.00 30.00 7,440.00 0.06 0.45 861,285.40 - 64,000.00 925,285.40

02. Assistant/Secr. Mngr 6 6,000.00 36,000.00 1,800.00 30.00 5,580.00 0.06 0.36 500,764.32 - 36,000.00 536,764.3203. Junior Manager 2 5,000.00 10,000.00 400.00 30.00 1,860.00 0.06 0.27 142,723.24 - 10,000.00 152,723.24

04. Junior Assistant Mngr 2 4,500.00 9,000.00 400.00 30.00 1,860.00 0.06 0.21 130,722.52 - 9,000.00 139,722.52

05. Senior Staff 7 4,000.00 28,000.00 1,400.00 30.00 6,510.00 0.06 0.15 415,521.80 103,880.45 28,000.00 547,402.25

BOTTOM LEVEL MGMNT

01. Senior BLM 7 3,000.00 21,000.00 700.00 20.00 4,340.00 0.06 0.14 304,781.62 76,195.41 21,000.00 401,977.03

02. Junior BLM 0 2,750.00 - - 20.00 - 0.06 0.12 - - - -

03. Junior Staff 15 2,500.00 37,500.00 1,500.00 20.00 9,300.00 0.06 0.11 563,101.26 140,775.32 37,500.00 741,376.58

CRAFT LEVEL

01. Senior Craft Level 8 2,250.00 18,000.00 800.00 20.00 4,960.00 0.06 0.09 276,321.08 69,080.27 18,000.00 363,401.35

02. Middle Craft Level 0 1,500.00 - - 20.00 - 0.06 0.08 - - - -

03. Junior Craft Level 8 1,200.00 9,600.00 800.00 20.00 4,960.00 0.06 0.07 175,520.83 43,880.21 9,600.00 229,001.04

04. Daily Worker 9 15,00/HRS 28,350.00 900.00 20.00 5,580.00 - - 408,060.00 - 28,350.00 436,410.00

05. Casual Worker 0 20,00/HRS - - 20.00 - - - - - - -

301,450.00 15,700.00 57,040.00 0.00 4,317,580.05 433,811.65 301,450.00 5,054,063.72

Tax 10% 505,406.37

Total 5,559,470.09


PeriodGROWTH

10%Rp

Year 01 0% 5,559,470.09

Year 02 0% 5,559,470.09

Year 03 20% 6,671,364.10

Year 04 0% 6,671,364.10

Year 05 20% 8,005,636.92Year 06 0% 8,005,636.92

Year 07 20% 9,606,764.31

Year 08 0% 9,606,764.31

Year 09 20% 11,528,117.17

Year 10 0% 11,528,117.17

Year 11 20% 13,833,740.61

Year 12 0% 13,833,740.61

Year 13 20% 16,600,488.73

Year 14 0% 16,600,488.73

Year 15 20% 19,920,586.47

Year 16 0% 19,920,586.47

Year 17 20% 23,904,703.77


13/18


STATISTICS

Rooms Available (units) 60 60 60 60 60 60 60 60 60 60 60

Rooms % Occupancy 63.18% 65.08% 65.71% 66.34% 66.97% 67.29% 67.61% 67.92% 68.87% 69.19% 66.82%

Average Room Rate 669.28 736.21 802.47 866.67 927.33 982.97 1,032.12 1,073.41 1,105.61 1,127.72 932.38

Sales Coefficient 2.47 2.41 2.39 2.39 2.40 2.43 2.46 2.49 2.53 2.60 2.46

Number of Days 365 365 365 365 365 365 365 365 365 365 365

REVENUES

R o o m s 9,260,963 40.5% 10,492,671 41.5% 11,548,050 41.8% 12,591,816 41.9% 13,601,560 41.7% 14,485,661 41.1% 15,281,352 40.6% 15,966,871 40.2% 16,675,354 39.6% 17,086,884 38.4% 13,699,118 40.6%

F o o d 6,658,380 29.1% 6,991,299 27.7% 7,340,864 26.6% 7,707,907 25.6% 8,093,303 24.8% 8,497,968 24.1% 8,922,866 23.7% 9,369,009 23.6% 9,837,460 23.3% 10,329,333 23.2% 8,374,839 24.8%

Beverage 1,942,020 8.5% 2,039,121 8.1% 2,141,077 7.8% 2,248,131 7.5% 2,360,537 7.2% 2,478,564 7.0% 2,602,493 6.9% 2,732,617 6.9% 2,869,248 6.8% 3,012,710 6.8% 2,442,652 7.2%

Total Rooms, FB & Minor 8,600,400 37.6% 9,030,420 35.7% 9,481,941 34.3% 9,956,038 33.1% 10,453,840 32.0% 10,976,532 31.1% 11,525,359 30.7% 12,101,626 30.5% 12,706,708 30.1% 13,342,043 30.0% 10,817,491 32.0%Event & Convention 4,357,440 19.0% 5,011,056 19.8% 5,762,714 20.9% 6,627,122 22.1% 7,621,190 23.4% 8,764,368 24.8% 9,640,805 25.6% 10,412,069 26.2% 11,453,276 27.2% 12,598,604 28.3% 8,224,865 24.4%

Other Income 660,960 2.9% 727,056 2.9% 814,303 2.9% 879,447 2.9% 949,803 2.9% 1,044,783 3.0% 1,149,261 3.1% 1,223,963 3.1% 1,321,880 3.1% 1,414,412 3.2% 1,018,587 3.0%

TOTAL REVENUES 22,879,763 100% 25,261,203 100% 27,607,008 100% 30,054,422 100% 32,626,392 100% 35,271,344 100% 37,596,777 100% 39,704,530 100% 42,157,219 100% 44,441,943 100% 33,760,060 100%

COSTS

Rooms Other Expense 463,048 5.0% 524,634 5.0% 577,402 5.0% 629,591 5.0% 680,078 5.0% 724,283 5.0% 764,068 5.0% 798,344 5.0% 833,768 5.0% 854,344 5.0% 684,956 5.0%

F o o d Costs 2,130,682 32.0% 2,237,216 32.0% 2,349,076 32.0% 2,466,530 32.0% 2,589,857 32.0% 2,719,350 32.0% 2,855,317 32.0% 2,998,083 32.0% 3,147,987 32.0% 3,305,386 32.0% 2,679,948 32.0%

Beverage Costs 310,723 16.0% 326,259 16.0% 342,572 16.0% 359,701 16.0% 377,686 16.0% 396,570 16.0% 416,399 16.0% 437,219 16.0% 459,080 16.0% 482,034 16.0% 390,824 16.0%

Total F&B Cost 2,904,453 33.8% 3,088,109 34.2% 3,269,051 34.5% 3,455,822 34.7% 3,647,621 34.9% 3,840,203 35.0% 4,035,784 35.0% 4,233,645 35.0% 4,440,835 34.9% 4,641,764 34.8% 3,755,729 34.7%

M.O.D 958,637 22.0% 1,102,432 22.0% 1,267,797 22.0% 1,457,967 22.0% 1,676,662 22.0% 1,928,161 22.0% 2,120,977 22.0% 2,290,655 22.0% 2,519,721 22.0% 2,771,693 22.0% 1,809,470 22.0%

F & B Other Opt Expense 26,438 4.0% 29,082 4.0% 32,572 4.0% 35,178 4.0% 37,992 4.0% 41,791 4.0% 45,970 4.0% 48,959 4.0% 52,875 4.0% 56,576 4.0% 40,743 4.0%

TOTAL COSTS 4,352,576 19.0% 4,744,257 18.8% 5,146,823 18.6% 5,578,557 18.6% 6,042,353 18.5% 6,534,438 18.5% 6,966,799 18.5% 7,371,603 18.6% 7,847,198 18.6% 8,324,378 18.7% 6,290,898.18 18.6%UNDISTR EXEPENSES

Payroll, Tax & Employee 5,559,470 24.3% 5,559,470 22.0% 6,671,364 24.2% 6,671,364 22.2% 8,005,637 24.5% 8,005,637 22.7% 9,606,764 25.6% 9,606,764 24.2% 11,528,117 27.3% 11,528,117 25.9% 8,274,271 24.5%

Adm & General 915,191 4.0% 1,010,448 4.0% 1,104,280 4.0% 1,202,177 4.0% 1,305,056 4.0% 1,410,854 4.0% 1,503,871 4.0% 1,588,181 4.0% 1,686,289 4.0% 1,777,678 4.0% 1,350,402 4.0%

Sales & Marketing 1,143,988 5.0% 1,263,060 5.0% 1,380,350 5.0% 1,502,721 5.0% 1,631,320 5.0% 1,763,567 5.0% 1,879,839 5.0% 1,985,226 5.0% 2,107,861 5.0% 2,222,097 5.0% 1,688,003 5.0%

Property Opr, Energy 1,372,786 6.0% 1,515,672 6.0% 1,656,420 6.0% 1,803,265 6.0% 1,957,584 6.0% 2,116,281 6.0% 2,255,807 6.0% 2,382,272 6.0% 2,529,433 6.0% 2,666,517 6.0% 2,025,604 6.0%

TOTAL UNDISTRIB EXPS 8,991,434 39.3% 9,348,650 37.0% 10,812,415 39.2% 11,179,527 37.2% 12,899,596 39.5% 13,296,339 37.7% 15,246,281 40.6% 15,562,444 39.2% 17,851,700 42.3% 18,194,409 40.9% 13,338,279.52 39.5%

TOTAL COST & EXPENSES 13,344,011 58.3% 14,092,907 55.8% 15,959,238 57.8% 16,758,085 55.8% 18,941,948 58.1% 19,830,777 56.2% 22,213,080 59.1% 22,934,046 57.8% 25,698,898 61.0% 26,518,786 59.7% 19,629,177.70 58.1%

GROSS OPR. PROFIT 9,535,752 41.7% 11,168,295 44.2% 11,647,770 42.2% 13,296,337 44.2% 13,684,444 41.9% 15,440,567 43.8% 15,383,697 40.9% 16,770,484 42.2% 16,458,321 39.0% 17,923,156 40.3% 14,130,882.29 41.9%


14/18


Item ProjectionBUILDING

PROJECT Year-1 Year-2 Year-3 Year-4 Year-5 Year-6 Year-7 Year-8 Year-9 Year-10

Revenue:

R o o m s - 9,260,963 10,492,671 11,548,050 12,591,816 13,601,560 14,485,661 15,281,352 15,966,871 16,675,354 17,086,884

F o o d - 6,658,380 6,991,299 7,340,864 7,707,907 8,093,303 8,497,968 8,922,866 9,369,009 9,837,460 10,329,333

Beverage - 1,942,020 2,039,121 2,141,077 2,248,131 2,360,537 2,478,564 2,602,493 2,732,617 2,869,248 3,012,710

Event & Convention - 4,357,440 5,011,056 5,762,714 6,627,122 7,621,190 8,764,368 9,640,805 10,412,069 11,453,276 12,598,604

Other Income - 660,960 727,056 814,303 879,447 949,803 1,044,783 1,149,261 1,223,963 1,321,880 1,414,412

Gross Revenue - 22,879,763 25,261,203 27,607,008 30,054,422 32,626,392 35,271,344 37,596,777 39,704,530 42,157,219 44,441,943

Cost of Good Sold: - 4,352,576 4,744,257 5,146,823 5,578,557 6,042,353 6,534,438 6,966,799 7,371,603 7,847,198 8,324,378

Gross Profit - 18,527,186 20,516,946 2,460,185 24,475,865 26,584,039 28,736,906 30,629,978 32,332,927 34,310,021 36,117,565

Expenses:

Payroll, Tax & Employee - 5,559,470 5,559,470 6,671,364 6,671,364 8,005,637 8,005,637 9,606,764 9,606,764 11,528,117 11,528,117

Administrative & General - 915,191 1,010,448 1,104,280 1,202,177 1,305,056 1,410,854 1,588,181 1,588,181 1,686,289 1,777,678

Sales & Marketing - 1,143,988 1,263,060 1,380,350 1,502,721 1,631,320 1,763,567 1,985,226 1,985,226 2,107,861 2,222,097

Property Opr, Energy - 1,372,786 1,515,672 1,656,420 1,803,265 1,957,584 2,116,281 2,382,272 2,382,272 2,529,433 2,666,517

Total Expenses - 8,991,434 9,348,650 10,812,415 11,179,527 12,899,596 13,296,339 15,562,444 15,562,444 17,851,700 18,194,409

EBITDA (GROSS PROFIT) - 9,535,752 11,168,295 11,647,770 13,296,337 13,684,444 15,440,567 15,067,535 16,770,484 16,458,321 17,923,156

Amortisation & Depreciation - 2,311,280 2,239,590 2,175,069 2,117,000 2,064,738 2,017,702 1,975,370 1,937,271 1,902,982 1,872,122

EARNING BEFORE FEE & TAX - 7,224,472 8,928,705 9,472,701 11,179,337 11,619,706 13,422,865 13,092,164 14,833,212 14,555,339 16,051,035

4% Management Fee - 915,191 1,010,448 1,104,280 1,202,177 1,305,056 1,410,854 1,503,871 1,588,181 1,686,289 1,777,678

NET PROFIT BEFORE TAX - 6,309,281 7,918,257 8,368,420 9,977,160 10,314,650 12,012,011 11,588,293 13,245,031 12,869,050 14,273,357

21% Government Tax & Service - 1,324,949 1,662,834 1,757,368 2,095,204 2,166,076 2,522,522 2,433,542 2,781,457 2,702,500 2,997,405

NET PROFIT AFTER TAX - 4,984,332 6,255,423 6,611,052 7,881,957 8,148,573 9,489,489 9,154,752 10,463,575 10,166,549 11,275,952

Profit Margin- 21.8% 24.8% 23.9% 26.2% 25.0% 26.9% 24.3% 26.4% 24.1% 25.4%


15/18

INTERPOLATION OF CASH FLOWS in a thousand rupiah (Rp000,-)

Cash 0 1 2 3 4 5 6 7 8 9 10 11

Cash Inflow - - 22,879,763 33,881,764 46,385,417 59,376,320 74,042,450 89,066,791 105,421,937 121,093,353 138,728,344 155,785,100

Cash Outflow - - 14,259,201 15,103,355 17,063,519 17,960,262 20,247,004 21,241,631 24,033,114 24,522,228 27,385,187 28,296,464

Net Cash Flow - - 8,620,561 18,778,409 29,321,898 41,416,058 53,795,446 67,825,160 81,388,823 96,571,126 111,343,157 127,488,636

INTERNAL RATE OF RETURN

Proceed Total 1 2 3 4 5 6 7 8 9 10

Total Net Cash Flow 105,044,779 - 7,295,612 8,495,013 8,786,121 9,998,957 10,213,311 11,507,191 11,130,122 12,400,846 12,069,531 13,148,074

IRR (Discount Rate) 5.56% 1.00000 0.94736 0.89749 0.85025 0.80549 0.76309 0.72292 0.68487 0.64881 0.61466 0.58230

Net IRR 76,915,958 - 6,911,571 7,624,197 7,470,372 8,054,058 7,793,664 8,318,776 7,622,634 8,045,841 7,418,662 7,656,183

Investment Total 1 2 3 4 5 6 7 8 9 10

New Investment 50,806,600 50,806,600 - - - - - - - - - -

Reinvestm-Depr.Cost 20,613,124 - - - - 10,907,677 - - - - 9,705,447

Total Investment 71,419,724 - - - - - - - - - -

PAYBACK PERIOD

Amount / Periods

46,172,638 6 thYears

4,633,962 7.30 thMonths

50,806,600 7 th Years


16/18


PERIODSCASH

FLOWSIRR

PRESENT

VALUE

PRESENT

VALUE ACCUM.

PHYSICAL

INVESTMENT NET PRESENT

VALUENPV > 1

48,688,600

Years # 0 - 1.00000 - - 48,688,600 - 0.00

Years # 1 7,295,612 0.94736 6,911,571 6,911,571 48,688,600 (41,777,029) 0.14

Years # 2 8,495,013 0.89749 7,624,197 14,535,768 48,688,600 (34,152,832) 0.30

Years # 3 8,786,121 0.85025 7,470,372 22,006,140 48,688,600 (26,682,460) 0.45

Years # 4 9,998,957 0.80549 8,054,058 30,060,198 48,688,600 (18,628,402) 0.62

Years # 5 10,213,311 0.76309 7,793,664 37,853,862 48,688,600 (10,834,738) 0.78

Years # 6 11,507,191 0.72292 8,318,776 46,172,638 48,688,600 (2,515,962) 0.95

Years # 7 11,130,122 0.68487 7,622,634 53,795,272 48,688,600 5,106,672 1.10

Years # 8 12,400,846 0.64881 8,045,841 61,841,113 48,688,600 13,152,513 1.27

Years # 9 12,069,531 0.61466 7,418,662 69,259,774 48,688,600 20,571,174 1.42

Years # 10 13,148,074 0.58230 7,656,183 76,915,958 48,688,600 28,227,358 1.58

-

10,000,000

20,000,000

30,000,000

40,000,000

50,000,000

60,000,000

70,000,000

80,000,000

90,000,000


17/18


Remarks Year 0 Year-1 Year-2 Year-3 Year-4 Year-5 Year-6 Year-7 Year-8 Year-9 Year-10 TOTAL

BEGINNING BALANCE - - 7,295,612 15,790,625 24,576,746 34,575,703 33,881,338 45,388,529 56,518,651 68,919,496 80,989,028 0

CASH IN FLOW

Hotel & Others :

Room Revenue - 9,260,963 10,492,671 11,548,050 12,591,816 13,601,560 14,485,661 15,281,352 15,966,871 16,675,354 17,086,884 136,991,180

Food Revenue - 6,658,380 6,991,299 7,340,864 7,707,907 8,093,303 8,497,968 8,922,866 9,369,009 9,837,460 10,329,333 83,748,388

Beverages Revenue - 1,942,020 2,039,121 2,141,077 2,248,131 2,360,537 2,478,564 2,602,493 2,732,617 2,869,248 3,012,710 24,426,519

Minor FB Revenue - - - - - - - - - - - -

Event & Convention - 4,357,440 5,011,056 5,762,714 6,627,122 7,621,190 8,764,368 9,640,805 10,412,069 11,453,276 12,598,604 82,248,645

Others Revenue - 660,960 727,056 814,303 879,447 949,803 1,044,783 1,149,261 1,223,963 1,321,880 1,414,412 10,185,868

Investment :

Fixed Investment 50,806,600 - - - - - - - - - - 50,806,600Revolving Loan (IDC) - - - - - - - - - - - -

Shareholders Fund - - - - - - - - - - - -

Total Cash InFlow 50,806,600 22,879,763 25,261,203 27,607,008 30,054,422 32,626,392 35,271,344 37,596,777 39,704,530 42,157,219 44,441,943 388,407,200

CASH OUT FLOW

Project Invesment

Invesment 50,806,600 - - - - - - - - - - 50,806,600

COGS - 4,352,576 4,744,257 5,146,823 5,578,557 6,042,353 6,534,438 6,966,799 7,371,603 7,847,198 8,324,378 62,908,982

Operating Expenses

Payroll, Tax & Employee - 5,559,470 5,559,470 6,671,364 6,671,364 8,005,637 8,005,637 9,606,764 9,606,764 11,528,117 11,528,117 82,742,705

Administrative & General - 915,191 1,010,448 1,104,280 1,202,177 1,305,056 1,410,854 1,588,181 1,588,181 1,686,289 1,777,678 13,588,334

Sales & Marketing - 1,143,988 1,263,060 1,380,350 1,502,721 1,631,320 1,763,567 1,985,226 1,985,226 2,107,861 2,222,097 16,985,418

Property Opr, Energy - 1,372,786 1,515,672 1,656,420 1,803,265 1,957,584 2,116,281 2,382,272 2,382,272 2,529,433 2,666,517 20,382,501

4% Management Fee - 915,191 1,010,448 1,104,280 1,202,177 1,305,056 1,410,854 1,503,871 1,588,181 1,686,289 1,777,678 13,504,024

Divestation & Installmnt -

Asset Reinvestment - - - - - 10,907,677 - - - - 9,705,447 20,613,124

Total Cash OutFlow 50,806,600 14,259,201 15,103,355 17,063,519 17,960,262 31,154,681 21,241,631 24,033,114 24,522,228 27,385,187 38,001,911 281,531,688

21% Gov Tax & Service - 1,324,949 1,662,834 1,757,368 2,095,204 2,166,076 2,522,522 2,433,542 2,781,457 2,702,500 2,997,405 22,443,857

ENDING BALANCE - 7,295,612 15,790,625 24,576,746 34,575,703 33,881,338 45,388,529 56,518,651 68,919,496 80,989,028 84,431,654 84,431,654


18/18

7,295,612

15,790,625

24,576,746

34,575,70333,881,338

45,388,529

56,518,651

68,919,496

80,989,028

84,431,654

-

10,000,000

20,000,000

30,000,000

40,000,000

50,000,000

60,000,000

70,000,000

80,000,000

90,000,000

1 2 3 4 5 6 7 8 9 10

Presentation - Kemuning Budget

Documents

Transcript of Presentation - Kemuning Budget