Book value for a company may be reported for fiscal year ending june, but you might want to calculate mb ratio at calendar yearend month, december. Stock price adjustment factors in compustat and crsp. Book equity is constructed from compustat data or collected from the moodys industrial, financial, and utilities manuals. The limitations of industry concentration measures constructed with compustat data. Appendix unless otherwise noted, data are from the compustats. This online appendix provides detailed derivation, variable definition, and portfolio construction for the. Limitations of excel sheets on the number of rows 256. On the relation between the markettobook ratio, growth. The results show that on a relative scale, the markettobook assets ratio outperforms all other proxy variables that we investigate. Compustat files also contain information on aggregates, industry segments, banks, market prices, dividends, and earnings. Now i am working with compustat global for the first time and am struggling to find a comparable time series. For the markettobook ratio we need the number of shares outstanding, end of year stock price, and book value of equity. Fama and french 1992 find that two variables, market equity me and the ratio of book equity to market equity beme capture much of.
All debt measures are computed as of the end of the calendar year 2004. Fama and french 1992 find that two variables, market equity me and the ratio of book equity to market equity beme capture much of the cross. I need this ratio for all the uk companies of last 15 year and i am not sure about which variables and. Compustat mainly covers accounting data for public and private companies. Be is the book value of stockholders equity, plus balance sheet deferred taxes and investment tax credit if available, minus the book value of preferred stock. High booktomarket ratios can be interpreted as the market valuing the. Computes annual buyandhold market equity for use as. Book value of equity consists of two economically different components.
Balance sheet data are obtained from the standard and poors compustat database. The data we need is in compustat fundamental annual funda. Using this items, the book value has the wrong order of magnitude too small. For the second measure of booktomarket, we use compustats book value. Price is from crsp, shares outstanding are from compustat if available or crsp.
Booktomarket, retained earnings, and earnings in the cross section of stock returns ray bally 1, joseph gerakos2, juhani t. The calendar year basis allows you to compare market data among companies based on a particular point in time. Hi, i am struggling to calculate market to book ratio tobins q from compustat. Documentation on compustat data annual financial data. Crsp follows calendar regime and compustat follows fiscal regime e. Wharton research data services taps the most comprehensive sources of financial, accounting, economic, management, marketing, banking, and insurance data. Bm book to market ratio book values are from compustat and.
In compustat, this variable is adjex and in crsp these variables are cfacpr and cfacshr. Davis abstract using a database that is free of survivorship bias, this article finds that booktomarket equity, earnings yield, and cash flow yield have significant explanatory power with respect to the crosssection of realized stock returns during the period. Neither the bookmarket value of equity ratio nor the market value of equity has consistent explanatory powerfor stock returns, and the salesprice ratio is a more reliable explanatoryfactor. How to use compustat global for daily stock returns. Compustat data is standardized, not as reported by the company so there may be a difference from what is reported in the 10k or 10q. Compustat fundamentalsbalance sheet items income before. Evidence from the stock market yuriy gorodnichenko and michael weber. Use gvkey compustat firm identifier at assets total, ceq book value of equity, datadate end of year date from the first table, and match on gvkey and datadate on securities table to get cshoc shares outstanding and prccd end of day stock price.
Variables are trimmed at the 1st and 99th percentiles based on booktomarket, size, prior onemonth return, and prior oneyear return skipping a month. Instead, they find that booktomarket captures the effects of leverage, and that size and booktomarket together absorb the effects of the earningtoprice ratio in explaining average return. Dissertation chapter 1 how important is target leverage. Booktomarket, retained earnings, and earnings in the. Examples of excluded rows include those with restated data, different views of the same data pro forma, prefasb. Booktomarket, retained earnings, and earnings in the cross section. The authors go on to speculate that the booktomarket ratio along with size explain return because they proxy for unknown economic risk factors. Earnings, retained earnings, and booktomarket in the cross section of expected returns ray bally 1, joseph gerakos2, juhani t. Understanding the compustat north america database 2. Overview of compustat global data august 2, 2002 26 income statement models this chapter presents a number of financial statemen t models for the balance sheet, income statement, and statement of cash flows. Linnainmaa3,4 and valeri nikolaev 1university of chicago booth school of business, united states. Several screening variables are preselected to produce one record per gvkeydatadate pair, while keeping the vast majority of records. The corporate leverage variables are total debt to market value of assets tdm, total debt to book value of assets tda, longterm debt to market value of assets ldm, and longterm debt to book value of assets lda.
Crsp monthly, compustat annual and quarterly data aligns accounting fundamentals with market prices. Merging compustat annual and crsp monthly in stata. Compustat data files compustat data files, distributed by standard and poors compustat services, inc. Other databases like crsp and datastream offer similar options but the compustat option is a very easy to use one. Hello everyone, im trying to merge compustat global annual data with compustat global security data by gvkey. How to calculate the book value with compustat fundamentals quarterly. A reexamination of firm size, booktomarket, and earnings.
A reexamination of firm size, booktomarket, and earnings price in the crosssection of expected stock returns volume 32 issue 4 dongcheol kim. Both compustat and crsp include variables which contain the split adjustment factor. Aocime are set to zero when re, cc, or aoci is nonpositive. We predict that booktomarket strategies work because the retained earnings component of the book value of equity includes the accumulation and, hence, the averaging of. Compustat standardizes data from the original filings to remove reporting variability and to allow for an accurate comparison across. The market and size factors in earnings help explain those in returns, but we find no link between beme factors in earnings and returns. My solution is to multiply the crsp market value with the last known ratio of compustat to crsp market value. Problems with merging crsp with compustatcrsp merged.
An overview of the adjustment factor variables is available in the compustat manual understanding the data on page 91 chapter 6. Fortify your research with a timetested database of financial, statistical, and market. The booktomarket ratio helps investors find the value of a company by comparing the firms book value to its market value. Earnings, retained earnings, and booktomarket in the. Long term debt market value of assets ldm ldm is the ratio. On compustat quarterly i found three variables that seemed to be. In addition, the analysis of becker and stromberg 2012 indicates multivariate outliers also affect commonly used control variables including booktomarket ratios, market leverage, and other data from the compustat and crsp databases. Crspannual updatecrspcompustat mergedfundamental annual miscellaneous items. The models identify where specific compustat global data items are located in each statement. I am experiencing difficulties finding the right items to calculate the book value of a firm from the compustat fundamentals quarterly. Bm book to market ratio book values are from compustat and market value is from cec test121 at florida international university. Compustat fundamentalsbalance sheet items firm size log.
If you have access to compustat through wharton you can find the manual there at. Market equity size is price times shares outstanding. Estimating a firms market value of common equity mve at a given point in time is something that a finance researcher does quite often. The investment opportunity set and its proxy variables by. Not for publication we include in this appendix a number of details and robustness checks that are omitted.
I calculate the variables using the data in the compustat annual industrial. Why do we take the natural log of booktomarket ratios. Since we are interested in computing roe for each industry over a number of years, we will need net income, the book value of equity, the sic industry code and the fiscal year. It can be surprisingly hard using only the two commonly available datasets for financial and stock information, crsp and compustat. In column 4, the dummy variables are replaced by hicompustat and leverage. Limitations of industry concentration measures constructed. The relation between the markettobook ratio and leverage ratio is not monotonic and is positive for most firms more than 88% of compustat firms and more than 95% of total market capitalization. Crspannual updatecrspcompustat mergedfundamental annualsupplemental data items csho. For return on assets we will use net income and end of year total assets.
Documentation on compustat data variable name variable description annual financial data financial performance measures ros annual return on sales net income revenues. Tobins q ratio provides information on how well a companys investments pay off. For my thesis i would like to merge crsp with compustatcrsp merged. Introduction to wrds and using the webinterface to. Book value per share 25 calendar year 27 canadian index code 27 canadian index code current 27 capital expenditures compustat business information files 28 footnote codes 28 capital expenditures restated 28 capital expenditures statement of cash flows 28 annual footnote code 29. Crsp 2,201,325 obersevations 31 variables panel data. Depending upon the data set, coverage may extend as far back as 1950 through the most recent yearend.
This post focuses on databases and the availability of the ratio or its components. At my department everybody wonder how come it is taking more than usual for me to complete the phd and on the job market people will be. Indicator variables at the bottom of the table identify these observations. Second, the ability of variables deflated by current market values. Crsp mainly covers stock market data from exchanges. Estimating market value of equity with crsp and compustat. The comprehensive compustat database provides company data going back 40.
We show that firms with higher markettobook ratios face lower debt financing costs and borrow more. Compustat fundamentalsincome statement items equity book value bkvlps bkvlps. In the example code, the following variables are retrieved. In this study, we investigated the relative merits of some financial variables that have been pro. The book to market bm ratio of event t is then the log of the ratio of book. Compustat databases like global and north america have great part databases that can be used to find out what the historical composition is for indexes of stock exchanges. Lists of annual, quarterly and variable compustat north america data items.
1559 795 1132 857 1533 1371 576 337 1675 1001 1607 760 11 1097 1195 1109 99 1669 748 1513 1195 969 1385 4 1596 1248 442 1215 363 629 731 982 889 590 1410 320 1041