Loan Application Analysis - Summary Report

Screen ID:

Screen Title:

Panel Number:

Report Name:

LNRECAP-01

Management Loan Application Analysis

838

LNRECAP05

$images\838g_shg.gif$

Click here to magnify

Access this loan by selecting Tool #456: Loan Application Analysis Report.

Practical uses of this report:

With this tool, create a report:

To evaluate the productivity of your loan officers. What is the “look to book” for your lenders—meaning how many loans that cross their desks are approved, and how many are denied or still sitting in pending status?
To see your most popular loan category, purpose, or security code assigned to a loan for the month. Did rates or promotions affect this number? Conversely, what category had a low application rate? Do you have a product that needs a boost?
Over a period of time to see if the interest rate associated with booked loans is increasing or decreasing compared to the weighted average associated with the loan portfolio. Evaluate the numbers. Is change needed? Make some good loans.

With CU*BASE lending tools, credit union lending departments can record all lending member activity, whether loans are approved or denied, to allow your management team to see a well-rounded picture of the lending department's activity.

To make that picture even clearer, the Application Analysis Report shows a full statistical analysis of six different areas for the month's loan application activity. Each area is broken down into an analysis showing total applications processed, as well as the totals for Approved, Denied, and Pending applications. With this tool, one report can show you a summary of:

The status on a loan officer's ranking for the month.
This month's most popular loan category.
The leading purpose and security assigned to loans.
The rate where this month's loans were approved.

Use this screen to choose the parameters for the report (see Field Descriptions below). When ready, use Enter to generate the report. See below for samples of each of the six reports that can be created.

Remember that the system retains just one application on file for every member who has processed a loan through the CU*BASE lending software. It also will retain all activity for the last 60 days or two calendar months. Therefore, if you choose a date more than 2 months ago, data may be incomplete.

CU*TIP:Use Detail(F12) to print a more detailed report to be used for your monthly Loan Officer Minutes.

Field Descriptions

Field Name	Description
Corp ID	Enter the corporation ID to be analyzed (usually 01), or enter 99 to combine all corporations.
Month/year to process	Enter the month and year for which data should be shown. Normally three previous months are available. To run a report using month-end data prior to the months held online, contact a Client Services Representative. (There is a charge if this service is requested.)
From date To date	Use these fields to choose a range of application dates to include on the report.
Export to file	Use “Export report to file” go to the screen where you can choose to create a file to use with CU*BASE Report Builder.
Select Report	Place a checkmark on one or more of the seven different report formats to choose how the report data should be organized. For example, the “Part One: Loan Category” format shows total applications listed by loan category code. (See the samples shown below.)
Select Report Criteria	If you wish to narrow the scope of the report, use one of the following three fields: A single business unit – Click the Select key to reveal a screen. Select one Business Unit code to show only applications for that business type and use the Select option to return to the report filter screen.. A single category – Click the Select key to reveal a screen. Select a Loan Category code to show only applications for that loan type and use the Select option to return to the report filter screen. A single branch - Click the Select key to reveal a screen. Select one location/branch number to show only applications for that member branch, then use Select to return to the report filter screen. NOTE: In this case, the branch used, is the loan activity took place. A single loan officer - Click the Select key to reveal a screen. Select one Employee ID to see only activity for a particular loan officer as the Interviewer/Processor ID. Then use Select to return to the report filter screen.