System, method and program product for modeling fund movements

• US 8,655,689 B1
• Filed: 10/12/2012
• Issued: 02/18/2014
• Est. Priority Date: 10/13/2011
• Status: Active Grant

• Current Assignee: Island Intellectual Property LLC (Double Rock Corporation)
• Original Assignee: Island Intellectual Property LLC (Double Rock Corporation)
• Inventors: Gareis, David Edgar
• Primary Examiner(s): Nguyen, Tien
• Application Number:
  US13/650,927
• Time in Patent Office: 494 Days
• Field of Search: 705/30, 705/34, 705/40, 705/41, 705/42, 705/45, 705/4, 235/379, 235/380, 235/385, 235/437, 235/470, 713/186, 726/27, 709/227
• US Class Current: 705/4
• CPC Class Codes: G06Q 40/08 Insurance

Abstract

A method, system and program product, the method comprising accessing, databases, comprising: aggregated account information for FDIC accounts; client account information for each of the respective client accounts, wherein the client account represents funds of the respective client held in the one or more aggregated deposit accounts holding funds of the respective client, the client account information; capacity caps; and obtaining, high, second and lowest stratification balances held in respective depository institutions; calculating for depository institutions a respective total balance in the program; calculating respective excess capacities for respective depository institutions; modifying, parameters selected from the group of a number of client accounts, additional client account funds, a total number of the depository institutions participating in the program, and the capacity caps for one or more of the depository institutions.

Claims

1. An allocation modeling method in a depository program with a government backed insurance limit, comprising:

accessing, using one or more computers, one or more electronic databases, stored on one or more computer-readable media, comprising;

(i) aggregated account information for a plurality of government backed-insured and interest-bearing aggregated deposit accounts held in a plurality of depository institutions in a program, wherein funds from a plurality client accounts are held in the aggregated deposit accounts in the depository institutions in the program, the aggregated account information for a respective one of the aggregated deposit accounts comprising a balance of funds held in the respective aggregated deposit account;

(ii) client account information for each of the respective client accounts, wherein the client account represents funds of the respective client held in the one or more aggregated deposit accounts holding funds of the respective client, the client account information comprising a respective balance of funds from the respective client account held in each of the one or more insured and interest-bearing aggregated deposit accounts holding funds of the respective client account;

(iii) depository institution information for respective of the depository institutions in the program, the depository information for a respective one of the depository institutions comprising a capacity cap for funds held therein from the program, and

for each respective one of a plurality of depository institutions participating in the program performing the steps;

obtaining, using the one or more computers, for a high stratification a current or an adjusted total high stratification balance in the respective depository institution, comprising a total of balances held or that may be held in the respective depository institution of high stratification client accounts, each of the high stratification client accounts having a total balance managed by the program within a highest range of balances that may be fully insured with government backed insurance through an allocation across government backed-insured interest-bearing aggregated deposit accounts in a first number of depository institutions;

obtaining, using the one or more computers, for a second stratification a current or an adjusted total second stratification balance in the respective depository institution, comprising a total of balances held or that may be held in the respective depository institution of second stratification client accounts, each of the second stratification client accounts having a total balance managed by the program within a second range of balances that may be fully insured with government backed insurance through an allocation across government backed-insured interest-bearing aggregated deposit accounts in a second number of depository institutions, wherein the second range has a lower upper limit than the highest range;

obtaining, using the one or more computers, for a lowest stratification a current or an adjusted total lowest stratification balance in the respective depository institution, comprising a total of balances held or that may be held in the respective depository institution of lowest stratification client accounts, each of the lowest stratification client accounts having a total balance managed by the program within a third range of balances that may be fully insured with government backed insurance through an allocation across government backed-insured interest-bearing aggregated deposit accounts in a third number of depository institutions, wherein the lowest range has a lower upper limit than the second range;

calculating or having calculated, using the one or more computers, for each of the respective depository institutions, a respective total balance in the program, based at least in part on the total high stratification balance, the total second stratification balance, and the total lowest stratification balance, held in the respective depository institution;

calculating or having calculated, using the one or more computers, a respective excess capacity for each of the respective depository institutions based at least in part on a difference between the capacity cap for the respective depository institution and the total balance for the respective depository institution; and

modifying, based at least in part on the respective excess capacities of the respective depository institutions, one or more of parameters selected from the group of a number of client accounts, additional client account funds, a total number of the depository institutions participating in the program, and the capacity caps for one or more of the depository institutions.

