Table of Contents

• How-to Guide

Prerequisites

• Subscription Tier: 
  • Enterprise: Included with the Subscription fee
  • Professional: Available as an Add-On
    • Please contact the Client Success Manager if you want to upgrade your subscription to include the Valcre Hospitality Workbook and Report. 
• Downloaded Hospitality Workbook from Valcre Online.
• Set up Hospitality Valuation Workbook 

Step 2: Complete the Hotel Averages table for the quarter you selected

• Enter the Occupancy, ADR, Rev (mm’s) (Revenue in $millions), and Supply for each year
• The RevPar row will be calculated based on the Occupancy and ADR values

Step 3: Complete the Hotel Averages table for the segment selected

• Enter the Occupancy, ADR, and Rev (mm’s) (Revenue in $millions)
• The RevPar row will be calculated based on the Occupancy and ADR values

Step 4: Complete the Hotel Operations table

4a. Enter the number of Rooms, Occupancy, and ADR above the table
4b. Enter the Nominal Values for the Revenue and Expense items in the yellow-shaded cells The %Ratio, $Room, and $Occupied Room Night columns will be calculated based on the values entered

Step 5: Add these tables to your Report. 

If these tables are not already in your Report, use the link names below each table to insert them using the Insert Link feature in the Valcre Ribbon.

• HMA_SegmentProf4th
• HMA_SegmentProfAnl
• HMA_SegmentProfOps