ABCDEFGH
1
Make a copy of this spreadsheet and play with it as you want!
2
3
STARTING DATASTARTING COSTS
4
Unit PriceTotal Price
5
10Number of prefab units$25,000$250,000Total cost of all prefab units
6
250Land area under the prefab unit (sq ft)$40$100,000Utility hookups and foundation
7
500Surounding area per unit (sq ft)$5$25,000Land preparation
8
3000Walking paths (sq ft)$10$30,000Walking paths development
9
7500Total area (sq ft)$1$7,500Costs of obtaining necessary licenses
10
TOTAL$412,500
11
12
13
REVENUE
14
15
OccupationRate per night (in USD)DaysIncome (Per unit)Income (Total)
16
Low Season50%$80185$7,400$74,000
17
Medium Season75%$115120$10,350$103,500
18
High Season90%$14560$7,830$78,300
19
AVERAGE64.79%$108365$25,580$255,800
20
21
22
FIXED COSTS
23
24
Staff costs365$3,600$43,800
25
General Manager
365$1,800$21,900
26
 Maintenance365$1,800$21,900
27
Administration and legal costs365$150$1,825
28
Marketing365$300$3,650
29
Depreciation and Amortization10%$3,438$41,250
30
TOTAL FIXED COSTS$11,088$134,325
31
32
33
VARIABLE COSTS
34
35
Staff costs365$1,971$23,650
36
 Housekeeping$10.00$1,971$23,650
37
Booking commissions12%$2,558$30,696This can be eliminated by having direct bookings
38
Supplies and third parties works$6.00$1,183$14,190
39
TOTAL VARIABLE COSTS$5,711$68,536
40
41
42
PROFIT OR LOSS$52,939
43
44