Research Guides: How do I use S&P Capital IQ: Exercises (2024)

Question 1
Industry Intelligence: Find recent deal activity on Asian-Pacific real estate.

  1. Mouse over Markets > Select Analysis under Industries
  2. Click Refine (the one next to Industry) under Market Analysis in the left navigation column
  3. Search forReal Estate, select it and click Submit
  4. Click Refine Geography in the top right corner > Select Asia / Pacific and click Submit
  5. Click M&A/Private Placements and Public Offerings under Transactions in the left navigation column

Question 2
Market Analysis: Find financial ratios in the Airline Industry in the United States.

  1. Click the Markets tab > Select Analysis under Industries
  2. Click Refine (the one next to Industry) under Market Analysis in the left navigation column
  3. Search for Airlines, select it and click Submit
  4. Click Refine Geography in the top right corner > Select United States of America and click Submit
  5. Click Key Stats & Ratios

Question 3
Company Screening: Build a list of private equity firms that prefer to invest in healthcare in Singapore.

  1. Mouse over Screening > Click Companies
  2. Under Company Details, select Investment Type > Select Private Equity Investing > Click Add Criteria
  3. Under Investment Criteria / Private Equity Funds, click Industries of Interest > Select Healthcare > Click Add Criteria
  4. Under Investment Criteria / Private Equity Funds, click Geographies of Interest > Select Singapore > Click Add Criteria
  5. Click View Results

Question 4
Company Screening: Find the latest annual total revenue and total assets of companies listed on the Hong Kong Stock Exchange.

  1. Mouse over Screening > Click Companies
  2. Under Equity Details, select Exchanges > Select (SEHK) The Stock Exchange of Hong Kong Ltd. > Click Add Criteria, then click View Results
  3. On the Screening Results page, click the Add/Edit Display Columns button
  4. Search and select Total Revenue (Latest Annual) > Click Add to Screen
  5. Search and select Total Assets (Latest Annual) > Click Add to Screen
  6. Click Update Results

Question 5
Comparable Company Analysis: Compare financial performance of Singapore Airlines, Cathay Pacific Airways, and Tiger Airways.

  1. Mouse over Screening > Click Create – Companies under Comparable Analysis
  2. Give your comparable set a name and click Save
  3. Next to Search by, click Search > Search Singapore Airlines and select it (Do the same for the other 2 airlines companies)
  4. Select Singapore Airlines in the Set Subject Company drop down menu
  5. Click Add to Comps to view analysis

As an industry expert with a deep understanding of financial markets, business intelligence, and data analysis, I have a proven track record of navigating complex datasets and providing valuable insights. My expertise spans various sectors, including real estate, airlines, private equity, and stock exchanges. I leverage my analytical skills to extract meaningful information and make informed decisions.

Now, let's delve into the specific concepts and steps outlined in the article:

Question 1: Industry Intelligence on Asian-Pacific Real Estate

  • Navigation: The article instructs to go to "Markets" and select "Analysis" under "Industries."
  • Refinement: Under "Market Analysis" in the left navigation column, refine the search by selecting "Real Estate" and clicking "Submit."
  • Geographical Focus: Click "Refine Geography" in the top right corner, select "Asia / Pacific," and click "Submit."
  • Transaction Type: Further narrow down by selecting "M&A/Private Placements and Public Offerings" under "Transactions."

Question 2: Market Analysis in the U.S. Airline Industry

  • Navigation: Go to the "Markets" tab and choose "Analysis" under "Industries."
  • Industry Selection: Under "Market Analysis" in the left navigation column, refine the search for "Airlines" and click "Submit."
  • Geographical Focus: Click "Refine Geography" in the top right corner, select "United States of America," and click "Submit."
  • Financial Ratios: Finally, click on "Key Stats & Ratios" to find the relevant financial ratios.

Question 3: Private Equity Firms Investing in Healthcare in Singapore

  • Navigation: Mouse over to "Screening" and click on "Companies."
  • Investment Type: Select "Private Equity Investing" under "Company Details."
  • Industry Focus: Under "Investment Criteria / Private Equity Funds," choose "Healthcare."
  • Geographical Preference: Further refine by selecting "Singapore" under "Geographies of Interest."

Question 4: Total Revenue and Total Assets of Companies on the Hong Kong Stock Exchange

  • Navigation: Go to "Screening" and click on "Companies."
  • Exchange Selection: Under "Equity Details," choose "(SEHK) The Stock Exchange of Hong Kong Ltd."
  • Display Criteria: Add "Total Revenue (Latest Annual)" and "Total Assets (Latest Annual)" to the display columns.
  • Results Update: Click "Update Results" to view the latest annual total revenue and total assets.

Question 5: Comparable Company Analysis of Singapore Airlines, Cathay Pacific Airways, and Tiger Airways

  • Navigation: Mouse over to "Screening" and click on "Create – Companies" under "Comparable Analysis."
  • Set Creation: Give your comparable set a name and save it.
  • Company Selection: Search for and select Singapore Airlines, Cathay Pacific Airways, and Tiger Airways.
  • Subject Company: Choose Singapore Airlines as the subject company.
  • Analysis View: Click "Add to Comps" to view the comparative analysis.

By following these steps, you'll be able to gather comprehensive information on recent deal activity, financial ratios, preferred private equity firms, and financial performance comparisons in the specified industries and regions.

Research Guides: How do I use S&P Capital IQ: Exercises (2024)
Top Articles
Latest Posts
Article information

Author: Foster Heidenreich CPA

Last Updated:

Views: 5798

Rating: 4.6 / 5 (56 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Foster Heidenreich CPA

Birthday: 1995-01-14

Address: 55021 Usha Garden, North Larisa, DE 19209

Phone: +6812240846623

Job: Corporate Healthcare Strategist

Hobby: Singing, Listening to music, Rafting, LARPing, Gardening, Quilting, Rappelling

Introduction: My name is Foster Heidenreich CPA, I am a delightful, quaint, glorious, quaint, faithful, enchanting, fine person who loves writing and wants to share my knowledge and understanding with you.