He Who Controls His Data, Controls His Destiny

We've often heard the phrases "If you can't track it,projected payments actually collected, calculated on a
you can't learn from it" and "Knowledge is power."weekly basis (not monthly). Large pay-offs, insurance
These couldn't be more true than they are today in thepayments and "roll-over" pay-offs were deducted
buy here-pay here industry. It's fairly easy to open afrom the car payments collected to ensure
buy here-pay here dealership (in most states); get a lot,consistency.
get a license and buy some cars. The trick is keeping itDelinquency rates, by themselves, aren't the best
open and the key to that is managing the cash flow.indicators of how efficiently the staff is collecting the
We often see dealers open lots, sell lots of vehiclesdealer's money. A high delinquency rate doesn't
and then, after months of everything seemingly goingalways indicate poor collections. The dealership may
well, can't understand why they're exceeding theirbe experiencing a high Recency rate not reflected in
cash flow projections. They tell us "My delinquency isn'tthe higher delinquency rate. Likewise, a low delinquency
bad and I'm selling cars, so why am I running low onrate does not always indicate good collections.
cash?" There may be many reasons for cash flowDelinquency rates can be manipulated by managers
shortages such as; selling too many cars too fast; orthat have little or no supervision by means of contract
not adhering to a cash-in-deal policy; or reconditioningrewrites (used to age delinquent payments) or by
cost being higher than expected; or operatingcharging off accounts too quickly (before truly working
expenses skyrocketing; or any combination thereof.the customer). The use of the Weekly Collection Rate
Most of the issues can be easily identified andwill help identify these issues. The rate can vary from
monitored with the use of month-end reports.week to week, but an average of 95% or better
However, another issue that affects cash flow is aindicates the staff is managing the collections of the
little more difficult to identify from just reviewing aaccounts receivable well. If charge offs are high, you
month-end report; how well the staff manages thewould see a drop in the collection rate. If accounts are
collection of the accounts receivable. For that, youbeing rewritten to "age" delinquent payments, you
need to dig a little deeper.would see a drop in the collection rate. Conversely, if
Webster defines data as "factual information used asthe staff is being diligent and working the customers
a basis for reasoning, discussion, or calculation." Dataproperly, you should see an increase in the collection
mining has been defined as "the nontrivial extraction ofrate. If they are persistent with the past due
implicit, previously unknown, and potentially usefulcustomers, you should see an increase in the collection
information from data"(1) involving sorting through largerate.
amounts of data and picking out relevant information.If you can't inspect it, you can't track it. If you can't
Of the many key indicators that are prevalent intrack it, there is no accountability. No accountability also
today's business (charge-off rates, loss rates, defaultmeans no motivation. No motivation means no reasons
rates, Recency rates, delinquency rates, etc.) oneto change. Don't expect what you can't inspect. Your
stands out above the rest. With over 900 weeks ofdata is like gold. Mine it often.
data reviewed, we have determined that the singleReferences:
best indicator of how well collections are being1. W. Frawley and G. Piatetsky-Shapiro and C.
managed at a buy here-pay here lot is the WeeklyMatheus, Knowledge Discovery in Databases: An
Collection Rate. This figure is the percentage of theOverview. AI Magazine, Fall 1992, pp. 213-228.