REPORTS (Commercial)

Reports Section

Keyboard shortcut: Ctrl + Alt + O

When a rDCF report is generated, the report opens as a fully functioning Excel model (viewable and printable within Excel). Benefits of generating reports in Excel include:

• Formulas used for calculations are included within the models, facilitating auditability thereof and removing the black box “Where did this number come from?” issue that is prevalent with other software applications.
• Enhanced formatting for cleaner looking reports, and the ability for the user to change formatting as desired.
• The ability to perform additional, user-defined analysis directly in the report. Because the report renders in Excel, any Excel spreadsheet functionality is available at the fingertips of the user.

Article contents:

• rDCF Reports, Excel, & Downloads
• Property Reports
• Tenant Reports
• Recovery Reports

rDCF Reports, Excel, & Downloads

Note: rDCF interacts with the version of Excel installed on the user’s computer. In some cases, enhanced Excel security settings may be enabled that will require the user to click the “Enable Editing” button for the report to render properly. If the “Enable Editing” button is not clicked within Excel when the report renders, formatting and or data presentation may be insufficient. Therefore, click the “Enable Editing” button whenever a report renders if so required by the security settings in your version of Excel.

Recommendation: When a rDCF report renders in Excel, the report is automatically saved within the “Downloads” folder on your computer (or another folder if the user has adjusted their web browser settings) with a default name of "<PropertyCode><ReportName><DateGenerated><TimeGenerated>". As the quantity of reports generated from within rDCF increases, the number of reports in your “Downloads” folder will likewise increase. Therefore, it is recommended that you periodically clear your “Downloads” folder to prevent the amount of data storage on your computer from becoming unnecessarily large.

Alert: A property is required to be calculated prior to generating a report.

If the property is uncalculated, the ability to run a report will be disabled. The "Run Report" button that appears when the property is calculated will change to the following:

Click the "Calculate" button in the Header Menu or press Ctrl + Alt + C to calculate the property, after which time the "Run Report" button will be enabled.

When the property is calculated, perform the following procedures to generate a report:

1. Select the report to be generated from the report list in the left-side panel; the settings for that report will appear in the right-side panel.
2. Enter the desired report settings in the right-side panel.
3. Click the "Run Report" button to generate the report.

Note: Every report will contain two tabs labeled "Run Time Parameters" and "Validation Warnings." The "Run Time Parameters" tab will display (i) the date and time the report was generated; (ii) the date and time the property was last calculated; (iii) the date and time the property was last updated; and (iv) the settings that were selected to generate the report. The "Validation Warnings" tab will summarize any input validation warnings that existed when the report was generated.

Reports are categorized into three groupings:

• Property Reports
• Tenant Reports
• Recovery Reports

Note: For organizations with Asset Management functionality, there is an additional category of reports entitled "Property Comparison" consisting of four reports: (i) Cash Flow Comparison; (ii) Market Comparison; (iii) Tenant Detail Comparison; and (iv) Tenant Roster Comparison. These reports compare two rDCF files for the same property against each other to highlight the differences between the files.

Property Reports

Property reports display information and/or calculations for the property as a whole, as opposed to tenant-by-tenant detail.

• Property Cash Flow
• Contractual Tenant Revenue
• Expiration
• Input Assumptions
• Market Lease Values
• Occupancy
• Occupancy by Area Measure
• Rent Roll
• Roll Over
• Vacancy & Credit Loss Audit
• Valuation

Property Cash Flow

Purpose: 

To present the projected revenues, expenses and capital expenditures for a property over a specified term in order to calculate net operating income and net cash flow.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Periodicity: Defines the time periods to be displayed on the report. Choices are “Annual”, “Monthly” or “Quarterly.”

Report Style:

• Potential Breakout: Displays Potential Revenue and Loss From Absorption & Downtime for all revenue sources (Base Rent, Recoveries, Miscellaneous Tenant Revenue and Percentage Rent).
• Recovery Detail: Displays Recovery revenue on multiple line items by Report Tag, or if no tag is used, by recovery pool name.
• Simple: The default and presents the standard method of displaying the property cash flow (only Potential Revenue and Loss From Absorption & Downtime for Base Rent is broken out).

