個案總覽

In January 2021, the chief data and analytics officer (CDAO) at Allianz Benelux SA (Allianz) spotted a possible opportunity to optimize cash flow with direct debit. Direct debit was a pre-authorized financial transaction between two parties where the amount due was directly and automatically collected from the payer’s bank account. Direct debit would allow Allianz to shorten payment processes, reduce risks by anticipating payments, and improve customer loyalty. Despite the clear advantages of direct debit for both clients and insurers, only a few of Allianz’s clients were currently making use of direct debit. It was not clear what drove Allianz’s customers or brokers to implement direct debit. This was where the CDAO and his data office team came in. The data office possessed a large amount of data on Allianz’s property and casualty insurance contracts and customers. Now the team needed to investigate how this data could be leveraged to determine the value drivers and develop a strategy to convert more clients to direct debit payments.

Student spreadsheet for W27310.

In January 2021, the chief data and analytics officer (CDAO) at Allianz Benelux SA (Allianz) spotted a possible opportunity to optimize cash flow with direct debit. Direct debit was a pre-authorized financial transaction between two parties where the amount due was directly and automatically collected from the payer's bank account. Direct debit would allow Allianz to shorten payment processes, reduce risks by anticipating payments, and improve customer loyalty. Despite the clear advantages of direct debit for both clients and insurers, only a few of Allianz's clients were currently making use of direct debit. It was not clear what drove Allianz's customers or brokers to implement direct debit. This was where the CDAO and his data office team came in. The data office possessed a large amount of data on Allianz's property and casualty insurance contracts and customers. Now the team needed to investigate how this data could be leveraged to determine the value drivers and develop a strategy to convert more clients to direct debit payments.

Spreadsheet Supplement for Case W27310

In July 2022, a portfolio manager for an investment company was considering adding the Coca-Cola Company (Coca-Cola) stock to its flagship global blend fund, which invested in firms with neither predominant value nor growth characteristics. Her initial task was to develop an investment thesis by first gathering qualitative and quantitative information related to Coca-Cola and its peers. Her thesis would consider what long-term trends might play out in the industry, as well as any short- and medium-term considerations related to the economy, the industry, and Coca-Cola itself. She wondered whether an analysis of recent financial performance coupled with expectations of future performance could provide any clues as to the suitability of current investments. Recognizing that further analysis would follow (such as an in-depth discounted cash flow analysis), the portfolio manager needed to know whether the fund should consider investing in Coca-Cola’s stock based on her preliminary analysis.

Spreadsheet to accompany product W31037.

In July 2022, a portfolio manager for an investment company was considering adding the Coca-Cola Company (Coca-Cola) stock to its flagship global blend fund, which invested in firms with neither predominant value nor growth characteristics. Her initial task was to develop an investment thesis by first gathering qualitative and quantitative information related to Coca-Cola and its peers. Her thesis would consider what long-term trends might play out in the industry, as well as any short- and medium-term considerations related to the economy, the industry, and Coca-Cola itself. She wondered whether an analysis of recent financial performance coupled with expectations of future performance could provide any clues as to the suitability of current investments. Recognizing that further analysis would follow (such as an in-depth discounted cash flow analysis), the portfolio manager needed to know whether the fund should consider investing in Coca-Cola's stock based on her preliminary analysis.

Spreadsheet Supplement for Case W31037

Spreadsheet supplement for case A00426.

Midway through construction, a hotel developer realised that costs had risen too much to be feasible for equity capital. They repositioned the asset as a ResiTel wherein each suite would be sold as a condominium unit to retail buyers. This called for setting up two separate entities: one (PropCo) for asset management and the other (LeaseCo) for operating the hotel. Unit owners would earn a regular share of hotel income. The lenders protected additional sale-risk by more conservative loan terms. The developer must analyse the feasibility of the repositioned asset.

Spreadsheet Supplement for Case HK1401

On April 14, 2022, Elon Musk offered to buy Twitter Inc. for US$54.20 per share, for a total cost of US$44 billion. Musk hoped to make the social media network a platform of free speech, and the company profitable and cash flow-positive far more quickly than its management team at the time. Musk's leveraged buyout was mainly funded by a margin loan backed by his own shares in his company, Tesla Inc. On July 8, 2022, Musk announced that he was backing out of the deal. Almost immediately, a lawsuit was filed to force Musk to close the deal as required by the merger agreement. In response, Musk had to decide whether his bid of US$54.20 per share was still a fair valuation for the purchase, if a leveraged buyout with a margin loan was the best financing plan, and whether to confirm or abandon his agreement to buy Twitter Inc. If he chose to walk away from the deal, he would have to consider the potential loss, depending on the outcome of the pending lawsuit in the Delaware Court of Chancery.

Spreadsheet Supplement for Case W30166