You are here: Reports > Aging Report
AGING REPORT
|
Function
To provide an analysis of the portfolio quality as it relates to current and delinquent loans. Operating Instructions Cutoff Date This date defaults to the current date but may be changed by selecting from the calendar. The cutoff date will determine which activity will be included in the report. Any recorded activity with an activity date beyond the cutoff date will not be included in the calculations. Loan Number The screen will automatically default to include all loans found within the database. You may override the selection by either entering the loan # or selecting from the combo box. To narrow the selection to only one loan, enter or select from the combo box, the appropriate loan number in both the beginning field and the “to” field. Sort Options Using the combo box, select the order in which the data is to appear. Selections include: #Loan Number A Alphabetical $Loan Amount Loan Officer Payment Due Date You may also enter #, A, or $ if do not wish to utilize the combo box. If the sort is to be by Loan Amount, it will be based on the amount in the Loan Master file, Loan Terms tab, Loan Amount field. This does not always match the dollars disbursed. Sorting by Loan Officer will insert a page break between each Officer. Sorting by Payment Due Date will separate loans according to their due date. Selection Criteria Options for narrowing selection criteria include: Fund County City Status Loan Officer Loan Type Borrower Type The following instructions relate to limiting the search to specific Fund(s), and the same instructions apply to each of the potential criteria above. If you do not wish to include all loans, click on the “funds” tab. All existing funds will be displayed for your selection. To select a fund, move the cursor to the fund to be included and click – it will then be highlighted, indicating loans with that fund are to be included on the report. If you wish to include more funds, hold down the Ctrl key and click on the additional fund to be included. If you select a fund by mistake, hold down the Ctrl key and click on the fund again – the highlighting will disappear, indicating it no longer is to be included in the selection criteria. Continue this process until you have narrowed the search to include only those loans you wish to review. Include Active $0.00 Balance Loans Checking this box will cause all Active Status loans to print, regardless of balance. Include Borrower Name: Removing the checkmark will generate a report without the borrower’s name included. Only the borrower’s Loan ID will appear on the report to assist in identifying the loan. Interpreting the Aging Report At the top of the report, you will find the selection criteria, including cutoff date, as entered. The date and time of the report is also included. Loan Reflects the number associated with each loan. Company/Borrower If the Loan Master file contains information found under “Company Loan Information” the company name as entered will appear. If the Loan Master file contains information under “Personal Loan Information” the first and last name of the borrower will appear. Loan Amount This is the number listed under Loan Amount within the Loan Master file. Disbursed Reflects the total amount disbursed to the loan as of the cutoff date. Current Balance Reflects the loan balance as of the last recorded activity prior to the cutoff date. Regular Payment The Loan Master file, Loan Terms field titled Payment including Service Fees and Escrows is shown here. Analysis of Payments Due: 1 payment – if any loan is delinquent by a minimum of one payment, that payment amount will be reflected in this column 2 payments – if any loan is delinquent by a minimum of two payments, the second payment amount will be reflected in this column. 3 payments – if any loan is delinquent by a minimum of three payments, the third payment amount will be reflected in this column. Over 3 – if any loan is delinquent by a minimum of four payments, the total of the payments beyond three payments delinquent will be reflected in this column. Total Due The amounts in Analysis of Payment Due columns are totaled into this column. Late Days Calculated as the days between the date the next payment was due and the cutoff date. Total Delinquent Dollars If any loans are found delinquent, the current balances for those loans are added together and listed under the appropriate column. Percent Delinquent The total loan portfolio balance is divided by the “Total Delinquent Dollars” to create a percentage. Things You Should Know
|
|
Copyright © 2019 GRANTS MANAGEMENT SYSTEMS, INC.