Saturday, July 20, 2013

Compare Asset Turnover across Different Sectors

In the article “Calculate Asset Turnover Ratio”, we explained what asset turnover ratio is and why it is important to a company. We also used Caterpillar’s real net income statement and balance sheet to show how to calculate a company’s asset turnover ratio. Furthermore, in the article “DuPont Equation and Its Implication”, it is showed that actually asset turnover ratio is one of the components that affect company’s return on equity. In this article, we are going to compare asset turnover ratio across different sectors to see if asset turnover ratio difference exists or not.

Methodology


Sector Categorization


We categorize companies into nine sectors based on Yahoo Finance definition. The nine sectors are Basic Materials, Conglomerates, Consumer Goods, Financial, Healthcare, Industrial Goods, Services, Technology, and Utilities.

Company Selection


Among all tradable companies, we choose those that can be traded by options. The reason for that is because we would like to select companies that have certain liquidity. The company that can be traded by options means that they have certain liquidity. Currently there are 2825 companies that is option tradable.

Profit Margin Calculation


1. use Stock Financial Statements Download (SFSD) to batch download all target companies’ most recent net income and balance sheet statement
2. calculate each company’s asset turnover ratio by formula: Revenue/Average Total Asset
3. Compile the calculated company asset turnover according to the sector it belongs to
4. use the median asset turnover number of the specific sector to represent the sector’s profit margin
Note the median is used instead of average to avoid the distortion due to long tail distribution

Result


Following table is the calculation result
 
image

There are several observations we can make from this table:
1. Among those 9 sectors, Consumer Goods and Services have high asset turnover ratio
2. If we take a look at the compiled data from article “Compare Profit Margin across Different Sectors”, consumer goods and service sectors have low profit margin.
3. For Consumer Goods sectors, we do expect to see low profit margin and high asset turnover ratio because consumer products tend to have low profit margin and company earns profit by high volume sales. As for Services sector, need to investigate further to find out the reason.
4. Financial Sector has extremely low asset turnover ratio

Further Analysis


We can further breakdown the data more into different industries inside each sector. Click here to download the raw data
By investigating industry breakdown data, we can found out the reason why Services sector also has high asset turnover ratio is because some industries in Services sector are actually retailers such as drugs wholesale. The real ‘service’ industries such as business service and management service do have low asset turnover ratio and that’s what we expect.
Following is the screenshot of asset turnover ratio distribution among Services sector.
 
image



















Monday, July 8, 2013

Stock Daily Quotes Tracker V 1.12 Available Now


We are pleased to announce that the Stock Daily Quotes Tracker (SDQT) version 1.12 is released! ! If you have purchased this software before, you can upgrade to the latest version simply by visiting out website or clicking ‘Help->Check Version’ from software.
 

What’s New in Version 1.12


Improved Connection Stability

For the version before 1.12, the internet connection is not stable. Sometimes the software will simply freeze for a very long time when retrieving stock quotes from Yahoo Finance website. This problem has been solved.
 

Retrieve Stock Information from Popup Menu

Before version 1.12, the only way to retrieve particular stock information is to double click the row the symbol from table. Now users can click ‘Get Info’ from popup menu to retrieve stock information
 

Show Time for Next Update

Now the status bar will show clearly the time next update will happen.
Following is sample screenshot to show the new features
 
image
 
If you haven’t purchased the Stock Daily Quotes Tracker yet, you can download the lite version here to give it a try with absolutely no cost