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 |