CFG – Regular Floating Rate Instruments
This function demonstrates cash flow generation for regular floating rate instruments (such as loans). For the assumed financial positions from integrated data sources the following rules will be used to generate the periodic principal and interest payments in each case, according to the product properties specified in the function Financial Positions. The cash flow generation is commonly triggered by certain events. Therefore, during input the Join Events and Positions function is chosen. On the Input tab, the fields Amortizing Type and Interest Rate Type are used to filter for desired entries. By selecting amortizing type “1” and “2” and interest rate type “FL” (floating rate) respectively, the input entries are limited to regular fixed rate instruments.
For demonstration purposes, the following rules have been defined:
-
Rule R0 – Lookup Period Rates from Index is set to rule type “Rate Modelling” on level 0. For the regular amortizing type, the periodic interest rate must be determined first to calculate the amortized principal. Therefore, for a floating interest rate type, the rate modelling is used first to lookup the correct rates from the relevant curve (index). It has a line L1 – Rate from a given Index of line type “Lookup Rate by Interpolation”. The given curve rates identified by the curve ID (index) is interpolated and assigned to each payment period in this rule.
-
Rule R1 – Principals by Payment Rate is set to rule type “Flow Generation” on level 1. It generates cash flows according to the predefined periodic payment rate and the periodic interest rate determined in rule R0. The selection condition “Periodic payment rate greater than 0” is used in this rule. Rule R1 contains the following lines:
-
L1 – Disbursement of line type “Single Flow” produces the disbursement cash flow of loans according to related events.
-
L2 – Principal Payment of line type “Periodic Fixed Rate Flow” distributes the principal payment by the given periodic payment rate and fixed interest rate to all payment periods.
-
-
Rule R1I – Interests is set to rule type “Rate Modelling” on level 2. It is executed after rule R1 and uses the result of rule R1 as input to produce periodic interests. It uses the period beginning balance, which is determined by the start amount of loans and the previous principal payments, as well as the periodic interest rate determined in rule R0. It has a line L1 - Interests calculated by given Interest Rates of line type “Periodic Fixed Interest”.
-
Rule R2 – Principals by Regular Scheduled Amounts is set to rule type “Flow Generation” on level 1. It generates cash flows by evenly distributing principal amounts. The selection condition "Periodic payment rate equal to 0" is used in this rule, which selects the disjoint subset of rule R1 from rule R0. Rule R2 contains the following lines:
-
L1 – Disbursement of line type “Single Flow” produces the disbursement cash flow of loans according to related events.
-
L2 – Principal Payment of line type “Periodic Fixed Amount Flow” distributes the amount (start amount – end amount) evenly to all payment periods.
-
L3 – Final Repayment of line type “Single Flow” produces the final repayment on the end date specified by the end amount of the position.
-
-
Rule R2I – Interests is set to rule type “Rate Modelling” on level 2. It is executed after rule R2 and uses the result of R2 as input to produce periodic interests. It uses the period beginning balance, which is determined by the start amount of loans and the previous principal payments, as well as the periodic interest rate determined in rule R0. It has a line L1 – Interests calculated by given Interest Rates of line type “Periodic Fixed Interest”.