Business activity management system
An automated method and system (100) for identifying and measuring the value and risk associated with tangible elements of value, intangible elements of value and external factors and using said measurements to optimize financial performance, risk transfer and business activities.
[0001] This application is a continutation of U.S. patent application Ser. No. 09/688,983 filed Oct. 17, 2000 the disclosure of which is incorporated herein by reference. The subject matter of this application is also related to the subject matter of U.S. patent application Ser. No. 09/940,450 filed Aug. 29, 2001, U.S. patent application Ser. No. 10/746,673 filed Dec. 24, 2003 and U.S. Pat. No. 5,615,109 for “Method of and System for Generating Feasible, Profit Maximizing Requisition Sets”, by Jeff S. Eder, the disclosures of which are incorporated herein by reference.
BACKGROUND OF THE INVENTION[0002] This invention relates to a method of and system for identifying and measuring the value and risk associated with tangible elements of value, intangible elements of value and/or external factors and using said measurements to optimize financial performance, risk transfer and associated business activities for an organization.
SUMMARY OF THE INVENTION[0003] It is a general object of the present invention to identify and measure the value and risk associated with tangible elements of value, intangible elements of value and external factors and using said measurements to support the optimization of business activities for an organization.
[0004] A preferable object to which the present invention is applied is quantifying and then satisfying the risk reduction needs for a commercial business. Comprehensive quantification of enterprise financial status is enabled by:
[0005] 1) Systematically analyzing and valuing contingent liabilities using real option algorithms in order to ensure that the most current information regarding the magnitude of potential liabilities is included in all analyses;
[0006] 2) Developing an improved understanding of the variability and risk associated with all elements of enterprise value—tangible and intangible;
[0007] 3) Incorporating insights from the analyses of performance by asset management systems (i.e. Customer Relationship Management, Supply Chain Management, Brand Management, etc.) and the analyses of risk by asset risk management systems (credit risk, currency risk, etc.) for individual assets;
[0008] 4) Integrating or fusing the information from the first three items in order to develop a view of the risk and opportunities faced by the company;
[0009] 5) Clearly identifying the liquidity and foreign exchange position of the enterprise; and
[0010] 6) Developing the optimal risk reduction program for the company within the constraints specified by the user.
[0011] The system of the present invention also calculates and displays an optimal value enhancement program for the commercial enterprise using the system. Because information on liquidity and foreign exchange needs is developed and transmitted along with the risk information, the system of the present invention is also capable of functioning as an automated, on-line liquidity transfer system, alone or in combination with the risk transfer system.
[0012] In addition to enabling the just in time provision of financial services, the present invention has the added benefit of eliminating a great deal of time-consuming and expensive effort by automating the extraction of data from the databases, tables, and files of existing computer-based corporate finance, operations, human resource, supply chain, web-site and “soft” asset management system databases in order to operate the system. In accordance with the invention, the automated extraction, aggregation and analysis of data from a variety of existing computer-based systems significantly increases the scale and scope of the analysis that can be completed. The system of the present invention further enhances the efficiency and effectiveness of the business valuation by automating the retrieval, storage and analysis of information useful for valuing elements of value from external databases, external publications and the internet. Uncertainty over which method is being used for completing the valuation and the resulting inability to compare different valuations is eliminated by the present invention by consistently utilizing the same set of valuation methodologies for valuing the different elements of enterprise value as shown in Table 1. 1 TABLE 1 Enterprise Element of Value Valuation Methodology Excess Cash & Marketable Securities GAAP Market Sentiment Market Value* − (COPTOT + &Sgr;Real option Values) Total current-operation value (COPTOT): Income Valuation Financial Assets: Cash & Marketable GAAP Securities (CASH) Financial Assets: Accounts Receivable GAAP (AR) Financial Assets: Inventory (IN) GAAP Financial Assets: Prepaid Expenses GAAP (PE) Financial Assets: Other Assets (OA) Lower of GAAP or liquidation value Elements of Production If calculated value > Value: Equipment (PEQ) liquidation value, then use system calculated value, else use liqui- dation value Elements of Intangible Elements System calculated Value: (IE): Customers, value for each IE Employees, Vendors, Strategic Partner- ships, Brands, Other Intangibles Elements of General Going GCV = COPTOT − Value: Concern Value CASH − AR − IN − (GCV) PE − PEQ − OA − &Sgr;IE Real Options Real option algorithms & industry real option allocation each based on relative strength of intangible elements Contingent Liabilities Real option algorithms *The user also has the option of specifying the total value
[0013] The market value of the enterprise is calculated by combining the market value of all debt and equity as shown in Table2. 2 TABLE 2 Enterprise Market Value = &Sgr; Market value of enterprise equity − &Sgr; Market value of company debt
[0014] Consultants from McKinsey & Company recently completed a three year study of companies in 10 industry segments in 12 countries that confirmed the importance of intangible elements of value as enablers of new business expansion and profitable growth. The results of the study, published in the book The Alchemy of Growth, revealed three common characteristics of the most successful businesses in the current economy:
[0015] 1. They consistently utilize “soft” or intangible assets like brands, customers and employees to support business expansion;
[0016] 2. They systematically generate and harvest real options for growth; and
[0017] 3. Their management focuses on three distinct “horizons”—short term (1-3 years), growth (3-5 years out) and options (beyond 5 years).
[0018] The experience of several of the most important companies in the U.S. economy, e.g. IBM, General Motors and DEC, in the late 1980s and early 1990s illustrate the problems that can arise when intangible asset information is omitted from corporate financial statements and companies focus only on the short term horizon. All three companies were showing large profits using current accounting systems while their businesses were deteriorating. If they had been forced to take write-offs when the declines in intangible assets were occurring, the problems would have been visible to the market and management would have been forced to act to correct the problems much more quickly than they actually did. These deficiencies of traditional accounting systems are particularly noticeable in high technology companies that are highly valued for their intangible assets and their options to enter growing markets rather than their tangible assets.
[0019] The utility of the valuations produced by the system of the present invention are further enhanced by explicitly calculating the expected purchase longevity of the different customers and different elements of value in order to improve the accuracy and usefulness of the valuations.
[0020] As shown in Table 1, real options and contingent liabilities are valued using real option algorithms. Because real option algorithms explicitly recognize whether or not an investment is reversible and/or if it can be delayed, the values calculated using these algorithms are more realistic than valuations created using more traditional approaches like Net Present Value. The use of real option analysis for valuing growth opportunities and contingent liabilities (hereinafter, real options) gives the present invention a distinct advantage over traditional approaches to risk management.
[0021] The innovative system has the added benefit of providing a large amount of detailed information to the enterprise and central exchange users concerning both tangible and intangible elements of value. Because intangible elements are by definition not tangible, they can not be measured directly. They must instead be measured by the impact they have on their surrounding environment. There are analogies in the physical world. For example, electricity is an “intangible” that is measured by the impact it has on the surrounding environment. Specifically, the strength of the magnetic field generated by the flow of electricity through a conductor is used to determine the amount of electricity that is being consumed. The system of the present invention measures intangible elements of value by identifying the attributes that, like the magnetic field, reflect the strength of the element in driving components of value (revenue, expense and change in capital), real options and market price for company equity and are easy to measure. Once the attributes related to the impact of each element are identified, they can be summarized into a single expression (a composite variable or vector). The vectors for all elements are then evaluated using a series of models to determine the relative contribution of each element to driving the components of value and market value. The system of the present invention then calculates the product of the relative element contributions and the value of the components of value, real options and market value to determine the net value impact of each element (see Table 5).
[0022] The method for tracking all the elements of value for a business enterprise provided by the present invention eliminates many of the limitations associated with current systems for risk management that were described previously. To facilitate its use as a tool for managing risk for a commercial enterprise, the system of the present invention produces reports in formats that are similar to the reports provided by traditional accounting systems. Incorporating information regarding all the elements of value is just one of the ways the system of the present invention overcomes the limitations of existing systems. Other advances include:
[0023] 1. The integrated analysis of all risks,
[0024] 2. The automated analysis of both “normal” risks and extreme risks, and
[0025] 3. The preparation of an xml summary of enterprise risk that enable the automated delivery of risk management products and services.
[0026] By eliminating many of the gaps in information available to personnel in the enterprise and the central exchange, the system of the present invention enables the just-in-time provision of financial services that are tailored to the exact needs of the enterprise. The electronic linkage also eliminates the time lag that prevents many from companies from obtaining the risk reduction products they need
BRIEF DESCRIPTION OF DRAWINGS[0027] These and other objects, features and advantages of the present invention will be more readily apparent from the following description of one embodiment of the invention in which:
[0028] FIG. 1 is a block diagram showing the major processing steps of the present invention;
[0029] FIG. 2 is a diagram showing the files or tables in the application database (50) of the
[0030] present invention that are utilized for data storage and retrieval during the processing in the innovative risk transfer system;
[0031] FIG. 3 is a block diagram of an implementation of the present invention;
[0032] FIG. 4 is a diagram showing the data windows that are used for receiving information from and transmitting information to the user (20) during system processing;
[0033] FIG. 5A, FIG. 5B, FIG. 5C, FIG. 5D, FIG. 5E and FIG. 5F are block diagrams showing the sequence of steps in the present invention used for specifying system settings and for initializing and operating the data bots that extract, aggregate, store and manipulate information utilized in system processing from: user input, the basic financial system database, the operation management system database, the web site transaction log database, the human resource information system database, risk management system database, external databases, the advanced finance system database, soft asset management system databases, the supply chain system database and the internet;
[0034] FIG. 6A, FIG. 6B and FIG. 6C are block diagrams showing the sequence of steps in the present invention that are utilized for initializing and operating the analysis bots;
[0035] FIG. 7 is a block diagram showing the sequence of steps in the present invention used for developing the optimal risk reduction strategy for each enterprise; and
[0036] FIG. 8 is a block diagram showing the sequence of steps in the present invention used in communicating the summary information, printing reports, and receiving information concerning swaps and coverage from an exchange or other risk transfer provider (600).
DETAILED DESCRIPTION OF ONE EMBODIMENT[0037] FIG. 1 provides an overview of the processing completed by the innovative system for business activity management. Processing starts in this system (100) with the specification of system settings and the initialization and activation of software data “bots” (200) that extract, aggregate, manipulate and store the data and user (20) input required for completing system processing. This information is extracted via a network (45) from: a basic financial system database (5), an operation management system database (10), a web site transaction log database (12), a human resource information system database (15), a risk management system database (17), an external database (25), an advanced financial system database (30), a soft asset management system database (35), a supply chain system database (37) and the internet (40). These information extractions and aggregations may be influenced by a user (20) through interaction with a user-interface portion of the application software (700) that mediates the display, transmission and receipt of all information to and from browser software (800) such as the Microsoft Internet Explorer in an access device (90) such as a phone or personal computer that the user (20) interacts with. While only one database of each type (5, 10, 12, 15, 17, 25, 30, 35 and 37) is shown in FIG. 1, it is to be understood that the system (100) can extract data from multiple databases of each type via the network (45). It also to be understood that the user (20) and the exchange operator (21) can operate separate access devices (90). One embodiment of the present invention contains a soft asset management system for each element of value being analyzed. Automating the extraction and analysis of data from each soft asset management system ensures that each soft asset is considered within the overall financial models for the enterprise. It should also be understood that it is possible to complete a bulk extraction of data from each database (5, 10, 12, 15, 17, 25, 30, 35 and 37) via the network (45) using data extraction applications such as Data Transformation Services from Microsoft or Aclue from Decisionism before initializing the data bots. The data extracted in bulk could be stored in a single datamart or data warehouse where the data bots could operate on the aggregated data.
[0038] All extracted information is stored in a file or table (hereinafter, table) within an application database (50) as shown in FIG. 2 or an exchange database (51) as shown in FIG. 10. The application database (50) contains tables for storing user input, extracted information and system calculations including a system settings table (140), a metadata mapping table (141), a conversion rules table (142), a basic financial system table (143), an operation system table (144), a human resource system table (145), an external database table (146), an advanced finance system table (147), a soft asset system table (148), a bot date table (149), a keyword table (150), a classified text table (151), a geospatial measures table (152), a composite variables table (153), an industry ranking table (154), an element of value definition table (155), a component of value definition table (156), a cluster ID table (157), an element variables table (158), a vector table (159), a bot table (160), a cash flow table (161), a real option value table (162), an enterprise vector table (163), a report table (164), an risk reduction purchase table (165), an enterprise sentiment table (166), a value driver change table (167), a simulation table (168), a sentiment factors table (169), an statistics table (170), a scenarios table (171), a web log data table (172), a risk reduction products table (173), a supply chain system table (174), an optimal mix table (175), a risk system table (176), an xml summary table (177), a generic risk table (178) and a risk reduction activity table (179). The application database (50) can optionally exist as a datamart, data warehouse or departmental warehouse. The system of the present invention has the ability to accept and store supplemental or primary data directly from user input, a data warehouse or other electronic files in addition to receiving data from the databases described previously. The system of the present invention also has the ability to complete the necessary calculations without receiving data from one or more of the specified databases. However, in one embodiment all required information is obtained from the specified data sources (5, 10, 12,15,17, 25, 30, 35, 37 and 40).
[0039] As shown in FIG. 3, one embodiment of the present invention is a computer system (100) illustratively comprised of a user-interface personal computer (110) connected to an application-server personal computer (120) via a network (45). The application server personal computer (120) is in turn connected via the network (45) to a database-server personal computer (130). The user interface personal computer (110) is also connected via the network (45) to an internet browser appliance (90) that contains browser software (800) such as Microsoft Internet Explorer or Netscape Navigator.
[0040] The database-server personal computer (130) has a read/write random access memory (131), a hard drive (132) for storage of the application database (50), a keyboard (133), a communications bus (134), a display (135), a mouse (136), a CPU (137) and a printer (138).
[0041] While only one database server personal computer is shown in FIG. 3, it is to be understood that the exchange-server personal computer (140) can be networked to one thousand or more database server personal computers (130) via the network (45).
[0042] The application-server personal computer (120) has a read/write random access memory (121), a hard drive (122) for storage of the non-user-interface portion of the enterprise portion of the application software (200, 300, 400 and 500) of the present invention, a keyboard (123), a communications bus (124), a display (125), a mouse (126), a CPU (127) and a printer (128). While only one client personal computer is shown in FIG. 3, it is to be understood that the application-server personal computer (120) can be networked to fifty or more client personal computers (110) via the network (45). The application-server personal computer (120) can also be networked to fifty or more server, personal computers (130) via the network (45). It is to be understood that the diagram of FIG. 3 is merely illustrative of one embodiment of the present invention.
[0043] The user-interface personal computer (110) has a read/write random access memory (111), a hard drive (112) for storage of a client data-base (49) and the user-interface portion of the application software (700), a keyboard (113), a communications bus (114), a display (115), a mouse (116), a CPU (117) and a printer (118).
[0044] The application software (200, 300, 400, 500 and 700) controls the performance of the central processing unit (127) as it completes the calculations required to support the enterprise portion of the risk transfer system. In the embodiment illustrated herein, the application software program (200, 300, 400, 500, 600 and 700) is written in a combination of C++ and Visual Basic®. The application software (200, 300, 400, 500 and 700) can use Structured Query Language (SQL) for extracting data from the databases and the internet (5, 10, 12, 15, 17, 25, 30, 35, 37 and 40). The user (20) can optionally interact with the user-interface portion of the application software (700) using the browser software (800) in the browser appliance (90) to provide information to the application software (200, 300, 400, 500 and 700) for use in determining which data will be extracted and transferred to the application database (50) by the data bots.
[0045] User input is initially saved to the client database (49) before being transmitted to the communication bus (124) and on to the hard drive (122) of the application-server computer via the network (45). Following the program instructions of the application software, the central processing unit (127) accesses the extracted data and user input by retrieving it from the hard drive (122) using the random access memory (121) as computation workspace in a manner that is well known.
[0046] The computers (110, 120 and 130) shown in FIG. 3 illustratively are IBM PCs or clones or any of the more powerful computers or workstations that are widely available. Typical memory configurations for client personal computers (110) used with the present invention should include at least 512 megabytes of semiconductor random access memory (111) and at least a 100 gigabyte hard drive (112). Typical memory configurations for the application-server personal computer (120) used with the present invention should include at least 2056 megabytes of semiconductor random access memory (121) and at least a 250 gigabyte hard drive (122). Typical memory configurations for the database-server personal computer (130) used with the present invention should include at least 4112 megabytes of semiconductor random access memory (131) and at least a 500 gigabyte hard drive (132). Typical memory configurations for the exchange-server personal computer (140) used with the present invention should include at least 8224 megabytes of semiconductor random access memory (145) and at least a 750 gigabyte hard drive (141).
[0047] Using the system described above, enterprise activity is analyzed, a comprehensive risk management program is developed and implemented for each enterprise after element of value within the enterprise is analyzed using the formulas and data listed in Table 1. As shown in Table 1, the value of the current-operation will be calculated using an income valuation. An integral part of most income valuation models is the calculation of the present value of the expected cash flows, income or profits associated with the current-operation. The present value of a stream of cash flows is calculated by discounting the cash flows at a rate that reflects the risk associated with realizing the cash flow. For example, the present value (PV) of a cash flow of ten dollars ($10) per year for five (5) years would vary depending on the rate used for discounting future cash flows as shown below. 3 Discount rate = 25% PV = 10 + 10 + 10 + 10 + 10 = 26.89 {overscore (1.25)} {overscore ((1.25))}2 {overscore ((1.25))}3 {overscore ((1.25))}4 {overscore ((1.25))}5 Discount rate = 35% PV = 10 + 10 + 10 + 10 + 10 = 22.20 {overscore (1.35)} {overscore ((1.35))}2 {overscore ((1.35))}3 {overscore ((1.35))}4 {overscore ((1.35))}5
[0048] One of the first steps in evaluating the elements of current-operation value is extracting the data required to complete calculations in accordance with the formula that defines the value of the current-operation as shown in Table 4. 4 TABLE 4 Value of current-operation = (R) Value of forecast revenue from current-operation (positive) + (E) Value of forecast expense for current-operation (negative) + (C)* Value of current operation capital change forecast *Note: (C) can have a positive or negative value
[0049] The three components of current-operation value will be referred to as the revenue value (R), the expense value (E) and the capital value (C). Examination of the equation in Table 4 shows that there are three ways to increase the value of the current-operation—increase the revenue, decrease the expense or decrease the capital requirements (note: this statement ignores a fourth way to increase value—decrease the interest rate used for discounting future cash flows).
[0050] In one embodiment, the revenue, expense and capital requirement forecasts for the current operation, the real options and the contingent liabilities are obtained from an advanced financial planning system database (30) derived from an advanced financial planning system similar to the one disclosed in U.S. Pat. No. 5,615,109. The extracted revenue, expense and capital requirement forecasts are used to calculate a cash flow for each period covered by the forecast for the enterprise by subtracting the expense and change in capital for each period from the revenue for each period. A steady state forecast for future periods is calculated after determining the steady state growth rate that best fits the calculated cash flow for the forecast time period. The steady state growth rate is used to calculate an extended cash flow forecast. The extended cash flow forecast is used to determine the Competitive Advantage Period (CAP) implicit in the enterprise market value.
[0051] While it is possible to use analysis bots to sub-divide each of the components of current operation value into a number of sub-components for analysis, one embodiment has a pre-determined number of sub-components for each component of value for the enterprise. The revenue value is not subdivided. In one embodiment, the expense value is subdivided into five sub-components: the cost of raw materials, the cost of manufacture or delivery of service, the cost of selling, the cost of support and the cost of administration. The capital value is subdivided into six sub-components: cash, non-cash financial assets, production equipment, other assets (non financial, non production assets), financial liabilities and equity. The production equipment and equity sub-components are not used directly in evaluating the elements of value.
[0052] The components and sub-components of current-operation value will be used in valuing the elements and sub-elements of value. An element of value will be defined as “an identifiable entity or group of items that as a result of past transactions and other data has provided and/or is expected to provide economic benefit to an enterprise”. An item will be defined as a single member of the group that defines an element of value. For example, an individual salesman would be an “item” in the “element of value” sales staff. The data associated with performance of an individual item will be referred to as “item variables”.
[0053] Analysis bots are used to determine element of value lives and the percentage of: the revenue value, the expense value, and the capital value that are attributable to each element of value. The resulting values are then added together to determine the valuation for different elements as shown by the example in Table 5. 5 TABLE 5 Element Gross Value Percentage Life/CAP* Net Value Revenue value = $120 M 20% 80% Value = $19.2 M Expense value = ($80 M) 10% 80% Value = ($6.4) M Capital value = ($5 M) 5% 80% Value = ($0.2) M Total value = $35 M Net value for this element: Value = $12.6 M *CAP = Competitive Advantage Period
[0054] The risk reduction program development using the approach outlined above is completed in five distinct stages. As shown in FIG. 5A, FIG. 5B, FIG. 5C, FIG. 5D, FIG. 5E and FIG. 5F the first stage of processing (block 200 from FIG. 1) programs bots to continually extract, aggregate, manipulate and store the data from user input and databases and the internet (5, 10, 12, 15, 17, 25, 30, 35, 37 and 40) in order for the analysis of business value. Bots are independent components of the application that have specific tasks to perform. As shown in FIG. 6A, FIG. 6B and FIG. 6C the second stage of processing (block 300 from FIG. 1) programs analysis bots that continually:
[0055] 1. Identify the item variables, item performance indicators and composite variables for each element of value and sub-element of value that drive the components of value (revenue, expense and changes in capital) and the market price of company equity,
[0056] 2. Create vectors that summarize the performance of the item variables and item performance indicators for each element of value and sub-element of value,
[0057] 3. Determine the appropriate discount rate on the basis of relative causal element strength and value the enterprise real options and contingent liabilities;
[0058] 4. Determine the appropriate discount rate, value and allocate the industry real options to the enterprise on the basis of relative causal element strength;
[0059] 5. Determine the expected life of each element of value and sub-element of value;
[0060] 6. Calculate the enterprise current operation value and value the revenue, expense and capital components of said current operations using the information prepared in the previous stage of processing;
[0061] 7. Specify and optimize predictive models to determine the relationship between the vectors determined in step 2 and the revenue, expense and capital component values determined in step 6,
[0062] 8. Combine the results of the fifth, sixth and seventh stages of processing to determine the value of each element and sub-element (as shown in Table 5); and
[0063] 9. Determine the causal factors for company stock price movement, calculate market sentiment and analyze the causes of market sentiment.
[0064] The third stage of processing (block 400 from FIG. 1) analyzes the risks faced by the enterprise in normal and extreme conditions in order to develop a comprehensive risk management program for the enterprise. The fourth stage of processing (block 500 from FIG. 1) implements the risk reduction program by communicating with the exchange, purchasing the required risk reduction and/or by updating soft asset, finance and operation management systems to implement risk reduction programs. The fifth and final stage of processing (block 600 from FIG. 1) analyzes the risks from all the enterprises using the exchange, sets prices and communicates with each enterprise in order to complete risk reduction program transactions.
System Setting and Data Bots[0065] The flow diagrams in FIG. 5A, FIG. 5B, FIG. 5C, FIG. 5D, FIG. 5E and FIG. 5F detail the processing that is completed by the portion of the application software (200) that extracts, aggregates, transforms and stores the information required for system operation from the: basic financial system database (5), operation management system database (10), the web site transaction log database (12), human resource information system database (15), risk management system database (17), external database (25), advanced financial system database (30), soft asset management system database (35), the supply chain system database (37), the internet (40) and the user (20). A brief overview of the different databases will be presented before reviewing each step of processing completed by this portion (200) of the application software.
[0066] Corporate financial software systems are generally divided into two categories, basic and advanced. Advanced financial systems utilize information from the basic financial systems to perform financial analysis, financial planning and financial reporting functions. Virtually every commercial enterprise uses some type of basic financial system as they are required to use these systems to maintain books and records for income tax purposes. An increasingly large percentage of these basic financial systems are resident in microcomputer and workstation systems. Basic financial systems include general-ledger accounting systems with associated accounts receivable, accounts payable, capital asset, inventory, invoicing, payroll and purchasing subsystems. These systems incorporate worksheets, files, tables and databases. These databases, tables and files contain information about the company operations and its related accounting transactions. As will be detailed below, these databases, tables and files are accessed by the application software of the present invention in order to extract the information required for completing a business valuation. The system is also capable of extracting the required information from a data warehouse (or datamart) when the required information has been pre-loaded into the warehouse.
[0067] General ledger accounting systems generally store only valid accounting transactions. As is well known, valid accounting transactions consist of a debit component and a credit component where the absolute value of the debit component is equal to the absolute value of the credit component. The debits and the credits are posted to the separate accounts maintained within the accounting system. Every basic accounting system has several different types of accounts. The effect that the posted debits and credits have on the different accounts depends on the account type as shown in Table 6. 6 TABLE 6 Account Type: Debit Impact: Credit Impact: Asset Increase Decrease Revenue Decrease Increase Expense Increase Decrease Liability Decrease Increase Equity Decrease Increase
[0068] General ledger accounting systems also require that the asset account balances equal the sum of the liability account balances and equity account balances at all times.
[0069] The general ledger system generally maintains summary, dollar only transaction histories and balances for all accounts while the associated subsystems, accounts payable, accounts receivable, inventory, invoicing, payroll and purchasing, maintain more detailed historical transaction data and balances for their respective accounts. It is common practice for each subsystem to maintain the detailed information shown in Table 7 for each transaction. 7 TABLE 7 Subsystem Detailed Information Accounts Vendor, Item(s), Transaction Date, Amount Owed, Payable Due Date, Account Number Accounts Customer, Transaction Date, Product Sold, Receivable Quantity, Price, Amount Due, Terms, Due Date, Account Number Capital Asset ID, Asset Type, Date of Purchase, Purchase Assets Price, Useful Life, Depreciation Schedule, Salvage Value Inventory Item Number, Transaction Date, Transaction Type, Transaction Qty, Location, Account Number Invoicing Customer Name, Transaction Date, Product(s) Sold, Amount Due, Due Date, Account Number Payroll Employee Name, Employee Title, Pay Frequency, Pay Rate, Account Number Purchasing Vendor, Item(s), Purchase Quantity, Purchase Price(s), Due Date, Account Number
[0070] As is well known, the output from a general ledger system includes income statements, balance sheets and cash flow statements in well defined formats which assist management in measuring the financial performance of the firm during the prior periods when data input and system processing have been completed.
[0071] While basic financial systems are similar between firms, operation management systems vary widely depending on the type of company they are supporting. These systems typically have the ability to not only track historical transactions but to forecast future performance. For manufacturing firms, operation management systems such as Enterprise Resource Planning Systems (ERP), Material Requirement Planning Systems (MRP), Purchasing Systems, Scheduling Systems and Quality Control Systems are used to monitor, coordinate, track and plan the transformation of materials and labor into products. Systems similar to the one described above may also be useful for distributors to use in monitoring the flow of products from a manufacturer.
[0072] Operation Management Systems in manufacturing firms may also monitor information relating to the production rates and the performance of individual production workers, production lines, work centers, production teams and pieces of production equipment including the information shown in Table 8. 8 TABLE 8 Operation Management System - Production Information 1. ID number (employee id/machine id) 2. Actual hours - last batch 3. Standard hours - last batch 4. Actual hours - year to date 5. Actual/Standard hours - year to date % 6. Actual setup time - last batch 7. Standard setup time - last batch 8. Actual setup hours - year to date 9. Actual/Standard setup hrs - yr to date % 10. Cumulative training time 11. Job(s) certifications 12. Actual scrap - last batch 13. Scrap allowance - last batch 14. Actual scrap/allowance - year to date 15. Rework time/unit last batch 16. Rework time/unit year to date 17. QC rejection rate - batch 18. QC rejection rate - year to date
[0073] Operation management systems are also useful for tracking requests for service to repair equipment in the field or in a centralized repair facility. Such systems generally store information similar to that shown below in Table 9. 9 TABLE 9 Operation Management System - Service Call Information 1. Customer name 2. Customer number 3. Contract number 4. Service call number 5. Time call received 6. Product(s) being fixed 7. Serial number of equipment 8. Name of person placing call 9. Name of person accepting call 10. Promised response time 11. Promised type of response 12. Time person dispatched to call 13. Name of person handling call 14. Time of arrival on site 15. Time of repair completion 16. Actual response type 17. Part(s) replaced 18. Part(s) repaired 19. 2nd call required 20. 2nd call number
[0074] Web site transaction log databases keep a detailed record of every visit to a web site, they can be used to trace the path of each visitor to the web site and upon further analysis can be used to identify patterns that are most likely to result in purchases and those that are most likely to result in abandonment. This information can also be used to identify which promotion would generate the most value for the company using the system. Web site transaction logs generally contain the information shown in Table 10. 10 TABLE 10 Web Site Transaction Log Database 1. Customer's URL 2. Date and time of visit 3. Pages visited 4. Length of page visit (time) 5. Type of browser used 6. Referring site 7. URL of site visited next 8. Downloaded file volume and type 9. Cookies 10. Transactions
[0075] Computer based human resource systems may some times be packaged or bundled within enterprise resource planning systems such as those available from SAP, Oracle and Peoplesoft. Human resource systems are increasingly used for storing and maintaining corporate records concerning active employees in sales, operations and the other functional specialties that exist within a modern corporation. Storing records in a centralized system facilitates timely, accurate reporting of overall manpower statistics to the corporate management groups and the various government agencies that require periodic updates. In some cases human resource systems include the company payroll system as a subsystem. In one embodiment of the present invention, the payroll system is part of the basic financial system. These systems can also be used for detailed planning regarding future manpower requirements. Human resource systems typically incorporate worksheets, files, tables and databases that contain information about the current and future employees. As will be detailed below, these databases, tables and files are accessed by the application software of the present invention in order to extract the information required for completing a business valuation. It is common practice for human resource systems to store the information shown in Table 11 for each employee. 11 TABLE 11 Human Resource System Information 1. Employee name 2. Job title 3. Job code 4. Rating 5. Division 6. Department 7. Employee No./(Social Security Number) 8. Year to date - hours paid 9. Year to date - hours worked 10. Employee start date - company 11. Employee start date - department 12. Employee start date - current job 13. Training courses completed 14. Cumulative training expenditures 15. Salary history 16. Current salary 17. Educational background 18. Current supervisor
[0076] Risk management systems databases (17) contain statistical data about the past behavior and forecasts of likely future behavior of interest rates, currency exchange rates and commodity prices. They also contain information about the current mix of risk reduction products (derivatives, insurance, etc.) the enterprise has purchased. Some companies also use risk management systems to evaluate the desirability of extending or increasing credit lines to customers. The information from these systems can be used to supplement the risk information developed by the system of the present invention.
[0077] External databases can be used for obtaining information that enables the definition and evaluation of a variety of things including elements of value, market value factors, industry real options and composite variables. In some cases information from these databases can be used to supplement information obtained from the other databases and the internet (5, 10, 12, 15, 17, 30, 35, 37 and 40). In the system of the present invention, the information extracted from external databases (25) can be in the forms listed in Table 12. 12 TABLE 12 Types of information 1) numeric information such as that found in the SEC Edgar database and the databases of financial infomediaries such as FirstCall, IBES and Compustat, 2) text information such as that found in the Lexis Nexis database and databases containing past issues from specific publications, 3) risk management products such as derivatives and standardized insurance contracts that can be purchased on line, 4) geospatial data; 5) multimedia information such as video and audio clips, and 6) generic risk data including information about the likelihood of earthquake and weather damage by geospatial location
[0078] The system of the present invention uses different “bot” types to process each distinct data type from external databases (25). The same “bot types” are also used for extracting each of the different types of data from the internet (40). The system of the present invention must have access to at least one external database (25) that provides information regarding the equity prices for the enterprise and the equity prices and financial performance of competitors.
[0079] Advanced financial systems may also use information from external databases (25) and the internet (40) in completing their processing. Advanced financial systems include financial planning systems and activity based costing systems. Activity based costing systems may be used to supplement or displace the operation of the expense component analysis segment of the present invention as disclosed previously. Financial planning systems generally use the same format used by basic financial systems in forecasting income statements, balance sheets and cash flow statements for future periods. Management uses the output from financial planning systems to highlight future financial difficulties with a lead time sufficient to permit effective corrective action and to identify problems in company operations that may be reducing the profitability of the business below desired levels. These systems are most often developed by individuals within companies using two and three dimensional spreadsheets such as Lotus 1-2-3®, Microsoft Excel® and Quattro Pro®. In some cases, financial planning systems are built within an executive information system (EIS) or decision support system (DSS). For one embodiment of the present invention, the advanced finance system database is similar to the financial planning system database detailed in U.S. Pat. No. 5,165,109 for “Method of and System for Generating Feasible, Profit Maximizing Requisition Sets”, by Jeff S. Eder, the disclosure of which is incorporated herein by reference.
[0080] While advanced financial planning systems have been around for some time, soft asset management systems are a relatively recent development. Their appearance is further proof of the increasing importance of “soft” assets. Soft asset management systems include: alliance management systems, brand management systems, customer relationship management systems, channel management systems, intellectual property management systems, process management systems and vendor management systems. Soft asset management systems are similar to operation management systems in that they generally have the ability to forecast future events as well as track historical occurrences. Customer relationship management systems are the most well established soft asset management systems at this point and will be the focus of the discussion regarding soft asset management system data. In firms that sell customized products, the customer relationship management system is generally integrated with an estimating system that tracks the flow of estimates into quotations, orders and eventually bills of lading and invoices. In other firms that sell more standardized products, customer relationship management systems generally are used to track the sales process from lead generation to lead qualification to sales call to proposal to acceptance (or rejection) and delivery. All customer relationship management systems would be expected to track all of the customer's interactions with the enterprise after the first sale and store information similar to that shown below in Table 13. 13 TABLE 13 Customer Relationship Management System - Information 1. Customer/Potential customer name 2. Customer number 3. Address 4. Phone number 5. Source of lead 6. Date of first purchase 7. Date of last purchase 8. Last sales call/contact 9. Sales call history 10. Sales contact history 11. Sales history: product/qty/price 12. Quotations: product/qty/price 13. Custom product percentage 14. Payment history 15. Current A/R balance 16. Average days to pay
[0081] Supply chain management system databases (37) contain information that may have been in operation management system databases (10) in the past. These systems provide enhanced visibility into the availability of goods and promote improved coordination between customers and their suppliers. All supply chain management systems would be expected to track all of the items ordered by the enterprise after the first purchase and store information similar to that shown below in Table 14. 14 TABLE 14 Supply Chain Management System Information 1. Stock Keeping Unit (SKU) 2. Vendor 3. Total Quantity on Order 4. Total Quantity in Transit 5. Total Quantity on Back Order 6. Total Quantity in Inventory 7. Quantity available today 8. Quantity available next 7 days 9. Quantity available next 30 days 10. Quantity available next 90 days 11. Quoted lead time 12. Actual average lead time
[0082] System processing of the information from the different databases (5, 10, 12, 15, 17, 25, 30, 35 and 37) and the internet (40) described above starts in a block 201, FIG. 5A, which immediately passes processing to a software block 202. The software in block 202 prompts the user (20) via the system settings data window (701) to provide system setting information. The system setting information entered by the user (20) is transmitted via the network (45) back to the application server (120) where it is stored in the system settings table (140) in the application database (50) in a manner that is well known. The specific inputs the user (20) is asked to provide at this point in processing are shown in Table 15. 15 TABLE 15 1. New run or structure revision? 2. Continuous, If yes, frequency? (hourly, daily, weekly, monthly or quarterly) 3. Structure of enterprise (department, etc.) 4. Enterprise checklist 5. Base account structure 6. Metadata standard (XML, MS OIM, MDC) 7. Location of basic financial system database and metadata 8. Location of advanced finance system database and metadata 9. Location of human resource information system database and metadata 10. Location of operation management system database and metadata 11. Location of soft asset management system databases and metadata 12. Location of external databases and metadata 13. Location of web site transaction log database and metadata 14. Location of supply chain management system database and metadata 15. Location of risk management system database and metadata 16. Location of account structure 17. Base currency 18. Location of database and metadata for equity information 19. Location of database and metadata for debt information 20. Location of database and metadata for tax rate information 21. Location of database and metadata for currency conversion rate information 22. Geospatial data? If yes, identity of geocoding service. 23. The maximum number of generations to be processed without improving fitness 24. Default clustering algorithm (selected from list) and maximum cluster number 25. Amount of cash and marketable securities required for day to day operations 26. Total cost of capital (weighted average cost of equity, debt and risk capital) 27. Number of months a product is considered new after it is first produced 28. Enterprise industry segments (SIC Code) 29. Primary competitors by industry segment 30. Management report types (text, graphic, both) 31. Default reports 32. Default Missing Data Procedure 33. Maximum time to wait for user input 34. Maximum discount rate for new projects (real option valuation) 35. Maximum number of sub-elements 36. Maximum amount to be spent on risk reduction per year 37. Confidence interval for risk reduction programs 38. On line account information for risk reduction products
[0083] The enterprise checklists are used by a “rules” engine (such as the one available from Neuron Data) in block 202 to influence the number and type of items with pre-defined metadata mapping for each category of value. For example, if the checklists indicate that the enterprise is focused on branded, consumer markets, then additional brand related factors will be pre-defined for mapping. The application of these system settings will be further explained as part of the detailed explanation of the system operation.
[0084] The software in block 202 uses the current system date to determine the time periods (months) that require data to complete the current operation and the real option valuations. After the date range is calculated it is stored in the system settings table (140). In one embodiment the valuation of the current operation by the system utilizes basic financial, advanced financial, soft asset management, supply chain, web-site transaction, external database and human resource data for the three year period before and the three year forecast period after the current date. The user (20) also has the option of specifying the data periods that will be used for completing system calculations.
[0085] After the storage of system setting data is complete, processing advances to a software block 203. The software in block 203 prompts the user (20) via the metadata and conversion rules window (702) to map metadata using the standard specified by the user (20) (XML, Microsoft Open Information Model or the Metadata Coalitions specification) from the basic financial system database (5), the operation management system database (10), the web site transaction log database (12), the human resource information system database (15), the risk management system database (17), the external database (25), the advanced financial system database (30), the soft asset management system database (35) and the supply chain system database (37) to the enterprise hierarchy stored in the system settings table (140) and to the pre-specified fields in the metadata mapping table (141). Pre-specified fields in the metadata mapping table include, the revenue, expense and capital components and sub-components for the enterprise and pre-specified fields for expected value drivers. Because the bulk of the information being extracted is financial information, the metadata mapping often takes the form of specifying the account number ranges that correspond to the different fields in the metadata mapping table (141). Table 16 shows the base account number structure that the account numbers in the other systems must align with. For example, using the structure shown below, the revenue component for the enterprise could be specified as enterprise 01, any department number, accounts 400 to 499 (the revenue account range) with any sub-account. 16 TABLE 16 Account Number 01 - 902 (any) - 477- 86 (any) Segment Enterprise Department Account Sub-account Subgroup Workstation Marketing Revenue Singapore Position 4 3 2 1
[0086] As part of the metadata mapping process, any database fields that are not mapped to pre-specified fields are defined by the user (20) as component of value elements of value or non-relevant attributes and umapped” in the metadata mapping table (141) to the corresponding fields in each database in a manner identical to that described above for the pre-specified fields. After all fields have been mapped to the metadata mapping table (141), the software in block 203 prompts the user (20) via the metadata and conversion rules window (702) to provide conversion rules for each metadata field for each data source. Conversion rules will include information regarding currency conversions and conversion for units of measure that may be required to accurately and consistently analyze the data. The inputs from the user (20) regarding conversion rules are stored in the conversion rules table (142) in the application database (50). When conversion rules have been stored for all fields from every data source, then processing advances to a software block 204.
[0087] The software in block 204 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation or a structure change. If the calculation is not a new calculation or a structure change then processing advances to a software block 212. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 207.
[0088] The software in block 207 checks the bot date table (149) and deactivates any basic financial system data bots with creation dates before the current system date and retrieves information from the system settings table (140), metadata mapping table (141) and conversion rules table (142). The software in block 207 then initializes data bots for each field in the metadata mapping table (141) that mapped to the basic financial system database (5) in accordance with the frequency specified by user (20) in the system settings table (140). Bots are independent components of the application that have specific tasks to perform. In the case of data acquisition bots, their tasks are to extract and convert data from a specified source and then store it in a specified location. Each data bot initialized by software block 207 will store its data in the basic financial system table (143). Every data acquisition bot for every data source contains the information shown in Table 17. 17 TABLE 17 1. Unique ID number (based on date, hour, minute, second of creation) 2. The data source location 3. Mapping information 4. Timing of extraction 5. Conversion rules (if any) 6. Storage Location (to allow for tracking of source and destination events) 7. Creation date (date, hour, minute, second)
[0089] After the software in block 207 initializes all the bots for the basic financial system database, processing advances to a block 208. In block 208, the bots extract and convert data in accordance with their preprogrammed instructions in accordance with the frequency specified by user (20) in the system settings table (140). As each bot extracts and converts data from the basic financial system database (5), processing advances to a software block 209 before the bot completes data storage. The software in block 209 checks the basic financial system metadata to see if all fields have been extracted. If the software in block 209 finds no unmapped data fields, then the extracted, converted data are stored in the basic financial system table (143). Alternatively, if there are fields that haven't been extracted, then processing advances to a block 211. The software in block 211 prompts the user (20) via the metadata and conversion rules window (702) to provide metadata and conversion rules for each new field. The information regarding the new metadata and conversion rules is stored in the metadata mapping table (141) and conversion rules table (142) while the extracted, converted data are stored in the basic financial system table (143). It is worth noting at this point that the activation and operation of bots where all the fields have been mapped to the application database (50) continues. Only bots with unmapped fields “wait” for user input before completing data storage. The new metadata and conversion rule information will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing passes on to software block 212.
[0090] The software in block 212 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation or a structure change. If the calculation is not a new calculation or a structure change then processing advances to a software block 228. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 221.
[0091] The software in block 221 checks the bot date table (149) and deactivates any operation management system data bots with creation dates before the current system date and retrieves information from the system settings table (140), metadata mapping table (141) and conversion rules table (142). The software in block 221 then initializes data bots for each field in the metadata mapping table (141) that mapped to the operation management system database (10) in accordance with the frequency specified by user (20) in the system settings table (140). Each data bot initialized by software block 221 will store its data in the operation system table (144).
[0092] After the software in block 221 initializes all the bots for the operation management system database, processing advances to a block 222. In block 222, the bots extract and convert data in accordance with their preprogrammed instructions in accordance with the frequency specified by user (20) in the system settings table (140). As each bot extracts and converts data from the operation management system database (10), processing advances to a software block 209 before the bot completes data storage. The software in block 209 checks the operation management system metadata to see if all fields have been extracted. If the software in block 209 finds no unmapped data fields, then the extracted, converted data are stored in the operation system table (144). Alternatively, if there are fields that haven't been extracted, then processing advances to a block 211. The software in block 211 prompts the user (20) via the metadata and conversion rules window (702) to provide metadata and conversion rules for each new field. The information regarding the new metadata and conversion rules is stored in the metadata mapping table (141) and conversion rules table (142) while the extracted, converted data are stored in the operation system table (144). It is worth noting at this point that the activation and operation of bots where all the fields have been mapped to the application database (50) continues. Only bots with unmapped fields “wait” for user input before completing data storage. The new metadata and conversion rule information will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to a software block 225.
[0093] The software in block 225 checks the bot date table (149) and deactivates any web site transaction log data bots with creation dates before the current system date and retrieves information from the system settings table (140), metadata mapping table (141) and conversion rules table (142). The software in block 225 then initializes data bots for each field in the metadata mapping table (141) that mapped to the web site transaction log database (12) in accordance with the frequency specified by user (20) in the system settings table (140). Each data bot initialized by software block 225 will store its data in the web log data table (172).
[0094] After the software in block 225 initializes all the bots for the web site transaction log database, the bots extract and convert data in accordance with their preprogrammed instructions in accordance with the frequency specified by user (20) in the system settings table (140). As each bot extracts and converts data from the web site transaction log database (12), processing advances to a software block 209 before the bot completes data storage. The software in block 209 checks the web site transaction log metadata to see if all fields have been extracted. If the software in block 209 finds no unmapped data fields, then the extracted, converted data are stored in the web log data table (172). Alternatively, if there are fields that haven't been extracted, then processing advances to a block 211. The software in block 211 prompts the user (20) via the metadata and conversion rules window (702) to provide metadata and conversion rules for each new field. The information regarding the new metadata and conversion rules is stored in the metadata mapping table (141) and conversion rules table (142) while the extracted, converted data are stored in the web log data table (172). It is worth noting at this point that the activation and operation of bots where all the fields have been mapped to the application database (50) continues. Only bots with unmapped fields “wait” for user input before completing data storage. The new metadata and conversion rule information will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to a software block 226.
[0095] The software in block 226 checks the bot date table (149) and deactivates any human resource information system data bots with creation dates before the current system date and retrieves information from the system settings table (140), metadata mapping table (141) and conversion rules table (142). The software in block 226 then initializes data bots for each field in the metadata mapping table (141) that mapped to the human resource information system database (15) in accordance with the frequency specified by user (20) in the system settings table (140). Each data bot initialized by software block 226 will store its data in the human resource system table (145).
[0096] After the software in block 226 initializes all the bots for the human resource information system database, the bots extract and convert data in accordance with their preprogrammed instructions in accordance with the frequency specified by user (20) in the system settings table (140). As each bot extracts and converts data from the human resource information system database (15), processing advances to a software block 209 before the bot completes data storage. The software in block 209 checks the human resource information system metadata to see if all fields have been extracted. If the software in block 209 finds no unmapped data fields, then the extracted, converted data are stored in the human resource system table (145). Alternatively, if there are fields that haven't been extracted, then processing advances to a block 211. The software in block 211 prompts the user (20).via the metadata and conversion rules window (702) to provide metadata and conversion rules for each new field. The information regarding the new metadata and conversion rules is stored in the metadata mapping table (141) and conversion rules table (142) while the extracted, converted data are stored in the human resource system table (145). It is worth noting at this point that the activation and operation of bots where all the fields have been mapped to the application database (50) continues. Only bots with unmapped fields “wait” for user input before completing data storage. The new metadata and conversion rule information will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to software block 228.
[0097] The software in block 228 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation or a structure change. If the calculation is not a new calculation or a structure change then processing advances to a software block 248. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 241.
[0098] The software in block 241 checks the bot date table (149) and deactivates any external database data bots with creation dates before the current system date and retrieves information from the system settings table (140), metadata mapping table (141) and conversion rules table (142). The software in block 241 then initializes data bots for each field in the metadata mapping table (141) that mapped to the external database (25) in accordance with the frequency specified by user (20) in the system settings table (140). Each data bot initialized by software block 241 will store its data in the external database table (146).
[0099] After the software in block 241 initializes all the bots for the external database, processing advances to a block 242. In block 242, the bots extract and convert data in accordance with their preprogrammed instructions. As each bot extracts and converts data from the external database (25), processing advances to a software block 209 before the bot completes data storage. The software in block 209 checks the external database metadata to see if all fields have been extracted. If the software in block 209 finds no unmapped data fields, then the extracted, converted data are stored in the external database table (146). Alternatively, if there are fields that haven't been extracted, then processing advances to a block 211. The software in block 211 prompts the user (20) via the metadata and conversion rules window (702) to provide metadata and conversion rules for each new field. The information regarding the new metadata and conversion rules is stored in the metadata mapping table (141) and conversion rules table (142) while the extracted, converted data are stored in the external database table (146). It is worth noting at this point that the activation and operation of bots where all the fields have been mapped to the application database (50) continues. Only bots with unmapped fields “wait” for user input before completing data storage. The new metadata and conversion rule information will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to a software block 245.
[0100] The software in block 245 checks the bot date table (149) and deactivates any advanced financial system data bots with creation dates before the current system date and retrieves information from the system settings table (140), metadata mapping table (141) and conversion rules table (142). The software in block 245 then initializes data bots for each field in the metadata mapping table (141) that mapped to the advanced financial system database (30) in accordance with the frequency specified by user (20) in the system settings table (140). Each data bot initialized by software block 245 will store its data in the advanced finance system database table (147).
[0101] After the software in block 245 initializes all the bots for the advanced finance system database, the bots extract and convert data in accordance with their preprogrammed instructions in accordance with the frequency specified by user (20) in the system settings table (140). As each bot extracts and converts data from the advanced financial system database (30), processing advances to a software block 209 before the bot completes data storage. The software in block 209 checks the advanced finance system database metadata to see if all fields have been extracted. If the software in block 209 finds no unmapped data fields, then the extracted, converted data are stored in the advanced finance system database table (147). Alternatively, if there are fields that haven't been extracted, then processing advances to a block 211. The software in block 211 prompts the user (20) via the metadata and conversion rules window (702) to provide metadata and conversion rules for each new field. The information regarding the new metadata and conversion rules is stored in the metadata mapping table (141) and conversion rules table (142) while the extracted, converted data are stored in the advanced finance system database table (147). It is worth noting at this point that the activation and operation of bots where all the fields have been mapped to the application database (50) continues. Only bots with unmapped fields “wait” for user input before completing data storage. The new metadata and conversion rule information will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to software block 246.
[0102] The software in block 246 checks the bot date table (149) and deactivates any soft asset management system data bots with creation dates before the current system date and retrieves information from the system settings table (140), metadata mapping table (141) and conversion rules table (142). The software in block 246 then initializes data bots for each field in the metadata mapping table (141) that mapped to a soft asset management system database (35) in accordance with the frequency specified by user (20) in the system settings table (140). Extracting data from each soft asset management system ensures that the management of each soft asset is considered and prioritized within the overall financial models for the each enterprise. Each data bot initialized by software block 246 will store its data in the soft asset system table (148).
[0103] After the software in block 246 initializes bots for all soft asset management system databases, the bots extract and convert data in accordance with their preprogrammed instructions in accordance with the frequency specified by user (20) in the system settings table (140). As each bot extracts and converts data from the soft asset management system databases (35), processing advances to a software block 209 before the bot completes data storage. The software in block 209 checks the metadata for the soft asset management system databases to see if all fields have been extracted. If the software in block 209 finds no unmapped data fields, then the extracted, converted data are stored in the soft asset system table (148). Alternatively, if there are fields that haven't been extracted, then processing advances to a block 211. The software in block 211 prompts the user (20) via the metadata and conversion rules window (702) to provide metadata and conversion rules for each new field. The information regarding the new metadata and conversion rules is stored in the metadata mapping table (141) and conversion rules table (142) while the extracted, converted data are stored in the soft asset system table (148). It is worth noting at this point that the activation and operation of bots where all the fields have been mapped to the application database (50) continues. Only bots with unmapped fields “wait” for user input before completing data storage. The new metadata and conversion rule information will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to software block 248.
[0104] The software in block 248 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation or a structure change. If the calculation is not a new calculation or a structure change then processing advances to a software block 264. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 261.
[0105] The software in block 261 checks the bot date table (149) and deactivates any risk management system data bots with creation dates before the current system date and retrieves information from the system settings table (140), metadata mapping table (141) and conversion rules table (142). The software in block 261 then initializes data bots for each field in the metadata mapping table (141) that mapped to a risk management system database (17) in accordance with the frequency specified by user (20) in the system settings table (140). Each data bot initialized by software block 261 will store its data in the risk system table (176).
[0106] After the software in block 261 initializes bots for all risk management system databases, the bots extract and convert data in accordance with their preprogrammed instructions in accordance with the frequency specified by user (20) in the system settings table (140). As each bot extracts and converts data from the risk management system databases (17), processing advances to a software block 209 before the bot completes data storage. The software in block 209 checks the metadata for the risk management system database (17) to see if all fields have been extracted. If the software in block 209 finds no unmapped data fields, then the extracted, converted data are stored in the risk management system table (174). Alternatively, if there are fields that haven't been extracted, then processing advances to a block 211. The software in block 211 prompts the user (20) via the metadata and conversion rules window (702) to provide metadata and conversion rules for each new field. The information regarding the new metadata and conversion rules is stored in the metadata mapping table (141) and conversion rules table (142) while the extracted, converted data are stored in the risk management system table (174). It is worth noting at this point that the activation and operation of bots where all the fields have been mapped to the application database (50) continues. Only bots with unmapped fields “wait” for user input before completing data storage. The new metadata and conversion rule information will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to software block 262.
[0107] The software in block 262 checks the bot date table (149) and deactivates any supply chain system data bots with creation dates before the current system date and retrieves information from the system settings table (140), metadata mapping table (141) and conversion rules table (142). The software in block 262 then initializes data bots for each field in the metadata mapping table (141) that mapped to a supply chain system database (37) in accordance with the frequency specified by user (20) in the system settings table (140). Each data bot initialized by software block 262 will store its data in the supply chain system table (174).
[0108] After the software in block 262 initializes bots for all supply chain system databases, the bots extract and convert data in accordance with their preprogrammed instructions in accordance with the frequency specified by user (20) in the system settings table (140). As each bot extracts and converts data from the supply chain system databases (37), processing advances to a software block 209 before the bot completes data storage. The software in block 209 checks the metadata for the supply chain system database (37) to see if all fields have been extracted. If the software in block 209 finds no unmapped data fields, then the extracted, converted data are stored in the supply chain system table (174). Alternatively, if there are fields that haven't been extracted, then processing advances to a block 211. The software in block 211 prompts the user (20) via the metadata and conversion rules window (702) to provide metadata and conversion rules for each new field. The information regarding the new metadata and conversion rules is stored in the metadata mapping table (141) and conversion rules table (142) while the extracted, converted data are stored in the supply chain system table (174). It is worth noting at this point that the activation and operation of bots where all the fields have been mapped to the application database (50) continues. Only bots with unmapped fields “wait” for user input before completing data storage. The new metadata and conversion rule information will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to software block 264.
[0109] The software in block 264 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation or a structure change. If the calculation is not a new calculation or a structure change then processing advances to a software block 276. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 265.
[0110] The software in block 265 prompts the user (20) via the identification and classification rules window (703) to identify keywords such as company names, brands, trademarks and competitors for pre-specified fields in the metadata mapping table (141). The user (20) also has the option of mapping keywords to other fields in the metadata mapping table (141). After specifying the keywords, the user (20) is prompted to select and classify descriptive terms for each keyword. The input from the user (20) is stored in the keyword table (150) in the application database before processing advances to a software block 267.
[0111] The software in block 267 checks the bot date table (149) and deactivates any internet text and linkage bots with creation dates before the current system date and retrieves information from the system settings table (140), the metadata mapping table (141) and the keyword table (150). The software in block 267 then initializes internet text and linkage bots for each field in the metadata mapping table (141) that mapped to a keyword in accordance with the frequency specified by user (20) in the system settings table (140).
[0112] Bots are independent components of the application that have specific tasks to perform. In the case of text and linkage bots, their tasks are to locate, count and classify keyword matches and linkages from a specified source and then store their findings in a specified location. Each text and linkage bot initialized by software block 267 will store the location, count and classification data it discovers in the classified text table (151). Multimedia data can be processed using bots with essentially the same specifications if software to translate and parse the multimedia content is included in each bot. Every internet text and linkage bot contains the information shown in Table 18. 18 TABLE 18 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Storage location 4. Mapping information 5. Home URL 6. Keyword 7. Descriptive term 1 To 7 + n. Descriptive term n
[0113] After being initialized, the text and linkage bots locate and classify data from the internet (40) in accordance with their programmed instructions with the frequency specified by user (20) in the system settings table (140). As each text bot locates and classifies data from the internet (40) processing advances to a software block 268 before the bot completes data storage. The software in block 268 checks to see if all linkages are identified and all keyword hits are associated with descriptive terms that have been classified. If the software in block 268 doesn't find any unclassified “hits” or “links”, then the address, counts and classified text are stored in the classified text table (151). Alternatively, if there are terms that haven't been classified or links that haven't been identified, then processing advances to a block 269. The software in block 269 prompts the user (20) via the identification and classification rules window (703) to provide classification rules for each new term. The information regarding the new classification rules is stored in the keyword table (150) while the newly classified text and linkages are stored in the classified text table (151). It is worth noting at this point that the activation and operation of bots where all fields map to the application database (50) continues. Only bots with unclassified fields will “wait” for user input before completing data storage. The new classification rules will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to a software block 270.
[0114] The software in block 270 checks the bot date table (149) and deactivates any external database bots with creation dates before the current system date and retrieves information from the system settings table (140), the metadata mapping table (141) and the keyword table (150). The software in block 270 then initializes external database bots for each field in the metadata mapping table (141) that mapped to a keyword in accordance with the frequency specified by user (20) in the system settings table (140). Every bot initialized by software block 270 will store the location, count and classification of data it discovers in the classified text table (151). Every external database bot contains the information shown in Table 19. 19 TABLE 19 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Storage location 4. Mapping information 5. Data source 6. Keyword 7. Storage location 8. Descriptive term 1 To 8 + n. Descriptive term n
[0115] After being initialized the bots locate data from the external database (25) in accordance with its programmed instructions with the frequency specified by user (20) in the system settings table (140). As each bot locates and classifies data from the external database (25) processing advances to a software block 268 before the bot completes data storage. The software in block 268 checks to see if all keyword hits are associated with descriptive terms that have been classified. If the software in block 268 doesn't find any unclassified units”, then the address, count and classified text are stored in the classified text table (151) or the external database table (146) as appropriate. Alternatively, if there are terms that haven't been classified, then processing advances to a block 269. The software in block 269 prompts the user (20) via the identification and classification rules window (703) to provide classification rules for each new term. The information regarding the new classification rules is stored in the keyword table (150) while the newly classified text is stored in the classified text table (151). It is worth noting at this point that the activation and operation of bots where all fields map to the application database (50) continues. Only bots with unclassified fields “wait” for user input before completing data storage. The new classification rules will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to software block 276.
[0116] The software in block 276 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation or a structure change. If the calculation is not a new calculation or a structure change then processing advances to a software block 291. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 277.
[0117] The software in block 277 checks the system settings table (140) to see if there is geocoded data in the application database (50) and to determine which on-line geocoding service (Centrus™ from QM Soft or MapMarker™ from MapInfo) is being used. If geospatial data are not being used, then processing advances to a block 291. Alternatively, if the software in block 277 determines that geospatial data are being used, processing advances to a software block 278.
[0118] The software in block 278 prompts the user (20) via the geospatial measure definitions window (709) to define the measures that will be used in evaluating the elements of value. After specifying the measures, the user (20) is prompted to select the geospatial locus for each measure from the data already stored in the application database (50). The input from the user (20) is stored in the geospatial measures table (152) in the application database before processing advances to a software block 279.
[0119] The software in block 279 checks the bot date table (149) and deactivates any geospatial bots with creation dates before the current system date and retrieves information from the system settings table (140), the metadata mapping table (141) and the geospatial measures table (152). The software in block 279 then initializes geospatial bots for each field in the metadata mapping table (141) that mapped to geospatial data in the application database (50) in accordance with the frequency specified by user (20) in the system settings table (140) before advancing processing to a software block 280.
[0120] Bots are independent components of the application that have specific tasks to perform. In the case of geospatial bots, their tasks are to calculate user specified measures using a specified geocoding service and then store the measures in a specified location. Each geospatial bot initialized by software block 279 will store the measures it calculates in the application database table where the geospatial data was found. Tables that could include geospatial data include: the basic financial system table (143), the operation system table (144), the human resource system table (145), the external database table (146), the advanced finance system table (147) and the soft asset system table (148). Every geospatial bot contains the information shown in Table 20. 20 TABLE 20 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Geospatial locus 6. Geospatial measure 7. Geocoding service
[0121] In block 280 the geospatial bots locate data and complete measurements in accordance with their programmed instructions with the frequency specified by the user (20) in the system settings table (140). As each geospatial bot retrieves data and calculates the geospatial measures that have been specified, processing advances to a block 281 before the bot completes data storage. The software in block 281 checks to see if all geospatial data located by the bot has been measured. If the software in block 281 doesn't find any unmeasured data, then the measurement is stored in the application database (50). Alternatively, if there are data elements that haven't been measured, then processing advances to a block 282. The software in block 282 prompts the user (20) via the geospatial measure definition window (709) to provide measurement rules for each new term. The information regarding the new measurement rules is stored in the geospatial measures table (152) while the newly calculated measurement is stored in the appropriate table in the application database (50). It is worth noting at this point that the activation and operation of bots that don't have unmeasured fields continues. Only the bots with unmeasured fields “wait” for user input before completing data storage. The new measurement rules will be used the next time bots are initialized in accordance with the frequency established by the user (20). In either event, system processing then passes on to a software block 291.
[0122] The software in block 291 checks: the basic financial system table (143), the operation system table (144), the human resource system table (145), the external database table (146), the advanced finance system table (147), the soft asset system table (148), the classified text table (151) and the geospatial measures table (152) to see if data are missing from any of the periods required for system calculation. The range of required dates was previously calculated by the software in block 202. If there are no data missing from any period, then processing advances to a software block 293. Alternatively, if there are missing data for any field for any period, then processing advances to a block 292.
[0123] The software in block 292, prompts the user (20) via the missing data window (704) to specify the method to be used for filling the blanks for each item that is missing data. Options the user (20) can choose from for filling the blanks include: the average value for the item over the entire time period, the average value for the item over a specified period, zero, the average of the preceding item and the following item values and direct user input for each missing item. If the user (20) doesn't provide input within a specified interval, then the default missing data procedure specified in the system settings table (140) is used. When all the blanks have been filled and stored for all of the missing data, system processing advances to a block 293.
[0124] The software in block 293 calculates attributes by item for each numeric data field in the basic financial system table (143), the operation system table (144), the human resource system table (145), the external database table (146), the advanced finance system table (147) and the soft asset system table (148). The attributes calculated in this step include: cumulative total value, the period-to-period rate of change in value, the rolling average value and a series of time lagged values. In a similar fashion the software in block 293 calculates attributes for each date field in the specified tables including time since last occurrence, cumulative time since first occurrence, average frequency of occurrence and the rolling average frequency of occurrence. The numbers derived from numeric and date fields are collectively referred to as “item performance indicators”. The software in block 293 also calculates pre-specified combinations of variables called composite variables for measuring the strength of the different elements of value. The item performance indicators are stored in the table where the item source data was obtained and the composite variables are stored in the composite variables table (153) before processing advances to a block 294.
[0125] The software in block 294 uses attribute derivation algorithms such as the AQ program to create combinations of the variables that weren't pre-specified for combination. While the AQ program is used in one embodiment of the present: invention, other attribute derivation algorithms, such as the LINUS algorithms, may be used to the same effect. The software creates these attributes using both item variables that were specified as 37 element” variables and item variables that were not. The resulting composite variables are stored in the composite variables table (153) before processing advances to a block 295.
[0126] The software in block 295 derives market value factors by enterprise for each numeric data field with data in the sentiment factors table (169). Market value factors include: the ratio of enterprise earnings to expected earnings, commodity prices not captured in process valuations, inflation rate, growth in g.d.p., volatility, volatility vs. industry average volatility, interest rates, increases in interest rates, insider trading direction and levels, consumer confidence and the unemployment rate that have an impact on the market price of the equity for an enterprise and/or an industry. The market value factors derived in this step include: cumulative totals, the period to period rate of change, the rolling average value and a series of time lagged values. In a similar fashion the software in block 295 calculates market value factors for each date field in the specified table including time since last occurrence, cumulative time since first occurrence, average frequency of occurrence and the rolling average frequency of occurrence. The numbers derived from numeric and date fields are collectively referred to as “market performance indicators”. The software in block 295 also calculates pre-specified combinations of variables called composite factors for measuring the strength of the different market value factors. The market performance indicators and the composite factors are stored in the sentiment factors table (169) before processing advances to a block 296.
[0127] The software in block 296 uses attribute derivation algorithms, such as the Linus algorithm, to create combinations of the factors that were not pre-specified for combination. While the Linus algorithm is used in one embodiment of the present invention, other attribute derivation algorithms, such as the AQ program, may be used to the same effect. The software creates these attributes using both market value factors that were included in “composite factors” and market value factors that were not. The resulting composite variables are stored in the sentiment factors table (169) before processing advances to a block 297.
[0128] The software in block 297 uses pattern-matching algorithms to assign pre-designated data fields for different elements of value to pre-defined groups with numerical values. This type of analysis is useful in classifying purchasing patterns and/or communications patterns as “heavy”, “light”, “moderate” or “sporadic”. The classification and the numeric value associated with the classification are stored in the application database (50) table where the data field is located before processing advances to a block 298.
[0129] The software in block 298 retrieves data from the metadata mapping table (141), creates and then stores the definitions for the pre-defined components of value in the components of value definition table (155). As discussed previously, the revenue component of value is not divided into sub-components, the expense value is divided into five sub-components: the cost of raw materials, the cost of manufacture or delivery of service, the cost of selling, the cost of support and the cost of administration and the capital value is divided into six sub-components: cash, non-cash financial assets, production equipment, other assets, financial liabilities and equity in one embodiment. Different subdivisions of the components of value can be used to the same effect. When data storage is complete, processing advances to a software block 302 to begin the analysis of the extracted data using analysis bots.
Analysis Bots[0130] The flow diagrams in FIG. 6A, FIG. 6B and FIG. 6C detail the processing that is completed by the portion of the application software (300) that programs analysis bots to:
[0131] 1. Identify the item variables, item performance indicators and composite variables for each enterprise, element of value and sub-element of value that drive the components of value (revenue, expense and changes in capital),
[0132] 2. Create vectors that use item variables, item performance indicators and composite variables to summarize the performance of each enterprise, element of value and sub-element of value,
[0133] 3. Determine the causal factors for industry value, determine the appropriate interest rate, value and allocate the industry real options to each enterprise on the basis of relative element strength;
[0134] 4. Determine the appropriate interest rate on the basis of relative causal element strength and value the enterprise real options;
[0135] 5. Determine the expected life of each element of value and sub-element of value;
[0136] 6. Calculate the enterprise current operation value and value the revenue, expense and capital components using the information prepared in the previous stage of processing;
[0137] 7. Specify and optimize predictive causal models to determine the relationship between the vectors determined in step 2 and the revenue, expense and capital values determined in step 6,
[0138] 8. Combine the results of the fifth, sixth and seventh stages of processing to determine the value of each, enterprise contribution, element and sub-element (as shown in Table 5);
[0139] 9. Calculate the market sentiment by subtracting the current operation value, the total value of real options and the allocated industry options from market value for the enterprise (if it has a public stock market price); and
[0140] 10. Analyze the sources of market sentiment.
[0141] Each analysis bot generally normalizes the data being analyzed before processing begins.
[0142] Processing in this portion of the application begins in software block 302. The software in block 302 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation or a structure change. If the calculation is not a new calculation or a structure change then processing advances to a software block 314. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 303.
[0143] The software in block 303 retrieves data from the meta data mapping table (141) and the soft asset system table (148) and then assigns item variables, item performance indicators and composite variables to each element of value using a two-step process. First, item variables and item performance indicators are assigned to elements of value based on the soft asset management system they correspond to (for example, all item variables from a brand management system and all item performance indicators derived from brand management system variables are assigned to the brand element of value). Second, pre-defined composite variables are assigned to the element of value they were assigned to measure in the metadata mapping table (141). After the assignment of variables and indicators to elements is complete, the resulting assignments are saved to the element of value definition table (155) and processing advances to a block 304.
[0144] The software in block 304 checks the bot date table (149) and deactivates any temporal clustering bots with creation dates before the current system date. The software in block 304 then initializes bots in order for each component of value. The bots: activate in accordance with the frequency specified by the user (20) in the system settings table (140), retrieve the information from the system settings table (140), the metadata mapping table (141) and the component of value definition table (156) in order and define segments for the component of value data before saving the resulting cluster information in the application database (50).
[0145] Bots are independent components of the application that have specific tasks to perform. In the case of temporal clustering bots, their primary task is to segment the component and sub-component of value variables into distinct time regimes that share similar characteristics. The temporal clustering bot assigns a unique identification (id) number to each “regime” it identifies and stores the unique id numbers in the cluster id table (157). Every time period with data are assigned to one of the regimes. The cluster id for each regime is saved in the data record for each item variable in the table where it resides. The item variables are segmented into a number of regimes less than or equal to the maximum specified by the user (20) in the system settings. The data are segmented using a competitive regression algorithm that identifies an overall, global model before splitting the data and creating new models for the data in each partition. If the error from the two models is greater than the error from the global model, then there is only one regime in the data. Alternatively, if the two models produce lower error than the global model, then a third model is created. If the error from three models is lower than from two models then a fourth model is added. The process continues until adding a new model does not improve accuracy. Other temporal clustering algorithms may be used to the same effect. Every temporal clustering bot contains the information shown in Table 21. 21 TABLE 21 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Maximum number of clusters 6. Variable 1 . . . 6 + n. Variable n
[0146] When bots in block 304 have identified and stored regime assignments for all time periods with data, processing advances to a software block 305.
[0147] The software in block 305 checks the bot date table (149) and deactivates any variable clustering bots with creation dates before the current system date. The software in block 305 then initializes bots in order for each element of value. The bots: activate in accordance with the frequency specified by the user (20) in the system settings table (140), retrieve the information from the system settings table (140), the metadata mapping table (141) and the element of value definition table (155) in order and define segments for the element of value data before saving the resulting cluster information in the application database (50).
[0148] Bots are independent components of the application that have specific tasks to perform. In the case of variable clustering bots, their primary task is to segment the element of value variables into distinct clusters that share similar characteristics. The clustering bot assigns a unique id number to each “cluster” it identifies and stores the unique id numbers in the cluster id table (157). Every item variable for every element of value is assigned to one of the unique clusters. The cluster id for each variable is saved in the data record for each item variable in the table where it resides. The item variables are segmented into a number of clusters less than or equal to the maximum specified by the user (20) in the system settings table (140). The data are segmented using the “default” clustering algorithm the user (20) specified in the system settings. The system of the present invention provides the user (20) with the choice of several clustering algorithms including: an unsupervised “Kohonen” neural network, neural network, decision tree, support vector method, K-nearest neighbor, expectation maximization (EM) and the segmental K-means algorithm. For algorithms that normally require the number of clusters to be specified, the bot will iterate the number of clusters until it finds the cleanest segmentation for the data. Every variable clustering bot contains the information shown in Table 22. 22 TABLE 22 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Element of value 6. Clustering algorithm type 7. Maximum number of clusters 8. Variable 1 . . . to 8 + n. Variable n
[0149] When bots in block 305 have identified and stored cluster assignments for the item variables associated with each component and subcomponent of value, processing advances to a software block 306.
[0150] The software in block 306 checks the bot date table (149) and deactivates any predictive model bots with creation dates before the current system date. The software in block 306 then retrieves the information from the system settings table (140), the metadata mapping table (141), the element of value definition table (155) and the component of value definition table (156) required to initialize predictive model bots for each component of value.
[0151] Bots are independent components of the application that have specific tasks to perform. In the case of predictive model bots, their primary task is to determine the relationship between the item variables, item performance indicators and composite variables (collectively hereinafter, “the variables”) and the components of value (and sub-components of value). Predictive model bots are initialized for each component and sub-component of value. They are also initialized for each cluster and regime of data in accordance with the cluster and regime assignments specified by the bots in blocks 304 and 305. A series of predictive model bots is initialized at this stage because it is impossible to know in advance which predictive model type will produce the “best” predictive model for the data from each commercial enterprise. The series for each model includes 12 predictive model bot types: neural network; CART; GARCH, projection pursuit regression; generalized additive model (GAM), redundant regression network; rough-set analysis, boosted Naïve Bayes Regression; MARS; linear regression; support vector method and stepwise regression. Additional predictive model types can be used to the same effect. The software in block 306 generates this series of predictive model bots for the levels of the enterprise shown in Table 23. 23 TABLE 23 Predictive models by enterprise level Enterprise: Element variables relationship to enterprise revenue component of value Element variables relationship to enterprise expense subcomponents of value Element variables relationship to enterprise capital change subcomponents of value Element of Value: Sub-element of value variables relationship to element of value
[0152] Every predictive model bot contains the information shown in Table 24. 24 TABLE 24 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Component or subcomponent of value 6. Global or Cluster (ID) and/or Regime (ID) 7. Element or Sub-Element ID 8. Predictive Model Type 9. Variable 1 . . . to 9 + n. Variable n
[0153] After predictive model bots are initialized, the bots activate in accordance with the frequency specified by the user (20) in the system settings table (140). Once activated, the bots retrieve the required data from the appropriate table in the application database (50) and randomly partition the item variables, item performance indicators and composite variables into a training set and a test set. The software in block 306 uses “bootstrapping” where the different training data sets are created by re-sampling with replacement from the original training set so data records may occur more than once. The same sets of data will be used to train and then test each predictive model bot. When the predictive model bots complete their training and testing, processing advances to a block 307.
[0154] The software in block 307 determines if clustering improved the accuracy of the predictive models generated by the bots in software block 306. The software in block 307 uses a variable selection algorithm such as stepwise regression (other types of variable selection algorithms can be used) to combine the results from the predictive model bot analyses for each type of analysis—with and without clustering—to determine the best set of variables for each type of analysis. The type of analysis having the smallest amount of error as measured by applying the mean squared error algorithm to the test data is given preference in determining the best set of variables for use in later analysis. There are four possible outcomes from this analysis as shown in Table 25. 25 TABLE 25 1. Best model has no clustering 2. Best model has temporal clustering, no variable clustering 3. Best model has variable clustering, no temporal clustering 4. Best model has temporal clustering and variable clustering
[0155] If the software in block 307 determines that clustering improves the accuracy of the predictive models, then processing advances to a software block 310. Alternatively, if clustering doesn't improve the overall accuracy of the predictive models, then processing advances to a software block 308.
[0156] The software in block 308 uses a variable selection algorithm such as stepwise regression (other types of variable selection algorithms can be used) to combine the results from the predictive model bot analyses for each model to determine the best set of variables for each model. The models having the smallest amount of error as measured by applying the mean squared error algorithm to the test data is given preference in determining the best set of variables. As a result of this processing, the best set of variables contain: the item variables, item performance indicators and composite variables that correlate most strongly with changes in the components of value. The best set of variables will hereinafter be referred to as the “value drivers”. Eliminating low correlation factors from the initial configuration of the vector creation algorithms increases the efficiency of the next stage of system processing. Other error algorithms alone or in combination may be substituted for the mean squared error algorithm. After the best set of variables have been selected and stored in the element variables table (158) for all models at all levels, the software in block 308 tests the independence of the value drivers at the enterprise, element and sub-element level before processing advances to a block 309.
[0157] The software in block 309 checks the bot date table (149) and deactivates any causal model bots with creation dates before the current system date. The software in block 309 then retrieves the information from the system settings table (140), the metadata mapping table (141), the component of value definition table (156) and the element variables table (158) in order to initialize causal model bots for each enterprise, element of value and sub-element of value in accordance with the frequency specified by the user (20) in the system settings table (140).
[0158] Bots are independent components of the application that have specific tasks to perform. In the case of causal model bots, their primary task is to refine the item variable, item performance indicator and composite variable selection to reflect only causal variables. (Note: these variables are grouped together to represent an element vector when they are dependent). A series of causal model bots are initialized at this stage because it is impossible to know in advance which causal model will produce the “best” vector for the best fit variables from each model. The series for each model includes five causal model bot types: Tetrad, M M L, LaGrange, Bayesian and path analysis. The software in block 309 generates this series of causal model bots for each set of variables stored in the element variables table (158) in the previous stage in processing. Every causal model bot activated in this block contains the information shown in Table 26. 26 TABLE 26 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Component or subcomponent of value 6. Enterprise, Element or Sub-Element ID 7. Variable set 8. Causal model type
[0159] After the causal model bots are initialized by the software in block 309, the bots activate in accordance with the frequency specified by the user (20) in the system settings table (140). Once activated, they retrieve the element variable information for each model from the element variables table (158) and sub-divides the variables into two sets, one for training and one for testing. The same set of training data is used by each of the different types of bots for each model. After the causal model bots complete their processing for each model, the software in block 309 uses a model selection algorithm to identify the model that best fits the data for each enterprise, element or sub-element being analyzed. For the system of the present invention, a cross validation algorithm is used for model selection. The software in block 309 saves the best fit causal factors in the vector table (159) in the application database (50) and processing advances to a block 312. The software in block 312 tests the value drivers or vectors to see if there are “missing” value drivers that are influencing the results. If the software in block 312 does not detect any missing value drivers, then system processing advances to a block 323. Alternatively, if missing value drivers are detected by the software in block 312, then processing advances to a software block 321.
[0160] If software in block 307 determines that clustering improves predictive model accuracy, then processing advances to block 310 as described previously. The software in block 310 uses a variable selection algorithm such as stepwise regression (other types of variable selection algorithms can be used) to combine the results from the predictive model bot analyses for each model and cluster to determine the best set of variables for each model. The models having the smallest amount of error as measured by applying the mean squared error algorithm to the test data is given preference in determining the best set of variables. As a result of this processing, the best set of variables contain: the item variables, item performance indicators and composite variables that correlate most strongly with changes in the components of value. The best set of variables will hereinafter be referred to as the “value drivers”. Eliminating low correlation factors from the initial configuration of the vector creation algorithms increases the efficiency of the next stage of system processing. Other error algorithms alone or in combination may be substituted for the mean squared error algorithm. After the best set of variables have been selected and stored in the element variables table (158) for all models at all levels, the software in block 310 tests the independence of the value drivers at the enterprise, element and sub-element level before processing advances to a block 311.
[0161] The software in block 311 checks the bot date table (149) and deactivates any causal model bots with creation dates before the current system date. The software in block 311 then retrieves the information from the system settings table (140), the metadata mapping table (141), the component of value definition table (156) and the element variables table (158) in order to initialize causal model bots for each enterprise, element of value and sub-element of value at every level in accordance with the frequency specified by the user (20) in the system settings table (140).
[0162] Bots are independent components of the application that have specific tasks to perform. In the case of causal model bots, their primary task is to refine the item variable, item performance indicator and composite variable selection to reflect only causal variables. (Note: these variables are grouped together to represent a single element vector when they are dependent). In some cases it may be possible to skip the correlation step before selecting causal the item variable, item performance indicator and composite variables. A series of causal model bots are initialized at this stage because it is impossible to know in advance which causal model will produce the “best” vector for the best fit variables from each model. The series for each model includes four causal model bot types: Tetrad, LaGrange, Bayesian and path analysis. The software in block 311 generates this series of causal model bots for each set of variables stored in the element variables table (158) in the previous stage in processing. Every causal model bot activated in this block contains the information shown in Table 27. 27 TABLE 27 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Component or subcomponent of value 6. Cluster (ID) and/or Regime (ID) 7. Enterprise, Element or Sub-Element ID 8. Variable set 9. Causal model type
[0163] After the causal model bots are initialized by the software in block 311, the bots activate in accordance with the frequency specified by the user (20) in the system settings table (140). Once activated, they retrieve the element variable information for each model from the element variable table (158) and sub-divides the variables into two sets, one for training and one for testing. The same set of training data is used by each of the different types of bots for each model. After the causal model bots complete their processing for each model, the software in block 311 uses a model selection algorithm to identify the model that best fits the data for each enterprise, element or sub-element being analyzed. For the system of the present invention, a cross validation algorithm is used for model selection. The software in block 311 saves the best fit causal factors in the vector table (159) in the application database (50) and processing advances to block 312. The software in block 312 tests the value drivers or vectors to see if there are “missing” value drivers that are influencing the results. If the software in block 312 doesn't detect any missing value drivers, then system processing advances to a block 323. Alternatively, if missing value drivers are detected by the software in block 312, then processing advances to a software block 321.
[0164] The software in block 321 prompts the user (20) via the variable identification window (710) to adjust the specification(s) for the affected enterprise, element of value or subelement of value. After the input from the user (20) is saved in the system settings table (140) and/or the element of value definition table (155), system processing advances to a software block 323. The software in block 323 checks the in the system settings table (140) and/or the element of value definition table (155) to see if there any changes in structure. If there have been changes in the structure, then processing advances to a block 205 and the system processing described previously is repeated. Alternatively, if there are no changes in structure, then processing advances to a block 325.
[0165] The software in block 325 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new one. If the calculation is new, then processing advances to a software block 326. Alternatively, if the calculation is not a new calculation, then processing advances to a software block 333.
[0166] The software in block 326 checks the bot date table (149) and deactivates any vector generation bots with creation dates before the current system date. The software in block 326 then initializes bots for each element and sub-element of value for the enterprise. The bots activate in accordance with the frequency specified by the user (20) in the system settings table (140), retrieve the information from the system settings table (140), the metadata mapping table (141), the component of value definition table (156) and the element variables table (158) in order to initialize vector generation bots for each enterprise, element of value and sub-element of value in accordance with the frequency specified by the user (20) in the system settings table (140).
[0167] Bots are independent components of the application that have specific tasks to perform. In the case of vector generation bots, their primary task is to produce formulas, (hereinafter, vectors) that summarize the relationship between the item variables, item performance indicators and composite variables for the element or sub-element and changes in the component or sub-component of value being examined. (Note: these variables are simply grouped together to represent an element vector when they are dependent). A series of vector generation bots are initialized at this stage because it is impossible to know in advance which vector generation algorithm will produce the “best” vector for the best fit variables from each model. The series for each model includes four vector generation bot types: data fusion, polynomial, induction and LaGrange. Other vector generation algorithms can be used to the same effect. The software in block 326 generates this series of vector generation bots for each set of variables stored in the element variables table (158). Every vector generation bot contains the information shown in Table 28. 28 TABLE 28 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Maximum number of regimes 6. Enterprise or Industry 7. Factor 1 . . . to 7 + n. Factor n
[0168] When bots in block 326 have identified and stored vectors for all time periods with data, processing advances to a software block 327.
[0169] The software in block 327 checks the bot date table (149) and deactivates any temporal clustering bots with creation dates before the current system date. The software in block 327 then initializes bots for market value factors for each enterprise with a market price and for the industry. The bots activate in accordance with the frequency specified by the user (20) in the system settings table (140), retrieve the information from the system settings table (140), the metadata mapping table (141) and the sentiment factors table (169) in order and define regimes for the market value factor data before saving the resulting regime information in the application database (50).
[0170] Bots are independent components of the application that have specific tasks to perform. In the case of temporal clustering bots for market value factors, their primary tasks are to identify the best market value indicator (price, relative price, yield or first derivative of price change) to use for market factor analysis and then to segment the market value factors into distinct time regimes that share similar characteristics. The temporal clustering bots select the best value indicator by grouping the universe of stocks using each of the four value indicators and then comparing the clusters to the known groupings of the S&P 500. The temporal clustering bots then use the identified value indicator in the analysis of temporal clustering. The bots assign a unique id number to each “regime” it identifies and stores the unique id numbers in the cluster id table (157). Every time period with data is assigned to one of the regimes,. The cluster id for each regime is also saved in the data record for each market value factor in the table where it resides. The market value factors are segmented into a number of regimes less than or equal to the maximum specified by the user (20) in the system settings table (140). The factors are segmented using a competitive regression algorithm that identifies an overall, global model before splitting the data and creating new models for the data in each partition. If the error from the two models is greater than the error from the global model, then there is only one regime in the data. Alternatively, if the two models produce lower error than the global model, then a third model is created. If the error from three models is lower than from two models then a fourth model is added. The process continues until adding a new model does not improve accuracy. Other temporal clustering algorithms may be used to the same effect. Every temporal clustering bot contains the information shown in Table 29. 29 TABLE 29 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Maximum number of regimes 6. Enterprise or Industry 7. Value indicator (price, relative price, yield, derivative, etc.) 8. Factor 1 . . . to 8 + n. Factor n
[0171] When bots in block 327 have identified and stored regime assignments for all time periods with data, processing advances to a software block 328.
[0172] The software in block 328 checks the bot date table (149) and deactivates any causal factor bots with creation dates before the current system date. The software in block 328 then retrieves the information from the system settings table (140), the metadata mapping table (141), the element of value definition table (155) and the sentiment factors table (169) in order to initialize causal market value factor bots for the enterprise and for the industry in accordance with the frequency specified by the user (20) in the system settings table (140).
[0173] Bots are independent components of the application that have specific tasks to perform. In the case of causal factor bots, their primary task is to identify the item variables, item performance indicators, composite variables and market value factors that are causal factors for stock price movement. (Note: these variables are grouped together when they are dependent). For each enterprise and industry the causal factors are those that drive changes in the value indicator identified by the temporal clustering bots. A series of causal factor bots are initialized at this stage because it is impossible to know in advance which causal factors will produce the “best” model for each enterprise and industry. The series for each model includes five causal model bot types: Tetrad, LaGrange, M M L, Bayesian and path analysis. Other causal models can be used to the same effect. The software in block 328 generates this series of causal model bots for each set of variables stored in the element variables table (158) in the previous stage in processing. Every causal factor bot activated in this block contains the information shown in Table 30. 30 TABLE 30 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 6. Enterprise or Industry 7. Regime 8. Value indicator (price, relative price, yield, derivative, etc.) 9. Causal model type
[0174] After the causal factor bots are initialized by the software in block 328, the bots activate in accordance with the frequency specified by the user (20) in the system settings table (140). Once activated, they retrieve the required information from the element of value definition table (155) and the sentiment factors table (169) and sub-divide the data into two sets, one for training and one for testing. The same set of training data is used by each of the different types of bots for each model. After the causal factor bots complete their processing for the enterprise and/or industry, the software in block 328 uses a model selection algorithm to identify the model that best fits the data for each enterprise or industry. For the system of the present invention, a cross validation algorithm is used for model selection. The software in block 328 saves the best fit causal factors in the sentiment factors table (169) in the application database (50) and processing advances to a block 329. The software in block 329 tests to see if there are “missing” causal market value factors that are influencing the results. If the software in block 329 does not detect any missing market value factors, then system processing advances to a block 330. Alternatively, if missing market value factors are detected by the software in block 329, then processing returns to software block 321 and the processing described in the preceding section is repeated.
[0175] The software in block 330 checks the bot date table (149) and deactivates any industry rank bots with creation dates before the current system date. The software in block 330 then retrieves the information from the system settings table (140), the metadata mapping table (141), the vector table (159) and the sentiment factors table (169) in order to initialize industry rank bots for the enterprise if it has a public stock market price and for the industry in accordance with the frequency specified by the user (20) in the system settings table (140).
[0176] Bots are independent components of the application that have specific tasks to perform. In the case of industry rank bots, their primary task is to determine the relative position of the enterprise being evaluated on the causal attributes identified in the previous processing step. (Note: these variables are grouped together when they are dependent). The industry rank bots use Data Envelopement Analysis (hereinafter, DEA) to determine the relative industry ranking of the enterprise being examined. The software in block 330 generates industry rank bots for the enterprise being evaluated. Every industry rank bot activated in this block contains the information shown in Table 31. 31 TABLE 31 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Enterprise
[0177] After the industry rank bots are, initialized by the software in block 330, the bots activate in accordance with the frequency specified by the user (20) in the system settings table (140). Once activated, they retrieve the item variables, item performance indicators, composite variables and market value factors for the enterprise from the application database (50) and sub-divides the factors into two sets, one for training and one for testing. After the industry rank bots complete their processing for the enterprise the software in block 330 saves the industry ranks in the vector table (159) in the application database (50) and processing advances to a block 331.
[0178] The software in block 331 checks the bot date table (149) and deactivates any option bots with creation dates before the current system date. The software in block 331 then retrieves the information from the system settings table (140), the metadata mapping table (141), the basic financial system database (143), the external database table (146) and the advanced finance system table (147) in order to initialize option bots for the industry and the enterprise.
[0179] Bots are independent components of the application that have specific tasks to perform. In the case of option bots, their primary tasks are to calculate the discount rate to be used for valuing the real options and to value the real options for the industry and the enterprise. The discount rate for enterprise real options is calculated by adding risk factors for each causal soft asset to a base discount rate. The risk factor for each causal soft asset is determined by a two step process. The first step in the process divides the maximum real option discount rate (specified by the user in system settings) by the number of causal soft assets. The second step in the process determines if the enterprise is highly rated on the causal soft assets and determines an appropriate risk factor. If the enterprise is highly ranked on the soft asset, then the discount rate is increased by a relatively small amount for that causal soft asset. Alternatively, if the enterprise has a low ranking on a causal soft asset, then the discount rate is increased by a relatively large amount for that causal soft asset as shown below in Table 32. 32 TABLE 32 Maximum discount rate = 50%, Causal soft assets = 5 Maximum risk factor/soft asset = 50%/5 = 10% Industry Rank on Soft Asset % of Maximum 1 0% 2 25% 3 50% 4 75% 5 or higher 100% Causal Soft Asset: Relative Rank Risk Factor Brand 1 0% Channel 3 5% Manufacturing Process 4 7.5% Strategic Alliances 5 10% Vendors 2 2.5% Subtotal 25% Base Rate 12% Discount Rate 37%
[0180] The discount rate for industry options is calculated using a weighted average total cost of capital approach in a manner that is well known. The base discount rate for enterprise options is calculated using a total average cost of capital (TACC) approach shown below.
TACC=cost of debt×(debt value/total value)+cost of equity×(equity value/total value)+cost of insurance×(insurance value/total value)
[0181] After the appropriate discount rates are determined, the value of each real option is calculated using Black Scholes algorithms in a manner that is well known. The real option can be valued using other algorithms including binomial, neural network or dynamic programming algorithms. The software in block 331 values option bots for the industy and the enterprise. Industry option bots utilize the industry cost of capital for all calculations.
[0182] Option bots contain the information shown in Table 33. 33 TABLE 33 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Industry or Enterprise ID 6. Real option type (Industry or Enterprise) 7. Real option 8. Allocation percentage (if applicable)
[0183] After the option bots are initialized, they activate in accordance with the frequency specified by the user (20) in the system settings table (140). After being activated, the bots retrieve information for the industry and the enterprise from the basic financial system database (143), the external database table (146) and the advanced finance system table (147) in order to complete the option valuation. After the discount has been determined the value of the real option is calculated using Black Schole's algorithms in a manner that is well known. The resulting values are then saved in the real option value table (162) in the application database (50) before processing advances to a block 332.
[0184] The software in block 332 uses the results of the DEA analysis in the prior processing block and the percentage of industry real options controlled by the enterprise to determine the allocation percentage for industry options. The more dominant the enterprise, as indicated by the industry rank for the intangible element indicators, the greater the allocation of industry real options. When the allocation of options has been determined and the resulting values stored in the real option value table (162) in the application database (50), processing advances to a block 333.
[0185] The software in block 333 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation or a structure change. If the calculation is not a new calculation, a value analysis or a structure change, then processing advances to a software block 341. Alternatively, if the calculation is new a value analysis or a structure change, then processing advances to a software block 343.
[0186] The software in block 341 checks the bot date table (149) and deactivates any cash flow bots with creation dates before the current system date. The software in the block then retrieves the information from the system settings table (140), the metadata mapping table (141) and the component of value definition table (156) in order to initialize cash flow bots for the enterprise in accordance with the frequency specified by the user (20) in the system settings table (140).
[0187] Bots are independent components of the application that have specific tasks to perform. In the case of cash flow bots, their primary tasks are to calculate the cash flow for the enterprise for every time period where data are available and to forecast a steady state cash flow for the enterprise. Cash flow is calculated using a well known formula where cash flow equals period revenue minus period expense plus the period change in capital plus non-cash depreciation/amortization for the period. The steady state cash flow is calculated for the enterprise using forecasting methods identical to those disclosed previously in U.S. Pat. 5,615,109 to forecast revenue, expenses, capital changes and depreciation separately before calculating the cash flow. The software in block 334 initializes cash flow bots for the enterprise.
[0188] Every cash flow bot contains the information shown in Table 34. 34 TABLE 34 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Enterprise ID 6. Components of value
[0189] After the cash flow bots are initialized, the bots activate in accordance with the frequency specified by the user (20) in the system settings table (140). After being activated the bots retrieve the component of value information for the enterprise from the component of value definition table (156). The cash flow bots then complete the calculation and forecast of cash flow for the enterprise before saving the resulting values by period in the cash flow table (161) in the application database (50) before processing advances to a block 342.
[0190] The software in block 342 checks the bot date table (149) and deactivates any element life bots with creation dates before the current system date. The software in block 341 then retrieves the information from the system settings table (140), the metadata mapping table (141) and the element of value definition table (155) in order to initialize element life bots for each element and sub-element of value in the enterprise being examined.
[0191] Bots are independent components of the application that have specific tasks to perform. In the case of element life bots, their primary task is to determine the expected life of each element and sub-element of value. There are three methods for evaluating the expected life of the elements and sub-elements of value. Elements of value that are defined by a population of members or items (such as: channel partners, customers, employees and vendors) will have their lives estimated by analyzing and forecasting the lives of the members of the population. The forecasting of member lives will be determined by the “best” fit solution from competing life estimation methods including the Iowa type survivor curves, Weibull distribution survivor curves, Gompertz-Makeham survivor curves, polynomial equations and the forecasting methodology disclosed in U.S. Pat. No. 5,615,109. Elements of value (such as some parts of Intellectual Property i.e. patents) that have legally defined lives will have their lives calculated using the time period between the current date and the expiration date of the element or sub-element. Finally, elements of value and sub-element of value (such as brand names, information technology and processes) that may not have defined lives and that may not consist of a collection of members will have their lives estimated by comparing the relative strength and stability of the element vectors with the relative stability of the enterprise Competitive Advantage Period (CAP) estimate. The resulting values are stored in the element of value definition table (155) for each element and sub-element of value.
[0192] Every element life bot contains the information shown in Table 35. 35 TABLE 35 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Element or Sub-Element of value 6. Life estimation method (item analysis, date calculation or relative CAP)
[0193] After the element life bots are initialized, they are activated in accordance with the frequency specified by the user (20) in the system settings table (140). After being activated, the bots retrieve information for each element and sub-element of value from the element of value definition table (155) in order to complete the estimate of element life. The resulting values are then saved in the element of value definition table (155) in the application database (50) before processing advances to a block 343.
[0194] The software in block 343 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation, a value analysis or a structure change. If the calculation is not a new calculation or a structure change, then processing advances to a software block 402. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 345.
[0195] The software in block 345 checks the bot date table (149) and deactivates any component capitalization bots with creation dates before the current system date. The software in block 341 then retrieves the information from the system settings table (140), the metadata mapping table (141) and the component of value definition table (156) in order to initialize component capitalization bots for the enterprise.
[0196] Bots are independent components of the application that have specific tasks to perform. In the case of component capitalization bots, their task is to determine the capitalized value of the components and subcomponents of value, forecast revenue, expense or capital requirements for the enterprise in accordance with the formula shown in Table 36. 36 TABLE 36 Value = Ff1/(1 + K) + Ff2/(1 + K)2 + Ff3/(1 + K)3 + Ff4/(1 + K)4 + (Ff4 × (1 + g))/(1 + K)5) + (Ff4 × (1 + g)2)/(1 + K)6) . . . + (Ff4 × (1 + g)N)/(1 + K)N+4) Where: Ffx = Forecast revenue, expense or capital requirements for year x after valuation date (from advanced finance system) N = Number of years in CAP (from prior calculation) K = Total average cost of capital - % per year (from prior calculation) g = Forecast growth rate during CAP - % per year (from advanced financial system)
[0197] After the capitalized value of every component and sub-component of value is complete, the results are stored in the component of value definition table (156) in the application database (50).
[0198] Every component capitalization bot contains the information shown in Table 37. 37 TABLE 37 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Enterprise ID 6. Component of value (revenue, expense or capital change) 7. Sub component of value
[0199] After the component capitalization bots are initialized they activate in accordance with the frequency specified by the user (20) in the system settings table (140). After being activated, the bots retrieve information for each component and sub-component of value from the advanced finance system table (147) and the component of value definition table (156) in order to calculate the capitalized value of each component. The resulting values are then saved in the component of value definition table (156) in the application database (50) before processing advances to a block 347.
[0200] The software in block 347 checks the bot date table (149) and deactivates any element valuation bots with creation dates before the current system date. The software in block 347 then retrieves the information from the system settings table (140), the metadata mapping table (141), the element of value definition table (155), the component of value definition table (156) in order to initialize valuation bots for each element and sub-element of value.
[0201] Bots are independent components of the application that have specific tasks to perform. In the case of element valuation bots, their task is to calculate the contribution of every element of value and sub-element of value in the enterprise using the overall procedure outlined in Table 5. The first step in completing the calculation in accordance with the procedure outlined in Table 5, is determining the relative contribution of element and sub-element of value by using a series of predictive models to find the best fit relationship between:
[0202] 1. The element of value vectors and the enterprise components of value; and
[0203] 2. The sub-element of value vectors and the element of value they correspond to.
[0204] The system of the present invention uses 12 different types of predictive models to determine relative contribution: neural network; CART; projection pursuit regression; generalized additive model (GAM); GARCH; MMDR; redundant regression network; boosted Naïve Bayes Regression; the support vector method; MARS; linear regression; and stepwise regression to determine relative contribution. The model having the smallest amount of error as measured by applying the mean squared error algorithm to the test data is the best fit model. The “relative contribution algorithm” used for completing the analysis varies with the model that was selected as the “best-fit”. For example, if the “best-fit” model is a neural net model, then the portion of revenue attributable to each input vector is determined by the formula shown in Table 38. 38 TABLE 38 1 ( ∑ k = 1 k = m ∑ j = 1 j = n I j k × O k / ∑ j = 1 j = n I ik ) / ∑ k = 1 k = m ∑ j = 1 j = n I j k × O k Where Ijk = Absolute value of the input weight from input node j to hidden node k Ok = Absolute value of output weight from hidden node k m = number of hidden nodes n = number of input nodes
[0205] After the relative contribution of each enterprise, element of value and sub-element of value is determined, the results of this analysis are combined with the previously calculated information regarding element life and capitalized component value to complete the valuation of each: enterprise contribution, element of value and sub-element using the approach shown in Table 39. 39 TABLE 39 Element Gross Value Percentage Life/CAP Net Value Revenue value = $120 M 20% 80% Value = $19.2 M Expense value = ($80 M) 10% 80% Value = ($6.4) M Capital value = ($5 M) 5% 80% Value = ($0.2) M Total value = $35 M Net value for this element: Value = $12.6 M
[0206] The resulting values are stored in the element of value definition table (155) for each element and sub-element of value of the enterprise.
[0207] Every valuation bot contains the information shown in Table 40. 40 TABLE 40 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Element of value or sub-element of value 6. Element of value ID
[0208] After the valuation bots are initialized by the software in block 347 they activate in accordance with the frequency specified by the user (20) in the system settings table (140). After being activated, the bots retrieve information from the element of value definition table (155) and the component of value definition table (156) in order to complete the valuation. The resulting values are then saved in the element of value definition table (155) in the application database (50) before processing advances to a block 351.
[0209] The software in block 351 checks the bot date table (149) and deactivates any residual bots with creation dates before the current system date. The software in block 351 then retrieves the information from the system settings table (140), the metadata mapping table (141) and the element of value definition table (155) in order to initialize residual bots for the enterprise.
[0210] Bots are independent components of the application that have specific tasks to perform. In the case of residual bots, their task is to retrieve data in order from the element of value definition table (155) and the component of value definition table (156) and then calculate the residual going concern value for the enterprise in accordance with the formula shown in Table 41. 41 TABLE 41 Residual Going Concern Value = Total Current-Operation Value − &Sgr; Financial Asset Values − &Sgr; Elements of Value
[0211] Every residual bot contains the information shown in Table 42. 42 TABLE 42 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Enterprise ID
[0212] After the residual bots are initialized they activate in accordance with the frequency specified by the user (20) in the system settings table (140). After being activated, the bots retrieve information from the element of value definition table (155) and the component of value definition table (156) in order to complete the residual calculation for the enterprise. After the calculation is complete, the resulting values are then saved in the element of value definition table (155) in the application database (50) before processing advances to a block 352.
[0213] The software in block 352 checks the bot date table (149) and deactivates any sentiment calculation bots with creation dates before the current system date. The software in block 352 then retrieves the information from the system settings table (140), the metadata mapping table (141), the external database table (146), the element of value definition table (155), the component of value definition table (156) and the real option value table (162) in order to initialize sentiment calculation bots for the enterprise.
[0214] Bots are independent components of the application that have specific tasks to perform. In the case of sentiment calculation bots, their task is to retrieve data in order from: the external database table (146), the element of value definition table (155), the component of value definition table (156) and the real option value table (162) and then calculate the sentiment for the enterprise in accordance with the formula shown in Table 43. 43 TABLE 43 Sentiment = Total Market Value − Total Current-Operation Value − &Sgr; Real Option Values
[0215] Every sentiment calculation bot contains the information shown in Table 44. 44 TABLE 44 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Enterprise ID
[0216] After the sentiment calculation bots are initialized they activate in accordance with the frequency specified by the user (20) in the system settings table (140). After being activated, the bots retrieve information from the external database table (146), the element of value definition table (155), the component of value definition table (156) and the real option value table (162) in order to complete the sentiment calculation for each enterprise. After the calculation is complete, the resulting values are then saved in the enterprise sentiment table (166) in the application database (50) before processing advances to a block 353.
[0217] The software in block 353 checks the bot date table (149) and deactivates any sentiment analysis bots with creation dates before the current system date. The software in block 353 then retrieves the information from the system settings table (140), the metadata mapping table (141), the external database table (146), the element of value definition table (155), the component of value definition table (156), the real option value table (162), the enterprise sentiment table (166) and the sentiment factors table (169) in order to initialize sentiment analysis bots for the enterprise.
[0218] Bots are independent components of the application that have specific tasks to perform. In the case of sentiment analysis bots, their primary task is to determine the composition of the calculated sentiment by comparing the portion of overall market return that related to the different elements of value and the calculated valuation for each element of value as shown below in Table 45. 45 TABLE 45 Total Enterprise Market Value = $100 Billion, 10% related to Brand factors Implied Brand Value = $100 Billion × 10% = $10 Billion Valuation of Brand Element of Value = $6 Billion Increase/(Decrease) in Enterprise Real Option Values Due to Brand = $1.5 Billion Industry Option Allocation Due to Brand = $1.0 Billion Brand Sentiment = $10 − $6 − $1.5 − $1.0 = $1.5 Billion
[0219] Every sentiment analysis bot contains the information shown in Table 46. 46 TABLE 46 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Enterprise ID
[0220] After the sentiment analysis bots are initialized, they activate in accordance with the frequency specified by the user (20) in the system settings table (140). After being activated, the bots retrieve information from the system settings table (140), the metadata mapping table (141), the enterprise sentiment table (166) and the sentiment factors table (169) in order to analyze sentiment. The resulting breakdown of sentiment is then saved in the enterprise sentiment table (169) in the application database (50) before processing advances to a block 402.
Risk Reduction Bots[0221] The flow diagram in FIG. 7 details the processing that is completed by the portion of the application software (400) that analyzes and develops a risk reduction strategy for the commercial enterprise using the system.
[0222] System processing in this portion of the application software (400) begins in a block 402. The software in block 402 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new calculation or a structure change. If the calculation is not a new calculation or a structure change, then processing advances to a software block 412. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 403.
[0223] The software in block 403 checks the bot date table (149) and deactivates any statistical bots with creation dates before the current system date. The software in block 403 then retrieves the information from the system settings table (140), the external database table (146), the element of value definition table (155), the element variables table (158) and the sentiment factor table (169) in order to initialize statistical bots for each causal value driver and market value factor.
[0224] Bots are independent components of the application that have specific tasks to perform. In the case of statistical bots, their primary tasks are to calculate and store statistics such as mean, median, standard deviation, slope, average period change, maximum period change, variance and covariance for each causal value driver and market value factor for every regime. Covariance with the market as a whole is also calculated for each value driver and market value factor. Every statistical bot contains the information shown in Table 47. 47 TABLE 47 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Regime 6. Value Driver or Market Value Factor
[0225] When bots in block 403 have identified and stored statistics for each causal value driver and market value factor in the statistics table (170), processing advances to a software block 404.
[0226] The software in block 404 checks the bot date table (149) and deactivates any risk reduction activity bots with creation dates before the current system date. The software in block 404 then retrieves the information from the system settings table (140), the external database table (146), the element of value definition table (155), the element variables table (158), the sentiment factor table (169) and the statistics table (170) in order to initialize risk reduction activity bots for each causal value driver and market value factor.
[0227] Bots are independent components of the application that have specific tasks to perform. In the case of risk reduction activity bots, their primary tasks are to identify actions that can be taken by the enterprise to reduce risk. For example, if one customer presents a significant risk to the enterprise, then the risk reduction bot might identify a reduction in the credit line for that customer to reduce the risk. Every risk reduction activity bot contains the information shown in Table 48. 48 TABLE 48 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Value driver or Market value factor
[0228] When bots in block 404 have identified and stored risk reduction activities in the risk reduction activity table (179), processing advances to a software block 405.
[0229] The software in block 405 checks the bot date table (149) and deactivates any extreme value bots with creation dates before the current system date. The software in block 405 then retrieves the information from the system settings table (140), the external database table (146), the element of value definition table (155), the element variables table (158) and the sentiment factor table (169) in order to initialize extreme value bots in accordance with the frequency specified by the user (20) in the system settings table (140).
[0230] Bots are independent components of the application that have specific tasks to perform. In the case of extreme value bots, their primary task is to identify the extreme values for each causal value driver and market value factor. The extreme value bots use the Blocks method and the peak over threshold method to identify extreme values. Other extreme value algorithms can be used to the same effect. Every extreme value bot activated in this block contains the information shown in Table 49. 49 TABLE 49 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Method 6. Value driver or Market value factor
[0231] After the extreme value bots are initialized, they activate in accordance with the frequency specified by the user (20) in the system settings table (140). Once activated, they retrieve the required information from the system settings table (140), the external database table (146), the element of value definition table (155), the element variables table (158) and the sentiment factor table (169) and determine the extreme value range for each value driver or market value factor. The bot saves the extreme values for each causal value driver and market value factor in the statistics table (170) in the application database (50) and processing advances to a block 409.
[0232] The software in block 409 checks the bot date table (149) and deactivates any scenario bots with creation dates before the current system date. The software in block 409 then retrieves the information from the system settings table (140), the operation system table (144), the external database table (146), the advanced finance system table (147), the element of value definition table (155), the sentiment factors table (169) and the statistics table (170) in order to initialize scenario bots in accordance with the frequency specified by the user (20) in the system settings table (140).
[0233] Bots are independent components of the application that have specific tasks to perform. In the case of scenario bots, their primary task is to identify likely scenarios for the evolution of the causal value drivers and market value factors. The scenario bots use information from the advanced finance system and external databases to obtain forecasts for individual causal factors before using the covariance information stored in the statistics table (170) to develop forecasts for the other causal value drivers and factors under normal conditions. They also use the extreme value information calculated by the previous bots and stored in the statistics table (170) to calculate extreme scenarios. Every scenario bot activated in this block contains the information shown in Table 50. 50 TABLE 50 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Type: Normal or Extreme 5. Enterprise
[0234] After the scenario bots are initialized, they activate in accordance with the frequency specified by the user (20) in the system settings table (140). Once activated, they retrieve the required information and develop a variety of scenarios as described previously. After the scenario bots complete their calculations they save the resulting scenarios in the scenarios table (171) in the application database (50) and processing advances to a block 410.
[0235] The software in block 410 checks the bot date table (149) and deactivates any simulation bots with creation dates before the current system date. The software in block 410 then retrieves the information from the system settings table (140), the operation system table (144), the advanced finance system table (147), the element of value definition table (155), the external database table (156), the sentiment factors table (169), the statistics table (170), the scenarios table (171) and the generic risk table (178) in order to initialize simulation bots in accordance with the frequency specified by the user (20) in the system settings table (140).
[0236] Bots are independent components of the application that have specific tasks to perform. In the case of simulation bots, their primary task is to run three different types of simulations for the enterprise. The simulation bots run simulations of organizational financial performance and valuation using: the two types of scenarios generated by the scenario bots—normal and extreme, they also run an unconstrained genetic algorithm simulation that evolves to the most negative scenario. In addition to examining the economic factors that were identified in the previous analysis, the bots simulate the impact of generic risks like fire, earthquakes, floods and other weather-related pheonomenal that are un-correlated with the economic scenarios. Every simulation bot activated in this block contains the information shown in Table 51. 51 TABLE 51 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Type: Normal, Extreme or Genetic Algorithm 6. Enterprise
[0237] After the simulation bots are initialized, they activate in accordance with the frequency specified by the user (20) in the system settings table (140). Once activated, they retrieve the required information and simulate the financial performance and value impact of the different scenarios. After the simulation bots complete their calculations, the resulting forecasts are saved in the simulations table (168) and the summary xml table (177) in the application database (50) and processing advances to a block 411.
[0238] The software in block 411 continually runs an analysis to define the optimal risk reduction strategy for each of the identified normal and extreme scenarios. It does this by first retrieving from the system settings table (140), the operation system table (144), the external database table (146), the advanced finance system table (147), the element of value definition table (155), the sentiment factors table (169), the statistics table (170), the scenario table (171), the risk reduction products table (173) and the risk reduction activity table (179) which is the information required to initialize the optimization algorithm. The software in the block determines the optimal mix of risk reduction products (derivative purchase, insurance purchase, etc.) and risk reduction activities (reducing credit limits for certain customers, shifting production from high risk to lower risk countries, etc.) for the company under each scenario given the confidence interval established by the user (20) in the system settings using a linear programming optimization algorithm. A multi criteria optimization determines the best mix for reducing risk under both normal and extreme scenarios. Other optimization algorithms can be used at this point and all optimizations consider the effect of changes in the cost of capital on the optimal solution. In any event, the resulting product and activity mix for each set of scenarios and the combined analysis is saved in the optimal mix table (175) and the xml summary table (177) in the application database (50) and the revised simulations are saved in the simulations table (168) before processing passes to a software block 412. The shadow prices from these optimizations are also stored in the risk reduction products table (173) and the xml summary table (177) for use in identifying new risk reduction products that the company may wish to purchase and/or new risk reduction activities the company may wish to develop.
[0239] The software in block 412 checks the system settings table (140) in the application database (50) to determine if the current calculation is a new, calculation or a structure change. If the calculation is not a new calculation or a structure change, then processing advances to a software block 502. Alternatively, if the calculation is new or a structure change, then processing advances to a software block 413.
[0240] The software in block 413 checks the bot date table (149) and deactivates any impact bots with creation dates before the current system date. The software in block 413 then retrieves the information from the system settings table (140), the operation system table (144), the external database table (146), the advanced finance system table (147), the element of value definition table (155), the simulations table (168), the sentiment factors table (169), the statistics table (170), the scenario table (171) and the optimal mix table (175) in order to initialize value impact bots in accordance with the frequency specified by the user (20) in the system settings table (140).
[0241] Bots are independent components of the application that have specific tasks to perform. In the case of impact bots, their primary task is to determine the value impact of each risk reduction product and activity—those included in the optimal mix and those that aren't—on the different scenarios. Every impact bot contains the information shown in Table 52. 52 TABLE 52 1. Unique ID number (based on date, hour, minute, second of creation) 2. Creation date (date, hour, minute, second) 3. Mapping information 4. Storage location 5. Enterprise 6. Risk reduction product or activity
[0242] After the value impact bots are initialized by the software in block 413, they activate in accordance with the frequency specified by the user (20) in the system settings table (140). After being activated, the bots retrieve information in order to revise the simulations of enterprise performance and determine the risk reduction impact of each product on each simulation. The resulting forecast of value impacts are then saved in the risk reduction products table (173) or the risk reduction activity table (179) as appropriate in the application database (50) before processing advances to a block 414.
[0243] The software in block 414 prepares and displays a listing from highest impact to lowest impact for each risk reduction product under the normal scenarios, the extreme scenarios and the combined (multi-criteria) analysis using the prioritized listing display window (706). The optimal mix for the normal and extreme scenarios are determined by calculating the weighted average sum of the different scenarios where the weighting is determined by the relative likelihood of the scenario. The display identifies the optimal mix from the combined analysis as the recommended solution for enterprise risk reduction. At this point, the user (20) is given the option of:
[0244] 1. Editing (adding or deleting products and activities) from the recommended solution;
[0245] 2. Selecting the optimal mix from the normal scenario;
[0246] 3. Selecting and then editing the optimal mix from the normal scenarios;
[0247] 4. Selecting the optimal mix from the extreme scenario;
[0248] 5. Selecting and then editing the optimal mix from the extreme scenarios; or
[0249] 6. Leaving the default choice in place.
[0250] After the user (20) has finished the review and the optional edit of the selected mix, any changes are saved in the optimal mix table (175) in the application database (50) and processing advances to a software block 502. It should be noted that the processing of the risk reduction bot segment can, with very minor changes, also be used to analyze the impact of value enhancing changes on the enterprise. This could include a value maximization analysis and/or a multi-criteria maximum value, minimum risk optimization.
Output[0251] The flow diagram in FIG. 8 details the processing that is completed by the portion of the application software (500) that generates a summary of the risk, liquidity and foreign exchange position of the company, places orders to purchase the optimal mix of risk reduction products and optionally prints management reports. Processing in this portion of the application starts in software block 502.
[0252] The software in block 502 checks the optimal mix table (175) in the application database (50) to determine which risk reduction activities have been included in the optimal mix. If risk reduction activities have been included in the optimal mix, then the software in this block prepares summaries of the changes and transmits them to the affected financial, operational and/or soft asset management system(s). For example, if the option to reduce the credit line for a certain customer has been accepted, then the customer relationship management system and the accounts receivable system will be updated with the new credit limit information by a transmission from the software in this block. Alternatively, if there are no risk reduction activities in the optimal mix, then processing advances directly to a software block 503.
[0253] The software in block 503 retrieves information from the system settings table (140) and the advanced finance system table (147) that is required to calculate the minimum amount of cash that will be available for investment in risk reduction during the next 36 month period. The system settings table (140) contains the minimum amount of cash and available securities that the user (20) indicated win order for enterprise operation while the advanced finance system table (147) contains a forecast of the cash balance for the enterprise for each period during the next 36 months. A summary of the available cash and cash deficits by currency, by month, by enterprise for the next 36 months is stored in a summary xml format in the xml summary table (177) during this stage of processing. After the amount of available cash for each enterprise is calculated and stored in the risk reduction purchase table (165), processing advances to a software block 504.
[0254] The software in block 504 assembles the previously developed summaries of cash position, foreign exchange requirements, risks, scenarios and statistics into a xml summary profile of the enterprise. This summary profile is transferred via the network (45) to an exchange or other risk transfer provider (600).
[0255] The software in block 514 analyzes the mix of risk reduction products and swaps recommended by an exchange or other risk transfer provider (600) to determine the percentage reduction in financial performance volatility that their purchase will produce for the enterprise. If the previously completed sentiment analysis indicated that financial performance volatility was a driver of market value, then the software in block 514 will retrieve the required information from the sentiment factors table (169) and estimate the value increase that will be produced by the decreased volatility. The software in block 514 also confirms that the products and/or swaps recommended by the exchange or other risk transfer provider (600) can be purchased using available cash for a total expenditure, counting both prior purchases and planned purchases, that is less than or equal to the maximum investment amount established by the user (20) in system settings table (140). If the planned purchases are within the guidelines established by the user (20), then the software generates a purchase order for the additional risk reduction products and/or swaps. Alternatively, if there isn't available cash or if the planned purchase exceeds the expenditure guideline established by the user (20), then a message indicating the problem(s) is prepared. In any event, the software in block 514 displays the resulting message or purchase order to the user (20) via the purchase review data window (711). The purchase review data window (711) also displays the estimate of value increase, if any, that the implementation of the risk reduction program will provide. The user (20) can optionally edit or confirm the purchase order, increase the amount that can be spent on risk reduction or chose to purchase a mix that is not the optimal mix. After the user (20) completes his or her review and optional edit, the software in block 514 transmits any orders to purchase the risk reduction products that were approved via the network (45). The software at this point could, of course, initialize one or more bots to search the various web sites and exchanges to get the best price for the company using the system of the present invention. In any event, the details of the purchase transaction and confirmation are then saved in the risk reduction purchase table (165) before processing advances to block 515.
[0256] The software in block 515 displays the report selection window (705) to the user (20). The user (20) optionally selects reports for printing. If the user (20) selects any reports for printing, then the information regarding the reports selected is saved in the reports table (164). After the user (20) has finished selecting reports, processing advances to a software block 516.
[0257] The software in block 516 checks the reports tables (164) to determine if any reports have been designated for printing. If reports have been designated for printing, then processing advances to a block 525. The software in block 525 sends the designated reports to the printer (118). After the reports have been sent to the printer (118), processing advances to a software block 527. Alternatively, if no reports were designated for printing, then processing advances directly from block 516 to block 527.
[0258] The software in block 527 checks the system settings table (140) to determine if the system is operating in a continuous run mode. If the system is operating in a continuous run mode, then processing returns to block 205 and the processing described previously is repeated. Alternatively, if the system is not running in continuous mode, then the processing advances to a block 528 where the system stops.
[0259] While the above description contains many specificity's, these should not be construed as limitations on the scope of the invention, but rather as an exemplification of one embodiment thereof. Accordingly, the scope of the invention should be determined not by the embodiment illustrated, but by the appended claims and their legal equivalents.
Claims
1. A computer readable medium having sequences of instructions stored therein, which when executed cause the processors in a plurality of computers that have been connected via a network to perform a business activity management method, comprising:
- integrating organization related data,
- identifying transaction measures with impact on one or more aspects of organization financial performance using at least a portion said data,
- modeling organization financial performance using said measures as required to identify changes in transactions that will optimize one or more aspects of organization financial performance, and
- implementing changes in business activities that will generate said changes.
2. The computer readable medium of claim 1 where the method further comprises making the list of changes and business activities available for review and use via a paper document or electronic display.
3. The computer readable medium of claim 1 where an organization is a single product, a group of products, a division, a company, a multi company corporation or a value chain.
4. The computer readable medium of claim 1 where data is aggregated using a xml and a common schema.
5. The computer readable medium of claim 1 where organization related data is obtained from the group consisting of advanced financial systems, basic financial systems, web site management systems, alliance management systems, brand management systems, customer relationship management systems, channel management systems, intellectual property management systems, process management systems, vendor management systems, operation management systems, sales management systems, human resource systems, accounts receivable systems, accounts payable systems, capital asset systems, inventory systems, invoicing systems, payroll systems, enterprise resource planning systems (ERP), material requirement planning systems (MRP), scheduling systems, quality control systems, purchasing systems, risk management systems, the Internet, external databases, user input and combinations thereof.
6. The computer readable medium of claim 1 where the transaction measures are selected from the group consisting of transaction ratios, time lagged transaction ratios, transaction trends, time lagged transaction trends, transaction averages, time lagged transaction averages, transaction data, time lagged transaction data, transaction patterns, time lagged transaction patterns, geospatial transaction measures, time lagged geospatial transaction measures, relative rankings, time lagged relative rankings, internet links, time lagged internet links, transaction frequencies, time lagged transaction frequencies, transaction time periods, time lagged transaction time periods, average transaction time periods, time lagged average transaction time periods, cumulative transaction time periods, cumulative transaction time periods, rolling average transaction time period, rolling average transaction time period, cumulative total transactions, time lagged cumulative total transactions, period to period rate of change in transactions, time lagged period to period rate of change in transactions and combinations thereof.
7. The computer readable medium of claim 1 where the transaction measures are identified by element of value where the elements of value are selected from the group consisting of alliances, brands, channels, customers, customer relationships, employees, intellectual capital, intellectual property, partnerships, processes, production equipment, vendors, vendor relationships and combinations thereof.
8. The computer readable medium of claim 1 where the transaction measures are identified by category of value where the categories of value are selected from the group consisting of current operation, real options, market sentiment and combinations thereof.
9. The computer readable medium of claim 1 where the one or more aspects of organization financial performance are selected from the group consisting of revenue, expense, capital change, current operation value, real option value, market sentiment value, market value, alliance value, brand value, channel value, customer value, customer relationship value, employee value, intellectual capital value, intellectual property value, partnership value, process value, production equipment value, vendor value, vendor relationship value, current operation risk, real option risk, market sentiment risk, market risk, alliance risk, brand risk, channel risk, customer risk, customer relationship risk, employee risk, intellectual capital risk, intellectual property risk, partnership risk, process risk, production equipment risk, vendor risk, vendor relationship risk, share price and combinations thereof.
10. The computer readable medium of claim 1 where the changes in business activities are selected from the group consisting of changes in purchase quantities, changes in purchasing mix, changes in vendors, changes in purchase discounts, changes in product discounts, changes in product pricing, changes in service pricing, changes in service discounts, changes in supply chain management, changes in the organization equity holdings, changes in operating limits for organization systems, changes in process management and combinations thereof.
11. A business activity management system, comprising:
- a plurality of computers connected by a network each with a processor having circuitry to execute instructions; a storage device available to each processor with sequences of instructions stored therein, which when executed cause the processors to:
- integrate organization related data,
- identify tangible measures of element and external factor impact on one or more aspects of organization financial performance using at least a portion said data,
- model organization financial performance using said measures as required to identify changes by element and external factor that will optimize one or more aspects of organization financial performance,
- make the list of changes available for review and optional approval via a paper document or electronic display, and
- implement one or more changes in business activities that will generate said changes.
12. The system of claim 11 where the method further comprises making the list of changes and business activities available for review and use via a paper document or electronic display.
13. The system of claim 11 where an enterprise is a single product, a group of products, a division, a company, a multi company corporation or a value chain.
14. The system of claim 11 where data is integrated using xml and a common schema.
15. The system of claim 11 where organization related data is obtained from the group consisting of advanced financial systems, basic financial systems, web site management systems, alliance management systems, brand management systems, customer relationship management systems, channel management systems, intellectual property management systems, process management systems, vendor management systems, operation management systems, sales management systems, human resource systems, accounts receivable systems, accounts payable systems, capital asset systems, inventory systems, invoicing systems, payroll systems, enterprise resource planning systems (ERP), material requirement planning systems (MRP), scheduling systems, quality control systems, purchasing systems, risk management systems, the Internet, external databases, user input and combinations thereof.
16. The system of claim 11 where the measures are selected from the group consisting of transaction ratios, time lagged transaction ratios, transaction trends, time lagged transaction trends, transaction averages, time lagged transaction averages, time lagged transaction data, transaction patterns, time lagged transaction patterns, geospatial transaction measures, time lagged geospatial transaction measures, relative rankings, time lagged relative rankings, internet links, time lagged internet links, transaction frequencies, time lagged transaction frequencies, transaction time periods, time lagged transaction time periods, average transaction time periods, time lagged average transaction time periods, cumulative transaction time periods, cumulative transaction time periods, rolling average transaction time period, rolling average transaction time period, cumulative total transactions, time lagged cumulative total transactions, period to period rate of change in transactions, time lagged period to period rate of change in transactions, composite variables, vectors and combinations thereof.
17. The system of claim 11 where the measures are identified by category of value where categories of value are selected from the group consisting of current operations, real options, market sentiment and combinations thereof.
18. The system of claim 11 where the one or more aspects of organization financial performance are selected from the group consisting of revenue, expense, capital change, current operation value, real option value, market sentiment value, market value, alliance value, brand value, channel value, customer value, customer relationship value, employee value, intellectual capital value, intellectual property value, partnership value, process value, production equipment value, vendor value, vendor relationship value, current operation risk, real option risk, market sentiment risk, market risk, alliance risk, brand risk, channel risk, customer risk, customer relationship risk, employee risk, fire risk, earthquake risk, flood risk, weather risk, contingent liabilities, intellectual capital risk, intellectual property risk, partnership risk, process risk, production equipment risk, vendor risk, vendor relationship risk, share price and combinations thereof.
19. The system of claim 11 where changes in business activities are selected from the group consisting of changes in purchase quantities;, changes in purchasing mix, changes in vendors, changes in purchase discounts, changes in product discounts, changes in product pricing, changes in service pricing, changes in service discounts, changes in supply chain management, changes in the organization equity holdings, changes in operating limits for organization systems, changes in process management, changes in risk transfer purchases and combinations thereof.
20. An interactive financial model that identifies the contribution of business activity and external factors to organization share price.
21. The model of claim 20 where the contribution of business activity is modeled with one or more transaction metrics.
22. The model of claim 21 where the one or more transaction metrics are selected from the group consisting of transaction ratios, time lagged transaction ratios, transaction trends, time lagged transaction trends, transaction averages, time lagged transaction averages, time lagged transaction data, transaction patterns, time lagged transaction patterns, geospatial transaction measures, time lagged geospatial transaction measures, relative rankings, time lagged relative rankings, internet links, time lagged internet links, transaction frequencies, time lagged transaction frequencies, transaction time periods, time lagged transaction time periods, average transaction time periods, time lagged average transaction time periods, cumulative transaction time periods, cumulative transaction time periods, rolling average transaction time period, rolling average transaction time period, cumulative total transactions, time lagged cumulative total transactions, period to period rate of change in transactions, time lagged period to period rate of change in transactions, composite variables, vectors and combinations thereof.
23. The model of claim 21 where the transaction metrics are key performance indicators.
24. The model of claim 20 where the contribution of external factors is determined using one or more tangible measures of external factor impact on aspects of financial performance.
25. The model of claim 20 that identifies the value of each of one or more organization elements of value is determined by its net contribution to organization value.
26. The model of claim 25 where the net contribution of an element to organization value is its direct contribution to organization value net of any contribution to the other elements of value and external factors that impact organization value.
27. The model of claim 25 where the elements of value are selected from the group consisting of alliances, brands, channels, customers, customer relationships, employees, intellectual capital, intellectual property, partnerships, processes, production equipment, vendors, vendor relationships and combinations thereof.
28. The model of claim 27 where brands are selected from the group consisting of a symbol indicating ownership, a symbol indicating source, a device indicating ownership, a device indicating source, mark, hallmark, label, logo, logotype, trade mark, stamp, tag, seal, a distinctive style, model, cut, line, make, pattern, a specific characteristic ascribed to an organization, a specific characteristic ascribed to an organization offering, a specific reputation ascribed to an organization, a specific reputation ascribed to an organization offering, a specific trait ascribed to an organization, a specific trait ascribed to an organization offering and combinations thereof.
29. The model of claim 27 where processes are selected from the group consisting of a series of actions bring about a result, a series changes bringing about a result, a series of functions bringing about a result and combinations thereof.
30. The model of claim 20 that supports the optimization of one or more aspects of organization financial performance where the one or more aspects of financial performance are selected from the group consisting of revenue, expense, capital change, current operation value, real option value, market sentiment value, market value, alliance value, brand value, channel value, customer value, customer relationship value, employee value, intellectual capital value, intellectual property value, partnership value, process value, production equipment value, vendor value, vendor relationship value, current operation risk, real option risk, market sentiment risk, market risk, alliance risk, brand risk, channel risk, customer risk, customer relationship risk, employee risk, fire risk, earthquake risk, flood risk, weather risk, contingent liabilities, intellectual capital risk, intellectual property risk, partnership risk, process risk, production equipment risk, vendor risk, vendor relationship risk and combinations thereof.
31. The model of claim 20 that supports the optimization of business activities where business activities are selected from the group consisting of purchasing, pricing, process management, supply chain management, risk management, sales, stock price management and combinations thereof.
32. The model of claim 31 where purchasing activities are selected from the group consisting of changes in purchase quantities, changes in purchasing mix, changes in vendors, changes in purchase discounts, changes in purchase prices, changes in purchase frequency and combinations thereof.
33. A method for integrating organization systems into an overall financial management system, comprising
- integrating data from organization related systems using xml and a common schema,
- developing a model of organization share price using at least a portion of said data,
- identifying changes in operation that will optimize one or more drivers of organization share price using said model, and
- implementing said changes in operation by communicating the changes to one or more organization systems.
34. The method of claim 33 where organization related systems are selected from the group consisting of advanced financial systems, basic financial systems, web site management systems, alliance management systems, brand management systems, customer relationship management systems, channel management systems, intellectual property management systems, process management systems, vendor management systems, operation management systems, sales management systems, human resource systems, accounts receivable systems, accounts payable systems, capital asset systems, inventory systems, invoicing systems, payroll systems, enterprise resource planning systems (ERP), material requirement planning systems (MRP), scheduling systems, quality control systems, purchasing systems, risk management systems, and combinations thereof.
35. The system of claim 33 that where changes in operation are selected from the group consisting of changes in purchasing, changes in pricing, changes in processes, changes in the supply chain, changes in risk management, changes in sales, changes in equity holdings and combinations thereof.
Type: Application
Filed: Apr 9, 2004
Publication Date: Oct 7, 2004
Inventor: Jeff Scott Eder (Mill Creek, WA)
Application Number: 10821504
International Classification: G06F017/60;
