個案總覽

Excel spreadsheet for students.

The chief financial officer (CFO) of Inmet Mining Corporation is considering the pricing and structure of a $500 million bond offering in late 2012. The company required capital to fully fund construction at its biggest asset, the Cobre Panama copper mine, which had been estimated at $6.2 billion dollars. Now, it was preparing yet another bond offering that would ensure these capital cost requirements would be met. Complicating matters was the fact that a competitor, First Quantum Minerals, had made a $70 per share offer to purchase the company in November 2012. The CFO has to weigh options and structure the bond offering accordingly.

A portfolio manager for Penhall Investment Funds was reviewing the financial data his team had prepared on Lenovo Group Limited (Lenovo), one of the major holdings in Penhall’s Global fund. Lenovo wanted to become more than just the largest manufacturer of PCs by volume. It aimed to become a leader in other devices, such as smartphones and tablets, and it was focusing on innovation as a key capability. The portfolio manager was impressed by Lenovo’s results so far; the stock was up 7.5 per cent in a year. However, given the decline in the traditional PC segment, the competitive nature of the industry and global economic conditions, he wondered if Lenovo should continue to be a key holding in the global fund.

A portfolio manager for Penhall Investment Funds was reviewing the financial data his team had prepared on Lenovo Group Limited (Lenovo), one of the major holdings in Penhall's Global fund. Lenovo wanted to become more than just the largest manufacturer of PCs by volume. It aimed to become a leader in other devices, such as smartphones and tablets, and it was focusing on innovation as a key capability. The portfolio manager was impressed by Lenovo's results so far; the stock was up 7.5 per cent in a year. However, given the decline in the traditional PC segment, the competitive nature of the industry and global economic conditions, he wondered if Lenovo should continue to be a key holding in the global fund.

This note provides an overview of Initial Public Offerings (IPOs) and addresses the methods used to value companies undergoing an IPO. It begins with a brief introduction to IPOs and the rationale behind going public, followed by an analysis of IPOs from the investor's perspective. Next, the IPO process is outlined and explained, including the underwriter choice, selling procedure, pricing and activities in the aftermarket. Lastly, the note examines the valuation methodology used in the pricing stage of IPOs. This includes the discounted cash flow method, the use of market multiples of comparable firms, as well as other situational considerations when determining the initial price per share range and final offering price.

Senior management of a large stock exchange is reviewing a recent software problem that resulted in a botched opening for the initial public offering of a popular social media company. They are drawing up a list of recommendations on how to prevent this type of failure in the future, taking into account the needs of their various stakeholders, including customers, market makers, listed firms, regulators and shareholders. Overviews of the stock market, NASDAQ in particular, and the use of technology to trade stocks securely and quickly are followed by examining the aftermath of a delay in the correct trading of Facebook shares on its opening.

A buy-side analyst for an investment company that has a company-specific, fundamentals-based investing philosophy is considering whether to include a small-cap Canadian company engaged in commodity streaming contracts in the mining sector as a significant investment. The analyst must first learn what commodity streaming involves to better understand whether the company has a viable business model. He also has to research the copper and natural gas industry outlooks. He must then develop a net asset value model to determine an appropriate valuation for the company.

Spreadsheet Supplement for W12453

Senior management of a large stock exchange is reviewing a recent software problem that resulted in a botched opening for the initial public offering of a popular social media company. They are drawing up a list of recommendations on how to prevent this type of failure in the future, taking into account the needs of their various stakeholders, including customers, market makers, listed firms, regulators and shareholders. Overviews of the stock market, NASDAQ in particular, and the use of technology to trade stocks securely and quickly are followed by examining the aftermath of a delay in the correct trading of Facebook shares on its opening.

Excel spreadsheet for students.

It was May 16, 2012, and the highly anticipated pricing of Facebook Inc.'s initial public offering (IPO) was underway. An analyst at CXTechnology Fund was preparing to speak to the lead underwriter about his final interest in the deal. The analyst had reviewed Facebook's phenomenal growth, its profitable business model and the competitive landscape for the social networking industry. The IPO appeared to be oversubscribed with heavy interest from institutional and retail investors alike, but the valuation seemed expensive, even by technology standards. The analyst needed to make a decision on whether to buy shares in the IPO or not. A spreadsheet for students is available, product 7B12N031.

