| Literature DB >> 31667265 |
Luciano Rossoni1, Alex Ferreira Gonçalves1.
Abstract
This data article incorporates, in an unbalanced panel data, five variables types: financial and market; board structure; board network and social capital; ownership and governance level; the cost of capital. The dataset is formed of 6024 firm-level annual observations based on 622 Brazilian public companies investigated between the years of 2002 and 2015, totaling 56 variables. A three-level data structure was created to allow aggregate directors and network board data into the panel data. Directors' data and adjacency matrix are included to allow for multilevel hierarchical analyzes as well as the use of analytical methods of social networks.Entities:
Keywords: Board interlocking; Corporate finance; Corporate governance; Director interlocks; Ownership structure; Social capital; Social networks; Stock market
Year: 2019 PMID: 31667265 PMCID: PMC6812178 DOI: 10.1016/j.dib.2019.104502
Source DB: PubMed Journal: Data Brief ISSN: 2352-3409
Fig. 1Brazilian companies investigated annually. Note: The sum of the market capitalization is represented on the right vertical axis (R$ 1,00 ≅ US$ 0,25).
Company identification.
| Variable name | Description |
|---|---|
| Economatica_Name | Economatica's Company Description (Trading Name) |
| Company_Name | Corporate Name |
| Stock_Class | ON: Ordinary shares: grant the voting power at the company's meetings. They are always nominative. |
| Company_status | Company status in the Stock market in 2017, December. |
| Stock_Exchange_Company_Code | The code used in the Stock Market trading process. Composed of four letters related to the company name and a number that identifies the type of the share as follows: |
| CNPJ | Brazilian national registry number of legal entity. |
| Economatica_Code | Company identification number used by Economatica Software to identify each company. |
| CVM_Code | Brazilian Securities Commission (CVM) unique identification code |
| Industry | Area of companies' activity listed on the stock market. |
| Year | Indicates the year in which the variables are measured, acting as the basis of time measurement. |
Source: Economatica®.
Financial and market variables.
| Variable name | Data type | Description | Cases |
|---|---|---|---|
| Total_Assets | Real-valued numeric | Book value of Total Assets adjusted for inflation. Amounts in thousands of reais (R$). | 6024 |
| Volatility | Real-valued numeric | The calculation of the annual volatility related to the stock earnings is based on the last 12 months, adjusted for inflation. It indicates the intensity and the frequency of the oscillations in the price of an asset in a certain period, considering the series of stock daily quotations. It is the degree of variation of the share price in a given period of time, the greater the volatility the greater the risk. | 2068 |
| Liquidity | Percentage | Liquidity is the facility that stocks have to be converted into cash and can be measured by the daily volume of trades made with them. For a stock to have high liquidity, it is necessary that there be a frequent presence in the trading sessions, and simultaneously in the period with a high volume of negotiations and a high number of trades. | 6024 |
| Stock Liquidity = 100 * w/P * sqrt (n/N * v/V) at where: | |||
| p = number of days in which there was at least one business with the share within the chosen period | |||
| P = total number of days in the chosen period | |||
| n = number of deals with the share within the chosen period | |||
| N = number of businesses with all shares within the chosen period | |||
| v = cash volume with the share within the chosen period | |||
| V = cash volume with all shares within the chosen period | |||
| ROA | Real-valued ratio | Return on Asset (ROA): The ratio between the company's profitability and the total volume of its assets. It is the company's ability to use its assets to generate profit. The data was consolidated annually (2002–2015), with reference month set in December of each year. The ROA is also known as LAJIRDA, which means earnings before interest, income tax, depreciation and amortization on total assets. This measure is obtained through the equation: | 5976 |
| Ln (ROA) = Ln (LAJIR/AT), wherein: | |||
| • LAJIR = profit before interest and taxes; | |||
| • AT = book value of total assets. | |||
| Market_Value | Real-valued numeric | Market value is the amount that stock market investors are willing to pay for trading on stock exchanges related to a specific company. It is obtained by multiplying the unit value of shares by the total number of shares that make up capital stock. The amounts are presented in thousands of reais (R$), adjusted by the inflation indexes. | 4228 |
| Beta | Real-valued numeric | The Beta Index is an indicator that measures the sensitivity of an asset to the behavior of a portfolio that represents the market. It is a measure of the risk that an investor is exposed to when investing in a particular asset compared to the whole stock exchange market. | 3375 |
| Beta = (Covariance between Return on Asset and Market)/(Variance of Return on Market) | |||
| Beta High: Beta> 1 | |||
| Beta Neutral: Beta = 1 | |||
| Beta Low: Beta <1 | |||
| Current_Liabilities | Real-valued numeric | Current liabilities are obligations normally paid within one year: accounts payable, debts with suppliers of goods or raw materials, taxes to be collected (for the government), bank loans due in the next 360 days, provisions (expenses incurred, generated, not yet paid but already recognized by the company: income tax, vacation, 13th salary, etc.). Values consolidated annually and adjusted for inflation. Data in thousands of reais (R$). | 6017 |
| Long_Term_Liabilities | Real-valued numeric | Long-term liabilities are debts of a company which will be settled after the end of the following financial year. In most institutions, the “year” is considered a calendar year. Examples are financings, bills to pay, among others. Values consolidated annually and adjusted for inflation. Data in thousands of reais (R$). | 3933 |
| Floating_Asset | Real-valued numeric | Floating assets are a reference to assets and rights that can be converted into cash in the short term. Assets that may be considered as current assets include cash, bank account, financial investments, accounts receivable, inventories, prepaid expenses, bank deposits, commodities, commodities, and securities. Values consolidated annually and adjusted for inflation. Data in thousands of reais (R$). | 6017 |
| Stock | Real-valued numeric | Stock refers to all tangible assets held for sale or own use in the ordinary course of business, goods in the process of production for sale or for own use or that are intended for consumption in the production of goods for sale or own use. Values consolidated annually and adjusted for inflation. Data in thousands of reais (R$). | 5613 |
| Accounting_Asset | Real-valued numeric | Accounting Asset is the set of tangible assets and rights used to achieve the entity's activities-purposes. The assets are necessary for the development of the company's corporate purpose, such as real estate, furniture, and utensils, installations, machinery and equipment, land vehicles, air, sea and rail, among others. Values consolidated annually and adjusted for inflation. Data in thousands of reais (R$). | 6022 |
| Revenue | Real-valued numeric | Revenue is the proceeds from the sale of goods or the provision of services. Values consolidated annually and adjusted for inflation. Data in thousands of reais (R$). | 5571 |
| Tobin_Q | Real-valued ratio | The simplified Chung and Pruitt | 4228 |
| Tobin Q = (VMaO + VMaP + (VCPC - VCAC + VCE + VCDLP))/VCAT | |||
| VMaO = (Market_Value field); | |||
| VMaP = (Market_Value); | |||
| VCAT = (Total_Assets); | |||
| VCPC = (Current_Liabilities); | |||
| VCAC = (Floating_Assets); | |||
| VCE = (Stocks); | |||
| VCDLP = (Long_Term_Liabilities). | |||
| Assets_Tangibility | Percentage | It is the ratio of Fixed Assets (Stock plus Accounting_Asset) divided by Total_Assets. | 5610 |
| Sales_Increasing | Percentage | Percentage growth of revenue of one year in relation to the previous year. | 4622 |
| Consolidated annual sales amount (in thousands of reais). In order to define the sales growth of 2002, it was necessary to collect data for 2001, even though it was outside the period determined for this study. The variable was operated using the formula: | |||
| Sales Growth (t-1) = Sales Volume (t-1) - Sales Volume (t))/(Sales Volume (t-1)) |
Source: Economatica®.
Board structure variables.
| Variable name | Data type | Description | Cases |
|---|---|---|---|
| Board_Size | Count | It consists of the number of board members of company i, in a year t. | 6005 |
| Outsiders_Board_number | Count | Number of directors who do not play roles other than the role of directors. External directors are those who sit on the board of directors and do not hold management positions within the company but may be linked to groups of shareholders (mainly controlling shareholders). Also included in this group are the so-called independent directors, who are those who have no connection with management positions or shareholders. | 6005 |
| Duality | Binary | On boards with a dual structure, the CEO occupies two positions (CEO and Chairman of the board) simultaneously. The data was filtered by the director's function code (code 30 - chairman of the board and president director). | 6005 |
| CEO_in_Board | Binary | Participation of the CEO on the board in positions other than of chairman of the board. A filter was performed by the member function code, filtering codes 31 (vice president of the board and president-director), 33 (effective director and president-director) and 36 (substitute director and president-director). | 6005 |
| Busy_Directors | Count | Busy directors are those who occupy simultaneously seats on various boards, commonly called in the literature by the expression “busy directors”. We consider that those who occupy 3 or more positions on different boards are classified as “busy directors”. | 6005 |
| Busy_Board | Binary | They were classified as busy boards those boards in which more than 50% of its members participate in 3 or more different boards (busy directors). | 6005 |
Note: Aggregated data from the dataset “3_Directors_Data”, available at supplementary material.
Board social capital and network variables.
| Variable name | Data type | Description | Cases |
|---|---|---|---|
| Degree | Count | Degree or Board Interlock refers to the number of companies linked by the directors that one company shares with other companies. Thus, the centrality corresponds to the number of board members on a board who simultaneously hold positions on boards of other companies, regardless of whether the companies belong to the same controlling group or not. | 6016 |
| EigenVector | Continuous | Alpha de Bonacich (Eigenvector): Measure that evaluates the degree of centrality of a company not individually, but also considers the centrality of neighbors (councils) to compose the indicator. It conceives a hierarchy between loops with greater or lesser centralization in the network. This measure, in addition to the adjacent ties, considers the centrality of these ties, which makes it different from the Centrality of Degree. Measurement operationalized through the Eigenvector feature of the UCINET® software. | 6016 |
| Coefficient_Cluster | Percentage | Indicator that measures the local density of the network and indicates how the contacts of an actor are recursively linked together. In other words, the greater the number of clicks they form (mutual ties between at least 3 participants), the larger the grouping of the network. This indicator ranges from 0 to 1, where the coefficient “0” indicates fully ungrouped networks while the coefficient “1” indicates fully clustered networks. This measure will be calculated for each year of the company's participation in the stock exchange. | 6016 |
| Efficiency | Percentage | Burt's measure of the effective size of the ego's network (essentially, the number of alters minus the average degree of alters within the ego network, not counting ties to ego). | 6016 |
| Social_Capital (Thousands_of_Reais) | Continuous | Resources immersed in the network of social relations between Boards of Directors through the so-called board's interlocks, accessed or/and mobilized in intentional actions through the interaction of the network and the resources present in it | 6016 |
| Heter_Social_Capital (Thousands_of_Reais) | Continuous | To reach indirect relations, we performed the structural holes procedure, which generated the redundancy value of each direct relation in relation to each of the network companies. The concept of redundancy is based on the following principle: If A is connected to B and C, and B is connected to C, the tie from A to B is redundant, because actor A can influence B through C. The measure of redundancy calculates, for each actor, how much of the other actors in the network are also connected to another actor. To say that the tie from A to B is highly redundant means that most of the other actors in the network also have a tie with B. Actors in networks with high redundancies are actors that are in networks with few “structural holes.” We then reduce the value 1 of the redundancy value found for each company (of each Alter), thus generating a heterogeneity score for each alters. The greater the heterogeneity, the greater the number of structural holes present in the network. As the last step, this heterogeneity value was multiplied by the market value of each existing tie. Finally, the value of the relational resources of each tie of the company was added. The financial data was collected on Economatica software. Values in thousands of Reais (R$). | 6016 |
Source: Brazilian Securities and Exchange Commission (CVM), Reference Forms and Annual Information (IAN).
Note: Network variables generated from adjacency matrices “2.1_Board_Social_Capital_Network_Data” and “2.2_Board_Heterogeneous_Social_Capital_Network_Data”, available at supplementary material. Variables processed by the UCINET® software.
Ownership and governance level variables.
| Variable name | Data type | Description | Cases |
|---|---|---|---|
| ADR_Name12 | Nominal | American Depository Receipt (ADR) are certificates that represent the shares of a foreign (non-US) company traded on the New York or NASDAQ stock exchanges. In addition to making it easier for Americans to invest in foreign companies without worrying about exchange rate changes, foreign exchange trading rules, and language, ADRs serve as indicators of a higher level of governance that are associated with lower capital costs. This variable comes from the cross-data of the CVM database with JP Morgan through the website | 419 |
| ADR_Level12 | Nominal | Identifies the Level of ADR. It should be noted that the ADRs classified as Levels 2 and 3 were used. Levels 1 and N144A were not considered, since there is no requirement to register with the Securities and Exchange Commission (SEC) or to comply with the Generally Accepted Accounting Principles (GAAP), thus having greater risk, making it difficult to compare them with other investments due to the difference in accounting. It is also important to highlight the basic difference between Level 2 and Level 3 ADRs. Level 2 requires partial compliance with GAAP and Level 3 requires full attendance. We emphasize that only Level 2 and 3 ADRs can be listed on the New York Stock Exchange, the American Stock Exchange or NASDAQ. This variable comes from the cross-data of the CVM database with JP Morgan through the website | 419 |
| Bovespa_Classification³ | Nominal | Refers to B3 governance levels, namely: “New Market”, Level 2, Level 1, “Bovespa Plus” and “Traditional” market. | 6024 |
| Percentual_Biggest_Owner_ON4 | Percentage | The largest shareholder's ownership of the company's voting shares. | 4275 |
| Sum_3_Largers_Owners_ON4 | Percentage | Sum of the three largest shareholder's ownership of the company's voting shares. | 4275 |
| Sum_5_Largers_Owners_ON4 | Percentage | Sum of the five largest shareholder's ownership of the company's voting shares. | 4275 |
| Percentual_Biggest_Owner_PF | Percentage | The largest shareholder's ownership of the company's preferred shares. | 2614 |
| Sum_3_Largers_PF4 | Percentage | Sum of the three largest shareholder's ownership of the company's preferred shares. | 2614 |
| Sum_5_Largers_PF4 | Percentage | Sum of the five largest shareholder's ownership of the company's preferred shares. | 2614 |
| HHI_3_Largers_ON4 | Ratio | The concentration of property is measured by means of an adaptation of the Herfindahl-Hirschman Index (HHI). This index is usually used to measure the degree of competition in a particular industry, but it is also used as a measure of the concentration of ownership in a given company. Their values range from 0 to 1, where the higher the index, the higher the concentration. It is calculated by summing the square of the individual voting shares owned by the three largest shareholders. It is defined as HHI: | 4275 |
| HHI_5_Largers_ON4 | Ratio | The concentration of property is measured by means of an adaptation of the Herfindahl-Hirschman Index (HHI). This index is usually used to measure the degree of competition in a particular industry, but it is also used as a measure of the concentration of ownership in a given company. Their values range from 0 to 1, where the higher the index, the higher the concentration. It is calculated by summing the square of the largest individual voting shares owned by the five largest shareholders. It is defined as HHI: | 4275 |
| HHI_3_Largers_PF4 | Ratio | The concentration of property is measured by means of an adaptation of the Herfindahl-Hirschman Index (HHI). This index is usually used to measure the degree of competition in a particular industry, but it is also used as a measure of the concentration of ownership in a given company. Their values range from 0 to 1, where the higher the index, the higher the concentration. It is calculated by summing the square of the individual preferred shares owned by the three largest shareholders. It is defined as HHI: | 2614 |
| HHI_5_Largers_PF4 | Ratio | The concentration of property is measured by means of an adaptation of the Herfindahl-Hirschman Index (HHI). This index is usually used to measure the degree of competition in a particular industry, but it is also used as a measure of the concentration of ownership in a given company. Their values range from 0 to 1, where the higher the index, the higher the concentration. It is calculated by summing the square of the individual preferred shares owned by the five largest shareholders. It is defined as HHI: | 2614 |
| Class_Ownership1 | Nominal | This field identifies whether the company is: National Private, Foreign Private or Public. This identification was made for each year of the survey, that is, from 2002 to 2015, since some companies changed ownership type during the analyzed period. For the definition of the type of property, we use the common shares, that is, those that give right to the vote. The definition for the classification of a company as “foreign” used the criterion of the Brazilian Central Bank and several international organizations, which considers the company as foreign when more than 10% of its shares are controlled by foreign capital. The companies classified as Public comprise exclusive public companies and mixed capital companies where the State has share control. | 6024 |
Source: 1 Brazilian Securities and Exchange Commission (CVM); 2 JP Morgan; ³ B3 Stock Exchange; 4 Economatica®.
Note: Concentration of property variables produced by the authors.
Cost of capital variables.
| Variable name | Data type | Description | Cases |
|---|---|---|---|
| Cost_of_Capital (MEAN)_RPEG_Ex_Ante | Ratio | Cost of Capital RPEG: Proxy obtained according to Price-Earnings to Growth model. | 814 |
| Cost_of_Capital (MEAN)_RPEF_Ex_Ante | Ratio | The Ex-Ante RPEF cost of capital data was collected from the Thomson Reuters Eikon platform and found in the database in decimal values. According to Espinosa and Trombetta | 847 |
| Cost_of_Capital (MEAN)MPEG_Ex_Ante | Ratio | Proxy obtained according to the model Modified Price to Earnings Growth model. According to Easton | 503 |
| Cost_of_Capital (MEAN)_WACC_Ex_Post | Ratio | Cost of Capital WACC (Weighted Average Cost of Capital - Ex-Post): Weighted average cost of equity and third-party capital. In terms of the coefficient, the cost of capital represents a minimum rate that the company must obtain in its operations, which indicates the minimum necessary remuneration to be earned to maintain the value of its shares and the respective sustainable growth of the company. This way of measuring the cost of capital is called Ex-Post and assumes the following expression | 2628 |
Source: Thomson Reuters Eikon.
Note: Cost of capital variables produced by authors.
Fig. 2Relationship between three level datasets.
Specifications Table
| Subject area | |
| More specific subject area | |
| Type of data | |
| How data was acquired | |
| Data format | |
| Experimental factors | |
| Experimental features | |
| Data source location | |
| Data accessibility | |
| Related research article |
The dataset panel incorporates firm-level variables on board interlock, financial and market indicators, corporate governance, and ownership structure. The data can be useful for assessing the combined effect of corporate governance, board social capital and networks on financial and market performance on emerging financial markets. As we organized the data into a three-tiered structure, company, directors, and dyads, it is possible to analyze how the emergence of the board interlock is imbricated with indicators of corporate governance and performance. As the dataset panel presents a horizon of 14 years with a large number of publicly traded companies, hypotheses about temporal dynamics and structural breaks are possible. The data are useful for studies of different theoretical perspectives, such as agency theory, network theory, institutional theory, and corporate finance. |