NT\ABL Asset-Based Lending System

The NT\ABL system is currently in production in the ABL departments of over 100 Banks and Finance Companies throughout the world. NT\ABL has the flexibility to grow with your company and can be used to monitor portfolios from as little as $100,000 to over $100 billion in size. Developed in 1998, NT\ABL is an evolution or our original Asset-Based Lending Manager (WinABLM), which was created in 1979. NT\ABL utilizes the most up-to-date Microsoft technology: Windows SQL Server database using stored procedures connected to a 32-bit Visual Basic client program.


A remote demonstration is available upon request. Please contact Alan Jasenovic at (435) 336-2957 or via E-Mail: for additional information or to request a brochure.


General System Information:


Ease of Use
NT\ABL features an intuitive user interface with menu driven programs that allow point and click access to programs. In the time critical world of asset-based lending, built in key-stroke shortcuts can accelerate the data entry process associated with your daily work. Up to 10 program screens can be opened simultaneously. This allows for easier access to frequently used screens, and quick comparison from screen to screen.

Full Service Lender, or Specialized Finance Company
NT\ABL is a full service system that can be used as your system of record to calculate availability, produce interest and fee statements and transmit daily transaction records to your General Ledger system. However, if you already have a system of record in place such as AFS©, Metavante©, Shaw©, etc, NT\ABL can be used as a collateral management tool to calculate availability, and monitor your clients ineligibles.

Technical Information
NT\ABL can be set up as Stand Alone system; in a Local Area Network; or in a Wide Area Network. Loaded on a Windows 2000 or Windows 2003 server NT\ABL uses a Microsoft SQL server database. A client / server system, the application is loaded on each individual workstation and communicates with the database via an ODBC connection.

NT\ABL System Features:


Tracking of Collateral and Loan Balances
The primary function of NT\ABL is to calculate your client’s availability position. The system allows you to monitor and update your clients’ current collateral and loan balances, as well as calculate amounts that are considered ineligible for lending. Based on these changing balances, the availability position is updated on-the-fly, allowing you to make informed decisions regarding borrowing requests. NT\ABL eliminates the spreadsheets many lenders use to monitor collateral and loan balances.

Client and Loan Structure
Your portfolio may contain a variety of clients with varying degrees of complexity. NT\ABL can handle clients with simplified structures (A/R and Inventory), as well as clients with more complex structures (Subsidiary company lines, multiple A/R lines, Inventory with various advance rates, Term Loans, LIBOR loans, Participations, Letters of Credit, etc.) To calculate a client’s availability, NT\ABL allows you to establish commitment amounts, sub-line limits, loan limits, advance rates, ineligible amounts and reserves.

Daily Loan Posting
Updates to a client’s collateral and/or loan position are entered in the Daily Loan Posting program. This program allows Collateral Analysts to input Borrowing Base Certificates, Lockbox receipts and post Advance requests. Availability analysis, ineligible updates and loan ledger history is also found on the same program so a Collateral Analyst can update and review information, without having to open and close multiple programs in the system.
NOTE: Borrowing Base Certificate updates can be posted by your clients via StuckyNet-Link, eliminating this portion of the data-entry process for your Collateral Analysts.

On-line Advance Approval
Loan officers can review a client’s availability position and authorize an advance request on-line. A password in entered in lieu of a signature and the loan balance is updated after the approval has bee received. This process allows Loan officers in other parts of the building or even in other regions to be part of the daily approval process.

Collateral and Loan Ledgers
The Microsoft SQL database maintains the detailed posting ledgers for the life of the loan, allowing you to review the historical postings or produce historical reports at any time.

Daily and Monthly Activity Reports
Daily reports can be produced to monitor the portfolio’s outstanding collateral and loan balances, check for out of formula situations, and monitor ticklers that are past due. Monthly reports summarize the interest and fees calculated for the entire portfolio.

Calculation of Interest
As a full service system, NT\ABL can calculate interest and fees at Month-End and produces both an ‘In-House’ and ‘Client’ copy of the Interest and Fee statements. Interest calculations can be based on an amount above the Prime rate, using a Flat Interest Rate, or using a LIBOR rate. Interest due can be collected in one of 3 ways:
  • 1. Capitalized: Interest is added back to the client’s loan balance
  • 2. Accrued: Interest is paid by check or wire
  • 3. DDA Sweep: Interest is swept from a Demand Deposit Account.

Fees
NT\ABL also has the ability to automatically assess fees. Fee types include:
  • Unused Line Fee
  • Collateral Monitoring Fees
  • Wire Fees
  • Insufficient Funds (NSF) Fees
  • Deferred Fees (for origination fees)

Print to .PDF and Send to .PDF by Client
All reports within the NT\ABL system can be saved in the Adobe .PDF file format. The .PDF format is readable by Adobe Acrobat Reader®, which is available as a free download to you and all your clients. Saving reports as a .PDF allows you to save and file electronic copies of reports so you no longer have to archive hardcopies of Interest Statements and other daily and month-end reports. Additionally, on several reports there is an option to Send to .PDF by Client. This allows you to print the entire portfolio with one button, and the system will automatically create a separate .PDF file for each client within the portfolio. At Month End you can automatically create separate .PDF files for each of your clients and send them an electronic copy of the Interest Statement and/or Loan Ledger Report via E-Mail.

