Case Studies

Project Profile for the Dealer Reserve System

Executive Summary

Company

Illiana Financial, based in Calumet City, Illinois was organized in 1936 as a cooperative financial institution.

Solution Description

The Microsoft Access database application provides a solution to efficiently calculate dealer reserve amounts.

Benefits

Detailed reports offering in-depth analysis include:

  • Delinquent Accounts by Dealer (over 60 days)
  • Dealer Weighted Yield

Software and Services

  • Microsoft Windows XP
  • Microsoft Access 2003
  • Windows 2003 Server
  • XP Systems XP2
  • IBM DB2 Database
  • IBM eServer pSeries
  • Adobe Acrobat

Customer Profile

Sector: Banking
Industry: Regional Banks
Assets: $154.0 Million

Illiana Financial is a cooperative financial institution with $154 million in assets and four offices throughout Illinois. Deposit products include checking, savings, money market accounts, and certificates of deposit. Illiana also offers home, auto, business loans, credit cards, and individual retirement accounts.

Business Situation

One of the institution’s loan products, indirect lending, enables third-party merchants to originate loans at the point of sale. The program has led to rapid growth which changed the structure and risk profile of the balance sheet for the institution. Credit risk is controlled in part by a dealer reserve account that provides for charging back non-performing loans to the merchant. The institution needed a system to credit the reserve account for the premium due at the time the principal of the loan is funded. The system also needed to compute when funds are disbursed from the dealer reserve account on a monthly basis net of any unpaid interest resulting from borrower prepayments or defaults on other non-performing loans.

Solution

Dealer Reserve System

Illiana Financial selected alligatortek to develop their Dealer Reserve System. The system provides the credit union with the ability to reconcile loan balances against the core processing system. The core processing system, XP2 from Fiserv unit XP Systems, provides an IBM DB2 database from which Access can extract the necessary data. Delinquent loans are flagged by exception reports and dealer reserve accounts are updated at each month-end.