Faculty Resources

Audit Analytics

Audit Analytics provides detailed research on over 20,000 public
companies and more than 1,500 accounting firms.
Search modules include: Current Auditor Engagements, Auditor Changes,
Auditor Fees, Auditor Opinions and Benefit Plan Opinions. Know who is
auditing whom and how much they are paying their independent auditor by
fiscal year. Track auditor changes including a detailed taxonomy of
issues. The audit opinion and benefit plan opinion modules provide quick
access to the text of an auditor's opinion and enables searching of
opinions by auditor and company specific demographics. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page


Sarbanes-Oxley Disclosures:
Search modules include: Section 404 Internal Control Disclosures and
Section 302 Disclosure Controls. Audit Analytics enables you to quickly
identify who has effective controls and who doesn't. Screen a group of
companies for specific Sarbanes-Oxley compliance issues and identify
which issues are pervasive in an industry or peer group. Data sets
include detailed categorizations allowing you to analyze disclosures by
issue type.


Compliance Disclosures:
Search modules include: Financial Restatements and Late Filers. Quickly
identify all companies with a particular type of restatement by auditor
or peer group. Analyze restatements by disclosure date, affected period
and specific issues. Determine who the auditor was as of the restatement
and during the restatement period. Restatement observations link back to
the original filings and all searches are downloadable into excel.


Litigation:
Search modules include: Federal Litigation by Auditor, Company,
Government Entity, and type. Quickly assess outstanding litigation risks
and easily identify corporate legal representation.


Corporate Governance:
Search modules include: Director and Officer Changes, Current Audit
Committee Member Listings, and Current Director and Officer Listings.
Provides a comprehensive listing of governance disclosures including
director and officer changes, auditor committee member listings, C-level
executives and their biographies.

Board Analyst 2002 - 2005

Produced by the Investor Responsibility Research Center (IRRC), this resource has analyzed the latest structure and pay practices of approximately 1,200 companies in the S&P 500, MidCap, and SmallCap indexes, to produce an in-depth study of U.S. boards. This comparative study charts and graphs numerous board features by index, by revenue band, and by economic sector. Extensive tables detail the structure and pay of each company's practices and compensation program e.g. (Practices, Independence, Size, Audit Committees, Nominating Committees, Compensation Committees, Independent Chair, Diversity, Pay). The data exists in excel spreadsheets for each year.

Access: The School of Business provides access to Compustat data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page.

Compact D/SEC

This resource consists of data from various SEC filings. The current version is available on Thomson Research (formerly Global Access). We also have monthly discs from 1989 to 2006. Some of the SEC data that can be searched are:

  • Financial Footnotes
  • Spectrum filings
  • Earnings Estimates

Access:The current month of Compact D/Sec can be accessed from Thomson Research (formerly Global Access). Previous month's discs can be checked out of the Business Library for two days.

Compustat

The Compustat database contains fundamental financial and market data for over 10,300 US companies. Compustat also includes data for over 7,600 inactive companies. Some of the subsets are:

Industrial Annual (current)
Industrial Annual (1960-79)
Industrial Annual (1950-69)
Industrial Quarterly (current)
Industrial Quarterly (1978-89)
Industrial Quarterly (1967-78)
Industrial Quarterly (1962-73)

Full Coverage Annual (current)
Full Coverage Annual (1960-79)
Full Coverage Annual (1950-69)

Full Coverage Quarterly (current)
Full Coverage Quarterly (1978-89)
Full Coverage Quarterly (1967-78)
Full Coverage Quarterly (1962-73)

Research Annual (current)
Research Annual (1960-79)
Research Annual (1950-69)

Research Quarterly (current)
Research Quarterly (1978-89)
Research Quarterly (1967-78)
Research Quarterly (1962-73)

Canadian Industrial Annual
Canadian Industrial Quarterly

Business Industry Segments (current)
Business Industry Segments (1986-92)
Business Industry Segments (1980-86)
Business Industry Segments Research (current)

Business Geographic Segments (current)
Business Geographic Segments Research (current)

Bank Annual
Bank Quarterly

Access: The School of Business provides access to Compustat data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page.

Computstat Executive Compensation

Standard & Poor's Compustat Executive Compensation  is a unique database for effective executive compensation analyses. This Compustat database includes data that “cover current, historic and total compensation, executive options and compensation of industry peers and comprehensive and objective executive compensation on the top officers of more than 1,900 companies. Compustat data is unique in that it is standardized. Standardizing the data ensures that comparability exists among similar types of data items as well as financial results in current and prior time frames. The ExecuComp report library accesses more that 100 up-to-date compensation and financial items from 1992 to 1998.

Access: The School of Business provides access to Compustat data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page.

Corporate Restructuring Databases - Bankruptcies

