MuleSoft, Inc. conducted its IP on March 17, 2017 for the principle 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 of $17 per share. The underwriting discoung 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, 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,557 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's IPO after the first day of trading in the secondary market.