個案總覽

Spreadsheet for case W14258.

Spreadsheet for KEL913.

After a period of poor stock-market performance, conglomerate Chestnut Foods (Chestnut) faces the acquisition of its stock by an activist investor. The new investor demands the sale of Chestnut's high-growth division, which contrasts with the CFO's turnaround plan to expand this same division. To disentangle the way forward for Chestnut, students are invited to grapple with the risk-adjusted performance of each division and the estimation of division-specific hurdle rates. Students learn to appreciate the importance of using risk-adjusted hurdle rates in establishing appropriate investment policy.

Spreadsheet supplement for teaching note W15345.

This note is a brief introduction to the logic and practice of using stock options to compensate executives. The Black-Scholes option-pricing model is used to estimate the value of option grants for a company. The note affords the opportunity to apply options valuation in the context of executive compensation, and serves as a companion to introductions to options that expose the reader to the Black-Scholes option-pricing model.

Spreadsheet for KEL904.

Spreadsheet for product 9B15N011.

Arun Kumar, founder and group chief executive officer of Strides Arcolab Limited - a first generation, Indian pharmaceutical company headquartered in Bengaluru - is preparing for a crucial meeting of the Board of Directors. The meeting was called to discuss the proposed dividend payout to the company's shareholders following the completion of a US$1.725 billion sale of its specialty division - Agila Specialties - to the U.S.-based pharmaceutical company Mylan Inc. Kumar proposed that Strides distribute all the free cash available from the sale - after the retirement of debt and internal payouts - in the form of dividends to its shareholders. Strides had already communicated its decision to retire debts and reduce its leverage.

Mission Hospital started its operations on April 02, 2008 with the aim of providing highest quality patient care facilities to all individuals at affordable rates. This super specialty hospital located in Durgapur, West Bengal, India, specializes in cardiac surgeries. Many of its patients are from nearby states and neighboring countries, and are covered under different health schemes. Among hospitals in India, flat rate for different treatments is becoming popular, mainly owing to healthcare tourism and government schemes. Dr. Satyajit Bose, chairman of Mission Hospital, was considering adoption of a package pricing (flat fee) strategy under which patients would be provided a fixed price for their treatment at the time of admission. This would imply that the package price should be calculated by the hospital on the basis of patient's clinical and non-clinical information available at the time of admission. Flat fee (or package pricing) can result in a loss to the hospitals if they do not accurately estimate the treatment cost for a patient. The hospital faces the challenge of identifying the key factors that drive the total cost of treatment so that it can quote an appropriate price to the patient.

Spreadsheet for product 5B15N011.

Spreadsheet supplement for case W15491.

In 2013, the long-delayed IPO of the Bangkok Mass Transit System Public Co. Ltd. (BTSC) took place, but in an unusually complex form. Instead of selling the shares of the company that owned the elevated railway concession, what was offered were investment units in Thailand's first publicly listed infrastructure mutual fund: the BTS Rail Mass Transit Growth Infrastructure Fund (BTSGIF). Proceeds from the IPO were used to acquire from BTSC the rights to the net farebox revenue generated from the railway. The investment exposed investors not only to the operating risk of the railway but to other types such as political risk.

The case discusses the public-private partnership to build the New Royal Adelaide Hospital (NRAH) (replacing the outdated Royal Adelaide Hospital) at a cost of A$1.7 billion in 2009. The 35-year concession was eventually awarded to a consortium, the South Australian Health Partnership (SAHP), and the government agreed to make an annual service payment to the consortium of A$397 million a year once the hospital was completed in 2016. Rising state debt in the wake of the global financial crisis led to protests by opposition politicians when the cost of the NRAH was said to have ballooned.

Student spreadsheet 1 for case SMU288.

Student spreadsheet 2 for case SMU288.

Excel spreadsheet for students.

The systematic analysis of an annual report of a large Canadian public company provides a framework and a set of skills and concepts to determine whether it is worth investing in the company. The detailed examination of the annual report includes an analysis of profitability - including return on capital employed, return on equity, return on sales, gross profit margin and asset turnover - and liquidity measures.

Spreadsheet supplement for case 915501.

Spreadsheet supplement for case 215058.

Spreadsheet supplement for case 215058.