A computer-implemented investment system and methods provide a guaranteed principal amount such as a fixed annuity while offering a possibility of higher returns found in a broad equity index fund to investors. A sum certain guaranteed principal investment calculation system and a calculate investor profile command that is customizable by a user can provide an investment strategy tailored to the user based on his profile data and scope of investment. The investment system allows a customizable application system to interface with investment clients, to correlate data with metadata and other criteria, and to display queried data. In one aspect, the investment system can provide a relational database management system that has a relational data repository for storing investment fact data, an aggregation module to present at least a non-guaranteed principal portion and a guaranteed principal portion per investment portfolio product, and a query servicing module to a user.