United parcel service inc ups book value per share. The book value per preferred share is calculated by dividing the call price or par valueplus the cumulative dividends in arrears by the number of outstanding preferred shares. Bm book to market ratio book values are from compustat and market value is from cec test121 at florida international university. Dec 15, 2009 15 december 2009 suraj diamonds face value of share rs. Estimating a firms market value of common equity mve at a given point in time is something that a finance researcher does quite often. 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. As indicated in table 3, differences between compustat and xbrl reported salesrevenue amounts existed with respect to seven of the twentyseven companies approximately 26% included in the sample. When you are using compustat to download data for a number of companies you will probably get missing data for some companies even though the variables you selected for the output are relatively common items. These regressions look at all stocks listed on the compustat database and. The classification is determined by comparing a companys pricetobook ratio to the median.
Bm book to market ratio book values are from compustat and. Misvaluation exploitation predicts that the documented mispricing will be the greatest for equity transactions, since equity securities are the most sensitive to perceived changes in firm value. It can be surprisingly hard using only the two commonly available datasets for financial and stock information, crsp and compustat. Hello everyone, im trying to merge compustat global annual data with compustat global security data by gvkey. Find the latest book value per share for united parcel service inc ups. Book value of equity per share bvps is a ratio that divides common equity value by the number of common stock shares outstanding. Enterprise value is total company value the market value of common equity, debt, and preferred equity minus the value of cash and shortterm investments.
There are several reasons why this happens and i will discuss some of these here for active companies. We prefer the shareholders equity numbers as reported by compustat compustat item seqq. Incorporate index fundamental data, economic and sector data, insider trading and. Crspannual updatecrspcompustat mergedfundamental annualsupplemental data items csho. For the marketto book ratio we need the number of shares outstanding, end of year stock price, and book value of equity. Deutsche bank aktiengesellschaft db book value per share. Fundamental updates, compustat classic, earnings, cash flow and revenue estimates additional subscriptions required. With regard to ftp delivery, in addition to your current set of files, you may retain a backup set of files from the. For the markettobook ratio we need the number of shares outstanding, end of year stock price, and book value of equity. Book value of equity, also known as shareholders equity, is a firms common equity that represents the amount available for distribution to shareholders.
Book value per share tells investors what a banks, or any stocks, book value is on a pershare basis. The easiest way to find all companies both active and inactive is using the filtering options at the top of the search screen at step 1 and 2 in wharton. We will use sic and download all firmyears with the same sic. Consider the information contained herein to be a starting point. The book value of equity per share is a financial measure which indicates a per share estimation of the minimum value of an entitys equity. Common equity is adjusted by the preferred stockholders legal claims against the company. Compustat can provide total return information for 5years period and along with the companys 10k report. Nov 11, 2019 however, bankruptcy nearly always eliminates all equity, so there is no residual book value for investors to be paid. The table is based on all sample observations firmquarters where earnings compustat quarterly data item 8 and net operating cash flows compustat quarterly data item 108 are available for the current quarter and the market value of. To arrive at this number, subtract liabilities from assets.
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. The book value of equity concept is rarely used as a measurement within a business. Be is the book value of stockholders equity, plus balance sheet deferred. Oct 09, 2015 when you are using compustat to download data for a number of companies you will probably get missing data for some companies even though the variables you selected for the output are relatively common items. The results indicate that the natural log of book tomarket equity has significant explanatory power with respect to subsequent stock returns in crosssectional regressions. 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. Compustat global has several options to find all companies from a specific country.
Book value of equity consists of two main components that we expect contain differ. In addition to information from annual reports compustat also offers securityequity information in several partdatabases. If youre calculating for book value per share, take that number and divide by number of shares outstanding. Microsoft book value per share analysis book value per share bs is can be calculated by subtracting liabilities from assets, and then dividing it by the total number of currently outstanding shares. How to compute the book value of equity accountingtools.
The second way is to just value the equity stake in the business, and this is. How to calculate the book value with compustat fundamentals. Google market to book and return on assets versus industry. In other words, divide the applicable equity by the number of shares. Financial firms and firms involved in major mergers compustat footnote. This item represents the common shareholders interest in a company in the event of liquidation of company assets. The book value of equity represents the equity of shareholders from a balance sheet perspective less the preferred stock. Book value per share equals total assets minus total liabilities divided by total outstanding shares. The results indicate that the natural log of booktomarket equity has significant explanatory power with respect to subsequent stock returns in crosssectional regressions. Equal to its original cost its book value minus depreciation and amortization. Find the latest book value per share for deutsche bank aktiengesellschaft db. Crspannual updatecrspcompustat mergedfundamental annual miscellaneous items capex capx. Estimating market value of equity with crsp and compustat. How to use compustat global for daily stock returns.
Book value per share is a widely used stock evaluation measure. To calculate market value for the population in compustat global ive ended up using. Earnings, retained earnings, and booktomarket in the cross section. Compustatfundamentalscash flow items capital intensity capx at capx. It is calculated by the company as shareholders equity book value divided by the number of shares outstanding.
The book value per share is the value each share would be worth if the company were to be liquidated, all the bills paid, and the assets distributed. The comprehensive compustat database provides company data going back 40 to 50 years on over 65,000 securities, as of 2010. In addition to information from annual reports compustat also offers security equity information in several partdatabases. However, bankruptcy nearly always eliminates all equity, so there is no residual book value for investors to be paid. Fortunately, the absolute dollar value differences noted were not material assuming a 1% hypothetical level of materiality based on individual. Please note that this feature requires full activation of your. Enterprise value is likely to grow to about 1250 b in 2020, whereas book value per share is likely to drop. I am experiencing difficulties finding the right items to calculate the book value of a firm from the compustat fundamentals quarterly. Book valueshare book value per share represents fiscal year end common equity liquidation value divided by fiscal year end common shares outstanding. How to figure the book value of bank stock finance zacks. Stockholders equity is the value reported by moodys or compustat, if it is available. Price is from crsp, shares outstanding are from compustat if available or crsp. Using the compustat manual, we identify four such accrual items.
Total assets total liabilities and stockholders equity 0. Although the book value of equity per share is a factor that can be used by the investors to determine the value of stock, it presents only a limited value of the firms situation. May 29, 2019 book value can also refer to the amount that investors would theoretically receive if an entity liquidated, which could be approximately the shareholders equity portion of the balance sheet if the entity liquidated all of its assets and liabilities at the values stated on the balance sheet. Compustat is a registered trademark of the mcgraw hill. For return on assets we will use net income and end of year total assets. Advocates of market leverage argue that the book value of equity is primarily a. The book value of equity is equal to total assets minus total liabilities, preferred stocks, and intangible assets. To calculate bvps, divide the total book value of equity by the number of outstanding shares. Cshoi from gfunda prccd from compustat global securities daily i have two points im unsure about and that i would greatly appreciate your thoughts on. This calculation is often modified to exclude intangible assets, because they are not readily convertible to cash, in which case the calculation is. Mar 28, 2017 for investors an important measure is the book value of equity per share bvps. Its most common application is by investors on a per share basis when evaluating the price at which a publiclyheld companys stock sells. Mar 28, 2017 book value per share equals total assets minus total liabilities divided by total outstanding shares. This calculation is often modified to exclude intangible assets, because they are not readily convertible to cash, in which case the calculation is called the tangible book value per share.
322 1382 304 1208 1237 439 1294 915 1383 96 143 259 72 1302 1406 802 1341 140 512 711 698 137 1231 1055 1144 554 1068 364 645 1009 426 1398 1117