Book to market compustat item

For additional information, please see the about section. Earnings before extraordinary items divided by assets ib at. Booktomarket, retained earnings, and earnings in the. Book equity is constructed from compustat data or collected from the moodys industrial, financial, and utilities manuals. The book value of common equity can be decomposed as follows, with the compustat data items in brackets. The book to market ratio is used to find the value of a company by comparing the book value of a firm to its market value. Hundreds of data items, ratios, concepts and annual data history from 1987 are included.

Compustat global includes coverage of over 96% of european market capitalization and 88% of asian market capitalization. I am experiencing difficulties finding the right items to calculate the book value of a firm from the compustat fundamentals quarterly. Booktomarket, retained earnings, and earnings in the cross section. How to calculate the book value with compustat fundamentals quarterly. For example, investopedia provides a growthmispricing. The classification is determined by comparing a companys pricetobook ratio to the median. Book equity is constructed from compustat data or collected from the moodys industrial, financial, and utilities. Earnings is total earnings before extraordinary items, from compustat. Be is the book value of stockholders equity, plus balance sheet.

Bp is calculated as the ratio of book value of common equity b to the market value of common equity p. Looking up data items in compustat can be tedious when you have to scroll. Crspannual updatecrsp compustat mergedfundamental annual miscellaneous items. Price is from crsp, shares outstanding are from compustat if available or crsp. Ratios, values and other instruments from the balance sheet compustat. Market value is the current stock price times all outstanding shares, net book value is all assets minus all liabilities. Earnings before extraordinary items divided by assets ibat. Availability of market index data specific uses for the compustat business information file 15 segment classifications 15 compustat business information files 17 segment naics file 19 naics reference file codes 20 reference file of sic codes 20 database comparability 21. Book value per share common equity liquidation value. Employees compustat business information segment item value files. Firm size, booktomarket ratio, and security returns. Wharton research data services wrds provides the leading business intelligence, data analytics, and research platform to global institutions enabling comprehensive thought leadership, historical analysis, and insight into the latest innovations in research. Leverage and the booktoprice effect in stock returns.

Market return 31 market to book fiscal year endquarter end 32 treasury stock number of common shares 32. An empirical investigation ofthe ohlson valuation dynamics. My solution is to multiply the crsp market value with the last known ratio of compustat to crsp market value. Understanding the compustat north america database 2. Looking up data items in compustat can be tedious when you have to scroll along the long lists of data items. Compustatfundamentalsbalance sheet items firm size log.

Market equity size is price times shares outstanding. The market to book ratio, or price to book ratio, is used to compare the current market value or price of a business to its book value of equity on the balance sheet. Ratios, values and other instruments from the balance. Appendix unless otherwise noted, data are from the compustats. Compustatfundamentalsbalance sheet items income before extraordinary items ib ib. Compustatfundamentalsincome statement items interest on longterm debt uxintd uxintd. Book value of assets at minus book value of common equity ceq plus 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.