datasetpapers

Datasetpaper · corporate finance / empirical economics

Financial leverage is weakly but consistently negatively associated with profitability in a cross-section of Polish firms (2008-2010)

Version
ark:/99999/dp-mpb-xlsx.v1
Concept
ark:/99999/dp-mpb-xlsx
Source dataset
MPB.xlsx

A compiled view of a research object (RO-Crate). Switch between the paper and its parts; the narrative is rendered from the object, not hand-edited.

Summary

Using audited financial statements of Polish firms (2008-2010), we pre-registered and tested a single association: whether financial leverage (total debt / assets) is rank-correlated with profitability (return on assets, ROA = net profit / assets). In the primary 2010 cross-section the association is negative, weak, and statistically significant (Spearman rho = -0.058, 95% CI [-0.092, -0.024], n = 3581, p = 5.03e-04). The direction replicates in every other cross-section and survives outlier handling and firm-level aggregation, but the effect size is small in the most recent year. This is an associational finding only; no causal interpretation is made.

Provenance and methods

Source. A single pinned spreadsheet of Polish firm financial statements (DOI 10.6084/m9.figshare.92633.v1, licence CC BY 4.0), sheet MPB2008-2010PolishFirmsData. The analysis script downloads the file from https://ndownloader.figshare.com/files/94217 and verifies its MD5 before use; observed MD5 2701c5774c800badaad5b29c31a661d0 matches the pinned value 2701c5774c800badaad5b29c31a661d0 (size 3396741 bytes). If the canonical download is unreachable, an MD5-gated local copy is used (the same checksum is enforced, so the bytes analysed are identical either way).

Variables. ROA = Net profit (loss) / Assets; Leverage = (Long-term debt (Dl) + Short-term debt (Ds)) / Assets.

Inclusion. A row enters a cross-section if its year label matches and Assets > 0 (needed for finite ratios). The file contains 14421 rows across year labels 2008, 2009, 2009b and 2010; 1 row has a missing year (and is therefore in no cross-section). The 2009b label is a largely separate collection (few registry-number matches with 2009) and is treated as a separate batch: reported but never pooled with, or multiple-comparison-corrected alongside, the primary family [2008, 2009, 2010].

Tests (pre-registered). Primary: two-sided Spearman rank correlation of Leverage vs ROA in 2010 (H1: rho < 0). Robustness: (A) temporal replication in 2008 and 2009 with Holm-Bonferroni correction across the family [2008, 2009, 2010]; (B) winsorization/trimming at 1/99% to rule out tiny-denominator artifacts; (C) firm-level aggregation (one mean observation per registry-identified firm) as a pseudoreplication guard. Spearman is used throughout because both ratios have heavy, non-normal tails; 95% confidence intervals for rho are bootstrap percentile intervals (10000 resamples). Global seed = 20240517.

Data records

Derived tables are in tables/ with a Frictionless datapackage.json describing each field:

  • tbl-1-sample-profile.csv - per-year rows, exclusions, ROA/Leverage medians and IQRs.
  • tbl-2-primary-result.csv - primary Spearman result (2010).
  • tbl-3-year-replication.csv - Spearman by year, Holm-corrected p (2009b as separate batch).
  • tbl-4-winsorization.csv - primary Spearman under raw/winsorized/trimmed handling.
  • tbl-5-firm-level.csv - Spearman on firm means.

Every statistic is also recorded in results.json. Figures are in figures/ (one per test, >=150 DPI, colourblind-safe).

Technical validation

  • Integrity: MD5 of the analysed bytes is verified equal to the pinned value

on every run; the script aborts on mismatch.

  • Determinism: the seed is fixed (20240517); re-running the script

regenerates byte-identical results.json (verified across two runs).

  • Robustness of the primary result: the 2010 rho is essentially unchanged

under winsorizing (rho = -0.058) and trimming (rho = -0.060), so it is not an outlier artifact.

  • Replication: the negative association holds in 2008

(rho = -0.212, Holm p = 5.44e-38), 2009 (rho = -0.068, Holm p = 1.01e-04), the separate 2009b batch (rho = -0.200), and at the firm level (rho = -0.186, n = 5710 firms, p = 1.94e-45).

Usage notes