Line Item Display:

• As Entered: Displays Line Items as entered in the Line Items section. All Line Items for which the "Cash Flow?" box has been checked will appear individually on the report.
• Cash Flow Grouping: Displays Line Items in an aggregate fashion based upon the Line Item Type (i.e., Misc. Income, Expense, Expense: Non Recov and Building Capital are each aggregated into one line on the report.

Note: For organizations with Asset Management functionality, there are two additional options for Line Item Display: (i) Detail Account #; and (ii) Summary Account #. These options allow for line items to be displayed based upon the assigned account number from the organization's Chart of Accounts.

Display Account?: Determines whether the Code for Line Items will be displayed. The default is unchecked, whereby only the Line Item Names display on the report. If checked, both the Line Item Codes and Names will display on the report.

Display Annual Totals: Available only if the Report Type is set to “Monthly” or Quarterly”. The default is unchecked, whereby Annual Totals will not be displayed. If checked, an additional column for each year will be included on the report that displays the summation of the monthly or quarterly amounts for such year.

Include Annual Metrics: Available only if the Periodicity is set to "Annual". The default is unchecked, whereby Annual Metrics will not be displayed. If checked, (i) Area statistics (Total Area, Occupied Area & Occupied %) for each year will appear above the cash flows; and (ii) two additional columns will display for each year, one showing the % of Effective Gross Revenue for each cash flow line on the report and one showing the per area value for each cash flow line on the report (the per area amount is determined by dividing the annual amount by the Area Measure "*TotalArea").

Contractual Tenant Revenue

Purpose: 

To break out the tenant revenue for a property as sourced from contractual leases versus speculative leases, on both a dollar and percentage basis.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Periodicity: Defines the time periods to be displayed on the report. Choices are “Annual”, “Monthly” or “Quarterly.”

Display Annual Totals: Available only if the Report Type is set to “Monthly” or Quarterly”. The default is unchecked, whereby Annual Totals will not be displayed. If checked, an additional column for each year will be included on the report that displays the summation of the monthly or quarterly amounts for such year.

Expiration

Purpose: 

To provide detail and summary lease expiration statistics on a year-by-year basis for all tenants within a property.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Lease Terms:

• Base Tenants: Includes expirations for base lease records on rent roll, exclusive of options or speculative renewals.
• Base Tenant or Last Option: Includes expirations for base lease records on rent roll (except for tenants with options), exclusive of speculative renewals. For options, only the expiration of the final option record is included (expirations of the base lease record and any prior options are excluded).
• Base Tenants and Options: Includes expirations for base lease records on rent roll, exclusive of speculative renewals. For options, expirations for both the base lease term and all option terms are included.
• All Terms (default setting): Includes expirations for base lease records on rent roll, all options and all speculative renewals.

Input Assumptions

Purpose:

To provide a summary of all assumptions input into rDCF for a property. This report may be used (i) as an audit tool to verify that data input is correct; and (ii) to review property files received from third parties to gain an understanding of the assumptions contained therein.

Settings:

Object Type: Select those data entry categories to be included on the report by checking the applicable box. The default setting is all categories (all boxes are checked). Clicking on a category name will either select (box is checked) or deselect (box is unchecked) such category for inclusion on the report. If all of the categories are selected, clicking the “Deselect All” button will uncheck all boxes. If at least one category is unchecked, the “Deselect All” button will change to “Select All”, which if clicked will result in all boxes being checked.

Alert: At least one category must be selected for the report to run.

Market Lease Values

Purpose:

To display a time series of values for various market lease assumptions (Renewal Probability, Rent, Free Rent, Tenant Improvements, Lease Commissions, Other Capital, and Downtime) on a new, renew, and weighted basis.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Market Lease: Select those market leases to be included on the report (the default is all market leases).

• Check the boxes to include specific market leases on the report.
• Uncheck the boxes to exclude specific market leases from the report. 
• Select all Market Leases by checking the box to the left of the "Code" header.
• Deselect all Market Leases by unchecking the box to the left of the "Code" header.
• To sort the list alphabetically in ascending order, click the double arrows (the double arrow icon will change to a single arrow pointing downward); to re-sort the list alphabetically in descending order, click the single arrow pointing downward (the single arrow pointing downward icon will change to a single arrow pointing upward).

Alert: At least one market lease must be selected for the reports to run.

Occupancy

Purpose:

To display occupancy statistics for a property on a monthly and annual basis, by both area and percentage occupied.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above..

Display Monthly %: Select whether monthly occupancy percentages should be displayed on the report (annual occupancy percentage is always displayed). The default is to display monthly occupancy percentages (box is checked). Uncheck the box if monthly occupancy should only display area measures and exclude percentages.

Occupancy by Area Measure

Purpose:

To display occupancy statistics for a property on a monthly and annual basis, by both area and percentage occupied, for tenant based Area Measures (i.e., those based upon Lease Types or Tenant Groups).

Note: This report is unavailable if there are no tenant based Area Measures.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Display Monthly %: Select whether monthly occupancy percentages should be displayed on the report (annual occupancy percentage is always displayed). The default is to display monthly occupancy percentages (box is checked). Uncheck the box if monthly occupancy should only display area measures and exclude percentages.

Area Measures: Select the tenant based area measures (i.e., those based upon Lease Types or Tenant Groups) to be included on the report (the default is all such area measures).

• Check the boxes to include specific area measures on the report.
• Uncheck the boxes to exclude specific area measures from the report. 
• Select all Area Measures by checking the box to the left of the "Code" header.
• Deselect all Area Measures by unchecking the box to the left of the "Code" header.
• To sort the list alphabetically in ascending order, click the double arrows (the double arrow icon will change to a single arrow pointing downward); to re-sort the list alphabetically in descending order, click the single arrow pointing downward (the single arrow pointing downward icon will change to a single arrow pointing upward).

Note:  The Occupancy by Area Measure report includes the square footage of all rent roll records assigned to the selected Lease Type(s) or Tenant Group(s) regardless as to whether such records have a Lease Type(s) that affects occupancy.

Rent Roll

Purpose:

To display summary information for all lease records within a property (including Tenant Name, Suite Number, Lease Begin and End Dates, Area, Base Rent and Abatements, Recovery Summary, Tenant Capital Summary, Renewal Type (i.e., Weighted, Option, None, etc.) and Market Lease assigned.

Settings:

Display All Base Rent: If checked, displays all base rent (including historical base rent prior to the Analysis Begin date) as entered on the Rent Roll tab.

Display Notes: If checked, displays all notes directly below the tenant record to which the note relates.

Base Rent Display Date: Reflects the initial date that base rent will be displayed on the report. Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date. This option is disabled when the "Display All Base Rent" checkbox is checked.

Roll Over

Purpose:

To compare gross rent for a lease record upon expiration to the gross rent at the commencement of the subsequent lease (the “rollover lease”), with a summary of the increase/decrease in gross rentals between lease records. This report is useful in determining whether existing leases are above or below market assumptions.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Tenant Inclusion:

• All Roll Over (default setting): Includes the roll over for all lease records, options and speculative renewals.
• Base Tenant: Includes the roll over for only base lease records, regardless of whether they roll to option or speculative renewal.
• Roll to Option: Includes the roll over for only lease records that roll to option (i.e., status of Option upon expiration). This may include the first option for a tenant rolling to a second option.
• Roll to Market: Includes the roll over for only lease records that roll to market (i.e., status of Weighted upon expiration).

Vacancy & Credit Loss Audit

Purpose:

To provide details behind the calculation of the Vacancy Loss and/or Credit Loss for a property.

Settings:

Start Date: Regardless of whether the calculation is done on an annual or monthly basis (as determined by the entry in the "Loss Factor Calculation" field on the Property Settings tab in the Property section), this field presents a series of 12-month periods that may be used as the start date for the report. The beginning month for such 12-month period is based upon the entry in the “Loss Factor Effective Month” field (also on the Property Settings tab in the Property section).

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Note: When the Loss Factor Calculation on the Property Settings tab is set to "Monthly", this report will display the monthly calculations; when set to "Annual", this report will display the annual calculations.

Valuation

Purpose:

To provide (i) property valuation calculation and valuation matrix for one or multiple Valuation Scenarios; and (ii) provide a summary of the cash flows used for the valuation and the calculation of the stabilization adjustment for the reversion vacancy loss (if applicable).

Settings:

Valuation Scenario: Select the Valuation Scenario(s) to be included on the report. The default setting is the Default Valuation Scenario as defined on the Valuation Settings tab in the Property section. Clicking on a scenario #/name will either select (box is checked) or deselect (box is unchecked) such scenario for inclusion on the report. If multiple boxes are checked, each scenario will appear on a separate tab in the report. If at lease one Valuation Scenario is selected, clicking the "Deselect All" button will uncheck all boxes. If all Valuation Scenario buttons are unchecked, the "Deselect All" button will change to "Select All", which if clicked will result in all boxes being checked.

Tenant Reports

Tenant reports display information and/or calculations for a specific tenant and/or tenants rather than for the building as a whole.

• Tenant Cash Flow
• Current Revenue vs. Market
• Full Tenant Detail
• Tenant Percent Rent Audit
• Tenant Roster
• Weighted Average Lease Term

Tenant Cash Flow

Purpose:

To present the projected revenues received and capital incurred for the leasing of space to a tenant(s) within the property.

Note: If there is additional leasing associated with a lease record subsequent to the lease End Date (i.e., Renewal Type on the Rent Roll of “Weighted”, “Renew” or “Vacate”), the cash flow for all subsequent leasing within the report term will appear on the report.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Periodicity: Defines the time periods to be displayed on the report. Choices are “Annual”, “Monthly” or “Quarterly”.

Report Style:

• Simple: The default and presents the standard method of displaying the tenant cash flow (only Potential Revenue and Loss From Absorption & Downtime for Base Rent is broken out).
• Potential Breakout: Displays Potential Revenue and Loss From Absorption & Downtime for all revenue sources (Base Rent, Recoveries, Miscellaneous Tenant Revenue and Percentage Rent).
• Recovery Detail: Displays Recovery revenue on multiple line items by Report Tag, or if no tag is used, by recovery pool name.

Display Annual Totals: Available only if the Report Type is set to “Monthly” or Quarterly”. The default is unchecked, whereby Annual Totals will not be displayed. If checked, an additional column for each year will be included on the report that displays the summation of the monthly or quarterly amounts for such year.

Tenants: Select the tenants to be included on the report (the default is all tenants). The list populates with every tenant record, including option records, entered on the Rent Roll.

• Check the boxes to include specific tenant records on the report.
• Uncheck the boxes to exclude specific tenant records from the report. 
• Select all Tenants by checking the box to the left of the "Sort Order" header.
• Deselect all Tenants by unchecking the box to the left of the "Sort Order" header.
• To sort the list in ascending order, click the double arrows (the double arrow icon will change to a single arrow pointing downward) for the column to be sorted; to re-sort the list in descending order, click the single arrow pointing downward (the single arrow pointing downward icon will change to a single arrow pointing upward) for the column to be re-sorted.

Note: If more than one tenant is selected, each tenant will appear on a separate tab within the Excel workbook.

Current Revenue vs. Market

Purpose:

To compare gross rent for a lease record at any date with the gross market rent for that lease at the same point in time, with a summary of the $/sf and % by which such lease record is above or below market. This report is useful in determining whether lease records are above or below market assumptions at any defined point in time, with a summary of the gross $/sf and % by which such lease record is above or below market.

The report is broken into two sections:

• Current Contractual Leases - Contractual leases for which the Lease Begin Date is equal or prior to the report Start Date.
• Future and Speculative Leases - All speculative leases and contractual leases for which the Lease Begin Date is subsequent to the report Start Date.

Settings:

Start Date: Represents that point in time for which the comparison of gross rent for a lease record is to be compared to gross market rent. Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Full Tenant Detail

Purpose:

To present the calculated results related to occupancy, revenues, tenant capital and sales on a tenant-by-tenant basis. This report may be used to determine the composition of line items on the Cash Flow report by tenant. Data is presented for both the base lease term and for market leases subsequent to the base lese term.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Periodicity: Defines the time periods to be displayed on the report. Choices are “Annual”, “Monthly” or “Quarterly”.

Display Annual Totals: Available only if the Report Type is set to “Monthly” or Quarterly”. The default is unchecked, whereby Annual Totals will not be displayed. If checked, an additional column for each year will be included on the report that displays the summation of the monthly or quarterly amounts for such year.

Amount Type:

• Amount: The default and displays the selected tenant detail items as full amounts rather than on a per area basis.
• Per Area: Displays the selected tenant detail items on a per area basis by dividing the amount by the tenant area leased.

Tenants: Select the tenants to be included on the report (the default is all tenants). The list populates with every tenant record, including option records, entered on the Rent Roll.

• Check the boxes to include specific tenant records on the report.
• Uncheck the boxes to exclude specific tenant records from the report. 
• Select all Tenants by checking the box to the left of the "Sort Order" header.
• Deselect all Tenants by unchecking the box to the left of the "Sort Order" header.
• To sort the list in ascending order, click the double arrows (the double arrow icon will change to a single arrow pointing downward) for the column to be sorted; to re-sort the list in descending order, click the single arrow pointing downward (the single arrow pointing downward icon will change to a single arrow pointing upward) for the column to be re-sorted.

Alert: At least one tenant must be selected for the report to run.

Tenant Detail Types: Select those Tenant Detail Types to be included on the report by checking the applicable box. The default setting includes the most commonly reviewed Tenant Detail Types (i.e., Occupied Area, Scheduled Base Rent, Scheduled Recoveries, Scheduled Percentage Rent, Tenant Improvement and Leasing Commissions). Clicking on a Tenant Detail Type will either select (box is checked) or deselect (box is unchecked) such type for inclusion on the report. If multiple boxes are checked, each Tenant Detail Type will appear on a separate tab in the report. If all of the types are selected, clicking the “Deselect All” button will uncheck all boxes. If at least one type is unchecked, the “Deselect All” button will change to “Select All”, which if clicked will result in all boxes being checked.

Alert: At least one Tenant Detail Type must be selected for the report to run.

Helpful Hint: Tenant Detail Types related to tenant revenue may be run on either a “Potential” or “Scheduled” basis. Additionally, base rent and recoveries may be run on a “Market” basis. The difference between these selections is as follows:

“Potential” revenue includes:

• Revenue for base lease records on the Rent Roll (i.e., tenants for which a Begin Date and End Date have been entered on the Rent Roll) at the specific terms entered on the Rent Roll with no reductions for free rent (i.e., revenue prior to free rent);
• Revenue for market leases (i.e., those leases subsequent to the base lease record entered on the Rent Roll with a Renewal Type of either “Weighted”, “Renew” or “Vacate”) at market terms with no reduction for free rent; &
• Revenue for periods of vacancy either prior to initial lease up or between leases at market terms with no reductions for free rent.

“Scheduled” revenue includes:

• Revenue for base lease records on the Rent Roll (i.e., tenants for which a Begin Date and End Date have been entered on the Rent Roll) at the specific terms entered on the Rent Roll as reduced by free rent;
• Revenue for market leases (i.e., those leases subsequent to the base lease record entered on the Rent Roll with a Renewal Type of either “Weighted”, “Renew” or “Vacate”) at market terms as reduced by market free rent.

No revenue is assigned to periods of vacancy.

“Market” revenue is calculated on a year-by-year basis (i.e., the calculation re-sets every year) and reflects revenue using the assumptions associated with the market lease attached to the lease record as per the “Market Lease” column on the Rent Roll.

Potential, Scheduled and Market calculations for a lease record:

• Commence on the Analysis Begin date unless an “Available Date” has been entered on the Rent Roll, in which case the calculations commence on the Available Date.
• End at the expiration of the Analysis Term, unless a Renewal Type of “None” has been selected on the Rent Roll, in which case the calculations end on the lease record End Date.

Tenant Percent Rent Audit

Purpose:

To provide details behind the calculation of percentage rent on a tenant-by-tenant basis.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Include Renewals: Default is unchecked, whereby the detail of percentage rent calculations will only be provided for base lease records entered on the Rent Roll. If the box is checked, percentage rent calculation details will also be provided for market leases occurring subsequent to the end date of the base lease record.

Tenants: Select the tenants to be included on the report (the default is all tenants). The list populates with every tenant record, including option records, entered on the Rent Roll.

• Check the boxes to include specific tenant records on the report.
• Uncheck the boxes to exclude specific tenant records from the report. 
• Select all Tenants by checking the box to the left of the "Sort Order" header.
• Deselect all Tenants by unchecking the box to the left of the "Sort Order" header.
• To sort the list in ascending order, click the double arrows (the double arrow icon will change to a single arrow pointing downward) for the column to be sorted; to re-sort the list in descending order, click the single arrow pointing downward (the single arrow pointing downward icon will change to a single arrow pointing upward) for the column to be re-sorted.

Note: If more than one tenant is selected, each tenant will appear on a separate tab within the Excel workbook.

Alert: At least one tenant must be selected for the report to run.

Tenant Roster

Purpose:

To see a listing of all tenant lease records on the Rent Roll for a property, including Suite, Tenant Name, Version (Initial or Option), Status (Contractual or Speculative), Lease Type, Start and End Dates, Area and % of Property NRA.

Settings:

Sort Order: Determines how records are sorted on the report. Options include:

• Rent Roll - Records are sorted in the same way they appear on the Rent Roll screen
• Tenant Name - Records are sorted alphabetically by tenant name
• End Date - Records are sorted chronologically by Lease End Date, starting with the most recent expirations
• Area - Records are sorted by square footage, largest to smallest

Note: If a tenant lease record has a Lease Type that is defined to not affect occupancy, that record will appear on the report but will not display any Area.

Weighted Average Lease Term

Purpose:

To calculate (i) the remaining lease term for each tenant with a Status of "Contractual" from a user-specified date; & (ii) the weighted average remaining lease term for all tenants with a Status of "Contractual" from a user-specified date, calculated using a denominator of both (a) the aggregate area of included tenants only; and (b) the net rentable area of the building.

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Recovery Reports

Recovery reports display the composition of recovery pools and the details behind recovery calculations on a tenant-by-tenant basis.

• Percent Reimbursed
• Recovery Pool Audit
• Rent Roll Recovery Input
• Tenant Recovery Audit
• Tenant Recovery Detail

Percent Reimbursed

Purpose:

To display (i) the recoveries per leased square foot paid by each tenant; (ii) the total recoverable expenses per square foot for the building (based upon the Area Measure "*Total Area"); (iii) the percent of recoveries per leased square foot paid by each tenant divided by the total recoverable expenses per square foot for the building (this reflects the percent of recoverable building expenses being paid by each tenant on a per square foot basis); and (iv) the percent of recoveries per square foot paid by all tenants in the aggregate divided by the total recoverable expenses per square foot for the building (this reflects the percent of recoverable expenses actually recovered).

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Recovery Pool Audit

Purpose:

To provide details on the composition of each recovery pool for a property (percent of expenses included, gross-ups, administrative fees, capped vs. uncapped components of the pool and tenant contribution reductions to the pool).

Settings:

Because the calculation is done on an annual basis, the Start Date field presents a series of 12-month periods that may be used as the start date for the report. The beginning month for such 12-month period is based upon the entry in the “Recovery Effective Month” field on the Property Settings tab in the Property section.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Recovery Pools: Select the Recovery Pools to be included on the report (the default is all recovery pools).

• Check the boxes to include specific recovery pools on the report.
• Uncheck the boxes to exclude specific recovery pools from the report. 
• Select all Recovery Pools by checking the box to the left of the "Code" header.
• Deselect all Recovery Pools by unchecking the box to the left of the "Code" header.
• To sort the list alphabetically in ascending order, click the double arrows (the double arrow icon will change to a single arrow pointing downward); to re-sort the list alphabetically in descending order, click the single arrow pointing downward (the single arrow pointing downward icon will change to a single arrow pointing upward).

Note: If more than one recovery pool is selected, each recovery pool will appear on a separate tab within the Excel workbook.

Alert: At least one recovery pool must be selected for the report to run.

Rent Roll Recovery Input

Purpose:

To provide details of recovery input for all tenants on the Rent Roll. This report may be used (i) as an audit tool to verify that tenant recovery data has been input correctly; and (ii) to review properties received from third parties to gain an understanding of the recovery mechanics for that property.

Settings:

There are no settings for this report.

Tenant Recovery Audit

Purpose:

To provide details behind the calculation of expense recoveries on a tenant-by-tenant basis.

Settings:

Because the calculation is done on an annual basis, the Start Date field presents a series of 12-month periods that may be used as the start date for the report. The beginning month for such 12-month period is based upon the entry in the “Recovery Effective Month” field on the Property Settings tab in the Property section.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Include Renewals: Default is unchecked, whereby the detail of expense recovery calculations will only be provided for base lease records entered on the Rent Roll. If the box is checked, expense recovery calculation details will also be provided for market leases occurring subsequent to the end date of the base lease record.

Tenants: Select the tenants to be included on the report (the default is all tenants). The list populates with every tenant record, including option records, entered on the Rent Roll.

• Check the boxes to include specific tenant records on the report.
• Uncheck the boxes to exclude specific tenant records from the report. 
• Select all Tenants by checking the box to the left of the "Sort Order" header.
• Deselect all Tenants by unchecking the box to the left of the "Sort Order" header.
• To sort the list in ascending order, click the double arrows (the double arrow icon will change to a single arrow pointing downward) for the column to be sorted; to re-sort the list in descending order, click the single arrow pointing downward (the single arrow pointing downward icon will change to a single arrow pointing upward) for the column to be re-sorted.

Note: If more than one tenant is selected, each tenant will appear on a separate tab within the Excel workbook.

Alert: At least one tenant must be selected for the report to run.

Tenant Recovery Detail

Purpose:

To provide details of recovery amounts contributed by each tenant per Report Tag. If a Report Tag has not been assigned to a recovery, then Recovery Pool Name (Pro-rata recovery Type) or Recovery Name (Amt or Detailed Amt recovery Type) will be used to categorize recovery amounts contributed by tenant.

Tip: This report may be used to obtain detail for recovery amounts on the Cash Flow report with a Report Style of "Recovery Detail."

Settings:

Start Date: Defaults to the Report Begin date as entered on the Property Settings tab in the Property section. Default date may be changed but may not be earlier than the Analysis Begin date.

Term: Reflects the desired number of years for the report. Defaults to the lesser of (i) the maximum Term based upon the Analysis Begin, Report Begin, and Term as entered on the Property Settings tab in the Property section plus 1 year; or (ii) 11 years. The default term may be changed but may not exceed the maximum Term per (i) above.

Periodicity: Defines the time periods to be displayed on the report. Choices are “Annual”, “Monthly” or “Quarterly”.

Include Annual Totals: Available only if the Report Type is set to “Monthly” or Quarterly”. The default is unchecked, whereby Annual Totals will not be displayed. If checked, an additional column for each year will be included on the report that displays the summation of the monthly or quarterly amounts for such year.