Optimizing Stock Portfolio using Markowitz Model

Authors

  • Quan Wang

DOI:

https://doi.org/10.54691/bcpbm.v44i.4926

Keywords:

Stock market; Markowitz Model; Sharpe ratio.

Abstract

The stock market is a well-known illustration of an investing option with obvious returns. Its volatility provides a basis for carefully analyzing its prior results in an effort to forecast future market returns. This paper discusses the various models used for selecting investment portfolios and utilizes the Markowitz decision-making model to aid in selecting an optimal investment portfolio based on historical price data and US Treasury 10-year bond rate data. Four stocks were included in the model, with two popular and highly volatile stocks, and two fast-growing stocks. The Markowitz model that maximizes the Sharpe ratio favors the two fast-growing stocks, whereas the same calculations for minimizing risk favor the more volatile stocks, but only lowers risk marginally and reduce returns significantly. The paper further analyzed the accuracy of the Markowitz model in this specific case and provided the Fama French model as a usable alternative that will likely provide alternative suggestions that are more correlated to real-life scenarios.

Downloads

Download data is not yet available.

References

Markowitz, H. (1952). Portfolio selection. The Journal of Finance, 7(1), 77. https://doi.org/10.2307/2975974.

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. https://doi.org/10.1016/0304 - 405x (93) 90023 - 5.

Ikpe, D., Mawonike, R., & Viens, F. (2022, October 15). Static Markowitz mean-variance portfolio selection model with long-term bonds. Numerical Algebra, Control and Optimization. Retrieved February 5, 2023, from https://www.aimsciences.org/article/doi/10.3934/naco.2022030.

Q4 and FY 2022 Update. (n.d.). Tesla Inc. Retrieved February 4, 2023, from https://tesla-cdn.thron.com/static/SVCPTV_2022_Q4_Quarterly_Update_6UDS97.pdf?xseo=&response-content-disposition=inline%3Bfilename%3D%22b7871185-dd6a-4d79-9c3b-19b497227f2a.pdf%22.

GameStop reports Third Quarter Fiscal Year 2022 results. Gamestop Corp. (2022, December 7). Retrieved February 5, 2023, from https://gamestop.gcs-web.com/news-releases/news-release-details/gamestop-reports-third-quarter-fiscal-year-2022-results.

4Q 2022 Earnings Release. (n.d.). ExxonMobil. Retrieved February 4, 2023, from https://corporate.exxonmobil.com/-/media/global/files/investor-relations/quarterly-earnings/earnings-announcements/2022-earnings-announcements/4q-earnings-release.pdf?la=en&hash=EC8782EF17AD4A9A25E1FDF04784279391255830.

Occidental Announces 3rd Quarter 2022 Results. (n.d.). Occidental Petroleum. Retrieved February 4, 2023, from https://www.oxy.com/globalassets/documents/investors/quarterly-earnings/oxy3q22earningspressrelease.pdf.

Cahyadi, S., & Napitupulu, T. A. (2015). The impact of crude price and exchange rate toward stock price of Oil Company. Advanced Science Letters, 21(4), 792–794. https://doi.org/10.1166/asl.2015.5878.

Sharpe, W. F. (1966). Mutual Fund Performance. The Journal of Business, 39 (S1), 119. https://doi.org/10.1086/294846.

Khan, A., Goodell, J. W., Hassan, M. K., & Paltrinieri, A. (2022). A bibliometric review of finance bibliometric papers. Finance Research Letters, 47, 102520.

Downloads

Published

2023-04-27

How to Cite

Wang, Q. (2023). Optimizing Stock Portfolio using Markowitz Model. BCP Business & Management, 44, 740-746. https://doi.org/10.54691/bcpbm.v44i.4926