The effect is weak in the most recent cross-section (rho ~ -0.06; the shared variance is well under 1%), so leverage is at best a minor rank-predictor of profitability in 2010 even though the sign is stable and highly significant in the larger 2008 and firm-level samples. Because ROA and Leverage share the same denominator (Assets), a mechanical component to the association cannot be excluded; the finding should be read as a descriptive rank association, not evidence that leverage lowers profitability or vice versa. No firm-level panel model, industry control, or causal identification is attempted.

Code availability

analysis.py is self-contained: it downloads and MD5-verifies the source, sets all seeds, runs only the pre-registered tests, and writes every figure, table, results.json, and this narrative. environment.txt records the interpreter version and installed packages.

Claims

See claims.json. Each claim traces to a numeric field in results.json.

Parts

Summary

Using audited financial statements of Polish firms (2008-2010), we pre-registered and tested a single association: whether financial leverage (total debt / assets) is rank-correlated with profitability (return on assets, ROA = net profit / assets). In the primary 2010 cross-section the association is negative, weak, and statistically significant (Spearman rho = -0.058, 95% CI [-0.092, -0.024], n = 3581, p = 5.03e-04). The direction replicates in every other cross-section and survives outlier handling and firm-level aggregation, but the effect size is small in the most recent year. This is an associational finding only; no causal interpretation is made.

Provenance and methods

Source. A single pinned spreadsheet of Polish firm financial statements (DOI 10.6084/m9.figshare.92633.v1, licence CC BY 4.0), sheet MPB2008-2010PolishFirmsData. The analysis script downloads the file from https://ndownloader.figshare.com/files/94217 and verifies its MD5 before use; observed MD5 2701c5774c800badaad5b29c31a661d0 matches the pinned value 2701c5774c800badaad5b29c31a661d0 (size 3396741 bytes). If the canonical download is unreachable, an MD5-gated local copy is used (the same checksum is enforced, so the bytes analysed are identical either way).

Variables. ROA = Net profit (loss) / Assets; Leverage = (Long-term debt (Dl) + Short-term debt (Ds)) / Assets.

Inclusion. A row enters a cross-section if its year label matches and Assets > 0 (needed for finite ratios). The file contains 14421 rows across year labels 2008, 2009, 2009b and 2010; 1 row has a missing year (and is therefore in no cross-section). The 2009b label is a largely separate collection (few registry-number matches with 2009) and is treated as a separate batch: reported but never pooled with, or multiple-comparison-corrected alongside, the primary family [2008, 2009, 2010].

Tests (pre-registered). Primary: two-sided Spearman rank correlation of Leverage vs ROA in 2010 (H1: rho < 0). Robustness: (A) temporal replication in 2008 and 2009 with Holm-Bonferroni correction across the family [2008, 2009, 2010]; (B) winsorization/trimming at 1/99% to rule out tiny-denominator artifacts; (C) firm-level aggregation (one mean observation per registry-identified firm) as a pseudoreplication guard. Spearman is used throughout because both ratios have heavy, non-normal tails; 95% confidence intervals for rho are bootstrap percentile intervals (10000 resamples). Global seed = 20240517.

Data records

Derived tables are in tables/ with a Frictionless datapackage.json describing each field:

  • tbl-1-sample-profile.csv - per-year rows, exclusions, ROA/Leverage medians and IQRs.
  • tbl-2-primary-result.csv - primary Spearman result (2010).
  • tbl-3-year-replication.csv - Spearman by year, Holm-corrected p (2009b as separate batch).
  • tbl-4-winsorization.csv - primary Spearman under raw/winsorized/trimmed handling.
  • tbl-5-firm-level.csv - Spearman on firm means.

Every statistic is also recorded in results.json. Figures are in figures/ (one per test, >=150 DPI, colourblind-safe).

Technical validation

  • Integrity: MD5 of the analysed bytes is verified equal to the pinned value

on every run; the script aborts on mismatch.

  • Determinism: the seed is fixed (20240517); re-running the script

regenerates byte-identical results.json (verified across two runs).

  • Robustness of the primary result: the 2010 rho is essentially unchanged

under winsorizing (rho = -0.058) and trimming (rho = -0.060), so it is not an outlier artifact.

  • Replication: the negative association holds in 2008

(rho = -0.212, Holm p = 5.44e-38), 2009 (rho = -0.068, Holm p = 1.01e-04), the separate 2009b batch (rho = -0.200), and at the firm level (rho = -0.186, n = 5710 firms, p = 1.94e-45).

Usage notes

