About Statement Options

See Also...   

Overview

You can access the Edit Statement Options dialog box to set the cursor movement options and to set the grace period for statements. The default settings are defined by your system administrator and apply globally across the system. However, you can overwrite these settings for a specific client by accessing the dialog box from the client statement screen.

If you're licensed to use CRE, you can also set certain CRE options here.

Field Details

The following table provides information regarding the fields in both the system-wide Edit Statement Options dialog box and the client-specific Edit Statement Options dialog box.

Note: You can change settings in the Edit Statement Options dialog box only.

Field Name

Required Field?

Description

Statement Options

Cursor Movement

No

Direction the cursor is set to move in the data grid when the Enter key is pressed. Valid values are provided in a drop-down list.

Pressing the Enter key completes your entry to a cell (what you type in the white entry box); how it moves you around in the spreadsheet depends on your setup in this dialog box.

Note: Your selection in the Cursor Movement dialog box affects you, the logged-in user, only (no other users) and only when you are in this client's spreadsheet. The default movement of the Enter key is defined in your system setup; please see your system administrator if you have questions.

  • Right: Moves you one cell to the right.

  • None: Keeps you in the current cell (does not move you to another cell).

  • Up: Moves you one cell up.

  • Down: Moves you one cell down.

  • Left: Moves you one cell to the left.

Subtotal Detail Lines

Yes

Indicates if detail lines will be subtotaled and displayed. If the check box is selected, the detail lines will be subtotaled and displayed. If the check box is not  selected, the detail lines will not be subtotaled.

Exchange Rates are Multipliers

Yes

Indicates if currency is to be multiplied by the exchange rate when converting currency. If the check box is selected, currency is to be multiplied by the exchange rate. If the check box is not selected, currency is to be divided by the exchange rate.

Default Industry

No

Default industry used when a new statement is added. Valid values are provided in a drop-down list.

Default Currency

Yes

Default currency used when a statement is set up. Valid values are provided in a drop-down list.

Default Statement Unit

Yes

Default unit of measure used when a statement is set up. Valid values are provided in a drop-down list.

Unlock Statement After [number of] Minutes

Yes

Number of minutes after which the system will unlock the statement. The minimum value for this field is 60 minutes and the maximum value is 1,440 minutes (24 hours).

Once the minute setting has been reached for a locked statement, the statement is unlocked and all unsaved changes that have been made to the statement are lost.

Create Projection with [number of] Projected Periods

Yes

Number of projected periods to assign when creating a projection.

Statement Grace Periods

Grace Period for Annual Statement

No

The basic functionality for these fields is the same: you set the number of months or days that will constitute the grace period for these statements. These values will apply to all annual, quarterly, or monthly statements unless overwritten at the client statement level.

Grace Period for Monthly Statement

No

Grace Period for Quarterly Statement

No

Commercial Real Estate Economic Valuation Report

Vacancy Sensitivity

Yes

The vacancy rate that will be used to forecast the property’s profitability.

The default is 10%.

You can change this rate for a client on the corresponding historical statement line (line 234).

The default is 10%.

Interest Rate Sensitivity

Yes

The degree of change in the price of a property in response to the fluctuations in the market interest rates. This interest rate will be used to forecast the specific property’s profitability.

The default is 2%.

You can change this rate for a client on the corresponding historical statement line (line 235).

The default is 2%.

Commercial Real Estate Proforma Report

CAP Rate - Leased Space

Yes

The capitalization rate that is applied to leased units when valuing the property.

Net Operating Income/ Cost = Cap Rate.

The Cap Rate is an indirect measure of how fast an investment will pay for itself.

The default is 10%.

CAP Rate - Vacancies

Yes

The capitalization rate that is applied to the vacant units when valuing the property.

The default is 8%.

Present Value Discount Rate

Yes

The rate used to calculate the present value of the property.

The default is 10%.

Discount Rate

Yes

The interest rate used to find the present value of an amount to be paid or received in the future.

The default is 10%.