Financial modeling and forecasting system

• US 8,271,369 B2
• Filed: 03/12/2004
• Issued: 09/18/2012
• Est. Priority Date: 03/12/2003
• Status: Active Grant

• Current Assignee: Norman Gilmore
• Original Assignee: Norman Gilmore
• Inventors: Gilmore, Norman
• Primary Examiner(s): Patel, Jagdish
• Assistant Examiner(s): HAMILTON, SARA CHANDLER
• Application Number:
  US10/800,270
• Publication Number:
  US 20040181378A1
• Time in Patent Office: 3,112 Days
• Field of Search: 705/35, 705/36.R
• US Class Current: 705/36.R
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

An approach for forecasting and modeling is provided. A software system (i.e., the Forecast and Modeling system) supports enterprise data collection to build large scale simulation models, which can be linked into a single up-to-date model of planned corporate activity and options. The Forecast and Modeling system advantageously provides re-usable financial components, and enables auditing and analysis of historical plans and beliefs.

Claims

1. A method for generating a financial model, implemented by one or more processors programmed by a set of instructions to perform the steps of:

collecting data in a multi-user peer-to-peer collaborative environment over a data network by;

issuing functor requests through a workflow router to users for data and programs;

receiving one or more functor objects from the users, wherein one or more functor objects comprise collections of variables which can be acted on by methods and wherein said one or more functor objects is received in response to the functor requests and contain the data and programs from the users;

the one or more processors generating a financial model, comprising a simulation framework based upon the received one or more functor objects;

wherein said simulation framework includes a variety of classes, wherein one or more of the classes corresponds to a variable template and method used to create and manipulate a functor object, by;

(a) inputting functor objects into the financial model; and

(b) using the variable template and method of one or more of the variety of classes included in the simulation framework to manipulate the collections of variables represented by the one or more functor objects.

2. A method according to claim 1, wherein the collected data resides within a spreadsheet, the method comprising:

mapping content from a plurality of cells of the spreadsheet to the one or more functor objects, wherein the content includes the data and programs for the functor objects for input into the financial model.

3. A method according to claim 1, wherein the collected data resides within a spreadsheet, the method comprising:

mapping content including the data from a plurality of cells of the spreadsheet to one or more classes, wherein each of the one or more classes duplicates functionality of the spreadsheet when the functor object is used to encapsulate or access the one or more classes.

4. A method according to claim 1, wherein the one or more processors are further programmed to perform the steps of:

outputting the financial model;

providing a user with a plurality of input parameters including operators;

dynamically receiving one of the input parameters from the user in support of what-if analysis of the financial model; and

generating a simulation result in response to the received input parameter for retrieval by the user over the data network.

5. A method according to claim 4, the method comprising:

generating a report of the simulation result via a list query language module that specifies and executes queries in list algebra, wherein the user places an arbitrary list query in at least one cell of a report grid for display.

6. A method according to claim 5, further comprising:

selecting a plurality of cells in the report grid; and

specifying a list query for collecting objects into a set, wherein a graphical embellishment is applied to cells including an object contained in the set.

7. A method according to claim 1, wherein a first user issues a functor request for requesting information relating to the financial model, and the functor request includes a program to collect the information and to validate a response from a second user, a response functor object received from the second user responsive to the functor request conforming to a class interface specified by the first user, the method further comprising:

storing the functor request; and

selectively forwarding the functor request to the second user.

8. A method according to claim 1, wherein the functor objects received from users responsive to the functor requests specify the necessity of additional inputs.

9. A computer-readable storage medium bearing instructions for generating a financial model, the instructions being arranged, upon execution, to cause one or more processors to perform the steps of:

the one or more processors collecting data in a multi-user peer-to-peer collaborative environment over a data network by;

issuing functor requests through a workflow router to users for data and programs;

receiving one or more functor objects from the users, wherein said one or more functor objects comprise collections of variables which can be acted on by methods and wherein said one or more functor objects is received in response to the functor requests and contain the data and programs from the users;

generating a financial model, comprising a simulation framework based upon the one or more received functor objects, wherein said simulation framework includes a variety of classes and wherein one or more of the classes corresponds to a variable template and method used to create and manipulate a functor object, by;

(a) inputting functor objects into the financial model; and

(b) using the variable template and method of one or more of the variety of classes included in the simulation framework to manipulate the collections of variables represented by the one or more functor objects.

10. A system for generating a financial model, the system comprising:

at least one memory including computer program instructions stored as program code thereon, and

at least one processor, where said at least one processor upon execution of the program code, causes the system to perform at least the following;

collecting data in a multi-user peer-to-peer collaborative environment over a data network by issuing functor requests through a workflow router to at least one of a plurality of users for data and programs;

receiving one or more functor objects from the at least one of a plurality of users, wherein one or more functor objects comprise collections of variables which can be acted on by methods and wherein said one or more functor objects is received in response to the functor requests and contain the data and programs from the at least one of a plurality of users;

generating a financial model, comprising a simulation framework based upon the one or more received functor objects, wherein said simulation framework includes a variety of classes, wherein one or more of the classes corresponds to a variable template and method used to create and manipulate a functor object, by;

(a) inputting functor objects into the financial model; and

(b) using the variable template and method of one or more of the variety of classes included in the simulation framework to manipulate the collections of variables represented by the one or more functor objects.

11. A system according to claim 10, wherein the collected data resides within a spreadsheet, and said at least one processor further causes the system to perform:

mapping content from a plurality of cells of the spreadsheet to the one or more functor objects, wherein the content includes the data and programs for the functor objects for input into the financial model.

12. A system according to claim 10, wherein the at least one processor further causes the system to perform:

providing content including the data from a plurality of cells of a spreadsheet to one or more classes, wherein each of the one or more classes duplicates functionality of the spreadsheet when the functor object is used to encapsulate or access the one or more classes.

13. A system according to claim 10, wherein the at least one processor further causes the system to perform:

executing the generated financial model, the financial model providing operators; and

providing a what-if analysis to dynamically process an input parameter from a user, the input parameter corresponding to an operator provided by the financial model.

14. A system according to claim 13, wherein the at least one processor further causes the system to perform:

generating a report of the simulation result, wherein queries are specified and executed in list algebra.

15. A system according to claim 10, wherein a first user issues a functor request for requesting information relating to the financial model, and the functor request includes a program to collect the information and to validate a response from a second user, a response functor object received from the second user responsive to the functor request conforming to a class interface specified by the first user, wherein the at least one processor further causes the system to perform:

storing the functor request; and

selectively forwarding the functor request to the second user.

16. A system according to claim 10, wherein the at least one processor further causes the system to perform:

soliciting input from the plurality of users to simulate a plurality of scenarios relating to the financial model, the scenarios corresponding to different competitive goals assigned to the users, the simulation comprising a plurality of classes and functor objects.

17. A system according to claim 16, wherein the at least one processor is further configured to perform, responsive to the inputs from the plurality of users, one of adding arbitrary new classes or functor objects to the simulation, or making arbitrary changes to a class or functor object currently in the simulation.