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 · Sistema de Análisis de Balances Ibéricos fundamentals commercial
    2021-2023 · 1197 Spanish agricultural and food production firms
    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 The paper reports no trading or execution result.

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.

Cited by 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.