7        Business Assumptions

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 

Business Assumptions Supported

The application supports the following types of business assumptions:

 Supported 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 

·        Encumbrance 

·        Incremental Cash Flow 

·        Value Change 

Cash Flow Movement

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:

·        Cash Flow Movement 

·        Asset Sale 

·        Cash Flow Delay 

·        Delinquency 

·        Prepayment 

·        Recovery 

·        Rollover 

·        Run-Off 

Cash Flow Movement

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.

Asset Sale

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.

Cash Flow Movement - Asset Sale

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%)]

Cash Flow Delay

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.

 Cash Flow Movement - Cash Flow Delay

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
[= (30000-30000*10%)]

26150
[=23000+ (30000*10%) + {(30000*10%)*5%}]

 

Delinquency

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:

Formulae for cash flow assignment

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.

 

Delays assigned to a selected time bucket

Business Assumption Definition

Computation Assignment

Product

Customer

From Bucket

Delinquent Value

Contractual Cash Flow
(From Bucket)

Contractual Cash Flow
(Overnight Bucket)

Delinquent  (Value)

Revised Cash flow
(From Bucket)

Revised Cash flow
(Overnight Bucket)

Business Loans

Large Customer

8-8Days

10%

30000

23000

3000

[= (30000* 10%)]

27000
[=(30000- 3000)]

40600

[=(23000+3000+5000+9600)]

9-9Days

20%

25000

5000

[= (25000*20%)]

20000
[=(25000-5000)]

10-10Days

30%

32000

9600

[= (32000*30%)]

22400
[=(32000-9600)]

 

 


Illustration 2: Delays assigned to a selected time bucket

Cash Flow Movement - Delinquency

Business Assumption Definition

Computation Assignment

Product

Customer

From Bucket

Delinquent Value

Contractual Cash Flow
(From Bucket)

Contractual Cash Flow
(Overnight Bucket)

Delinquent  (Value)

Revised Cash flow
(From Bucket)

Revised Cash flow
(Overnight Bucket)

Home Loans

Non- Large Customer

3-3 Days

15%

15000

23000

2250

[= (15000*15%)]

12750
[=(15000-2250)]

27350

[=(23000+2250+2100)]

 

4-4 Days

10%

21000

2100

[= (21000* 10%)]

18900
[=(21000- 2100)]

 

 

 

 

 

 

Prepayment

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:

Cash flow assignment formula

Formula for Cash flow assignment

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 Movement Prepayment

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

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:

Formula for cash flow assignment for delinquent or defaulted cash flows  

The following example shows the assumption applied to product type (loan), legal entity (LE 1), and currency (USD):

Cash Flow Movement - Recovery

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

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:

Formula for cash flow assignment

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).

Cash Flow Movement - Rollover

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:

Formula for cash flow assignment

Run-Off

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:

Formula for cash flow assignment

An illustration is as follows:

 

Cash Flow Movement - 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

 

 

 

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
[(20000-20000*10%)]

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)]

 

 

Encumbrance

This section provides information about Encumbrance. 

Topics:

·        Encumbrance 

·        Ratings Downgrade 

·        Valuation Changes 

Encumbrance

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.

Ratings Downgrade

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:

Formula for new stock of HQLA assignment

Assuming a downgrade trigger of 3-Notches, this assumption is specified as follows:

Encumbrance - Ratings Downgrade

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%)]

 

Valuation Changes

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

 

 

 

Encumbrance - Valuation Changes

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)]

 

Incremental Cash Flow

This section provides information about Incremental Cash Flow. 

Topics:

·        Incremental Cash Flow 

·        Drawdown 

·        Liability Run-off 

·        New Business 

·        Ratings Downgrade 

·        Run-off 

·        Secured Funding/Financing 

·        Valuation Changes 

Incremental Cash Flow

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.

Drawdown

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:

This illustration shows the formula for drawdown. 

 

 Incremental Cash Flow - 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

Liability Run-off

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:

This illustration shows the formula for computing the balance to be maintained at the end of the portfolio restoration period.

4.     The balance at the end of the market inaccessibility period is computed as follows:

This illustration shows the formula for balance at the end of the market inaccessibility period.

5.     The total re-issue amount is computed as follows:

This illustration shows the formula for total re-issue amount.

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:

