Investment Analysis Application Using In-House Spreadsheet Models

Lee Tangedahl, Timothy A. Manuel


This paper describes a spreadsheet package which has been used in investments classes as well as in computer application classes. The spreadsheet package is menu driven and (among other things) generates statistical and regression analysis and solves the quadratic equations necessary to find the efficient frontier. The program allows the student to easily apply the major results of modern portfolio theory in a realistic fashion using actual stock return data.

Full Text:



  • There are currently no refbacks.

Copyright (c) 2017 Developments in Business Simulation and Experiential Learning

Creative Commons License
This work is licensed under a Creative Commons Attribution-NoDerivatives 4.0 International License.