 Find Information
 Research Guides
 MBA 5133: Financial Accounting Concepts (Linthicum)
MBA 5133: Financial Accounting Concepts (Linthicum)
for MBA 5133 / ACC 5003:
 Getting Started
 Class Page
 Databases for Industry Financial Ratios
 Financial Ratios Industry Level in WRDS
 Web Resources
Step 2: Select your universe
Step 3: Industry Classification Variables

GICS SectorsThe Global Industry Classification Standard (GICS®)

FamaFrench IndustriesWe assign each NYSE, AMEX, and NASDAQ stock to an industry portfolio at the end of June of year t based on its fourdigit SIC code at that time. (We use Compustat SIC codes for the fiscal year ending in calendar year t1. Whenever Compustat SIC codes are not available, we use CRSP SIC codes for June of year t.) We then compute returns from July of t to June of t+1.Detail for FamaFrench 49 Industry Portfolios can be found within a zip file that has been downloaded as below.
WRDS Financial Ratios Manuals and Overviews
What is formula for ratios? Examples:
 Cash Flow Margin = Income before Extraordinary Items and Depreciation as a fraction of Sales (page 4 of 7)
 ShortTerm Debt/Total Debt = Shortterm Debt as a fraction of Total Debt (page 4 of 7)
Financial Ratios Industry Level in WRDS

Financial Ratios Industry Level by WRDS (Beta)Please note: This resource is only available to current UTSA faculty, students, and staff. You must request a WRDS account prior to use.
In Step 4, there are totally 74 variables available, which are grouped into the categories as below:
 Industry Return (this category contains the variable #1 to #3 as listed in the left column of the next table below)
 Valuation Ratios (#416)
 Profitability Ratios(#1731)
 Capitalization Ratios (#3235)
 Financial Soundness (#3651)
 Solvency Ratios (#5257)
 Liquidity Ratios (#5861)
 Efficiency Ratios (#6268)
 Other Ratios (#6972)
 Valuation Ratios (require IBES subscription) (#7274)
Step 4: Select Your Variables:
In Step 4: Select Your Variables:


Select Your Variables  In Which Category 
1. Equal Weighted Industry Return  Industry Return (#13)  
2. Value Weighted Industry Return  Industry Return (#13)  
3. The number of companies that belongs to the industry classification  Industry Return (#13)  
4. Dividend Payout Ratio  Valuation Ratios (#416)  
5. Trailing P/E to Growth (PEG) ratio  Valuation Ratios (#416)  
6. Book/Market  Valuation Ratios (#416)  
7. Shillers Cyclically Adjusted P/E Ratio  Valuation Ratios (#416)  
8. Dividend Yield  Valuation Ratios (#416)  
9. Enterprise Value Multiple  Valuation Ratios (#416)  
10. Price/Cash flow  Valuation Ratios (#416)  
11. P/E (Diluted, Excl. EI)  Valuation Ratios (#416)  
12. P/E (Diluted, Incl. EI)  Valuation Ratios (#416)  
13. Price/Operating Earnings (Basic, Excl. EI)  Valuation Ratios (#416)  
14. Price/Operating Earnings (Diluted, Excl. EI)  Valuation Ratios (#416)  
15. Price/Sales  Valuation Ratios (#416)  
16. Price/Book  Valuation Ratios (#416)  
17. Effective Tax Rate  Profitability Ratios(#1731)  
18. Gross Profit/Total Assets  Profitability Ratios(#1731)  
19. Aftertax Return on Average Common Equity  Profitability Ratios(#1731)  
20. Aftertax Return on Total Stockholders Equity  Profitability Ratios(#1731)  
21. Aftertax Return on Invested Capital  Profitability Ratios(#1731)  
22. Gross Profit Margin  Profitability Ratios(#1731)  
23. Net Profit Margin  Profitability Ratios(#1731)  
24. Operating Profit Margin After Depreciation  Profitability Ratios(#1731)  
25. Operating Profit Margin Before Depreciation  Profitability Ratios(#1731)  
26. Pretax Return on Total Earning Assets  Profitability Ratios(#1731)  
27. Pretax return on Net Operating Assets  Profitability Ratios(#1731)  
28. Pretax Profit Margin  Profitability Ratios(#1731)  
29. Return on Assets  Profitability Ratios(#1731)  
30. Return on Capital Employed  Profitability Ratios(#1731)  
31. Return on Equity  Profitability Ratios(#1731)  
32. Capitalization Ratio  Capitalization Ratios (#3235)  
33. Common Equity/Invested Capital  Capitalization Ratios (#3235)  
34. Longterm Debt/Invested Capital  Capitalization Ratios (#3235)  
35. Total Debt/Invested Capital  Capitalization Ratios (#3235)  
36. Inventory/Current Assets  Financial Soundness (#3651)  
37. Receivables/Current Assets  Financial Soundness (#3651)  
38. Free Cash Flow/Operating Cash Flow  Financial Soundness (#3651)  
39. Operating CF/Current Liabilities  Financial Soundness (#3651)  
40. Cash Flow/Total Debt  Financial Soundness (#3651)  
41. Cash Balance/Total Liabilities  Financial Soundness (#3651)  
42. Cash Flow Margin  Financial Soundness (#3651)  
43. ShortTerm Debt/Total Debt  Financial Soundness (#3651)  
44. Profit Before Depreciation/Current Liabilities  Financial Soundness (#3651)  
45. Current Liabilities/Total Liabilities  Financial Soundness (#3651)  
46. Total Debt/EBITDA  Financial Soundness (#3651)  
47. Longterm Debt/Book Equity  Financial Soundness (#3651)  
48. Interest/Average Longterm Debt  Financial Soundness (#3651)  
49. Interest/Average Total Debt  Financial Soundness (#3651)  
50. Longterm Debt/Total Liabilities  Financial Soundness (#3651)  
51. Total Liabilities/Total Tangible Assets  Financial Soundness (#3651)  
52. Total Debt/Equity  Solvency Ratios (5257)  
53. Total Debt/Total Assets  Solvency Ratios (5257)  
54. Total Debt/Total Assets  Solvency Ratios (5257)  
55. Total Debt/Capital  Solvency Ratios (5257)  
56. Aftertax Interest Coverage  Solvency Ratios (5257)  
57. Interest Coverage Ratio  Solvency Ratios (5257)  
58. Cash Conversion Cycle (Days)  Liquidity Ratios (#5861)  
59. ash Ratio  Liquidity Ratios (#5861)  
60. Current Ratio  Liquidity Ratios (#5861)  
61. Quick Ratio (Acid Test)  Liquidity Ratios (#5861)  
62. Asset Turnover  Efficiency Ratios (#6268)  
63. Inventory Turnover  Efficiency Ratios (#6268)  
64. Payables Turnover  Efficiency Ratios (#6268)  
65. Receivables Turnover  Efficiency Ratios (#6268)  
66. Sales/Stockholders Equity  Efficiency Ratios (#6268)  
67. Sales/Invested Capital  Efficiency Ratios (#6268)  
68. Sales/Working Capital  Efficiency Ratios (#6268)  
69. Accruals/Average Assets  Other Ratios (#6972)  
70. Research and Development/Sales  Other Ratios (#6972)  
71. Avertising Expenses/Sales  Other Ratios (#6972)  
72. Labor Expenses/Sales  Valuation Ratios (require IBES subscription) (#7274)  
73. Forward P/E to 1year Growth (PEG) ratio  Valuation Ratios (require IBES subscription) (#7274)  
74. Forward P/E to Longterm Growth (PEG) ratio  Valuation Ratios (require IBES subscription) (#7274) 