個案總覽

Spreadsheet Supplement for case 210022

This case focuses on an opportunity that American Electric Power (AEP) has to invest, with The Nature Conservancy (TNC), in one of the world's first projects for Reducing Emissions from Deforestation and Forest Degradation (REDD). The proposed plan was to protect 812,000 hectares of rich, biologically diverse forest land, known as Bosque Rojo, in central Peru. This project would address the two issues targeted by REDD by ending both deforestation from the local communities' conversion of land from forest to farmland and forest degradation from commercial logging. REDD projects offered a substantial opportunity to mitigate climate change, as deforestation and forest degradation contributed approximately 15-20 percent of global greenhouse gas (GHG) emissions. Protecting Bosque Rojo could prevent the release of millions of tons of carbon dioxide (CO2). The project partners and investors would obtain certified offset credits equivalent to the reduction in emissions over the 30-year project lifetime. Among U.S. power companies, AEP had one of the highest levels of CO2 emissions. It estimated its 2009 emissions would reach 150M metric tonnes. With climate change legislation on the horizon, it wanted to set an example for Congress to show that REDD offsets could lead to cost-effective reduction in GHG emissions, and also gain experience in the international REDD scene. AEP expected to have to substantially reduce its own emissions (e.g. by substituting wind power for coal in electricity generation) or obtain offset credits either on the open market or through direct participation in external emission reduction projects. AEP believed that REDD projects would be much cheaper than any of its other options to obtain offset credits. To confirm this belief, the company needed to calculate a net present value (NPV) for the project, understand the project's risks, and determine if Bosque Rojo was, indeed, the best use of company funds.

The case briefly describes the history of Electronic Data Systems (EDS) under Ross Perot and GM before turning to the beginning of a tumultuous decade in the late 1990s. As the turn of the century approached, EDS made critical strategic missteps such as missing opportunities in the Internet space, overlooking the onset of client-server computing, and failing to obtain major Y2K-related projects. The company attempted a turnaround by replacing the CEO with Dick Brown, whose leadership helped streamline the sprawling company. Despite initial successes, Brown's tenure ultimately ended in failure, due largely to his failure to recognize the growing Indian market and his willingness to buy business at the expense of the company's margin. The disastrous multibillion-dollar Navy & Marine Corp Intranet contract typified the type of high-profile transactions that Brown pursued, often boosting EDS's stock price in the short term while eroding its cash flow short term and its profitability over the long term. EDS management went through several stages of the turnaround process: the blinded phase, the inactive phase, and the faulty action phase, until Michael Jordan replaced Brown as CEO and enacted a three-tiered operational, strategic, and financial turnaround.

Students must determine whether or not Visa, which had an IPO one month prior, is a good investment. The case provides an overview of multisided platform businesses and the payments industry in general. Visa's business model and economics are reviewed.

Spreadsheet Supplement for INS125

This Excel worksheet contains sample problems, prebuilt Excel models to run breakeven analyses, and charts and graphs which help visualize the results. It is designed to accompany "Marketing Analysis Toolkit: Breakeven Analysis."

This Excel worksheet contains sample problems, prebuilt Excel models to run market sizing and market share analyses, and charts and graphs which help visualize the results. It is designed to accompany Marketing Analysis Tookit: Market Size and Market Share Analysis. The toolkit enables students to size a market and generate a sales forecast using a market build-up methodology. Students measure market demand and company demand and calculate market and product penetration rates and merket share.

Spreadsheet Supplement for case 299034

This Excel model is used to analyze the deals made in The Real Property Negotiation Game, which simulates the experience negotiating the sale, purchase, or financing of a property.

Spreadsheet for 3214

Spreadsheet for teaching note 8B09A27.

Spreadsheet Supplement for NA0025.

Spreadsheet supplement to case UV4312.

Excel spreadsheet for students.

Student Spreadsheet for 4065.

The protagonist in this case is an analyst attempting to value Netflix, Inc., and check whether her recent buy recommendation at a price of $20.00 per share was still valid. Recent bad news had caused the price to drop and she needed to do her best to figure out what was the future for Netflix, and was it undervalued at $17 per share? Intended for MBA students, this case contains her discounted cash flow valuation and a set of assumptions (revenues per customer, retention rates, etc.) students can use to perform a valuation of the existing Netflix customer base as another approach toward judging the $17 stock price. There are two student spreadsheets available for this case (UV4342 and UV4343).

This case examines the April 2009 decision of Rosetta Stone management to price the initial public offering of Rosetta Stone stock during one of the most difficult periods in capital-raising history. The case outlines Rosetta Stone's unique language learning strategy and the associated strong financial performance. Students are invited to value the stock and take a position on whether the current $15 to $17 per share filing range is appropriate. The case is designed to showcase corporate valuation using discounted cash flow and peer-company market multiples. The epilogue details the 40% first-day rise in Rosetta Stone stock from the $18 offer price. With such a backdrop, students are exposed to one of the well-known finance anomalies-the IPO underpricing phenomenon-and are invited to critically discuss various proposed explanations.

Spreadsheet supplement for case UV3928.

Spreadsheet supplement for case 910410.

Spreadsheet Supplement for UV5144.