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 281
- Downloads 0
Quality Academic Process: A Panacea for Student Development in University Education
There has been a discussion on the quality of student development in the Nigerian university system as one of the roles of university education, is a manpower development. However, there has been a decline in the quality...
Infrastructure Development in Punjab, Pakistan: From Assessment to Spatiotemporal Analysis at District Level
Access to inclusive and sustainable infrastructure to the masses of each spatial unit of any country and region is of the paramount importance. This paper aims at examining the level of infrastructure development, analys...
Modified Shewhart Control Chart Based on CEV for Gamma Distributed Lifetimes in the Presence of Type-I Censored Data
This article explains the modified version of Shewhart control charts for monitoring the mean level of the Gamma lifetimes under the Type-I censored data. Shewhart control chart based on the conditional expected values (...
Corruption, Political Instability and Sustainable Development: The Interlinkages
The study empirically probed the interdependence among corruption, political instability and sustainable development for a panel of 28 developing economies and disaggregated sample of lower-middle and upper-middle income...
Disaggregated Imports Demand Functions: An Empirical Analysis for Pakistan
Given the importance of international trade in the economic performance of a country, voluminous research work has been carried out on the determinants of aggregate exports and imports. The present study departs from the...