Reports - UBPR
Changes to UBPR
|To: UBPR Users
August 26, 2004
John M. Smullen
Changes to UBPR
The UBPR web site has undergone several changes since
it was first made available three years ago. This latest set of enhancements
expands the export capabilities for the standard Uniform Bank Performance
Report (UBPR) and extends the capabilities of the UBPR Custom Peer Report.
- UBPR – Prior to this change
UBPR data could only be exported to a spreadsheet one page at a time.
Users may now select any combination of pages for export or download.
This change will substantially shorten the time it takes to export multiple
pages of UBPR data.
- Custom Peer Report Enhancements
– Several changes were made to the search engine. That engine
is used to identify banks for inclusion in a custom peer group. Additionally
the number of UBPR pages available in the custom peer report was expanded
and several other enhancements were added.
- The search engine was revised
to allow users to define peer groups using several new criteria.
New items that may be used to define a peer group are: Metropolitan
Statistical Areas (MSA); Sub Chapter S status; Asset size; Federal
Reserve District. The addition of these new elements should provide
additional flexibility when defining peer groups.
- The search engine now allows
users to select whether the peer group is trimmed of outlier banks
before peer group averages are recomputed. Once a custom peer group
has been defined, this feature appears at the bottom of the list
of custom peer group members. The standard UBPR trims or eliminates
banks that are above the 95th or below the 5th percentile for each
ratio before a peer average is computed. This trimming process has
proven to be very useful in reducing the impact of outliers on peer
group statistics. The custom peer report provides for the same statistical
process. Because most custom peer groups should be trimmed this
option defaults to being on. Trimming may be switched off in those
situations where it may be appropriate to include all banks in custom
peer averages. UBPR pages will note whether or not trimmed averages
- The custom peer report now computes
and displays all UBPR pages with peer group data. Previously only
page 1 was available. The menu for selecting custom peer group pages
has been revised as well and appears in a left hand window. To compute
custom peer data and display the results simply click on a page.
Once a page is selected the results are stored for the current session
and the page should redisplay instantly.
- The custom peer report also features
a highlighting tool. This tool allows peer group statistics to be
visually highlighted when they meet certain criteria. When the percentile
values either exceed certain values or change beyond a defined range
they are highlighted in color. This simple tool allows quick identification
of ratios where a bank may be an outlier.
- Individual pages within the custom peer
report now indicate that the report is based on a custom
peer group. Displayed pages also note whether peer group averages
were trimmed for outliers or not. Finally, page 1 also shows the
number of banks in the custom peer group.