Business - Financial benchmarks for 43 industries by turnover band 2016

Stats NZ

Definitions

Interquartile range: Benchmark ratios are produced from the unit(s) that are located at the median (50th percentile), at the first quartile (25th percentile), and the third quartile (75th percentile). The range of values between quartile 1 and quartile 3 is known as the interquartile range. The interquartile range enables users who are benchmarking their business against these figures to see if the differences between their ratio and the benchmark ratios are relatively large (outside the interquartile range) or relatively small (within the interquartile range).

Gross Profit Ratio:
Gross profit divided by sales and/or services. Gross profit indicates how much profit is made after paying for the cost of goods sold (the direct costs attributable to the production of goods and supplies such as inventory and stock).

Stock Turnover Ratio:
Cost of goods sold divided by ((opening stock plus closing stock)divided by 2)). Stock turnover, also known as inventory turnover, represents the number of times stock is sold and replaced within a year. This is ROUNDED.

Salaries and Wages / Turnover Ratio:
Salaries and wages divided by (sales and/or services plus interest received plus dividends plus rental and lease payments plus other income). This ratio represents the percentage of turnover income that is spent on labour costs. It can be an indicator of whether a business is spending too much or too little of its turnover income on staffing the business.

Return on Total Assets:
Total current year taxable profit divided by total assets. This ratio tests the efficiency of investment in fixed assets and is a measure of how effectively the business has converted these assets into net income.

Return on Total Equity:
Total current year taxable profit divided by total proprietor or shareholder funds. The return on equity represents the rate of return earned on the owner’s equity and investment.

Current Ratio:
Total current assets divided by total current liabilities. This ratio gives an indication of a business’s ability to pay its short term liabilities.

Quick Ratio:
Total current assets minus closing stock divided by total current liabilities. The quick ratio, also known as the acid test, is very similar to the current ratio, but excludes stock. It tests a business’s ability to pay short-term debt from immediately convertible or liquid assets.

Liabilities Structure:
Total proprietor or shareholder funds divided by (total proprietor or shareholder funds plus total liabilities). The liability structure ratio represents equity solely as a proportion of equity plus liabilities. A low ratio indicates a low level of owner’s equity in the business, and a higher risk to debt holders.

Data calculation/treatment

Benchmark ratios are calculated using Inland Revenue tax data. All businesses supplying financial statements and tax returns are included, where the turnover for those businesses is between $60,000 and $10 million. Stats NZ provide benchmark ratios at the mid-points (medians), the 25th and 75th percentile (Interquartile ranges). Half the businesses in a turnover band will be below the mid-point (or median), and half will be above. Quarter of the businesses in a turnover band will be below the 25th percentile and quarter will be above the 75th percentile.
Size bands are based on turnover. Stats NZ produce four even quarters of the industry population based on the number of businesses to help you find the most comparable indicators for your business size (i.e. micro, small, medium, or large). A minimum of 30 responding units in each quartile (120 per industry) is required for an industry’s ratio to be published.

Limitations of the data

These statistics are released with a caveat because of limitations in the data, they are of a lower standard than official statistics the department releases. This is because AES sample are selected and weighted at an AES industry level and not at an ANZSIC level. This data is indicative only, and may be subject to revisions in the future.
These statistics do not claim to present a picture of the total New Zealand economy. Some industrial activities are entirely excluded and others are under-covered with regard to smaller business units, particularly those that fall below the threshold for compulsory GST registration. These figures exclude GST.

Inclusions

This dataset is limited to 43 industries based on the ANZSIC classification (Level 4).

Data provided by

Stats NZ

Dataset name

Business Performance Benchmarker: Benchmark ratios 2016

Webpage:

https://shinyapps.stats.govt.nz/bpb/

How to find the data

At URL provided, select the 'Benchmark ratios' tab from the top menu, then 'Download benchmark ratios for all industries' from the green left-hand pane.

Import & extraction details

File as imported: Business Performance Benchmarker: Benchmark ratios 2016

From the dataset Business Performance Benchmarker: Benchmark ratios 2016, this data was extracted:

  • Sheet: Tabular format
  • Range: G6:AD177
  • Provided: 4,128 data points

Dataset originally released on:

August 25, 2017

About this dataset

Stats NZ has calculated the industry benchmarks using information provided on financial statements and tax returns. All businesses supplying financial statements and tax returns are included in the calculation of standard performance range, where the turnover for those businesses is between $60,000 and $10 million inclusive.

Turnover bands have been calculated to produce four even quarters of the industry population. This allows you to find the most comparable indicators for your size of business (ie. micro, small, medium, or large based on turnover).
For some industries, changes in indicators are not consistent with the change in business turnover/size. This may happen because business turnover is not the only factor influencing values of particular indicators (ie. operating structure, and geographic location can also influence indicator values).
Inland Revenue supplies each business's financial returns and attachments to Stats NZ, who use this information to calculate the industry benchmarks. Stats NZ does not return any information about any specific business data to Inland Revenue, nor anything that could be used to identify any individual to Inland Revenue.