This illustration shows the formula for re-issue amount per business day.

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:

This illustration shows the formula for additional run off during per business day.

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:

Inputs

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%

 

 

Time Periods and Balances

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.


 
Illustration - Cash Flows When Re-Issue Amount is Negative

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


New Business

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:

 Incremental Cash Flow - New Business Example 1

Business Assumption Definition

Cash Flow Assignment

Product Type

Legal Entity

Primary Bucket

Off-set Bucket

Growth

Off-set Value

Contractual Cash Flow
(Primary Bucket)

Revised Contractual Cash Flow
(Primary Bucket)

Contractual Cash Flow
(Off-set Bucket)

Revised Contractual Cash Flow
(Off-set Bucket)

Loans

LE1

3-3 Days

60-60 Days

15%

60%

20000

17000
[=20000-(20000*15%)]

25000

26800 [=
(20000*15%*60%)+25000]

90-90 Days

20%

27000

27600

[=(20000*15%*20%)+27000]

120-120 Days

20%

32000

32600
[=(20000*15%*20%)+32000]

 

Here,

This illustration shows the formula for Asset Book Growth.

An example of Liability Book Growth is as follows:

Incremental Cash Flow - New Business Example 2

Business Assumption Definition

Computation

Product Type

Legal Entity

Primary Bucket

Off-set Bucket

Growth

Off-set Value

Contractual Cash Flow
(Primary Bucket)

Revised Contractual Cash Flow
(Primary Bucket)

Contractual Cash Flow
(Off-set Bucket)

Revised Contractual Cash Flow
(Off-set Bucket)

Deposits

LE1

3-3 Days

4-4 Days

25%

60%

20000

25000 [=
20000+ (20000*25%)]

25000

22000
[=25000- (20000*25%*60%)]

5-5 Days

40%

32000

30000
[=32000- (20000*25%*40%)]

 

Here,

Formula for Inflow Amount and Outflow Amount

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.

 

Ratings Downgrade

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:

This illustration shows the formula for Cash flow assignment.

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:

Illustration - Impact of a Notch Based Downgrade

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:

Downgrade Assumption Specification

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:

New Rating Post Downgrade Assessment

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:

Incremental Cash Flow - Ratings Downgrade

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.

Run-off

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:

Incremental Cash Flow - Run-Off

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%]

 

Secured Funding/Financing

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:

 Incremental Cash Flow - Secured Funding/Financing

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:

Cash Flow Computation

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.

Valuation Changes

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:

Incremental Cash Flow - Valuation Changes

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.

Value Change

This section provides information about Value Change.

Topics:

·        Available Stable Funding Factor

·        Haircut

·        Required Stable Funding Factor

Available 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.

 Value Change - Available Stable Funding Factor

Business Assumption Definition

Balance Assignment

Product

ASF Factor

EOP Balance

Available Stable Funding

P1

85%

10000000

8500000
[= (1000000*85%)]

P 2

100%

200000

200000
[= (200000*100%)]

Term deposits from retail

90%

320000

288000
[= (320000*90%)]

Unsecured funding from non-financial corporates

50%

21000

10500
[= (21000*50%)]

 

Haircut

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.

Value Change - Haircut

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:

 

Value Change - Haircut

Product Type

Asset Level

Haircut

Market Value

Haircut Adjusted Market Value

Cash

Level 1

0%

3000000

3000000
[=30000000*(1-0%)]

Covered bond

Level 1

0%

220000

187000
[=220000*(1-15%)]

Covered bond

Level 2A

15%

550000

412500
[=550000*(1-25%)]

Common Equity

Level 2B

50%

110000

55000
[=110000*(1-50%)]

 

Required Stable Funding Factor

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.

Value Change - Required Stable Funding Factor

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%)]

 

Intraday Business Assumptions Supported

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.

Cash Flow Movement

This section provides information about Cash flow Movement. 

Topics:

·        Time Shift in Payments

·        Payments Default

Time Shift in Payments

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:

 

Time Bucket Definition

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:

Payments Made and Received

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:

Payments Received After Assignment

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.

Payments Default

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.

 

 Example - Payments Made and Received for a Legal Entity

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:

Example - New set of Inflows and Outflows

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

Encumbrance

This section provides information about Encumbrance. 

Withdrawal of Credit Lines

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’.