2. The method as defined in claim 1, further comprising:

allocating, using the one or more computers, funds of each of the high stratification client accounts, the second stratification client accounts and the lowest stratification client accounts across one or more of the depository institutions to obtain government backed insurance for the funds;

summing for each of the depository institutions, using the one or more computers, the funds of the high stratification client accounts allocated to the respective depository institution, to obtain the total high stratification balance for the respective depository institution;

summing for each of the depository institutions, using the one or more computers, the funds of the second stratification client accounts allocated to the respective depository institution, to obtain the total second stratification balance for the respective depository institution; and

summing for each of the depository institutions, using the one or more computers, the funds of the lowest stratification client accounts allocated to the respective depository institution, to obtain the total lowest stratification balance for the respective depository institution.

3. The method as defined in claim 1, may further comprising:

determining, using the one or more computers, a current respective percentage of the high stratification client accounts, a current respective percentage of the second stratification client accounts, and a current respective percentage of the lowest stratification client accounts, relative to a total number of client accounts managed by the program, and determining an average balance of client accounts for the high stratification client accounts, an average balance of client accounts for the second stratification client accounts, and an average balance of client accounts for the lowest stratification client accounts; and

modifying, using the one or more computers, one or more of the respective percentage and/or the average balance of client accounts in one or more of the stratifications to determine a need to change capacity caps for one or more of the depository institutions, and/or a need to change a number of depository institutions in the program, and/or a government backed insurance limit for the program, so that a change in the percentage of the client accounts in one or more of the stratifications and/or a change in the average balance of client accounts in one or more of the stratifications will receive government-backed insurance.

4. The method as defined in claim 1, may further comprising:

determining, using the one or more computers, a current respective percentage of the high stratification client accounts, a current respective percentage of the second stratification client accounts, and a current respective percentage of the lowest stratification client accounts, relative to a total number of client accounts in the program;

determining an average balance of client accounts for the high stratification client accounts, an average balance of client accounts for the second stratification client accounts, and an average balance of client accounts for the lowest stratification client accounts; and

calculating a projected new total balance of funds managed by the program for a given number of new client accounts to be added, based at least in part on the given number of new client accounts, the current number of client accounts, the percentage of the high stratification client accounts and the average balance for the high stratification client accounts, the percentage of the second stratification client accounts and the average balance for the second stratification client accounts, and the percentage of the lowest stratification client accounts and the average balance for the lowest stratification client accounts.

5. The method as defined in claim 4, further comprising:

modifying one of the current respective percentages of the client accounts in the stratifications or the average balance of the client accounts in one or more of the stratifications; and

computing the other of the one or more of the stratifications or the average balance of client accounts in the respective stratifications using algorithms embedded in a first spreadsheet; and

computing the excess capacity for respective ones of the depository institutions using algorithms embedded in a second spreadsheet.

6. The method as defined in claim 1, comprising:

revising one or more selected from the group of capacity cap, insurance limit for the program, and number of depository institutions participating in the program, based at least in part on the determining step; and

calculating an allocation of funds, using the one or more computers, among the government backed insured, interest bearing aggregated deposit accounts of the depository institutions, based at least in part on the capacity cap, insurance limit for the program, and number of depository institutions participating in the program.

7. The method as defined in claim 6, comprising:

allocating, using the one or more computers, amounts of funds from multiple of the client accounts among multiple of the recipient depository institutions, so that a respective balance of funds allocated to each of the aggregated deposit accounts of the depository institutions substantially matches a sum of the respective balances of funds from the multiple of the respective client accounts allocated to this respective aggregated deposit account; and

updating, using the one or more computers, one or more of electronic databases to update the respective balances of client account funds held in one or more of the recipient depository institutions in one or more aggregated deposit accounts therein based on the allocations.

8. The method as defined in claim 6, comprising:

generating and making accessible, using the one or more computers, transfer data based at least in part on the allocations.

9. The method as defined in claim 6, comprising:

generating data for a table, using the one or more computers, that lists for each of a plurality of the stratifications, an upper limit for the respective stratification, a lower limit for the respective stratification, a number of clients in the respective stratification, an average total balance of funds in the stratification, a percentage of a total balance managed by the program that is represented by the average total balance of funds in the respective stratification; and

generating and providing or making accessible display data, using the one or more computers, based at least in part on the data in the table.

10. The method as defined in claim 6, comprising:

