Loan Payments Analysis (1)

Screen ID: ILNPMT-01
Screen Title: Loan Payment Activity Analysis
Panel ID: 5743
Tool Number: 468
    Click here to magnify

 

Access this screen by selecting Tool #468 Loan Payments Analysis.

The Loan Payment Activity Analysis allows you to compare payments received to the due dates that were anticipated as of the prior month-end, allowing you to determine how loan payments are flowing through the system. This will give you the insight to better manage and understand how many dollars monthly need to go out the door in order to break even in your loan portfolio and then grow. The activity summary shows how many of the actual payments were over, under, or equal to the expected amount, and also provides information on early payoffs and members who made no payments. A variance between expected and actual payments is displayed to provide insight on how fast your loan portfolio is being paid off.

NOTE: The analysis will include only loans that were on the books as of the previous EOM snapshot. Loan payments made during the selected month that were not anticipated as of prior EOM will not be analyzed.

NOTE:  Two month end files are required to run this dashboard.  If your credit union has not been on the system that long, you will receive and error message.

Use the filters on the first screen to isolate loans by payment frequency, product type, loan category, business unit, collateral type, credit score range, and interest range for a more in-depth analysis of your loan portfolio. Press Enter to process to the second screen to see the activity summary.

Field Descriptions

Field Name

Description

Loan payment activity for

Select between Closed End (MEMBER5) or LOC (MEMBER6) loans to analyze.

Analyze payments received during

Select month and year (MMYYYY) to analyze. This will compare payments received that month with the due dates that were anticipated as of prior month-end.

NOTE: Analysis will include only loans that were on the books as of the previous EOM snapshot. Loan payments made during the selected month that were not anticipated as of prior EOM will not be analyzed.

Loan payment frequency

Defaults to monthly. Use the drop down to select a different payment frequency or All.

Product

To include only accounts of a specific loan product, use the Select button to reveal ascreen to select one or more business units. When you return to the screen, the count of the items selected will appear next to the button.

Business unit

To include only accounts with specific business unit codes, use the Select button to reveal ascreen to select one or more business units. When you return to the screen, the count of the items selected will appear next to the button.

Loan category

To include only loans for specific loan categories, use the Select button to reveal a screen to select one or more loan categories. When you return to the screen, the count of the items selected will appear next to the button.

Collateral type

To include only loans for specific collateral types, use the Select button to reveal a screen to select one or more collateral types. When you return to the screen, the count of the items selected will appear next to the button.

Current credit scores between

Use these fields to isolate loans by the credit score associated with the individual loan accounts.

Interest rates between

Select the from and to interest rate range for analysis.