Portfolio Establishment for Asset Allocation based on the Empirical Study

Qinxin Wang; Yuxin Tang; Yanyan Jin; Yutong Lai; Runyin Wang; Yihua He

doi:10.54691/bcpbm.v26i.2058

Authors

Qinxin Wang
Yuxin Tang
Yanyan Jin
Yutong Lai
Runyin Wang
Yihua He

DOI:

https://doi.org/10.54691/bcpbm.v26i.2058

Keywords:

Optimal portfolio; Markowitz model; Single-factor Index model.

Abstract

The purpose of this study is to use Markowitz model and Single-factor index model to determine the optimal portfolio of S&P 500 and 6 stocks from 3 industries under 5 different constraints. The research is looked at stock prices on a daily basis from January 2000 to December 2020 and all data were obtained from secondary sources or non-participatory observation methods. Then this paper also considers the sensitive analysis to investigate the different impacts of factors. The sensitivity analysis tool used in this study was the Solver Table. Through calculation, the optimal portfolio ratio, minimum risk point, maximum Sharpe ratio, effective frontier, minimum return frontier and maximum variance frontier for each constraint under different models are obtained. In this process, it has been found that Single-factor Index model is simpler and more practical than Markowitz model. This paper provides inspiration for individual investors and financial institutions that Index model is more convenient to use in real life and likewise help them to make investment decisions.

Downloads

Download data is not yet available.

References

Bonfim, D. (2009). Credit risk drivers: Evaluating the contribution of firm level information and of macroeconomic dynamics. Journal of Banking & Finance, 33(2), 281-299.

Ivanova, M., & Dospatliev, L. (2017). Application of Markowitz portfolio optimization on Bulgarian stock market from 2013 to 2016. International Journal of Pure and Applied Mathematics, 117(2), 291-307.

Huang, X., & Qiao, L. (2012). A risk index model for multi-period uncertain portfolio selection. Information Sciences, 217, 108-116.

Sarwar, S., Shahbaz, M., Anwar, A., & Tiwari, A. K. (2019). The importance of oil assets for portfolio optimization: The analysis of firm level stocks. Energy Economics, 78, 217-

Wood, David. (2002). Portfolio Optimization Benefits from Integrating Analysis of Risk, Strategy, and Valuation. Oil and Gas Journal. 100. 26-33.

Brinson, G. P., Hood, L. R., & Beebower, G. L. (1986). Determinants of portfolio performance. Financial Analysts Journal, 42(4), 39-44.

Fama, E. F., & French, K. R. (1993). Common risk factors in the returns on stocks and bonds. Journal of financial economics, 33(1), 3-56.

Asness, C. S., Frazzini, A., & Pedersen, L. H. (2019). Quality minus junk. Review of Accounting Studies, 24(1), 34-112.

Lev, B., & Srivastava, A. (2019). Explaining the recent failure of value investing. NYU Stern School of Business.

Markowitz, H. M. (1991). Foundations of portfolio theory. The journal of finance, 46(2), 469-477.

Pogue, G. A. (1970). An extension of the Markowitz portfolio selection model to include variable transactions' costs, short sales, leverage policies and taxes. The Journal of Finance, 25(5), 1005-1027.

Soleimani, H., Golmakani, H. R., & Salimi, M. H. (2009). Markowitz-based portfolio selection with minimum transaction lots, cardinality constraints and regarding sector capitalization using genetic algorithm. Expert Systems with Applications, 36(3), 5058-5063.

Sharpe, W. F. (1963). A simplified model for portfolio analysis. Management science, 9(2), 277-293.

Hristache, M., Juditsky, A., & Spokoiny, V. (2001). Direct estimation of the index coefficient in a single-index model. Annals of Statistics, 595-623.

Bilbao, A., Arenas, M., Jiménez, M., Perez Gladish, B., & Rodríguez, M. V. (2006). An extension of Sharpe's single-index model: portfolio selection with expert betas. Journal of the Operational Research Society, 57(12), 1442-1451.

Margin account requirements. (n.d.). Retrieved from https://www.finra.org/rules-guidance/key-topics/margin-accounts

15 U.S. Code § 80a–12 - functions and activities of investment companies. (n.d.). Retrieved from https://www.law.cornell.edu/uscode/text/15/80a-12

Kenton, W. Beta. Retrieved from https://www.investopedia.com/terms/b/beta.asp

Mandal, N. (2013). Sharpe’s single index model and its application to construct optimal portfolio: an empirical study. Great Lake Herald, 7(1), 1-19.