In the post-pandemic era, marked by economic uncertainty and stock market volatility, investors are turning to Modern Portfolio Theory (MPT) to guide their investment decisions. This study aims to develop a robust mathematical framework for portfolio construction using the Markowitz Model (MM) and the Index Model (IM) with added constraints. The objectives are threefold: (1) to create a portfolio framework that reflects investor preferences using MM and IM with additional constraints, (2) to compare these models against the Gaussian Distribution using Python and Excel, (3) to compare the statistical data and correlation tests of daily logarithmic returns in Python with monthly excess returns in Excel, and (4) to evaluate their performance relative to the traditional Markowitz approach through Monte Carlo simulations.The methodology involves incorporating five additional constraints into the MM and IM models. The analysis uses 20 years of historical daily return data for ten stocks from various sectors, one equity index (S&P 500) as a risk-free rate proxy (1-month Fed Funds rate). Daily logarithmic returns are analyzed using Python, while Excel Solver and Solver Table are employed for monthly excess return data.
Read full abstract