個案總覽

Spreadsheet to accompany product 9B16E029.

In November 2014, the founder and chief executive officer of HomeZilla, in Toronto, Canada, was considering how to provide value-added services to his business. One of the company’s main services was to work with real estate agents to provide web listings to attract home shoppers. Many Internet companies were analyzing web-browsing data in an effort to better understand user behaviour and thus improve their business. Inspired by this trend, the founder considered how his company could use web-browsing data to better attract home shoppers on the company’s website and thereby add value to his business.

In November 2014, the founder and chief executive officer of HomeZilla, in Toronto, Canada, was considering how to provide value-added services to his business. One of the company's main services was to work with real estate agents to provide web listings to attract home shoppers. Many Internet companies were analyzing web-browsing data in an effort to better understand user behaviour and thus improve their business. Inspired by this trend, the founder considered how his company could use web-browsing data to better attract home shoppers on the company's website and thereby add value to his business.

Student spreadsheet for case W16002.

Instructor Spreadsheet to accompany product 8B16E023.

Spreadsheet to accompany product # 9B16E023.

On February 29, 2016, an investor, who was a business school graduate, purchased one share of Tesla Motors, Inc. stock for $191.93. In doing so, the investor wondered what trading strategy should be followed over the next six months to maximize returns while minimizing risk. In choosing a strategy, he wanted to make good use of the knowledge gained from his financial analytics classes. To that end, he did not know if he should choose a buy and hold, or a stop-loss strategy with an optimal stop-loss threshold. The investor wondered how he would make this decision. Would a six month comparison of the stop-loss strategy with thresholds from 1 per cent to 99 per cent versus the buy and hold strategy resolve his dilemma?

On February 29, 2016, an investor, who was a business school graduate, purchased one share of Tesla Motors, Inc. stock for $191.93. In doing so, the investor wondered what trading strategy should be followed over the next six months to maximize returns while minimizing risk. In choosing a strategy, he wanted to make good use of the knowledge gained from his financial analytics classes. To that end, he did not know if he should choose a buy and hold, or a stop-loss strategy with an optimal stop-loss threshold. The investor wondered how he would make this decision. Would a six month comparison of the stop-loss strategy with thresholds from 1 per cent to 99 per cent versus the buy and hold strategy resolve his dilemma?

Student spreadsheet for case W16434.