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 264
- Downloads 0
Econometric Test on Growth-Unemployment Nexus in India
Generally, the economic growth boosts employment growth rate but empirical evidences do not support these views in all cases. In this paper, the author endeavors to relate growth with unemployment rate during 1991-2016 i...
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...
Impact of Working Capital on the Profitability of UK Pharmaceuticals and Biotechnology FTSE All Share Index Firms
The study is conducted to investigate the impact of a working capital on profitability for the Pharmaceuticals and Biotechnology firms listed on FTSE all share index. Panel data is collected (data is collected from 2009...
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 (...
Creating Optimal Portfolio and the Efficient Frontier Using Microsoft Excel®: Teaching Module
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 optim...