Hello Excel Forum folks,
I am reviewing an enormous database of small loan transactions (less than 45 day loans, less than $700 aka payday loans) for compliance, and have identified an issue which I need to further investigate. Here is some background:
The law does not permit a borrower from obtaining a small loan when he/she has gone into default. A default occurs when the payment arrangements found in the small loan contract have not been fulfilled. The way this industry works is the companies will hold on to a signed check for the amount of the loan + the fee and cash that check after the terms of the loan have been fully matured and if the borrower has not yet paid. When the check gets pushed back from the bank for whatever reason, the loan is now in "default." I am trying to identify any instances where a borrower obtains a loan, goes into default and obtains another loan before coming out of default (closing). I need a function (or a few functions) that I can apply to this table which will identify these violations.
The table contains the following columns: Customer Name, Agreement Date, Due Date, Close Date, Return Date.
(A) Customer Name - borrowers name
(B) Agreement Date - date of the original loan agreement
(C) Due Date - due date (maturity date) of original loan
(D) Close Date - date in which the loan is fully paid, whether defaulted or not
(E) Return Date - date in which check is returned by bank, default date.
I hope the ExcelForum universe can grant me the answer I am searching for!
Thanks!
Bookmarks