The SALE1 / SALE2 sheets in the Valcre Valuation Workbook. are the Improved Sales Comparison Approach sheets. This guide will teach you how to use them.
Prerequisites
- Subscription Tier: Professional or Enterprise
- Sales Comparables loaded into Valcre Online
- The current Valcre Valuation Workbook was downloaded and set up by enabling the SALE1 and/or SALE2 modules.
Table of Contents
- Enabling the Sale 1 | Sale2 sheets
- Improves Sales Comparison Approach Set-up
- Improved Sales Comparision table
- Improved Sales Comparison Approach Conclusion table
- Improved Sales Map
- Improved Sales Photographs
How-to Guide
Enabling the Sale 1 | Sale 2 Module
Step 1: In the Home sheet, select any module with Sale1 and, if applicable, Sale2. You may also select SHOW ALL under the Modules, then select Yes for Sale Module 1 and Sale Module 2 (if applicable).
Improved Sales Comparison Approach Table
How-to Guide
Step 1: Select Comp Set Name to Import from Valcre Online.
This will pull the data into the improved sales comparison table below.
Step 2: Clean up the table by using the comparables analyzed number to remove excess space.
Step 3 (optional): Remove or add any comparables in the Comp ID field
Add by typing directly in the yellow field
Step 4: Adjust your Rounding
Select if you wish to see figures in the whole dollar or wish to show dollars and cents.
Step 5: Determine if you will adjust the Income and Physical information table.
Step 6 (optional): Enter your Standard Adjustment rate
The Sales Comparison table will have a summary of your Sales Comparables.
Step 7: Pull in any additional items from Valcre Online to populate additional fields using the information entered into Valcre Online for that item.
Pro tip: This section has ten additional lines hidden; unhide them if you wish to add additional items to this table.
- As with any table, do not delete columns or rows; it will cause workbook errors to form and prevent their usage in the Report.
Sale information
This section allows you to make sale adjustments.
- Note: Sales price vs. Analysis price in valcre online is expenditures after the sale. This is automatically calculated here.
Step 1: Using the yellow fields, make all applicable adjustments.
Step 2: Select how you would like to view the Marketing Period.
Income and physical information
This section allows you to make further adjustments.
Step 1: Using the yellow fields, make all applicable adjustments
Step 2: Select your qualitative items. These will have automatic adjustments based on the drop-downs selected and are adjusted based on the standard adjustment field set at the top of this sheet.
- You may manually override any of these fields; simply type directly into the field.
Step 3: Add additional items you would like to make adjustments on
Pro tip: This section has nine additional lines hidden; unhide them if you wish to add additional items to this table.
- As with any table, do not delete columns or rows; it will cause workbook errors to form and prevent their usage in the Report.
Improved Sales Comparison Approach Conclusion table
How-to Guide
Shows a summary of adjustments that will assist you in making your final conclusion.
Step 1: Enter the $/SF Conclusion to generate your final Value.
Step 2: Select the Indicated Value. These values were selected on the HOME sheet. If you would like to adjust them, please adjust on the HOME sheet and select Set Up Workbook again to update your changes.
Step 3: If you are making any adjustments, such as lease-up costs, select Yes from the Adjustment dropdown, enter the adjustment's name and value in the table, and select the indicated value.
Step 4: Select where you would like to round to using Rounding.
|
Pro tip: To disable the adjustment summary, select Yes in the Hide Adjustment Summary drop-down menu to the right of the table. |
Note: Any conclusions made in the improved sales comparison approach conclusions will appear in the VALUES sheet.
Improved Sales Map
How-to Guide
This map will show your Subject and Comparables using Google Maps (default) or Here Maps.
Step 1: Bring in your map by selecting your preferred map provider and then select Get Map
| Pro tip: Are you seeing overlapping pins? If this is the case, you can use the moveable map pins provided at the top of the chart to ensure your map is displayed correctly. More information on how to work around this scenario can be found in the following video - Modifying Comparable Map Pins |
Step 2: Set map preferences
| Map size | |
|
Show Key Appears below the map |
|
| Map Type | |
|
Zoom Note: The Zoom defaults to Auto, fitting the subject and all comparables on the view. Adjust your zoom as necessary using the drop-down and selecting Get Map to show changes. |
|
|
Pin Style Adjust your pin style to highlight your subject and comparables as appropriate for your report, and select Get Map to show changes. |
Additional Pin Modifications
Step 1: Adjust Pin Colors and Labels.
These were pre-set during branding when you first purchased Valcre, but they can be manually updated by right-clicking and selecting a new color fill.
Improved Sales Photographs
How-to Guide
Step 1: Select Get Photos to bring your Sales Comparable photos from Valcre Online.
Step 2 (optional): Resize the photos
The photos will retain the same height, but you may need to adjust the width. Manually change the sizing as applicable.
| Continue Learning about Valcre with our next suggested guide: Valcre Workbook: Using the RENT1- Rent Roll Single-Tenant sheet. |
For additional questions about Using the SALE1| SALE2 sheet in Valcre Office, please contact Valcre Support using the live chat feature in Valcre Online or Valcre Mobile.