A Functional Activity Code – Glossary
This topic describes the IC formula and condition for the various sweep/pool methods.
IC Formulae
Sweep
Table A-1 Sweep
Header / Child | Condition | Formula |
---|---|---|
Header/Child | ABS(LMVD_DR_BAL)>0 | (ABS(LMVD_DR_BAL) * RATE1*DAYS)/(YEAR*100) |
(LMVD_CR_BAL>0) AND (LMVD_CR_BAL<=10000) | (LMVD_CR_BAL * RATE2*DAYS)/(YEAR*100) | |
(LMVD_CR_BAL>10000) AND (LMVD_CR_BAL<=9999999) | (LMVD_CR_BAL * RATE3*DAYS)/(YEAR*100) |
Pool
Table A-2 Interest Method
Header / Child | Condition | Formula |
---|---|---|
Header | (LMVD_CR_POOLBAL>0) AND (LMVD_CR_POOLBAL<=10000) | (LMVD_CR_POOLBAL * RATE4*DAYS)/(YEAR*100) |
(LMVD_CR_POOLBAL>10000) AND (LMVD_CR_POOLBAL<=9999999) | (LMVD_CR_POOLBAL * RATE5*DAYS)/(YEAR*100) | |
ABS(LMVD_DR_POOLBAL)>0 | (ABS(LMVD_DR_POOLBAL) * RATE6*DAYS)/(YEAR*100) | |
Child | Not Applicable | Not Applicable |
Table A-3 Advantage Method
Header / Child | Condition | Formula |
---|---|---|
Header | LMVD_CR_POOLBAL>0 | (LMVD_CR_POOLBAL * RATE7*DAYS)/(YEAR*100) |
ABS(LMVD_DR_POOLBAL)>0 | (ABS(LMVD_DR_POOLBAL*RATE8*DAYS)/(YEAR*100)) | |
Child | ABS(LMVD_DR_BAL)>0 | (ABS(LMVD_DR_BAL*RATE9*DAYS)/(YEAR*100)) |
(LMVD_CR_BAL>0) AND (LMVD_CR_BAL<=10000) | (LMVD_CR_BAL * RATE10*DAYS)/(YEAR*100) | |
(LMVD_CR_BAL>10000) AND (LMVD_CR_BAL<=9999999) | (LMVD_CR_BAL * RATE11*DAYS)/(YEAR*100) |
Table A-4 Ratio Method
Header/Child | Condition | Formula |
---|---|---|
Header/Child | (LM_NETPOOLPOSITION > 0) AND (VD_DLY_CR_BAL_M > 0) | VD_DLY_CR_BAL_M * ((LM_COVERAGE_RATIO*CRCOVRATE*DAYS) / (YEAR*100)) + (((1-LM_COVERAGE_RATIO) *CRRESRATE*days)/(YEAR*100)) |
(LM_NETPOOLPOSITION > 0) AND (ABS(VD_DLY_DR_BAL_M)>0) | ABS(VD_DLY_DR_BAL_M) * ((1*DRCOVRATE*DAYS)/(YEAR*100)) | |
(LM_NETPOOLPOSITION < 0) AND (VD_DLY_CR_BAL_M > 0) | VD_DLY_CR_BAL_M * ((1*DRCOVRATE*DAYS)/(YEAR*100)) | |
(LM_NETPOOLPOSITION < 0) AND (ABS(VD_DLY_DR_BAL_M)>0) | ABS(VD_DLY_DR_BAL_M) * ((LM_COVERAGE_RATIO*DRCOVRATE*DAYS) / (YEAR*100)) + (((1-LM_COVERAGE_RATIO) *DRRESRATE*days)/(YEAR*100)) |
Table A-5 Interest Optimization Method
Accounts | Condition | Result |
---|---|---|
All Accounts | (LM_IO_STR_BALANCEINTHCCY >= LM_IO_STR_THAMOUNT) AND (LM_IO_STR_BALANCEINACCCY >= LM_IO_STR_THAMOUNTINACCCY) | (VD_DLY_CR_BAL_M*LM_IO_CCYEN_RATE*DAYS)/(YEAR*100) |
(LM_IO_STR_BALANCEINTHCCY >= LM_IO_STR_THAMOUNT) AND (LM_IO_STR_BALANCEINACCCY >= LM_IO_STR_THAMOUNTINACCCY) | (VD_DLY_CR_BAL_M*LM_IO_CCYPR_RATE*DAYS)/(YEAR*100) | |
(LM_IO_STR_BALANCEINTHCCY >= LM_IO_STR_THAMOUNT) AND (LM_IO_STR_BALANCEINACCCY >= LM_IO_STR_THAMOUNTINACCCY) | (VD_DLY_CR_BAL_M*LM_IO_CCYNM_RATE*DAYS)/(YEAR*100) |