Formulas and Data Identification
The variables in a formula represent data to be plugged into the formula. The exact format varies depending on the type of formula you're creating. For example, if you're using variables from a client statement, the format differs from the format you would use for a report's financial calculation.
Each variable consists of a two-letter code representing the general location of the data plus a number representing the line number of the data. The two-letter code is a combination of report name, financial data type, and/or financial period, or simply a report name.
Data can come from the locations listed in the following table's Location of Data column.
For further explanation of the codes in this table, see the appropriate section after this table.
|
Location of Data |
Wildcard Value |
Historical Data Type |
Budgeted Data Type |
Currency Data Type |
Financial Period |
Line Number |
|
Client statement |
A |
D |
G |
J |
A to Z |
1 to 300 |
|
Standard report |
B |
E |
H |
K |
||
|
Cash flow report |
C |
F |
I |
L |
||
|
Covenant additional data line values |
Z |
W |
X |
Y |
A to Z |
1 to 300 |
Client Statement Variables
For variables coming from the client statement, the first letter represents the data type of the appropriate period or, if Statement Analyzer doesn't need to know the data type, the standard wildcard value A.
|
Wildcard Value (If Data Type is Insignificant) |
Historical Data Type |
Budgeted Data Type |
Currency Data Type |
|
|
First Letter |
A |
D |
G |
J |
|
Current Period |
One Period Prior to Current |
Two Periods Prior to Current |
And So On... |
|
|
Second Letter |
A |
B |
C |
D, E, F, ... |
The number represents the account line number (1 to 300).
Here are some examples:
-
AA145: Use the value entered for the current period (which can be any type) on line 145.
-
AB10: Use the value entered for the period (which can be any type) one prior to the current period, on line 10.
-
GA130: Use the value entered for the current period of type Budgeted, on line 130.
-
JB289: Use the value entered for the Currency period one prior to the current period, on line 289.
Standard Report Variables
The first letter represents the data type of the appropriate period or, if Statement Analyzer doesn’t need to know the data type, the standard wildcard value B.
|
Location of Data |
Wildcard Value |
Historical Data Type |
Budgeted Data Type |
Currency Data Type |
|
Standard report |
B |
E |
H |
K |
The second letter represents the period.
|
Location of Data |
Current Period |
One Period Prior to Current |
Two Periods Prior to Current |
And So On... |
|
Second Letter |
A |
B |
C |
D, E, F, ... |
The number represents the expression line number from the expression list for the industry in which this client’s data is spread.
Examples:
|
BA7 |
Perform financial calculation #7 on the current period, regardless of the period’s data type. |
|
KB12 |
Perform financial calculation #12 on the Currency period one period prior to the current period. |
|
HA1 |
Perform financial calculation #1 on the current Budgeted period. |
|
BB1001 |
Perform financial-institution defined calculation 1001 on the prior period, regardless of the period’s data type. |
Cash Flow Report Variables
Variables can come from any line of the primary cash flow report for a particular industry. These variables are structured in much the same way as variables from a historical spreadsheet.
The first letter represents the data type of the appropriate period or if Statement Analyzer doesn’t need to know the data type, the standard wildcard value C.
|
Location of Data |
Wildcard Value |
Historical Data Type |
Budgeted Data Type |
Currency Data Type |
|
Standard report |
C |
F |
I |
L |
The second letter represents the period.
|
Location of Data |
Current Period |
One Period Prior to Current |
Two Periods Prior to Current |
And So On... |
|
Second Letter |
A |
B |
C |
D, E, F, ... |
The number represents the line number from the cash flow report.
Note: All lines of the report are counted, including blank lines and underscore lines.
|
CA30 |
Perform the calculation for Cash Flow item 30 on the current period, regardless of the period’s data type. |
|
FA35 |
Perform the calculation for Cash Flow item 35 on the current Historical period. |
|
CB10 |
Perform the calculation for Cash Flow item 10 on the period (regardless of the data type) one prior to the current period. |
Covenant Additional Data Line Values Variables
Covenant expression formulas can use additional data line values, which are predefined values in a sequentially numbered list (the first additional data line value is number 1).
References to an additional data line value in a formula are constructed in much the same way as variables from a client statement.
The first letter represents the data type of the appropriate period or, if Statement Analyzer doesn't need to know the data type, the standard wildcard value Z.
|
Wildcard Value (If Data Type is Insignificant) |
Historical Data Type |
Budgeted Data Type |
Currency Data Type |
|
|
First Letter |
Z |
W |
X |
Y |
The second letter represents the period.
|
Current Period |
One Period Prior to Current |
Two Periods Prior to Current |
And So On... |
|
|
Second Letter |
A |
B |
C |
D, E, F, ... |
Z numbers 1- 25 are reserved for Statement Analyzer-defined additional data line values. Z numbers 26 - 100 are reserved for financial institution-defined additional data line values. Additional data lines defined on a covenant statement for a client start at the Z number 101.
Here are some examples:
-
ZA1: Use Z value 1 on the current period, regardless of the period's data type.
-
XB4: Use Z value 4 on the Budgeted period one prior to the current period.