Key Physical Characteristics

Use the Narrative Writer function (Must have: Valcre AI add-in, workbook version 1.7.1+ and add-in 2.1.1+) to create your preferred narrative style. Make any changes by typing directly into the narrative box before selecting Use Narrative.

Older versions of the workbook/add-in: This comment box uses a formula to automatically pull data from other areas of the Valuation Workbook via Valcre Online.

• To edit or add to the comment: Press F2. + F9 to convert the formula into plain text. 

Key Economic Characteristics

This comment box uses a formula to automatically pull data from other areas of the Valuation Workbook and Valcre Online.  It will populate once the RENTROLL sheet is completed.

To edit or add to the comment: Press F2. + F9 to convert the formula into plain text. 

Key Appraisal Problem being solved

This comment box is for manual entry. Use it to describe the key appraisal problems being addressed by typing directly into the text field. No need for F2+F9.

These sections are primarily populated with the information entered into Valcre Online.

• To change any of this information, update the relevant record in Valcre Online, then reload the Workbook.

Some fields won’t populate until you’ve completed other parts of the Workbook. For example, the Seismic Risk value will appear only after that field is filled out on the SITE sheet. This table will be fully populated once you’ve finished the “Front Half” of the Workbook.

These charts will appear in your report as shown in the Workbook. To remove any data, right-select the row you do not wish to display and select Hide. 

Pro tip: As with any table, do not delete columns or rows; it will cause workbook errors to form and prevent their usage in the Report file.  

Highest & Best Use

This table will pre-populate after completing the SITE sheet in the Workbook, using the data input there. 

Exposure & Marketing Time

This table will pre-populate after completing the Exposure & Marketing Time chart located further down on this sheet.

Strengths, Weaknesses, Opportunities, & Threats

This table has a yellow field, indicating that you can type freely into the boxes provided.  

Step 1: Select if you are using the PwC Real Estate Investor Survey.

• Selecting Yes will activate the PwC Real Estate Investor Survey section of the in the Exposure & Marketing Time table.
• By default, this is set to No.

Pro tip: The drop-down names in this table automatically match the data imported from PwC—either by using the Import button in the Valcre ribbon or by manually entering data directly onto this sheet. 

Step 3: Select whether you are using the Market Participant Survey and how many participants you will include.

• Note: This section will activate at the bottom of this table allowing you to overwrite the placeholder text to fill out your Market Participants and Company information. 

Step 4: Select if you are using Sales Comparables.

• Note: This will include the Improved Sales line at the bottom of the table

Step 6: Select if you would like to include Most Profitable Buyer.

• Note: This will include the Most Profitable Buyer line at the bottom of the table.

Step 8: The Months Range and Average columns will update dynamically based on the data imported via API using the Import button in the Valcre Ribbon. If you are not using the API, you will need to manually enter this data. 

• Note: The overall Average will be calculated at the bottom.