It was May 16, 2012, and the highly anticipated pricing of Facebook Inc.’s initial public offering (IPO) was underway. An analyst at CXTechnology Fund was preparing to speak to the lead underwriter about his final interest in the deal. The analyst had reviewed Facebook’s phenomenal growth, its profitable business model and the competitive landscape for the social networking industry. The IPO appeared to be oversubscribed with heavy interest from institutional and retail investors alike, but the valuation seemed expensive, even by technology standards. The analyst needed to make a decision on whether to buy shares in the IPO or not. A spreadsheet for students is available, product 7B12N031.

Partners in Nunavut Iron Ore Acquisition Inc. (Nunavut), an entity that had been set up to bid for control of Baffinland Iron Mines Corporation (Baffinland), are forced to respond to a rival bid. Baffinland owned the Mary River project, one of the most significant iron ore reserves in Canada, and had been trying to develop the project since 2004, but the number of prospective mining and financing partners declined following the onset of the global financial crisis in 2007. Baffinland’s share price tumbled as a result of its inability to move the project forward, falling from over $4.68 in October 2007 to $0.17 cents in 2008. In September 2010, sensing an opportunity to pick up an asset at a distressed price, Nunavut, backed by a private equity firm in the United States, had sparked a bidding war for Baffinland against ArcelorMittal, a Belgium-based steel company.

Spreadsheet for product 9B10N037.

On April 11, 2011, the merger between Canadian Satellite Radio Holdings Inc. (the parent company of XM Canada) and SIRIUS Canada Inc. received the approval of CRTC (Canadian Radio-television and Telecommunications Commission). This was the last obstacle standing in the way of the president and CEO of the new organization. The president had had plenty of time to prepare for this merger since it was first announced in November of 2010. However, with only a few months before the implementation plan was to go into place, the president was once more reviewing the proposal that he had prepared. The merger of XM Canada and SIRIUS Canada was not going to be easy. Both organizations had been fierce competitors, but it was clear that their survival was dependant on a successful merger. The president’s plan had to consider the make-up of the management team, the consolidated marketing strategy, operations and information systems integration, and how all of this was to be financed.

The chief executive officer (CEO) of Air Canada was reviewing the company's risk management program with the intent to suggest changes to the policy. Risk management was a topic all corporate boards were dedicating time to since the financial collapse of 2008, and boards had come to realize that hard questions needed to be asked about the source of risk, how it was disclosed, how it was to be accounted for and how it was managed. The CEO knew that he needed to consider the impact of his view of the economy, interest rates, exchange rates and the commodity markets on how aggressive Air Canada should be with its appropriate hedges. He decided to start by identifying the most relevant sources of external risk that could materially affect Air Canada's short and long-term financial performance. He then wanted to understand how these risks were managed today and how they compared to West Jet, their main competitor. Finally, he wanted to determine what changes should be made to either eliminate the source of risk or better manage any significant risks that remained.

The chief executive officer (CEO) of Air Canada was reviewing the company's risk management program with the intent to suggest changes to the policy. Risk management was a topic all corporate boards were dedicating time to since the financial collapse of 2008, and boards had come to realize that hard questions needed to be asked about the source of risk, how it was disclosed, how it was to be accounted for and how it was managed. The CEO knew that he needed to consider the impact of his view of the economy, interest rates, exchange rates and the commodity markets on how aggressive Air Canada should be with its appropriate hedges. He decided to start by identifying the most relevant sources of external risk that could materially affect Air Canada's short and long-term financial performance. He then wanted to understand how these risks were managed today and how they compared to West Jet, their main competitor. Finally, he wanted to determine what changes should be made to either eliminate the source of risk or better manage any significant risks that remained.

Spreadsheet for product 9B02N013.

Spreadsheet for product 9B05N009.

Spreadsheet for product 9B04N014.