Portfolio Analysis Using Spreadsheet Tools
Clarence C. Y. Kwan · SSRN Electronic Journal · 2001
This paper uses spreadsheet tools to solve portfolio selection problems numerically. Without the encumbrance of any algorithmic details and formal programming requirements, the analysis can easily accommodate various relevant constraints, such as investment limits and institutional procedures for short selling. In addition, it illustrates how the portfolio concept can be delivered pedagogically without relying on unrealistic assumptions found in many investment textbooks. This approach can also enhance the practical relevance and accessibility of portfolio analysis to investors.