Saturday 04 May 2024       
  • Increase font size
  • Default font size
  • Decrease font size
  • default style
  • blue style
  • green style
  • red style
  • orange style

Our Blog - Subject 1

 

(1) Sectoral indicators vs. our company

  Share to Linkedin   Blog Index
 

Are Staff Costs of my company in line with the sector it belongs to? And what about profits? Do we have too much Stock? ...

 

The first step in our Business Analysis is to analyze how we are in relation to our sector existing data. It's not easy to know exact details of our direct competence, but there are institutions that collect general information and offer it grouped by sector and net turnover intervals in economic and financial ratios format.

 

Below we see an example of sectoral comparative, and we explain how to understand and interpret the data, and then we show how we can access to the sectoral data we are interested in.

 

 


 

An example of sectoral comparative

 

The following shows an example where several ratios for different companies have been obtained (consolidated format) and they are compared with existing values for the sector and net turnover interval these companies belong to.

In the left column we have placed, as Quartiles Statistical Distribution format, existing values for the sector, and in the right, the values obtained for the sample companies.

 

 

 


 

         
All   Operating costs, ...   Working capital   Financial results   Structure of assets   Structure of liabilities

 


 

In our example we work with ratios provided by the CBSO Bank of Spain, if the company is located in a different country it is advisable to find sectoral information for that country.

 

A ratio represents the relation between two values and, therefore, we have to interpret the result considering the values it comes from: it is not comparable a 10% profit over net turnover between two companies whose net turnover is 100 million and 1 million respectively.

 

The ratios studied in the example are obtained from different areas of Financial Statements (Balance Sheet and P & L), and sectoral reference values are calculated from data supplied by companies in all sectors, and are shown as quartiles statistical distribution:

 

 

Quartiles distribution means that for each ratio a sorted list with sample companies according to their value for that ratio is created; they are divided into four intervals and determined the cutoff values (quartiles):

 

  • Q1, 75% of companies in the sample is over this value.

  • Q2, is the median, 50% of companies in the sample is over this value and 50% down.

  • Q3, 25% of companies in the sample is over this value.

In the left image we have developed R02 ratio for our example. Looking at its value for consolidation column (Europe), this is [13.47], which means that we are in the first interval, ie, 75% of companies have staff costs higher than ours (relative to net turnover), which, initially, would point to a good management in this sense.

 

However, we must analyze many more aspects of our business to reach that conclusion: is also profit ratio the expected one? Could have a positive impact on our profitability ratio the increasing of staff costs? How is it about the budget? ...

 

The optimum position within distribution interval (to left or right) depends on the ratio; for example R05 (Economic net result / Net turnover) should be placed as close to the right as possible.

 


 

How to access to sectoral indicators?

 

  • Spain

    • CBSO Bank of Spain

       

      . Click on the link above to access to the page Sectoral Rates of non-financial corporations.

      . From there click on Consult the Sectoral Rates...... to access European Committee of Central Balance Sheet Data Offices.

      . Fill in the required fields and press Continue.

      . A dialog is displayed where you can choose Sector of activity, Financial year, Size and Country.

      . Pressing on Consult a pdf file with the requested results is shown, in case of difficulty try with a different browser.

       

      You can also visit CBSO homepage and access to a really interesting information.

  • Other countries

    • From CBSO Bank of Spain you can access to sectoral information of other countries (Germany, Austria, Belgium, France, Holland, Italy, Portugal, Poland ...), this information is provided in a most general level about companies sectoral classification.


      If you know how to access this type of information in other countries you can use the comments area to be included and so it can be useful to other visitors of the blog.

 


 

If you are a member of Linkedin you can share this article using the attached button.

  Share to Linkedin   Go to top

 


 

Comments area

 

 

Please enter your comments or feedback
*
*
  *
  * Mandatory fields
   
 

 

     

Fernando:

  • Post realmente interesante. Gracias por compartir la información y facilitar el acceso a los datos de la Central de Balances del Banco de España. He localizado los datos para mi empresa y he desarrollado  algunos de los ratios propuestos y al analizarlos nos hemos llevado  alguna sorpresa con respecto a nuestra competencia.

Respuesta:

  • Muchas gracias Fernando. Desde aquí os animamos a crear informes automatizados que analicen periódicamente los ratios que creáis conveniente comparativamente con los de vuestra competencia más directa y a niveles sectoriales más generales.

 


 

         
Copyright © 2024 Keypress Software Inc. All Rights Reserved.