Financial modeling systems and methods

• US 10,096,061 B2
• Filed: 03/20/2009
• Issued: 10/09/2018
• Est. Priority Date: 03/20/2008
• Status: Active Grant

• Current Assignee: LEAP System Incorporated
• Original Assignee: LEAP System Incorporated
• Inventors: Castiglione, Robert, Castiglione, Christian
• Primary Examiner(s): Ebersman, Bruce I
• Application Number:
  US12/408,643
• Publication Number:
  US 20090259580A1
• Time in Patent Office: 3,490 Days
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes

Abstract

Systems and methods for providing financial modeling are provided. A financial modeling method according to the present invention can comprise receiving comprehensive financial data relating to an entity. The financial data can be categorized into a plurality of financial components, which can comprise a protection component, and savings component, and a growth component. An additional step can comprise analyzing the financial data, along with a set of assumptions, to create a financial model based on the plurality of financial components. The method can display a graphical representation of the financial model, and the graphical representation can illustrate an application of one or more of the financial components to the financial data. An update to the financial data or the assumptions can be received and dynamically incorporated into the graphical representation.

Claims

1. A non-transitory computer-readable medium storing instructions that, when executed by one or more processors, cause a system to:

receive financial data relating to an entity;

categorize the financial data into a plurality of financial components, the plurality of financial components at least including a protection component, and savings component, and a growth component;

responsive to analyzing the financial data and a set of assumptions, create, by the processor, a financial model based on the plurality of financial components;

output, for display, a graphical representation of the financial model, the graphical representation illustrating application of one or more of the plurality of financial components to the financial data;

divide each of the plurality of financial components into a plurality of sub-components;

output, for display, for at least one of the plurality of financial components, a graphical representation of the sub-components associated with the at least one financial component, each respective sub-component of the at least one financial component being represented in a respective cell of a grid, wherein the grid has a plurality of rows and a plurality of columns, and wherein the graphical representations of the sub-components associated with the at least one financial component are arranged inside the grid according to a predetermined hierarchical pattern based at least in part on a number of functions associated with each respective sub-component; and

responsive to receiving an update to the financial data and the set of assumptions, output, for display, a dynamically updated graphical representation of the financial model dynamically based on the received update, the dynamically updated graphical representation of the financial model including simulating a move of funds by;

graphically depicting removal of a value of the funds from a first displayed sub-component; and

graphically depicting movement of the value of the funds between the first displayed sub-component and a second displayed sub-component by;

illustrating physical motion, from the first displayed sub-component to the second displayed sub-component, of a graphical depiction of the value of the funds across a display; and

graphically depicting combining the value of the funds with a value in the second displayed sub-component.

2. The non-transitory medium of claim 1 storing additional instructions that, when executed by the one or more processors, cause the system to output, for display, one or more dollar values corresponding to a sub-component from the sub-components associated with the at least one financial component.

3. The non-transitory medium of claim 1, wherein the predetermined hierarchical pattern is further based on a degree of risk associated with each sub-component.

4. The non-transitory medium of claim 1, wherein the predetermined hierarchical pattern is further based on liquidity associated with each sub-component.

5. The non-transitory medium of claim 1, wherein the predetermined hierarchical pattern is further based on productivity associated with each sub-component.

6. The non-transitory medium of claim 1, the protection component corresponding to funds used to protect the entity'"'"'s wealth.

7. The non-transitory medium of claim 1, the savings component corresponding to funds that are saved.

8. The non-transitory medium of claim 1, the growth component corresponding to funds expected to grow.

9. The non-transitory medium of claim 1, the debt component corresponding to liabilities of the entity.

10. The non-transitory medium of claim 1, the displayed sub-components being color-coded to indicate a status with respect to one or more financial benchmarks.

11. The non-transitory medium of claim 1, wherein the grid of the two or more sub-components, inside the graphical representation of the first component, comprises at least two dimensions.

12. The non-transitory medium of claim 1, wherein the functions include protection of assets, protection of income, and protections from consequences of death.

13. The non-transitory medium of claim 1, wherein the functions include providing a safety net, high yields, and tax benefits.

14. A method for modeling financial data, the method comprising:

receiving, at a processor, a user'"'"'s responses to a financial questionnaire;

automatically importing, by the processor, the user'"'"'s responses to the financial questionnaire into a financial model, the financial model having a plurality of financial components, including at least two distinct and explicitly identified financial components;

receiving, by the processor, a set of assumptions relating to the financial model;

outputting, by the processor and for display, a graphical representation of the financial model, the graphical representation illustrating application of one or more of the plurality of financial components to at least a portion of the user'"'"'s responses and at least a portion of the set of assumptions;

dividing, by the processor, each of the plurality of financial components into a respective plurality of sub-components;

for at least one of the plurality of financial components, outputting, by the processor and for display, a graphical representation of the plurality of sub-components associated with a respective financial component, each respective sub-component of the associated plurality of sub-components being represented in a respective cell of a grid,

wherein the grid has a plurality of rows and a plurality of columns,

wherein the graphical representations of the associated plurality of sub-components are arranged inside the grid according to a predetermined hierarchical pattern, and

wherein the graphical representations of the associated plurality of sub-components are color-coded according to a predetermined scheme wherein, for a benchmark associated with a particular respective sub-component, a first color indicates that that the particular respective sub-component passed the benchmark, a second color indicates that the particular respective sub-component received borderline results for the benchmark, and a third color indicates that the particular respective sub-component failed the benchmark; and

responsive to receiving, at the processor, an update to the user'"'"'s responses and the set of assumptions, outputting, by the processor and for display, a dynamically updated graphical representation of the financial model based on the received update, the dynamically updated graphical representation of the financial model including simulating a move of funds by;

graphically depicting removal of a value of the funds from a first displayed sub-component; and

graphically depicting movement of the value of the funds between the first displayed sub-component and a second displayed sub-component by;

illustrating physical motion, from the first displayed sub-component to the second displayed sub-component, of a graphical depiction of the value of the funds across a display; and

graphically depicting combining the value of the funds with a value in the second displayed sub-component.

15. The method of claim 14, further comprising determining, by the processor, one or more input values based on the user'"'"'s responses.

16. The method of claim 14, further comprising calculating, by the processor, one or more output values corresponding to financial outputs in a user specified future year.

17. The method of claim 16, further comprising applying, by the processor, an inflation rate to the output values to generate a present value of the output values.

18. The method of claim 14, wherein receiving an update to the user'"'"'s responses or the set of assumptions comprises receiving, by the processor, an update to a start age of an entity, and wherein the dynamically updated graphical representation of the financial model has one or more input values based on the updated start age.

19. The method of claim 14, wherein receiving an update to the user'"'"'s responses or the set of assumptions comprises receiving, by the processor, an update to an end age of an entity, and wherein the dynamically updated graphical representation of the financial model has one or more output values based on the updated start age.

20. The method of claim 14, the method further comprising updating, by the processor, a future representation of a cash flow based on a projected debt repayment term.