Financial Model for Hostels
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJLMNOPQRSTUVWXYZAAABAC
1
2
Note: To edit the numbers in Google Sheets, first make a copy of this sheet (File > Make a copy).
Or alternatively download to use in Excel (File > Download as > Microsoft Excel).
3
4
Made by Tim Zenderman (BananaDesk).
5
Interested in a demo of BananaDesk? Email us: demos@bananadesk.com
6
See detailed post on how to use this spreadsheet here.
7
8
9
Hostel Setup
Expenses
10
11
Total Dorm Beds
55
Fixed Expenses
12
Total Private Rooms
10
Rent / month
$2,000.00
13
Dorm Base Occupancy
50.00%
Insurance / month
$300.00
14
Private Rooms Base Occupancy
75.00%
Internet / month
$150.00
15
Dorm Base Rate
$12.00
Other utilities / month
$500.00
16
Private Room Base Rate
$45.00
Technology / month
$200.00
17
Maintenance / month
$500.00
18
Extras
Reception - Day Shift Hours
16
19
Percentage of Guests buying Extras
40.00%
Reception - Day Wage
$10.00
20
Average Spend per Purchase
$10.00
Reception - Night Shift Hours
8
21
Profit Margin on Extras
40.00%
Reception - Night Wage
$12.00
22
23
24
Seasonality
Too many days!
Semi-Fixed Expenses
25
If you're having trouble with these, go to the "Calculator for Semi-Fixed Expenses" tab.
26
Days Closed
30
Housekeeping Base / day
$80.00
27
Housekeeping / bed / night
$1.00
28
Special Dates
Electricity Base / day
$20.00
29
Number of Special Days
15
Electricity / bed / night
$0.70
30
Occupancy rate
100.00%
Water Base / day
$10.00
31
Rate Multiplier
5.00
Water / bed / night
$0.25
32
Gas Base / day
$15.00
33
High Season
Gas / bed / night
$0.35
34
Number of High Season Days
90
35
Occupancy rate
80.00%
Variable Expenses
36
Rate Multiplier
1.20
Free Breakfast / bed / night
$2.00
37
Laundry / bed / night
$0.25
38
Low Season
OTA Percent of Total Reservations
80.00%
39
Number of Low Season Days
45
OTA Commission Percentage
18.00%
40
Occupancy rate
50.00%
41
Rate Multiplier
0.80
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
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...