Patent ID: 8583530

Claim:
A financial modeling system, the financial modeling system comprising: at least one data storage device; and at least one processor, the at least one processor configured: to store, in the at least one data storage device, a spreadsheet data structure that that describes a variable annuity contract between a customer and a financial services company, wherein the spreadsheet data structure includes: a first formula for determining a value associated with the variable annuity contract during a first time period; a second formula for determining the value associated with the variable annuity contract during a second time period, wherein the second time period is subsequent to the first time period, and wherein the second formula is based on an output of the first formula; to generate an intermediate representation of the spreadsheet data structure based on the first formula and the second formula, wherein the intermediate representation includes information that describes how the value associated with the variable annuity contract is determined during the first time period and the second time period; and to generate compilable software code based on the information from the intermediate representation, wherein the compilable software code includes one or more instructions for determining the value associated with the variable annuity contract during the first time period and the second time period.