The Data Page
This page provides information on how to collect data from a variety of sources. it also allows you to look at and download a number of data sets that you might find useful in corporate finance and valuation. If you have trouble viewing the data in your browser, you can download the data in excel format. I will try to keep them updated, and include the dates of the updates with the data sets. If you want to see the company-specific information, you can download the data on individual firms below.
Recent additions: While most of the data sets here are based upon U.S. firms, I have added updates for Europe (Western Europe and the UK), Japan and for Emerging Markets (Latin America, Asia and Eastern Europe) for a few data items - betas and price multiples. Any company with a market capitalization greater that $ 50 million in US dollar terms should be in the datasets. You can download the data in excel files but the html files will contain only the US data. While I will update the US data every six months or so, I will update the non-US data once a year. I have also added the archived files from previous years for those of you who want historical data. The data is as of the end of each year.
With the U.S. data, I have added an extra feature, at least for the risk measures and multiples, where I have broken down the averages by market cap class.
Date of last update:Market | Date of last update | Number of firms | Data source |
United States | January 2006 | 7113 | Value Line |
Europe (EU, UK, Switzerland & Scandinavia) | January 2006 | 3809 | Bloomberg |
Japan | January 2006 | 3195 | Bloomberg |
Emerging Markets (Asia, Latin America, Eastern Europe, Mid East and Africa) | January 2006 | 8485 | Bloomberg |
Australia, New Zealand & Canada | January 2006 | 1365 | Bloomberg |
Archived Data : The data reported in
the download is the most recent data (from the dates of the last update).
For the US data, you can download the archived averages from the end
of the previous years (1998-2004). The 2004 archived average is the average
as of December 2004 (January 2005 update), for instance.
Individual company information: While the industry
averages are reported below, you can also download information on individual
firms. The files below contain the information for the U, Europe and Emerging
Markets separately. Be forewarned that these are large files and may take
a while to download. The archived files from previous years
are also available. (The 2004 file incluces data from the end of 2004 and
so on...)
US | Europe | Emerging Markets | Japan | Australia, NZ and Canada | |
Current | Download | Download | Download | Download | Download |
2004 | Download | Download | Download | Download | Download |
2003 | Download | Download | Download | Download | Download |
2002 | Download | Download | Download | ||
2001 | Download | ||||
2000 | Download |
Variable definitions: You
can get the definitions of the variables used in the datasets by clicking here
Source data: If you want more information on the source data, click
here.
Collecting Data
|
|
|
Annual Report or 10K | While both contain large amounts of relevant data, I sense that they are both becoming data dumps as companies become increasingly risk averse. | |
Value Line | Plus: Old fashioned but very effective at delivering substantial amounts
of information on one page. Minus: Needs to update page to reflect available (and necessary data) and downplay its stock picking and forecasting ability. |
|
Bloomberg | Clearly the best all-round source of data on any firm almost anywhere in the world. It has two shortcomings. It is not very user-friendy, making it difficult to wade through the data to get the information you need, and it is often difficult to download the data that you need from the terminal. | Getting Data from Bloomberg- pdf file (online version) |
Data Sets
Topic | Data Sets |
Download Excel file | Archived Data | Description |
Corporate Governance | |
This data set includes insider holdings and institutional holdings as a percent of outstanding stock, classified by industry. | ||
Discount Rate Estimation | |
This data set includes actual returns on stocks, bonds and bills for the United States from 1928 to the most recent year. It is a useful starting point for estimating historical equity premiums. | ||
Download | These risk premiums are estimated based upon a simple 2-stage Dividend discount model and reflect the risk premium which would justify they current level of the index, given the dividend yield, expected growth in earnings and the level of the long term bond rate. | |||
Download | These are risk premiums estimates for other markets based upon the country ratings assigned by Standard and Poors'. | |||
1998, 1999, 2000, 2001, 2002, 2003. 2004 | This data set lists betas by industrial sector. The betas are computed using 5 years of monthly returns for each stock and then averaged (simple). The unlevered betas are estimated using the average market debt/equity ratios by industrial sector. (Hamada betas). | |||
Marginal tax rate by country | Download | This is the KPMG survey of corporate tax rates by country. Please give them full credit when you use any of the information from this file. | ||
Download | 1998, 1999, 2000, 2001, 2002, 2003, 2004 | These are betas adjusted to reflect a firm's total exposure to risk rather than just the market risk component. It is a function of the market beta and the portion of the total risk that is market risk. These betas might provide better estimates of costs of equity for undiversified owners of businesses. | ||
Risk Measures by Market Cap Class | Download | These are risk measures - standard deviatiions, betas, total betas and hilo risk - broken down for U.S. firms into ten market cap classes. Make of it what you will. | ||
Download | 1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This data set lists costs of equity, costs of debt, market debt ratios and costs of capital by industrial sector. | ||
Performance Measures | Download | 2002, 2003, 2004 | This data set lists annualized Jensen's alphas by industry, as well as R-squared values. | |
Download | 1998, 1999, 2000, 2001, 2002, 2003, 2004 | This lists out the average economic value added and equity economic value added by industry sector. While I have not made any adjustments to the operating income and book value of capital, this is a good starting point for comparisons. | ||
Capital Structure | Download | 1998, 1999, 2000, 2001, 2002, 2003, 2004 | This data set lists the industry averages of the market debt ratio, the effective tax rate (tax benefit), insider holdings (discipline), variance in operating income (bankruptcy risk) and fixed assets to total assets (agency costs). | |
Download | This data set lists S&P bond ratings classes, with normal spreads over the treasury bond rate and typical interest coverage ratios | |||
Download | This summarizes the impact of converting operating lease commitments into debt on market debt to capital ratios, operating income and return on capital, categorized by industry. | |||
This summarizes the results of the latest cross sectional regression of the market debt ratio (total debt to capital) against financial variables. | ||||
Download | This lists the coefficients obtained when we regress sector market value changes (quarterly) against changes in long term interest rates, GNP growth and inflation. | |||
Download |
This data set includes annual data on interest rates, inflation rates, GNP growth and the weighted dollar from 1981 on... | |||
Dividend Policy | Download | 1998, 1999, 2000, 2001, 2002, 2003, 2004 | This data set lists the industry averages of the dividend yield and payout ratios, as well as other variables that might be relevant in examining the trade off involved in paying dividends. | |
This summarizes the results of the latest cross sectional regression of the dividend yield and payout ratio against financial variables. | ||||
Cash Flow Estimation | Download | 1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This lists out average capital expenditures and depreciation by industry sector, as a percent of operating income. It is a useful resource during valuation. It also includes the sales to capital ratio which is useful when valuing young firms with negative earnings. | |
Download | 1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This reports average operating and net margins by industry sector for the most recent time period. | ||
Download | 1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This lists out average inventory, accounts receivable, accounts payable and non-cash working capital by industry sector, as a percent of revenues. | ||
Growth Rate Estimation | Download | 1998, 1999, 2000, 2001, 2002, 2003, 2004 | This data set reports average return on equity (net income/book value of equity) by industry sector and decomposes these returns into a pure return on assets and leverage. | |
Download | 1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This data set summarizes growth rates from fundamentals (ROE * Retention Ratio) by industry group. | ||
Download | 1998, 1999, 2000, 2001, 2002, 2003, 2004 | This data set summarizes growth in earnings over the last 5 years by industry. | ||
Download | 1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This data set summarizes growth rates from fundamentals (ROC*Reinvestment Rate) by industry group. | ||
Multiples | 1998, 1999, 2000, 2001, 2002, 2003, 2004 | This lists out the PE ratio, expected growth (Value Line) and the PE/growth by industry group for the most recent time period. | ||
1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This lists outs Price/Book value ratios and ROE by industry group for the most recent time period. | |||
1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This lists out Price/Sales ratios and margins by industry group for the most recent time period. | |||
1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This lists out Enterprise Value / EBITDA by industry group for the most recent time period. Enterprise Value is the market value of equity plus the book value of debt minus cash. | |||
Multiples by Market Cap Class (US) | Download | The averages for key equity and enterprise value multiples are reported for firms in different market cap classes in the U.S. | ||
Download | This lists out the average PE, Price to book, Price to Sales and Enterprise Value multiples by country. It also includes summary statistics on returns on equity and capital and margins (net and operating). | |||
1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This lists the output from the latest regressions of multiples against fundamentals (PE, PBV and PS ratios). | |||
Option Pricing Models | Download | 1998, 1999, 2000, 2001, 2002, 2003 , 2004 | This lists out average annualized stock price variance (in daily stock prices) over the previous five years, and the average firm value standard deviation over the same period. |