You are here: Reports > Accrued Interest Analysis
ACCRUED INTEREST ANALYSIS
|
Function
To provide accurate information regarding delinquent interest to assist with cash-flow and income projections. 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 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. 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. Interpreting the Accrued Interest Analysis Report 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. Pmts In the Loan Master file, Loan Terms tab, there is a field titled Total Pmts. The data within that field is shown here. Rate This shows the annual interest rate for each loan. Last Balance Reflects the loan balance as of the last recorded activity prior to the cutoff date. Last Activity Reflects the date of the most recently recorded activity prior to the cutoff date, along with the amount of that activity. Days Calculated as the days between the Last Activity date and the cutoff date. Accrued Interest The sum of any accrued interest recorded in the loan history plus interest that has accrued between the Last Activity Date and the cutoff date. Current Balance The sum of Last Balance plus Accrued Interest. Things You Should Know
|
|
Copyright © 2019 GRANTS MANAGEMENT SYSTEMS, INC.