Hotel Revenue Projection Excel Template

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.

hotel revenue projection template

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:

  1. 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

  2. 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.

  3. 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.

  4. 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.

Notes and major health warnings
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.
Last modified March 6th, 2020 by Michael Brown

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 degree from Loughborough University.

You May Also Like