Create Your Own Industry-Specific League Tables

The Lippincott Library has several great resources for finding league tables. However, the majority of these pre-populated league tables are typically geared towards specific geographies and companies rather than industry-specific information. What happens if you would like to look at a league table for a specific industry? You are going to have to construct your own. Fortunately, we have a resource that will enable you to do just that. Continue reading

A League Table of Your Own

A League Table is a list of entities such as companies, teams, or individuals, ranked in order of achievement. In business, league tables most often refer to a list of investment banks ranked on the volume or value of such transactions as IPO’s or M&A deals. There are a very large number of combinations of league table variables (e.g. types of issues, country, time periods and currency). Here are descriptions of three financial databases that can help you construct a league table that fits your criteria.

(1) Bloomberg (available in Lippincott Library and Huntsman Hall)

Type LEAG and hit the green GO key.

The screen below is a list of investment banks ranked by amount of U.S. Bonds underwritten in 2013.

Bloomberg league default ok

There are many customization options. Click on:

  • Year (to choose dates from 1999 on)
  • Period (to choose year, half year or quarter)
  • Select a Market (to choose among markets for Debt, Equity, Structured Notes, and Syndicated Loans). You can also choose “custom markets” which will enable you to create a table based on detailed security, issuance and issuer data
  • Related Functions (to choose among league tables for M&A, Legal Advisors, Clean Energy, Muni League, and to create a matrix table)
  • View Ranks (to view a five year history and a detailed description of the table criteria)

Bloomberg also has hundreds of pre-formatted league tables with accompanying analysis. For a listing of these, type:

NI LEAG CRL and hit GO. Continue reading

Zephyr: Making M&A Searching a Breeze

Zephyr is a database describing worldwide Merger and Acquisition (M&A),  IPO, and Private Equity deals. Currently the file contains more than 1.1 million completed, announced and rumored deals.

A typical M&A search combines variables for geography, time period, deal type, and deal value. Creating customized reports for such deals is easy on Zephyr.

In the following example, we are searching for the largest 50 (ranked by value of deal) M&A acquisitions completed by public U.S. companies in the past 5 years.

Zephyr1

Clicking on the circled items will show menus with additional details. For example, the menu for “Deal Type” will display scores of options for deal types, sub-deal types, methods of payment, and financing.

Here are the variables chosen for our example:

Company Status => Listed or Delisted
Deal Type => Acquisition
Deal Status=> Completed
Geography => USA
Time Period => Last 5 years
Deal Value => Largest 50 Continue reading