5.5 Liquidity Gap Variance Across Runs in Base Currency
Table 5-6 Liquidity Gap Variance Across Runs in Base Currency
Field Names | Description |
---|---|
Report Name | Liquidity Gap Variance Analysis Across Runs in Base Currency |
Report Level Filters |
Gap Type: This is a drop-down selection of one of the following options: Liquidity Gap and Cumulative Gap. Variance as: This is a drop-down selection of one of the following options: Amount and Percentage. Run: This is a drop-down containing a list of runs that are mapped to the underlying contractual run of the run selected as part of the page level filter. Run Execution ID: This is a drop-down selection containing a list of run execution ID’s for the selected second run. The drop-down list displays only those executions that have a FIC_MIS_Date equal to the As-of-Date selected at the page level. |
Report Description |
This report displays the absolute and percentage variance between liquidity gaps in each time bucket across two runs. The graphical report displays the liquidity gap or cumulative gap calculated as part of both runs in each time bucket as well as the variance between the two runs. The tabular report displays the detailed variance between two runs. Time buckets are displayed based on the bucket level selected as part of the page level filter. The Run selected as part of the page level filters is considered as the main Run against which the variance is calculated. |
Report Type |
Graphical Report: Combination of Line and Column Chart Time Buckets of the selected bucket level are displayed on the X-axis. Liquidity gaps or cumulative gaps are displayed on the primary Y-axis across two runs as column values based on the gap type filter selected. Variance is displayed as a line on the secondary Y-axis in terms of absolute amount or percentage based on the variance as filter selection. Variance is calculated as follows: Variance Amount = Run 2 Amount – Run 1 Amount Variance Percentage = (Run 2 Amount – Run 1 Amount) / Run 1 Amount Tabular Report: The following are displayed as row items: Inflows – Principal, Interest and Total Outflows – Principal, Interest and Total Liquidity Gap – Principal, Interest and Total Cumulative Gap – Principal, Interest and Total The time buckets corresponding to the bucket level selected as part of the page level filter are displayed as column items. Variance between two runs is displayed as column values as an amount or percentage depending on the variance as filter selection. Note: Gap type filter is not applicable for the tabular report. |
Dimensions |
Legal Entity Currency Principal/Interest Cash Flows Line of Business Product Type Product Customer Type Customer Account |
Base Measures |
Principal Cash Flows Interest Cash Flows |
Computed Measures |
Total Inflows Total Outflows Liquidity Gap – Principal, Interest and Total Cumulative Gap – Principal, Interest and Total Variance Amount Variance Percentage |
Drill-through On |
Graphical Report: Clicking each column in the column chart. Tabular Report: Row level drill- through on the principal, interest and total components of Inflows, Outflows and Liquidity Gap. |
Drill-through’s |
The drill- through sequence remains unchanged for both the tabular and graphical reports as follows: Level 1: Line of Business Level 2: Product Type Level 3: Product Level 4: Customer Type Level 5: Customer Level 6: Account Graphical Report: On clicking each column the drill-through report will display the break-up of all three measures such as Run 1 amount, Run 2 amount and variance across the dimension on the drill-through. All drill- through reports is a combination of line and column charts as per the original report. Tabular Report: Drill- through is enabled on the following row items as per the drill- through sequence available as part of the Liquidity Gap Analysis - <Currency Type> report: Inflows – Principal, Interest and Total Outflows – Principal, Interest and Total Liquidity Gap – Principal, Interest and Total The measure displayed is variance as an absolute amount or a percentage based on the report level selection. |