- User Guide
- Business Assumptions
- Cash Flow Assignment Methodologies
- Assumption Calculation
8.5.1 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 taken into account if the Changing Balance/Cash Flows option is selected in the Run Definition window.
- 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 i.e. assumption value is always applied on the original balance. This basis is applicable to each subsequent business assumption where the effects of the previous assumption are ignored for the purpose of estimating the impact of an assumption i.e. the assumption cash flows arising out of the given assumption.
Example 1: In case of 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
Table 7-63 Business Assumption Definition
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 Table 7-64 Assumption Calculation - Original Balance/ Cash Flows (Run-off)
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
Table 7-65 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% - Changing Balance/Cash Flows: - This takes into account 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, 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 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
Table 7-66 Business Assumption Definition
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 Table 7-67 Assumption Calculation - Changing Balance/Cash Flows (Run-off)
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
Table 7-68 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 Table 7-69 Assumption Calculation- Cash Flow Delay
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.