>
Fa   |   Ar   |   En
   Creating Optimal Portfolio and the Efficient Frontier Using Microsoft Excel®  
   
نویسنده Roychoudhury Saurav
منبع Journal Of Quantitative Methods - 2018 - دوره : 2 - شماره : 2 - صفحه:104 -136
چکیده    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®.
کلیدواژه Optimal Portfolio ,Efficient Frontier ,Risk ,ExpectedReturn And Risk-Free Asset
آدرس Capital University, Department Of Business, Usa
پست الکترونیکی sroychou@capital.edu
 
     
   
Authors
  
 
 

Copyright 2023
Islamic World Science Citation Center
All Rights Reserved