18.1 Forward Liquidity Gap Variance Analysis in <Currency Type>
Table 18-2 Forward Liquidity Gap Variance Analysis
Field Names | Description |
---|---|
Report Name | Forward Liquidity Gap Variance Analysis in <Currency Type> |
Report Level Filters |
Reporting Bucket Definition: This is a drop-down selection. The drop-down list is displayed based on the Time Bucket Definition selected in the given Run. Bucket Level: This is a drop-down selection. The drop-down list is filtered based on the Reporting Time Bucket selected. Date 1: This is a drop-down selection of forward dates. The dropdown list is filtered based on the AsOfDate,Process/Run,Scenario and Run Execution Id selected as page level parameters. Date 2: This is a drop-down selection of forward dates. The dropdown list is filtered based on the AsOfDate,Process/Run,Scenario and Run Execution Id selected as page level parameters. Varaince As: This is a dropdown selection. There are two options available : Percentage Amount |
Report Description |
This report that displays the absolute and percentage variance between liquidity gaps in each time bucket across two forward dates. The name of this report changes based on the Currency Type selected as part of the Page Level Filters. For instance if the currency type is selected as Reporting Currency, the name of this report is displayed as Forward Liquidity Gap Variance Analysis in Reporting Currency. |
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 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 = Amount as on Date 2 – Amount as on Date 1 Variance Percentage = (Amount as on Date 2 – Amount as on Date 1) / Amount as on Date 1
Tabular Report: The following are displayed as row items: Total Inflows Total Outflows Liquidity Gap Cumulative Gap The time buckets corresponding to the bucket level selected as part of the report level filter are displayed as column items. Variance between 2 dates is displayed as column values as an amount or percentage depending on the variance as filter selection. |
Dimensions |
Time Buckets Calendar Forward Date Legal Entity |
Base measures |
Cash Flows Gap / Cumulative Gap |
Computed measures |
Total Inflows Total Outflows Liquidity Gap Cumulative Gap |
Drill through on |
Graphical Report: Graphical format is not available for this report.
Tabular Report: Tabular format is not available for this report. |
Drill through’s |
Graphical Report: Graphical format is not available for this report. Tabular Report: Tabular format is not available for this report. |