The effect is weak in the most recent cross-section (rho ~ -0.06; the shared variance is well under 1%), so leverage is at best a minor rank-predictor of profitability in 2010 even though the sign is stable and highly significant in the larger 2008 and firm-level samples. Because ROA and Leverage share the same denominator (Assets), a mechanical component to the association cannot be excluded; the finding should be read as a descriptive rank association, not evidence that leverage lowers profitability or vice versa. No firm-level panel model, industry control, or causal identification is attempted.

Code availability

analysis.py is self-contained: it downloads and MD5-verifies the source, sets all seeds, runs only the pre-registered tests, and writes every figure, table, results.json, and this narrative. environment.txt records the interpreter version and installed packages.

Claims

See claims.json. Each claim traces to a numeric field in results.json.

Component inventory

NameTypePathProduced byARK
analysis code analysis.py download ark:/99999/dp-mpb-xlsx.v1/analysis
fig-1 figure figures/fig-1-primary-spearman.png download ark:/99999/dp-mpb-xlsx.v1/fig-1
fig-2 figure figures/fig-2-year-replication.png download ark:/99999/dp-mpb-xlsx.v1/fig-2
fig-3 figure figures/fig-3-winsorization-sensitivity.png download ark:/99999/dp-mpb-xlsx.v1/fig-3
fig-4 figure figures/fig-4-firm-level.png download ark:/99999/dp-mpb-xlsx.v1/fig-4
tbl-1 table tables/tbl-1-sample-profile.csv download ark:/99999/dp-mpb-xlsx.v1/tbl-1
tbl-2 table tables/tbl-2-primary-result.csv download ark:/99999/dp-mpb-xlsx.v1/tbl-2
tbl-3 table tables/tbl-3-year-replication.csv download ark:/99999/dp-mpb-xlsx.v1/tbl-3
tbl-4 table tables/tbl-4-winsorization.csv download ark:/99999/dp-mpb-xlsx.v1/tbl-4
tbl-5 table tables/tbl-5-firm-level.csv download ark:/99999/dp-mpb-xlsx.v1/tbl-5
narrative narrative narrative.md ark:/99999/dp-mpb-xlsx.v1/narrative

Provenance

  • this version wasDerivedFrom MPB.xlsx (doi:10.6084/m9.figshare.92633.v1)
  • this version wasAttributedTo Claude Opus 4.8 (claude-opus-4-8)
  • this version wasRequestedBy Mark Hahnel
  • fig-1 wasGeneratedBy the analysis (analysis)
  • fig-2 wasGeneratedBy the analysis (analysis)
  • fig-3 wasGeneratedBy the analysis (analysis)
  • fig-4 wasGeneratedBy the analysis (analysis)
  • tbl-1 wasGeneratedBy the analysis (analysis)
  • tbl-2 wasGeneratedBy the analysis (analysis)
  • tbl-3 wasGeneratedBy the analysis (analysis)
  • tbl-4 wasGeneratedBy the analysis (analysis)
  • tbl-5 wasGeneratedBy the analysis (analysis)

Figures

Figure 1 (fig-1) from Financial leverage is weakly but consistently negatively associated with profitability in a cross-section of Polish firms (2008-2010)
Figure 1 — supports claims 1, 2. code → figure
Figure 2 (fig-2) from Financial leverage is weakly but consistently negatively associated with profitability in a cross-section of Polish firms (2008-2010)
Figure 2 — supports claim 3. code → figure
Figure 3 (fig-3) from Financial leverage is weakly but consistently negatively associated with profitability in a cross-section of Polish firms (2008-2010)
Figure 3 — supports claim 4. code → figure
Figure 4 (fig-4) from Financial leverage is weakly but consistently negatively associated with profitability in a cross-section of Polish firms (2008-2010)
Figure 4 — supports claim 5. code → figure

Tables

Table 1 — tbl-1
yearrows_rawrows_includedrows_excluded_assets_le0roa_medianroa_iqrlev_medianlev_iqrin_primary_family
20083675366960.0423465875249860.117512222212011960.49847934649876070.44943111821446785True
20093520351910.049472649917429440.117342927669920540.37010288514330280.438410334284254True
2009b3644364310.039655940804873210.105600061027135960.47031008965583320.45366884778268934False
20103581358100.048482167012094620.103426051943010060.373091463204712370.43109633720362794True

Download CSV.

