Company Information: IPO - Initial Public Offerings

Zephyr

Content: 
Zephyr contains information and data on mergers and acquisitions, IPOs, private equity, and venture capital deals. The database contains information on completed, pending, withdrawn, announced, and rumoured deals. 
Coverage:
European deals from 1997 and forward; global deals from 2001 and forward.
Additional features include news, ranking, and tables about M&A activities.
 

Requesting data.

1. Create your search query by applying filters to all deals in Zephyr. For example, you might be interested in deals in a specific period, country, size, or industry.
2. Select the IPOs & Capital markets tab > Deal Types > choose among more "IPO types"
   
   
   
   
    
3. Create your report by getting information on the selected deals or the company involved.
4. Export your report.

To search in more details

Setting the criteria:
We are interested in completed IPOs between January 1, 2000 and December 31, 2022 of European companies.

• Although it is possible to find IPOs from the All deals section, an easier approach would be to start our search from the IPOs & Capital markets section. This section is available just above the box in which the criteria stand. In this section we will find all criteria related to equity offerings. The definition of an IPO in Zephyr states that the stocks of the company going public should already have started trading. Therefore, all IPO deals are automatically completed.
• To add the first criterion, click on ‘Deal types’. Now unfold the folder IPO and select ‘initial public offering’. Click on ‘OK’ in the lower right corner to be redirected to the previous page. The criterion has been added to our search strategy.
• For the next criterion click on ‘Time Period’. Here we can choose between a relative/absolute date range from the dropdown menu or we can set our own custom date range. Often, we will prefer the latter. Click on the ‘selection circle’ and type in 01/01/2000 and 01/01/2023. To get only completed deals select ‘Completed’ and ‘Completed-assumed’. While this did not matter for the selection of IPOs it does matter for the time period. For example, if a rumor of an IPO started in 2014, but it was actually completed in 2015 we do not want to include this deal in our sample. Then click on ‘OK’.
• The final step is to click on ‘Target Geography’ and on ‘Country’ and select the Western Europe. In an IPO the target refers to the company going public. Click on ‘OK’

Creating the report.
It is possible to specify the information to be downloaded on the deals or companies involved. Click on “Add” or “List format”.

• The left part of the screen contains some predefined lists or allows to upload a list that is created earlier. For more information see Saving and Uploading below.
• The middle part contains all variables available in Zephyr. This part is subdivided into a Deal, Company, and Advisor section. It is possible to search for the variables by going through the separate sections and folders or by using the search box at the bottom of the middle part. The selected variables appear at the right-hand section. When chosen all the variables, click on ‘OK’. Do note that some variable definitions are slightly different for IPOs than for M&A deals.
• Note! Zephyr does offer some information on the deal such as the deal value and sometimes offer price. However, it is best to collect additional stock price information from other databases such as Bloomberg or Datastream. Therefore, make sure to include the ISIN code. Standard financials can be downloaded directly from Zephyr under Companies. However more specific items should be collected from databases such as Orbis, Bloomberg or Datastream. Such as items from the balance sheet, profit & loss account, or cash flow statement
• Some variables contain more than one value. For example, the sub deal-type could contain multiple values. If that is the case Zephyr will show a pop-up menu called ‘Repeatable field’. Choose whether you want to include all values or only the first value.

Exporting the report.

• Click on ‘export’.
• Next choose your format. Give the file a name and click on ‘OK’.
• Note: When exporting the reports, one can encounter two types of limitations: - limitation in the format that is being used. For example .xlsx can only hold 1,048,576 rows. This means that the number of deals should be less when using this format (without accounting for the possible multiple lines for one deal). - limitation in the amount of data that can be exported. The only way to work around this issue is by splitting the report into several parts. For example, choose to download the deals by country instead of for a whole region or split the report by deal and company variables. Saving and Uploading. In Zephyr you can save your search strategy to your drive. Click on ‘save’ above the search strategy. In the pop-up menu enter a name for the strategy and click on ‘save’ to the left. This will allow you to download the search strategy to your drive. To load your search strategy, go to ‘Saved searches’ and click on ‘Load from disk’