Paper: arXiv 2504.05912
Authors: Mike Hernandez-Romero, Germà Coenders
Abstract
This study analyzes the financial resilience of agricultural and food production companies in Spain amid the Ukraine-Russia war using cluster analysis based on financial ratios. This research utilizes centered log-ratios to transform financial ratios for compositional data analysis. The dataset comprises financial information from 1197 firms in Spain’s agricultural and food sectors over the period 2021-2023. The analysis reveals distinct clusters of firms with varying financial performance, characterized by metrics of solvency and profitability. The results highlight an increase in resilient firms by 2023, underscoring sectoral adaptation to the conflict’s economic challenges. These findings together provide insights for stakeholders and policymakers to improve sectorial stability and strategic planning.
Complexity vs Empirical Score
- Math Complexity: 5.0/10
- Empirical Rigor: 3.0/10
- Quadrant: Lab Rats — high math complexity, limited empirical testing
Why this score: The paper uses compositional data analysis (centered log-ratios) and cluster analysis, which involve advanced statistical methods (moderate math complexity), but the empirical side is limited to analyzing a static dataset of financial ratios without backtesting, simulations, or code implementation, focusing on descriptive results for stakeholders.
Research Flowchart
flowchart TD A["Research Goal: Assess financial resilience of Spanish agri-food firms<br>amid Ukraine-Russia war"] --> B["Data Collection<br>1197 firms (2021-2023)"] B --> C["Compositional Transformation<br>Centered Log-Ratios (CLR) of financial ratios"] C --> D["Compositional Cluster Analysis<br>Group firms by solvency & profitability"] D --> E["Cluster Identification<br>Silhouette validation"] E --> F["Key Findings:<br>• Distinct clusters (Resilient, Stable, Vulnerable)<br>• Resilient firms increased by 2023<br>• Sectoral adaptation insights"] F --> G["Outcomes: Policy & Strategic Planning"]
Evidence Card
What the authors claim, on what data, and who has checked it. Read from the paper's own text by a language model: every quote is verbatim, nothing was re-run. How to read this card
Proposes
The paper proposes using compositional data analysis with centered log‑ratio transformations to cluster financial ratios of Spanish agricultural and food production firms.
Source sentence
This research utilizes centered log-ratios to transform financial ratios for compositional data analysis.
Assumes 3
- Financial ratios can be treated as compositional data, allowing CoDa methodology to be applied. model
Source sentence
To overcome these limitations, this study employs the Compositional Data (CoDa) methodology (Aitchison, 1982; 1983; 1986; Pawlowsky-Glahn et al., 2015).
- Zero values in accounting data can be imputed using the Expectation‑Maximization algorithm for log‑ratios. statistical
Source sentence
The most widely used imputation method in compositional financial analysis is the Expectation-Maximization (EM) algorithm for log-ratios, developed by Palarea-Albaladejo and Martín-Fernández (2008).
- A three‑cluster solution is the most appropriate grouping, as indicated by silhouette width and Caliński‑Harabasz indices. model
Source sentence
In this case, a three-cluster solution maximizes both criteria, indicating the most appropriate grouping for the present analysis. 14 Figure 1.
Data
- SABI database fundamentals commercial
Source sentence
The dataset comprises financial information from 1197 firms in Spain's agricultural and food sectors over the period 2021-2023. The financial data used in this study was obtained from the Sistema de Análisis de Balances Ibéricos (SABI, accessible at https://sabi.bvdinfo.com) database.
Costs
Not applicable
Finds 5
- Resilient firms increased by 2023, indicating sectoral adaptation to the war’s economic challenges. performance
Source sentence
The results highlight an increase in resilient firms by 2023, underscoring sectoral adaptation to the conflict's economic challenges.
- Three distinct financial profiles were identified: conservative (Cluster 1), high‑risk leveraged (Cluster 2), and balanced (Cluster 3), with Cluster 3 being the most resilient. statistical
Source sentence
The cluster analysis identified three distinct financial profiles: conservative (Cluster 1), high-risk leveraged (Cluster 2), and balanced (Cluster 3). Cluster 3 is the most resilient.
- Firms experienced financial strain in 2022 with a drop in profitability measures, but recovered and surpassed pre‑war performance levels by 2023. performance
Source sentence
5. Conclusions and discussion The analysis of financial ratios reveals that, although firms in some of the industries experienced financial strain in 2022 with a drop in profitability measures, they demonstrated remarkable resilience, leading to recovery and even surpassing pre-war performance levels by 2023. This recovery indicates the sector's ability to adapt and overcome the economic disruptions caused by the
- The debt maturity ratio consistently decreased over the three‑year period. statistical
Source sentence
The debt maturity ratio experienced a consistent reduction over the three-year period.
- K‑means clustering of standard financial ratios placed 99.64 % of observations in a main cluster, with two tiny outlier clusters (0.33 % and 0.03 %). statistical
Source sentence
A k-means cluster analysis of the standard financial ratios in Equations 2 to 13 resulted in a cluster containing 99.64 % of observations and two clusters containing only outliers (0.33 % and 0.03 % of observations respectively).
Checked by others
No other paper in the archive has been found to support or contradict these findings (compared with 26 related papers). Coverage is partial, so this is neither replication nor refutation.
1 paper in the archive
Code
No repository by the authors found in the paper.
Extracted 2026-11-14 · same card as JSON · A language model chose these items: check the source sentence before relying on one.