In this paper, we present the problem of portfolio optimization under investment. This area of investment is traced with works of Professor Markowitz way back in 1952. First, we determine the probability distribution of the Uganda Securities Exchange (USE) stocks returns. Secondly, we develop unrestricted portfolio optimization model based on the classical Modern Portfolio Optimization (MPT) model, and then we incorporate certain restrictions typical of the USE trading or investment environment and hence, develop the modified restricted model. Thirdly, we explore the possibility of diversification under a portfolio of averagely correlated assets. Determination of the model parameters and model development is all done using Excel spreadsheets. We explicitly go through the mathematics of the solution methods for both models. Validation of the models is done using the USE stocks daily trading data, in which case we use a random sample of 6 stocks out of the 13 stocks listed at the USE. To start with, we prove that USE stocks log returns are normally distributed. Data analysis results and the frontier curves show that our modified (restricted) model is valid as the solutions are all consistent with the theoretical foundations of the classical MPT-model but inferior to the unrestricted model. To make the model more useful, accurate and easy to apply and robust, we programme the model using Visual Basic for Applications (VBA). We therefore recommend that before applying investment models such as the MPT, model modifications must be made so as to adapt them to particular investment environments. Moreover, to make them useful so as to serve the intended purpose, the models should be programmed so as to make implementation less cumbersome.
Cite this paper
F. Mayanja, S. Mataramvura and W. Charles, "A Mathematical Approach to a Stocks Portfolio Selection: The Case of Uganda Securities Exchange (USE)," Journal of Mathematical Finance
, Vol. 3 No. 4, 2013, pp. 487-501. doi: 10.4236/jmf.2013.34051
 M. Fredrick, M. Sure and M. Charles, “Portfolio Optimization Model: The Case of Uganda Securities Exchange,” LAP LAMBERT Academic Publishing GmbH & Co. KG, Ltd., Saarbrücken, 2012.
 A. V. Puelz, “A Stochastic Convergence Model for Portfolio Selection,” Operations Research, Vol. 50, No. 3, 2002, pp. 462-476.
 H. M. Markowitz, “Portfolio Selection,” The Journal of Finance, Vol. 7, No. 1, 1952, pp. 77-91.
 H. M. Markowitz, “Portfolio Selection: Efficient Diversification of Investments,” John Wiley & Sons, New York, 1959.
 J. Lintner, “The Valuation of Risk Assets and the Selection of Risky Investments in Stock Portfolios and Capital Budgets,” The Review of Economics and Statistics, Vol. 47, No. 1, 1965, pp. 13-39.
 W. F. Sharpe, “Capital Asset Prices: A Theory of Market Equilibrium under Conditions of Risk,” Journal of Finance, Vol. 19, No. 3, 1964, pp. 425-442.
 P. Krokhmal and S. Uryasev, “Portfolio Optimization with Conditional Value-at-Risk Objective and Constraints Center for Applied Optimization,” University of Florida, Gainesville, 2001, pp. 32611-6595.
 S. Uryasev, “Portfolio Optimization with Conditional Value-at-Risk Objective and Constraints Center for Applied Optimization,” University of Florida, Gainesville, 1999, p. 32611.
 Y. Kroll, H. Levy and H. M. Markowitz, “Mean-Variance versus Direct Utility Maximization,” The Journal of Finance, Vol. 39, No. 1, 1984, pp. 47-62.
 H. Konno and H. Yamazaki, “Mean-Absolute Deviation Portfolio Optimization Model and Its Applications to Tokyo Stock Market Management,” Science, Vol. 37, No. 5, 1991, pp. 519-531.
 T. Kariya, “Distribution of Stock Prices in the Stock Market of Japan,” Toyo Keizai Publishing Co., Tokyo, 1989.
 G. Arnold, “Corporate Financial Management,” 3rd Edition, Pearson Education Limited, 2008.
 Uganda Securities Exchange, “Frequently Asked Questions and Answers about USE,” 2010. www.use.or.ug
 A. B. Mayanja and K. Legesi, “Cost of Equity Capital and Risk on USE: Equity Finance; Bank Finance, Which One Is Cheaper?” MPRA Paper No. 6407, Economic Policy Research Centre, First Brokerage House, Washington DC, 2007.
 E. J. Elton and M. J. Gruber, “Portfolio Theory When Investment Relatives Are Log normally Distributed,” Journal of Finance, Vol. 29, No. 4, 1974, pp. 1265-1274.http://dx.doi.org/10.1111/j.1540-6261.1974.tb03103.x
 H.-S. Lau, “On Estimating Skewness in Stock Returns Management,” Science, Vol. 35, No. 9, 1989, pp. 1139-1142. http://dx.doi.org/10.1287/mnsc.35.9.1139
 D. J. Wheeler and D. S. Chambers, “Introduction to Skewness and Kurtosis,” SPC Press, Inc., Knoxville, 1992.
 S.-P. Wan, “Modern Portfolio Theory Bussiness 442: Investments,” Chapter 5, 2000.
 A. T. Hamdy, “Newblock Operations Research an Introduction,” 8th Edition, Pearson Education, Inc., University of Arkansas, Fayetteville, 2007.
 M. Jackson and M. Staunton, “Advanced Modelling in Finance Using Excel and VBA,” John Wiley & Sons, Ltd., Chichester, 2001.