Valcre supports import of PwC Investor Survey data into our Valcre Workbook. Below is an overview of the data that can be imported into Valcre and links to helpful information to walk you through the process.
PwC Investor Survey data supported in Valcre:
- Capitalization Rates (OAR) | current year and multi-year historical values back to 2000
- Exposure & Marketing Time | current and 1 year historical
- Discount Rates | current year and multi-year historical values back to 2000
- Residual Cap Rates | current year and multi-year historical values back to 2000
How to import PwC data into Valcre:
- From the workbook, click on the "PwC" link in the OAR sheet of the workbook to login to PwC to access Investor Survey data
- From the Home screen on PwC National, scroll down and select “Property” under Survey Market Spotlights
- Select your region from the dropdown menu
- To the right side of the screen, click on “View Detailed Findings”
- Scroll down to the lower half of the next page and locate the graph under the heading, “Key Indicator Analysis”
- On the right side of the chart, click on the download button and select “Download Data in Excel”
- Export Market files from PwC website for up to 4 markets to analyze in Valcre
- Note: Historical data access varies by PwC Subscription Plan
- Navigate to the OAR sheet in the Valcre Workbook and load each Market file into the National Investor Survey table
- Data will automatically populate the table and charts for all time periods included in the export files
- Imported data will automatically populate the Discount Rates and Residual Cap Rates tables and charts on the RATES sheet
- Manually populate ranges (min and max) if desired for analysis
- Navigate to the EXEC sheet and manually populate the Exposure & Marketing Time table
Additional learning resources: