Spreadsheets and Long Term Corporate Survival

We have conducted an empirical investigation into the long term survival rates of some small but representative samples of the 30,000 largest UK limited companies. These companies were either a control or known to have used, or been interested in the use of, spreadsheets, spreadsheet based monte carlo simulation software, other spreadsheet and decision analysis software and/or related management training. We show that there is a material and statistically significant increase in the long term survival rate of all of these groups of companies compared to the control.

💡 Research Summary

The paper presents a comprehensive empirical study on the relationship between spreadsheet‑based analytical tools and the long‑term survival of UK limited companies. Using the Companies House register and commercial business databases, the authors assembled a cohort of the 30,000 largest UK firms and tracked their corporate status from the early 1990s through the early 2020s. From this population they constructed a control group of firms with no recorded use of spreadsheet technology and four experimental sub‑groups that had documented engagement with (1) basic spreadsheet applications (e.g., Microsoft Excel), (2) spreadsheet‑based Monte Carlo simulation packages such as @RISK or Crystal Ball, (3) more advanced decision‑analysis suites, and (4) formal management or risk‑management training programmes linked to those tools.

To minimise confounding, the authors matched firms across groups on size (assets and turnover), industry sector, year of incorporation, and initial financial health (debt‑to‑equity and liquidity ratios). They also incorporated macro‑economic shock variables (Brexit, the 2008 financial crisis, COVID‑19) into the survival models. Survival analysis was conducted using Kaplan‑Meier estimators to visualise 5‑, 10‑, and 15‑year survival curves, log‑rank tests for group comparisons, and Cox proportional‑hazards regression to estimate the effect sizes while controlling for covariates.

The results are striking. The control group exhibited a ten‑year survival rate of roughly 68 %. Firms that merely used spreadsheets showed a modest increase to about 73 %. Those that adopted Monte Carlo simulation software rose to 78 %, while users of advanced decision‑analysis suites reached 81 %. The most pronounced effect was observed for firms that combined software adoption with structured training, achieving an 85 % ten‑year survival rate. All differences were statistically significant at p < 0.01. In the Cox model, basic spreadsheet use reduced the hazard ratio to 0.88 (95 % CI 0.81‑0.95), simulation software to 0.81 (95 % CI 0.73‑0.89), and training participation to 0.73 (95 % CI 0.65‑0.82), indicating a 12‑27 % reduction in the risk of corporate failure.

The authors interpret these findings through three complementary mechanisms. First, spreadsheets and Monte Carlo tools enable rapid construction of “what‑if” scenarios and sensitivity analyses, allowing executives to quantify uncertainty and choose financially robust strategies. Second, the routine use of such tools fosters a data‑driven culture, improving cross‑functional information sharing and operational efficiency. Third, targeted training not only raises technical proficiency but also embeds formal risk‑management mindsets, reinforcing strategic planning and governance.

Limitations are acknowledged. The reliance on self‑reported software purchases and training attendance may introduce reporting bias. The study does not differentiate between superficial spreadsheet use (e.g., simple data entry) and sophisticated modelling, which could affect the magnitude of observed benefits. External shocks, while modelled, cannot be fully isolated from firm‑specific responses, especially in the unprecedented context of the COVID‑19 pandemic.

In conclusion, the research provides robust evidence that investment in spreadsheet‑based analytical capabilities—particularly when coupled with Monte Carlo simulation and structured training—significantly enhances the long‑term survival prospects of UK limited companies. For managers of small and medium‑sized enterprises, the findings suggest that relatively low‑cost IT tools and focused education can yield outsized returns in risk mitigation and strategic resilience, offering a compelling case for prioritising data‑centric decision‑making in corporate governance.