Company Financial
|
Look at long-term debt and total-liabilities |
! Note !
Some text and data and web-links may be added (or
changed) on this page --- if/when I re-visit this page.
About 20 more companies may be
added to the sortable table.
Sections below:
INTRO
Sortable-HTML-Table
MORE-INFO-links
CONCLUSION
|
INTRODUCTION : In trying to choose an 'optimum' set of stocks in which to invest, it is helpful to compare the financial-data of companies in which to invest. Since the financials of any company can change quite dramatically from year-to-year, due to external as well as internal conditions, I find it necessary to make investment decisions (sell as well as buy) by taking into account financial TRENDS of each company, namely trends of revenue, net-income, liabilities AS WELL AS
trends of PERCENTS and RATIOS such as
In addition, dividend-yield-percent and executive-compensation are factors that I consider. There is a 'pool' of over 6,000 stocks in which to invest. I generally look for stocks that paid a dividend for many years, while being profitable for many years. For example, I would favor Apple (which pays a dividend) over Google-alias-Alphabet and Berkshire-Hathaway (which do not pay a dividend). I have been burned several times with companies that eventually went backrupt, as their yearly profits turned to yearly losses. Almost without exception, those companies have been ones that did not pay a dividend. In almost no cases have I experienced a company going bankrupt when the company has been paying a dividend for many years and continues to do so, while remaining profitable. I do not think a company with a strong profit margin and cash-flow (like Google-Alphabet) is going to go bankrupt, BUT when I am deciding between two companies to invest in, I am going to favor the one that pays a dividend --- because, by paying a dividend, that company is paying attention to its stock investors, not just its bond holders. To help in making stock-buying (and stock-selling) decisions, there is a SORTABLE-TABLE below that provides access to data-charts (and some data-tables) of company financials for about 200-plus companies--- via links in the table. SOURCE OF FINANCIAL CHARTS: A site with lots of financial data (in nice CHARTS plotted against time in years or quarters) is the macrotrends.net site. In addition, there are some nice data-TABLES at 'macrotrends.net', corresponding to tables in annual reports --- such as 'balance sheet' tables and 'cash flow' tables. You can go to the Macrotrends Stocks Research and Analysis page and enter a stock symbol such as 'NEE' --- and get to pages such as:
You can use any of these 'TRENDS' links to go to other useful 'trends' pages, by using the tabs (and sub-tabs) at the top of these pages. Example tabs & sub-tabs:
The site 'macrotrends.net' also has a nice stock screener. SOURCE OF CEO / NEO COMPENSATION DATA: Links to 'salary.com' pages provide data on CEO compensation as well as the compensation of NEO's other than the CEO --- and even board members. Unfortunately, the 'salary.com' site does not include salary info for Canadian and other foreign companies, companies such as 'Waste Connections' and 'Canadian Pacific' and 'Canadian National Railway'. I may provide a 'keyword-web-search' link for compensation info for such companies. THE DATA IN THE FOLLOWING DATA-TABLE: The following 'snapshot' data is intended to give me a relatively rapid way to investigate the financials of the kinds of companies that I may wish to invest in --- and some that I do not want to invest in. Data on annual Revenues, Net-income, and other financial items are presented for a 'sample' year. You can click on these numeric data items to go to a 'macrotrends.com' or 'salary.com' page that gives data for a wide range of years. You might notice that there are some 'always in the news' companies missing from this data --- such as auto-makers like General Motors and Ford (periodically needing a government bailout) --- and financial institutions like Goldman Sachs and J. P. Morgan (constantly getting Federal Reserve & Congress handouts) --- and Wells Fargo (continually screwing their depositors) --- and Chipotle (periodically giving customers food poisoning) --- and sugar-sellers like Coca-Cola --- and tobacco companies. These are companies that I will probably never invest in --- for one reason or another. The data-table includes columns for:
For many companies, CEO compensation is ROUGHLY correlated to the annual revenues (company size) or number-of-employees.
NOTE:
Example: Note on When the Data 'Snapshot' is Taken: Note that the revenue and/or CEO compensation data for various years may be 'fiscal' years of each company --- not 'calendar' years. And the start and end months of 'fiscal' years may not be the same from company to company. Usually the 'macrotrends.net' data in the table is taken from the charts at calendar year-end (at or near 31 Dec) --- or within a month or two of 31 Dec. In other words, the data is usually taken from a quarter near the end of a calendar year. Note on Updating the Table: Updates to the 'Sample Year' data may occur for some companies and not others, as I update the data at various times for some of the several hundred companies. Also, when I add companies, the 'Sample Year' may be different from the 'Sample Year' used for other companies in the table. So the 'sample Year' may vary from company-to-company. Precision of the data: The numeric data are generally presented to about three (3) 'significant digit' accuracy. For some small companies, with low compensation and/or low revenues, some figures may be shown with 2 significant digits. For some kinds of data that have a lot of variablity, the numbers may be shown to 2 significant digits. Three digits are sufficient to express the reported values to within one percent accuracy (or better). For the 'rough comparison' purposes of this data, presenting more digits is 'over-kill'. Accuracy of the data: The accuracy of the data depends on how accurately the companies report their financial data in their annual reports and how accurately they report the CEO compensation data in their Proxy statements. Let the buyer beware! --- Remember Enron and Worldcom. A lot of 'fudging' can be done with data like Assets and Liabilities and Expenses. And accounting data can be moved around into various 'classes of data' that can make profits look high and liabilities look low. If you think any data item may be wrong, you can click on the link to see that data at a source. Some data can change from year-to-year or quarter-to-quarter or month-to-month or day-to-day or even second-to-second (for example, dividend-yield-percent and price-to-earnings-ratio). So you can click on the link to see the data-item at various times (in a time-series chart)--- and you can use various alternate sources of data shown on this page, like in the more-info-sources section below the table. |
|
GUIDE TO USING THE SORTABLE DATA TABLE The intent is to have at least 200 companies in this sortable data-table. It remains to be seen if I will have time to gather more data and add more companies to this sortable-HTML-table. One purpose of this HTML table is to demonstrate that the data can be quickly sorted by clicking on ANY column heading in this web page table. The data can be sorted in either ascending or descending order. Click the column heading again if it is not in the order that you want. In particular, clicking on a Revenues column heading will sort the companies from smallest to largest (in terms of revenue). Clicking again will sort from largest to smallest. Similarly, clicking on the CEO-Compensation column heading, will sort the companies according to their CEO compensation --- or chief NEO compensation in the case of companies like Berkshire-Hathaway where an NEO like a Chief-Financial-Officer (CFO) may have the largest compensation. Thus you can see the companies that have the largest CEO/NEO compensation 'rise to the top'. Various sorts can be used to help decide on a set of companies in which to invest --- according to your current criteria. When you click on a link in the table, the link-page is presented in a separate window (or tab) in the web browser. One advantage of separate windows is you can bring up the history of two different kinds of data and see how they correlate. For example, for a given company, you can click on the 'Net Income' data item and the 'CEO compensation' data-item and bring the windows side-by-side to see how the CEO-compensation compares to Net-Income over a period of several years. You can also sort the table by 'company name' or by 'stock symbol' --- the first two columns. When this web page is (re)loaded, the table rows are presented in order by company name. (Company names that start with a number are at the bottom of the table, initially.) When you are in the middle of the table and are wondering what a number represents (in a cell in a certain row and column), you can position your pointer device over the cell. A small popup window will give you a brief description of what the data item is. This should work in most web browsers --- on desktop computers, if not on mobile devices such as cell phones and tablet computers. In the table columns, 'TBD' (if any) means 'To Be Determined'. TBD entries sort to the top or bottom of the table. 'NEG' is used in the PE-ratio column when the Net-Income is negative, which would make the value of the Price-to-Earnings ratio rather meaningless. For example, a very small negative number for Earnings could make the PE-ratio a huge negative number. The tendency might be to interpret this as a very, very bad sign --- although the company may be almost 'breaking even'. Color of the columns : The columns of PERCENT and RATIO data are colored pinkish. Note that PERCENTS (like net-profit-margin) and RATIOS (like Debt-to-Net-Income and Price-to-Earnings) allow you to compare both large and small companies. The columns of 'absolute' data (such as Revenue, Net-Income, Cash-On-Hand, Longterm-Debt, Total-Liabilities, Number-of-Employees, Shares-Outstanding) are colored blueish. Note that you can sort on columns like Revenue or Number-of-Employees to rank companies according to size. Searching this data table : If you are looking for some particular information, you can use the text search function of your web browser. For example, if you are looking for information on a specific company, you can enter a character-string such as 'veriz' or 'monster' in the text search entry field of your web browser, to find info (on this page) on a company such as 'Verizon' or 'Monster Beverage'. Additional data sources : Below the data table on this page, there is a section of links to various sites that provide company data on revenue and NEO (Named Executive Officer) compensation --- and other kinds of company data. Out-of-date or Not quite to your liking? You are welcome to take this HTML page and update (and/or reformat) it as you like. Enough of these Introduction sections. The SORTABLE-DATA-TABLE follows. |
|
Some INFO on some table-data : The Debt-to-Equity Ratio The Debt-to-Equity ratio is the ratio of Longterm-Debt to Equity, where Equity is usually defined as Assets minus Liabilities. However, I do not have a lot of trust in the valuation of Assets by a company. Assets include 'intangible' stuff like 'Goodwill', which often seems to be a way of accounting for over-paying for an acquisition. Furthermore, in a bankruptcy where a company would have to sell its assets, many of those assets are probably not going to bring the values that have been carried on the books. Instead of using 'Equity', I would rather divide (Longterm) Debt by Net-Income (per year) --- which essentially tells me how many years it would take to 'cover' the debt, if this net-income persisted. The Debt-to-Net-Income Ratio One problem with the Debt-to-Net-Income ratio is when a company has negative net-income for the year. In the table, when net-income is negative for the year, 'NEG' is entered for the ratio --- just as we do for the PE-ratio, when earnings are negative. Another problem is that Net-Income can swing wildly from year-to-year, often because of sudden unforseen expenditures --- such as pandemics, hurricanes, floods, big construction projects, big legal settlements, etc. The Revenue for a company is usually more stable than its Net-Income. So, as an alternative to the Debt-to-Net-Income ratio, it would be nice to use a Debt-to-Revenue ratio --- but 'with a twist'. The Debt-to-0.1*Revenue Ratio We note that it would be nice if a company could achieve a Net-Income of about 10% of its Revenue. This would help us evaluate a company (and compare it to other companies) even if the company is going through a period of negative Net-Income. We note that some companies like grocers and discount retailers (like Costco, Walmart, Target, Pricesmart --- with a large grocery business) have a profit margin of about 2 or 3 percent --- not 10 percent. In that case, the Debt-to-0.1*Revenue Ratio gives us an idea of how many years it would take to cover the Debt, IF the company COULD achieve a 10% profit margin. We note that other companies (tech companies, like successful semiconductor companies and successful pharmaceutical companies) may have profit margins closer to 20 or 30 percent --- not just 10 percent. In that case, the Debt-to-0.1*Revenue Ratio gives us an idea of how many years it would take to cover the Debt, IF the company fell on hard times and its profit margin dropped from 20 or 30 percent to about 10 percent. The Longterm-Debt and Total-Liabilites Some companies are reported to have zero long-term-debt, but this may be a bit of an exaggeration --- the debt may simply be very low compared to items like Equity and Net-Income and Revenue. As a bit of a check on assuming no-debt when long-term-debt is reported as zero, the table shows a column for Total-Liabilites --- next to the column for Long-Term-Debt. You can check the company 'Balance Sheet' in their annual (10-K) report to the SEC to see some details on the components of 'Total-Liabilities'. Some LINKS for more information : Some more information on these companies may be available at their web sites --- and their 10-K reports may be available at the SEC web site at sec.gov, where SEC = Securities and Exchange Commission. The site capedge.com provides SEC filings (such as 10-K annual reports and proxy statements, which include executive compensation data) in convenient lists of links to relevant documents. You can use the 'Search' field at the top of the 'capedge.com' home page. Enter a stock symbol or company name. The '10-K' annual reports and 'DEF 14A' annual proxy statements are readily available. The site macrotrends.net is a good source of revenues data for any given company --- for multiple years on one web page per company. You can enter a company name or stock symbol --- such as AAPL --- in the 'Search' field of the web page at www.macrotrends.net / stocks / research and, in a drop-down menu, of options such as
you can choose the 'Revenue' line, and see a barchart of revenues over multiple recent years --- along with a summary of percent increase/decrease over the past few years. Thus you can compare revenues (or other financial results) of a company against NEO compensation as seen at the salary.com site. You can also use the site macrotrends.net as a good source of number of employees 'trend' data for any given company --- for multiple years on one web page per company --- in a barchart. The 'Number of Employees' graph can let you know if the company has been hiring and, thus, let you know if the company has been performing well. To get to the 'Number of Employees' graph, can go to the 'Revenue' page for the company, and see a graph of revenues over multiple recent years. At the top of the 'Revenue' page is a set of 'tabs' with labels such as:
If you click on 'Other Metrics', you will see the two 'sub-tabs':
You can click on the 'Number of Employees' sub-tab, and see a barchart of the number of employees over multiple recent years --- along with a summary of percent increase/decrease over the past few years. You can hold the cursor over any of the bars, in the number-of-employees barchart, to see a popup-box that shows the number of employees in that year. Check out the 'Dividend Yield History' while you are 'at it'. The site salary.com is a good source of executive compensation for any given company --- for multiple years for various NEO's of the company. You can enter a company name in the 'Search' field of the web page at www.salary.com / personal / executive-salaries/ and get a breakdown of compensation of the NEO's into
Some sites may give slightly different values for compensation and revenues and other financial data in any given year. Different sources may use different methods to arrive at various numeric data items. So it may behoove you to double-check the data using different data sources. You can do various web searches on various companies to get further information on their revenues and compensation. For example, using Apple Inc as a sample company, here are some example queries.
Additionally, you can get further information on many companies at Wikipedia --- for example, Alliant Energy (Wikipedia link). You can use these WEB SEARCH and Wikipedia links, and change the company name for info on other companies. Furthermore, there are many more links to financial information and charts on the Stock Price Histories web page of this site. As mentioned above, you are welcome to take a copy of this web page and add/change/correct data --- and/or re-organize the page as you wish --- and/or add more information-links --- and publish it on your own web site. |
|
In CONCLUSION: VOTE THOSE PROXIES! If you want to help put the brakes on the rapidly accelerating 'pay inequities' and 'income gap', do not throw away those 'proxies' without voting them. It is easy to vote via the internet. It just takes a small number of clicks or pokes at a 'proxy vote' web site. In particular, almost every proxy includes a 'say on pay' item in the 'voting instruction form' --- worded something like this: 'Advisory vote to approve executive compensation.' OR 'To approve, on a non-binding advisory basis, the compensation of the named executive officers.' Typically you are offered the options: 'For', 'Against', or 'Abstain'. Or the options: 'For' or 'Withold'. If you think pay increases of 100's of thousands of dollars per year are unwarranted (especially after a mediocre or bad year --- or yearS), then vote 'Against' or 'Withold'. It is only 'advisory' --- but if enough people vote this way, mountains can be moved. By the way, those voting forms usually include a list of Board Directors to be elected or re-elected. Since the Directors are complicit in outlandish CEO and NEO compensation practices, if you vote 'Against'/'Withhold' on executive compensation --- to be consistent --- you should vote 'Against'/'Withhold' on election of Board Directors. |
|
Bottom of this To return to a previously visited web page location, click on the Back button of your web browser, a sufficient number of times. OR, use the History-list option of your web browser. OR ...
< Go to Top of Data Table, above. >
Page history:
Page was created 2023 May 02. |