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 10 Suites)
4
15
5
Average Price pr Room/NightOccupancy Rate NightsNights in OpsTotal RevPA
6
6075%365274 16,425
7
8
9
Estimated Income
10
2017201820192020
11
Total Profit Share 348,880 348,880 348,880 485,130 Percentages
12
Master Franchisers
(ie EUor USA)
10,466.39 10,466.39 10,466.39 14,553.89 3.0%
13
Country/State Franchisee
(ie Laos or LA)
34,887.98 34,887.98 34,887.98 48,512.98 10.0%
14
Local Franchisee (ie SF)0 to 5%
15
Land Owners 151,762.69 151,762.69 151,762.69 211,031.44 43.5%
16
POSHTEL 151,762.69 151,762.69 151,762.69 211,031.44 43.50%
17
18
94092.86858
19
Asumptions (AirBnb put this on top)
20
Ancillary Sales$ Amountspend/day% ProbabilitySales/Yr
21
Cleaning and Laundry20100% 5,475
22
Food & Beverage20100% 5,475
23
Recreationn rentals (Bike, Canoes, etc)
2050% 2,738
24
Electricity, Water, and waste10100% 2,738
25
26
Operating CostReccurance$ CostSum
27
License & permits One time 1,000 1,000
28
Marketing & AirBnb ManagementMonthly3% 493
29
Wifi/4g/3g/mth Monthly 100 1,200
30
31
FinancingCost pr UNITSUM COST
32
Container50000 750,000
33
Interest9% 817,500
34
Monthly Installment 11,354
35
Yearly Installment 136,250
36
37
38
39
Revenue Breakdown
40
2017201820192020
41
Rental Revenue pr. unit 16,425 16,425 16,425 16,425
42
Ancillary Revenue 16,425 16,425 16,425 16,425
43
Total Revenue from Operations 10 units 492,750 492,750 492,750 492,750
44
Financing Cost 136,250 136,250 136,250 -
45
46
47
48
Cost of Operation
49
Admin fee30.00%
50
Ancillary COGS - - - -
51
Cost of Operation 2,693 2,693 2,693 2,693
52
HQ Operating Cost (Logisitic, Brand, Marketing, Etc.) 4,928 4,928 4,928 4,928
53
Total Estimated Cost 7,620 7,620 7,620 7,620
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
 
 
Main menu