Peer Group Average Report
Peer Group Average Report – This report displays all UBPR ratios averaged by peer group in UBPR format. All peer groups are available. From the FFIEC Central Data Repository’s Public Data Distribution web site at the following URL address https://cdr.ffiec.gov/public/ManageFacsimiles.aspx you will be able to select the Peer Group Average Report from the Report drop down menu.
After selecting the Peer Group Average 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 Report. See print screen below.
In the print screen above a Peer Group Average Report was generated for Peer Group 5 – Insured commercial banks having assets between $300 million and $1 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:
Please note peer group averages 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 of $500 million will match to the peer averages contained in the Peer Group Average Report when generating a report for Peer Group 5 – insured commercial banks having assets between $300 million and $1 billion. In the print screen above, the ratio of Net Income as a Percent of Average Assets (ROA) of 1.16% as of 3/31/18 on the Summary Ratios Page – 1 will match the ratio displayed in the peer group column of the UBPR for XYZ Bank and any other bank that is included in Peer Group 5.
Computing Peer Group Averages
Peer group averages shown in the Peer Group Average 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 95th and below the 5th 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 5 is 1.16%. The 1,205 banks in Peer Group 5 (displayed as the last line item on the Summary Ratios–Page 1) have an ROA that ranges from -1.94% to 9.47%. After sorting the banks from highest to lowest ROA, 120 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, Net Income is the sum of each bank – s net income contained in Peer Group 5 – insured commercial banks having assets between $500 million and $1 billion.
Lastly, on the top left corner of any of the Peer Group Average Report pages you will notice a download button and on the top right corner a toggle button with the page defaulted to Table. 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 with the dates defaulted to Quarterly. The user can select the thumbnail to the right of any of the line items to display a graph for that line item. The user can also toggle to Year mode.
At the bottom of the graph there is a sliding date scale which can be used to display a preferred date range. The range displayed below is from 3/31/2001 to 3/31/2018.
Lastly, 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. Also, note Year mode is selected.
