學門類別
政大
哈佛
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- Snapchat’s Dilemma: Growth or Financial Sustainability
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Did I Just Cross the Line and Harass a Colleague?
- TNT Assignment: Financial Ratio Code Cracker
- Porsche Drive (A): Vehicle Subscription Strategy
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
-
Queenie's Quandary: A Quest for a Perfect Portfolio
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 - Student Spreadsheet
Spreadsheet to accompany product W37576.