POSHTEL SIMPLE MODEL
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEF
1
2
PlEASE DON'T CHANGE (SUGGEST IN EDITABLE MODEL)
3
the Number of Containers (in Yellow) - (MINIMUM 10 Suites)
4
10
5
Average Price pr Room/NightOccupancy Rate NightsNights in OpsTotal RevPA
6
20060%365219 43,800
7
8
9
Estimated Income
10
2017201820192020
11
Total Profit Share 371,079 371,079 371,079 552,746 Percentages
12
Master Franchisers
(ie EUor USA)
11,132.38 11,132.38 11,132.38 16,582.38 3.0%
13
Country/State Franchisee
(ie Laos or LA)
37,107.93 37,107.93 37,107.93 55,274.60 10.0%
14
Local Franchisee (ie SF)0 to 5%
15
Land Owners 161,419.51 161,419.51 161,419.51 240,444.51 43.5%
16
POSHTEL 161,419.51 161,419.51 161,419.51 240,444.51 43.50%
17
18
100080.0962
19
Asumptions (AirBnb put this on top)
20
Ancillary Sales$ Amountspend/day% ProbabilitySales/Yr
21
Cleaning and Laundry20100% 4,380
22
Food & Beverage20100% 4,380
23
Recreationn rentals (Bike, Canoes, etc)
2050% 2,190
24
Electricity, Water, and waste10100% 2,190
25
26
Operating CostReccurance$ CostSum
27
License & permits One time 1,000 1,000
28
Marketing & AirBnb ManagementMonthly3% 1,314
29
Wifi/4g/3g/mth Monthly 100 1,200
30
31
FinancingCost pr UNITSUM COST
32
Container50000 500,000
33
Interest9% 545,000
34
Monthly Installment 15,139
35
Yearly Installmnent 181,667
36
37
38
39
Revenue Breakdown
40
2017201820192020
41
Rental Revenue pr. unit 43,800 43,800 43,800 43,800
42
Ancillary Revenue 13,140 13,140 13,140 13,140
43
Total Revenue from Operations 10 units 569,400 569,400 569,400 569,400
44
Financing Cost 181,667 181,667 181,667 -
45
46
47
48
Cost of Operation
49
Admin fee30.00%
50
Ancillary COGS - - - -
51
Cost of Operation 3,514 3,514 3,514 3,514
52
HQ Operating Cost (Logisitic, Brand, Marketing, Etc.) 13,140 13,140 13,140 13,140
53
Total Estimated Cost 16,654 16,654 16,654 16,654
54
55
56
Risk
57
Distruction
58
Robbery
59
26 Plus
60
27 Plus
61
28 Plus
62
29 Plus
63
30 Plus
64
65
66
67
68
69
70
71
72
73
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
Loading...
 
 
 
Master Version (Check Before Edit)
Editable Version (brainstorm)
Edit Suggestion
Personal Brainstorm links