Valuation Workbook: Using the SALE1 | SALE2 - Improved Sales sheet
Jen McGee
Available on Plans
Essentials
Professional
Enterprise
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.
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
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.
Optionally you manually remove or add any comparables in the Comp ID field
Add by typing directly in the yellow field
Step 3: Adjust your Rounding
Select if you wish to see figures in the whole dollar or wish to show dollars and cents.
Step 4: Determine if you will adjust the Income and Physical information table.
Step 5 (optional): Enter your Standard Adjustment rate
The Sales Comparison table will have a summary of your Sales Comparables.
Step 7: Pull in any additional comp attributes from Valcre Online to populate additional fields. These attributes will populate with data that was input into Valcre online.
NEW with all workbook versions 1.6.0 or higher: 34 additional adjustment categories, including granular adjustments from related buildings, parcels, and streets across all Comp Grids. Additionally, the adjustment values and aggregates will match Valcre Online.
IE: If you have multiple buildings, the Years Built will now show a range across all buildings.
Pro tip: This section has 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.
Pro tip: 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.
Step 3: If you are making any adjustments (e.g., lease-up costs), use the Adjustment dropdown. Enter the adjustment’s name and value in the table, then select the indicated value.
New Adjustment Option (Available in Workbook versions 1.6.1.0 or higher): Select Multiple from the dropdown to add three adjustment types, which pull data from the LeaseUp(Lease-Up Analysis Detailed Table) and the Extra sheet (Net Present Value table):
PV of Capital Expenditures
Rent Loss & Leasing Costs
PV of Below Market Rent
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.
Any conclusions made in the improved sales comparison approach conclusions will appear in the VALUES sheet.
Improved Sales Map
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.
Step 3: Drag and drop the North Arrow onto your map, placing it in the desired location. Rotate the arrow so it points north, making the map easier for your client to read.
Only available with Workbook versions 1.6.2.0 or higher.
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
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.
Comments
0 comments