個案總覽

Instructor spreadsheet for product 8B21N006.

Student spreadsheet for product 9B21N006.

In May 2019, a retail investor in the Philippines had to decide whether or not to immediately sell his shares in Holcim Philippines, Inc (HPI). The San Miguel Corporation had just announced the acquisition of around 86 per cent controlling interest in HPI. The price of HPI had increased considerably in the months leading up to the acquisition announcement, and this investor was anticipating a large gain. Now, he needed to run a fair value estimate of HPI’s price using both the capital-asset-pricing-model-based discounted cash flow method and the comparable multiples method in order to decide what to do: Should he sell his shares at the prevailing market price, wait until the future potential tender offer, or hold his shares indefinitely?

In May 2019, a retail investor in the Philippines had to decide whether or not to immediately sell his shares in Holcim Philippines, Inc (HPI). The San Miguel Corporation had just announced the acquisition of around 86 per cent controlling interest in HPI. The price of HPI had increased considerably in the months leading up to the acquisition announcement, and this investor was anticipating a large gain. Now, he needed to run a fair value estimate of HPI's price using both the capital-asset-pricing-model-based discounted cash flow method and the comparable multiples method in order to decide what to do: Should he sell his shares at the prevailing market price, wait until the future potential tender offer, or hold his shares indefinitely?

Spreadsheet supplement for case W21328.