Investment analysis and reporting system and method

• US 20060106700A1
• Filed: 03/08/2005
• Published: 05/18/2006
• Est. Priority Date: 11/12/2004
• Status: Abandoned Application

• Current Assignee: Clearwater Analytics, LLC
• Original Assignee: Clearwater Analytics, LLC
• Inventors: Boren, Michael K., Reed, Justin Kelly, Price, Paul David, Dunn, Charles David, Dunn, James Timothy, Hill, Brian Andrew, Price, James D., Bates, Douglas K., Boren, David R., Anderson, Jerek J., Growney, Christopher J.
• Application Number:
  US11/076,310
• Publication Number:
  US 20060106700A1
• Time in Patent Office: Days
• US Class Current: 705/35
• CPC Class Codes: G06Q 20/4016 involving fraud or risk level assessment in transaction processing
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/06 Asset management; Financial planning or analysis
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

A method and system for analyzing and reporting institutional investments provides a single platform for daily investment accounting, compliance, performance, and risk reports for investment portfolios held at single or multiple custody/safekeeping locations. The method involves retrieving transaction data from multiple independent financial institutions and storing it in a database in a standardized format and retrieving security data from one or more security information service providers and storing it in the database. The method further involves applying a uniform set of customized accounting, compliance, risk and performance parameters to the transaction data and security data stored in the database and, in response to a user request, calculating and reporting selected data to the user in accordance with the uniform accounting, compliance, risk and performance parameters.

Claims

1. A management terminal of an institutional investment analysis and reporting system, the management terminal comprising:

an input/output module configured to retrieve and/or extract data from a plurality of disparate data sources in communication with the management terminal via a telecommunications network;

a database configured to store data retrieved from the data sources;

a reconciliation module configured to reconcile data stored in the database;

an accounting module configured to generate accounting reports from data stored in the database;

a compliance module configured to generate compliance reports from data stored in the database;

a risk module configured to generate risk reports from data stored in the database; and

a performance module configured to generate performance reports from data stored in the database.

2. The management terminal of claim 1, wherein the data sources comprise databases maintained by a plurality of independent custody/safekeeping banks or money managers.

3. The management terminal of claim 1, wherein the data sources comprise databases maintained by one or more security information service providers.

4. The management terminal of claim 1, wherein the accounting reports can be generated using customized methodologies and fiscal periods selected by a user.

5. The management terminal of claim 1, wherein the accounting module is configured to forecast cash flows and other income and expense.

6. The management terminal of claim 1, wherein the accounting module is configured to automatically download accounting close entries, transactions, and balances including investment debits and credits to a general ledger.

7. The management terminal of claim 1, wherein the compliance module is configured to monitor pre-trade, post-trade, and real-time market-driven compliance with appropriate accounting and risk compliance rules.

8. The management terminal of claim 1, wherein the data retrieved from the data sources comprises data related to one or more of the following investment instruments:

money market funds, commercial paper, CDs, time deposits, treasuries, bonds, and auction rate preferred notes.

9. The management terminal of claim 1, wherein the data retrieved from the data sources comprises data related to equity products or to derivative investment products.

10. The management terminal of claim 9, wherein the derivative investment products comprise options, swaps, and futures.

11. The management terminal of claim 1, wherein the reconciliation module is configured to automatically confirm and reconcile data retrieved from the data sources and notify the user of discrepancies.

12. The management terminal of claim 1, wherein the data retrieved from the data sources comprises data related to a plurality of individual securities, and the reconciliation module is configured to provide a detailed, security-by-security reconciliation report daily.

13. The management terminal of claim 1, wherein the telecommunications network comprises the Internet.

14. A method for analyzing and reporting institutional investments comprising:

retrieving transaction data from multiple independent financial institutions and storing it in a database in a standardized format;

retrieving security data from one or more security information service providers and storing it in the database;

automatically reconciling the retrieved transaction and security data and notifying the user of discrepancies;

receiving a user request from a user terminal in communication with a management terminal via a telecommunications network, for a selected report of data stored within the database;

in response to the user request, generating the selected report by compiling data retrieved from the multiple independent financial institutions and displaying the report to the user.

15. The method of claim 14, wherein the selected report displays the after tax performance of a municipal/taxable hybrid investment account.

