Patent ID: 10438387

Abstract:
A graphing system (FIG. 2) and method (200) for generating a one-page multi-Y axis graph (207) for analyzing alternate scenarios. The WHATIF SYSTEM can generate a one-page multi-Y axis graph using input from a spreadsheet file (208). The WHATIF SYSTEM can also generate a one-page multi-Y axis graph using input from one or more sets of financial project profitability measures (203). The WHATIF SYSTEM allows the user to generate a BASE CASE file (201) of a projects financial description. The BASE CASE file is simulated by the SIMULATE function (202) producing a set of profitability measures (203): Internal Rate of Return on Investment (IRROI) before taxes, IRROI after taxes, Internal Rate of Return on Equity (IRROE) after taxes, payback period, minimum equity, minimum loan, and minimum period required to repay debt. A file named WHATIF (204) defines percentage adjustments to be automatically applied to the BASE CASE file by the AUTOMATE function (205). The GRAPH function (206) generates a one-page multi-Y axis graph (207) displaying a graph of a spreadsheet file or a graph of financial metrics and profitability measures.