154x Filetype XLSX File size 1.38 MB Source: www.smartsheet.com
Sheet 1: Hotel Revenue Projection
HOTEL REVENUE PROJECTION TEMPLATE | ||||||||||
* User to complete non-shaded cells, only. | ||||||||||
ROOMS | DAYS OPEN | TOTAL OCCUPANCY AVAILABLE PER YEAR |
||||||||
40 | 365 | 14,600 | ||||||||
OCCUPANCY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | |||||
OCCUPANCY RATE enter percentage | 50.00% | 55.00% | 65.00% | 75.00% | 80.00% | |||||
OCCUPIED ROOM NIGHTS | 7,300 | 8,030 | 9,490 | 10,950 | 11,680 | |||||
REVENUE | ||||||||||
AVERAGE DAILY ROOM RATE | $110.00 | $115.00 | $120.00 | $125.00 | $130.00 | |||||
ROOM REVENUE TOTAL | $803,000.00 | $923,450.00 | $1,138,800.00 | $1,368,750.00 | $1,518,400.00 | |||||
OTHER REVENUE % based on total room revenue | ||||||||||
FOOD | 10% | $80,300.00 | $92,345.00 | $113,880.00 | $136,875.00 | $151,840.00 | ||||
BEVERAGE | 5% | $40,150.00 | $46,172.50 | $56,940.00 | $68,437.50 | $75,920.00 | ||||
OTHER 1 | $2,000.00 | $3,000.00 | $4,000.00 | $5,000.00 | $6,000.00 | |||||
OTHER 2 | $500.00 | $600.00 | $700.00 | $800.00 | $900.00 | |||||
OTHER REVENUE TOTAL | $122,950.00 | $142,117.50 | $175,520.00 | $211,112.50 | $234,660.00 | |||||
TOTAL REVENUE | $925,950.00 | $1,065,567.50 | $1,314,320.00 | $1,579,862.50 | $1,753,060.00 | |||||
CLICK HERE TO CREATE IN SMARTSHEET |
HOTEL REVENUE PROJECTION TEMPLATE | |||||||||
* User to complete non-shaded cells, only. | |||||||||
ROOMS | DAYS OPEN | TOTAL OCCUPANCY AVAILABLE PER YEAR |
|||||||
0 | 0 | 0 | |||||||
OCCUPANCY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | ||||
OCCUPANCY RATE enter percentage | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||||
OCCUPIED ROOM NIGHTS | 0 | 0 | 0 | 0 | 0 | ||||
REVENUE | |||||||||
AVERAGE DAILY ROOM RATE | $- | $- | $- | $- | $- | ||||
ROOM REVENUE TOTAL | $- | $- | $- | $- | $- | ||||
OTHER REVENUE % based on total room revenue | |||||||||
FOOD | 0% | $- | $- | $- | $- | $- | |||
BEVERAGE | 0% | $- | $- | $- | $- | $- | |||
OTHER 1 | $- | $- | $- | $- | $- | ||||
OTHER 2 | $- | $- | $- | $- | $- | ||||
OTHER REVENUE TOTAL | $- | $- | $- | $- | $- | ||||
TOTAL REVENUE | $- | $- | $- | $- | $- | ||||
no reviews yet
Please Login to review.