generating data for a table, using the one or more computers, that lists for each of the depository institutions participating in the program, the capacity cap, a measure derived from the total high stratification balance, a measure derived from the total second stratification balance, a measure derived from the total lowest stratification balance, a measure of the respective total balance in the program for the respective depository institution, and the excess capacity for the respective depository institution; and

generating and providing or making accessible display data, using the one or more computers, based at least in part on the data in the table.

11. The method as defined in claim 10, wherein the measure is an average.

12. The method as defined in claim 10, wherein the measure is the current total stratification balance for the respective stratification.

13. The method as defined in claim 9, further comprising the wherein machine-executable instructions/programming code may comprise algorithms embedded in Excel or other spreadsheets.

14. The method as defined in claim 1, wherein each of the stratifications consists of a multiple of the FDIC insurance limit.

15. The method as defined in claim 14, wherein there are a plurality of source entities providing clients funds for allocation to depository institutions participating in the program.

16. The method as defined in claim 14, there is a single source entity providing clients funds for allocation to depository institutions participating in the program.

17. The method as defined in claim 14, there is a single self-clearing entity providing clients funds from multiple source entities for allocation to depository institutions participating in the program.

18. The method as defined in claim 17, wherein one of the multiple source entities is affiliated with one or more of the depository institutions, and further comprising allocating finds of client accounts of that one source entity first to the one or more of the depository institutions with which it is affiliated.

19. A system, comprising:

one or more computers configured to perform the following steps;

accessing, using one or more computers, one or more electronic databases, stored on one or more computer-readable media, comprising;

(i) aggregated account information for a plurality of government backed-insured and interest-bearing aggregated deposit accounts held in a plurality of depository institutions in a program, wherein funds from a plurality client accounts are held in the aggregated deposit accounts in the depository institutions in the program, the aggregated account information for a respective one of the aggregated deposit accounts comprising a balance of funds held in the respective aggregated deposit account;

(ii) client account information for each of the respective client accounts, wherein the client account represents funds of the respective client held in the one or more aggregated deposit accounts holding funds of the respective client, the client account information comprising a respective balance of funds from the respective client account held in each of the one or more insured and interest-bearing aggregated deposit accounts holding funds of the respective client account;

(iii) depository institution information for respective of the depository institutions in the program, the depository information for a respective one of the depository institutions comprising a capacity cap for funds held therein from the program, and

for each respective one of a plurality of depository institutions participating in the program, performing the steps;

obtaining, using the one or more computers, for a high stratification a current or an adjusted total high stratification balance in the respective depository institution, comprising a total of balances held or that may be held in the respective depository institution of high stratification client accounts, each of the high stratification client accounts having a total balance managed by the program within a highest range of balances that may be fully insured with government backed insurance through an allocation across government backed-insured interest-bearing aggregated deposit accounts in a first number of depository institutions;

obtaining, using the one or more computers, for a second stratification a current or an adjusted total second stratification balance in the respective depository institution, comprising a total of balances held or that may be held in the respective depository institution of second stratification client accounts, each of the second stratification client accounts having a total balance managed by the program within a second range of balances that may be fully insured with government backed insurance through an allocation across government backed-insured interest-bearing aggregated deposit accounts in a second number of depository institutions, wherein the second range has a lower upper limit than the highest range;

obtaining, using the one or more computers, for a lowest stratification a current or an adjusted total lowest stratification balance in the respective depository institution, comprising a total of balances held or that may be held in the respective depository institution of lowest stratification client accounts, each of the lowest stratification client accounts having a total balance managed by the program within a third range of balances that may be fully insured with government backed insurance through an allocation across government backed-insured interest-bearing aggregated deposit accounts in a third number of depository institutions, wherein the lowest range has a lower upper limit than the second range;

calculating or having calculated, using the one or more computers, for each of the respective depository institutions, a respective total balance in the program, based at least in part on the total high stratification balance, the total second stratification balance, and the total lowest stratification balance, held in the respective depository institution;

calculating or having calculated, using the one or more computers, a respective excess capacity for each of the respective depository institutions based at least in part on a difference between the capacity cap for the respective depository institution and the total balance for the respective depository institution; and

modifying, based at least in part on the respective excess capacities of the respective depository institutions, one or more of parameters selected from the group of a number of client accounts, additional client account funds, a total number of the depository institutions participating in the program, and the capacity caps for one or more of the depository institutions.