Printing the Method B Delinquency Report

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

LDQAMB-01

Loan Delinquency Analysis Method B Report

625

LDQAMB

images\625g_shg.gif

Click here to magnify

 

Access this screen by selecting Tool #666: Print Method B Delinquency Report.

This report lets you analyze your delinquent loans using the NCUA Method B calculation (estimated balance). The fields on this screen let you control which loans are included on the report. Since Method B is most often used only for loans held longer than 15 years (typically mortgages), you can limit the scope of the report to make it easier to work with. 

The calculation looks at the original amortization schedule which defined what was supposed to happen over the life of the loan, then compares it to where the loan stands today. The report then shows:

(a)The balance the loan should have had as of today's date (“Estimated Balance”), and

(b)The date when the member should have reached the balance shown on the loan as of today's date (“Pay Date”); and then

(c)Calculates the difference in days between (b) and today's date (“Estimated Delq Days”).

See below for a sample of the report showing these columns.

Important Reminders

  • Because of the ability to disburse funds throughout the life of the loan, the report is NOT valid for open credit/LOC loans.

  • In order for this calculation to be accurate, there can have been no maintenance to key amortization data throughout the life of the loan. If you refinanced the loan or changed any other key data used by the amortization, the calculation may not match the original terms of the loan. Careful attention to detail on these loans is critical in order for the Method B analysis to be accurate.

Field Descriptions

Field Name

Description

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

Branch/location

(Optional) To include only loans assigned to a specific branch (location) number, enter the branch number here. Leave the field blank to include all loans.

Loan officer ID

(Optional) To include only loans authorized by a specific loan officer, enter the loan officer's Employee ID here. Click the lookup button images\magnifyingglasslookup_shg.gif to see a list of your credit union's configured codes. Leave the field blank to include all loans.

Loan category code

(Optional) To include only accounts with a specific loan category on the report, enter the category code here. Click the lookup button images\magnifyingglasslookup_shg.gif to see a list of your credit union's configured codes. Leave the field blank to include all loans.

Loan purpose code

(Optional) To include only accounts with a specific loan purpose code on the report, enter the purpose code here. Click the lookup button images\magnifyingglasslookup_shg.gif to see a list of your credit union's configured codes. Leave the field blank to include all loans.

Loan security code

(Optional) To include only accounts with a specific loan security code on the report, enter the security code here. Click the lookup button images\magnifyingglasslookup_shg.gif to see a list of your credit union's configured codes. Leave the field blank to include all loans.

Interest calc type

(Optional) To include only loans categories with a specific interest calculation type (such as mortgages), choose an interest calc type code here. Leave the field blank to include all loans.

Loan term (number of payments)

(Optional) To include only loans with a specific term, enter the total number of payments here. For example, to include all your 15-year mortgages, enter 180 here. Leave the field blank to include all loans.

Single loan account

(Optional) To calculate delinquency for only a single membership, enter the account base here. All loan accounts under that membership will be included.

Report Sample

images\4100rpt1_shg.gif

The first section of columns represents the account as it stands now in your member records. The “ESTIMATED” columns on the right edge of the report show the results of comparing the loan to the original amortization schedule. Notice there are two “Delq Days” columns: one shows the number of days delinquent as calculated by CU*BASE; the other shows the number of days the loan is delinquent according to the original amortization schedule.

  • NOTE: If your credit union performs Skip-a-Pay or extensions, these loans will appear in the report results.

images\4100rpt2_shg.gif

This summary shows your overall delinquency stats as calculated using NCUA Method B.