- Find Information
- Research Guides
- ACC 3163: Quantitative Analysis for Accounting (Ye)
ACC 3163: Quantitative Analysis for Accounting (Ye)
• Course research guide for ACC 3163: Quantitative Analysis for Accounting with Zhongxia (Shelly) Ye
Financial Ratios Industry Level in WRDS)
- Financial Ratios Industry Level by WRDS (Beta)There are totally 74 variables available in the Financial Ratios Industry Level by WRDS (Beta) that are grouped into the categories as follows below:
Industry Return (#1-3)
Valuation Ratios (#4-16)
Profitability Ratios(#17-31)
Capitalization Ratios (#32-35)
Financial Soundness (#36-51)
Solvency Ratios (52-57)
Liquidity Ratios (#58-61)
Efficiency Ratios (#62-68)
Other Ratios (#69-72)
Valuation Ratios (require IBES subscription) (#72-74)Please note: This resource is only available to current UTSA faculty, students, and staff. You must request a WRDS account prior to use.
You can make a WRDS Query for any of the following 74 variables (for details, please refer to the 2nd tab "Variable Descriptions" on Financial Ratios Industry Level by WRDS (Beta) or this pdf file):
- Equal Weighted Industry Return
- Value Weighted Industry Return
- The number of companies that belongs to the industry classification
- Dividend Payout Ratio
- Trailing P/E to Growth (PEG) ratio
- Book/Market
- Shillers Cyclically Adjusted P/E Ratio
- Dividend Yield
- Enterprise Value Multiple
- Price/Cash flow
- P/E (Diluted, Excl. EI)
- P/E (Diluted, Incl. EI)
- Price/Operating Earnings (Basic, Excl. EI)
- Price/Operating Earnings (Diluted, Excl. EI)
- Price/Sales
- Price/Book
- Effective Tax Rate
- Gross Profit/Total Assets
- After-tax Return on Average Common Equity
- After-tax Return on Total Stockholders Equity
- After-tax Return on Invested Capital
- Gross Profit Margin
- Net Profit Margin
- Operating Profit Margin After Depreciation
- Operating Profit Margin Before Depreciation
- Pre-tax Return on Total Earning Assets
- Pre-tax return on Net Operating Assets
- Pre-tax Profit Margin
- Return on Assets
- Return on Capital Employed
- Return on Equity
- Capitalization Ratio
- Common Equity/Invested Capital
- Long-term Debt/Invested Capital
- Total Debt/Invested Capital
- Inventory/Current Assets
- Receivables/Current Assets
- Free Cash Flow/Operating Cash Flow
- Operating CF/Current Liabilities
- Cash Flow/Total Debt
- Cash Balance/Total Liabilities
- Cash Flow Margin
- Short-Term Debt/Total Debt
- Profit Before Depreciation/Current Liabilities
- Current Liabilities/Total Liabilities
- Total Debt/EBITDA
- Long-term Debt/Book Equity
- Interest/Average Long-term Debt
- Interest/Average Total Debt
- Long-term Debt/Total Liabilities
- Total Liabilities/Total Tangible Assets
- Total Debt/Equity
- Total Debt/Total Assets
- Total Debt/Total Assets
- Total Debt/Capital
- After-tax Interest Coverage
- Interest Coverage Ratio
- Cash Conversion Cycle (Days)
- ash Ratio
- Current Ratio
- Quick Ratio (Acid Test)
- Asset Turnover
- Inventory Turnover
- Payables Turnover
- Receivables Turnover
- Sales/Stockholders Equity
- Sales/Invested Capital
- Sales/Working Capital
- Accruals/Average Assets
- Research and Development/Sales
- Avertising Expenses/Sales
- Labor Expenses/Sales
- Forward P/E to 1-year Growth (PEG) ratio
- Forward P/E to Long-term Growth (PEG) ratio
Detailed info about industry classification variable users have an option to select in Financial Ratios Industry Level by WRDS (Beta):
|
Industry Metrics & Ratios
- Key Business Ratios (Mergent Online) This link opens in a new windowIndustry benchmarks based on Dun and Bradstreet’s (D&B) database of aggregated financial statements of public and private companies in 800 lines of business. Features 14 key business ratios for the critical areas of business performance – solvency, efficiency, and profitability. Search data by SIC or NAICS code, line of business, asset range and year.
For historical data back to 1979, go to Key Business Ratios Archive (a digital archive of print publications). - BizMiner This link opens in a new windowProvides detailed industry analysis and market research reports on more than 16,000 lines of business in national and local markets. Includes startup and small business statistics, such as annual sales and market share; failure rates; entrepreneurial activity rates; startup profit & loss detail and ratios; and detailed small business balance sheets, P & L, and ratios.
- IBISWorld This link opens in a new windowContains detailed industry market reports for the U.S., based on the NAICS classification. Reports include industry performance, lifecycle, products and markets, supply chain, operating conditions, regulation and policy, key competitors, barriers to entry, outlook, and more. Specialized Industry Reports address more narrowly defined product/service segments or emerging industries.
- RMA eStatement Studies This link opens in a new windowProvides performance metrics derived from the financial statements of financial institutions' borrowers and prospects. The Financial Ratio Benchmarks (FRB) provides industry norms including liquidity, coverage, leverage, and operating ratios. The Industry Default Probability Data (IDP) uses cash flow measures to project the expected default frequency estimates (EDF) by industry. Data for 760+ industries based on NAICS codes may be examined on a national or regional level. Five year archive