PPA Module: Setting up the PPA worksheets

Table of Contents

1. Commercial setup
2. Multi-Family setup

Prerequisites

• Subscription: Professional + Enterprise
  • PPA Add-on purchased and implemented
• Version Requirement:
  • Workbook: 1.6.3.1 or higher
  • Add-in: 2.0.12.0
• Completed Workbook: up to PPA modules
  • Recommended: Argus Package import (Commercial)
  • Recommended: Completed Expanded Cost Approach

Step 1: Set up your workbook

Pro Tip: Make sure to enable the Income + Commercial Leases-Rent 1 module, as this will give you access to the RENTROLL sheet

Step 2: Enable the DCF module for Argus

Step 4: Import your Argus package or individual reports directly on the DCF sheet using the legacy import method. 

• This will take care of populating your RENTROLL sheet with data from your Argus package or individual report, which will be used to populate the PPA module worksheets
• The Argus reports will also include additional data to power the PPA module, such as MLA data and information used to populate per-tenant cash flow tables

Not sure how to use our legacy Argus file import? Use our guide: How to import Argus package via Legacy Import method

Not using an Argus DCF? 

1. Manually enter your subject property rent roll on the RENTROLL sheet
   • Review our RENTROLL guide: Using the RENTROLL sheet (Multi-Tenant)
2. Complete set up of your MLA’s by manually entering this data on the PPA_EXEC sheet.

Step 5: Load the PPA for Commercial Module. 

• In the Valcre Ribbon, select Load Module → PPA_ASC805_COM

Step 1 :  Set up your workbook

Pro Tip: Enable the Survey + Subject Unit Mix - Survey 1 module. This will give you access to the UNITMIX sheet.

Step 2: On the UNITMIX sheet, import your subject unit mix from Valcre Online or manually enter it. 

• You can also utilize the Alternate Multifamily Rent Roll option to input your entire multifamily property’s rent roll and generate your Unit Mix. This can be enabled from the UNITMIX sheet:

Need a refresher? Review our Unit Mix guide: Using the UNITMIX sheet

Step 3: Load the PPA module for Multi-Family

• In the Valcre Ribbon, select Load Module →PPA_ASC805_MF