8/13/2019 Presentation - Kemuning Budget
1/18
8/13/2019 Presentation - Kemuning Budget
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%
8/13/2019 Presentation - Kemuning Budget
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
8/13/2019 Presentation - Kemuning Budget
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
8/13/2019 Presentation - Kemuning Budget
5/18
in a thousand rupiah (Rp000,-)
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
8/13/2019 Presentation - Kemuning Budget
6/18
in a thousand rupiah (Rp000,-)
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
8/13/2019 Presentation - Kemuning Budget
7/18
in a thousand rupiah (Rp000,-)
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
in a thousand rupiah (Rp000,-)
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/13/2019 Presentation - Kemuning Budget
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 - -
8/13/2019 Presentation - Kemuning Budget
9/18
in a thousand rupiah (Rp000,-)
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
8/13/2019 Presentation - Kemuning Budget
10/18
in a thousand rupiah (Rp000,-)
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
in a thousand rupiah (Rp000,-)
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
in a thousand rupiah (Rp000,-)
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
8/13/2019 Presentation - Kemuning Budget
11/18
in a thousand rupiah (Rp000,-)
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
8/13/2019 Presentation - Kemuning Budget
12/18
in a thousand rupiah (Rp000,-)
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
in a thousand rupiah (Rp000,-)
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
8/13/2019 Presentation - Kemuning Budget
13/18
in a thousand rupiah (Rp000,-)
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%
8/13/2019 Presentation - Kemuning Budget
14/18
in a thousand rupiah (Rp000,-)
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%
8/13/2019 Presentation - Kemuning Budget
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
8/13/2019 Presentation - Kemuning Budget
16/18
in a thousand rupiah (Rp000,-)
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
8/13/2019 Presentation - Kemuning Budget
17/18
in a thousand rupiah (Rp000,-)
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
8/13/2019 Presentation - Kemuning Budget
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