This resource has two databases. The Full Detail database provides over
200 items on all U.S. public companies that have $10 million or more in assets and have filed for Chapter 11 bankruptcy protection or companies with assets over $50 million that have had a default or an exchange offer at a substantial discount to face value. The Full Detail database is updated monthly. The Limited Detail database covers from 1980 to 1990 and is not updated.

Access: Individual faculty can have the software loaded onto their desktop. Contact Michael Enyart at 263-3902 or by email.

CRSP: Center for Research in Security Prices

CRSP provides monthly and annual updates of 2 databases; end-of-day and month-end. These contain price, volume and return data on NYSE, AMEX and Nasdaq common stocks with basic market indices.

Important facts regarding CRSP Stock Data:

    • Annual Updates: Ready in March.

    • End-of-Day and Month-End Data: NYSE/AMEX: High, low, bid, ask, closing price, trading volume, shares outstanding, capital appreciation, income appreciation, total return, year-end capitalization, and year-end capitalization portfolio. Nasdaq data also includes: closing bid, ask, number of trades, historical traits information, market maker count, trading status, and NASD classification.

    • History: NYSE - monthly data begins December 1925, daily July 1962. AMEX - both monthly and daily data begin July 1962. Nasdaq - both monthly and daily data begins December, 14 1972.

    • Identifying Information: Complete Name History records for each security containing all historical: PERMNO, PERMCO, CUSIPs, exchange codes, ticker symbols, SIC codes, share classes, share codes, and security delisting information. Offering seamless and accurate time series analysis, CRSP data includes unique permanent issue and company identifiers, PERMNO and PERMCO.

    • Distribution Information: descriptions of all distributions, dividend amounts, factors to adjust price and shares, declarations, ex-distributions, record and payment dates, and security and company linking information.

CRSP Indicies
The CRSP Stock File Indices are provided for four frequencies: daily, monthly, quarterly, and annual. There are five groups of securities for which indices are calculated: the individual NYSE, AMEX and Nasdaq markets, and the NYSE/AMEX and NYSE/AMEX/Nasdaq market combinations. Value weighted returns, with and without dividends, as well as equal-weighted returns, with and without dividends, are calculated for each index.

CRSP/COMPUSTAT Merged Databases
The CRSP/COMPUSTAT Merged Databases (CCM) contain CRSP Link, a link between primary identifiers unique to CRSP and Standard and Poor's Compustat®. CCM data are packaged with Standard & Poor's Compustat fundamental financial information reformatted into the CRSPAccess database format containing: utilities, C and FORTRAN 77 random access libraries, sample programs, and installation support for CRSP and COMPUSTAT data. The link enables researchers to query both CRSP's and Standard and Poor's Compustat's® historical databases with a high degree of accuracy.

    • Annual Updates: Ready in August

    • Monthly and Quarterly Updates: Ready in the first half of the following month (e.g. September data would be available by the 16th of October).

    • Annual and Quarterly Data: The COMPUSTAT data include more than 340 annual and 120 quarterly Income Statement, Balance Sheet, Flow of Funds, and supplemental data items covering over 11,000 US and Canadian active companies and 9,400 inactive companies.

    • History: Available from 1950

    • Linking Information: CRSP's PERMNO and PERMCO are linked to COMPUSTAT's GVKEY.

CRSP US Treasury Databases
CRSP provides 1.5 million end-of-day price observations for 3,244 US Treasury bills, notes and bonds since 1961. The monthly database contains 101,986 prices for 5,136 issues since 1925.

Important facts regarding CRSP US Treasury data:.

    • Annual Updates: Ready in March.

    • History: Daily data begins on June 14, 1961. Monthly data begins on December, 31 1925.

    • Identifying Information: Unique CRSP Identifier (CRSPID), CUSIP, maturity date, Coupon rate, and other items, sorted by CRSPID.

    • Quote Data: Bid, ask, and source. Performance Data: Accrued interest, yield, return and duration.

    • Debt Data: Debt outstanding, total and publicly held.

    • Fixed Term Indices Files: Performance of single Treasury issues at fixed maturity horizons.

Access: The School of Business provides access to CRSP data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page.

D&B Million Dollar Database

This is one of the oldest business directories. It provides information on 11.9 million company records with employment figures; 10.0 million company records with sales figures and 15.6 million executive names. A good source for company names and address for surveys.

Access: This database can be accessed from any place on campus or through WiscWorld.

