{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":135,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":80,"n_cols":3,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,1,3,9]]}
[]
[null,"Once you are logged in to the WRDS website, and are prepared to mine data from COMPUSTAT's Fundamental's Annual site, complete the following items. They can all be found on the Fundamentals Annual site."]
[]
[]
[]
[1,"What date range do you want to use?"]
[null,null,"Select 5 fiscal years of data, depending on your company's fiscal year-end"]
[2,"What format are your company codes?"]
[null,null,"TIC"]
[3,"Company Code"]
[null,null,"Stock Ticker (e.g. IBM, BLK, BX, MS, MSFT, etc.)"]
[4,"Select Variable Types"]
[null,null,"Data Items"]
[5,"Identifying Information"]
[null,null,"Company Name"]
[null,null,"Ticker Symbol"]
[null,null,"Fiscal Year-End"]
[6,"Identifying Information, cont."]
[null,null,"SIC - Standard Industry Classification Code"]
[7,"Balance Sheet Items"]
[null,null,"ACT -- Current Assets - Total"]
[null,null,"AT -- Assets - Total"]
[null,null,"CEQ -- Common/Ordinary Equity - Total"]
[null,null,"CHE -- Cash and Short-Term Investments"]
[null,null,"INVT -- Invetories - Total"]
[null,null,"LCT -- Current Liabilities - Total"]
[null,null,"LT -- Liabilities - Total"]
[null,null,"PPENT -- Property, Plant, and Equipment - Total (Net)"]
[null,null,"RECT -- Receivables Total"]
[null,null,"SEQ -- Stockholders' Equity - Total"]
[8,"Income Statement Items"]
[null,null,"COGS -- Cost of Goods Sold"]
[null,null,"EPSPX -- Earnings Per Share (Basic) Excluding Extraordinary Items"]
[null,null,"NI -- Net Income (Loss)"]
[null,null,"OIADP -- Operating Income After Depreciation"]
[null,null,"SALE -- Sales/Turnover (Net)"]
[null,null,"XINT -- Interest and Related Expense - Total"]
[9,"Cash Flow Items"]
[null,null,"AQC -- Acquisitions"]
[null,null,"CAPX -- Capital Expenditures"]
[null,null,"DLTR -- Long-Term Debt Reduction"]
[null,null,"DV -- Cash Dividends (Cash Flow)"]
[null,null,"INTPN -- Interest Paid Net"]
[null,null,"OANCF -- Operating Activities Net Cash Flow"]
[null,null,"TXPD -- Income Taxes Paid"]
[10,"Miscellaneous"]
[null,null,"CSHO -- Common Shares Outstanding"]
[null,null,"CSHPRI -- Common Shares Used to Calculate Earnings Per Share"]
[11,"Supplemental Data Items"]
[null,null,"PRCC_F -- Price Close - Annual - Fiscal"]
[12,"How would you like the query output?"]
[null,null,"comma-delimited text (*.csv)"]
[13,"Submit Query"]
[]
[14,"Click on the \".csv\" link in the new tab to download the data, yo"]
[]
[15,"Once you have the spreadsheet downloaded, move the worksheet into this workbook"]
[null,null,"Right click on the tab at the bottom of the downloaded worksheet screen and select \"Move or Copy\""]
[null,null,"Select the first drop-down box and select 'Financial Statement Ratio Builder'"]
[null,null,"Under the \"Before sheet:\" drop-down box, select '(move to end)'"]
[]
[16,"Select any cell in the downloaded data worksheet, and run the Get_Company_Ratios macro"]
[null,null,"On the worksheet ribbon (top of page), select the Developer tab"]
[null,null,"Select the Macros button and choose \"Get_Company_Ratios\""]
[]
[null,"Good Job! Now you're ready to calculate the industry ratios"]
[]
[17,"Because you already selected that accounts you want analyzed, all you have to do to obtain the industry information is change company code format"]
[null,null,"Change format code from TIC to SIC "]
[null,null,"The SIC code is found in the column AN of the your Data sheet"]
[18,"Submit Query"]
[]
[19,"Once you have the spreadsheet downloaded, move the worksheet into this workbook"]
[null,null,"Right click on the tab at the bottom of the downloaded worksheet screen and select \"Move or Copy\""]
[null,null,"Select the first drop-down box and select 'Financial Statement Ratio Builder'"]
[null,null,"Under the \"Before sheet:\" drop-down box, select '(move to end)'"]
[]
[20,"Select any cell in the downloaded data worksheet, and run the Get_Industry_Ratios macro"]
[null,null,"On the worksheet ribbon (top of page), select the Developer tab"]
[null,null,"Select the Macros button and choose \"Get_Industry_Ratios\""]