Creating Optimal Portfolio and the Efficient Frontier Using Microsoft Excel®: Teaching Module
Journal Title: Journal of Quantitative Methods (JQM) - Year 2018, Vol 2, Issue 2
Abstract
Portfolio managers and investors strive to achieve the best possible trade-off between risk and return, and one of the tools they use is constructing mean-variance efficient portfolios. Finance students learn about optimal portfolios and efficient frontiers, though it is difficult to replicate them unless they have access to sophisticated software. This paper develops a teaching module that uses Microsoft Excel® to create mean-variance portfolios and traces out the efficient frontier using real-world data. In the process, the students learn to determine optimal investment allocations in a portfolio, select the optimum investment portfolio given investor’s objectives and preferences and learn about factors that influence different asset allocations. For multiple assets (N>3), the paper uses Matrix algebra in Excel®. The paper enables students and investors to learn how to construct real-world mean-variance efficient portfolios using Excel®.
Authors and Affiliations
Saurav Roychoudhury
Keywords
Related Articles
- EP ID EP546466
- DOI 10.29145/2018/jqm/020207
- Views 231
- Downloads 0
Environmental Kuznets Curve: A Times Series Evidence from Pakistan
In this paper, the Environmental Kuznets Curve (EKC) is used to investigate the connections between CO2 emissions, energy consumption, economic growth, trade openness and urban population in Pakistan over the period of 1...
Financial Development and Economic Growth: The Role of Energy Consumption
The study investigates financial development and economic growth nexus, incorporating use of energy resources for Pakistan for 1980- 2016, using Johansen co-integration and granger causality approach. The results of Joha...
Detecting Stationarity of GDP: A Test of Unit Root Tests
Despite extensive research of research on unit roots, consensus on several important issues and implications has not emerged to date (Libanio, 2005). There are many series which were being investigated for existence of u...
Quantitative Methods and its Contemporary Directions
As complex social, political, economic and business factors affect quantitative research, a critical debate is needed to understand and apply them in evidence based scenarios.
Structural Equation Modelling of Relationship between Teachers’ Capacity Building and Students’ Academic Performance in Secondary Schools in Kwara State, Nigeria
Unarguably, students’ academic success rests on the learning experiences derived from their teachers via teaching and learning processes in the classroom. Teachers are an important tool for implementing the school progra...