30.1 Concentration Analysis

This section describes the parameters of the Concentration Analysis.

Table 30-2 Concentration Analysis Parameters

Parameters Description
Analysis Name Concentration Analysis
Report Level Filters
  • Tabular Report: Not Applicable.
  • Graphical Report 1: All the dimensions covered by this analysis, measures and Include Previous year (Y or N)
  • Graphical Report 2: Display Top X (10, 25, 50, 100, 250).
Analysis Description

This analysis provides a comprehensive and multidimensional view of the credit concentrations in the retail banking portfolio.

This analysis enables spotting of credit exposure, delinquency, and default concentrations in the retail credit portfolio of the bank, across multiple combinations of dimensions.

Reports Covered

This analysis is presented through a combination of Tabular and Graphical Reports, consisting of the following:

  • Concentration Analysis (tabular report): A multidimensional tabular report displaying the concentration by Number of Accounts, Number of Accounts Percentage, Gross Credit Exposure, Gross Credit Exposure Percentage, EOP Balance Total, EOP Balance – Total Percentage, Delinquent Exposure, Delinquent Exposure Percentage, NPA Exposure, NPA Exposure Percentage, Security Value and Security Value Percentage.
  • Concentration analysis (graphical report): A combination chart where the concentration is displayed by selecting a measure (GCE, EOP balance, Delinquent exposure, NPA exposure) and combination of dimensions. The column displays the selected measure and the line chart as a composition of the selected measure. You can also compare the previous year result in the graph by choosing Include previous year option as (Y or N).
  • GCE Concentration: A Bubble Chart, where each bubble representing a portfolio combination (based on the selected combination of dimensions) is analyzed for GCE Concentration, YoY percentage change in the EOP Balance, and WAPD of the portfolio.
  • Delinquent Concentration: A Bubble Chart, where each bubble representing a portfolio combination (based on the selected combination of dimensions) is analyzed for delinquent exposure, concentration, YoY percentage change in the EOP Balance, and WAPD of the portfolio.
  • NPA Concentration: A Bubble Chart, where each bubble representing a portfolio combination (based on the selected combination of dimensions) is analyzed for NPA Exposure concentration, YoY percentage change in the EOP Balance, and WAPD of the portfolio.
  • Concentration – Other Key Measures: A radar chart displaying the selected measure as (Number of Accounts, Security Value, and EOP Balance - Total) Concentration for a chosen portfolio (by selected combination of dimensions). You can filter the data using one of the following options: All Measures, No of Accounts, Security Value, EOP Balance and Total. You can filter the data using one of the following options: All Measures, No of Accounts, Security Value and EOP Balance – Total.
Dimensions
  • Line of Business
  • Product Type
  • Product
  • Organization Structure
  • Collateral Type
  • LTV
  • Customer Type
  • Natural Currency
  • External Credit Score Band
  • Insurance Coverage Band
  • Exposure Band
  • Legal Entity
  • Maturity Profile
Drill-down details Not Applicable
Drill-down Path Not Applicable