個案總覽

In December 2012, a young worker in Toronto wants to invest $50,000 savings. He needs to decide the equity portfolio that will result in the lowest risk at the best possible return on his investment. In particular, he is looking to invest in Wal-Mart, IBM, Apple, Chevron and Amazon, all large U.S. corporations that have weathered the recent economic crisis and show growth potential for the future. He remembers learning about using efficient frontiers to analyze stocks and decides to undertake an exhaustive analysis before deciding in which company to invest.

Excel spreadsheet for instructors.

Excel spreadsheet for instructors.

Excel spreadsheet for students.

Excel spreadsheet for students.

In December 2012, a young worker in Toronto wants to invest $50,000 savings. He needs to decide the equity portfolio that will result in the lowest risk at the best possible return on his investment. In particular, he is looking to invest in Wal-Mart, IBM, Apple, Chevron and Amazon, all large U.S. corporations that have weathered the recent economic crisis and show growth potential for the future. He remembers learning about using efficient frontiers to analyze stocks and decides to undertake an exhaustive analysis before deciding in which company to invest.