Business assumptions are behavior patterns exhibited by a bank’s customers or by the bank itself, which result in a change in the cash flows that occur purely under contractual terms. These include run-offs, prepayments, rollovers, drawdowns, asset sale, delinquencies, recoveries, haircuts, and so on. The application allows business assumptions to be defined under normal conditions. That is, business-as-usual or under multiple stress conditions, through a parameterized and flexible graphical user interface.
The assumptions defined under multiple conditions differ in the magnitude of the behavior exhibited, which results in either change in the cash inflows and outflows. For instance, the run-off rate under normal conditions for certain deposits maybe 2%, under a mild stress scenario it maybe 8%, and under a severe and prolonged stress scenario, it maybe 20%. The application allows you to define and maintain a library of such business assumptions of varying magnitudes and with different parameters. Once saved and approved, a business assumption is registered as a Process in the Rules Framework of Oracle Financial Services Analytical Applications Infrastructure, and can be used across multiple scenarios, Runs, and time periods for computing liquidity risk metrics.
The assumptions can be used to compute liquidity gaps and liquidity ratios under BAU and stress scenarios. LRS supports pre-packaged business assumptions required for computing liquidity coverage ratio in accordance with the BIS Basel III guidelines.
On execution of a BAU or stress Run, one or multiple business assumptions are applied to the contractual cash flows whose attributes correspond to the dimensions specified in the assumption. The application of an assumption results in an increase or decrease in cash flows, movement of cash flows from one bucket to another, change in the value or the encumbrance status of an account depending on the type of business assumption.
NOTE:
Every SKU in the Liquidity Risk Solution (LRS) pack leverages this common user interface.
Topics:
· Business Assumptions Supported
· Intraday Business Assumptions Supported
· Impact of Assumptions on Interest Cash Flows
· Cash Flow Assignment Methodologies
· Business Assumption Definition
· Understanding Business Assumption Summary
· Defining a New Business Assumption
· Business Assumption Approval Process
· Editing a Business Assumption
The application supports the following types of business assumptions:
Sl. No. |
Assumption Category |
Assumption Sub-category |
---|---|---|
1 |
Cash Flow Movement |
Cash Flow Movement Asset Sale Cash Flow Delay Delinquency Prepayment Recovery Rollover Run-off |
2 |
Encumbrance |
Encumbrance Ratings Downgrade Valuation Changes |
3 |
Incremental Cash Flow |
Incremental Cash Flow Drawdown New Business Ratings Downgrade Run-off Secured Funding/Financing Valuation Changes |
4 |
Value Change |
Available Stable Funding Factor Haircut Required Stable Funding Factor |
The computations related to each assumption category and sub-category are explained in detail in the following sections.
Topics:
Cash Flow Movement is a category of Business Assumptions that moves the cash flows move from the original time bucket to a prior bucket or a subsequent time bucket, based on the selected Assumption Sub Category.
Topics:
· Recovery
· Rollover
· Run-Off
This is a generic assumption, which enables you to define cash flow movements based on all combinations available as part of the Cash Flow Movement category. That is, it is a superset of all functionality supported by each subcategory in this assumption category.
This assumption moves the cash flows occurring in the original time bucket to a new user-specified time bucket, occurring before or post the original time bucket, based on the assumption value specified.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
This assumption is a specific case of cash flow movement category where cash flows posted in the original maturity bucket of an asset are moved to a prior bucket due to a sale.
· This assumption allows you to specify a sale of unencumbered marketable, fixed, or other assets to advance the cash inflows. Sale can be specified on each individual asset or as a combination of dimensions.
· This assumption allows you to specify a partial sale of assets by specifying the sale amount.
· The assumption reverses all original cash flows that occur between the sale bucket and maturity bucket and posts the market value less haircut in the sale bucket.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the asset sale assumption to cash flows:
1. New inflows are calculated due to sale based on the current market or fair value (in case of marketable and fixed assets) or current outstanding balance (in case of other assets such as loans) and haircut.
2. For instance, if the face value of a bond is 100, the market value is 120, and the sale is specified as 50%, then new inflows are 60 (i.e. 120*50%). Similarly, if the outstanding balance of a loan is 10000 and sale is specified at 75% with a haircut of 5%, the new inflow is 7125 [10000*75 % *(1 - 5 %)].
3. The original time bucket(s) are identified in which the asset(s) matures and the original cash inflows, both principal and interest, in each time bucket.
4. The original cash inflows to be reversed are calculated. This is proportionate to the sale amount and is calculated based on the original value.
5. In the example of the bond, it will be 50 (that is, 100*50%). In the example of the loan, it will be 75% of the original principal and interest payments.
6. The cash inflows are assigned due to sale to the sale bucket and reverse the proportionate original cash flow in the respective original buckets.
7. The number of units held is updated post-sale in case of marketable assets and the outstanding balance in case of other assets. For all further computations, the revised asset balance is used.
If a sale is specified as an amount or in terms of units, it is converted into a percentage of the market value or outstanding balance to reverse the original cash flows. For instance, a bank has 10 bonds whose total market value is $1200 and the original value is $1000.
a. When the sale is specified as $900 pre-haircut value, the percentage sold is 75% (that is, 900/1200). The original cash flow to be reversed is $750 (1000*75%).
b. When the sale is specified as 5 units, the percentage sold is 50% (that is, 5/10). The original cash flow to be reversed is $500 (1000*50%).
NOTE:
· Assets can only be sold in buckets that are before the original bucket. That is, their maturity bucket.
· If an asset is currently encumbered but its encumbrance period is less than its maturity, it can be sold in the time bucket occurring between the last day of encumbrance and its maturity.
· Other assets include unencumbered loans and other non-marketable assets.
· A sale of assets removes all future cash flows, both principal and interest and results in a new inflow at the sale bucket.
· The haircut is applied to the sale value only that is, market value in case of marketable and fixed assets and outstanding balance in case of other assets. Original cash flow reversal will not include haircut.
· If the sale is specified as an amount, it is considered as the pre-haircut amount.
· When converting the sale amount to a percentage, the pre-haircut amount is to be considered.
The following example illustrates the asset sale business assumption. This example is based on the equal cash flow assignment methodology. The original value of the asset in the 1-5 year bucket is 48000 and the greater than 5-year bucket is 32000. The current market value is 1245 per unit and the number of units held is 100.
Business Assumption Definition |
Cash Flow Assignment |
||||||
---|---|---|---|---|---|---|---|
Product Type |
Rating |
Sale Amount / Percentage |
Haircut |
Time Bucket |
Contractual Cash Flow |
Time Bucket |
Revised Cash Flow |
Bond |
BBB |
40% |
10% |
8-15 Days |
10000 |
Overnight |
24940 [= 10000 + {(1245*100*40%*90%)/3}] |
5000 |
1-7 Days |
19940 [= 5000 + {(1245*100*40%*90%)/3}] |
|||||
8000 |
8-15 Days |
22940 [= 8000 + {(1245*100*40%*90%)/3}] |
|||||
119870 |
1-5 Years |
100670 [=119870 - (48000*40%)] |
|||||
200907 |
> 5 Years |
188107 [=200907 - (32000*40%)] |
Due to market conditions, the payments or receipts that are expected at a particular time are delayed, thereby giving rise to liquidity risk. In such a scenario, the payments or receipts that were expected as on date will now be available at a future date. This assumption moves the expected cash flows in a particular time bucket to one or multiple future time buckets based on a percentage of the cash flow occurring in that bucket. In a cash flow delay assumption, cash flow movement happens from previous buckets to the future buckets.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption. This is the delayed payment or receipt amount excluding penalty which is reversed.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties on the delayed payments or receipts, if any.
In cash flow delay assumption, the cash flow movement is always to a future time bucket. Therefore, 0% is assigned to the previous buckets for Increasing or Decreasing assignment as illustrated in the table:
Illustration: Delays assigned to a selected time bucket.
Business Assumption Definition |
Computation Assignment |
||||||||
---|---|---|---|---|---|---|---|---|---|
Product |
Currency |
From Bucket |
To Bucket |
Delayed Amount |
Penalty |
Contractual Cash flow (From Bucket) |
Contractual Cash flow (To Bucket) |
Revised Cash flow -(From Bucket) |
Revised Cash flow(To Bucket) |
Vehicle Loan |
US Dollars |
10-10 Days |
12-12 Days |
10% |
5% |
30000 |
23000 |
27000 |
26150 |
This assumption caters to large and non-large customers. This assumption is based on the anticipation of the bank that there can be an emergency loss due to the delinquency of its customers which will affect the future cash flows. When a customer becomes delinquent, the cash flows of the delinquent buckets (as specified in percentage and amount) are moved to the overnight bucket. To specify delinquency on large customers, select a large customer dimension; however, the computation of cash flows is the same for both large and non-large customers. In a delinquency assumption, the cash flow movement happens from the forward bucket/s to the previous bucket (Overnight).
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
Cash flow assignment is done in the following manner:
An example of the assumption applied to product type (Business loan), and currency (USD) for Large and Non-Large Customers is illustrated in the table:
Illustration 1: Delays assigned to a selected time bucket.
Business Assumption Definition |
Computation Assignment |
|||||||
---|---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
Delinquent Value |
Contractual Cash Flow |
Contractual Cash Flow |
Delinquent (Value) |
Revised Cash flow |
Revised Cash flow |
Business Loans |
Large Customer |
8-8Days |
10% |
30000 |
23000 |
3000 [= (30000* 10%)] |
27000 |
40600 [=(23000+3000+5000+9600)] |
9-9Days |
20% |
25000 |
5000 [= (25000*20%)] |
20000 |
||||
10-10Days |
30% |
32000 |
9600 [= (32000*30%)] |
22400 |
Illustration 2: Delays assigned to a selected time bucket
Business Assumption Definition |
Computation Assignment |
|||||||
---|---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
Delinquent Value |
Contractual Cash Flow |
Contractual Cash Flow |
Delinquent (Value) |
Revised Cash flow |
Revised Cash flow |
Home Loans |
Non- Large Customer |
3-3 Days |
15% |
15000 |
23000 |
2250 [= (15000*15%)] |
12750 |
27350 [=(23000+2250+2100)]
|
4-4 Days |
10% |
21000 |
2100 [= (21000* 10%)] |
18900 |
||||
|
|
|
|
|
Prepayment is a situation where the customer repays the loan in part or full, at any time before the maturity of the loan. Prepayment would lead the bank to lose out on the interest component that it would have received if the loan was not pre-paid. Prepayment results in a cash inflow in a time bucket before the original time bucket and reduced cash inflow in the original time bucket. The percentage of prepayment is to be specified by you and the balance is payable only when it is due.
The prepayment supports prepayments on liabilities as well as assets in a single business assumption definition.
If a prepayment is specified on an asset or liability backed by collateral, the encumbrance period of the underlying collateral is re-calculated based on the time bucket in which the asset or liability is completely paid up.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
Cash flow assignment is done in the following manner:
The following example explains the Assumption Value Based on Original Cash Flows across Business Assumptions.
A prepayment of 10% from 8-15 Day bucket to 1-7 Day bucket and a 20% rollover is defined from 1-7 Day bucket to 8-15 Day bucket. The contractual cash flow in the 1-7 Day bucket is 5000 and the 8-15 Day bucket is 8000. The impact on the 1-7 Day bucket based on original cash flows is illustrated below:
Cash Flow Assignment |
|||
---|---|---|---|
Assumption |
Contractual Cash Flow in 1-7 Day Bucket |
Impact of Assumption |
Post-Assumption Cash Flow |
No Assumption |
5000 |
0 |
5000 [=5000 - 0] |
Prepayment |
5000 |
800 [= (8000*10%)] |
5800 [=5000 + 800] |
Rollover |
5800 |
- 1000 [= - (5000*20%)] |
4800 [= 5800 - 1000] |
In this case, even though the cash flow has changed after applying the prepayment assumption, the original cash flow is used for estimating the impact of the rollover assumption.
Recovery assumes the part/full amount is recovered from delinquent/ defaulted accounts. In this assumption, the contractual cash flows assigned to the overnight time bucket is considered. Even though contractually it is due immediately, the actual recovery takes place only over a period of time. In this assumption, the contractual cash flows assigned to the overnight time bucket is considered. You are allowed to specify the percentage of recovery in each time bucket based on past experiences. The balance percentage which is not specified by you is placed in the unspecified time bucket. Therefore, the contractual cash flow is first deducted from the overnight time bucket and assigned to various other time buckets based on the defined percentages.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
Cash flow assignment is done for delinquent/defaulted cash flows in the following manner:
The following example shows the assumption applied to product type (loan), legal entity (LE 1), and currency (USD):
Business Assumption Definition |
Cash Flow Assignment |
||||||||
---|---|---|---|---|---|---|---|---|---|
Product Type |
Legal Entity |
Currency |
Loan Status |
Time Bucket |
Business Assumption |
Time Bucket |
Default Cash Flow |
Business Assumption |
Adjusted Cash flow |
Product 01 |
LE 1 |
USD |
Default |
1 - 30 days |
10% |
Overnight |
10000 |
|
0 [=(10000-10000)] |
1 - 30 days |
|
10% |
1000 [= (10% *10000)] |
||||||
30 - 60 days |
15% |
30 - 60 days |
|
15% |
1500 [=(15%* 10000)] |
||||
60 - 180 days |
25% |
60 - 180 days |
|
25% |
2500 [=(25% * 10000)] |
||||
|
|
|
|
|
|
Unspecified that is, 180 - |
|
|
5000 [=(10000-1000-1500-2500)] |
Rollover refers to the rescheduling of a certain percentage of cash flows to a future time bucket. This occurs when an asset/liability is renewed for an additional term. The amount of cash flow rolled over is thus reduced/increased from the original time bucket and assigned to the new time bucket in the future.
The assumption specification and computation method for this subcategory remain unchanged. This subcategory allows rollovers to be specified even on repos, reverse repos and swaps. In the case of rollover of swaps, the user is required to select the transaction legs option as two.
If a rollover is specified on an asset or liability that has underlying collateral, then the availability of the underlying should be determined. Only if the underlying collateral is available during the extended period, the assumption should be allowed to be saved
Rollover of assets impacts the inflow amount and rollover of liabilities impacts the cash outflow amount. The signage and computation depends on the product type selected. In a rollover assumption, cash flow movement happens from previous bucket/s to the forward buckets.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
Rollover of Assets refers to the rescheduling of a certain percentage of cash flows to a future time bucket. This occurs when an asset is renewed for an additional term. The amount of cash flow rolled over is thus reduced from the original time bucket and assigned to the new time bucket. The effect of this assumption would be an altered final cash flow in the affected time buckets. The rollover of assets impacts the inflow amount.
Cash flow assignment is done in the following manner:
For instance, Rollover of Assets is explained in the following example of the assumption applied to product type (Loan), legal entity (LE 1), and currency (USD).
Business Assumption Definition |
Cash flow Assignment |
|||||||
---|---|---|---|---|---|---|---|---|
Product Type |
Legal Entity |
Currency |
Original Maturity Bucket |
Revised Time Bucket |
Rollover % |
Contractual Cash flow |
Time Bucket |
Revised Cash flow amount |
Loan |
LE 1 |
USD |
15-30 Days |
60-90 Days |
10% |
10000 |
15-30 Days |
3000 [= 10000 - (10%* 10000) - (60% * 10000)] |
5000 |
60-90 Days |
6000 [(= 5000 + (10* 10000)] |
||||||
180-360 Days |
60% |
7000 |
180-360 Days |
13000 [= 7000 + (60%* 10000)] |
Rollover of liabilities refers to the rescheduling of a certain percentage of cash flows to a future time bucket. It occurs when the liabilities are renewed for an additional term. The amount of cash flow rolled over is thus increased in the original maturity time bucket and assigned to the new maturity time bucket. The effect of the business assumption would be an altered final cash flow in the various time buckets. Rollover of liabilities impacts the cash outflow amount.
Cash flow assignment is done in the following manner:
In a Run-off assumption, the bank assumes that a certain percentage of deposits/liabilities will be withdrawn by their customers before the scheduled maturity of the deposit. This business assumption would result in an additional outflow in an earlier time bucket and a reduction in the contractual cash outflow in the original time bucket. The assumption can also be applied to assets as well, where the impact on cash flows will be opposite to that specified for deposits above.
The cash flow movement happens from forward bucket/s to the previous bucket/s since cash flows which were expected to be withdrawn at a future date are getting withdrawn as on date.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
Cash flow assignment is done in the following manner:
An illustration is as follows:
Business Assumption Definition |
||||||||
---|---|---|---|---|---|---|---|---|
Legal Entity |
Customer |
From Bucket |
To Bucket |
Assumption Unit |
Run-off |
Assignment Method |
Assumption Category |
Based On |
Legal Entity 1 |
Customer 2 |
6-6Days |
3-3Days |
Percentage |
10% |
Equal |
Cash Flow Movement: Run - off |
Cash Flows |
Cash flow Assignment |
|||||
---|---|---|---|---|---|
To Bucket |
Contractual Cash Flow (From Bucket) |
Contractual Cash Flow (To Bucket) |
Run-off |
Revised Cash flow (From Bucket) |
Revised Cash flow (To Bucket) |
Overnight |
20000 |
10000 |
500 |
18000 |
10500 |
|
|
[=(20000*10%)/4] |
[=(10000+500)] |
||
1-1 Day |
11000 |
500 |
11500 |
||
|
|
[=(20000*10%)/4] |
[=(11000+500)] |
||
2-2 Days |
22000 |
500 |
22500 |
||
|
|
[=(20000*10%)/4] |
[=(22000+500)] |
||
3-3 Days |
12000 |
500 |
12500 |
||
|
|
[=(20000*10%)/4] |
[=(12000+500)] |
This section provides information about Encumbrance.
Topics:
This is a generic assumption that can be defined and caters to the different combinations available as part of rating downgrade and valuation changes of collateral.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
Some financing transactions or derivatives with embedded downgrade triggers, downgrade a bank’s rating by a recognized credit rating institution, requiring the bank to post additional collateral. This assumption impacts the numerator of LCR that is, a decrease in the market value of HQLA.
For some financing transactions or derivatives with embedded downgrade triggers, downgrade in a bank’s rating by a recognized credit rating institution will require the bank to post additional collateral. The encumbrance assumption category assumes that the asset required to be posted as additional collateral is already available with the bank and will be encumbered. This results in the deduction of the relevant amount from the stock of high quality liquid assets as it is now no longer unencumbered.
NOTE:
The assumption specification and computation method for this subcategory correspond to that available as part of the Additional Collateral - Rating Downgrade Decrease in Asset assumption type. This assumption is renamed as Ratings Downgrade in this version.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
New Stock of HQLA assignment is done in the following manner:
Assuming a downgrade trigger of 3-Notches, this assumption is specified as follows:
Business Assumption Definition |
Cash Flow Assignment |
|||
---|---|---|---|---|
Asset Level |
Downgrade Impact Value |
Downgrade Impact Amount |
Downgrade |
Decrease in HQLA |
Level 1 Asset |
80% |
11000 |
1 Notch |
8800 [= (11000*80%)] |
Level 1 Asset |
100% |
9000 |
2 Notches |
9000 [= (9000*100%)] |
Level 1 Asset |
80% |
80000 |
3 Notches |
64000 [= (80000*80%)] |
This assumes that a bank would require posting additional collateral because of a decrease in the value of current assets.
This assumption impacts the numerator of LCR, which results in a decrease in the stock of HQLA.
In this assumption, the additional collateral posted will result in the selected assets being marked as encumbered. The relevant amount is deducted from the stock of high quality liquid assets where applicable. These assets will not be available for the purpose of counterbalancing or for estimating the cash inflows for LCR.
This assumption supports changes in the value of the collateral posted due to changes in the market valuation of transactions or changes in the contract value. This further leads to cash outflow.
This assumption impacts the denominator of LCR that is, increase in the outflow for the Legal Entity.
Some derivatives are secured by collateral to cover losses arising from changes in mark-to-market valuations. For changes in the value of the derivative, additional collateral is posted, resulting in a cash outflow. The valuation changes can be with Natural currency or Selected Currency. Valuation changes can be specified in Amount or Percentage. Here, both ratings and notches downgrade are not applicable.
The time buckets selected as part of the assumption parameters are the impacted time buckets.
NOTE:
The assumption specification and computation method for this subcategory correspond to that available as part of the Additional Collateral - Valuation Changes - Asset Value Decrease assumption type. This assumption is renamed as Valuation Changes in this version.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
For example:
Based On |
Assumption Unit |
Assignment Method |
---|---|---|
Market Value |
Percentage |
Selected |
Legal Entity |
Product |
Valuation Change Impact |
---|---|---|
LE 1 |
P4 |
100% |
LE 2 |
P5 |
50% |
LE 3 |
P4 |
20% |
LE 4 |
P5 |
30% |
Legal Entity |
Product Type |
Original Market Value |
Revised Market Value |
---|---|---|---|
LE 1 |
P4 |
520000 |
0 [=520000-(100% * 520000)] |
LE 2 |
P5 |
610000 |
305000 [610000- (50%*610000)] |
LE 3 |
P4 |
160000 |
128000 [160000-(20% * 160000)] |
LE 4 |
P5 |
120000 |
84000 [120000-(30% * 120000)] |
This section provides information about Incremental Cash Flow.
Topics:
· Drawdown
· Run-off
This is a generic assumption which enables you to define and caters to the different combinations available as part of Incremental Cash Flow.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
The Drawdown of Unutilized Credit and Drawdown of Funding Line of Credit assumption types have been merged as part of the drawdown subcategory. The assumption specification and computation method for this subcategory remain unchanged. This subcategory allows drawdown to be specified on lines of credit extended as well as received by banks in a single business assumption.
There is an amount line given to the bank or received by the banks which are allowed to drawdown. This allows drawdown to be specified on lines of credit extended as well as received by Banks.
· Drawdown of Unutilized Credit: Banks generally allow customers to withdraw a certain amount which is a percentage of the value specified as the limit. This business assumption is applied to the undrawn portion, the assumption being that a certain portion of the undrawn amount is drawn by the customer at the specified time bucket thus leading to additional cash outflows. This assumption also allows you to specify the corresponding cash inflow for the specified cash outflow.
· Drawdown of Funding Line of Credit: Banks also receive lines of credit from other banks and financial institutions. The bank can drawdown these lines as per its requirement at any time during the tenure of the facility. A percentage of the total undrawn amount is assumed to be drawn down over each time bucket. Drawdown of funding line of credit results in cash inflow first and outflow at a later date. This assumption also allows you to specify the corresponding cash outflow for the specified cash inflow
Additionally, this assumption allows you to specify the corresponding cash inflow for the specified cash outflow.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
Various options for cash flow assignments are available. Refer section Cash Flows.
Following is an illustration for drawdown:
Business Assumption Definition |
Cash Flow Assignment |
||||||
---|---|---|---|---|---|---|---|
Product Type |
Primary Bucket |
Off-Set Bucket |
Undrawn amount |
Drawdown Value |
Contractual Cash Flow |
Time Bucket |
Revised Cash Flow |
Loan |
1-7 Days |
8-15 Days |
10000 |
30% |
5000 |
1-7 Days |
8000 [= 5000 +30%* 10000] |
|
|
|
|
|
8000 |
8-15 Days |
5000 [=8000 - 30%*10000] |
Here,
Primary bucket = Inflow bucket
Offset bucket = Outflow bucket
When the markets are inaccessible to the banks due to several reasons, the cash flows continue to run-off contractually. However, no new business is allowed due to market inaccessibility. Banks are required to maintain a pre-defined level of balance at all times. In some cases, due to market inaccessibility, the balance goes down and banks are required to restore the balance to the pre-defined levels over a period of time, called the restoration period.
The following steps are for calculating cash flows based on the liability run-off business assumption:
1. Run-off the contractual cash flows until the end of the market inaccessibility period.
2. The sum of cash outflows during the market inaccessibility period is computed.
3. The balance to be maintained at the end of the portfolio restoration period is computed as follows:
4. The balance at the end of the market inaccessibility period is computed as follows:
5. The total re-issue amount is computed as follows:
6. If the re-issue amount is positive, the following occurs:
a. All contractual cash flows occurring after-market inaccessibility period are removed.
b. The re-issue allocation days as the number of business days in the portfolio restoration period is calculated.
c. The re-issue amount per business day is calculated as follows:
d. The reissue amount per day as a cash inflow on each business day during the portfolio restoration period is posted.
7. If re-issue amount is negative, the following occurs:
a. If the outstanding contractual balance at the end of the portfolio restoration period is greater than the post-restoration target balance.
i. The additional run off during per business day is computed as follows:
ii. The additional run off per day as a cash outflow on each business day during the portfolio restoration period in addition to contractual cash outflow is posted.
b. If the contractual balance at the end of the portfolio restoration period is less than the post-restoration target balance.
i. The contractual cash outflows on each business day following the market inaccessibility period, until the outstanding balance is equal to the post-restoration target balance is posted.
ii. All contractual cash outflows after the day on which the outstanding balance is equal to the post restoration target balance are removed.
See the following example for Liability Run-off:
As of Date |
13-Apr-14 |
---|---|
EOP Balance |
4698.24 |
Inaccessibility End Bucket |
9-9 Day |
Restoration End Bucket |
20-20 Day |
Minimum Balance |
100 |
Restoration % |
1% |
Market Inaccessibility End Date |
22-Apr-14 |
---|---|
Restoration End Date |
3-May-14 |
Market Inaccessibility Period |
9 |
Portfolio Restoration Period |
11 |
Contractual Cash Outflows during Inaccessibility Period |
2321.93 |
Post Restoration Target Balance |
100.00 |
Post Market Inaccessibility Balance |
2376.30 |
Contractual Run-off during Restoration |
2056.58 |
Post Restoration Outstanding Contractual Balance |
319.72 |
Total Reissue Amount |
-2276.30 |
Reissue Allocation Days |
8 |
Reissue Amount per Day |
0.00 |
Additional Run-off per Day |
27.47 |
The following example shows the cash flows when re-issue amount is negative and post-restoration outstanding contractual balance and post-restoration target balance.
Inputs |
Calculation |
||||||
---|---|---|---|---|---|---|---|
Calendar Date |
Contractual Cash Outflow |
Contractual Cash Inflow |
Day from As of Date |
Holiday Indicator |
Cumulative Cash Outflow (Post Inaccessibility Period) |
Post Assumption Cash Outflow |
Post Assumption Cash inflow |
4/14/2014 |
919.85 |
0.00 |
1 |
|
0.00 |
919.85 |
0.00 |
4/15/2014 |
341.48 |
0.00 |
2 |
|
0.00 |
341.48 |
0.00 |
4/16/2014 |
320.37 |
0.00 |
3 |
|
0.00 |
320.37 |
0.00 |
4/17/2014 |
291.37 |
0.00 |
4 |
|
0.00 |
291.37 |
0.00 |
4/18/2014 |
131.73 |
0.00 |
5 |
|
0.00 |
131.73 |
0.00 |
4/19/2014 |
0.00 |
0.00 |
6 |
Y |
0.00 |
0.00 |
0.00 |
4/20/2014 |
0.00 |
0.00 |
7 |
Y |
0.00 |
0.00 |
0.00 |
4/21/2014 |
198.15 |
0.00 |
8 |
|
0.00 |
198.15 |
0.00 |
4/22/2014 |
118.98 |
0.00 |
9 |
|
0.00 |
118.98 |
0.00 |
4/23/2014 |
33.59 |
0.00 |
10 |
|
0.00 |
61.05 |
0.00 |
4/24/2014 |
295.54 |
0.00 |
11 |
|
33.59 |
323.00 |
0.00 |
4/25/2014 |
329.09 |
0.00 |
12 |
|
329.12 |
356.56 |
0.00 |
4/26/2014 |
0.00 |
0.00 |
13 |
Y |
658.22 |
0.00 |
0.00 |
4/27/2014 |
0.00 |
0.00 |
14 |
Y |
658.22 |
0.00 |
0.00 |
4/28/2014 |
440.79 |
0.00 |
15 |
|
658.22 |
468.25 |
0.00 |
4/29/2014 |
266.20 |
0.00 |
16 |
|
1099.01 |
293.66 |
0.00 |
4/30/2014 |
112.62 |
0.00 |
17 |
|
1365.20 |
140.08 |
0.00 |
5/1/2014 |
289.16 |
0.00 |
18 |
|
1477.82 |
316.63 |
0.00 |
5/2/2014 |
289.60 |
0.00 |
19 |
|
1766.98 |
317.06 |
0.00 |
5/3/2014 |
0.00 |
0.00 |
20 |
Y |
2056.58 |
0.00 |
0.00 |
5/4/2014 |
0.00 |
0.00 |
21 |
Y |
2056.58 |
0.00 |
0.00 |
5/5/2014 |
319.72 |
0.00 |
22 |
|
2056.58 |
0.00 |
0.00 |
The new business assumption accounts for both the initial outflows as well as corresponding inflows occurring due to growth in the business represented by Leg 1 and Leg 2. This assumption also accounts for both the outflows and corresponding inflows occurring due to the growth in business represented by Leg 1 and Leg 2.
The New Business assumption category supports the following assumptions:
· Deposit Balance Growth (when Based on = Cash Flows)
· Asset Book Growth (when Based on = Cash Flows)
· Liability Book Growth (when Based on = Cash Flows)
· EOP Balance Growth of Assets (when Based on = EOP Balance)
· EOP Balance Growth of Liabilities (when Based on = EOP Balance)
The change in the earlier deposit balance growth assumption is now the new business assumption. If you select the assumption type as Deposit Balance Growth, select Based On is selected as Cash Flows under this assumption.
The following five assumptions have been merged into a single assumption. This is how you can cater to each assumption:
· Deposit Balance Growth (Based on = Cash Flows)
Deposits balance refers to the cash in hand and the deposits maintained by the bank with other institutions including the central bank. Increase in deposit balance results in an increased cash inflow in the maturing time bucket.
NOTE:
Deposits Balance Growth can either be positive or negative.
· Asset Book Growth (Based on = Cash Flows)
Asset book refers to the balances of loans and advances given by the bank. An increase in the asset balance results in increased cash outflow in the selected time bucket and corresponding inflows in future time buckets. This assumption accounts for both the initial outflows as well as corresponding inflows occurring due to growth in the business represented by Leg 1 and Leg 2.
· Liability Book Growth (Based on = Cash Flows)
Liability Book Growth refers to the growth in the value of deposits which are maintained by the bank’s customers or borrowings that have been taken by the bank. The growth in the value of deposits results in additional cash outflow in the maturing time bucket. This assumption also accounts for both the outflows and corresponding inflows occurring due to the growth in business represented by Leg 1 and Leg 2.
· EOP Balance Growth of Assets (Based on = EOP Balance)
EOP Asset Balance of Growth assumption estimates new businesses based on the EOP balance of assets. It accounts for both legs of the transactions, that is, inflows as well as outflows.
· EOP Balance Growth of Liabilities (Based on = EOP Balance)
EOP Liability Balance Growth assumption estimates new businesses based on the EOP balance of liabilities. It accounts for both legs of the transactions, that is, inflows and outflows.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
Various options for cash flow assignments are available. See the Cash Flows section.
See the following example for Asset Book Growth:
Business Assumption Definition |
Cash Flow Assignment |
||||||||
---|---|---|---|---|---|---|---|---|---|
Product Type |
Legal Entity |
Primary Bucket |
Off-set Bucket |
Growth |
Off-set Value |
Contractual Cash Flow |
Revised Contractual Cash Flow |
Contractual Cash Flow |
Revised Contractual Cash Flow |
Loans |
LE1 |
3-3 Days |
60-60 Days |
15% |
60% |
20000 |
17000 |
25000 |
26800 [= |
90-90 Days |
20% |
27000 |
27600 [=(20000*15%*20%)+27000] |
||||||
120-120 Days |
20% |
32000 |
32600 |
Here,
An example of Liability Book Growth is as follows:
Business Assumption Definition |
Computation |
||||||||
---|---|---|---|---|---|---|---|---|---|
Product Type |
Legal Entity |
Primary Bucket |
Off-set Bucket |
Growth |
Off-set Value |
Contractual
Cash Flow |
Revised
Contractual Cash Flow |
Contractual
Cash Flow |
Revised
Contractual Cash Flow |
Deposits |
LE1 |
3-3 Days |
4-4 Days |
25% |
60% |
20000 |
25000 [= |
25000 |
22000 |
5-5 Days |
40% |
32000 |
30000 |
Here,
NOTE:
1. Regarding columns titled “Cash Flow”, if the value is positive, it is a cash inflow. If the value is negative, it will be a cash outflow.
2. ‘Contractual cash flow- Primary' and 'Contractual cash flow- Secondary' refers to cash flows that are already present in the respective buckets. Similarly, the revised column represents cash flows after the application of this business assumption.
3. The cash flow signage explanation provided before holds good for both asset growth and liability growth.
4. For a liability
growth, such as deposits, a growth from the bank's perspective means that
there will be an inflow of funds first (bank receives deposits from customers
first) and then there will be a corresponding outflow later (Bank returns
deposit proceeds on maturity to the customer). The converse holds good
for asset growth. Note that the first transaction bucket is always the
primary bucket.
In the example above on deposits, 3-3 days is defined as a primary bucket
(the first bucket). In this case, since it is a liability, it would result
in an inflow in this bucket. The offset bucket will have an outflow.
5. The growth amount (delta) in the primary buckets and the offset buckets would be the same. For example: In the example of deposits above, the growth amount in the primary bucket is 5000 (25% of 20000). The offset buckets have an amount of 5000 which is the sum of 3000 and 2000.
This assumption supports both rating based, and notch-based downgrade. These downgrades are specified for each legal entity within the bank’s organizational structure. This can come from multiple sources such as Moody’s, S&P, and can be both short term and long term or a combination thereof. Since these rating downgrades are defined at a legal entity level, the legal entity is a mandatory dimension for this assumption. If the downgrade is the same across all legal entities, no individual legal entity is required to be selected.
For some financing transactions or derivatives with embedded triggers for downgrade, a downgrade of the bank’s rating by a recognized credit rating institution requires the bank to post additional collateral. This will increase the cash outflow for all the accounts that are triggered based on the corresponding downgrade impact amount and downgrade impact value specified by the bank. The downgrade trigger and the corresponding downgrade impact amount are available as part of the account information. For calculation of downgrade impact amount see the Modified Liquidity Coverage Ratio Calculations, section Other Calculations in the OFS Liquidity Risk Regulatory Calculations for US Federal Reserve User Guide Release 8.1.0.0.0.
NOTE:
The assumption specification and computation method for this subcategory correspond to that available as part of the Additional Collateral - Rating Downgrade Cash Flow Increase assumption type. This assumption is renamed as Ratings Downgrade in this version.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
Cash flow assignment is done in the following manner:
The following example illustrates the impact of a notch-based downgrade. Suppose legal entity 1 has 3 accounts whose downgrade triggers are specified as follows:
Account |
Rating Type |
Rating Source |
Downgrade Trigger |
Trigger Type |
Impact Amount |
---|---|---|---|---|---|
Account 1 |
Short Term |
Moody’s |
P-3 |
And |
1000000 |
Long Term |
Moody’s |
A3 |
Or |
|
|
Long Term |
S&P |
A- |
|
|
|
Account 2 |
Short Term |
Moody’s |
P-2 |
And |
250000 |
Long Term |
S&P |
BBB+ |
|
|
|
Account 3 |
Short Term |
Internal |
A-3 |
Or |
3000000 |
Long Term |
Moody’s |
Baa2 |
|
|
|
Account 4 |
Long Term |
Moody’s |
Baa1 |
|
750000 |
Account 5 |
Short Term |
Moody’s |
P-2 |
|
1250000 |
The downgrade assumption is specified as follows:
Rating Type |
Rating Source |
Downgrade Trigger |
Impact % |
Time Bucket |
---|---|---|---|---|
Short Term |
Moody’s |
2-Notches |
100% |
7 Days |
Long Term |
Moody’s |
3-Notches |
The new rating post downgrade is assessed as follows:
Rating Type |
Rating Source |
Current Rating |
Rating Post Downgrade |
---|---|---|---|
Short Term |
Moody’s |
P-1 |
P-3 [= P-1 - 2 Notches] |
Long Term |
Moody’s |
Aa3 |
A3 [= Aa3 - 3 Notches] |
The impact of the downgrade assumption, considering weekly time buckets, is calculated as follows:
Account |
Applicability of Assumption |
Reason |
Cash Outflow / Encumbrance |
Outflow Bucket |
---|---|---|---|---|
Account 1 |
Applicable |
Both parts of the first condition are fulfilled. The second condition is Or, hence not required to be fulfilled if the first one is. |
1000000 [=1000000*100%] |
5 - 5 Week [=(7+15 Days)/5 Business Days] |
Account 2 |
Not Applicable |
The second part of the condition is not fulfilled. |
|
|
Account 3 |
Not Applicable |
Either of the conditions is not fulfilled. |
|
|
Account 4 |
Not Applicable |
The condition is not fulfilled. |
|
|
Account 5 |
Applicable |
The condition is fulfilled as the quantum of downgrade specified as part of the assumption is greater than the downgrade trigger set for this instrument. |
1250000 [=1250000*100%] |
3 - 3 Week [=(7+5 Days)/5 Business Days] |
The total impact of this assumption is a cash outflow or asset encumbrance of 2250000.
Incremental Cash Flow Run-off is applied to the End of Period (EOP) balances, indicating the amount that is withdrawn before their scheduled maturity. The computation methodology has one additional step; if cash flows exist for the dimension combination for which Run-off is specified, they are deleted, and then the new cash outflows are generated.
See the Defining a New Business Assumption, section for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
For instance, incremental cash flow Run-off is applied to Time Deposits whose EOP balance is $ 10000. The assumption is applied on the original balance to selected time buckets as follows:
Business Assumption Definition |
Cash Flow Assignment |
||||
---|---|---|---|---|---|
Product Type |
To Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Revised Cash Flow |
Time Deposits |
1-7 Days |
10% |
5000 |
1-7 Days |
1000 [=5000 - 5000 +10000*10%] |
|
8-15 Days |
20% |
8000 |
8-15 Days |
2000 [=8000 - 8000 +10000*20%] |
This assumption is based on debt backed or secured by collateral securities associated with lending. This assumption category refers to the generation of secured funding or creation of secured financing transactions including secured loans, repos, and so on. For example, in a mortgage, your house is considered collateral towards the debt. If you default on repayment, the bank seizes your house, sells it and uses the proceeds to pay back the debt.
Functionally, this assumption is similar to the new business assumption except for the inclusion of the underlying collateral and encumbrance status into the picture.
NOTE:
· Assets can only be posted as collateral or specified as underlying only if they are unencumbered during the period between the Primary and Off-set bucket.
· The ability to filter assets based on their encumbrance period is supported.
The following steps are involved in applying the secured funding/financing assumption to cash flows:
1. Map inflows and outflows of the transaction to respective time buckets.
2. Calculate the corresponding interest amount.
3. Mark the assets selected as collateral or underlying as encumbered and update the encumbrance period.
See Defining a New Business Assumption, for information on the steps involved in specifying this assumption.
For example: If a bank is giving out an additional loan with reference to an existing loan by taking in some collateral. This is an example of a secured funding transaction, as the bank receives collateral in exchange for the cash given out. Assume that the outstanding end of period balance of the original loan is 10,000. The bank extends another 10% of the loan by taking in collateral against it, Borrow_1. Further, the 10% being extended is completely offset as a bullet payment in a single bucket (100% in offset bucket).
This scenario is defined in the business assumption as follows:
Business Assumption Definition |
|||||||
---|---|---|---|---|---|---|---|
Standard product type |
Primary bucket |
Primary value-leg 1 |
Offset bucket |
Offset value- leg 1 |
Collateral/underlying |
Encumbered value |
|
Loans |
7-7 days |
10 |
15-15 days |
100 |
Borrow_1 |
50% |
NOTE:
The encumbered value represents the portion of the collateral which is used to secure the loan .
The cash flow computation for this definition is explained as follows:
Buckets |
Cash flow |
||
---|---|---|---|
Contractual |
BaU |
||
Primary bucket |
7-7 days |
5000 |
4000 (5000- (10%*10000) |
Offset bucket |
15-15 days |
8000 |
9000 (8000+(10%*10000) |
Given that the example is based on loans, the primary leg involves a deduction in cash and the secondary leg involves an addition in cash flow. The deduction/addition will be reverse in nature if the product type is an asset. The application identifies whether to deduct/add a primary bucket and offset bucket based on the product type chosen.
This assumption supports changes in the value of the collateral posted due to changes in market valuation of transaction or changes in the contract value. This further leads to cash outflow.
This assumption impacts the denominator of LCR that is, increase in the outflow for the Legal Entity.
Some derivatives are secured by a collateral to cover losses arising from changes in mark-to-market valuations. For changes in the value of the derivative, additional collateral is posted resulting in a cash outflow. The valuation changes can be with Natural currency or Selected Currency. Valuation changes can be specified in Amount or Percentage. Here, both ratings and notches downgrade are not applicable.
The time buckets selected as part of the assumption parameters are the impacted time buckets.
NOTE:
The assumption specification and computation method for this subcategory correspond to that available as part of the Additional Collateral - Valuation Changes assumption type. This assumption is renamed as Valuation Changes in this version.
See the Defining a New Business Assumption, section for information on the steps involved in specifying this assumption.
The following steps are involved in applying the delay in cash flow timing assumption to cash flows:
1. Identify the original time bucket and calculate the cash outflow occurring in it due to the assumption.
2. Identify the corresponding revised time buckets and the cash inflow occurring in it, including penalties, if any.
3. If time-specific or critical obligation, record the delay and indicate a breach.
For example:
Based On |
Assumption Unit |
Assignment Method |
---|---|---|
Market Value |
Percentage |
Selected |
Legal Entity |
Product Type |
Time Bucket |
Valuation Change Impact |
---|---|---|---|
LE 1 |
PT 1 |
6-6 Days |
100% |
LE 2 |
PT 1 |
6-6 Days |
80% |
Account |
Legal Entity |
Product Type |
Market Value |
Valuation Change Impact |
---|---|---|---|---|
Account 1 |
LE 1 |
PT 1 |
100000 |
100000[=100% *100000] |
Account 2 |
LE 2 |
PT 1 |
200000 |
160000[=80%*200000] |
Account 3 |
LE 1 |
PT 1 |
300000 |
300000[=100%*300000] |
Account 4 |
LE 2 |
PT 1 |
400000 |
320000[=80%*400000] |
Legal Entity |
Product Type |
Outflow |
---|---|---|
LE 1 |
PT 1 |
400000[=100000 + 300000] |
LE 2 |
PT 1 |
480000[=160000 + 320000] |
Each of these does not calculate the impact of interest and has been explained in a principle perspective.
The examples provided for the business assumption do not illustrate the impact of interest cash flows.
For information on interest cash flow calculations from the perspective of assumptions, refer to the Impact of Assumptions on Interest Cash Flows section.
The example depicted in the section depicts only the additional outflow (delta) in the respective buckets due to the application of the assumption.
This section provides information about Value Change.
Topics:
· Available Stable Funding Factor
· Haircut
· Required Stable Funding Factor
Available stable funding (ASF) factors are the multiplication factors specified for liabilities and equities to calculate the Net Stable Funding Ratio (NSFR). This business assumption allows you to specify the ASF factor in percentage terms only. The percentage specified is applied to the selected combination to calculate the NSFR.
See the Defining a New Business Assumption, section for information on the steps involved in specifying this assumption. In the following example, ASF factor is applied on EOP balances for a selected list of products and the resulting ASF amounts are calculated.
Business Assumption Definition |
Balance Assignment |
||
---|---|---|---|
Product |
ASF Factor |
EOP Balance |
Available Stable Funding |
P1 |
85% |
10000000 |
8500000 |
P 2 |
100% |
200000 |
200000 |
Term deposits from retail |
90% |
320000 |
288000 |
Unsecured funding from non-financial corporates |
50% |
21000 |
10500 |
Haircuts are applied to high quality liquid assets to determine the stock of high quality liquid assets. This assumption does not affect the cash flows. Haircuts are allowed to be specified in percentage terms only. The haircut percentage specified will be applied to all assets with the dimensional attributes specified to calculate the stock of high quality liquid assets to compute the Liquidity Coverage Ratio (LCR).
See the Defining a New Business Assumption, section for information on the steps involved in specifying this assumption.
Business Assumption |
||
---|---|---|
Product Type |
Asset Level |
Haircut |
Cash |
Level 1 |
0% |
Covered bond |
Level 1 |
0% |
Covered bond |
Level 2A |
15% |
Common Equity |
Level 2B |
50% |
The assumption stores these haircuts at the account level granularity for further use while calculating the stock of HQLA for the purpose of LCR computation. The application then computes the haircut adjusted values of assets for inclusion in the stock of HQLA as follows:
Product Type |
Asset Level |
Haircut |
Market Value |
Haircut Adjusted Market Value |
---|---|---|---|---|
Cash |
Level 1 |
0% |
3000000 |
3000000 |
Covered bond |
Level 1 |
0% |
220000 |
187000 |
Covered bond |
Level 2A |
15% |
550000 |
412500 |
Common Equity |
Level 2B |
50% |
110000 |
55000 |
Required stable funding factors are the multiplication factors specified for assets to calculate the NSFR. This assumption allows you to specify the amount in percentage only. The percentage specified is applied to the selected combination to calculate the Net Stable Funding Ratio (NSFR).
See the Defining a New Business Assumption, section for information on the steps involved in specifying this assumption. In the following example, RSF factor is applied on EOP balances for a selected list of products and the resulting RSF amounts are calculated.
Business Assumption |
Computation |
||
---|---|---|---|
Product |
RSF Factor |
EOP Balance |
Required Stable Funding |
Non-renewable loans to financial entities and financial corporates |
0% |
200000 |
0 [= (200000*0%)] |
Gold |
50% |
150000 |
75000 [= (150000*50%)] |
Corporate bonds rated A+ to A- |
40% |
220000 |
0 [= (220000*40%)] |
The application supports the following types of intraday business assumptions:
1. Cash Flow Movement
§ Time Shift in Payments
§ Payments Default
2. Encumbrance
§ Withdrawal of Credit Lines
3. Incremental Cash Flow
§ Intraday Drawdown
§ Large Unexpected Payments
4. Value Change
§ Intraday Valuation Changes
The computations related to each assumption category and subcategory are explained in detail in the following sections.
This section provides information about Cash flow Movement.
Topics:
When a bank is under financial stress, customers and counterparties defer payments, leading to a reduction in Intraday liquidity. The delayed payments affect other payments in the pipeline and also affect the fulfillment of time-specific obligations.
Similarly, when certain obligations of the bank are brought forward in time during the day, this leads to a stressed situation as well. The assumption supports a time shift in payments- either a forward or backward shift.
The application supports a time shift of payments from one time bucket to another. You can apply this assumption to both payments made and payments received.
NOTE:
All payments within the time bucket are affected and shifted according to the assumption definition.
The following is an example for Time Shift in Payment assumption category:
The Time buckets are defined as follows:
Level 2 |
Level 1 |
Level 0 |
---|---|---|
09:00:00 to 09:24:00 |
09: 00:00 to 09:12:00 |
09:00:00 to 09:06:00 |
09:06:01 to 09:12:00 |
||
09:12:01 to 09:24:00 |
09:12:01 to 09:18:00 |
|
09:18:01 to 09:24:00 |
When a Business Assumption is defined:
· Dimensions: Legal entity - Payment system
· Based on: Payments received
· Time buckets from : 09:00:00 to 09:12:00
· Time buckets To: 09:12:01 to 09:24:00
· Percentage of delay: 60%
The payments made and received are as follows:
Time bucket (Level 0) |
Payments Received (Inflows) |
Payments Made (Outflows) |
---|---|---|
Amount |
Amount |
|
09:00:00 to 09:06:00 |
990 |
675 |
09:06:01 to 09:12:00 |
550 |
234 |
09:12:01 to 09:18:00 |
130 |
167 |
09:18:01 to 09:24:00 |
100 |
389 |
When the assumption is defined at level 1, the same is translated to level 0 buckets when the assignment method is selected.
In this example, the selected time bucket option as an assignment method is chosen. In this case, Inflows in the time period 09:00:00 to 09:12:00 moves to the time bucket 09:12:01 to 09:24:00. Since the ‘to’ bucket has two level 0 buckets, the assignment of the total amount, that is,(990 +550) must be done to both the buckets. After the assignment, the payments received and made are as follows:
Time bucket |
Payments Received (Inflows) |
Payments Made (Outflows) |
---|---|---|
Amount |
Amount |
|
09:00:00 to 09:06:00 |
396 |
675 |
09:06:01 to 09:12:00 |
220 |
234 |
09:12:01 to 09:18:00 |
592 |
167 |
09:18:01 to 09:24:00 |
562 |
389 |
Here, 60% of (990 +550) is delayed and is allocated equally between the level 0 buckets in the to bucket.
In this assumption, certain risky counterparties are assumed to default on their payments. Here, incoming payments from the respective counterparty type reduces to an extent as specified in the assumption definition. The counterparty is chosen through a dimensional selection.
For example, consider the following payments made and received for a legal entity - payment system combination.
Time Stamp |
Payments Received |
Payments Made |
||
---|---|---|---|---|
Payments |
Counterparty Type |
Payments |
Counterparty Type |
|
9:00 |
100 |
A |
|
|
9:15 |
30 |
A |
40 |
C |
9:30 |
|
|
90 |
C |
9:45 |
60 |
A |
150 |
B |
10:00 |
30 |
C |
100 |
B |
10:15 |
90 |
B |
300 |
A |
10:30 |
45 |
|
|
|
10:45 |
89 |
B |
70 |
D |
11:30 |
90 |
C |
100 |
B |
12:00 |
56 |
C |
90 |
E |
12:15 |
|
|
70 |
E |
12:30 |
78 |
A |
100 |
B |
13:15 |
|
|
20 |
C |
13:30 |
96 |
E |
|
|
14:30 |
200 |
E |
200 |
D |
15:00 |
250 |
A |
|
|
15:15 |
300 |
B |
87 |
D |
15:30 |
60 |
B |
40 |
E |
15:45 |
|
|
|
|
16:00 |
50 |
E |
99 |
A |
16:15 |
|
|
60 |
B |
16:30 |
40 |
D |
|
|
16:45 |
|
|
|
|
17:00 |
|
|
|
|
Assume that one of the counterparty types A is in complete default (100%). This means that the incoming payment from A reduces to zero. The payments to be received by A flows normally. The new set of Inflows and Outflows are as follows:
Time Stamp |
Payments Received |
Payments Made |
||
---|---|---|---|---|
Payments |
Counterparty Type |
Payments |
Counterparty Type |
|
9:00 |
|
A |
|
|
9:15 |
|
A |
40 |
C |
9:30 |
|
|
90 |
C |
9:45 |
|
A |
150 |
B |
10:00 |
30 |
C |
100 |
B |
10:15 |
90 |
B |
300 |
A |
10:30 |
45 |
|
|
|
10:45 |
89 |
B |
70 |
D |
11:30 |
90 |
C |
100 |
B |
12:00 |
56 |
C |
90 |
E |
12:15 |
|
|
70 |
E |
12:30 |
|
A |
100 |
B |
13:15 |
|
|
20 |
C |
13:30 |
96 |
E |
|
|
14:30 |
200 |
E |
200 |
D |
15:00 |
|
A |
|
|
15:15 |
300 |
B |
87 |
D |
15:30 |
60 |
B |
40 |
E |
15:45 |
|
|
|
|
16:00 |
50 |
E |
99 |
A |
16:15 |
|
|
60 |
B |
16:30 |
40 |
D |
|
|
16:45 |
|
|
|
|
17:00 |
|
|
|
|
In this example, the counterparty is in complete default.
However, a partial default in payments can also be defined. This can be defined by using the Assumption Unit in the Business Assumptions window. This consists of two options, Percentage and Value.
In case of a partial default, the remaining payments need to be shifted to a ‘Residual’ time bucket. If this bucket is specified at a higher level, the remaining payments are dispersed equally among the lower level buckets.
Examples: If the Assumption unit is in %, and 70% is the specified value, then 70% of the payments of the particular counterparty type is defaulted. The remaining 30% of payments are redistributed in the residual time bucket equally.
NOTE:
1. The assignment method in payments default is only the Selected time bucket.
2. When Assignment unit= value, the value specified is the value defaulted by the specific dimensional combination
3. By default, if no value or percentage is given, the assumption unit appears as 0 for the possible dimensional combinations.
4. The Residual time bucket is within the from time bucket or outside it.
For example, from 11:00:00 to 12:00:00; residual bucket: 11:45:00- 12:00:00
Or from bucket: 12:00:00 to 13:00:00; residual bucket: 14:15:00-14:30:00
The metrics affected by this assumption are as follows:
· Daily Maximum Intraday Liquidity Usage
· Total Payments
· Throughput
This section provides information about Encumbrance.
This assumption is a specific case when a bank is under financial stress, counterparties and correspondent banks may withdraw intraday credit lines, thus reducing the intraday liquidity available to the bank. The direct impact of this assumption is on non-committed credit lines; since they can be withdrawn completely.
This withdrawal of Credit Lines is expected at the start of the day. When credit lines are withdrawn, the available intraday liquidity at the start of the day reduces by the same extent.
The metric which impacts due to this effect is ‘Available Intraday Liquidity at the start of the business day’.
Sl. No. |
Sources |
---|---|
1 |
Central Bank reserves |
2 |
Collateral pledged at central bank |
3 |
Collateral pledged at ancillary systems |
4 |
Unencumbered liquid assets on the balance sheet |
5 |
Total credit lines available |
5a |
Of which secured |
5b |
Of which committed |
6 |
Balances with other banks |
7 |
Other |
In this assumption, depending on the dimension selected, the intraday credit lines are reduced by the extent of the withdrawal.
Topics:
This assumption enables banks to provide correspondent banking services only. The payment system participants value intraday credit on electronic funds transfer networks because payments and receipts are not perfectly synchronized. In addition, it eliminates the necessity of holding clearing balances large enough to cover all expected outflows of funds.
When a customer bank is in stress, to maintain adequate liquidity, the customer may resort to excessive drawdown of Intraday credit lines.
In the following example, the correspondent bank has 5 customers. Under normal conditions, credit lines extended to customers and usage are as follows:
Normal Conditions |
||||||
---|---|---|---|---|---|---|
Financial Institution Customer |
Intraday Credit Line Extended |
Intraday Usage |
Secured |
Committed |
Usage of Secured |
Usage of Committed |
Bank O |
85 |
70 |
40 |
50 |
31 |
21 |
Bank E |
80 |
60 |
25 |
10 |
26 |
30 |
Bank M |
45 |
30 |
30 |
40 |
21 |
6 |
Bank G |
35 |
25 |
30 |
30 |
12 |
13 |
Bank Z |
30 |
20 |
15 |
20 |
12 |
17 |
TOTAL |
275 |
205 |
140 |
150 |
102 |
87 |
One or more of the customer banks may be under stress, due to which maximum drawdown of Intraday credit lines may occur. The application supports the following dimensional inputs:
· Percentage of Drawdown
· Respective Customers
In this example, two customer banks are assumed to be under stress-Bank E and Bank O. Under this example, a 100% drawdown of credit lines by the customer is assumed. Hence the credit lines extended and used under stressed conditions are as follows:
Stress Conditions |
||||||
---|---|---|---|---|---|---|
Financial Institution Customer |
Intraday Credit Line Extended |
Intraday Usage |
Secured |
Committed |
Usage of Secured |
Usage of Committed |
Bank O |
85 |
85 |
40 |
50 |
40 |
50 |
Bank E |
80 |
80 |
25 |
10 |
25 |
10 |
Bank M |
45 |
30 |
30 |
40 |
21 |
6 |
Bank G |
35 |
25 |
30 |
30 |
12 |
13 |
Bank Z |
30 |
20 |
15 |
20 |
12 |
17 |
TOTAL |
275 |
240 |
140 |
150 |
110 |
96 |
Similarly, the application computes ‘Peak Usage’ for both normal conditions and stressed conditions.
When a drawdown assumption is applied at a higher level of time buckets, a single assignment within any level zero buckets of the said amount is considered. An example is as follows:
· Primary bucket (level 3): 08:00 - 09:00, level zero buckets being minutes
· Offset Bucket (Level 3):16:00- 17:00
· Available balance: 1000, assumption value= 40%
An amount of 400 is the outflow in the primary bucket and an inflow in the offset bucket for banks providing credit lines to its customers. This amount is allocated as a single amount in any level zero time bucket which constitutes primary and offset buckets; like 08:03( outflow 400) and 16:06( inflow 400); or 08:44 (outflow 400) and 16:02 (inflow 400).
This assumption allows the introduction of unforeseen large payments in the usual working day. The large payments can be either receipts or obligations or both. The introduction of large payments suddenly within the bank’s payment system causes a scenario of liquidity stress whereby the bank has to arrange such funds in very short notice. The assumptions allows the user to specify the payment system affected, the time bucket at which the payment(s) is introduced, and the amount. The amounts introduced are included in the time buckets as specified in the assumption.
As with other intraday assumptions, all the intraday metrics are calculated post-application of the assumption through a Stress Run.
The following is an example of this assumption:
This example contains actual payments made through a particular payment system and the impact of the introduction of a large payment within the other payments.
Actual payments with time stamp are as follows:
Payments made |
Payment system |
Time stamp |
Time bucket - 15 minutes |
---|---|---|---|
568 |
PS 1 |
12:08 |
12:01-12:15 |
876 |
PS 1 |
12:09 |
12:01-12:15 |
654 |
PS 1 |
12:12 |
12:01-12:15 |
655 |
PS 1 |
12:30 |
12:16-12:30 |
673 |
PS 1 |
12:31 |
12:31-12:45 |
890 |
PS 1 |
12:32 |
12:31-12:45 |
123 |
PS 1 |
12:44 |
12:31-12:45 |
876 |
PS 1 |
12:45 |
12:31-12:45 |
The Time bucket is defined as follows:
· Level 0: 1 minute
· Level 1: 15 minutes interval.
The bucketed payments at level 1 are as follows:
Time bucket |
Payments made |
---|---|
12:01-12:15 |
2098 |
12:16-12:30 |
655 |
12:31-12:45 |
2562 |
The business assumption is defined as follows:
· Based on: Payments made
· Payment system: PS1
· Time bucket: Level 1- 12:16 to 12:30
· Amount: 6765
The new bucketed payments after the application of the assumption are as follows.
Time bucket |
Payments made |
---|---|
12:01-12:15 |
2098 |
12:16-12:30 |
7420 |
12:31-12:45 |
2562 |
The new payment can be introduced at any level of time bucket. In this example, it is introduced in Level 1 of the definition.
This section includes information about Value Change.
In cases of particular currency shocks or a market-wide stress scenario, the value of the intraday assets held by the bank reduces to a certain extent. This assumption is applicable to all reporting banks.
The metric affected as a part of this assumption is “Available Intraday Liquidity at the start of the business day”.
This assumption considers the particular intraday asset and the percentage amount by which it must be reduced. The legal entity under which the asset is held is considered.
This assumption works on all available intraday assets which constitute the metric “Available Intraday Liquidity at the start of the business day” except credit lines.
Legal Entity |
Product |
Percentage |
---|---|---|
LE1 |
Product 1 |
70% |
LE2 |
Product 2 |
80% |
The valuation change is explained as follows:
· Product 1 is reduced to 30% of its prior value.
· Product 2 is reduced to 20% of its total value.
OFS LRM considers the impact on both principal and interest cash flows. This is treated in the following ways:
· When business assumption values are applied to both principal and interest cash flows.
· When assumption values are applied on principal cash flows only and interest is approximated.
· When interest is calculated and is not approximated.
When you select the approximate Interest parameter in the Run Definition window as Yes, then interest is approximated as explained below. If the parameter is selected as No, then the assumption values are applied on both principal and interest cash flows.
The following steps are involved in approximating interest:
1. Obtain the principal and interest cash flows under contractual terms.
2. Bucket the contractual cash flows based on the time buckets selected while distinguishing between interest and principal cash flows in each time bucket.
3. Calculate the outstanding balance in each bucket under contractual terms. The outstanding balance in the first time bucket will be the EOP balance. The formula for calculating the outstanding balance for each subsequent bucket is as follows:
Here,
O/S Balance: Outstanding Balance
CF: Cash Flows
4. Apply the business assumption to estimate principal cash flows. In the case of balance-based assumptions, this applies to the EOP balance. In the case of cash flow-based assumptions, this applies to the principal cash flows in a given bucket.
5. Calculate the outstanding balance in each bucket under business-as-usual or stress terms. The outstanding balance in the first time bucket will be the EOP balance. The formula for calculating the outstanding balance for each subsequent bucket is as follows:
Calculate the proportionate impact on interest cash flows in each bucket under business-as-usual or stress terms as per the following formula:
6. Calculate the total principal and interest cash inflows and outflows in each time bucket post assumption.
7. Calculate the total inflows, outflows, and net gap in each time bucket post assumption.
NOTE:
This computation is not applicable for the assumption types Rollover of Repos and Reverse Repos and Creation of Repos as the interest calculations are explicitly defined in these cases.
The following tables explain the impact of assumptions on Interest Cash Flows. The standard time buckets are Overnight, 1-7 Days, 8-15 Days, 16-30 Days, 1-3 Months, 3-6 Months, 6-12 Months, and > 1 Year. All examples consider an EOP balance of 5000 for time deposits.
Example 1: Impact on Interest Cash Flows under Growth Assumption
In this case, growth of 10 % on the EOP balance is defined in the 8-15 Days bucket. The offset bucket for this growth is a single bucket at 3-6 months. The cash flows are as shown below. The numbers for Contractual Principal and Interest cash flow are examples. The rest of the rows are computed values as per equations provided earlier in this section.
Condition |
Measure |
Cash Outflow |
|||||||
---|---|---|---|---|---|---|---|---|---|
Overnight |
1-7 Days |
8-15 Days |
16-30 Days |
1-3 Months |
3-6 Months |
6-12 Months |
> 1 Year |
||
Contractual |
Principal Cash Flow |
221.00 |
195.00 |
244.00 |
283.00 |
163.00 |
263.00 |
257.00 |
3374.00 |
Interest Cash Flow |
112.00 |
129.00 |
87.00 |
147.00 |
65.00 |
88.00 |
84.00 |
1477.42 |
|
O/S Balance |
5000.00 |
4779.01 |
4584.00 |
4340.00 |
4057.00 |
3894.00 |
3631.00 |
3374.00 |
|
Business Assumption |
Principal Cash Flow |
|
|
-500.00 |
|
|
500 |
|
|
O/S Balance |
5000.00 |
4779.00 |
4584.00 |
4840.00 |
4557.00 |
4394.00 |
3631.00 |
3374.00 |
|
Proportionate Interest Cash Flow |
0.00 |
0.00 |
0.00 |
0.0 |
16.94 |
8.01 |
11.30 |
0 |
The assumption cash flows provide the impact of the assumption only and not the change in the original cash flows due to the assumption.
Example 2: Impact on Interest Cash Flows under Rollover Assumption
In this case, a rollover of 10% is defined on the cash flows from the 1-7 Days bucket to the 3-6 Months bucket. The cash flows are as shown below. The numbers for Contractual Principal and Interest cash flow are examples. The rest of the rows are computed values as per equations provided earlier in this section.
Condition |
Measure |
Cash Outflow |
|||||||
---|---|---|---|---|---|---|---|---|---|
Overnight |
1-7 Days |
8-15 Days |
16-30 Days |
1-3 Months |
3-6 Months |
6-12 Months |
> 1 Year |
||
Contractual |
Principal Cash Flow |
221.00 |
195.00 |
244.00 |
283.00 |
163.00 |
263.00 |
257.00 |
3374.00 |
Interest Cash Flow |
112.00 |
129.00 |
87.00 |
147.00 |
65.00 |
88.00 |
84.00 |
1477.42 |
|
O/S Balance |
5000.00 |
4779.00 |
4584.00 |
4340.00 |
4057.00 |
3894.00 |
3631.00 |
3374.00 |
|
Business Assumption |
Principal Cash Flow |
|
-19.50 |
|
|
|
19.50 |
|
|
O/S Balance |
5000.00 |
4779.00 |
4603.50 |
4359.50 |
4076.50 |
3913.50 |
3631.00 |
3374.00 |
|
Proportionate Interest Cash Flow |
0.00 |
0.00 |
0.0 |
0.37 |
0.66 |
0.31 |
0.44 |
0.00 |
Example 3: Impact on Interest Cash Flows under Run-off Assumption
In this case, a 10% EOP Balance Run-off is defined from the 3-6 Months bucket to the 1-7 Days bucket. The cash flows are as shown below. The numbers for Contractual Principal and Interest cash flow are examples. The rest of the rows are computed values as per equations provided earlier in this section.
Condition |
Measure |
Cash Outflow |
|||||||
---|---|---|---|---|---|---|---|---|---|
Overnight |
1-7 Days |
8-15 Days |
16-30 Days |
1-3 Months |
3-6 Months |
6-12 Months |
> 1 Year |
||
Contractual |
Principal Cash Flow |
221.00 |
195.00 |
244.00 |
283.00 |
163.00 |
263.00 |
257.00 |
3374.00 |
Interest Cash Flow |
112.00 |
129.00 |
87.00 |
147.00 |
65.00 |
88.00 |
84.00 |
1477.42 |
|
O/S Balance |
5000.00 |
4779.00 |
4584.00 |
4340.00 |
4057.00 |
3894.00 |
3631.00 |
3374.00 |
|
Business Assumption |
Principal Cash Flow |
|
500.00 |
|
|
|
-500.00 |
|
|
O/S Balance |
5000.00 |
4779.00 |
4084.00 |
3840.00 |
3557.00 |
3394.00 |
3631.00 |
3374.00 |
|
Proportionate Interest Cash Flow |
0.00 |
0.00 |
0 |
-9.49 |
-16.94 |
-8.01 |
-11.3 |
0.00 |
When interest is calculated and is not approximated
If include Interest Cash Flow is selected as Yes and Approximate Interest is selected as No, the application includes the interest cash flow. If you have selected cash flow type in dimension and node as Principal, then assumption impacts only principal cash flows. If you have selected cash flow type in dimension and node as Interest, then assumption impacts only Interest cash flows. If you have not selected the cash flow type in dimension, then the assumption ignores the cash flow type. This means it will include both principal and interest cash flows.
NOTE:
Interest cash flows occurring contractually are considered during calculations and the impact of assumptions on interest is calculated under BAU and stress conditions if the option ‘Yes’ is selected as part of the Include Interest Cash Flows field in the Run Definition window. See Run Management Definition section for details.
The complete list of cash flow assignment methods are as follows:
· Selected time bucket only
· Equally to all time buckets up to and including the selected bucket
· In decreasing order to all time buckets up to and including the selected bucket
· In increasing order to all time buckets up to and including the selected bucket
· In proportion to the bucket size
Detailed in the following sections are illustrations for each cash flow assignment method. The standard Level 0 time buckets are Overnight, 1-7 Days, 8-15 Days, 16-30 Days, 1-3 Months, 3-6 Months, 6-12 Months, 1-5 years, and > 5 Years. All examples consider an EOP balance of 500000 for time deposits.
1. Selected Time Bucket
In this case, the assumption unit is applied to the cash flows and the assumption cash flows are mapped to the time bucket selected. If the assumption is not specified on Level 0 buckets, then the assignment to the lower buckets is done proportionately to the bucket size.
2. Equal Assignment
Here, cash flows assigned to each bucket are up to the selected bucket. Assignments are made equally to the selected level and further assignment is done till the most granular level. The formulae under different conditions are as follows:
a. EOP Balance Based Assumptions, Assumption Unit = Percentage
Where,
Level X Buckets: Higher granular buckets
Business Assumption |
Cash Flow Assignment |
||||
---|---|---|---|---|---|
Product |
From Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Revised Cash Flow |
Time Deposits |
8-15 Days |
5% |
10000 |
Overnight |
- 2500 [= 10000 - {(500000*5%)/2}] |
|
|
|
5000 |
1-7 Days |
- 7500 [= 5000 - {(500000*5%)/2}] |
b. Cash Flow Based Assumptions, Assumption Unit = Percentage
Where, n: Selected bucket
Business Assumption |
Cash Flow Assignment |
||||
---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Revised Cash Flow |
Time Deposits |
8-15 Days |
5% |
10000 |
Overnight |
9800 [= 10000 - {(8000*5%)/2}] |
|
|
|
5000 |
1-7 Days |
4800 [= 5000 - {(8000*5%)/2}] |
c. Assumption Unit = Value
Business Assumption |
Cash Flow Assignment |
||||
---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Revised Cash Flow |
Time Deposits |
8-15 Days |
3000 |
10000 |
Overnight |
8500 [= 10000 - (3000/2)] |
|
|
|
5000 |
1-7 Days |
3500 [= 5000 - (3000/2)] |
3. Proportionate Assignment
Cash flows are assigned to each bucket up to the selected bucket in proportion to the bucket size. Assignments are made proportionately to the selected level and further assignment is done till the most granular level. The formulae under different conditions are as follows:
a. EOP Balance Based Assumptions, Assumption Unit = Percentage
Where,
t: Number of days in the given Level X bucket
T: Total number of days up to the selected bucket Business Assumption |
Cash Flow Assignment |
||||
---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Revised Cash Flow |
Time Deposits |
8-15 Days |
5% |
10000 |
Overnight |
10000 [= 10000 - {(500000*5%)*0/7] |
|
|
|
5000 |
1-7 Days |
- 20000 [= 5000 - {(500000*5%)*7/7] |
b. Cash Flow Based Assumptions, Assumption Unit = Percentage
Business Assumption |
Cash Flow Assignment |
||||
---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Revised Cash Flow |
Time Deposits |
8-15 Days |
5% |
10000 |
Overnight |
10000 [= 10000 - {(8000*5%)*0/7}] |
|
|
|
5000 |
1-7 Days |
4600 [= 5000 - {(8000*5%)*7/7}] |
c. Assumption Unit = Value
Business Assumption |
Cash Flow Assignment |
||||
---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Revised Cash Flow |
Time Deposits |
8-15 Days |
3000 |
10000 |
Overnight |
10000 [= 10000 - (3000*0/7)] |
|
|
|
5000 |
1-7 Days |
2000 [= 5000 - (3000*7/7)] |
4. Decreasing Assignment
Cash flows are assigned to each bucket up to the selected bucket in decreasing order based on ranks assigned to cash flows. Assignments are made in decreasing order to the selected level and further assignment is done till the most granular level. The formulae under different conditions are as follows:
a. EOP Balance Based Assumptions, Assumption Unit = Percentage
Where,
Bucket Rank: This is the rank assigned to each Level X bucket within the bucket set. The rank is assigned in decreasing order that is, 1 is assigned to the last bucket in the set, 2 is assigned to the previous bucket, and so on.
Business Assumption |
Cash Flow Assignment |
|||||
---|---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Bucket Rank |
Revised Cash Flow |
Time Deposits |
1-3 Months |
5% |
10000 |
Overnight |
4 |
0 [= 10000 - (500000*5%)*4/10] |
|
|
|
5000 |
1-7 Days |
3 |
- 2500 [= 5000 - (500000*5%)*3/10] |
|
|
|
8000 |
8-15 Days |
2 |
3000 [= 8000 - (500000*5%)*2/10] |
|
|
|
3000 |
16-30 Days |
1 |
500 [= 3000 - (500000*5%)*1/10] |
b. Cash Flow Based Assumptions, Assumption Unit = Percentage
Business Assumption |
Cash Flow Assignment |
|||||
---|---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Bucket Rank |
Revised Cash Flow |
Time Deposits |
1-3 Months |
5% |
10000 |
Overnight |
4 |
9880 [= 10000 - (6000*5%)*4/10] |
|
|
|
5000 |
1-7 Days |
3 |
4910 [= 5000 - (6000*5%)*3/10] |
|
|
|
8000 |
8-15 Days |
2 |
7940 [= 8000 - (6000*5%)*2/10] |
|
|
|
3000 |
16-30 Days |
1 |
2970 [= 3000 - (6000*5%)*1/10] |
c. Assumption Unit = Value
Business Assumption |
Cash Flow Assignment |
|||||
---|---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Bucket Rank |
Revised Cash Flow |
|
|
|
|
|
|
|
Time Deposits |
1-3 Months |
3000 |
10000 |
Overnight |
4 |
8800 [= 10000 - (3000*4/10)] |
|
|
|
5000 |
1-7 Days |
3 |
4100 [= 5000 - (3000*3/10)] |
|
|
|
8000 |
8-15 Days |
2 |
7400 [= 8000 - (3000*2/10)] |
|
|
|
3000 |
16-30 Days |
1 |
2700 [= 3000 - (3000*1/10)] |
5. Increasing Assignment
Cash flows are assigned to each bucket up to the selected bucket in increasing order based on ranks assigned to cash flows. Assignments are made in increasing order to the selected level and further assignment is done to the most granular level. The formulae under different conditions are as follows:
a. EOP Balance Based Assumptions, Assumption Unit = Percentage
Where,
Bucket Rank: Rank assigned to each Level 0 bucket within the bucket set. The rank is assigned in increasing order i.e. 1 is assigned to the first bucket in the set, 2 is assigned to the next bucket, and so on.
Business Assumption |
Cash Flow Assignment |
|||||
---|---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Bucket Rank |
Revised Cash Flow |
Time Deposits |
8-15 Days |
5% |
10000 |
Overnight |
1 |
1666.67 [= 10000 - (500000*5%)*1/3] |
|
|
|
5000 |
1-7 Days |
2 |
- 11666.67 [= 5000 - (500000*5%)*2/3] |
b. Cash Flow Based Assumptions, Assumption Unit = Percentage
Business Assumption |
Cash Flow Assignment |
|||||
---|---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Bucket Rank |
Revised Cash Flow |
Time Deposits |
8-15 Days |
5% |
10000 |
Overnight |
1 |
9866.67 [= 10000 - (8000*5%)*1/3] |
|
|
|
5000 |
1-7 Days |
2 |
4733.33 [= 5000 - (8000*5%)*2/3] |
c. Assumption Unit = Value
Business Assumption |
Cash Flow Assignment |
|||||
---|---|---|---|---|---|---|
Product |
Time Bucket |
Run-off |
Contractual Cash Flow |
Time Bucket |
Bucket Rank |
Revised Cash Flow |
Time Deposits |
8-15 Days |
3000 |
10000 |
Overnight |
1 |
9000 [= 10000 - (3000*1/3)] |
|
|
|
5000 |
1-7 Days |
2 |
3000 [= 5000 - (3000*2/3)] |
NOTE:
If assumptions are specified on bucket levels other than Level 0, the assignment is done at the selected level and further assignment is done at the higher granular levels, using the same cash flow assignment methodology selected, till assignment has been made to Level 0 buckets. The only exception is the selected time bucket method, where the cash flow is assigned proportionately to higher granular bucket levels based on the bucket size. Previously, the assignment to more granular levels was done equally.
An illustration of assignment across multiple levels is provided in the following table. Suppose $1000 is assigned in increasing order to buckets at multiple levels. The assignment is done as follows:
Level 2 Bucket |
Rank |
Amount Assigned |
Level 1 Bucket |
Rank |
Amount Assigned |
Level 0 Bucket |
Rank |
Amount Assigned |
---|---|---|---|---|---|---|---|---|
1 - 3 Week |
1 |
333.33 [= (1000*1/3)] |
1 Week |
1 |
111.11 [= (333.33*1/3)] |
1 Week |
1 |
111.11 [= (111.11*1/1)] |
|
|
|
2 - 3 Week |
2 |
222.22 [= (333.33*2/3)] |
2 Week |
1 |
74.07 [= (222.22*1/3)] |
|
|
|
|
|
|
3 Week |
2 |
148.15 [= (222.22*2/3)] |
4 - 8 Week |
2 |
666.67 [= (1000*2/3)] |
4 - 5 Week |
1 |
222.22 [= (666.67*1/3)] |
4 Week |
1 |
74.07 [= (222.22*1/3)] |
|
|
|
|
|
|
5 Week |
2 |
148.15 [= (222.22*2/3)] |
|
|
|
6 - 8 Week |
2 |
444.44 [= (666.67*1/3)] |
6 Week |
1 |
74.07 [= (444.44*1/6)] |
|
|
|
|
|
|
7 Week |
2 |
148.15 [= (444.44*2/6)] |
|
|
|
|
|
|
8 Week |
3 |
222.22 [= (444.44*3/6)] |
6. New Business
End of Period (EOP) Asset Balance of Growth assumption allows you to select the method for cash flow assignment. Various options for cash flow assignment available are as follows:
§ Decreasing: In decreasing order to all time buckets up to and including the selected time bucket.
§ Equal: Equally to all time buckets up to and including the selected time bucket.
§ Proportional: In proportion to the time bucket size.
§ Selected: Selected time bucket only.
Decreasing Cash Flow assignment is done using the following formula:
Equal cash Flow assignment is done using the following formula:
Proportional Cash Flow assignment is done using the following formula:
Selected Cash Flow assignment is done using the following formula:
EOP Liability Balance Growth assumption allows you to select the method for cash flow assignment. Available options for cash flow assignment are as follows:
§ Decreasing: In decreasing order to all time buckets up to and including the selected time bucket.
§ Equal: Equally to all time buckets up to and including the selected time bucket.
§ Proportional: In proportion to the time bucket size.
§ Selected: Selected time bucket only.
Decreasing Cash Flow assignment is done using the following formula:
Equal Cash Flow assignment is done using the following formula:
Proportional Cash Flow assignment is done using the following formula:
Selected Cash Flow assignment is done using the following formula:
7. Drawdown
Funding Line of Credit allows you to select the method for cash flow assignment. This business assumption also allows you to select the method for the cash flow assignment. Available options for cash flow assignment are as follows:
§ Decreasing: In decreasing order to all time buckets up to and including the selected time bucket.
§ Equal: Equally to all time buckets up to and including the selected time bucket.
§ Proportional: In proportion to the time bucket size.
§ Selected: Selected time bucket only.
Decreasing Cash Flow assignment is done using the following formula:
Equal Cash Flow assignment is done using the following formula:
Proportional Cash Flow assignment is done using the following formula:
Selected Cash Flow assignment is done using the following formula:
Credit Line Drawdown allows you to select the method for the cash flow assignment. This assumption also allows you to specify the corresponding cash outflow for the specified cash inflow.
Available options for cash flows assignment for this assumption are as follows:
§ Decreasing: In decreasing order to all time buckets up to and including the selected time bucket.
§ Equal: Equally to all time buckets up to and including the selected time bucket
§ Proportional: In proportion to the time bucket size
§ Selected: Selected time bucket only.
Decreasing Cash Flow assignment is done using the following formula:
Equal Cash Flow assignment is done using the following formula:
Proportional Cash Flow assignment is done using the following formula:
Selected Cash Flow assignment is done using the following formula:
In the Run Definition window, assumptions can either be “Applied To” Changing Balance/Cash Flows or Original Balance/Cash Flows. This calculation is applied across business assumptions in a single Run. It is applicable across business assumptions based on the option selected as part of the Assumption Applied To field in the Run Definition window. This means that all assumptions are now executed sequentially, and the effects of the previous assumption are considered if the Changing Balance/Cash Flows option is selected in the Run Definition window.
1. Original Balance/Cash Flows:
When the user selects Original Balance/Cash Flows as a Run level parameter, it calculates the assumption based on the original balance. It has a standalone effect, or assumption, that value is always applied to the original balance. This basis applies to each subsequent business assumption where the effects of the previous assumption are ignored to estimate the impact of an assumption, such as the assumption cash flows arising out of the given assumption.
Example 1: In case of the original balance, when a Run is executed with two assumptions, the assumption value is defined on the original balance and not on the revised balance of the selected bucket (Refer table 2 - Customer 2)
Run 1: Original Balance (Run-off and Rollover)
Assumption 1: Run-off
Business Assumption Definition |
||||||||
---|---|---|---|---|---|---|---|---|
Legal Entity |
Customer |
From Bucket |
To Bucket |
Assumption Unit |
Run-off |
Assignment Method |
Assumption Category |
Based On |
Legal Entity 1 |
Customer 2 |
6-6Days |
3-3Days |
Percentage |
10% |
Equal |
Cash Flow Movement : Run - off |
Cash Flows |
Computation |
|||||
---|---|---|---|---|---|
To Bucket |
Contractual Cash Flow |
Run-off |
Revised Cash Flow |
||
(From Bucket) |
(To Bucket) |
(From Bucket) |
(To Bucket) |
||
Overnight |
20000 |
10000 |
500 |
18000 |
10500 |
|
|
|
(20000*10%)/4 |
|
(10000+500) |
1-1 Day |
|
11000 |
500 |
|
11500 |
|
|
|
(20000*10%)/4 |
|
(11000+500) |
2-2 Days |
|
22000 |
500 |
|
22500 |
|
|
|
(20000*10%)/4 |
|
(22000+500) |
3-3 Days |
|
12000 |
500 |
|
12500 |
|
|
|
(20000*10%)/4 |
|
(12000+500) |
Assumption 2: Rollover
Business Assumption Definition |
||||||||
---|---|---|---|---|---|---|---|---|
Legal Entity |
Customer |
From Bucket |
To Bucket |
Assumption Unit |
Rollover |
Assignment Method |
Assumption Category |
Based On |
Legal Entity 1 |
Customer 1 |
6-6Days |
7-7 Days |
Percentage |
10% |
Selected |
Cash Flow Movement: Rollover |
Cash Flows |
|
Customer 2 |
|
8-8 Days |
|
20% |
|
|
|
Computation |
|||||
---|---|---|---|---|---|
To Bucket |
Contractual Cash Flow |
Rollover |
Revised Cash Flow |
||
(From Bucket) |
(To Bucket) |
(From Bucket) |
(To Bucket) |
||
7-7 Days |
20000 |
7000 |
2000 |
14000 |
9000 |
8-8 Days |
|
10500 |
4000 |
|
14500 |
2. Changing Balance/Cash Flows:
This considers the cascading effect of an assumption on cash flows and EOP balance at a Run level parameter. Cascading effect refers to the scenario where the impact of the assumption value is calculated based on changing balance across assumptions and “not within an assumption”. However, the cascading effect can be seen across assumptions at Run level taking into consideration the impact of the previous assumption on the EOP balance or cash flows. In this case, the cash flows or EOP balances are recalculated after each assumption and the subsequent assumption values are calculated based on the updated cash flows or balances.
Example 1: In the case of changing balance, when a Run is executed with two assumptions, the assumption value is defined on the revised balance of the selected buckets.
Run 2: Changing Balance (Run-off and Cash Flow Delay)
Assumption 1: Run-off
|
Business Assumption Definition |
|||||||||
---|---|---|---|---|---|---|---|---|---|---|
Legal Entity |
Customer |
From Bucket |
To Bucket |
Assumption Unit |
Applied to |
Run-off |
Assignment Method |
Assumption Category |
Based On |
|
Legal Entity 2 |
Customer 3 |
6-6 Days |
3-3 Days |
Percentage |
Changing Balance |
10% |
Equal |
Cash Flow Movement: Run - off |
Cash Flows |
Computation |
|||||
---|---|---|---|---|---|
To Bucket |
Contractual Cash Flow |
Rollover |
Revised Cash Flow |
||
(From Bucket) |
(To Bucket) |
(From Bucket) |
(To Bucket) |
||
Overnight |
20000 |
10000 |
500 |
18000 |
10500 |
1-1Days |
|
11000 |
500 |
|
11500 |
2-2Days |
|
22000 |
500 |
|
22500 |
3-3Days |
|
12000 |
500 |
|
12500 |
Assumption 2: Cash Flow Delay
Business Assumption Definition |
|||||||
---|---|---|---|---|---|---|---|
Customer |
From Bucket |
To Bucket |
Assumption Unit |
Applied to |
Assignment Method |
Assumption Category |
Based On |
Customer 3 |
6-6 Days |
12-12 Days |
Percentage |
Changing Balance |
Selected |
Cash Flow Movement: Cash Flow Delay |
Cash Flows |
Computation |
||||
---|---|---|---|---|
Contractual Cash Flow (From Bucket) |
Contractual
Cash Flow |
Delay + Penalty |
Revised
Cash flow |
Revised
Cash flow |
18000 |
23000 |
10% + 5% |
16200 (18000-10%*18000) |
24890 |
In the above computation, when Run is executed with a new assumption category, assumption value is applied on the changing balance.
The Business Assumption Definition window has the following sections for the purpose of defining assumption parameters:
Topics:
· Time Bucket Definition Selection
· Cash Flow Interval Selection
· Assumption Parameter Specification
The details must be specified as follows:
· Folder: Select the Folder which is specific to the business assumption definition.
· Access Type: Choose the access type option, Read/Write or Read Only.
The details for each business assumptions are entered here as follows:
· Assumption Name: Specify the Assumption Name.
· Assumption Description: Enter the assumption description.
· Intraday Assumption: Select Yes or No if it is an intraday assumption.
Assumption properties are the basic parameters required for defining a business assumption. They include the following:
· Assumption Intraday Subcategory
· Based On
· Intraday Assignment Method - Leg 1 and 2
· Specify Collateral/Underlying
· Reporting Line Classification
The application supports multiple types of business assumptions, each of which is classified into 4 broad categories based on the behavior exhibited by the individual business assumptions. These categories are selected from a drop-down list as follows:
· Cash Flow Movement
· Encumbrance
· Incremental Cash Flow
· Value Change
The other assumption properties required to be specified by a user as part of this section will depend on the selection of the assumption category.
The application supports multiple types of business assumptions, each of which is classified into sub-categories based on the behavior exhibited by the individual business assumptions. These sub-categories are selected from a drop-down list as follows:
· Cash Flow Movement
§ Asset Sale
§ Cash Flow Delay
§ Cash Flow Movement
§ Delinquency
§ Prepayment
§ Recovery
§ Rollover
§ Run-off
· Incremental Cash Flow
§ Drawdown
§ Incremental Cash Flow
§ Liability Run-Off
§ New Business
§ Ratings Downgrade
§ Run-off
§ Secured Funding/Financing
§ Valuation Changes
· Encumbrance
§ Encumbrance
§ Ratings Downgrade
§ Valuation Changes
· Value Change
§ Available Stable Funding Factor
§ Haircut
§ Required Stable Funding Factor
The application supports multiple types of business assumptions, each of which are classified into subcategories based on the behavior exhibited by the individual business assumptions.
When Intraday Assumption is selected Yes in the Business Assumption Definition window the following subcategories are available for selection from the drop-down list:
· Cash Flow Movement
§ Time Shift in Payments
§ Payments Default
· Encumbrance
§ Withdrawal of Credit Lines
· Incremental Cash Flow
§ Intraday Drawdown
§ Large Unexpected Payments
· Value Change
§ Intraday Valuation Changes
This option determines the measure that the assumption values are applied to obtain cash flows. From the drop-down list, you are allowed to select the option on which different assumption values are applied.
The following table helps to understand the set of parameters for each assumption category and subcategory.
Assumption Category |
Assumption Subcategory |
Based On |
---|---|---|
Cash Flow Movement |
Cash Flow Movement |
· Cash Flows · EOP Balance · Fair Value · Fair Value of Collateral Posted · Fair Value of Collateral Received · High Run-off Category 1 Balance · High Run-off Category 2 Balance · High Run-off Category 3 Balance · Highly Stable Balance · Insured Balance · Less Stable Balance · Market Value · Market Value of Collateral Posted · Market Value of Collateral Received · Stable Balance · Uninsured Balance |
Run-Off |
· Cash Flows · EOP Balance · High Run-off Category 1 Balance · High Run-off Category 2 Balance · High Run-off Category 3 Balance · Highly Stable Balance · Insured Balance · Less Stable Balance · Stable Balance · Uninsured Balance · Unsecured Balance · Secured Balance |
|
Prepayment |
Cash Flows |
|
Cash Flow Delay |
Cash Flows |
|
Delinquency |
Cash Flows |
|
Recovery |
Cash Flows |
|
Rollover |
· Cash Flows · Fair Value of Collateral Posted · Fair Value of Collateral Received · Market Value of Collateral Posted · Market Value of Collateral Received · Non-qualifying Amount · Non-qualifying Less Stable Amount · Non-qualifying Stable Amount · Non-qualifying Unsecured Balance · Qualifying Amount · Secured Cash Flows · Unsecured Cash Flows |
|
Asset Sale |
· EOP Balance · Fair Value · Market Value |
|
Encumbrance |
Encumbrance |
· Downgrade Impact Value · Fair Value · Fair Value of Collateral Posted · Fair Value of Collateral Received · Fair Value of Excess Collateral · Fair Value of Required Collateral · Largest 30 Day Cumulative Collateral Amount · Market Value · Market Value of Collateral Posted · Market Value of Collateral Received · Market Value of Excess Collateral · Market Value of Required Collateral |
Ratings Downgrade |
Downgrade Impact Value |
|
Valuation Changes |
· Fair Value · Fair Value of Collateral Posted · Fair Value of Collateral Received · Fair Value of Excess Collateral · Fair Value of Required Collateral · Largest 30 Day Cumulative Collateral Amount · Market Value · Market Value of Collateral Posted · Market Value of Collateral Received · Market Value of Excess Collateral · Market Value of Required Collateral |
|
Incremental Cash Flow |
Incremental Cash Flow |
· Available Undrawn Amount · Cash Flows · Downgrade Impact Value · EOP Balance · Fair Value · Fair Value of Collateral Posted · Fair Value of Collateral Received · Fair Value of Excess Collateral · Fair Value of Required Collateral · General Ledger Balance · High Run-off Category 1 Balance · High Run-off Category 2 Balance · High Run-off Category 3 Balance · Highly Stable Balance · Insured Balance · Largest 30 Day Cumulative Collateral Amount · Less Stable Balance · Market Value · Market Value of Collateral Posted · Market Value of Collateral Received · Market Value of Excess Collateral · Market Value of Required Collateral · Non-Contractual Obligation Amount · Non Operational Balance · Penalty Free Portion of Stable Balance · Penalty Free Portion of Highly Stable Balance · Stable Balance · Undrawn Balance · Uninsured Balance |
Run-off |
· Available Undrawn Amount · Dividend Payable · EOP Balance · EOP Balance net of Underlying HQLA Inflow · EOP Balance net of Underlying HQLA Outflow · EOP amount with significant penalty or withdrawal · Encumbered Balance · Fair Value of Collateral Posted · Fair Value of Collateral Received · Fund Value · General Ledger Balance · High Run-off Category 1 Balance · High Run-off Category 2 Balance · High Run-off Category 3 Balance · Highly Stable Balance · Insured Amount Withdrawal without penalty · Insured Balance · Insured Non-operational Amount · Insured Operational Amount · Less Stable Balance · Less Stable Balance withdrawable amount without penalty · Market Value · Market Value of Collateral Posted · Market Value of Collateral Received · Minimum Amount Due · Minimum Reserves · Net Derivative Cash Flow net of collateral · Net Derivative Cash Inflow net of collateral · Net Intra-group Outflow · Net Intra-group Inflow · Non Contractual Obligation Amount · Non Operational Balance · Non-qualifying Amount · Non-Qualifying Unsecured Balance · Non-qualifying Stable Amount · Non-qualifying Less Stable Amount · Operational Balance · Penalty Free Portion of High Run-off Category 1 Amount · Penalty Free Portion of High Run-off Category 2 Amount · Penalty Free Portion of High Run-off Category 3 Amount · Penalty Free Portion of Highly Stable Balance · Penalty Free Portion of Stable Balance · Qualifying Amount · Returnable Asset Value · Secured Balance · Secured Lending inflow Amount · Segregated Inflow Amount · Stable Balance · Structured Outflow Amount · Uncleared Balance · Unencumbered Balance · Unencumbered Highly Stable Amount · Unencumbered Stable Amount · Unencumbered Less Stable Amount · Uninsured Amount Withdrawal without penalty · Uninsured Balance · Uninsured Non Operational Amount · Uninsured Operational Amount · Uninsured Operational Amount · Unsecured Lending Dues · Unsecured Balance · Unsettled Amount · Value of Fund |
|
Drawdown |
· Adjusted Undrawn Amount · Available Undrawn Amount · Portion of the undrawn amount that can be drawn in liquidity horizon period · Structured Outflow Amount · Undrawn Balance |
|
Liability Run-off |
Balance |
|
New Business |
EOP Balance |
|
Ratings Downgrade |
· Downgrade Impact Value · Underlying Mitigant Value |
|
Secured Funding/Financing |
· Cash Flows · EOP Balance |
|
Valuation Changes |
· Additional Collateral Amount For Derivatives · Collateral Valuation Change Amount · Contractually Due Collateral · Dividend Payable · Excess Collateral Due · Excess Contractual Obligation Amount · Fair Value · Fair Value of Collateral Posted · Fair Value of Collateral Received · Fair Value of Excess Collateral · Fair Value of Required Collateral · Largest 30 Day Cumulative Collateral Amount · Market Value · Market Value of Collateral Posted · Market Value of Collateral Received · Market Value of Excess Collateral · Market Value of Required Collateral · Net Derivative Cash Outflow net of collateral |
|
Value Change |
Available Stable Funding Factor |
· Cash Flows · EOP Balance · Less Stable Balance · NSFR Derivative Liabilities · Net NSFR Derivative Liabilities · Non-Operational Balance · Non-Operational Cash Flows · Operational Balance · Operational Cash Flows · Stable Balance · Standard Accounting Head Balance · Total Less Stable Balance · Total Less Stable Cash Flows · Total Stable Balance · Total Stable Cash Flows · Net CFR Derivative Liabilities · Variation Margin Received · Initial Margin Received |
Haircut |
· Fair Value · Market Value |
|
Required Stable Funding Factor |
· Additional Derivative Liability for RSF · Cash Flows · Derivative Liability Amount · EOP Balance · EOP Carrying Value · Encumbered Balance · Encumbered Carrying Value · Fair Value · Fair Value or Collateral Posted · GL Balance · Initial Margin Posted · Market Value · Market Value of Collateral Posted · NSFR Derivative Assets · Net NSFR Derivative Assets · Non Contractual Obligation Amount · Non-Operational Balance · Non-Operational Carrying Value · Operational Balance · Operational Carrying Value · Standard Accounting Head Balance · Standard Accounting Head Carrying Value · Undrawn Amount · Unencumbered Balance · Unencumbered Carrying Value · Net CFR Derivative Assets · Derivative Asset Amount · Variation Margin Posted · Default Fund Value |
When the Intraday Assumption is selected as Yes in the Business Assumption Definition window, the following set of parameters is shown for each assumption category and sub-category:
Intraday Assumption Category |
Intraday Assumption Subcategory |
Based On |
---|---|---|
Cash Flow Movement |
Time Shift in Payments |
Payments Received Payments Made |
Payments Default |
Payments Received |
|
Encumbrance |
Withdrawal of Credit Lines |
Undrawn Amount |
Incremental Cash Flow |
Intraday Drawdown |
Undrawn Amount |
Large Unexpected Payments |
Payments Made Payments Received |
|
Value Change |
Intraday Valuation Changes |
Available Intraday liquidity |
This option determines if only the off-set leg or both the primary and the off-set legs are required to specify the business assumption value as part of the assumption specification section. This is based on the type of business assumption being specified. For instance, in case of rollover, prepayments, Run-offs, and so on, assumption values are applied only to the off-set leg as the primary leg of the transaction has already occurred in the past. However, in case of a new business assumption, such as deposit growth, both the primary leg (amount deposited) and the off-set leg (repayment of the amount deposited) are required as both legs occur in the future. This selection is determined by the assumption subcategory selected. In the case of subcategories where only one option is applicable, the selection has defaulted to One in an un-editable mode. In cases where both values are applicable, Two can be selected.
The following options are present:
· One: If One is selected as assumption leg, then only one column appears for entering the off-set assumption value.
· Two: If Two is selected as the assumption leg, then two columns appear for entering primary assumption value and secondary or off-set value.
This option determines how the primary assumption value is allocated to time buckets. There are specific methods in which the assumption value can be distributed across buckets. Assignment methods determine how the primary assumption values are assigned to multiple buckets to determine the cash flows. Leg 1 is applicable when only one leg of the transaction is affected, such as when the assumption legs field value is selected as One.
The options are as follows:
· Selected Time Bucket
· Increasing
· Decreasing
· Equal
· Proportionate
This method assigns the cash flows only to the time buckets against which the assumption value is specified. If the assumption is not specified on Level 0 buckets, then the assignment to the more granular buckets is done proportionately to the bucket size.
The formula is as follows:
The time buckets used for computation are as follows:
N_BUCKET_NO |
V_BUCKET_NAME |
V_BUCKET_NAME_CATEGORY |
---|---|---|
1 |
Overnight |
Overnight |
2 |
1-10Days |
1-15Days |
3 |
11-15Days |
1-15Days |
4 |
16-20Days |
16-30Days |
5 |
21-25Days |
16-30Days |
6 |
26-30Days |
16-30Days |
The following example shows the allocation of cash flows when the assumption value is specified for a Level 0 bucket.
Assumption Category |
Assumption Unit |
Applied to |
Assignment Method |
Based On |
---|---|---|---|---|
Cash Flow Movement: Run-off |
Percentage |
Original Balance |
Selected |
Cash Flow |
Business Assumption |
Computation |
||||||||
---|---|---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
To Bucket |
Run-off % |
Contractual Cash Flow |
Contractual Cash Flow |
Run-off |
Revised Cash flow |
Revised Cash flow |
Time Deposits |
Customer 1 |
10-10 Days |
5-5 Days |
10% |
30000 |
23000 |
3000 (30000* 10%) |
33000 |
20000 |
However, this allocation differs for Levels other than Level 0 buckets as Illustrated in the following example.
The following example shows the selected Cash Flow assignment method on Level 1 buckets.
Business Assumption |
Computation |
||||||||
---|---|---|---|---|---|---|---|---|---|
Customer |
From Bucket |
To Bucket |
Run-off % |
Contractual Cash Flow |
To Bucket |
Contractual Cash Flow |
Run-off |
Revised Cash flow |
Revised Cash flow |
Customer 1
|
16-30Days |
1-15Days |
10% |
50000
|
1-10Days |
21000 |
5000 (50000*10%) |
45000 (50000-5000) |
24333.33 {21000+(5000*10/15)} |
|
|
|
|
|
11-15Days |
15000 |
|
|
16666.67 {15000+(5000*5/15)} |
3. Increasing assignment:
The cash flows are assigned to each bucket up to the selected bucket in increasing order based on ranks assigned to cash flows. Assignments are made in increasing order to the selected level and further assignment is done until the most granular level.
The formulae under different conditions are as follows:
a. When, Cash Flow Based Assumptions, Assumption Unit = Percentage
b. When Assumption Unit = Value
The following example shows Increasing Cash Flow assignment method based on Cash Flow.
Assumption Category |
Assumption Unit |
Applied to |
Assignment Method |
Based On |
---|---|---|---|---|
Cash Flow Movement: Run-off |
Percentage |
Original Balance |
Increasing |
Cash Flow |
Business Assumption |
Bucket |
Computation |
|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
To Bucket |
Run-off % |
To Bucket |
Bucket Rank |
Contractual
Cash Flow |
Contractual
Cash Flow |
Run-off (Value) |
Revised
Cash flow |
Revised
Cash flow |
Assets |
Customer 1 |
10-10Days |
3-3Days |
10% |
Overnight |
1 |
30000 |
20000 |
300 |
27000 |
20300 |
|
|
|
|
|
1-1Days |
2 |
|
21000 |
600 |
|
21600 |
|
|
|
|
|
2-2Days |
3 |
|
19000 |
900 |
|
|
|
|
|
|
|
3-3Days |
4 |
|
27000 |
1200 |
|
28200 |
c. When, EOP Balance Based Assumptions, Assumption Unit = Percentage
The following example shows Increasing Cash Flow assignment method based on EOP Balance. Here, EOP Balance (Time Deposits) is assumed as 300000.
Assumption Category |
Assumption Unit |
Applied to |
Assignment Method |
Based On |
---|---|---|---|---|
Incremental Cash Flow: Run-off |
Percentage |
Original Balance |
Increasing |
EOP Balance |
Business Assumption |
Computation |
|||||||
---|---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
Run-off % |
Bucket Rank |
Primary Bucket |
Contractual Cash Outflow (Primary Bucket) |
Run-off |
Revised Cash Outflow (Primary Bucket) |
Time Deposits |
Customer 1
|
1-1 Days |
10 |
1 |
Overnight |
20000 |
10000 |
10000 |
|
|
|
|
2 |
1-1 Days |
30000 |
20000 |
20000 |
4. Decreasing Assignment
The Cash flows are assigned to each bucket up to the selected bucket in decreasing order based on ranks assigned to cash flows. Assignments are made in decreasing order to the selected level and further assignment is done until the most granular level.
The formulae under different conditions are as follows:
a. When, Cash Flow Based Assumptions, Assumption Unit = Percentage
b. When Assumption Unit = Value
The following example shows Decreasing Cash Flow assignment method based on Cash Flow.
Assumption Category |
Assumption Unit |
Applied to |
Assignment Method |
Based On |
---|---|---|---|---|
Cash Flow Movement: Run-off |
Percentage |
Original Balance |
Decreasing |
Cash Flow |
Business Assumption |
Bucket |
Computation |
|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
To Bucket |
Run-off % |
To Bucket |
Bucket Rank |
Contractual Cash Flow |
Contractual Cash Flow |
Run-off (Value) |
Revised Cash flow |
Revised Cash flow |
Assets |
Customer 1 |
10-10Days |
3-3Days |
10% |
Overnight |
4 |
30000 |
20000 |
1200 |
27000 |
21200 |
|
|
|
|
|
1-1Days |
3 |
|
21000 |
900 |
|
21900 |
|
|
|
|
|
2-2Days |
2 |
|
19000 |
600 |
|
19600 |
|
|
|
|
|
3-3Days |
1 |
|
27000 |
300 |
|
30000 |
c. When, EOP Balance Based Assumptions, Assumption Unit = Percentage
Assumption Category |
Assumption Unit |
Applied to |
Assignment Method |
Based On |
---|---|---|---|---|
Incremental Cash Flow: Run-off |
Percentage |
Original Balance |
Decreasing |
EOP Balance |
The following example shows Decreasing Cash Flow assignment method based on EOP Balance. Here, EOP Balance (Time Deposits) is assumed as 300000.
Business Assumption |
Computation |
|||||||
---|---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
Run-off % |
Bucket Rank |
Primary Bucket |
Contractual Cash Outflow (Primary Bucket) |
Run-off |
Revised Cash Outflow (Primary Bucket) |
Time Deposits |
Customer 1 |
1-1 Days |
10
|
2 |
|
Overnight |
|
20000 |
|
|
|
|
1 |
|
1-1 Days |
|
30000 |
5. Equal Assignment
The Cash flows are to be assigned equally up to the selected bucket. Assignments are made equally to the selected level and further assignment is done until the most granular level.
The formulae under different conditions are as follows:
a. When, Cash Flow Based Assumptions, Assumption Unit = Percentage
b. When Assumption Unit = Value
The following example shows Equal Cash Flow assignment method based on Cash Flow. Here, Level X buckets are assumed as a higher granular bucket.
Cash Flow Movement- Run-off |
Percentage |
Original Balance |
Equal |
Cash Flow |
---|---|---|---|---|
Cash Flow Movement: Run-off |
Percentage |
Original Balance |
Equal |
Cash Flow |
Business Assumption |
Bucket |
Computation |
|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
To Bucket |
Run-off % |
To Bucket |
Bucket Rank |
Contractual Cash Flow |
Contractual Cash Flow |
Run-off (Value) |
Revised Cash Flow |
Revised Cash Flow |
Assets |
Customer 1 |
10-10Days |
5-5 Days |
10% |
Overnight |
30000 |
20000 |
500 |
27000 |
20500 |
|
|
|
|
|
|
1-1Days |
|
21000 |
500 |
|
21500 |
|
|
|
|
|
|
2-2Days |
|
19000 |
500 |
|
|
|
|
|
|
|
|
3-3Days |
|
27000 |
500 |
|
27500 |
|
|
|
|
|
|
4-4Days |
|
13000 |
500 |
|
13500 |
|
|
|
|
|
|
5-5Days |
|
11000 |
500 |
|
11500 |
|
c. When, EOP Balance Based Assumptions, Assumption Unit = Percentage
The following example shows Equal Cash Flow assignment method based on EOP Balance. Here, EOP Balance (Time Deposits) is assumed as 500000.
Assumption Category |
Assumption Unit |
Applied to |
Assignment Method |
Based On |
---|---|---|---|---|
Incremental Cash Flow: Run-off |
Percentage
|
Original Balance
|
Equal
|
EOP Balance |
Business Assumption |
Computation |
||||||
---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
Run-off % |
Primary Bucket |
Contractual Cash Outflow (Primary Bucket) |
Run-off |
Revised Cash Outflow (Primary Bucket) |
Time Deposits |
Customer 1
|
1-1 Days |
10 |
Overnight |
20000 |
50000 |
45000 20000+(50000/2) |
|
|
|
|
1-1 Days |
30000 |
|
|
6. Proportionate Assignment
The Cash flows are assigned to each bucket up to the selected bucket in proportion to the bucket size. Assignments are made proportionately to the selected level and further assignment is done until the most granular level.
The formulae under different conditions are as follows.
a. When, Cash Flow Based Assumptions, Assumption Unit = Percentage
b. When Assumption Unit = Value
The following example shows Proportionate Cash Flow assignment method based on Cash Flow.
Here,
t = Number of days in the given Level x bucket
T= Total number of days up to the selected bucket
Assumption Category |
Assumption Unit |
Applied to |
Assignment Method |
Based On |
---|---|---|---|---|
Cash Flow Movement: Run-off |
Percentage |
Original Balance |
Proportionate |
Cash Flow |
The following time buckets are considered for the computation:
N_BUCKET_NO |
V_BUCKET_NAME |
---|---|
1 |
Overnight |
2 |
1-10Days |
3 |
11-15Days |
4 |
16-20Days |
5 |
21-25Days |
6 |
26-30Days |
Business Assumption |
Computation |
|||||||||
---|---|---|---|---|---|---|---|---|---|---|
Product |
Customer |
From Bucket |
To Bucket |
Run-off % |
To Bucket |
Contractual Cash Flow |
Contractual Cash Flow |
Run-off (Value) |
Revised Cash Flow |
Revised Cash Flow |
Assets |
Customer 1 |
26-30Days |
11-15Days |
10% |
Overnight |
30000 |
20000 |
0 |
27000 |
20000 |
|
|
|
|
|
1-10Days |
|
21000 |
2000 |
|
23000 |
|
|
|
|
|
11-15Days |
|
19000 |
1000 |
|
20000 |
c. When, EOP Balance Based Assumptions, Assumption Unit = Percentage
The following example shows Proportionate Cash Flow assignment method based on EOP Balance. Here, EOP Balance (Time Deposits) is assumed as 300000.
Assumption Category |
Assumption Unit |
Applied to |
Assignment Method |
Based On |
---|---|---|---|---|
Incremental Cash Flow: Run-off |
Percentage |
Original Balance |
Proportionate |
EOP Balance |
Business Assumption |
Computation |
|||||||
---|---|---|---|---|---|---|---|---|
Product |
Customer |
Primary Bucket |
Run-off |
Bucket Rank |
Primary Bucket |
Contractual Cash Outflow (Primary Bucket) |
Run-off |
Revised
Cash Outflow |
Customer 1 |
1-10Days |
10 |
1 |
|
Overnight |
20000 |
0(300000*10%)*0/10 |
20000 |
|
|
|
2 |
|
1-10Days |
30000 |
30000 |
60000 |
This option determines how the secondary assumption value is allocated to time buckets. Secondary assumption value refers to the off-set value which can be selected in addition to the primary assumption value. Assignment methods determine how the primary assumption values are assigned to multiple buckets to determine the cash flows. Leg 2 is applicable when only two legs of the transaction are affected, such as when the assumption legs field value is selected as Two. The secondary assumption value is the off-set value specified by you in addition to the primary assumption value and is applicable only when the assumption leg is selected as Two. This is applicable only when assumption legs are selected as Two.
The options are as follows:
· Selected Time Bucket
· Increasing
· Decreasing
· Equal
· Proportionate
The detailed calculations pertaining to each assignment method are explained in section Assignment Method Leg 1.
When the Intraday Assumption is selected as Yes in the Business Assumption Definition window the Intraday Assignment Method - Leg 1 and 2 are applicable.
For Assumptions which include time bucket as a dimension, Assumption methods are defined in the Business Assumptions window. For each leg of the assumption, the intraday assignment method is chosen separately. Assignment methods signify the method by which payments at a higher level intraday time bucket flow down to lower level intraday time buckets. Assignment methods for intraday assumptions are listed as follows:
· Selected Time Bucket
In this method, payments from one time bucket are aggregated and shifted to another selected time bucket. The size of the source and target time buckets is not the same; since the aggregation and /or dispersion occurs at a higher time bucket level. This assignment method is available in all assumptions. For a payments shift assumption, if the selected buckets are at a higher level, payments get aggregated and dispersed equally at all constituent lower buckets. In case of a drawdown assumption, if the selected bucket is at a higher level, a single drawdown for the input value occurs at any level zero bucket of the higher level. The same principle holds good for the offset bucket as well. For a payments default assumption, if the selected residual time bucket is at a higher level, the payments are dispersed equally at all constituent lower buckets.
· Parallel Time Bucket
In this method, payments from one bucket are shifted in parallel to another bucket of the same level as the source bucket. In other words, a constant shift happens to all level 0 buckets constituting the higher level buckets.
This assignment method is available only for Payments Shift assumption:
For example: Within a Payments Shift Assumption, if
· Source bucket (level 3): 11-12 hrs
· Target Bucket- (level 3): 9-10 hrs
If the level 0 buckets are in minutes, then all payments under 11:00 moves to 09:00 bucket, all payments under 11:01 moves to 09:01 bucket, all payments from 11:02 moves to 09:02 and so on.
For a drawdown and value change assumption, the parallel bucket option is not applicable.
This option helps to identify the unit based on which the assumption is defined. The options which can be selected from the drop-down list are as follows:
· Amount
· Percentage
· Units
NOTE:
Units are only applicable on the selection of the subcategory Asset Sale as part of the Cash Flow Movement assumption category).
This option is applicable only when the assumption unit is selected as Amount. If the assumption unit is selected as Amount then the following options are displayed:
· Natural Currency
· Currency Selection
NOTE:
If you select Natural Currency, then the currency must be selected as part of dimension selection.
Ratings downgrade caters to the downgrade of a legal entity’s rating. This option identifies the downgrade level for the purpose of triggering the need for additional collateral. This parameter identifies the downgrade specified for a legal entity.
This downgrade can be specified as follows:
· Rating Based
· Notches Based
NOTE:
This is applicable only on the selection of the subcategory Encumbrance and Ratings Downgrade as part of the assumption categories Incremental Cash Flow or Encumbrance.
This option determines if one or two off-set legs are required to specify the business assumption value as part of the assumption specification section. This is based on the product type. For instance, for loans, deposits, and so on, there is only one primary leg and one off-set leg whereas for swaps there are two primary and two off-set legs for the same transaction.
One of the following options is selected:
· One: If One is selected, only one column for the specification of each assumption leg is displayed as part of the assumption specification table that is, one column each for primary and off-set assumption value specification.
· Two: If Two is selected, two columns are displayed for specifying each assumption leg that is two columns each for primary and off-set assumption value specification.
The Charge Penalty options are as follows:
· Yes: If Yes is selected, an additional column in the assumption value grid is added to specify the penalty.
· No: If No is selected, no Penalty is required.
NOTE:
This option is enabled only for the following assumption sub-categories under Cash Flow Movement category:
· Cash Flow Movement
· Prepayment
· Cash Flow Delay
This option determines if existing unencumbered assets are required to be posted as collateral or underlying in the case of secured funding and repo transactions. The options are as follows:
· Yes: If Yes is selected, existing assets can be posted as collateral for each row in the assumption specification table.
· No: If No is selected, no collateral is required.
When the assumption category is selected as Cash Flow Movement and the subcategory is selected as Asset Sale, Sale Specification By field is allowed for selection. The two ways to specify a sale are as follows:
· Individual Assets: You can specify a sale by selecting the assets individually. In the dimension browser, you have only the Asset browser. Here, you must select each individual asset that you need to sell.
· Dimensions: You can select the relevant dimensions such as Product, Currency, and Rating. You are allowed to select individual members within this and all assets which have asset dimensional attributes that are selected are sold. All individual assets that have the attributes of the selected dimensions and dimension members are sold.
The field is available for reporting line configuration. You can use this field to configure reporting line items for a specific assumption criterion. The replines are seeded in the FSI_LRM_REP_LINE_ATTR_DETAILS table. Reporting Line Classification is enabled when the following assumption category and subcategory are selected.
Assumption Category |
Assumption Sub- Category |
---|---|
Value Change |
Available Stable Funding factor |
Required Stable Funding factor |
Filters are enabled when the following assumption category and subcategory are selected. You can select one or multiple dimensions from the list of dimensions displayed in the dimension browser. The application allows you to select a maximum of seven dimensions. The selected dimensions are displayed in the Filter section.
Assumption Category |
Assumption Subcategory |
---|---|
Incremental Cash Flows |
Run-off |
Drawdown |
|
Valuation Change |
|
Cash Flow Movement |
Rollover |
Value Change |
Available Stable Funding factor |
Required Stable Funding factor |
|
Haircut |
The application provides two types of filters:
· Inclusion Filters: The application allows you to add a maximum of seven dimensions. If you want to add more, the dimensions with common hierarchies can be added as filters.
· Exclusion Filters: If you want to exclude any hierarchy from the common dimensions, they can be added as exclusion filters.
For example, you want to include all the accounts of type deposits/Term Deposits but exclude only CASA from deposits. Select deposits in the inclusion filter, as a result, all accounts of type deposits get included. Add CASA in the Exclusion filter, as a result, the CASA type of deposits are excluded from the assumption definition.
The steps to select Dimensions are as follows:
· Dimension Selection: One or more dimensions can be selected from a list of dimensions displayed in the dimension browser. The selected dimensions are displayed in the Dimension Selection section and as columns in the Assumption Specification table. You are allowed to drag and drop the dimensions which are displayed as part of the Dimension Selection section for sequencing the dimensions. If the sequence of dimensions is changed, the respective columns in the Assumption Specification table are re-arranged.
If new dimensions are added to an existing definition, the Assumption Specification table is reformed, and all assumption values are re-set.
· Dimension Member Selection: One or more members can be selected for each selected dimension. These are displayed as row items in the Assumption Specification table. If you change any dimension member or add any new dimension to the existing definition, the grid will be reset.
For an explanation on how to add dimensions that are displayed in the BAU window under the Dimension browser, refer to the Aggregation Dimension Selection section.
For more details on list dimensions, refer to the Annexure: Functional Details, LRS Data Flow and Dimensions section.
The steps to select Time Buckets are as follows:
· Time Bucket Definition Selection: One time bucket definition can be selected from a list of definitions displayed in the Time Bucket Definition browser. Only one time bucket can be selected. The values which are defined in the Time Bucket Definition window are displayed here. For more information refer to the Time Buckets section. On selection of the time bucket definition, it is displayed in the time bucket definition selection against both <Time Bucket 1> Selection and <Time Bucket 2> Selection.
· <Time Bucket 1> Selection: One or more time buckets from the given time bucket definition can be selected as part of <Time Bucket 1> Selection. The selected time buckets are displayed as row items in the Assumption Specification table. The name of this parameter changes depending upon on the assumption category selected as per the following mapping:
Assumption Category |
<Time Bucket 1> Selection |
---|---|
Cash Flow Movement |
From Bucket Selection |
Incremental Cash Flows |
Primary Bucket Selection |
Encumbrance |
Not Applicable |
Value Change |
Not Applicable |
· <Time Bucket 2> Selection: One or more time buckets defined as part of the selected time bucket definition can be selected as part of <Time Bucket 2> Selection. The time buckets selected are displayed as drop-down values in the <Time Bucket 2> column in each row of the Assumption Specification table. The name of this parameter changes depending upon the assumption category selected as per the following mapping:
Assumption Category |
<Time Bucket 2> Selection |
---|---|
Cash Flow Movement |
To Bucket Selection |
Incremental Cash Flows |
Off-set Bucket Selection |
Encumbrance |
Not Applicable |
Value Change |
Not Applicable |
· For assumption category Incremental Cash Flow, sub-category Liability Run-Off, the following time buckets are available:
§ Inaccessibility End Bucket:
This is a single selection from a list of time buckets selected as part of the Inaccessibility End Bucket parameter in the Time Bucket Definition Selection section. The last day of the Inaccessibility End Bucket is the end of the market inaccessibility period. Day 1 is the start of the inaccessibility period. If no time bucket is selected, then the market inaccessibility period is 0.
§ Restoration End Bucket:
This is a single selection from a list of time buckets selected as part of the Restoration End Bucket parameter in the Time Bucket Definition Selection section. This time bucket is greater than the Inaccessibility End Bucket. The last day of the Restoration End Bucket is the end of the restoration period. Inaccessibility End Day+1 is the start of the restoration period.
— The minimum Balance is specified as an amount (in terms of the assumption currency).
— The Restoration percentage is specified as a percentage.
NOTE:
· Time Bucket Selection is not applicable when the assumption category is selected as value change.
· The values which are defined in the Time Bucket definition window are displayed as part of Time Bucket Definition Selection section in the Business Assumptions Definitions window.
· When the Intraday Assumption is selected as Yes in the Business Assumption Definition window, only the Intraday Time Buckets are displayed in this section.
The Cash flow interval selection allows the user to select appropriate cash flow time bands as required in the business assumption. This field appears and is applicable only to the following combination of category, subcategory and based on measure.
Category |
Sub category |
Based on measures |
---|---|---|
Value change |
Required stable funding factor |
Cash flows |
Available stable funding factor |
Cash flows Total stable cash flows Total less stable cash flows Operational cash flows Non-operational cash flows |
For these combinations, the selection of a cash flow interval is mandatory for assumption definition. By choosing the cash flow intervals, the user allows the cash flows to be grouped in time in accordance with the definition.
The Assumption Parameter Specification table is generated after all the assumption properties, dimensions, and time buckets are selected. This displays the dimensions selected as column values and the dimension members as row values. Additionally, it displays one or two time bucket columns based on the assumption properties selected.
The names of these columns change based on the assumption category selected as follows:
Table 94 Assumption Specification
Assumption Category |
<Time Bucket 1> |
<Time Bucket 2> |
---|---|---|
Cash Flow Movement |
From Bucket |
To Bucket |
Incremental Cash Flows |
Primary Bucket |
Off-set Bucket |
Encumbrance |
From Bucket |
To Bucket |
Value Change |
Not Applicable |
Not Applicable |
NOTE:
Time bucket definitions must be created before defining a new business assumption. Refer to the Time Buckets section for more information.
In the Oracle Financial Services Analytical Applications Infrastructure home screen, select Financial Services Liquidity Risk Management.
To open the Business Assumptions window, select Liquidity Risk Management then select Business Assumptions on the Left-Hand Side (LHS) menu.
Figure 22 Business Assumption Summary
The definitions based on the search criteria are listed under List of Business Assumptions.
This is the search section which contains multiple parameters. You can specify one or multiple search criteria in this section. When you click Search, depending upon the search criteria, this filters and displays the relevant search combination parameters under the Business Assumption Summary as a list.
The Business Assumption Summary window displays the following fields.
Search Field or Icon |
Description |
---|---|
Search |
This icon allows you to search the Assumption based on the search criteria specified. Search criteria include a combination of Folder, Assumption Name, Assumption Category, Time Bucket Definition, Status, and Active Status. The business assumptions displayed in the List of Business Assumptions table are filtered based on the search criteria specified when clicking this icon. |
Reset |
This icon allows you to reset the search section to its default state that is, without any selections. Resetting the search section displays all the existing business assumption definitions in the List of Business Assumptions table. |
Folder |
This field allows you to search for the pre-defined business assumption definitions based on the selected folder. This field displays a list of folders that you have access to as a drop-down list. The selection of a folder from the drop-down list displays only those business assumptions that have been defined within the selected folder/segment in the List of Business Assumption table. |
Assumption Name |
This field allows you to search the pre-defined business assumption definitions based on the assumption name. Enter the assumption name. |
Assumption Category |
This field allows you to search the pre-defined business assumption definitions based on the assumption category. This field displays a list of categories that you have access to as a drop-down list. The selection of an assumption category from the drop-down list displays only those business assumptions that have been defined within the selected assumption category in the List of Business Assumption table. |
Inclusion Filters |
This field allows you to specify the Inclusion filters. |
Exclusion Filters |
This field allows you to specify the Exclusion filters. |
Time Bucket Definition |
This field allows you to search the pre-defined business assumption definitions based on the Time Bucket Definition. Enter the time bucket definition which was defined in the Time Bucket Definition window. |
Status |
This field allows you to search the pre-defined business assumption definitions based on approval status. This field displays a list of statuses that you have access to as a drop-down list, that is, Approved, Draft, In Review, Open, Pending Approval or Retired. Click the drop-down list to select Approved or Rejected status. The selection of a status from the drop-down list displays only those business assumptions that have been defined within the selected status in the List of Business Assumption table. |
Active |
This field allows you to search the pre-defined business assumption definitions based on active status. This field displays a status that you have access to as a drop-down list, that is, Yes or No. The selection of a status from the drop-down list displays only those business assumptions that have been defined within the selected status in the List of Business Assumption table. |
Intraday Assumption |
This field allows you to search the Intraday business assumption defined. This field displays options in the drop-down list, Yes or No. Selection of a Yes from the drop-down list displays only those intraday business assumptions that have been defined in the List of Business Assumption table. Selection of a No from the drop-down list displays only those business assumptions apart from intraday assumptions that have been defined in the List of Business Assumption table. |
Business Assumptions Icon Name |
Icon |
Description |
---|---|---|
Add |
This icon allows you to define a new assumption. |
|
View |
This icon allows you to view the selected assumption. |
|
Edit |
This icon allows you to edit the selected assumption. |
|
Delete |
This icon allows you to delete the selected assumption. |
|
Copy |
The icon allows a definition to be copied and resaved as a new definition. |
|
Make Active |
This icon allows activating the selected version of the assumption. The active version of the assumption is considered for Run definition. |
|
Workflow Summary |
The icon displays the approval summary for the definition. |
The Business Assumption Definition window allows you to define a new assumption definition in the LRM Application. See the Business Assumptions Supported section for a detailed explanation and calculations.
Figure 23 Business Assumption Definition
The assumption parameters enabled are specific to each assumption category and sub-category. To create a new business assumption, follow these steps:
1. Click in
the Business Assumption Summary window.
2. The Business Assumption Definition window is displayed where you can define new business assumption definitions. See the following table for field details.
Field |
Available Options |
||||
---|---|---|---|---|---|
Section: Linked to |
|||||
Folder |
Select the folder specific to the business assumption definition. |
||||
Access Type |
Select either Read/Write or Read-Only. |
||||
Section: Assumption Details |
|||||
Assumption Name |
Enter a name unique across infodoms. This field allows special characters. |
||||
Assumption Description |
Enter a brief description. This field allows special characters. |
||||
Version Number |
Generated automatically. |
||||
Intraday Assumption |
Select either Yes or No. |
||||
Section: Assumption Properties |
|
||||
Assumption Category |
Select from the following options: · Cash Flow Movement · Incremental Cash Flow · Encumbrance · Value Change |
||||
Assumption Sub-Category |
Based on the Assumption category selected, the following options are displayed: Note: If Intraday Assumption is selected as Yes, then intraday specific categories and sub-categories are displayed. See Assumption Intraday Sub-Category for details. Assumption Category: Cash Flow Movement Assumption sub-category: · Cash Flow Movement · Asset Sale · Cash Flow Delay · Delinquency · Prepayment · Recovery · Rollover · Run-off Assumption Category: Encumbrance Assumption sub-category: · Encumbrance · Ratings Downgrade · Valuation Changes Assumption Category: Incremental Cash Flow Assumption sub-category: · Incremental Cash Flow · Drawdown · Liability Run-off · New Business · Ratings Downgrade · Run-off · Secured Funding/Financing · Valuation Changes Assumption Category: Value Change Assumption sub-category: · Available Stable Funding Factor · Haircut · Required Stable Funding Factor |
||||
Based On |
Choose the based on measure to which the assumption parameter values are applied for cash flows calculation. See Based On for details. |
||||
Assumption Legs |
Select the number of Assumption Legs to specify the assumption parameter values, as either: · One · Two NOTE: This field is not available for all assumption sub-categories. When One is selected as assumption leg, in assumption specification only a column is displayed to add the primary assumption value. See Assumption Legs for details. |
||||
Assignment Method - Leg 1 |
Select from the following options: · Selected Time Bucket · Increasing · Decreasing · Equal · Proportionate See Assignment Method Leg 1, for details about the specific methods in which the assumption value can be assigned across multiple buckets. |
||||
Assignment Method - Leg 2 |
Select from one of the following options: · Selected Time Bucket · Increasing · Decreasing · Equal · Proportionate See Assignment Method leg 2, for details about the specific methods in which the assumption value can be assigned across multiple buckets. |
||||
Assumption Unit |
Select from one of the following options: · Amount · Percentage · Unit: Applicable when Sale is specified. See Assumption Unit for details. This parameter is the unit based on which the assumption values are specified. |
||||
Assumption Currency |
This option is enabled only when you select the assumption unit as Amount. See Assumption Currency for details. You can either select the option as Natural Currency, or choose any other currency from the drop-down list, which is required as part of the definition. NOTE: · If you select Natural Currency, ensure that the currency is selected as part of dimension selection. · Assumption Category - Incremental Cash Flow, sub-category - Liability Run Off is the only assumption where a currency is specified, even when the unit is specified as percentage. The assumption currency is required for specifying the minimum Balance. |
||||
Rating Downgrade |
Select from one of the following options: · Notch Based · Ratings Based This is applicable only when you select the sub-category Encumbrance and Ratings Downgrade, for assumption categories Incremental Cash Flow or Encumbrance. See Ratings Downgrade for details. |
||||
Transaction Leg |
Select from one of the following options: · One · Two See Transaction Legs, for details. |
||||
Charge Penalty |
Select from one of the following options: · Yes (For this option, an additional column in the assumption value grid is added to specify penalty) · No See Charge Penalty for details. |
||||
Specify Collateral/Underlying |
Select from one of the following options: · Yes · No This parameter determines if the existing unencumbered assets are required to be posted as collateral or underlying that is, if there are secured funding and repo transactions. See Specify Collateral/Underlying for details. |
||||
Sale Specification By |
This field is available only when you select Cash Flow Movement as the Assumption Category and Asset Sale as the Sub-Category. Select from one of the following options to specify a sale: · Individual Assets · Dimensions · If you select Individual Assets follow these steps: 1. In
the Asset Browser Selection, click 2. Select the Asset Type, enter Name and Account ID. 3. Select one or more members from a list of members displayed. 4. Click
5. Click OK. If you select Dimensions, follow the steps in Dimension Selection. See Sale Specification By for details. |
||||
Reporting Line Classification |
Select Enable or Disable for the field Reporting Line Classification. If you select Enable, the field Reporting
Line Dimension is displayed. Click |
||||
Section: Inclusion Filters/Exclusion Filters |
|||||
Inclusion Filters |
This field is available only for specific Assumption categories and sub-categories. See Filter Selection for details. To add Inclusion Filters/Exclusion Filters, follow these steps: 1. Click the corresponding icon 2. Select one or more (maximum of 7) dimensions. 3. Click
4. Click OK. The selected dimensions are displayed in the Inclusion Filters section. 5. Click the selected dimension member. The Hierarchy Browser window appears. 6. Select
one or multiple members from the list of dimensions displayed
in the Hierarchy browser. Click 7. Click OK. |
||||
Exclusion Filters |
|||||
Section: Dimension Selection |
|||||
Dimension |
To add a dimension, follow these steps: 1. Click 2. Select one or more (maximum of 7) dimensions. 3. Click
4. Click OK. The selected dimensions are displayed in the Selected Members section. 5. Click the selected dimension member. The Hierarchy Browser window appears. 6. Select
one or more members from the list of hierarchies displayed in
the Hierarchy browser. Click 7. Click OK. Note: · You can add a maximum of seven dimensions, one source or actual time bucket, and optionally a revised time bucket. · For the Intraday assumption category Incremental Cash Flow, sub-category Large Unexpected Payments, LRM - Intraday - Payment Settlement Systems dimension is selected by default. · See Dimension Selection for details. |
||||
Section: Time Bucket Definition Selection |
|||||
Time Bucket Definition |
To add a time bucket definition, follow these steps: 1. Click
2. Select time bucket definitions from a list of definitions displayed in the time bucket definition browser. Here it is a single selection. Only one time bucket can be selected. The values which are defined in the Time Bucket definition window are displayed here. 3. Click OK. The selected time bucket definition is displayed in the time bucket definition selection against both <Time Bucket 1> Selection, and <Time Bucket 2> Selection. 4. Click
the Note: For category Incremental Cash Flow, subcategory Liability Run-off, the selected time bucket definition is displayed in the time bucket definition selection against both Inaccessibility End Bucket selection, and Restoration End Bucket selection. For Inaccessibility End Bucket, click the selected time bucket icon. One or multiple time buckets from the given time bucket definition can be selected as part of Inaccessibility End Bucket selection. The selected time buckets are displayed as row items in the assumption specification table. For Restoration End Bucket, click the selected time bucket icon. A single selection of a time bucket greater than the Inaccessibility End Bucket can be selected as part of Restoration End Bucket selection. The time buckets selected are displayed as drop-down values in the Off-set Bucket column in each row of the assumption specification table. |
||||
Assumption Category |
<Time Bucket 1> Selection |
<Time Bucket 2> Selection |
|||
Cash Flow Movement |
From Bucket Selection |
To Bucket Selection |
|||
Incremental Cash Flows |
Primary Bucket Selection |
Off-set Bucket Selection |
|||
Encumbrance |
From Bucket Selection |
To Bucket Selection |
|||
Value Change |
Not Applicable |
Not Applicable |
|||
NOTE: · When the Intraday Assumption is selected as Yes in the Business Assumption Definition window, only the Intraday Time Buckets are displayed in this section. · This field is available only for specific Assumption categories and sub-categories. See Time Bucket Definition for details. · For Category Encumbrance, sub-category Ratings Downgrade, category Value Change, sub-category - Available Stable Funding Factor, the time bucket selection is not required as they are not determined, and these factors are applied to balances and market values of assets and liabilities. · For Category Value Change, sub-category - Haircut, the time bucket selection is not required as they are not determined. These haircut values are further used in the Run for the calculation of stock of HQLA. · For Category Incremental Cash Flow, sub-category Incremental Cash Flow and Liability Run off, if you have selected Assumptions Legs as One, in Time Bucket Definition Selection only Off-set Bucket is displayed. Whereas, if you have selected Assumptions Legs as Two, in Time Bucket Definition Selection both Primary Bucket and Off-set Bucket is displayed. |
|||||
Section: Cash flow Interval Selection |
|||||
Cash Flow Interval Selection |
To select a cash flow interval, follow these steps: 1. Click
2. Select a defined cash flow interval displayed in the browser. 3. Click OK. The selected Cash Flow Interval is displayed in the Cash Flow Interval selection section. 4. Click the selected dimension member. The Hierarchy Browser window appears. 5. Select
one or multiple members from a list of hierarchies and click 6. Click OK. Note: This field is available only for specific Assumption categories and sub-categories. See Cash Flow Interval Selection for details. For category Value Change, sub-category Available Stable Funding Factor, this selection is enabled only when you select the Based On measure as Cash Flows, Less Stable Cash Flows, Non-operational Cash Flow, Operational Cash Flow or Stable Cash Flow. |
||||
3. Click . The Assumption Parameter Specification table is generated
with the selected dimensions as column values and dimension members as
row values. Additionally, depending on your selection, one or two time
bucket columns are displayed.
The names of these columns change based on the assumption category selected as follows:
Assumption Category |
<Time Bucket 1> |
<Time Bucket 1> |
---|---|---|
Cash Flow Movement |
From Bucket |
To Bucket |
Incremental Cash Flows |
Primary Bucket |
Off-set Bucket |
Encumbrance |
From Bucket |
To Bucket |
Value Change |
Not Applicable |
Not Applicable |
The unique combinations of selected dimension members
and the From buckets are displayed as rows. If you have enabled Reporting Line Classification, then the Reporting
Line column is displayed. Click to
view the hierarchy browser. Select the reporting line item from the list.
Click OK.
The names of these columns change based on the assumption category selected as follows:
Assumption Category |
Assumption Sub-Category |
Columns Displayed in Assumption Parameter Specification |
---|---|---|
Cash Flow Movement |
Cash Flow Movement |
· Each selected dimension · From Bucket · To Bucket · Assumption Value - Leg 1 (if Transaction Legs is one) · Assumption Value - Leg 2 (if Transaction Legs is two) · Penalty (if charge penalty is yes) |
|
Run-Off |
· Each selected dimension · From Bucket · To Bucket · Run-off |
|
Prepayment |
· Each selected dimension · From Bucket · To Bucket · Prepayment Value · Penalty (if charge penalty is yes) |
|
Cash Flow Delay |
· Each selected dimension · From Bucket · To Bucket · Assumption Value · Penalty (if charge penalty is yes) |
|
Delinquency |
· Each selected dimension · From Bucket · Delinquent Value |
|
Recovery |
· Each selected dimension · To Bucket · Recovery Value |
|
Rollover |
· Each selected dimension · From Bucket · To Bucket · Rollover Value - Leg 1 (if Transaction Legs is One) · Rollover Value - Leg 2 (if Transaction Legs is Two) |
|
Asset Sale |
· Each selected dimension (if Sale Specification by is Dimensions) · Each selected asset (if Sale Specification by is Individual Assets) · Sale Bucket · Sale Value · Haircut (in %) |
Encumbrance |
Encumbrance |
· Each selected dimension · Downgrade Impact |
|
Ratings Downgrade |
· Each selected dimension · Downgrade Impact |
|
Valuation Changes |
· Each selected dimension · Valuation Change Impact |
Incremental Cash Flow |
Incremental Cash Flow |
· Each selected dimension · Primary Bucket (if Assumption Legs is Two) · Incremental Value - Leg 1 (if Transaction Legs is One) · Incremental Value - Leg 2 (if Transaction Legs is Two) · Off-set Bucket · Off-set Value - Leg 1 (if Transaction Legs is One) · Off-set Value - Leg 2 (if Transaction Legs is Two) · Collateral/Underlying (if Specify Collateral/Underlying is yes) · Encumbered Value (if Specify Collateral/Underlying is yes) |
|
Run-Off |
· Each selected dimension · Time Bucket · Run-off |
|
Drawdown |
· Each selected dimension · Primary Bucket · Downgrade Value - Leg 1 · Off-set Bucket · Off-set Value - Leg 1 |
|
Liability Run-Off |
· Each selected dimension · Inaccessibility End Bucket: |
|
New Business |
· Each selected dimension · Primary Bucket · Growth Value - Leg 1 (if Transaction Legs is 1) · Growth Value - Leg 2 (if Transaction Legs is 2) · Off-set Bucket · Off-set Value - Leg 1 (if Transaction Legs is 1) · Off-set Value - Leg 2 (if Transaction Legs is 2) |
|
Ratings Downgrade |
· Each selected dimension · Time Bucket · Downgrade Impact |
|
Secured Funding/Financing |
· Each selected dimension · Each selected dimension · Primary Bucket · Primary Value - Leg 1 · Primary Value - Leg 2 (if Transaction Legs is Two) · Off-Set Bucket · Off-Set Value - Leg 1 · Off-Set Value - Leg 2 (if Transaction Legs is Two) · Collateral/Underlying · Encumbered Value |
|
Valuation Changes |
· Each selected dimension · Time Bucket · Downgrade Impact |
Value Change |
Available Stable Funding Factor |
· Each selected dimension · ASF Factor |
|
Haircut |
· Each selected dimension · Haircut (%) |
|
Required Stable Funding Factor |
· Each selected dimension · RSF Factor |
Intraday Assumption Category |
||
Cash Flow Movement |
Time Shift in Payments |
· Each selected dimension · From Bucket · To Bucket · Assumption Value |
Payments Default |
· From Bucket · Residual Bucket · Assumption Value |
|
Encumbrance |
Withdrawal of Credit Lines |
· Each selected dimension · Assumption Value |
Incremental Cash Flow |
Intraday Drawdown |
· Each selected dimension · Primary Bucket · Off-Set Bucket · Downgrade Value · Off-Set Value |
Large Unexpected Payments |
· Each selected dimension · Time Bucket · Assumption Value Note: The unique combinations of selected dimension members and the from buckets are displayed as rows. An additional text field "Transaction Amount" is displayed where you can enter the amount value. |
|
Value Change |
Intraday Valuation Changes |
· Each selected dimension · Assumption Value |
Only for an assumption category and sub-category which support Rating Downgrade, the Downgrade Specification table is generated with the selected dimensions as column values and dimension members as row values. The Downgrade Specification table has the following columns:
Assumption Category |
Assumption Sub-Category |
Columns Displayed in Assumption Parameter Specification |
---|---|---|
Encumbrance |
Ratings Downgrade |
· Each selected dimension · Rating Type · Rating Source · Downgrade |
Encumbrance |
||
Incremental Cash Flow |
Ratings Downgrade |
NOTE:
· You can sort and filter on each dimension column.
· The dimensions columns are re-arranged based on drag and drop enabled in the Dimension Selection section.
· To delete
a table row in the Assumption Specification table, select a row and then
click the icon.
· To add a
sub row to each row, for instance, to specify multiple <Time Bucket
2>, select a row and then click the icon.
· To delete sub rows, right-click on the sub row to delete.
· To enable
Collateral Posting, select a row, and then click the icon.
The Asset Browser window with only unencumbered assets is displayed. This
icon is enabled only when the Post Collateral parameter is selected as
Yes.
· The assets that are unencumbered during the selected period are displayed even if they are encumbered currently. These are allowed to be posted as collateral for the unencumbered period.
· After selecting
the members, click to
move the selected member, or click
to
move all the members, to the Selected Members section, and click OK.
· The selected collateral is displayed in the respective row in Assumption Specification. Encumbrance value can be specified as a percentage against each collateral. This column enables the specification of partial encumbrance. You can select one or multiple members for each selected dimension. These are displayed as sub rows against the dimensional combination row for which this is being specified in the Assumption Specification table.
4. Follow these steps to add values to Collateral/Underlying, and Encumbered value columns for assumption category - Incremental Cash Flow, sub-category - Secured Funding/Financing:
a. Click the
check box on the left of the dimensional combination. Once the dimensional
combination is chosen in the grid, click the Add Assets () icon. The Add Assets icon allows you to add as many
assets as needed for the particular row in the grid.
b. Once the Add Assets icon is clicked, enter values in the following screen.
c. The business assumption definition after collateral and encumbered value is specified are displayed as follows.
5. To save the definition, click Save.
6. To return to the Business Assumption Definition Summary window, click Close.
NOTE:
· Stress assumptions are defined in the business assumption definition window as that explained above. These assumptions will have adverse values for Run-offs, rollovers, drawdowns, haircuts, and so on. The dimensions used for stress testing may also be different from those under BAU conditions. However, the process of defining a stress business assumption does not change.
· After you save a Business Assumption, it is registered as a process in the Rules Framework of Oracle Financial Services Analytical Applications Infrastructure.
· A Business Assumption is available for selection in the Run Management window only after it is approved.
· If a Business Assumption is edited, it is saved as a new version.
· After including additional dimension members, the existing Assumption Specification table must not be reset.
OFS LRM supports approval workflows based on user roles. Business assumptions that are defined within the application are required to be approved. These are defined within the application before they can be used for computations. The user who creates the assumption will send it for approval after finalizing it. Assumptions can be approved only by users with the required access levels. For more information refer to the User Roles and Access section.
Topics:
· Sending Business Assumption Definition for Approval
· Approving a business assumption definition
· Retiring a business assumption definition
To send a definition for approval, follow these steps:
1. Click Business Assumption on the LHS menu of the LRM Application to open the Business Assumption Summary window.
NOTE:
· Assumptions in the following stages can be sent for approval:
· A new definition which in “Draft” status.
· A version of a definition that is rejected and is in “Open” status.
· A definition that is edited and a new version of which is created and is in “In Review” status.
2. Click to select a definition with the status “Draft”,
“Open” or “In Review” from the list of business assumptions and then click
the
icon.
Figure 24 Business Assumption Summary - Draft Status
Figure 25 Business Assumption Summary - Open Status
Figure 26 Business Assumption Summary - In Review Status
The Business Assumption Definition window is displayed with all the parameters defined.
Figure 27 Business Assumption Summary - Send for Approval
To send a definition for authorization, click Send for Approval. This changes the status of the definition to Pending Approval. The definition is successfully sent for approval and the status changes to Pending Approval.
To approve a business assumption, follow these steps:
1. Click Business Assumption on the LHS menu of the LRM Application to open the Business Assumption Summary window. Only assumptions which are in Pending Approval status can be approved or rejected by the approver.
2. Click to select a definition with the status Pending
Approval from the list of business assumptions and then click the
icon.
Figure 28 Business Assumption Summary - Pending Approval
The Business Assumption Definition window is displayed with all the parameters defined.
Figure 29 Business Assumption Definition - Approve/Reject
3. To approve the definition that is sent for authorization, click Approve.
The Approve dialog box is displayed with the assumption name and description.
Figure 30 Business Assumptions - Approve
4. Enter Approver comments and then click Approve.
5. To reject the definition that is sent for authorization, click Reject.
The Reject dialog box is displayed with the assumption name and description.
Figure 31 Business Assumptions - Reject
6. Enter Approver comments and then click Reject.
7. Click the
icon to view the summary of the entire approval
workflow. It displays approval history showing the start date, completion
date, status owner, and comments if any.
Figure 32 Business Assumptions - Approval Summary
NOTE:
· The Approve or Reject buttons are present only for the users who have the right to approve or reject the definition.
· If the definition is rejected, it changes back to ‘Open’ status. When the definition is in open status, click View to view the definition. You cannot edit the values in the View window.
You can retire a business assumption definition when a definition is no longer valid and not required to be included in the selection of a new run calculation. To retire a definition once it is approved, follow these steps:
1. To retire
a definition, click to select a definition
from the list of business assumptions and then click
or
.
Figure 33 Business Assumptions - Retire
The Business Assumption Definition window is displayed.
2. Click Retire. A retired definition will not be available for selection as part of a new Run definition.
NOTE:
· After approval, when an assumption is edited and is in In Review status, it is not picked up for execution. Only when the definition goes through the entire approval process and is approved it is marked as latest and it can be used for execution.
· After the definition is approved, the latest version of such approved definitions are executed. While executing the Run executes the latest version of that assumption (that is, the version marked as latest). Run automatically picks up the definition which is marked as latest. Only the version marked as latest will be executed at a given point of time.
· If the business conditions change, and you require a previously defined version number to make it active, select the assumption from the Business Assumption Summary window and click Make Active. Once it is approved, that version is automatically marked as latest, but you can always go back and mark a previous version as the latest in Business Assumption Summary window (Make Active).
· The status updated in the Business Assumptions Summary window allows you to search the pre-defined business assumption definitions on the basis of approval status. This field displays a list of statuses that you have access to as a drop-down list that is, Approved, Draft, In Review, Open, Pending Approval or Retired. Click the drop-down list to select the status. The selection of a status from the drop-down list displays only those business assumptions that have been defined within the selected status in the List of Business Assumption table.
· Business assumption definitions can be edited before or post-approval. If edited before approval, it is resaved with the same version number. If edited post-approval, it is resaved with a new version number. You cannot edit the definition once sent for approval and in Pending Approval status.
· The business assumption definition, once saved and approved, is registered as a Rule in the Rules Framework of Oracle Financial Services Analytical Applications Infrastructure.
The process of editing a business assumption is as follows:
1. To edit a
definition, click to
select a definition from the list of business assumptions and then click
.
Figure 34 Business Assumptions - Editing a Business Assumption
· You can edit a definition which is in Draft, Open and In Review status. An LRM Analyst has the privileges to edit.
· When the definition is in Draft status, all the parameters can be edited in the Business Assumption Definition window.
· When the definition is in Open status and In Review status, all the parameters except the Assumption Name can be edited in the Business Assumption Definition window.
· When you edit a definition which is Draft status, it remains in version 0.
· When you edit a definition that is in Open status, the version number does not change.
NOTE:
· In Draft and Open status, the changes made are overwritten and the version number does not change.
2. When you edit a definition that is in Approved status, the version number is changed, and a new version is created. This changes the status to In Review.