Narrative1's Commercial Lease page allows you to automatically calculate a parcels summarized $ per SF in a monthly and yearly range based upon the effective rent of each parcel's individual tenants and lessees.
The page also allows you to view a parcel's tenant or lessee information, displaying the unit's size alongside the effective price per square foot in a monthly and yearly projection.
A parcel's Rent Summary is, by default, generated automatically based upon the tenant and lessee entries within Rent Detail.
|The lowest tenant/lessee $/SF yearly value and the largest in a parcel.|
|The lowest tenant/lessee $/SF/Mo. value and the largest in a parcel.|
|The smallest tenant/lessee square footage value and the largest in a parcel.|
By default, a user cannot edit these field; toggle Override Rent Detail to unlock the fields to allow manual text entry. To revert back to locked, auto-calculating fields, click Refresh Rent Summary.
The Confidential toggle indicates that the information on this page is sensitive and should be viewed by appropriate personnel only. Flagging a parcel as Confidential does not impact it anywhere beyond this page.
To add a new tenant:
Click Add New; a blank row will appear within Rent Detail
Enter the Tenant/Lessee Name, Size (Square Footage), and either the Effective $/SF (Yearly) or Effective. $/SF/Mo; typing into either of these fields will cause the other to populate.
Note: When creating a new Tenant/Lessee, ensure a name is always entered. Forgetting to do so will prevent data from syncing with your Appraisal.xlsm file.
To delete a tenant:
Toggle the checkbox beside the desired tenant(s)
Click Delete Selected
For dollar amount values, you may enter a value with a maximum of four decimals places (i.e. $12.2011).
Modifying the Rent Detail
It is possible to customize the view of the Rent Detail table by reordering or hiding columns, or by clicking upon a column to sort by that column's value in alphabetical or reverse-alphabetical order.
Note: Any modification's made here will affect the default user settings for all users within your organization's database.
To reorder a column, simply click and drag a column to a new position in the header row. This action can also be completed by accessing the Columns Chooser interface.
To sort alphabetically by a column, simply click on a desired column; click again to reverse the effect.
Columns Chooser will allow you to show or hide certain columns within the Rent Detail table.
In the Select Columns window, labels in the leftmost column are currently active within Rent Detail. To hide a column, double-click it's label in the left-most column. To make it reappear, double-click it's label in the right-most column. Add All will display all columns, and Remove All will hide all columns.
Note: You must double-click a value for it to be shown or hidden.
Exporting to Excel
Tenant data within the Commercial Lease page is accessible within the Lease Grid.