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 233
- 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...
Determinants of Net Interest Margins in Emerging Markets: A Generalized Method of Moments Approach
The study focuses on checking the effect of Leverage Risk, Credit Risk, Implicit Interest Payment, Non-Interest Bearing Reserve and Management Efficiency on Net Interest Margin of the banks of Pakistan, India and Banglad...
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...
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...
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...