Trend Reporting
Several reports and graphs allow you to monitor Monthly Trend History, which can be viewed for a 24-month span. Trend information can be produced on large reports, combining various balances for comparison purposes, or specific trend information (such as A/R spread information) can be produced on separate reports for detailed analysis.

Tickler Posting
A tickler system is built into NT\ABL to create automated reminders for either recurring tasks (Field Audits, Loan Renewals, etc.) or for required documents that your clients must provide on a recurring basis (Monthly A/R Agings, Financial Statements, Inventory Reports, etc.)

Exception Tracking
Red Flag criteria can be established so the system can monitor a client’s activity. When a client does not meet the expected criteria, the item exceeding the criteria appears on the Exceptions Management report. Some of the items NT\ABL can monitor are: Sales activity (number of days since last sale), Collection activity (number of days since last collection), Ineligible fluctuations, Dilution percentage out of range, A/R turnover out of range, Loan turnover out of range, etc.

Multiple Parameters Graphs
Graphs can be created using all available information stored in NT\ABL and can be produced at a Client Level, Loan Level, or Portfolio Level. Graphs can be copied and saved to Microsoft Word, or Excel for review or for presentations.

Excel Interface
The built-in Excel interface allows you to extract data directly from the NT\ABL database to create your own custom reports and spreadsheets.

Accounts Receivable Detailing (ARS)
The ability to track collateral on an invoice by invoice level is integrated into the NT\ABL system. The A/R detail information entered in NT\ABL (manually or uploaded electronically) can then be used to calculate ineligibles, update the list of high concentration debtors, and store the aging spread history.

Audit Verification (AVS)
NT\ABL includes the ability to create Audit verification letters that are sent to your clients’ customers. Verification letters can be created manually or automatically if the aging has been imported into NT\ABL via the aging import process. Verification history is maintained for the life of the loan for future review.

Auto E-Mail
If you are currently using Microsoft Exchange Server as your E-Mail system (aka Outlook), you can send reports to your clients via E-Mail directly from the NT\ABL system. Frequently requested reports such as Loan Ledgers, Status Reports and monthly Interest and Fee Statements are saved as .PDF files and sent as E-Mail attachments through the Contact Management program in NT\ABL. Other saved reports such as Excel Spreadsheets and Word documents can also be sent via E-Mail through the NT\ABL system.

Multi-Currency Capability
NT\ABL has the ability to monitor collateral or loan balances in foreign currency amounts. Loan information is entered into the system in the client’s local currency type and the balances are converted at the Grand Total line to the system currency on various reports and inquiry screens. A user maintainable conversion table identifies the current exchange rate.

Departmentalized Security
Individual departments can be established for different user groups. The system administrator can limit access to certain key areas of NT\ABL based on departmental requirements. For example to restrict the modification of loan limits, advance rates, etc. Security levels can be created to limit users groups such as Loan Officers or Field Auditors to have inquiry level access to NT\ABL for reporting and view-only privileges.

Electronic Interfaces:
Several processes can be automated by means of custom or canned programming that greatly increases the efficiency of an asset-based lending operations department. At WSA we have either installed such programming or are working on new products that provide the following:

Client Aging Import
The A/R Detailing sub-system for NT\ABL allows your clients to submit an A/R aging in an electronic text file format. A separate software product called Monarch®, a text editing tool by Datawatch (www.datawatch.com) is used as a conversion tool for all the different aging formats you will receive. The imported aging is then used to calculate ineligibles within the NT\ABL system. Aging information can also be used to create written verification notices in NT\ABL’s Audit Verification system, which can be forwarded to the client’s customers. (This feature is included in the standard NT\ABL system, but requires the use of Monarch software.)

StuckyNet-Link
StuckyNet-Link is add-on Internet software package to NT\ABL that allows your borrowers to post their borrowing base certificates on-line via a secure web site. It also allows the borrower to view and print loan ledgers, interest statements and review their availability position. Additionally, the borrower can submit electronic text file copies of A/R agings, sales registers and cash receipt registers via StuckyNet-Link. (StuckyNet-Link is available at additional cost.)

Letter of Credit
Daily electronic download of LC balances from your bank or Letter of Credit processor. (This requires custom programming.)

Cash Receipt Posting
Receive daily cash receipts from your clearing bank and automatically post against the client’s collateral and loan in NT\ABL. (This requires custom programming. We currently have over 50 clients with this interface in place.)

Wire Transfers
Upload daily wire transfer instructions to your bank. (This requires custom programming. We have a number of finance companies with this interface.)

General Ledger Interface:
A standard G/L interface file is included in NT\ABL. A transaction file is output that can update your G/L automatically from the postings and interest generated in NT\ABL. (This may require some custom programming if your accounting system requires a specific file format.)