Follow your ratios from one quarter to the next

Who, when. You want to follow the institution’s solvency, liquidity, leverage or profitability at every closing, spot what moves and comment on it. This guide chains the indicators, the dashboards, their results and their exports. It assumes the reportings of each date are uploaded in a perimeter (see Check a filing before submission).

1. Build the list of indicators

An indicator is a value computed from the reportings, for instance {C 01.00, r0010, c0010} / {C 02.00, r0010, c0010}. Two ways to fill the Controls & indicators › Indicators › Custom indicators library:

  • Import the EBA indicators copies into your indicators the EBA risk indicators the application can compute, with the EBA tag (see How to import the EBA indicators). This is the starting point.
  • New indicator or Import (.xlsx) for your own: an internal ratio, an outstanding amount, an aggregate (see Indicators and dashboards).
Tip
  • Choose the Ratio type for a percentage, Amount for a number: it decides the display and the Excel format.
  • An indicator’s formula has one member and no comparison. An open-row coordinate r999 only enters it inside sum, sumtop, sumif or length (see Indicator formulas).
  • The EBA list is corrected and extended from one version to the next: run the import again with Overwrite my indicators that have the same reference to update it, leaving the option unticked if you have adapted formulas.

Check the Validity column: an indicator that is not Valid for the taxonomy in force is not evaluated, its value is NaN (see Validity status).

2. Compose the dashboard

In Analysis › Dashboards, create one dashboard per theme or per committee, for instance “Prudential ratios — ALCO”, and tick its indicators (see Indicators and dashboards). From the indicator list, Add to dashboard… does the same starting from a selection (see How to add indicators to a dashboard).

Give each indicator a first tag, for instance “Solvency” or “Liquidity”: it groups the sections of a workbook template (step 6).

3. Run on several dates

Execute dashboard asks for a perimeter, one or more reporting dates, the period type and the files. Tick the files of every date to follow: the result has one column per date, and the differences are computed between neighbouring columns.

Warning

By default, only official reportings are offered. A date without an official reporting is missing from the result until you untick the official-only option, or until the file is marked official.

The run appears in the In progress tab, then in Runs. Each run is a snapshot: it keeps the indicators’ formulas as they were at computation time, and your annotations stay its own.

4. Read the result

On the result page, each indicator has its block:

  • the table of values by date, with Delta (abs) and Delta (rel). The relative difference is taken against the absolute value of the previous value, so its sign follows the direction of the change;
  • the mean, minimum, maximum and standard deviation;
  • the chart, with the mean and the one- and two-standard-deviation bands.
Tip

Start with the Higher variation than filter and with the highlighted rows: a change greater than one standard deviation is highlighted. The “Hide lines with some NaN values” filters hide the indicators that could not be computed on a date; turn them off to see them and understand why, often a template missing from that date’s reporting.

Show Audit Trail shows the value of every data point used: this is where a surprising figure is checked, before looking for a business explanation.

5. Review and comment

Each block carries review elements: a status (Validated, Validated with reserves, Not validated), a priority (P0 to P3) and comments. They are saved as soon as they change, and belong to this run only.

One way to work:

  1. Not validated and P0 or P1 for any unexplained change; the comment says what is expected from whom.
  2. Validated with reserves for an explained change still to watch.
  3. Validated for the rest.

The Summary tab shows one chart per priority, split by status: this is the committee’s view.

6. Export and present

The three icons of the result page produce exactly what the filtered screen shows:

  • Print, for a quick review;
  • PowerPoint, one slide per indicator with the table, the chart, the status, the priority and the comments: the committee pack;
  • Excel, with the values, the audit trail and the applied filters.

For a workbook in your own layout, use a dashboard template: an Excel workbook whose %%…%% cells hold indicator formulas, filled at generation, or built directly from your indicators with Generate from indicators, one section per tag.

7. The next quarter

At the next closing, upload the reportings, mark the official one, then execute the dashboard again, ticking the new date together with the previous ones. The Results column of the Runs tab counts the indicators by review status: a recent run where everything is “not evaluated” is a run nobody has reviewed yet.

Note

The EBA risk indicators computed by the Pillar 3 module are another set: 21 KRIs of the Risk Dashboard, computed for each workbook and compared with the EU distribution, not editable. Your imported indicators are the full list, to follow over time. Both coexist (see The EBA indicators and the Risk Dashboard).