MuleSoft, Inc. conducted its IPO on March 17, 2017, for the principal purposes of increasing its capitalization and financial flexibility, creating a public market for its Class A common stock, and enabling access to the public equity markets for it and its stockholders. MuleSoft sold 13 million shares for an IPO offer price of $17 per share. The underwriting discount was $1.19 per share. MuleSoft intends to use the net proceeds from the offering to the firm for general corporate purposes, such as working capital, operating expenses, and capital expenditures, and to possibly acquire complementary businesses, products, services, or technologies. MuleSoft’s closing stock price was $24.75 after the first day of trading on the NYSE and there were 125,991,577 shares of stock outstanding. Create a spreadsheet to conduct an analysis of MuleSoft’s IPO and determine the following:
a. Calculate the total proceeds for MuleSoft’s IPO.
b. Calculate the percentage underwriter discount for MuleSoft’s IPO.
c. Calculate the dollar amount of the underwriting fee for MuleSoft’s IPO.
d. Calculate the net proceeds for MuleSoft’s IPO.
e. Calculate the percentage IPO underpricing for MuleSoft’s IPO.
f. Calculate the market capitalization for MuleSoft after the first day of trading in the secondary market.