The IMF 2019 Financial Soundness Indicators Compilation Guide (2019 FSI Guide)
DISCLAIMER:
This Concentration and Distribution Measures (CDMs) tool, for selected Financial Soundness Indicators, is provided to member countries only for their convenience. A key objective of the tool is to facilitate comparability, reproducibility and interpretability of CDMs across the membership. However, individual countries remain solely responsible for their reported CDMs. The IMF makes no representation or warranty of any kind, express or implied, about the tool’s completeness, accuracy, reliability, suitability or usability with every system.
INSTRUCTIONS
Step 1 : The CDM computation tool requires to open all three workbooks that comprise the tool: (1) the Output_CDM_Computation.xlsm; (2) the Input_Ratios_File.xlsm; and (3) theInput_Weight_File.xlsm workbooks; AND to enable macros.
Step 2 : In the two input files, go to worksheet “Controls” to select the relevant frequency and generate dates with the required format. The default option is quarterly.
Step 3 : In the two input files, delete the sample source data from all sheets. The sample data in these files were randomly generated for testing purposes only. Sample data can be easily deleted by selecting simultaneously all relevant sheets (holding Ctrl or Shift key down) and deleting all data starting from row 5 to row 104 ( see NOTE 1 below).
Step 4 : Fill in the Input_Ratios_File and the Input_Weight_File workbooks with your data. The Input_Ratios_File is for the bank by bank FSIs, while the Input_Weight_File should contain the underlying denominators used to calculate the bank by bank FSI ratios.The Input_Weight_File also contain a sheet (Total_Assets), which is used to compute the Herfindahl concentration index. Please note that the worksheet Total_Assets must always be filled in regardless of the selection of the FSIs on which CDMs are computed. The first column (A) in all worksheets must contain the Institution Code that uniquely identifies each bank for which FSI ratios and underlying denominators are entered, starting with row 5.
Step 5 : When all data have been entered in the two input files, in the Output_CDM_Computation.xlsm (worksheet Intructions and controls), click on the " Click here to start CDM computation" button to start CDM Computation. A new menu will pop up.
Step 6 : Select the relevant options from this menu. Hold the Shift or Ctrl key down on your keyboard to select multiple FSIs on which you would like to compute the CDMs. Click the "Run" button to compute the CDMs or the " Cancel" button to start over.
Step 7 : Computed CDMs are shown in the "CDMs" worksheet of the Output_CDM_Computation.xlsm file. When updating the output file, computed CDMs are visible for the selected periods only. Columns prior to the selected starting period are hidden, although previously compiled data are still available. Unhide the relevant hidden columns to see any historical CDMs.
NOTES
1 - Since CDM computation relies on bank codes and dates, this information must be provided in the two input files. See step 2 above to automatically generate dates with the required format.
2 - The program was tested using Microsoft Excel 2016. It might not work properly with older versions of Excel.
3 - Do not change the format of these three workbooks. You may hide irrelevant columns, but do not delete any columns or any worksheets in any of the three files.
4 - Always use extension xlsm when saving the three files. Do not change the names of the two input workbooks and worksheets.