Welcome to Valcre's Hospitality Workbook! This is included with the Valcre Enterprise plan.
Below, you will find a library of video tutorials that go through the Hospitality Workbook functionality. The videos are organized by each tab in the workbook and accompanied with a brief summary of that tab's functionality.
Hospitality quick links and video tutorial library
Home tab:This video focuses on the process for setting up your hotel analysis and identifies the differences between the home tabs in the hospitality workbook and the main workbook |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Facilities tab:In this tab, you are able to note the property amenities and their relevant details such as size, location in the building, and capacity |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Market Profile tab:In this tab, you are able to input market stats for the subject property including occupancy rates, daily rates, and revenue per available room
|
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Demand Driver Statistics tab:In this tab, you can input itemized demand drivers that you perceive are impacting room night demand |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Room Night Builder tab:In this tab, you are able to input room night supply and demand for the subject and the competitive set which will facilitate demand and occupancy projections in the coming tabs |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Data Sets tab:In this tab, statistics for the subject and the competitive set are organized for comparison, and the data set information such as names, open date, rooms and locations |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Set Trends tab:In this tab, the collected history and projections are organized into charts to show trends for average daily rate, occupancy rate, and revenue per available room |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Segmentation tab:In this tab, the segmentation conclusions for the subject and the competitive set are organized for analysis *This sets up the Demand Project Analysis tab |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Demand Projections tab:In this tab, you can make conclusions about annual demand for the subject and the set as well as identify new supply |
*To make full screen, click the square "fullscreen" button on bottom right of video |
PenOccupancy tab:This is part 2 of the Demand Projections tab. In this tab, you can make conclusions about how the subject will perform compared to properties within the competitive set |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
ADR Builder tab:This tab enables you to forecast growth for room rates for the set on a per segment basis, and then estimate how the subject will perform compared to the properties within the set
|
*To make full screen, click the square "Fullscreen" button on bottom right of video |
ADR Occupancy Summary tab:In this tab, the data is organized into tables highlighting conclusions for rates and occupancy for the subject, the set, and the surrounding market |
*To make full screen, click the square "fullscreen" button on bottom right of video |
Projections Summary tab:In this tab, the data is organized into a table and drives charts that provide a summary of the conclusions that you made for supply and demand as well as rates and occupancy for the subject, the set, and the surrounding market |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Expense Comparable tab:This tab is used to input data for the expense comparables as well as any third party data source |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Income and Expenses tab:In this tab, you are able to track the history for the charted accounts for the subject. Revenue and expenses for all departments can be tracked here! |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Revenue and Expenses tabs:Estimates for revenue and expenses as well as growth and variability settings are made on these tabs. The following four tabs work in conjunction with each other: -Departmental Revenue and Expenses tab (0:34) -Undistributed Expenses tab (9:58) -Fixed Expenses tab (10:47) -Fixed Variable tab (13:20) |
*To make full screen, click the square "Fullscreen" button on bottom right of video |
Direct Cap tab and DCF tabs:The data in these tabs are collected as a function of completing the revenue and expense tabs. The Direct Cap and DCF tables are generated automatically and do not require any additional set up. However, you are able to modify and edit various cash flow related elements in order to customize your analysis |
*To make full screen, click the square "Fullscreen" button on bottom right of video |