Before we start, please review the different shading types and cell colors in the Valcre Valuation Workbook.
Yellow: Typeable fields with manual entry. You can overwrite any information populated as necessary.
Blue: Drop-down menus with different options to select.
Green Color Text: Data will be pulled directly from Valcre Online. You can change items in the Green text, but we recommend only doing so where the entry field is shaded in Yellow. Green text fields without the yellow shade contain essential formulas that should not be overridden.
Setting up the Workbook
Step 1: Add your Job
Select Load Job from the Valcre Ribbon, select the job you wish to load into the Valuation Workbook and select Load.
Pro Tip: The jobs assigned to you will show by default. If you wish to access jobs you are not assigned, de-select the Assigned to Me radio box.
Step 2: Complete the Workbook Set Up
2a. Select Lodging & Hospitality as the Property Type
Next, select the appropriate Property Subtype.
Occupancy Status can be left blank, as it will rarely apply
2b. Select Lodging and Hospitality for the Template option in Step 3 of the Set Up.
2c. Select an appropriate preset from the dropdown options for Select Modules, or select Show All to view all available modules.
In this guide example, we will enable the following modules:
Cost Approach
Improved Sales Comparison Approach
Income Survey Module
Discounted Cash Flow
Select Hotel Excel for the DCF option
Note: The Income Approach elements highlighted in the image below are designed to assess a mixed-use hotel property, such as a hotel with ground-floor retail.
2d. Finally, select Set Up to complete the Workbook Set Up
Step 3: Review all fields to add additional information about the property and analysis.
Pro tip: Green text indicates this field will pre-populate with data from Valcre Online. Please note that any changes to data in the Valuation workbook pulled in from Valcre Online will not update the new information in Valcre Online. We always recommend changing the database to keep it as your source of truth. Once changed in Valcre Online, reload the job in the workbook with the new information.
Step 4: Complete all applicable fields in the Valuation Scenarios and Insurable Replacement Cost sections:
Once you have completed all the necessary information on the Home sheet, you can proceed to the Facilitiessheet for the Hospitality Workbook.
Additional Questions? Valcre Support is ready to help with all your Valcre product questions! You can connect to us via phone, email, or chat!
Comments
0 comments