Data & Program Library (http://dpls.dacc.wisc.edu/collection.html)

The Data and Program Library Service (DPLS) is the central repository of data collections used by the social science research community at the University of Wisconsin-Madison. Its mission is to promote academic research by facilitating the use of secondary research materials. The collection includes major surveys from a variety of distributors, U.S. government data, and locally produced archival datasets.

Datastream

This is one of the major resources of for international data. You might consider Datastream an international combination of Compustat, CRSP, and DRI/McGraw-Hill. It includes:

  • Equities
    •  
  • Financial Statements
  • Indicies
  • Exchange Rates
  • UK Investment Trusts
  • Options
  • Bonds, Warrants, Convertibles
  • Economics
  • Interest Rates
  • Commodities
  • Futures

    • Access: Datastream is available on two computers in the Business Library. Individual Faculty can have the software loaded onto their desktop. Contact Michael Enyart (263-3902) or by email.

    Dow Jones Averages

    The Dow Jones Averages are comprised of the Dow Jones Industrial Average (DJIA), the Dow Jones Transportation Average (DJTA) and the Dow Jones Utility Average (DJUA). The DJIA, the best known U.S. stock index, and the DJTA, the oldest U.S. stock index were created by Charles Henry Dow, co-founder of Dow Jones & Company.

    Currently there are 30 stocks in the Dow Jones Industral Average, which represents about one-fifth of the value of all U.S. stocks. The Dow Jones Transportation Average includes 20 stocks, and there are 15 stocks in The Dow Jones Utility Average.

    Access: The School of Business provides access to Dow Jones Averages data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page

    FDIC: Research Information System

    The Federal Deposit Insurance Corporation (FDIC) database contains financial data and history of all entities filing the Report Of Condition and Income (Call Report) and some savings institutions filing the OTS Thrift Financial Report (TFR). These entities include Commercial banks, savings banks, or savings and Loans (The Federal Deposit Insurance Corporation Database p.1).

    FDIC files include structure data, financial time series data, complex derived integers data, ratio data, and merger history data. For more information about the FDIC data, download the data dictionary or visit the U.S. Federal Deposit Insurance Corporation WWW Home Page

    Access: The School of Business provides access to FDIC data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page

    First Call Consensus Earnings

    The First Call Historical Database, or FCHD, is a history of First Call's Real Time Earnings Estimates. FCHD Release 1.0 contains the following major data tables:

    • Broker Estimate Detail (EPS, Cash Flow Per Share, Funds From Operations, etc.)
    • Consensus Estimates (mean, standard deviation, high, low, number of estimates)
    • Estimate Revision Activity (1, 7, 30 and 90 days as well as Monthly and
      Monthly Option Expiration)
    • Reported Actuals
    • Company Issued Guidelines
    • Footnotes
    • Stock Splits
    • Company and Issuer Information
    • Cross Reference to other First Call Products

    FCHD contains earnings information dating as far back as 1990, on over 9,700 securities, including:

    • 8,500 U.S. Securities
    • 1,000 Canadian Securities
    • 180 ADR's

    Access: The School of Business provides access to Institutional Ownership (13f) data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page.

    Global Corporate New Issues

    New Issues databases provide authoritative coverage of global equity issues, Eurobonds, U.S. Private Placements, and more -- giving you the same critical information used by leading investment banks and top financial publications. The New Issues databases answer questions like these:

      • How many bond issues offered by French companies were managed by foreign underwriters?

      • Who is the leading underwriter of Hong Kong rights issues?

      • Which Latin American telecommunications companies have completed direct offerings?

      • What other issues will be coming to market during the week you're expecting to launch an issue?

      • Which IPOs came to the U.S. market at, above, or below original price range?

    The New Issues databases cover more than 290,000 transactions and include coverage as far back as 1970. These databases include data highlights such as:

        · Issuer profiles
        · Managers and fees
        · Offering terms
        · Financial data
        · Shares offered

    Access: Individual faculty can have the software loaded onto their desktop. Contact Michael Enyart at 263-3902 or by email.

    Institutional Ownership

    This database provides comprehensive institutional ownership and account profile information for fixed income and equity securities. This resource allows users to find holders of a specific bond or deal, issues within a particular state, or view the entire portfolio of a specific account.

    Access: The School of Business provides access to Institutional Ownership (13f) data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page.

    Morningstar

    Morningstar Principia Pro is a mutual fund advisory service. It covers over 1,500 mutual funds and includes such data as fund objective, recent price and dividend information, ten years of performance figures, background on portfolio composition, portfolio analysis, risk and return analysis, and Morningstar ratings. Data is updated on a quarterly basis. This resource will provide historical performance data on Mutual Funds.

    Access: Morningstar is available on one computer in the Business Library.

    Philadelphia Stock Exchange

    The Philadelphia Stock Exchange founded in 1790 is the oldest organized stock exchange in the nation. As one of North America's primary marketplaces for the trading of stocks, equity options, index options and currency options, the PHLX continues to be a market leader in the development and introduction of innovative new products and services.

    The PHLX trades more than 2,800 stocks, 740 equity options, 12 sector index options, and 100 currency pairs. On the equity floor, PHLX's PACE (Philadelphia Automated Communication and Execution) system was one of the first automated equity trading systems on any exchange.

    The PHLX's Semiconductor Sector (SOX) Index Option has become one of the most actively traded sector index option offered by any exchange, and serves as a widely quoted benchmark of the high-tech industry. Additionally, the Oil Service Sector (OSX) is the industry's most successful new sector index option. Furthermore, the PHLX's Gold/Silver Sector (XAU), KBW Bank Sector (BKX) and Utility Sector (UTY) are established in a highly competitive environment of other indices, as leading industry indicators.

    In perhaps one of the most important innovations since listed currency options themselves, the PHLX has created a unique market structure for the trading of currency options. Titled the United Currency Options Market (UCOM), unprecedented flexibility is provided for with the availability of both standardized and customized currency options. Customized currency options offer choice of expiration date, strike (exercise) price, premium payment and any combination of 10 currencies currently available for a total of 100 possible currency pairs.

    Access: The School of Business provides access to Philadelphia Stock Exchange data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page

    RDNA

    The RDNA database is a sister to RECAP and is one of the premier sources of business information in the biotech industry. This database provides the following information on biotechnology companies:

    Alliances: Contains records of over 10,000 biotech alliances covering the history biotech partnering up to the most recent press release. This also maintains a copy of the contracts as filed with the SEC for those deals with filing requirements (approximately 9,500). For some of those filed contracts ReCap has completed a provision-level analysis (approximately 1,200).

    Clinical Trials: This part of the database displays the progress of potential biotech products currently in or having ended clinical testing for over 3000 indications. For most of these compounds, ReCap provides a expert opinion called a Clinical Capsule.

    Product Sales: Provides historical sales data for 55 biotech products, with graphs of quarterly revenue and detail notes.

    Valuation Histories: Graphs and tables detailing the financing history of over 550 biotech and medical device companies

    Employment Agreements: Provides over 2000 unedited biotech executive employment agreements.

    Anyone interested in gaining access to this database should contact Michael Enyart at 263-3902 or by email.

    SDC Mergers & Acquisitions

    All corporate transactions involving at least 5% of the ownership of a company where the transaction was valued at $1 million or more (after 1992, deals of any value are covered) or where the value of the transaction was undisclosed. Public and private transactions are covered. Date coverage is from 1979 to present domestically and 1985 to present internationally.

    Access: Individual Faculty can have the software loaded onto their desktop. Contact Michael Enyart at 263-3902 or by email.

    TAQ: NYSE Trade and Quote Database

    The Trade and Quote (TAQ) database contains intraday transactions data (trades and quotes) for all securities listed on the New York Stock Exchange (NYSE) and American Stock Exchange (AMEX), as well as Nasdaq National Market System (NMS) and SmallCap issues.

    Access: The School of Business provides access to TAQ data through the Wharton Research Data Service or WRDS. WRDS restricts access by UserID and password. Ph.D. students and faculty of the Business School may obtain WRDS accounts through the WRDS web page. WRDS does not provide accounts for individual MBA students. Click on the "Account Registration" link to request an faculty, Ph.D. or class account. Account information will be returned to you in about 48 hours. If you do not provide an email address as part of the signup, we will not be able to pass your account on to you. In addition, we will not pass account information on to non-Wisconsin email addresses. Be sure to use a Wisconsin email account on the signup page: WRDS Web Page

    Thomson Research

    Provides access to the 10K's, ARS, 8K, 10Q, and Registration Statements from 1997 to date. The documents are provided in HTML, Word, a Custom Format, and the financials can be downloaded into a spreadsheet.

    Access: Contact Michael Enyart at 263-3902 or by email.

    ValueLine Investment Survey

    The ValueLine Investment Survey is a comprehensive source of information and advice on approximately 1,800 stocks, more than 90 industries, the stock market, and the economy. It has three parts: The Ratings & Reports, Summary & Index, and Selection & Opinion. In the CD-ROM version of this product, ValueLine provides information on the largest mutual fund owners of the 1,800 stocks.

    Access: ValueLine Investment Survey is available on one computer in the Business Library. The CD-ROM is a monthly service and we have discs from December 1996. They can be checked out for two days.

    VentureXpert

    VentureXpert provides an extensive query and report database for the private equity industry. VentureXpert is a source forcomprehensive information on venture funds, private firms, executives, venture-backed companies and limited partners, as well as an analytics source for fund performance, commitments, disbursements, and statistics. VentureXpert's comprehensive data includes:

    • Investment information for over 23,500 private-equity backed companies
    • Over 7,100 venture capital and buyouts funds managed by over 4,400 private equity firms
    • Over 118,000 private equity transactions from 1970 to the present
    • Exclusive deal and fund information from all corners of the globe

    Access: Individual Faculty can have the software loaded onto their desktop. Contact Michael Enyart at 263-3902 or by email.