Discounted future value operations on a massively parallel processing system and methods thereof

A non-transitory computer readable medium having stored thereon instructions which when executed by a processor cause the processor to perform the method of:

• arranging data from a data source in a columnar table format;
• receiving tabular data containing data points representing a forecast of future values;
• receiving instructions to perform an iterative calculation on the data points;
• and
• for a predetermined selection of the columnar data points, assigning portions of the predetermined selection to a parallel processing system and applying structured query language operators to the columnar data and the tabular data to calculate results of the iterative calculation.

A system comprising:

• a central controller coupled via a communication bus to a relational engine, a database optimizer, a parallel calculation engine, and a parallel processor, the central controller executing instructions and controlling operation of the relational engine, database optimizer, parallel calculation engine, and parallel processor;
• the relational engine configured to arrange data stored in a data store coupled to the communication bus into a columnar table;
• the database optimizer configured to manage data in the data store and distribute the data to the parallel processor;
• and
• the parallel calculation engine configured to assign predetermined portions of the columnar table to the parallel processor.