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. |