In general, compustat requires that a firm has some number of years of history as public company before including it in the dataset. Because analyst forecast data start in january 1976, the re portfolios start in. Book equity is constructed from compustat data or collected from the moodys industrial, financial, and utilities manuals. Compustat series are calculated for the fixed sample of 643 firms that have all data. That can tell you if the company has borrowed too much to be a profitable investment. 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. The market value is the current stock price of all outstanding shares i. Data year compustat business information files 62 debt capitalized lease obligations 62 annual footnote codes 62 debt consolidated subsidiary 63 annual footnote codes 63 debt convertible 63 annual footnote codes 63 debt debentures 64 annual footnote codes 64 debt due in one year 64 debt finance subsidiary 65 annual footnote codes 65 debt maturing in 2nd, 3rd, 4th, and 5th years. Each factor is calculated from base compustat values, whose numbers are given. The market to book ratio also called the price to book ratio, is a financial valuation metric used to evaluate a companys current market value relative to its book value.
For our purposes it is important to use the book value, because we. Several screening variables are preselected to produce one record per gvkeydatadate pair, while keeping the vast majority of records. Debt in current liabilities longterm debt due in one year. Bm book to market ratio book values are from compustat and market value is from cec test121 at florida international university. Unless otherwise noted, data are from the compustats fundamentals annual data. Ratios, values and other instruments from the balance. Examples of excluded rows include those with restated data, different views of the same data pro forma, prefasb. Long term debt dltt plus debt in current liabilities dlc, divided by assets at. This compustat data item includes equity securities that are. I need this ratio for all the uk companies of last 15 year and i am not sure about which variables and.
I am calculating tobins q value using compustat data for firm i and year t. Long term debt market value of assets ldm ldm is the ratio. It can be surprisingly hard using only the two commonly available datasets for financial and stock information, crsp and compustat. The wharton research data service wrds data set and. The definition of book value per share for companies is discussed first. Net debt is the book value of a companys gross debt less any cash and cashlike assets on the balance sheet. Covers accounting data for public and private companies.
Market to book ratio price to book formula, examples. Hi, i am struggling to calculate market to book ratio tobins q from compustat. How to find book value of a debt on a balance sheet. Bm book to market ratio book values are from compustat and.
Mom cumulative past return cumulative return to the stock between month t2 and t12. The ability of retail order imbalances to predict future returns is twice as large on days sa research is published, and the relation is stronger for articles that generate more comments or are written by skilled contributors. Understanding the compustat north america database 2. Book value per share 28 calendar year 30 canadian index code 30 canadian index code current 30.
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. How can we calculate market value of equity and book value. I am experiencing difficulties finding the right items to calculate the book value of a firm from the compustat fundamentals quarterly. Ratios, values and other instruments from the balance sheet. Under the current financial reporting standards, companies may be required to measure their debts at fair value. Annual data industrial crsp the center for research. This figure is fully adjusted for all subsequent stock splits and stock dividends. Book value of debt can be found in balance sheet i. How to calculate the book value with compustat fundamentals quarterly. In this case you can choose to match data from compustat with data from datastream. Book value of an asset is the value at which the asset is carried on a balance sheet and calculated by taking the cost of an asset minus the accumulated depreciation. Second thing is that how can we calculate book value of total debt.
Debt defined this way should never be negative, but there are some errant compustat observations. Compustat fundamentalsincome statement items interest on longterm debt uxintd uxintd. Compustat fundamentalsbalance sheet items firm size log. The market value of debt, market versus book value of debt.
Smith amir sufi the first part of this appendix describes the process of collecting covenant violation data from 10k and 10q sec quarterly filings for the universe of compustat. Sources of data 9 compustat documentation 10 whats in this guide. A data appendix university of california, riverside. Market value of equity plus book value of pref stock and debt divided by book value of total assets wc03451, wc03251, wc03051, wc02999 also see. Long term liabilities are long term debt dltt longterm debt total, deferred taxes txdb deferred taxes, balance sheet zero or absent, maybe depends on company and capital leases in compustat there are cld2 due in 2nd yr cld3. Estimating a firms market value of common equity mve at a given point in time is something that a finance researcher does quite often. Lev leverage longterm debt dltt plus shortterm debt dlc divided by equity value, all items from compustat annual. All accounting related data are obtaine d from compustat quarterly and annual file.
Kahle stulz appendix american economic association. In the case of compustat global the fundamentals annual part database does not have these two price variables. In this section we detail our data sources and define the control variables. Empirical research typically relies on book rather than market value of debt, though theory is virtually always in terms of market value.
Leverage and the booktoprice effect in stock returns. Plus, we have different access methods depending on your requirements and usage reports to evaluate value to budget. Aapl, including valuation measures, fiscal year financial statistics, trading record, share statistics and more. Introduction to wrds and using the webinterface to. Compustat business information files the compustat business information files are companions to the. Compustat item seq, long term debt and debt in current liabilities and qis the ratio of total assets, the market value of equity from crsp as of scal year end, minus the bookvalue of equity and deferred taxes compustat items ceq and txdb to total assets. In practice, the difficulty of measuring a firms cost of debt and the lack of precision around the firms rental expenses and. How can we calculate market value of equity and book value of. Variable name definition age number of years since crsp listing source. Longterm debt dltt plus debt in current liabilities dlc divided by book value of assets. Book value of assets at minus book value of common equity ceq plus the. Obsolete compustat quarterly data schema chapter 5 of quantitative equity portfolio management by qian, hua, sorensen discuss a set of factors that derived from the compustat quarterly data.
Crsp valuation market capgdp market cap divided by gdp series gdpa from the u. Data appendix for creditor control rights, corporate. The definition for this item differs for companies and indexes. The data may be a little out of date now especially in light of changes to accounting. The market value of equity which i call meq is seq stockholders equity minus ceq book common equity plus the market value of equity.
If not, we measure stockholders equity as the book value of common equity plus the par value of preferred stock, or the book value of assets minus total liabilities in that order. Data appendix for creditor control rights, corporate governance, and firm value greg nini david c. I am grateful that i had access to the wrds databases. Appendix unless otherwise noted, data are from the compustat s fundamentals annual data on wrds. It includes notes payable, longterm debt and the current portion of long term debts. In the example i use here i used a list of isin codes of current aex index companies from datastream. Stockholders equity is the value reported by moodys or compustat, if it is available. 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. Sales, gross income, book debt, and interest are from the compustat industrial and research data files.
It provides more than 300 annual and 100 quarterly income statement, balance sheet, statement of cash flows, and supplemental data items on more than 24,000 publicly held companies. The book value of net debt typically approximates its market value. All of our data sets are available via flexible delivery options to power your research and analysis. Gross debt is simply the sum total of the book value of a companys debt. Estimating market value of equity with crsp and compustat. This paper measures the market value of debt and assesses how using book value of debt as a proxy for market value of debt may have serious effects in. Appendix unless otherwise noted, data are from the compustats. Calendar yearend data versus fiscal yearend data crsp follows calendar regime and compustat follows fiscal regime e. Investment research is increasingly produced outside of wall street. The full data set consists of annual compustat data from 1971 to 2006 for publicly. Looking up data items in compustat can be tedious when you have to scroll along. Compustat fundamentalsincome statement items equity book value bkvlps bkvlps.
1041 1437 1506 515 691 994 1331 127 584 805 1451 1248 756 1406 1330 100 1315 708 419 194 967 1321 363 500 1557 392 722 1445 957 1223 1527 632 1055 1068 373 979 253 736 300 1254 856 114 678