您選擇的商品

Queenie's Quandary: A Quest for a Perfect Portfolio

Saurin Patel, Shubh Patel

商品編號:W37576
出版日期:2024/10/07
再版日期:2024/04/10
商品來源:
商品主題:Finance; Economics & Public Policy
商品類型:
涵蓋議題:Markowitz Optimal Portfolio Construction;Modern Portfolio Theory;MS Solver;Investments
難易度:4 - Undergraduate/MBA
內容長度:4 頁
地域:Australia; Canada; India; United Kingdom; United States
產業:Finance and Insurance
事件年度:2024

Queenie Stone started her career as an asset manager for a large investment bank in New York City. Her manager tasked her with creating a new three-stock portfolio and investigating how changes in her inputs of expected returns, standard deviations, and correlations would impact her portfolio asset weights. The stocks included the Procter and & Gamble Company (PG), JP Morgan & Chase & Co. (JPM), and Advanced Micro Devices, Inc. (AMD). Queenie created an equally weighted portfolio as a base case to compare with Markowitz’s optimal portfolio construction methodology, based on modern portfolio theory. Using Queenie’s equally weighted model with the necessary formulas, students use Excel’s Solver tool to find the optimal portfolio allocations among these stocks.

教學手冊:Queenie's Quandary: A Quest for a Perfect Portfolio - Teaching Note
補充材料: