34.4 Formula Results Functions
Formula Results Rule has its own unique functions which allows the user to access the various financial elements.
The following table can be used as a quick reference guide for the Formula Results functions.
Table 34-3 List of Formula Results Functions
| Function FE Financial Element | Formula | Use in Cash Flow | Use in Gap | Use in MV |
|---|---|---|---|---|
|
Cash Flow FE |
FE(Leaf, FE, Lag) |
Yes |
Yes |
No |
|
Current Leaf FE |
CLFE (FE, Lag) |
Yes |
Yes |
No |
|
Static FE |
SFE(Leaf,FE) |
No |
No |
Yes |
|
Static Current Leaf FE. |
SCLFE(FE) |
No |
No |
Yes |
|
Cash Flow Coefficient |
K(Coeff, Lag) |
Yes |
No |
No |
|
IRR Gap Coefficient |
IGK(Coeff, Lag) |
No |
Yes |
No |
|
Liq Gap Coefficient |
LGK(Coeff, Lag) |
No |
Yes |
No |
|
Static Coefficient |
SK(Coeff) |
Yes |
Yes |
Yes |
|
Rate |
RT(IRC, Lag, Term, Mult) |
Yes |
No |
No |
|
Days in Bucket |
DAYS(Bucket) |
Yes |
No |
No |
|
Month of the Bucket |
MONTH( ) |
Yes |
No |
No |