You are here: Reports > Borrower Profiles

BORROWER PROFILES

Function 
To provide staff, management, and funders with a broad spectrum of information related to each loan.


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.

Set Up Delinquencies
Sometimes it becomes important to include explanatory information in the Borrower Profile report. Selecting the Setup Delinquencies icon allows that information to be entered. Fields are available to enter the delinquent days (how far behind are the payments), the delinquent amount, and associated notes. For example, a loan may not have made a payment for several months, but the borrower is meeting on a regular basis with a small business counselor and a negotiated workout is being arranged. This situation can be documented under “Notes” and then it becomes a part of the report.

Operating Instructions
Loan Number               Select the appropriate loan number. 
Delinquent Days          Enter the number of days the loan is to be considered delinquent. 
Delinquent Amount    Enter the amount the loan is to be considered delinquent. 
Notes                             Document any special information to be included in the report. 

 

Process Buttons
Clear All Setup Deletes all lines entered in the Setup Delinquencies screen. 
Save          After entering Loan Delinquencies, you must select Save to retain the information. 
Print          Prints only information entered into the Setup Delinquencies screen. 

 

Interpreting the Report
Each loan included in the selection criteria and information about that loan will be listed in the report. Some data is pulled directly from the Loan Master file, and some is from the recorded activity to each loan.

Loan Master data includes: 

• County 
• Loan Type 
• Fixed Assets / Working Capital 
• SIC/NAIS Code 
• Ethnicity 
• Gender 
• City, State, County 
• RLF Amount 
• Public Funds 
• Private Funds 
• Owner Equity 
• Total Loan Package 
• Pre-loan Jobs 
• New Jobs 
• Minority Jobs 
• Female Jobs 
• FHOH Jobs 
• Handicapped Jobs 
• Date Closed 
• Interest Rate 
• Maturity Date 
• # of Years 
• Total Payments 
• Default Date (if applicable) 
• Default Balance (if applicable) 

 

Loan History data includes: 

• Last Paid-thru Date (current) 
• Principal Repaid 
• Interest Paid 
• Penalties / Late Fees Paid (Fees) 
• Loan Balance 
• Additionally, any information entered by selecting “Setup Delinquencies” will be included. 

Things You Should Know

• This report may be produced as often as desired with no consequence to the database. 
• Once the status within a Loan Master file has been changed to Default, the screen will prompt for a default date. This date, along with the loan balance as of this date, will be incorporated into the report. 
• The information related to loan activity (repayment, balance, principal, etc.) are affected by the cutoff date. Activity recorded with an activity date beyond the cutoff date will not be included. However, information related to the Loan Master file (RLF Amount, jobs created, ethnicity, etc.) are reported as they appear in the Loan Master file at the time the report is created. Borrower Profiles will not print for any loans whose Note Date is after the cutoff date. 
• Only one delinquency setup is allowed for each loan, and will be included any time the report is pulled unless deleted. As circumstances change, editing the delinquency setup will result in the newer information being included on subsequent reports. 
• If the selection criteria is narrowed for any option, it is important to select “Clear Selections” before beginning again. Another option for clearing selection criteria is to “Exit” the reports screen and then select “Borrower Profiles” once again from the Report Menu. 
• Once the report is displayed on-screen, it may be sent to a printer or exported to a file by clicking on the appropriate icon on the top task bar. 
• If any loans are missing the Closing Date in the Loan Master file this report will not be prepared. Instead you will receive a listing of the loans that are missing this date. Once the missing Closing Dates have been entered, you may then prepare the report.