Expansion of the current methodology for the study of the short-term liquidity problems in a sector

Purpose: The aim of this work consists of defining and applying a new methodology for the calculation of short-term financial ratios that more reliably approximate the solvency of a sector. Design/methodology: We begin with a classic sector analysis and propose the creation of ratios that limit the debt repayment on an individual level and that do not imply the compensation of aggregate balances, as occurs with the current formulas of calculation. Findings: The new methodology more reliably approximates the solvency of a sector by being able to estimate with greater precision its global capacity for short-term debt repayment. Research limitations/implications: The limitations to the proposed sector ratios are the same as the limitations of the customary individual ratios. Therefore, to offer an example, the ratios do not correct the assumption that the only source of resources to meet current liabilities is made up by available and liquid assets. In other words, no new tools are proposed to include future income from sales by the companies. Practical implications: To be able to study the solvency of the different sectors that make up the economy with more uniform criteria. Social implications: The information provided by the new ratios obtained in this work proves to be relevant information in the case of wanting to determine the degree of dependence of companies in a sector on financial institutions, or in the case of wanting to determine the degree of dependence on aid in a subsidized sector. Originality/value: The proposal of new tools that go beyond the current limitations.


Introduction
The Royal Spanish Academy considers the word "ratio" to be synonymous to the word "proportion" and thus defined as the quotient between two numbers, or in general, two amounts that can be compared to one another.
Although there are different ways of representing a ratio, currently the most common consists of representing it by means of a fraction written as A/B.Mathematically, the numerical value of a ratio can be interpreted as the number of times one of the numbers fits inside the other.In this interpretation, the concept of equivalence between fractions plays an important role, which makes it possible to state that in a ratio with a value 3/2 (=1.5/1), the quantity A is one and a half times quantity B, or that in a ratio with a value 1/5 (=20/100), the quantity A is 20% of B.
Financial ratios, understood as quotients between two economic magnitudes, owe their enormous expansion in accounting practice to these interpretations.They complement the information provided by the financial statements expressed in monetary units, while at the same time, they can facilitate the comparison over time, with the evolution of the company itself, and in space, as it is possible to make comparisons with other companies in the same industry.
The interest generated by the possibility of analyzing the real situation of a sector through the calculation of financial and economic ratios obtained from the aggregation of the annual accounts of companies that form it (Amat, 2016;Farreras, Linares & Rondós, 2012;Registradores de España, 2016), has resulted in the emergence of new tangential lines of research, such as the quality of accounting information, the limitations associated with the aggregation of line items and the application of analysis methodologies complementary to the ratios.
The ratios are a tool used by both scholars in their research and professionals in the study of a company or a sector.Bernstein and Wild (1999) state that in traditional financial analysis, ratios represent the final product of the research, as the diagnosis of a specific area of the company is generated based on them.The difference from predictive analysis can be seen here, in that the ratios constitute the raw material that will be processed using statistical techniques and mathematical modeling.These techniques have played a part in generating interest in ratios, leading to an explosion in their use in multiple economic studies.However, it is necessary for the scientific world to know not only about the instruments to be applied, but also accounting science in order to take advantage of their full potential.
There are many different situations in which financial ratios have been used.Among the most important lines, we can mention their use for the analysis of the performance of a company's stock (Soliman, 2008) and its assets (Nissim & Pemman, 2001;Fairfield & Yohn, 2001), and to study the evolution of a company in situations of liquidity shortfalls, such as in models predicting bankruptcy (Altman & Hotchkiss, 2006).Beaver (1966) reached the conclusion that the ratios measuring the cash flows as compared to the indebtedness of the company are the best indicators to predict the financial development of the company.
There are multiple advantages of using ratios, but the most recognized are that they allow for a comparison to be made between companies by eliminating the consequences of the divergence caused by the difference in size (Whittington, 1980;Gallizo, 2005).However, authors like Lev and Sunder (1979) state that the size effect remains unresolved when there is no strict proportionality between the numerator and denominator, and Foster (1986) warns about the importance of controlling for the effect of size differences for the effective application of ratios.There are also several authors who defend the hypothesis that the size of the company is relevant in the financial analysis and this can be undermined if we only use the analysis by ratio methodology (e.g., Serrano Cinca, Mar Molinero & Gallizo Larraz, 2005;Sudarsanam & Taffler, 1995).
The latest trends also abandon the introduction of an avalanche of ratios in financial diagnostics, eliminating the so-called pseudo-ratios for not having a causal relationship between the numerator and the denominator, which leads to different types of interpretations of the same coefficient (Lizarraga, 1996;Bukovinsky, 1993).The reality is that it has been more than demonstrated that operating with a few ratios has its benefits.
While it is possible to interpret financial ratios individually, they provide more information when compared to reference values, which can be historical for the same company, standard ratios (Westwick, 1987) or ratios for the sector to which the company belongs.Financial analysts have tried to offer users of their reports some recommended intervals in which they should position the value of each ratio; in this area, we can call attention to the contributions made by Lev (1969), who analyzes the different strategies used by companies to reach their optimal values, proposing the hypothesis that there is an equilibrium value for each ratio and in each sector, demonstrating that the ratios undergo a process of adjustment towards the optimal value, which is the response to new strategies by the company or changes in the environment.Gallizo (2005) indicates that we must treat the optimal value as a tool to be used to guide the business management.However, it is necessary to be aware that the users of this methodology can often suffer from a simplistic reduction that can undermine the diagnosis.For example, we might consider the case of interpreting the solvency ratio as part of the short-term debt that can be paid at a certain time with the balances from the investments (also short-term) that become liquid assets throughout the course of the operating cycle.If it is considered that the optimal value of this ratio must belong to the interval of "1.5" to "2," which justifies the idea that the short-term asset has a balance of around 50% or 100% above the short-term debts so that company presents prompt payment, this consideration could be understood to be excessively simplistic by not including in the study model the different maturities of both assets and liabilities that could indicate the true correlation between the investment and financing, and therefore the real liquidity requirements at each moment.The heterogeneity of the subjects with which we are working makes it difficult to make any sort of generalization that could be applied to every sector, although one of the advantages that has become evident when conducting empirical studies at the sector level is the possibility of using sector ratios as a reference for comparison with those of the analyzed company, which provides an answer as to the position of the individual company in the industry (Suarez, 1999).
The problems that have been detected when working with ratios are different in nature; first of all, we must bear in mind that they are a static magnitude that offers us a view of a company at a specific moment; the analyst must have in-depth knowledge of the peculiarities of the company for which he intends to conduct a diagnosis in order to be able to interpret its balances at the time of drawing the conclusions.One account that can undergo important variations is that of stocks, which can show divergent balances in different years for a same period, according to the purchasing policy of the company for each financial year.
The accounting data, while constituting the basic information we work with, is not by itself free of problems that can alter the image of a company; in this sense, we must refer to the evaluation criteria.There are studies (Shah & Murtaza, 2000) that indicate the divergence of results when choosing the accounting value or the market value, but we must also refer to the subjectivity that line items can present, such as in the case of amortizations or provisions and the capacity for "window dressing" that can result.
There are also problems related to the very elaboration of the ratios.In this sense, we must present the case in which the denominators are negative or close to zero (Foster, 1986).The best solution when we are faced with this circumstance is to perform an adjustment process, breaking them down into their basic magnitudes and obtaining new financial ratios that offer similar information, but that do not lead to methodological errors.
On a sector level, given that in financial ratios it is common for extreme atypical values to appear as the result of dividing by very small terms (e.g., Ezzamel & Mar-Molinero, 1990;Frecka & Hopwood, 1983;Kane, Richardson, & Meade, 1998), it is not recommendable to use the mathematical mean of the sector ratios as a parameter to represent the set of companies in the industry.This is due to the fact that the extreme values can distort the interpretable results of an aggregate function that is sensitive to them.Oliveras and Moya (2005) warn that if any of the ratios for a sector is very different from the sector mean, the cause must be investigated.In this sense, the present article advises that a single outlier can cause the difference.
The present work is focused on improving the financial analysis line of a sector.Specifically, the work presents an alternative to conventional calculations to study the capacity a sector has to make good on its short-term obligations.This option differs from the normal one in the way in which different short-term return ratios are obtained on the sector level.The new sector ratios offer another type of information that is more coherent with a sector's capacity for return.
The work has been organized into three parts.The first section describes the customary methodology used to study the short-term liquidity problems in a sector analysis.An alternative proposal is then presented.In the third part, to show the usefulness of the alternative sector ratio calculation methodology, a sector analysis is conducted on the Catalan agricultural sector.Finally, to conclude the work, a section is presented on the conclusions drawn and the bibliography used.

