Comparison and Application of Markowitz Model and Index Model in Capital Markets
DOI:
https://doi.org/10.61173/6bgw1q76Keywords:
Markowitz Model, Index Model, SPX Index, Optimal portfolio, Capital MarketsAbstract
The Markowitz Model represents a portfolio’s returns for given risk levels. This research will imply the MM in Excel using the Solver tool. The model focuses on creating a portfolio that maximizes returns for a given level of risk or minimizes risks for a given level of return. Implementing the index model simplifies the calculation of expected returns and the covariance matrix of returns compared to the MM. This study aimed to compare the Markowitz Model and Index Model in constructing optimal portfolios from 10 stocks, the SPX index, and the 1-month federal funds rate, considering 20 years of monthly return data. This paper analyzes the impact of five constraints on these models’ efficient frontiers, using Excel Solver for optimization. The study aims to understand how these models perform under various practical constraints and draw insights relevant to real-life portfolio management scenarios.
References
December 2, 2022. Archived from the original on May 2, 2023. Retrieved April 3, 2023. ● “Certificate of Incorporation of Computing-Tabulating- Recording-Co”, Appendix to Hearings Before the Committee on Patents, House of Representatives, Seventy-Fourth Congress, on H. R. 4523, Part III, United States Government Printing Office, 1935 [Incorporation paperwork filed June 16, 1911], archived
from the original on August 3, 2020, Retrieved July 18, 2019 ●“SAP Q4 2022 Quarterly Statement” (PDF). SAP SE. Retrieved 4 February 2023. ●“in PDF on page 2 (Assets Under Management)” (PDF). bankofamerica.com. ●“US SEC: 2022 Form 10-K Citigroup Inc”. U.S. Securities and Exchange Commission. February 27, 2023. ●Wack, Kevin (February 26, 2020). “How New York became Wells Fargo’s new center of power.” American Banker. ● “The Travelers Companies, Inc. 2022 Annual Report (Form 10-K)”. sec.gov. U.S. Securities and Exchange Commission. 16 February 2023. ● “Southwest Airlines Announces New Crew Base for Pilots and Flight Attendants at Nashville International Airport (BNA)” (Press release). August 14, 2023. Retrieved October 26, 2023. ●Alaska Air Group, Inc. 2022 Annual Report (Form 10-K)”. U.S. Securities and Exchange Commission. February 13, 2023. ●“Airline Certificate Information – Detail View.” av-info.faa. gov. Federal Aviation Administration. December 27, 1946.
Archived from the original on January 20, 2018. Retrieved
January 19, 2018. Certificate Number HALA005A
Downloads
Published
Issue
Section
License
Copyright (c) 2024 by the authors.
This work is licensed under a Creative Commons Attribution 4.0 International License.
