ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Premier
4
5
6
7
8
9
10
11
12
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal / YearAverage / Year
13
Days Available31293130313031313031303136630.5
14
Occupancy Rate65%60%60%65%70%75%84%85%75%70%65%79%71%
15
Average Daily Rate$120$94$105$95$105$107$113$115$103$101$102$150$109
16
RevPar$78$56$63$62$74$80$95$98$77$71$66$119$78
17
Gross Revenue, USD$2,418$1,636$1,953$1,853$2,279$2,408$2,943$3,030$2,318$2,192$1,989$3,674$28,690$2,391
18
Gross Revenue, IDRRp39,171,600Rp26,496,720Rp31,638,600Rp30,010,500Rp36,911,700Rp39,001,500Rp47,668,824Rp49,090,050Rp37,543,500Rp35,505,540Rp32,221,800Rp59,510,700Rp464,771,034Rp38,730,920
19
Management & Marketing Fee$242$164$195$185$228$241$294$303$232$219$199$367$2,869$23910%
20
Operational Expenses$532$360$430$408$501$530$647$667$510$482$438$808$6,312$52622%
21
Maintenance / Amortization$24$16$20$19$23$24$29$30$23$22$20$37$287$241%
22
Expenses$798$540$644$611$752$794$971$1,000$765$723$656$1,212$9,468$789
23
Payout to Owner, USD$1,620$1,096$1,309$1,241$1,527$1,613$1,971$2,030$1,553$1,468$1,333$2,461$19,222$1,602
24
Payour to Owner, IDRRp26,244,972Rp17,752,802Rp21,197,862Rp20,107,035Rp24,730,839Rp26,131,005Rp31,938,112Rp32,890,334Rp25,154,145Rp23,788,712Rp21,588,606Rp39,872,169Rp311,396,593Rp25,949,716
25
26
27
Operational expenses*1BDROperational expenses*2BDR
28
*counting relying on the period of June
*counting relying on the period of June
29
Running Costs BreakdownUSDIDRRunning Costs BreakdownUSDIDR
30
Obligatory expensesObligatory expenses
31
Wi-fi$21Rp340,200Wi-fi$21Rp340,200
32
Banjar fee$4Rp71,500Banjar fee$4Rp71,500
33
Garbage fee$3Rp50,000Garbage fee$3Rp50,000
34
Security post$10Rp158,000Security post$10Rp158,000
35
Pool and garden maintenance$25Rp400,000Pool and garden maintenance$25Rp400,000
36
Paid TV&Netflix $12Rp194,400Paid TV&Netflix $12Rp194,400
37
$75Rp1,214,100$75Rp1,214,100
38
Non olbigatoryNon olbigatory
39
Laundry linen$24Rp389,990Laundry linen$32Rp524,822
40
Front Office (Reception, Concierge Service)$62Rp1,000,000Front Office (Reception, Concierge Service)$62Rp1,000,000
41
HSKP$31Rp500,000HSKP$56Rp900,000
42
Hotel Programm (PMS)$22Rp353,500Hotel Programm (PMS)$22Rp353,500
43
Toilet paper and tissues$4Rp58,929Toilet paper and tissues$7Rp117,857
44
Ecolab (cleaning chemicals), pest control service$8Rp123,214Ecolab (cleaning chemicals), pest control service$15Rp246,428
45
Bathroom amenities (shampoo,conditioner and etc)$10Rp164,286Bathroom amenities (shampoo,conditioner and etc)$20Rp328,571
46
Welcome package, amenities$3Rp45,000Welcome package, amenities$5Rp75,000
47
Other supplies (batteries,lamps, mosquito sprays and etc)$21Rp337,500Other supplies (batteries,lamps, mosquito sprays and etc)$32Rp525,000
48
HSKP Inventory (sponges, cloths,brooms and etc)$8Rp135,000HSKP Inventory (sponges, cloths,brooms and etc)$11Rp172,500
49
Electricity$42Rp675,006Electricity$74Rp1,200,000
50
$233Rp3,782,425$336Rp5,443,678
51
TOTAL$308Rp4,996,525TOTAL$411Rp6,657,778
52
53
54
55
56
57
58
59
60
SHORT-TERM RENTAL SUMMARYBASE SCENARIOBEST CASE SCENARIOSTRESSED SCENARIOINVESTMENT SUMMARY / UNITBASE SCENARIOBEST CASE SCENARIOSTRESSED SCENARIO
61
Occupancy Target, %71.08%82%60%Property purchase price$150,000$150,000$150,000
62
Average Rate Target, USD$109$126$93Renovation / Launch setup$200$200$200
63
RevPar Target, USD$78$103$56Annual Revenue, USD$28,690$32,993$24,386
64
Yearly revenue per unit, USD$28,690$32,993$24,386Annual Net Income, USD$19,222$22,105$16,339
65
Unit Count111ROI, %12.80%14.72%10.88%
66
Total Accommodation Revenue$28,690$32,993$24,386ROI, Years7.816.799.19
67
Management & Marketing Fee, USD$2,869$3,299$2,439
68
Operational Expenses, USD$6,312$7,258$5,365USD/IDR Rate16200
69
Maintenance and Amortization, USD$287$330$244Best Case +15%
70
Unit Count111Streesed --15%
71
Total Expenses, USD$9,468$10,888$8,047Property purchase price$150,000
72
Net Income Target, USD$19,222$22,105$16,339Renovation / Launch setup$200
73
Net Income Target, IDRRp311,396,593Rp358,106,082Rp264,687,104
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100