Current methodology to find the short-term sector financial ratios
Based on the use of certain financial ratios, this work focuses on the explanation of an alternative calculation used to obtain its value.The starting point for this work is the selection of the ratios to study the short-term solvency of a sector.Without sacrificing generality, three ratios have been chosen whose structure makes it possible to get an idea of the proposed alternative calculation methodology that is being presented.Specifically, the cash flow or acid test ratios, the liquidity or solvency ratios and the current asset ratio + the long-term financial asset, divided by current liabilities.Figure 1 shows its formulation with the customary abbreviations.The customary working methodology to find ratios representative of the sector to be used to establish its state of health consists of calculating the ratios for a specific period, based on the aggregation of numerators and denominators of all the companies in the sector.As a result, given the properties of linearity in the "addition" operation, the sector ratios in Figure 1 can be formulated by the expressions in Figure 2. The calculations of the ratios of a sector are represented in capital letters to differentiate them from individual company ratios For the purpose of clarifying the nomenclature, a detailed model of the calculation of the three ratios is shown with the aid of Table 2, using fictitious data as an example: Table 1.Intermediate calculations of the sector liquidity ratio for returns on liquid assets for a specific period

Proposed methodology to find the short-term sector financial ratios
The calculation of an aggregate ratio poses a fundamental problem that consists of the fact that its use cannot perfectly reflect reality (Linares-Mustarós, Farreras-Noguer, Ferrer-i-Comalat & Rabaseda-Tarrés, 2013).
Below we see a simplified example to clearly illustrate the previous statement, through the calculation of the acid test ratio.
Let's imagine a sector made up by two companies with the data from Table 2.In theory, it is evident that the two companies do not have the same capacity to return the entire amount of their liquid debt.Clearly, in a situation with an extremely pessimistic panorama in which the sector could not create any liquid assets from future sales, the table shows that the first company has the capacity to return 100% of the short-term investment, while the second company only has the capacity to return 75% of this total investment.If we calculate the aggregate acid test ratio, we would obtain a R1=30/30=1, which would lead us to believe that the sector that year has the capacity to return 100% of the short-term investment, but as we will see, in an extremely pessimistic situation, this statement would be far from the truth.Specifically, given that the first of the companies has a debt of 10 and it can return those 10, and the second company can return only 15 of its debt of 20, the total percentage of the short-term debt that can be returned under these pessimistic conditions is (10+15)/(10+20)*100=83.33...%.
Therefore, it is necessary to have an indicator that makes it possible to identify what part of the debt in a specific period the companies in a sector will be capable of returning.Studying the evolution of said indicator over time would permit obtaining new information about the variations in the sector's liquidity problems and could help governments and institutions decide which sectors could need certain types of aid.Likewise, said indicator could improve the evaluation of the results of previous aid.
In this sense, Linares et al. ( 2013) proposed a mathematical formula for a new indicator called the "liquid return sector liquidity ratio," which is defined as follows: Where E={E 1 , E 2 , E 3 ,,..., E n }, the set of companies in a specific sector whose acid tests are represented by {ra 1 , ra 2 , ra 3 ,..., ra n }.
The liquid return sector liquidity ratio is defined according to the following expression: For the purpose of clarifying the nomenclature and seeing how the ratio works, a detailed model of the calculation of the new ratio is shown with the aid of Table 3, using the fictitious data used as an example in Table 2: Table 3. Calculations of the sector liquidity ratio for returns on liquid assets for a specific period.The ratio indicates that in an excessively pessimistic scenario, the sector only has the capacity to return 65.45% of the investment made in it We can see that with the proposed formula, the option for a company to return more than 100% of what it owes to the sector is eliminated, thus making it possible to obtain a new ratio that can be interpreted as the per unit coefficient of the current liability return capacity in the sector that the group of companies can return in an extremely pessimistic scenario.
Continuing with the present idea of limiting the capacity of a company to return the entire sector debt, the ratios in Figure 1 would be formulated by the expressions in Figure 3.
Figure 3. Formula for the ratios R 1 , R 2 and R 3 , calculated aggregating data from the sector, with a limitation on the total return of each sector company