Sources of Credit Lines

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.

Incremental Cash Flow

Topics:

·        Intraday Drawdown 

·        Large Unexpected Payments 

Intraday Drawdown

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:

Credit Lines Extended To Customers And Usage

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:

Credit Lines Extended and Used Under Stressed Conditions

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).

Large Unexpected Payments

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:

Actual payments with time stamp

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:

Bucketed Payments at Level 1

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.

New Bucketed Payments After Application of the Assumption

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.

Value Change

This section includes information about Value Change. 

Intraday Valuation Changes

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 - Intraday Valuation Changes

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.

Impact of Assumptions on Interest Cash Flows

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:

This illustration shows the formula for calculating the outstanding balance for each subsequent bucket.

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:

This illustration shows the formula for calculating the outstanding balance for each subsequent bucket.

Calculate the proportionate impact on interest cash flows in each bucket under business-as-usual or stress terms as per the following formula:

This illustration shows the formula for the proportionate impact on interest cash flows in each bucket under business-as-usual or stress terms.

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.

 Impact on Interest Cash Flows under Growth Assumption

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.

Impact on Interest Cash Flows under Rollover Assumption

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.

Impact on Interest Cash Flows under Run-off Assumption

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.


 

Cash Flow Assignment Methodologies

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

This illustration shows the calculation for EOP Balance Based Assumptions,

Where,

Level X Buckets: Higher granular buckets

Equal Assignment under Balance Based Assumptions, %

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

This illustration shows the formula for Cash Flow based Assumptions.

Where, n: Selected bucket

Equal Assignment under Cash Flow Based Assumptions,%

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

This illustration shows the formula for Assumption unit.

 

Equal Assignment, 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

This illustration shows the formula for EOP Balance Based Assumptions. 

Where,

t: Number of days in the given Level X bucket

Proportionate Assignment under Balance Based Assumptions, %

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

This illustration shows the formula for Cash Flow Based Assumptions.

 

Proportionate Assignment under Cash Flow Based Assumptions, %

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

Proportionate Assignment, 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

This illustration shows the formula for EOP Balance Based Assumptions.

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.

Decreasing Assignment under Balance Based Assumptions, %

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

This illustration shows the formula for Cash Flow Based Assumptions.

Decreasing Assignment under Cash Flow Based Assumptions, %

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

This illustration shows the formula for Assumption unit.

Decreasing Assignment, 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

This illustration shows the formula for EOP Balance Based Assumptions.

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.

Increasing Assignment under Balance Based Assumptions, %

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

This illustration shows the formula for calculation of cash flows.

 

 Increasing Assignment under Cash Flow Based Assumptions, %

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

This illustration shows the formula for calculation of cash flows.

 Increasing Assignment, 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:

 

Cash Flow Assignment to Multiple Bucket Levels

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:

This illustration shows the formula for calculation of cash flows. 

Equal cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows. 

Proportional Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows. 

Selected Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows.

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:

This illustration shows the formula for calculation of cash flows. 

Equal Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows.

Proportional Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows. 

Selected Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows.

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:

This illustration shows the formula for calculation of cash flows. 

Equal Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows. 

Proportional Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows. 

Selected Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows.

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:

This illustration shows the formula for calculation of cash flows. 

Equal Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows. 

Proportional Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows. 

Selected Cash Flow assignment is done using the following formula:

This illustration shows the formula for calculation of cash flows.


Assumption Calculation

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

