個案總覽

Instructor spreadsheet to accompany product W37475.

Spreadsheet to accompany product W31083.

Spreadsheet to accompany product W31084.

In January 2021, Indigo Paints Limited launched an initial public offering of ordinary equity shares to list the company on a stock exchange. It was one of the most subscribed public offers in recent times in India. The company was in the business of manufacturing and selling decorative paints. A retail investor from Mumbai, India received an allotment of Indigo shares and wondered if the grey market premium indicated a fair value for the stock. He understood that initial public offerings were generally underpriced, but wondered what the company's intrinsic value actually was. He sought input from his friend, who was an independent financial advisor, to help him understand the value proposition that the initial public offering would bring to Indigo Paints Limited. The two friends consulted all relevant financial statements and began their calculations.

Spreadsheet Supplement for Exercise W31083