IFPS

IFPS (Interactive Financial Planning System) was a financial modeling language created by professor Gerald R. Wagner and his students of the University of Texas at Austin in the late 1970s.^[1] IFPS was marketed by Execucom, an Austin-based company started by Wagner. The company was acquired by Comshare in 1991.^[2]

IFPS was available for a variety of platforms, including IBM mainframes (VM/CMS), DEC VAX, various flavors of Unix, DOS-based PCs and Macintosh Computers (named "Mindsight"- running on two floppies). There were a number of versions, from about 1985, including optimization and a data area for storing data separately from models. IFPS seems to have been an important inspiration for the Javelin financial modeling application. Some parts of the IFPS approach were later used by Lotus's Improv- like the separation of model logic and data. Difference to spreadsheet software (Lotus 1-2-3 and later Excel): Mainframe and PC/Mac versions of IFPS completely separated the logic model (connections between variables) and the data. Both were bound together by data placeholder (like "earnings in Year1" in the logic model - to easily run scenarios . (Spreadsheet) columns were represented by Name1, Name2, name3 etc. The model logic was written in lines with placeholder- oriented text ( "earnings=sales-costs" etc.). Comment lines on the model could be included anywhere with //. IFPS mainframe versions also allowed to simulate stochastic events by providing a of range probability distributions. The IFPS approach made it easy to communicate complex models even to laymen and managers.

IFPS was eventually out-competed by spreadsheets.

References