Peer Group Average Distribution Report - This report provides a distribution or range of values for all ratios that appear in the UBPR by peer group. The report can provide valuable insight into the population of banks that are used to calculate peer average data that appears in the UBPR. The report displays ratio distribution data in UBPR page format. From the FFIEC Central Data Repository's Public Data Distribution website at the following URL address https://cdr.ffiec.gov/public/ManageFacsimiles.aspx you will be able to select the Peer Group Average Distribution Report from the Report drop down menu.

After selecting the Peer Group Average Distribution Report from the menu of Report choices you will notice the following screen.

The user will need to select a date from the Report Date drop down menu. Please note the existing date defaults to the most recent quarter-end date which may not have peer group statistics generated yet. For example, peer group statistics are generally not available until 45 days after quarter-end. In the above print screen the user can select March 2018 since this report was generated more than 45 days after the March 2018 quarter.

After the correct report date is selected the Peer Group drop down menu becomes populated with a list of all available UBPR peer groups. After the peer group of choice is selected the user should select the Search button on the top of the page to display the Peer Group Average Distribution Report. See print screen below.

In the print screen above a Peer Group Average Distribution Report was generated for Peer Group 3 - Insured commercial banks having assets between $3 billion and $10 billion. Below is a print screen of the Cover Page of this report.

You will notice not all UBPR pages are generated for this report. This is because only pages that contain ratios will be generated (i.e., UBPR pages with only monetary amounts will not be generated). Consequently, only the following UBPR pages will be generated:

A typical page in this report will contain twelve columns of ratios. Columns one through eleven displays ratios for the eleven different percentiles used in the report. The following percentiles are used in the report: 1^st, 5^th, 10^th, 20^th, 25^th, 50^th, 75^th, 80^th, 90^th, 95^th and 99^th. The last column displays ratios for a trimmed average. See print screen below.

Please note the ratios displayed in the - Trimmed Average - column shown in this report match the peer averages contained in a UBPR for a particular bank. For example, the peer group averages contained in a UBPR generated for a bank (say Bank XYZ) with total assets between $3 billion and $10 billion will match to the peer averages contained in the Peer Group Average Distribution Report when generating a report for Peer Group 3 - insured commercial banks having assets between $3 billion and $10 billion. In the print screen above, the ratio of Avg Earning Assets to Avg Assets of 93.86% on the Summary Ratios Page - 1 will match the ratio displayed in the peer group column of the UBPR for XYZ Bank as well as any other bank that is included in Peer Group 3.

Computing Peer Group Averages

Peer group averages shown in the last column in the Peer Group Average Distribution Report are a trimmed average of the ratios for individual banks. The peer group average for a given ratio is trimmed or adjusted to eliminate the effect of outliers or banks above the 95^th and below the 5^th percentile. The resulting average in most cases is very close to the median or mid-point value for a given group of banks. Thus, the peer group average could be thought of as representing the performance of the-bank-in-the-middle for a specific ratio. It should be noted that the group of banks averaged for one ratio will differ from that used in other ratios. This occurs because the top and bottom 5% of banks designated as outliers will change from ratio to ratio. Consequently averages for separate ratios cannot be added or otherwise combined. The resulting peer group ratios are very stable over time and are not influenced by outlier banks.

For example, in the above print screen the trimmed average Return on Assets (ROA) for Peer Group 3 is 1.28%. The 141 banks in Peer Group 3 have an ROA that ranges from .13% to 2.63%. After sorting the banks from highest to lowest ROA, fourteen banks were identified as being in the top and bottom 5% and excluded from the group of banks to be averaged. Currently, such detailed peer group statistics are only available via accessing the CDR database tables; however, at the moment only CDR programmers have access to such data. However, users can download bulk data files located at Download Bulk Data - FFIEC Central Data Repository's Public Data Distribution and sort through the data to achieve the same results; titlehough this would be a time consuming endeavor. When a UBPR line item is reported by only a small group of banks within a peer group, an insufficient number of valid observations can distort peer-group data. To minimize this problem, a floor has been set for the minimum number of ratio values that may be used to calculate the peer group average. If fewer than five ratio values are available to compute the peer group figure, a double number sign (##) is displayed rather than the value.

Please refer to the UBPR Users Guide-Technical Information for more information regarding peer groups. https://cdr.ffiec.gov/CDRDownload/CDR/UserGuide/v98/Technical%20Information.pdf

On the bottom of the Summary Ratios--Page 1 you will notice the following three line items which are not ratios: Average Total Asserts, Total Equity Capital and Net income. For purposes of this report these line items represent the sum of all of such balances for all banks in the selected peer group. For example, in the print screen below, Average Total assets is the sum of each bank - s average total assets contained in Peer Group 3 - insured commercial banks having assets between $3 billion and $10 billion.

On the top left corner of any of the Peer Group Average Distribution Report pages you will notice a download button and on the top right corner a toggle button with the page defaulted to Table mode. See print screen below. When the user selects the Download button the report pages selected in the left side of the report page will be downloaded into a text file. In the example below the following three pages will be downloaded to a text file: Liquidity & Investment Portfolio--Page 10A, Capital Analysis--Page 11, and Fiduciary & Related Services--Page 1.

When the user toggles to Graph mode the first line item on the report page will be depicted as a line graph based on percentile rank. See print screen below. The user can select the thumbnail to the right of any of the line items to display a graph for that line item. On the upper right corner of the graph there is a Download button that can be selected to download the graph into the following three graph formats: PDF, JPEG and SVG.

Lastly, at the bottom of the graph there is a sliding scale which can be used to display a percentile rank range.