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.
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.
|
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%. |