State Average Report - This report provides a summary UBPR ratio data and selected aggregate information averaged by state. A further breakdown of average statistical data is provided by asset size. The information is provided for all states and territories in UBPR format 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 State Average Report from the Report drop down menu.
After selecting the State 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 State or Territory drop down menu becomes populated with a list of all available States and U.S Territories. See print screen below.
After a state is selected the Peer Group drop down menu becomes populated with two choices: All insured commercial banks (CACOM) or all insured savings banks (CASVG). California is selected in this example.
After the peer group of choice is selected the user should select the Search button on the top of the page to display the State Average Report.
In the print screen below a State Average Report was generated for the peer group all insured commercial banks in California. 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 five columns of ratios. See print screen below. The date format is as follows:
Please note ratios displayed in this report are for all banks headquartered in a particular state. California is selected in this example. For example, as of 3/31/18 in the above print screen, the trimmed average for Interest-Bearing Bank Balances as a Percent of Average Assets for all insured commercial banks in California is 8.59%. The 156 insured commercial banks in California ratio of Interest-Bearing Bank Balances as a Percent of Average Assets ranges from 0 to 90.85%. After sorting the banks from highest to lowest Interest-Bearing Bank Balances as a Percent of Average Assets, 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; although 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
Computing Peer Group Averages
Peer group averages shown in the State 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.
On the top left corner of any of the State 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.
In the print screen below, 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 below there is a sliding date scale which can be used to display a preferred date range. The range displayed below is from 12/31/2004 to 3/31/2009.
Lastly, on the upper right corner of the graph below 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.