Loan Portfolio Analysis

Screen ID: 

Screen Title: 

Panel Number:

images\kb_closed_shg.gif

IGLBGT11-02

Current Portfolio - Loans

5838


Click here to magnify

 

This screen appears after selecting an option on the initial selection window.

This tool gives a quick a snapshot of your entire loan portfolio.  This tool is the easiest and best way to get a picture of your rates across all member accounts.  The “organize by” selection you made on the initial window controls what appears in the first two columns of the dashboard.

Click any column heading to sort the list by any column (click again to toggle between ascending and descending order).  Use the  button in the # Members column to export this specific group of members so that you can communicate with them via Member Connect.  Use the  button in the # Members column to see Common Bonds analyses for these specific members.

A Word About Online Credit Cards

If you have online credit cards, the system will include all of the rates from the individual rate “buckets” (purchases, balance transfers, and cash advances) found on each individual account.  For credit cards as well as other loans, the weighted average rates are calculated using the actual outstanding balance for each rate.

A Word About Written-Off Loans

This dashboard will automatically exclude written-off loans, but the method by which that is done depends on how the data is organized, based on the selection you made on the initial window:

Although it is rare, there might be situations where an individual loan account record is out of synch with the way your loan categories and G/Ls are configured, causing a written-off account to appear in one view but not when the data is organized a different way.

Analytics Booth: Power Line and Web View

Launching the Web View (F22) dashboard will provide additional tools to subscribers to analyze data that can only be found in Analytics Booth, including more screen real estate to view more data at one time, different filters and graphics, and new ways to understand the data. Non-subscribers will be presented with a splash page.

Use the Power Line (F23) button to launch an immediate trend line graph in Analytics Booth to help you better understand your data.

Not a subscriber? Learn more in the CU*Answers Store.  

Check out this video: Analytics Booth at a Glance (Board Members: More Analytics Booth Videos Below!)

Calculating Weighted Average Rates

The following sample illustrates how the system calculates the Weighted Average Rate and the Average Rate for this dashboard:

Note: Average Rate is calculated by adding all of the rates for all accounts and dividing by the number of accounts.  So in the sample above the average rate would be 4.150%.

Additional Video Resources

Check out these additional video resources!

Analytics Booth for Board Members: Features

Analytics Booth for Board Members: Password Reset

Analytics Booth for Board Members: First-Time Login

Analytics Booth for Board Members: Analyzing Peer Group Data

Analytics Booth for Board Members: Configuring Primary Peer Group

Analytics Booth for Board Members: Configuring Secondary Peer Group

Visit the CU*BASE video library.

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#IGLBGT11-02.htm