個案總覽

Instacart is an online grocery delivery platform that is seeking to go public through an initial public offering (IPO). Instacart has hired an investment bank to be its lead bookrunner, and the bank is responsible for coming up with an IPO price range. Maya Martinez, an investment banking analyst at the firm, has been tasked with building financial models to come up with an appropriate share range for the firm’s managing directors to present at the IPO roadshow.

Spreadsheet to accompany product W36955.

Spreadsheet to accompany product W36956.

Instacart is an online grocery delivery platform that is seeking to go public through an initial public offering (IPO). Instacart has hired an investment bank to be its lead bookrunner, and the bank is responsible for coming up with an IPO price range. Maya Martinez, an investment banking analyst at the firm, has been tasked with building financial models to come up with an appropriate share range for the firm's managing directors to present at the IPO roadshow.

Spreadsheet supplement for case W36955

Arconic Inc. was an international aluminum parts manufacturing and lightweight composite engineering conglomerate. In early 2019, it was set to be sold to Apollo Global Management Inc., a premier private equity firm; however, the deal fell apart due to a dispute over the valuation of pension obligations. The board of Arconic Inc. still demanded structural changes to maximize shareholder value, and in February 2020, the company engaged Bulge Bracket Bank (Bulge Bracket) to explore other options. The managing director of Bulge Bracket saw that there was a case to be made for spinning off Arconic Inc.’s Global Rolled Products division as a new company, to be called Arconic Corporation. He assigned a promising second-year analyst the task of conducting a comparable companies analysis to determine a fair valuation for Arconic Corporation. By drawing up a list of other companies in the materials industry and conducting a qualitative and quantitative analysis on them to identify comparable companies, the analyst was able to determine a reasonable implied valuation range ahead of the stock market listing of the spun-off company on April 1, 2020.

Spreadsheet to accompany product W32370.

Arconic Inc. was an international aluminum parts manufacturing and lightweight composite engineering conglomerate. In early 2019, it was set to be sold to Apollo Global Management Inc., a premier private equity firm; however, the deal fell apart due to a dispute over the valuation of pension obligations. The board of Arconic Inc. still demanded structural changes to maximize shareholder value, and in February 2020, the company engaged Bulge Bracket Bank (Bulge Bracket) to explore other options. The managing director of Bulge Bracket saw that there was a case to be made for spinning off Arconic Inc.'s Global Rolled Products division as a new company, to be called Arconic Corporation. He assigned a promising second-year analyst the task of conducting a comparable companies analysis to determine a fair valuation for Arconic Corporation. By drawing up a list of other companies in the materials industry and conducting a qualitative and quantitative analysis on them to identify comparable companies, the analyst was able to determine a reasonable implied valuation range ahead of the stock market listing of the spun-off company on April 1, 2020.

Spreadsheet supplement for case W32370