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 259
- Downloads 0
Determinants of Export Survival: The Case of Ghanaian Manufacturers
In this study, we sought to investigate the factors that affect the export survival of Ghanaian manufacturing firms, using the survival (or duration) analysis technique. The study used a panel dataset (of Ghanaian manufa...
Impact of Credit Constraints on Firms Growth: A Case Study of Manufacturing Sector of Pakistan
This study explores the impact of credit constraint on growth by using firm level data of manufacturing sector of Pakistan for the period of 1974-2010 analyzing via Generalized Method of Moments (1991) one step and two s...
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...
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...
The Journey from Entropy to Generalized Maximum Entropy
Not available