The hotel revenue projection template provides a quick and easy method to estimate the sales revenue generated by a hotel business for the next 5 years.
The revenue forecast generated can be used as starting point for our Financial Projections Template for inclusion in a hotel business plan.
Using the Hotel Revenue Projection Template
The Excel hotel revenue template, available for download below, calculates the annual revenue for a hotel business plan by entering details as follows:
Enter the Hotel Information
Enter the details of the number of rooms in the hotel and the number of days the hotel is open for each year. The hotel revenue template calculates the maximum number of room nights available at the hotel for the year
Enter the Occupancy Rate
For each of the years 1 to 5 enter the occupancy rate as a percentage of the total room nights available. The template calculates the room nights occupied for the year.
Enter the Average Daily Room Rate
Enter the average daily room rate for the year. Our weighted average price calculator is available to help calculate the average room rate if needed.
The hotel revenue template calculates the total annual revenue room revenue.
Enter the Food and Beverage Percentage and Other Revenue
Enter the food and beverage rate as a percentage of the total room revenue. The template calculates an estimate of the revenue from food and beverage by applying this rate to the total room revenue.
To complete the hotel revenue forecast other revenue from sundry activities should be entered on the line provided for each year of the forecast.
The hotel revenue projection template calculates the total other revenue and finally the total revenue of the hotel.
Hotel Revenue Projection Template Download
The hotel revenue projection template is available for download in Excel format by following the link below.
Users use this hotel revenue management excel template at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a hotel sales projections template that you might use when preparing to forecast hotel revenue for inclusion in financial projections. It is purely illustrative of a hotel revenue excel template. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the hotel revenue forecast template, please let us know and we will try to fix it.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a BSc from Loughborough University.