- Products User Guide
- Product Definition
- Product Definition
- ICCF Details
1.2.3 ICCF Details
Use ICCF Details screen to calculate the interest that applies on a contract.
- Creating interest rules
- Building interest classes (specifically, for the Securities module)
- Associating a product with an interest rule (or an interest class in case of the Securities module). This rule applies on all contracts processed under the product.
- Amending, if required, certain interest details that a contract acquires from the product under which it is processed
- Click the Interest button in the Product Definition screen to invoke the ICCF Details screen.The system displays the ICCF Details screen.
- In the ICCF Details screen, specify the fields.In this screen, you can associate the product you are creating with an Interest Rule. The attributes defined for the interest rule or class that you link to a product default to all contracts processed under the product.
Note:
For products created in certain modules of Oracle Banking Treasury Management, you may have to specify additional interest details. These details have to be specified in the Product Preferences screen of the module.For detailed explanation on the fields, refer to the below table.Table 1-2 ICCF Details- Field Description
Field Description Amount Type
Specify the basis on which interest has to be calculated. By default, the principal will be taken as the basis.
Pre Payment Method
The prepayment method identifies the computation of the prepayment penalty for the contract.
Stop Application
Select this check box to stop application.
The attributes defined for a product will be automatically applied to all contracts involving the product. If, for some reason, the user want to stop applying the Interest Rule defined for the product on contracts that are to be initiated in the future (involving the product), the user could do so through the Product ‘ICCB Details’ screen.
In effect, stopping the application of a component for a product would be equivalent to deleting the component from the product. By specifying that the application of the component must be stopped, the user has the advantage of using the definition made for the component again, by making it applicable.
Propagation Required
Select this check box if the propagation is required.
If the interest amount collected from the borrower must be passed on to participants of the contract, check the 'Propagation Required' check box.
Accrual Required
Select this check box if the accrual is required.
Allow Amendment
A change to a contract (after it has been authorized) that involves a change in its financial details constitutes an Amendment on the contract. The user can indicate whether such an Amendment, called a Value Dated Change, must be allowed for the interest component being defined.
The user can amend the following through this function:
- Interest rate
- Rate code
- Spread
- Interest amount
Consider as Discount
While defining an interest, the user can indicate whether the interest component is to be considered for discount accrual on a constant yield basis or whether accrual of interest is required.
If the user select the Consider as Discount option the interest received against the component is used in the computation of the constant yield and subsequently amortized over the tenor of the associated contract.
Checking the Consider as Discount also indicates whether the interest component is to be considered for IRR computations.
The Consider as Discount option is not available if the amount category is Penalty.
Collection Type
Select the collection type. The options are:
- Advance
- Arrear
Category
If the interest rate type is Fixed or Floating, the Amount Basis Category specifies the type of balance that has to be considered for interest application. It could be any one of the following:
- Expected
- Overdue
- Normal
- Outstanding
If the Basis Amount Category is Expected, the balance on which interest has to be applied will be the Expected balance (the balance assuming that all the scheduled repayments defined for the contract are made on time).
If the Basis Amount Category is Overdue, the balance on which interest has to be applied will be the amount that is overdue, based on the repayment method defined for the contract. An example of this category is the application of penalty interest on the Principal amount or interest, when a repayment has not been made, as per the date specified for the contract.
Settlement Currency
Specify the currency in which the interest, charge or fee component gets settled. The currency mentioned here must exist in the currency table. By default it is the local currency.
Level Number
Grace Period and Level Number
The user can apply interest at various levels:
- Main interest on principal – Level 0 (Category: Expected)
- Interest on overdue interest – Level 1 (Category: Overdue)
- Interest on Level 1 interest – Level 2 (Category: Overdue) … and so on.
For each interest component, starting from Level 1 and belonging to ‘Overdue’ category, the user can also specify the number of grace days, beyond the main interest due date, after which that interest component becomes applicable. For each such component, the default value for the number of grace days is:
Number of grace days for the previous level + 30 days
The user can change this value, provided that the number of grace days for a component (level) does not exceed the number of grace days for any successive level. At any point, an amendment of the number of grace days for any or more interest components at the Product ICCB level will only affect new contracts.
For interest components of Level 0 and ‘Expected’ category, the default value for grace days is 0 – this cannot be changed.
Main Component
The user can define any number of interest type of components (tenor based components) for a product. If the user has defined more than one interest type of component, the user can specify the main interest component as ‘Main Component’. This will be the interest component that will be used for capitalization or amortization purposes if the repayment schedules are defined thus.
The details of this Main Component will be shown in the Contract Details screen and the user can change them there without having to invoke the Contract ICCB Details screen. Components other than the main component have to be processed through the Contract ICCB Details screen.
Bulk Amount
When a contract gets rolled over, the user may wish to split it into 2 contracts - one for the interest amount (I) and the other for the principal amount (P). If the user want the floating rate pickup for both the new contracts (tenor/amount) to be based on P+I of the original contract, check the 'Bulk Amount' check box. For example, if the principal amount is Rs.1000 and Interest accrued is Rs.100. Upon rollover, your bank may require two contracts, one for Rs.1000 (Principal contract) and the other for Rs.100(interest contract). Lets say the slab rate followed by your bank is:
- 0 – 1000 - 3%
- 1001 – 2000 - 4%
In the normal course, system would apply 3% interest rate on both the contracts of Rs.1000 and Rs.100 (since both fall within 0 -1000 slab). But if the ‘Bulk Amount’ option is chosen, then 4% is applied on both the contracts (as if a single contract of Rs.1100 is rolled over where system would have applied 4pct).
Link Contract As Rate Code
The user can use this field to indicate whether a fixed rate contract may be linked to the floating rate component, instead of a rate code. Check this box to indicate that a fixed rate contract may be linked.
Grace Period
The grace days that user specify for any level of interest in the Product ICCF screen will default to contracts entered under that product.
Alternative Risk-Free Rate
Select the Alternate Risk-Free Rate check box to enable the Alternate Risk Free-Rate preferences. Rate Type
The Rate Type indicates whether the interest is a Fixed Rate, a Floating Rate or a Special amount. When creating a product, the user must specify the Rate Type through the ‘Product - ICCB Details’ screen.
If the Rate Type is a Floating Rate, the user must also specify the Rate Code to which the product has to be linked.
Rate Code
Each Rate Code corresponds to a rate defined for a combination of Currency, Amount (if it is necessary) and an Effective Date. These details are maintained in the Floating Rates table.
This rate will be applied to contracts involving the product.
Borrow Lend Indicator
Floating rates are defined with a borrow or a lend tag attached to them. Here, the user indicate the nature of the floating rate that needs to be picked up for the interest component.
The options available are:
- Borrow
- Lend
- Mid
Rate Cycle Type
For floating type of interest components and fixed type with rate code attached, the user can indicate the manner in which floating rates must be applied.
The preference that the user specify here is used when an interest component does not fit into any direct parameter defined for the floating rate code. The options available are:
- Up – Choose this option to indicate that the rate of the upper tenor slab must be used.
- Down - Choose this option to indicate that the rate of the lower tenor slab must be used
- Interpolate - Choose this option to indicate that the rate must be interpolated between the rates of the upper and lower slabs
- Round Off - Choose this option to indicate that the tenor of the component must be rounded off to the nearest whole number. The rate defined for the derived tenor will be applied to the component
Event
The event is to which the component must be applied together with its description.
Rule
Rule associated to the Interest component
Component
The component for which the user are entering details together with its description.
Code Usage
The user must specify the method in which the rates in the Floating Rates table have to be applied. It could either be automatic application (meaning the rate has to be applied every time it changes), or periodic application (meaning the rate has to be applied at a regular frequency, defined for each contract involving the product).
Reset Tenor
Enter the tenor for which the floating rate (when applied automatically) needs to be picked up from the floating rates table, for contracts using this product. This field is applicable to floating type of interest components and fixed type with rate code attached.
Margin Basis
Indicate the basis for the interest margin and the method for applying the interest margin on the selected interest component for contracts using this product.
The user need to specify how the system must obtain the interest margin (if any) that must be applied on the selected interest component at the time of fixing the interest rate for contracts using the product. The available options are:
- Facility - The system defaults the margin from the borrower facility contract with which the drawdown is linked.
- Tranche - The system defaults the margin from the borrower tranche contract with which the drawdown is associated.
- Drawdown - If this option is chosen, the user must enter the applicable margin when the interest rate is fixed.
- This component which the user select is excluded from all the processing including liquidation and this calculation type is only used for margin application.
- After defining this component, booked formula for main interest component needs to be modified by replacing INTEREST_RATE with INTEREST_RATE + MARGIN_RATE. By doing this the interest gets calculated based on resolved interest rate (i.e. including floating rate and spread if applicable) and the margin.
- Customer - If this option is chosen, then the margin will be applicable to all draw down contracts under the selected customer.
Margin Application
Margin Application can be periodic or automatic
Event Description
Defaults event description
Rule Description
Defaults Rue description
Description
Defaults Component description
Pricing Details Specify the Pricing Details. External Pricing
Check this box for external pricing of interest component.
Product Limits Specify the Product Limits fields. Currency
Specify the currency for which limits are maintained
Rate Fixing Days
Defaults fixing days from Rate fixing maintenance screen. User will be able to modify the same.
Fixing Date Movement
Defaults fixing date movement from Rate fixing maintenance screen. User will be able to modify the same
Default Rate
Specify the default rate on contract creation. User will be able to modify the same.
Minimum Rate
Specify the minimum rate on contract creation. If the interest rate specified for a contract is less than this minimum rate, the minimum rate is applied on the contract
Maximum Rate
Specify the maximum rate on contract creation. If the interest rate specified for a contract is greater than this maximum rate, this rate will be applied on the contract.
Default Spread
Specify the default spread for a Floating rate type on contract creation
Minimum spread
Specify the minimum spread for a floating rate type product. If the spread specified during contract processing is less than the value specified as the minimum spread, this value will be picked up as the spread.
Maximum Spread
Specify the maximum spread for a floating rate type product. if the spread specified during contract processing is more than the value specified as maximum spread, this value will be picked up as the spread.
Interest Basis
This field indicates how the system must consider the tenor basis upon which interest is computed over a schedule or interest period, in respect of the interest component being associated with the product.
Denominator Basis
This field indicates the interest methods which have their interest basis set to ACTUAL i.e. 30(EURO)/ACTUAL, 30(US)/ACTUAL and ACTUAL/ACTUAL. Denominator Basis is used to specify how the month of February is treated when the denominator is 'Actual'. There are two types of denominator basis methods:- Per Interest Basis – Here the computation would be done based on ACT/ACT–ISMA Interest Method. In this case, the '366 Basis' field will not be applicable.
- Per Annum (A) – Here the interest calculation will depend on the value the user specify for 366 Basis
366 Basis
This is applicable only if the Denominator Basis is set to 'Per Annum'. The user can select one of the following values here:
- Leap Year
- Leap Date - computation would be done based on ACT/ACT - FRF Interest Method
No of Interest Period
This is applicable if the Denominator Basis is 'Per Interest Period'. Here the user can specify the number of Interest periods (Schedules) in the financial year.
Link Contract as Rate Code
A floating rate component defined for a product can be linked to either a rate code, or to a contract with a fixed rate main component. This is applicable only for products in the following modules:- Deposits (a fixed rate loan can be linked)
- Money Market (for a placement product, a fixed rate borrowing contract can be linked, and for a borrowing product, a fixed rate placement can be linked)
In the MM Product ICCF screen, for a placements product, select the Link Contract as Rate Code option to indicate that for contracts using the placements product, a fixed rate borrowing contract can be linked instead of a rate code. For a borrowing product, select this option to indicate that for contracts using the borrowing product, a fixed rate placement contract can be linked instead of a rate code.
If so linked, the fixed rate specified for the main component of the linked contract, is applicable to the main contract. This would work in a similar fashion to linking a rate code. The spread and customer margin is applied on the linked contract rate to arrive at the effective interest rate for the main contract.
The Code Usage can be set to Auto or Periodic, only for the FLOAT Rate Type.Note:
If the selected linked fixed rate contract involves a different customer than that of the main contract, an override is sought, which can be accepted to proceed with saving the main contract.When the fixed rate in the linked contract is amended with a back value date, the effective date on which the changed rate is applied to any contracts it is linked to, is either the last liquidation date for the fixed rate contract, or the effective date of rate change for the contract it is linked to, whichever is later.
Parent topic: Product Definition