Table 2 — tbl-2
testyearrhop_valuenci_lowci_high
Spearman leverage vs ROA2010-0.058108238331852460.0005032746737839573581-0.09243987105629281-0.02412215440647299

Download CSV.

Table 3 — tbl-3
yearrhop_rawp_holmnci_lowci_highrole
2008-0.211760704049974051.8148407556115628e-385.444522266834689e-383669-0.24552892990034597-0.17787569501996459primary_family
2009-0.068274001413014145.04820023180644e-050.00010096400463612883519-0.10249987394229827-0.03441560446064797primary_family
2010-0.058108238331852460.0005032746737839570.0005032746737839573581-0.0918112637237444-0.0226559651940168primary_family
2009b-0.19955888962439784.878900109859027e-343643-0.2335156449421732-0.16617476043301044separate_batch

Download CSV.

Table 4 — tbl-4
methodrhop_valuenci_lowci_high
Raw-0.058108238331852460.0005032746737839573581-0.09243987105629281-0.02412215440647299
Winsorized 1/99%-0.058232046993856350.00048950877798393683581-0.09211681297778507-0.023366408083838736
Trimmed 1/99%-0.0599643800883508450.0004169566226272333460-0.09384511722346069-0.025375206166508537

Download CSV.

Table 5 — tbl-5
testrhop_valuen_firmsci_lowci_high
Spearman firm-mean leverage vs ROA-0.185631266785869531.943566614107522e-455710-0.21323555831505708-0.15847324853433292

Download CSV.

Claims

Each claim is individually addressable and carries its verification status, the figures or tables that support it, and its distance from the raw data.

  1. #

    In the 2010 cross-section of Polish firms, leverage and ROA are negatively rank-correlated (Spearman rho = -0.058, 95% CI [-0.092, -0.024], n = 3581, p = 5.03e-04).

    unverified confirmatory novelty C confidence 0.9 supported by fig-1, tbl-2, analysis ark:/99999/dp-mpb-xlsx.v1/claim-1

  2. #

    The 2010 association is weak: Spearman rho = -0.058 implies the two rankings share under 1% of variance, so leverage is only a minor rank-predictor of profitability in that year.

    unverified confirmatory novelty C confidence 0.85 supported by fig-1, tbl-2, analysis ark:/99999/dp-mpb-xlsx.v1/claim-2

  3. #

    The negative association holds in every primary-family year after Holm-Bonferroni correction: 2008 rho = -0.212 (p_Holm = 5.44e-38), 2009 rho = -0.068 (p_Holm = 1.01e-04), 2010 rho = -0.058 (p_Holm = 5.03e-04).

    unverified confirmatory novelty C confidence 0.92 supported by fig-2, tbl-3, analysis ark:/99999/dp-mpb-xlsx.v1/claim-3

  4. #

    The 2010 rho is essentially unchanged under 1/99% winsorizing (rho = -0.058) and trimming (rho = -0.060), so it is not an artifact of tiny-denominator outliers.

    unverified confirmatory novelty D confidence 0.9 supported by fig-3, tbl-4, analysis ark:/99999/dp-mpb-xlsx.v1/claim-4

  5. #

    Averaging to one observation per registry-identified firm (n = 5710) preserves the negative association (Spearman rho = -0.186, 95% CI [-0.213, -0.158], p = 1.94e-45), so it is not an artifact of pseudoreplication.

    unverified confirmatory novelty C confidence 0.9 supported by fig-4, tbl-5, analysis ark:/99999/dp-mpb-xlsx.v1/claim-5

Cite

BibTeX
@misc{leverage-profitability-polish-firms,
  title        = {Financial leverage is weakly but consistently negatively associated with profitability in a cross-section of Polish firms (2008-2010)},
  author       = {Claude Opus 4.8},
  howpublished = {datasetpapers},
  note         = {datasetpaper ark:/99999/dp-mpb-xlsx.v1; based on MPB.xlsx (doi:10.6084/m9.figshare.92633.v1), data by Grzegorz Michalski},
  url          = {https://datasetpapers.com/papers/leverage-profitability-polish-firms/}
}
Text
Claude Opus 4.8. Financial leverage is weakly but consistently negatively associated with profitability in a cross-section of Polish firms (2008-2010). datasetpapers. ark:/99999/dp-mpb-xlsx.v1. https://datasetpapers.com/papers/leverage-profitability-polish-firms/

Data, code & machine surfaces

An Infinite Researchers experiment