Assumption Calculation - Original Balance/ Cash Flows (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
(20000-2000)

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

Assumption Calculation - Original Balance/ Cash Flows (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
(20000*10%)

14000
(20000-2000-4000)

9000
(7000+2000)

8-8 Days

 

10500

4000
(20000*20%)

 

14500
(10500+4000)

 

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

Assumption Calculation - Changing Balance/Cash Flows (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
(20000*10%)/4

18000
(20000- 2000)

10500
(10000+500)

1-1Days

 

11000

500
(20000*10%)/4

 

11500
(11000+500)

2-2Days

 

22000

500
(20000*10%)/4

 

22500
(22000+500)

3-3Days

 

12000

500
(20000*10%)/4

 

12500
(12000+500)

 

Assumption 2: Cash Flow Delay

Assumption Calculation- 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
(To Bucket)

Delay + Penalty

Revised Cash flow
(From Bucket)

Revised Cash flow
(To Bucket)

18000

23000

10% + 5%

16200

(18000-10%*18000)

24890
{23000+ (18000*10%) + (1800*5%)}

 

In the above computation, when Run is executed with a new assumption category, assumption value is applied on the changing balance.


Business Assumption Definition

The Business Assumption Definition window has the following sections for the purpose of defining assumption parameters:

Topics:

·        Linked To 

·        Assumption Details 

·        Assumption Properties 

·        Filter Selection 

·        Dimension Selection 

·        Time Bucket Definition Selection 

·        Cash Flow Interval Selection 

·        Assumption Parameter Specification 

Linked To

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.

Assumption Details

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

Assumption properties are the basic parameters required for defining a business assumption. They include the following:

·        Assumption Category 

·        Assumption Subcategory 

·        Assumption Intraday Subcategory 

·        Based On 

·        Assumption Legs 

·        Assignment Method - Leg 1 

·        Assignment Method - Leg 2

·        Intraday Assignment Method - Leg 1 and 2 

·        Assumption Unit 

·        Assumption Currency 

·        Ratings Downgrade 

·        Transaction Legs 

·        Charge Penalty 

·        Specify Collateral/Underlying 

·        Sale Specification By 

·        Reporting Line Classification 

Assumption Category

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.

Assumption Subcategory

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

Assumption Intraday Subcategory

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

Based On

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.

 List of Based On

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:

 

List of Based On - Intraday

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

 

Assumption Legs

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.

Assignment Method - Leg 1

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

Selected Time Bucket

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:

 

Time Buckets Used For Computation

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.

Assignment Method Leg 1 - Selected Time Bucket Example 1

Assumption Category

Assumption Unit

Applied to

Assignment Method

Based On

Cash Flow Movement: Run-off

Percentage

Original Balance

Selected

Cash Flow

 

 


Assignment Method Leg 1 - Selected Time Bucket Example 2

Business Assumption

Computation

Product

Customer

From Bucket

To Bucket

Run-off %

Contractual Cash Flow
(From Bucket)

Contractual Cash Flow
(To Bucket)

 Run-off 

Revised Cash flow
- From Bucket

Revised Cash flow
-To Bucket

Time Deposits

Customer 1

10-10 Days

5-5 Days

10%

30000

23000

3000

(30000* 10%)

33000
(30000+ 3000)

        20000
    (23000--3000)

 

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
(From Bucket)

To Bucket

Contractual Cash Flow
(To Bucket)

Run-off

Revised Cash flow
- From Bucket

Revised Cash flow
-To Bucket

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

 

Assignment Method Leg 1 - Increasing assignment Example 1

Business Assumption

Bucket

Computation

Product

Customer

From Bucket

To Bucket

Run-off %

To Bucket

Bucket Rank

Contractual Cash Flow
(From Bucket)

Contractual Cash Flow
(To Bucket)

Run-off  (Value)

Revised Cash flow
- From Bucket

Revised Cash flow
-To Bucket

Assets

Customer 1

10-10Days

3-3Days

10%

Overnight

1

30000

20000

300
=(30000*10%)*1/10

27000
=(30000- 3000)

20300
= (20000+300)

 

 

 

 

 

1-1Days

2

 

21000

600
=(30000*10%)*2/10

 

21600
== (21000+600)

 

 

 

 

 

2-2Days

3

 

19000

900
=(30000*10%)*3/10

 


19900
= (19000+900)

 

 

 

 

 

3-3Days

4

 

27000

1200
=(30000*10%)*4/10

 

28200
= (27000+1200)

 

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.

Assignment Method Leg 1 - Increasing assignment Example 2

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
(300000*10%)*1/3

10000

 

 

 

 

2

1-1 Days

30000

20000
(300000*10%)*2/3

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

This illustration shows the formula for calculation of cash flows.

b.     When Assumption Unit = Value

This illustration shows the formula for calculation of cash flows.

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

 

Assignment Method Leg 1 - Decreasing Assignment Example 1

Business Assumption

Bucket

Computation

Product

Customer

From Bucket

To Bucket

Run-off %

To Bucket

Bucket Rank

Contractual Cash Flow
(From Bucket)

Contractual Cash Flow
(To Bucket)

Run-off  (Value)

Revised Cash flow
- From Bucket

Revised Cash flow
-To Bucket

Assets

Customer 1

10-10Days

3-3Days

10%

Overnight

4

30000

20000

1200
(30000*10%)*4/10

27000
(30000- 3000)

21200
 (20000+1200)

 

 

 

 

 

1-1Days

3

 

21000

900
(30000*10%)*3/10

 

21900
 (21000+900)

 

 

 

 

 

2-2Days

2

 

19000

600
(30000*10%)*2/10

 

19600
(19000+600)

 

 

 

 

 

3-3Days

1

 

27000

300
(30000*10%)*1/10

 

30000
 (27000+300)

c.     When, EOP Balance Based Assumptions, Assumption Unit = Percentage

This illustration shows the formula for calculation of cash flows.

 

 

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.

Assignment Method Leg 1 - Decreasing Assignment Example 2

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

This illustration shows the formula for calculation of cash flows.

b.     When Assumption Unit = Value

 

This illustration shows the formula for calculation of cash flows.

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

 

Assignment Method Leg 1 - Equal Assignment Example 1

Business Assumption

Bucket

Computation

Product

Customer

From Bucket

To Bucket

Run-off %

To Bucket

Bucket Rank

Contractual Cash Flow
(From Bucket)

Contractual Cash Flow
(To Bucket)

Run-off  (Value)

Revised Cash Flow
- From Bucket

Revised Cash Flow
-To Bucket

Assets

Customer 1

10-10Days

5-5 Days

10%

Overnight

30000

20000

500
(30000*10%)/6

27000
=(30000- 3000)

20500
 (20000+500)

 

 

 

 

 

 

1-1Days

 

21000

500
(30000*10%)/6

 

21500
(21000+500)

 

 

 

 

 

 

2-2Days

 

19000

500
(30000*10%)/6

 


19500
(19000+500)

 

 

 

 

 

 

3-3Days

 

27000

500
(30000*10%)/6

 

27500
(27000+500)

 

 

 

 

 

 

4-4Days

 

13000

500
(30000*10%)/6

 

13500
(13000+500)

 

 

 

 

 

 

5-5Days

 

11000

500
(30000*10%)/6

 

11500
(11000+500)

 

 

c.     When, EOP Balance Based Assumptions, Assumption Unit = Percentage

This illustration shows the formula for calculation of cash flows.

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

 

Assignment Method Leg 1 - Equal Assignment Example 2

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
(500000*10%)

45000

20000+(50000/2)

 

 

 

 

1-1 Days

30000

 


55000
30000 + (50000/2)

 

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

            This illustration shows the formula for calculation of cash flows.

b.     When Assumption Unit = Value

This illustration shows the formula for calculation of cash flows.

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

 

Proportionate Cash Flow assignment method

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:

 

Buckets 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

 

Assignment Method Leg 1 - Proportionate Assignment Example 1

Business Assumption

Computation

Product

Customer

From Bucket

To Bucket

Run-off %

To Bucket

Contractual Cash Flow
(From Bucket)

Contractual Cash Flow
(To Bucket)

 Run-off  (Value)

Revised Cash Flow
- From Bucket

Revised Cash Flow
-To Bucket

Assets

Customer 1

26-30Days

11-15Days

10%

Overnight

30000

20000

0
(30000*10%)*0/15

27000
=(30000- 3000)

20000

 

 

 

 

 

1-10Days

 

21000

2000
(30000*10%)*10/15

 

23000
(21000+2000)

 

 

 

 

 

11-15Days

 

19000

1000
(30000*10%)*5/15

 

20000
(19000+1000)

 

c.     When, EOP Balance Based Assumptions, Assumption Unit = Percentage

This illustration shows the formula for calculation of cash flows.

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

 

Assignment Method Leg 1 - Proportionate Assignment Example 2

Business Assumption

Computation

Product

Customer

Primary Bucket

Run-off
(%)

Bucket

Rank

Primary Bucket

Contractual Cash

Outflow (Primary Bucket)

Run-off

Revised Cash Outflow
(Primary Bucket)

Customer 1

1-10Days

10

1

 

Overnight

20000

0(300000*10%)*0/10

20000

 

 

 

2

 

1-10Days

30000

30000
(300000*10%)*10/10

60000
(30000 + 30000)

 

 


Assignment Method - Leg 2

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.

Intraday Assignment Method - Leg 1 and 2

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.

Assumption Unit

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).

 

Assumption Currency

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

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.

 

Transaction Legs

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.

Charge Penalty

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

 

 

Specify Collateral/Underlying

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.

Sale Specification By

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.

Reporting Line Classification

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.

Reporting Line Classification enabled assumption category and subcategory

Assumption Category

Assumption Sub- Category

Value Change

Available Stable Funding factor

Required Stable Funding factor

Filter Selection

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.

 

Dimensions displayed in filter selection

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.

Dimension Selection

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.

Time Bucket Definition Selection

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:

Time Bucket 1 Selection

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:

Time Bucket 2 Selection

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.

 

 

Cash Flow Interval Selection

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.

 

Assumption categories supporting cash flow interval selection

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.

Assumption Parameter Specification

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

 

Understanding Business Assumption Summary

 

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

Description of the Business Assumptions Summary page follows This illustration shows the Business Assumption Summary page for the OFS LRS application. You can add, view, edit, copy or delete definitions.

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.

Business Assumptions - Fields and Descriptions

Search Field or Icon

Description

SearchSearch icon

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 Refresh icon

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 Summary

Business Assumptions Icon Name

Icon

Description

Add

Add icon

This icon allows you to define a new assumption.

View

View icon

This icon allows you to view the selected assumption.

Edit

Edit icon

This icon allows you to edit the selected assumption.

Delete

Delete icon

This icon allows you to delete the selected assumption.

Copy

Copy icon

The icon allows a definition to be copied and resaved as a new definition.

Make Active

Make Active icon

This icon allows activating the selected version of the assumption. The active version of the assumption is considered for Run definition.

Workflow Summary

Workflow Summary icon Workflow Summary icon

The icon displays the approval summary for the definition.

Defining a New Business Assumption

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

Description of the Business Assumption Definition window follows This illustration shows the Business Assumption Definition window. You can define a new business definition using this window.

 


The assumption parameters enabled are specific to each assumption category and sub-category. To create a new business assumption, follow these steps:

1.     Click Add icon 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.

 

Business Assumption Definition

Field

Available Options

Section: Linked to

Business Assumption Definition Linked to section

Folder

Select the folder specific to the business assumption definition.

Access Type

Select either Read/Write or Read-Only.

Section: Assumption Details

Business Assumption Definition Assumption Details section

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

Business Assumption Definition Assumption Properties section 

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 Select Assets icon Select Assets icon icon. The Asset Browser window appears.

2.     Select the Asset Type, enter Name and Account ID.

3.     Select one or more members from a list of members displayed.

4.     Click Move icon Move icon to move the selected members to Selected Members section or click Move All icon Move All icon to select all members.

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 Select Dimension icon Select Dimension icon to view the hierarchy browser. All the dimensions in the FSI_LRM_REP_LINE_ATTR_DETAILS table are displayed. Click Move icon Move icon  to move the selected dimensions to the Selected Members section. 

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 Select Dimension icon. The Liquidity Risk Business Definition browser window appears.

2.     Select one or more  (maximum of 7) dimensions.

3.     Click Move icon Move icon or Move All icon to move the selected dimensions, or all dimensions respectively, to the Selected Members section.

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  Move icon or Move All icon to move the selected or all dimensions respectively to the Selected Members section.

7.     Click OK.

Exclusion Filters

Section: Dimension Selection

Dimension

To add a dimension, follow these steps:

1.     Click Select Dimension icon Select Dimension icon corresponding to Dimension Selection. The Liquidity Risk Business Definition browser window appears.

2.     Select one or more (maximum of 7) dimensions.

3.     Click Move icon Move icon or Move All icon to move the selected dimensions, or all dimensions respectively, to the Selected Members section.

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 Move icon Move icon or Move All icon Move All icon to move the selected or all hierarchies respectively, to the Selected Members section.

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 Select Dimension icon Select Dimension icon to select a Time Bucket Definition. The Time Bucket Definition Browser window appears.

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 BIS Time Bucket Definition icon BIS Time Bucket Definition icon icon corresponding to <Time Bucket 1> Selection and then <Time Bucket 2> Selection to define the time buckets. You can select one or multiple time buckets from the given time bucket definition. The selected time buckets are displayed as row items in the Assumption Specification table. The name of this parameter changes depending on the assumption category selected as per the following mapping.

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 Select Dimension icon Select Dimension icon corresponding to Cash Flow Interval Selection. The Cash Flow Interval Selection browser window is displayed.

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 Move icon Move icon or Move All icon to move the selected member or all the members, respectively, to the Selected Members section.

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 Grid Right icon Grid Right icon. 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.

Assumption Parameter Specification section

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 Select Dimension icon Select Dimension iconto 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:

Columns Displayed in Assumption Parameter Specification

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 Delete icon Delete icon icon.

·        To add a sub row to each row, for instance, to specify multiple <Time Bucket 2>, select a row and then click the Add Assets icon Add Assets iconicon.

·        To delete sub rows, right-click on the sub row to delete.

·        To enable Collateral Posting, select a row, and then click the Add Assets icon Add Assets iconicon. 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 Move icon Move icon to move the selected member, or click Move All icon Move All icon 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 (Add Assets icon Add Assets icon) icon. The Add Assets icon allows you to add as many assets as needed for the particular row in the grid.

Assumption parameter specification grid Assumption parameter specification grid

b.     Once the Add Assets icon is clicked, enter values in the following screen.

Description of the Add Assets window follows This illustration shows the Add Assets window.

c.     The business assumption definition after collateral and encumbered value is specified are displayed as follows.

Description of the Business Assumption definition window follows This illustration shows the Business Assumption definition window.

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.

 

 

 

Business Assumption Approval Process

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 

Sending Business Assumption Definition for Approval

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 Select icon Select icon to select a definition with the status “Draft”, “Open” or “In Review” from the list of business assumptions and then click the Edit icon Edit icon icon.

Figure 24 Business Assumption Summary - Draft Status

Description of the Business Assumption Summary - Draft Status page follows This illustration shows the Business Assumption Summary - Draft Status page.

Figure 25 Business Assumption Summary - Open Status

Description of the Business Assumption Summary - Open Status page follows This illustration shows the Business Assumption Summary - Open Status page.

Figure 26 Business Assumption Summary - In Review Status

Description of the Business Assumption Summary - In Review Status page follows This illustration shows the Business Assumption Summary - In Review Status page.

The Business Assumption Definition window is displayed with all the parameters defined.

Figure 27 Business Assumption Summary - Send for Approval

Description of the Business Assumption Summary - Send for Approval page follows This illustration shows the Business Assumption Summary - Send for Approval page.

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.

Approving a business assumption definition

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 Select icon Select icon to select a definition with the status Pending Approval from the list of business assumptions and then click the View icon View icon icon.

Figure 28 Business Assumption Summary - Pending Approval

Description of the Business Assumption Summary - Pending Approval page follows This illustration shows the Business Assumption pending Approval page.

The Business Assumption Definition window is displayed with all the parameters defined.

Figure 29 Business Assumption Definition - Approve/Reject

Description of the Business Assumption Definiton - Approve or Reject window follows This illustration shows the Business Assumption Definition - Approve or Reject window.

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

Description of the Business Assumption - Approve dialog box follows This illustration shows the Business Assumption Approve dialog box.

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

Description of the Business Assumption - Reject dialog box follows This illustration shows the Business Assumption Reject dialog box.

6.     Enter Approver comments and then click Reject.

7.     Click the workflowsummary 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

Description of the Business Assumption - Approval Summary follows This illustration shows the Business Assumption Approval Summary section.

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.

 

 

Retiring a Business Assumption Definition

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 Select icon Select icon to select a definition from the list of business assumptions and then click View icon View icon  or Edit icon Edit icon.

Figure 33 Business Assumptions - Retire

Description of the Business Assumption Summary page follows This illustration shows the Business Assumption Summary page.

The Business Assumption Definition window is displayed.

Description of the Business Assumption Definition - View page follows This illustration shows the Business Assumption definition - View page.

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.

 

Editing a Business Assumption

The process of editing a business assumption is as follows:

1.     To edit a definition, click Select icon Select icon to select a definition from the list of business assumptions and then click Edit icon Edit icon.

Figure 34 Business Assumptions - Editing a Business Assumption

Description of the Business Assumption Summary follows This illustration shows the Business Assumption Summary page.

·        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.