Using the Competitive Set Trends Sheet in the Hospitality Workbook

This sheet is where the historical and forecasted trends associated with the Average Daily Rate and Occupancy Rate you have identified are aggregated and organized into tables with charts for visualization.


This guide shows you how to use the Competitive Set Trends sheet in your Hospitality Workbook.

 

Pre-Requisites 

  1. Subscription Tier: 
    • Enterprise Only
      • Please get in touch with your Client Success Manager if you wish to upgrade your subscription to access the Valcre Hospitality template. 
  2. Downloaded Hospitality Template from Valcre Online
  3. Set up the Hospitality Valuation Workbook 

Table of Contents

  1. Video Walk-Through
  2. How-to Guide

 

Video Walk-Through

 

How-to Guide

Step 1: Access the Competitive Set Trends sheet by selecting SETTRENDS from the bottom menu. 

This sheet contains the Average Daily Rate, Occupancy Rate, and RevPar tables for the Set Trends. These tables do not require any information to be input. The information in this sheet comes from the previous tabs and is setting up the chart. In this sheet, you will find information on the Subject, the Primary Set, and the Submarket. The final column in each table (ADR Index, Occupancy Index, or RevPar Index) is automatically calculated.  

You will notice a column of data still needing information in the charts. This will likely be your Submarket column and will be completed once you finish the ProjSummary Sheet. Once this happens, the missing data will automatically populate. 

Step 2: Review the Average Daily Rate table and form your conclusions. 

Step 3: Add your Average Daily Rate Summary.

In the top yellow field, you can insert text to summarize the analysis detailed in the table below.

Step 4: Review the Occupancy Rate table and form your conclusions. 

Step 5: Add your Occupancy Rate Summary.

In the top yellow field, you can insert text to summarize the analysis detailed in the table below.

Step 6: Review the RevPar table and form your conclusions. 

Step 7: Add your RevPar.

In the top yellow field, you can insert text to summarize the analysis detailed in the table below.

Step 8: Add the table to your Word report (if it has not already been added).

Step 8.1: Once in your Word Report, place the cursor in the area of the Word Report you wish to add these tables. 

Step 8.2: Use the Insert Link feature to add the appropriate table from this sheet.

  • Average Daily Rate: HMA_SetTrendsADR

  • Occupancy Rate: HMA_SetTrendsOcc

  • RevPar: GMA_SetTrendsRevPar

Once you have completed all necessary information in the Competitive Set Trends sheet, you can move on to the Segmentation sheet in the Hospitality Workbook. 


For additional questions about the Competitive Set Trends sheet in the Hospitality Valuation Workbook, please get in touch with Valcre Support using the Online Chat using Valcre Online or Valcre Mobile.

Was this article helpful?
0 out of 0 found this helpful