Of Interest
The Secret to Understanding and Using Benchmark Information
By Brian Hamilton, MBA, Sageworks

Of interest to many types of financial professionals, benchmarks can be extremely valuable to the financial analysis process. However, benchmarking is a tool that is only effective when data is gathered correctly, and the benchmark information is utilized properly.

“Benchmarks” are financial metrics/ratios/results, which show average ranges of financial performance by companies in a given industry. There are many different types of financial benchmarks. When using benchmarks, a primary question should be addressed: what is the average level of performance for a given ratio/metric in a specific industry? In a way, a benchmark is a scorecard against which the relative strength of a company can be assessed.

Understanding the average financial performance of specific industries is important to both accountants and bankers, who want to understand industry conditions and how the companies they are evaluating compare to other companies in a given industry. For example, credit analysts at banks use industry benchmark data as a way to assess the relative health of a given company. Valuation analysts use benchmark data to assess the future earning potential of a company. Accountants use benchmark data as a way to identify any weak areas that need to be improved by their clients.

For numerous reasons, it has been a major challenge in the U.S. to access good quality industry benchmark data. Historically, companies that have sold benchmark data were selling data gathered largely from tax return filings. Data from tax returns tends to give conservative and unrealistically low numbers for operating profits. Further, private companies in the U.S. are not compelled to publish their financial results. Consequently, access to private company data is very limited, and sources of industry data may be unreliable.

When evaluating any industry data, the following items should be assessed:

The sample size.
If the sample size of the industry being reviewed is too small, conclusions may be faulty and financial results can be skewed and incorrect. When reviewing industry data and looking at a particular company in a given sales range, also make sure there are enough sample companies in a particular sales range, i.e. even within the same industry selection there can be a different number of companies represented in each sales range. Although there are no specific “rules,” a good rule of thumb is to have at least five companies represented in each sales range.

The source of the data.
As noted previously, tax returns are generally not a good source of private company benchmark data. Real-time operating data is valuable.

The calculation of metrics.
Data providers may use different financial formulas, so it’s important to know how the numbers are calculated. For example, metrics about profitability should be carefully scrutinized because net profit formulas vary dramatically, depending on the expense and/or revenue items included, i.e. net profit before taxes, net profit before taxes amortization and depreciation, operating profit, and net income after taxes.

The age of the benchmark data.
The frequency with which a data provider updates benchmark data is critical. Older data is sometimes of very little value; therefore, know the age of the data is being used.

What are the most important financial metrics when reviewing benchmark data? These three should be at the top of the list:
  1. Net Profit Before Taxes Margin. The net profit margin is typically expressed as net profit before taxes during a given operating period divided by sales. A good way to look at net margin is to think of it as determining how many cents of profit a business extracts from each dollar it sells. There are many financial metrics that might be analyzed, but none is as important as the net profit margin.
  2. The Liquidity Ratios. There are two major liquidity ratios. The first is the Current Ratio, which is expressed as current assets divided by current liabilities. Generally, this ratio indicates the overall liquidity position of a company. There are many limitations to the Current Ratio, but it is always good to know the relative strength of a company compared to its peers. The Quick Ratio is another liquidity ratio, typically expressed as cash plus accounts receivables divided by current liabilities. Many financial professionals put more weight on the Quick Ratio because it is a better measure of a company’s very-term cash position. Again, the Quick Ratio is not a perfect indicator of liquidity, but it is helpful in understanding where a company compares relative to peers.
  3. Turnover Ratios. Three major turnover ratios should be reviewed. Accounts Receivable Turnover, measured in days, is calculated as accounts receivable divided by sales times 365 days. It roughly indicates the number of days it takes a company to convert accounts receivable to cash. The lower the number, the better. Another important turnover ratio is Accounts Payable Days, calculated as accounts payable divided by cost of goods sold times 365 days. The Accounts Payable Days ratio measures the number of days it takes to pay vendors. The third turnover ratio is Inventory Days ratio, calculated as inventory divided by sales times 365 days. The Inventory Days ratio measures the average number of days it takes to sell inventory. The lower the number, the better. Generally, these turnover ratios are good indicators. Knowing how a company compares to its peer group will give a general idea how the company is managing its resources.

Benchmarking will grow in importance as financial professionals gain access to better data and use it more effectively in making decisions.


About the Author
Brian Hamilton is the co-founder and CEO of Sageworks, where he manages overall strategy and product development. He is an original co-developer of “FIND” (Financial Information into Narrative Data), the company's core artificial intelligence technology which converts financial numbers into plain-language reports. “FIND” is the basis of ProfitCents™ and Sageworks Analyst™, applications that are used today by thousands of financial institutions and accounting firms throughout North America and the United Kingdom. He is a frequent speaker for many state CPA societies.

Top