Valuation Workbook: Using the SALE1 | SALE2 - Improved Sales sheet

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 

  1. Subscription Tier: Professional or Enterprise
  2. Sales Comparables loaded into Valcre Online
  3. The current Valcre Valuation Workbook was downloaded and set up by enabling the SALE1 and/or SALE2 modules. 

Table of Contents

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. 

Snag_28b9934.png

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.

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