How do I use S&P Capital IQ: Exercises

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 for Real 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