POSHTEL SIMPLE MODEL
 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 15 Suites)
4
1
5
Occupancy Rate NightsNights in OpsTotal RevPA
6
$0.0066%365242 -
7
8
9
Estimated Income
10
2017201820192020
11
Total Profit Share - 11,283 3,236 3,236 12,320 Percentages
12
Master Franchisers
(ie EUor USA)
- 338.50 97.09 97.09 369.59 3.0%
13
Country/State Franchisee
(ie Laos or LA)
- 1,128.33 323.64 323.64 1,231.97 10.0%
14
Local Franchisee (ie SF)0 to 5%
15
Land Owners- 4,908.25 1,407.82 1,407.82 5,359.07 43.5%
16
POSHTEL- 4,908.25 1,407.82 1,407.82 5,359.07 43.50%
17
18
-3043.115
19
Asumptions (AirBnb put this on top)
20
Ancillary Sales$ Amountspend/day% ProbabilitySales/Yr
21
Cleaning and Laundry20100% 4,840
22
Food & Beverage20100% 4,840
23
Recreationn rentals (Bike, Canoes, etc)
2050% 2,420
24
Electricity, Water, and waste10100% 2,420
25
26
Operating CostReccurance$ CostSum
27
License & permits One time 1,000 1,000
28
Marketing & AirBnb ManagementMonthly3% -
29
Wifi/4g/3g/mth Monthly 100 1,200
30
31
FinancingCost pr UNITSUM COST
32
Container50000 50,000
33
Interest9% 54,500
34
Monthly Installment 757
35
Yearly Installment 9,083
36
37
38
39
Revenue Breakdown
40
2017201820192020
41
Rental Revenue pr. unit - - - -
42
Ancillary Revenue 14,520 14,520 14,520 14,520
43
Total Revenue from Operations 10 units - 14,520 14,520 14,520
44
Financing Cost 9,083 9,083 9,083 -
45
46
47
48
Cost of Operation
49
Admin fee30.00%
50
Ancillary COGS - - - -
51
Cost of Operation 2,200 2,200 2,200 2,200
52
HQ Operating Cost (Logisitic, Brand, Marketing, Etc.) - - - -
53
Total Estimated Cost 2,200 2,200 2,200 2,200
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...
Main menu