Commercial Lease and Unit Lease Rent Roll Tables

Assumptions

The Rent Roll tables allow for import of rent roll data from the web with engine 46.02. Users can choose to hand-enter Rent Roll data or can import the used in excel instance from web for either Comm Lease of MF Lease data.

Step 1. Choose whether the Rent Roll is Commercial Lease Only, Unit Lease Only or Mixed Use from the drop down at the top of the page. The dropdown will attempt to pre-populate dependent upon the Property Major Type/Property Type in the File info worksheet. 

Step 2. Choose or enter the Effective Date of Rent Roll.

The Effective Date of Rent Roll drop-down allows you to choose one of the dates entered on Dates and Premises. They appear in the drop-down in the following order: 

1. As Is
2. As Complete
3. As Stabilized

Step 3. Choose Contract Calculation.

The default annualization calculation is 12 months. You can choose to calculate via the number of months from January of the analysis year to the month of the effective date of the rent roll. For instance, if the effective date is in October, you have a choice to calculate contract rent at the monthly rate times 12 or the monthly rate x 10

Commercial Lease Rent Roll

The Commercial Rents Confidential drop-down will allow you to select between Yes and No; selecting Yes will only flag this record's Commercial Lease page in the Web Database as Confidential for your reference.

Populating the Commercial Lease Rent Roll Table

Set up Commercial Space Types and corresponding Market Rent to auto-populate the Commercial Rent Roll table.

Entering data in the Rent Roll table will populate all of the subsequent tables, such as Market Rent Summary and Occupancy. Use the Data Entry Indicators button to determine hand-entered fields, formatted in blue hash below.

Importing Comm Lease data from the database

If the subject property data was entered in web, users can populate the following commercial lease data.

Click the Populate Comm Lease Data from DB button in the left-hand menu.

The following fields can be populated from web:

1. Tenant/Lessee
2. Suite
3. Space Type
4. SF
5. Lease Date Start
6. Lease Date End
7. Lease Type
8. Monthly Contract Rent

If a field has not been filled out in web, the user can hand-enter or correct the data in the Rent Roll table.

Note:

It is imperative that the user fills out the Occupied and Vacant units columns.

Export Commercial Lease Data back to the web

There is not a limit to how many tenants can be exported to the web, so long as they have the correct N1DB range names associated. Use the 46.02.1 and above version of template to automatically create the range names. The following default fields can be exported to the web:

1. Lessee
2. Suite
3. Space Type
4. Size/SF
5. Lease Start Date
6. Lease Expire Date
7. Lease Term
8. Lease Type
9. Eff.$/Mo.
10. Eff.$/Year
11. Eff.$/SF (The range name, N1DBComm_*_Eff._Rent\SF, must be available for the Rent Roll Export to work)
12. Eff.$/SF/Mo.

All available Comm Lease fields:

Once the Rent Roll has been completed, choose the most predominant Lease Type. A list of definitions is provided below the dropdown.

Unit Lease Rent Roll

The Type of Unit Lease is configurable. The dropdown will attempt to pre-populate dependent upon the Property Major Type in the File info worksheet. This value can be overwritten to match the report's needs.

Populating the Unit Lease Rent Roll Table

Unit Lease Market Rents

Unit lease market rent data is pulled from the Multi-Family Lease Comparison tables. Unhide the rows under the type of unit lease dropdown to overwrite available unit types and market rent.

Entering data in the Rent Roll table will populate all of the subsequent tables, such as Market Rent Summary and Occupancy. Use the Data Entry Indicators button to determine hand-entered fields, formatted in blue hash below. 

Click the Toggle Display button to format the Rent Roll and all subsequent tables.

Importing Unit Lease data from the database

If the subject property data was entered in web, users can populate the following unit lease data.

Click the Populate Unit Lease Data from DB button in the left-hand menu.

The following fields can be populated from web:

1. Unit Type
2. Floor
3. Category
4. Total Units
5. Vacant Units
6. SF
7. Monthly Contract Rent
8. Monthly Market Rent

If a field has not been filled out in web, the user can hand-enter or correct the data in the Rent Roll table.

There is not a limit on how many unit types can be exported to the web, so long as they have the correct N1DB range names associated. Use the 46.02.1 and above version of template to automatically create the range names. The following fields can be exported to the web:

1. Unit Description
2. Floor
3. No. of Units
4. Vacant Units
5. Rent/Mo.
6. Rent/Year.
7. Rent/SF/Mo.
8. Market Rent/Mo.
9. Market Rent/SF

All available Unit Lease fields: