Capital IQ

Definition:

Capital IQ is a financial information repository sponsored by S&P to gather information on companies, industries, markets, etc.

  • What it is: Capital IQ collects, scrubs, interprets, and analyzes public data, aggregating over 135 billion data points a year to become a leading provider of research in the financial services sector. These data points consist of financial news, market and sector-specific insights, and company performance. It is widely used by investment bankers, stock traders, hedge and mutual funds, private equity, M&A searchers, etc. It organizes historical information on companies, markets, transactions, and people worldwide, providing clients with the data necessary to analyze company fundamentals, build financial models, screen for investment ideas, and execute other financial research tasks.
  • What does it do: Provides the financial and industry information about companies to allow investors and business leaders to make informed investment, M&A, and business decisions.

Uses:

Limitations:

  • Where it shouldn't be used: Capital IQ is an expensive paid service and should not be used by companies and organizations which have limited need for that type of information. It would be in their best interest to contact a consulting firm experience in its use to gather and display the needed information for the infrequent use situations.
  • Any restrictions: Paid Service
  • Warnings: Sophisticated analysis can be misused by inexperienced and untrained analysts. Be sure that someone trained in science and art is involved in the analysis using Capital IQ or other sophisticated financial search engines.

Demonstrations:

Introduction to S&P Capital IQ 

Install Capital IQ Plug-In for Excel

Capital IQ Financial Statement and Stock Price Downloads

Using the screening tool on Capital IQ

Event Study Using Excel and Capital IQ

Step-by-step process:

  • Get Training from one of the many sources of the above videos or a quick start outline like the following link: Capital IQ Quick Start Guide
  • Gather the required data: There is a variety of data available, some of the main categories include
    • Financials
    • Key Statistics
    • Public Filings
    • Transaction History
    • Trends
    • Transactions
    • Key Companies
    • Public Comparables Analysis
    • Present Transaction Analysis
    • Investment Opportunities
    • Partner Opportunities
    • Company
    • Industry
    • Screening
  • Utilize the screening, charting and the excel plugins for analysis
  • Interpretation of results is done with practice, training, and developed expertise

Template for capturing data:

 Templates are built into the Capital IQ system

Output representation and recommendations:

There are a variety of output representations that will support the recommendations from the Capital IQ analysis. Look for output tables, charts, graphs, and representations built into Capital IQ.

This content is provided to you freely by Ensign College.

Access it online or download it at https://ensign.edtechbooks.org/projectbasedinternship/capital_iq.