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
		


	



Sheet 2: BLANK Hotel Revenue Projection

	
	
	
	
	
	
	

		


		
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
		


		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-