Home > Business Databases > Capital IQ Common pitfalls and webinars

Capital IQ Common pitfalls and webinars

Capital IQ webinars listS&P Capital IQ provides regular training webinars which are free to join. Simply log into Capital IQ in the usual manner and go to the Help link at the top-right.

There is also a video archive of all the past topics you can choose from. These include:

  • 5 Common Pitfalls to Avoid in Screening
  • Assessing Counterparty Credit Risk
  • Corporate Valuations Series
  • New Portfolio Templates
  • Value Investing Using S&P Capital IQ
  • Excel Trilogy: Basic/Intermediate/Advanced

Capital IQ webinar Java warningYou will need to have Java installed, and to allow it to run, and to accept the warning messages.

It should work on Windows and Mac OS in any modern web browser, but please leave a comment below if you find otherwise.

Please enter your University email address and your name when accessing these resources. Remember we only have an extended trial subscription for Capital IQ here at The University of Manchester Library so only one person can use it at a time.

The most recent webinar was titled “5 Common Pitfalls to Avoid in Screening” and we shall look at the first example from it.

Linking criteria and identifying a company as public on a given date in history

Capital IQ screening (linking)

In this example we want to screen for a list of public materials companies that closed an M&A deal in the last 12 months with total revenue greater than US$1,000,000,000 one day prior to the closure of the deal.

  1. Begin by choosing the Screening tab in the menu bar and clicking on Companies.
  2. The first criteria must return no more than 1,000,000 results. From the first column, choose Company Details > Industry Classifications and click on Materials, then Add Criteria.
  3. From the last column, choose M&A Details > Dates then in the list choose Closed Date, with the Time Frame: Last 12 Months. This metric refers to a transaction, not to a company, but we can still use it for screening. Click Add Criteria.
  4. We now want to identify the company as a public company. It might be tempting to go for Company Details > Company Type: Public Company, but that would apply to the status today, not on the date of the transaction. To get the status on the date of the transaction, you need a metric relating to the Transaction (about the target company).So again from the last column, choose M&A Details > Valuations and in the list choose Pre-Deal Share Performance with the Data Point: Target Market Cap 1-Day Prior  and the Value: Greater Than 0. This means the company was publicly listed. Ensure that Target/Issuer is displayed in the box below, and choose Type: AND from the radio buttons at the bottom. Click Add Criteria.Why Type: AND instead of Type: New (the default)? Because this criteria is part of a Transaction detail, and we are in Company Screening, we need to combine all the Transactions criteria together, using logical AND. It is a bit confusing, as all the criteria are combined with AND rather than OR, but it is essential when linking these types of screenings.
  5. Finally, to limit to target companies with Total Revenue greater than $1 billion at the time of the deal and not at the present day, choose from the last column M&A Details > Valuations then from the list Target/Issuer LTM Financials (at Announcement) with the Data Point: Total Revenue, Value: Greater Than 1000 (the units are millions of US Dollars). Again, ensure Target/Issuer is displayed below this and choose Type: AND to link it to the Transaction criteria. Click Add Criteria, then View Results.

The most important thing to take away from this is to consider using Pre-Deal Share Performance with the Data Point: Target Market Cap 1-Day Prior and the Value: Greater Than 0 to identify a company as public from a transaction, using the Type: AND operator after choosing a deal date.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.