What is Gvkey in Compustat?
Table of Contents
What is Gvkey in Compustat?
GVKEY (Global Company Key) is a unique number assigned to each company in the Compustat-Capital IQ database.
How do you calculate ROA on Compustat?
Return on Assets Return on Assets is Income Before Extraordinary Items – Available for Common, divided by Total Assets, which is defined as the sum of current assets, net property, plant, and equipment, and other noncurrent assets. This is then multiplied by 100.
What is CRSP and Compustat?
The CRSP/Compustat Merged Database is a CRSP product that contains Compustat data items. The database is structured so that Compustat items can be accessed using CRSP’s PERMNO/PERMCO identifiers and Compustat’s GVKEY identifiers.
How do I find my CUSIP number on Capital IQ?
Capital IQ:
- To search by CUSIP, enter the CUSIP in the search box.
- To locate CUSIP, enter the company name in the search box. Then, on the company’s page, click Equity Listings on the left menu. On the Equity Listings page, click the ticker that is bold.
How is Tobins Q Compustat calculated?
6 This calculation for Tobin’s q in terms of fields from COMPUSTAT = ((PRCC_F * CSHO) + AT – CEQ ) / AT. on the historical location of the firm’s corporate headquarters. Compustat’s historical files provide information on firms’ historical locations required for this variable.
What is market value of equity in Compustat?
ME. Market Equity. Market equity (size) is price times shares outstanding. Price is from CRSP, shares outstanding are from Compustat (if available) or CRSP.
How do I access Compustat?
Follow these steps:
- Go to WRDS.
- Select “account request”
- Select “request a user account”
- Select the appropriate “account type”
- Fill out and submit the form.
- You will receive an email after your request is approved with login instructions.
How do you read a Cusip number?
A CUSIP number is similar to a serial number. The first six alphanumeric characters are known as the base, or CUSIP-6, and identify the issuer. The seventh and eighth digits identify the type of security and the ninth digit is a “check digit” that is automatically generated.
How do I find my cap IQ identifier?
Go to the S&P Capital IQ tab at the top of the screen and open up the “Templates” tab under the “Data” category. Go to SPCIQ Excel Plug-In Tools and open the SPCIQ Identifier Converter. This should help explain the ID conversion process.
What is the formula for leverage?
Leverage = total company debt/shareholder’s equity. Total debt = short-term debt plus long-term debt. Count up the company’s total shareholder equity (i.e., multiplying the number of outstanding company shares by the company’s stock price.)
How do you calculate book value of equity?
For example, let’s suppose that a company has a total asset balance of $60mm and total liabilities of $40mm. The book value of equity will be calculated by subtracting the $40mm in liabilities from the $60mm in assets, or $20mm.
How do I get financial data from Compustat?
Company Fundamentals or Financials Download from Compustat
- Connect to Compustat – see WRDS access help.
- Under Subscriptions, select Compustat – Capital IQ.
- Under Compustat, select North America – Daily (or Global – Daily).
- Select Fundamentals Quarterly (for quarterly data) or Fundamentals Annual (for annual data).*
How do I use Compustat data?
- Navigate to Compustat. Go to Capital IQ under Subscriptions on the home page.
- Enter the Date Range. Choose either Fiscal Year or Data Date from the drop down.
- Enter the Companies.
- Select the Variables.
- Add Conditional Statement (Optional)
- Select Query Output.
- Submit Query.