16. The method of claim 14, wherein the selected report displays performance attribution by duration, sector, and/or security selection.

17. The method of claim 16, wherein the selected report includes details on municipal/taxable and/or multi currency attribution.

18. The method of claim 14, wherein the selected report is transmitted to the user via electronic mail.

19. A method for reporting institutional investment information, comprising:

enabling a user to select a report of data related to any individual or all of the following characteristics of an institutional investment account;

(a) accounting, (b) compliance, (c) risk, and (d) performance;

initially displaying a first report of the selected data at a summary level;

receiving a user request for more detailed information about the summary data displayed in the first report; and

in response to the user request, displaying a second, third or fourth report at a detailed level showing information about one or more specific securities within the institutional investment account.

20. The method of claim 19, wherein enabling the user to select a report comprises displaying a treasury dashboard user interface.

21. The method of claim 20, wherein the treasury dashboard user interface displays treasury-related activities including banking data, foreign exchange information, stock administration data, and investment data.

22. A method for analyzing and reporting institutional investments comprising:

retrieving transaction data from multiple independent financial institutions and storing it in a database in a standardized format;

retrieving security data from one or more security information service providers and storing it in the database;

applying a uniform set of accounting, compliance, risk and performance parameters to the transaction data and security data stored in the database;

in response to a user request, calculating and reporting selected data to the user in accordance with the uniform accounting, compliance, risk and performance parameters.

23. The method of claim 22, wherein retrieving transaction data and/or security data comprises executing one or more custom report-access scripts at selected intervals.

24. The method of claim 22, wherein transaction data and/or security data is retrieved using the HTTP or FTP conventional telecommunications protocol.

25. The method of claim 22, wherein transaction data and/or security data is retrieved in HTML or CSV format.

26. The method of claim 22, further comprising executing one or more custom parsers to extract selected information from the retrieved transaction data and/or security data.

27. The method of claim 22, wherein the accounting, compliance, risk and performance parameters can be defined by a user upon inception of a new institutional investment account.

28. The method of claim 22, wherein the accounting parameters comprise a trade date or a settlement date accounting methodology.

29. The method of claim 22, wherein the accounting parameters comprise a straight-line amortization method or a scientific/constant yield amortization method.

30. The method of claim 22, wherein the accounting parameters comprise an amortization method in which transactions are amortized to the first par call and accreted to the legal final maturity or amortized to the final maturity.

31. The method of claim 22, wherein the accounting parameters comprise static effective maturity dates on pre-paying/embedded option securities.

32. The method of claim 31, wherein the pre-paying/embedded option securities comprise one or more of the following securities:

callable bonds, ABS, and MBS.

33. The method of claim 22, wherein the accounting parameters comprise a tax lot security costing method or an average cost security costing method.

34. The method of claim 22, wherein the accounting parameters comprise one or more of the following bond inventory methods:

(a) first in, first out;

(b) last in, first out; and

(c) average cost.

35. The method of claim 22, wherein the accounting parameters comprise customizable FAS115 balance sheet classification reporting parameters.

36. The method of claim 22, wherein reporting selected data to the user comprises providing book-of-record investment accounting information.

37. The method of claim 22, wherein reporting selected data to the user comprises providing investment reporting and analytics services to an investment manager.

38. The method of claim 37, wherein the reporting and analytics services comprise one or more of the following account characteristics:

(a) value at risk, (b) attribution, (c) shock testing information, and (d) equity driven credit score.

39. A method of monitoring compliance in an institutional investment system, the method comprising:

establishing a plurality of compliance rules for a user account based at least in part on inputs received from the user, wherein one or more of the compliance rules is based on accounting and/or risk parameters;

monitoring daily activity within the user account to detect violations of the compliance rules for the account on a daily basis; and

notifying the user of compliance rule violations within one day of when such violations are detected.

40. The method of claim 39, wherein compliance rule violations for short-term investment instruments are reported accurately.

41. The method of claim 40, wherein the short-term investment instruments comprise CDs or commercial paper.

42. The method of claim 39, wherein one or more of the compliance rules is based on risk parameters.

43. The method of claim 42, wherein at least one of the compliance rules is customizable based on user-specific accounting or risk parameters.