Empirical Study
To analyze the return capacity of the current liability invested in the agricultural sector, the data for the registered companies is analyzed according to the CNAE classification for Group A-Agriculture, livestock keeping, forestry and fishing, and specifically, Subgroup A01-Agriculture, livestock keeping, hunting and related services, located in Catalonia, using the SABI database.The study was conducted between the years 2006 and 2015.The database was consulted on March 10, 2017.
It should be pointed out that the data obtained from this database are from commercial companies from the subgroup that have the legal status of "sociedad limitada" (limited partnership) or "sociedad anónima" (public limited company).
The results are presented below: The first row provides the details of how the number of Catalonian companies has evolved that are dedicated to Subgroup 01 during the analyzed period.
The next two rows (R 1 and RL 1 ) show the evolution of the cash flow or acid test ratio that relates the most liquid part of the current assets (available + certain) to the current liabilities, thus eliminating the uncertainty associated with stock.If this ratio has a value of between 0.8 and 1, it is interpreted that the sector will be able to make payments on obligations of less than one year.
The traditional calculation (R 1 ) shows us a subsector that will be able to pay its debts without any problems in most years.The evolution during the years of the study has been fairly constant, with the lowest value in 2008, with 0.68 and the highest in 2006, with 0.80.
The calculation of the aggregate sector ratio (RL 1 ) reveals a subsector with problems in paying its debts.With a constant evolution of around 0.5, the largest figure (0.55) is obtained in 2006, while the smallest occurred in the years 2009 and 2012.These values show a subsector that in an extremely pessimistic scenario could only return half of its debts.
The next two rows (R 2 and R 2 ) show the evolution of the liquidity ratio, also known as the solvency, current solvency or cash flow ratio, relating the total of current assets to the total of current liabilities.It is estimated that the desirable value would be greater than 1, and if possible, around 1.5 or as much as 2.
Such widely varying values owe to the fact that this ratio depends to a great extent on the type of companies we are analyzing and the rotation of accounts receivable and stocks.
Using the traditional calculation (R 2 ), the ratios remain above 1.2 for nine years, which indicate a good liquidity situation, especially in 2012, when it exceeds 1.3.The analyzed subsector would have an appropriate payment capacity and its companies would be far from the danger of bankruptcy, at least in the short term.
The calculation of the sector aggregate ratio (RL 2 ) shows us a subsector with a compromised liquidity situation, with values between 0.75 and 0.81 for every year studied.
The next two rows (R 3 and RL 3 ) show the evolution of the ratio that relates the current asset and the financial asset (with group companies and third parties) to the current liability.This ratio takes into account not only the property and short-term rights of the company, it also considers those long-term items that are generally not related to the activity and that could quickly be converted into cash if needed.
The traditional calculation (R 3 ) reveals a subsector that has financial investments that could, if necessary, contribute to increasing its liquidity ratio (R 2 ) and provide even greater security to its investors.There is an increasing evolution over the years of the study, with the maximum value of 2.14 obtained in 2010.
If we compare the ratios R 2 and R 3 , an increase becomes evident, with values between 0.37 and 0.84.
The calculation of the sector aggregate ratio (RL 3 ) shows a constant evolution, with values of nearly 0.85.If we compare the ratios RL 2 and RL 3 , a growth becomes evident, but with values between 0.05 and 0.09, what we see is a subsector in which financial investments would obviously help in case of need, but to a very small extent.
A spreadsheet with all the data and calculations can be downloaded at this address: http://web2.udg.edu/grmfcee/RLs.xls

Conclusions
This work has shown the usefulness of an alternative methodology for calculating sector ratios.This provides more reliable information on the capacity of a sector to globally return its debt over the short term.It therefore determines with greater precision both is payment capacity and its timeliness.
The ideas are applied in a specific sector in order to find the deviations between the results that have been obtained using the classic ratios and those proposed in this work.The results have shown sufficiently disperse values that corroborate the need to implement these new indicators.
This work has important repercussions on both an academic and social level.On the one hand, the work opens new channels for determining the ideal ratio in a sector.On the other hand, the work warns that current praxis must be refined in the area of sector analysis.

Figure 1 .
Figure 1.Definition of three ratios to study the capacity a sector has to make good on its short-term obligations

Figure 2 .
Figure 2. Formulation of the ratios R1, R2 and R3, calculated aggregating data from the sector

Table 2 .
Acid test ratio of the sector

Table 4 .
Calculations of the three ratios calculated in the traditional manner and as the aggregate sector ratio for the period 2006 to 2015