Valuation Workbook: Using the LAND1 | LAND2 - Site Valuation sheet

  Available on Plans Essentials Professional  Enterprise

The LAND1 / LAND2 sheets in the Valcre Valuation Workbook are the Land Sales Comparison Approach sheets. This guide will teach you how to use them. 

 

Table of Contents

 

Prerequisites 

  1. Subscription Tier: Professional or Enterprise
  2. The current Valcre Valuation Workbook was downloaded and set up by enabling the Land1 and/or Land2 modules. 

 


Enabling the LAND1 |  LAND2 Module

Step 1: In the Home sheet, select any module with Land and, if applicable, Land 2. You may also select SHOW ALL under the Modules, then select Yes for Land Module 1 and Land Module 2 (if applicable)

 


Land Sales Comparison Approach Set-up

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): Manually 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 Physical Information table. 

 

Step 6 (optional): Enter your Standard Adjustment rate

 

Land Sales Comparison table

This table will have a summary of your Land Sales Comparables.

Step 1: 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. 
Snag_60ad7b3.png 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.   
Step 2: Using the yellow fields, make all applicable adjustments. 
Step 3: Select how you would like to view the Marketing Period

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; type directly into the field. 

Step 3: Add additional items you would like to make adjustments on

Snag_60ad7b3.png 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.   

 

Land Sales Comparison Approach Conclusion table

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- the same values created on the Home sheet
Step 3: If you are going to make 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.
Snag_60ad7b3.png 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.

Land 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

 

Snag_60ad7b3.png 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: Make map adjustments

Map size

Show Key 

Appears below the map.

Map Type

Zoom

The Zoom on Here maps 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.

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. 

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. 

 


Land Sales Photos

Step 1: Select Yes for Auto-fit and  Get Photos to populate your Land Comparable photos from Valcre Online.

Step 2 (optional): Resize the photos

You may manually adjust the sizing and positioning if you want to re-size the photos further. 

Snag_60ad7b3.png Pro tip: How your photos appear in the workbook is how they will appear in the report.

Additional Questions?  Valcre Support is ready to help with all your Valcre product questions! You can connect to us via phone, email, or chat! 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.