Skip to main content
The Actuary: The magazine of the Institute and Faculty of Actuaries - return to the homepage Logo of The Actuary website
  • Search
  • Visit The Actuary Magazine on Facebook
  • Visit The Actuary Magazine on LinkedIn
  • Visit @TheActuaryMag on Twitter
Visit the website of the Institute and Faculty of Actuaries Logo of the Institute and Faculty of Actuaries

Main navigation

  • News
  • Features
    • General Features
    • Interviews
    • Students
    • Opinion
  • Topics
  • Knowledge
    • Business Skills
    • Careers
    • Events
    • Predictions by The Actuary
    • Whitepapers
    • Moody's - Climate Risk Insurers series
    • Webinars
    • Podcasts
  • Jobs
  • IFoA
    • CEO Comment
    • IFoA News
    • People & Social News
    • President Comment
  • Archive
Quick links:
  • Home
  • The Actuary Issues
  • April 2015
04

Spreadsheet errors prove costly for UK companies

Open-access content Wednesday 8th April 2015 — updated 5.13pm, Wednesday 29th April 2020

A third of large companies have made bad decisions as a result of poorly designed spreadsheets, according to a study.

2

Kenny Whitelaw-Jones, managing director at financial modelling firm F1F9, said "poorly constructed spreadsheets" were to blame.

A survey of 1,277 UK senior managers and C-suite executives found one in five large British businesses suffered direct financial loss because of spreadsheet mistakes. Just one in five businesses was confident their spreadsheets contained no errors.

The firm's report Capitalism's Dirty Secret found 59% of respondents admitted their companies "spent nothing" on external spreadsheet-related training in the last year.

In the finance and accounting sector, where spreadsheet analysis was seen as a "core skill", 40% of companies spent nothing on training. In addition, 30% of financial decision makers said they had never received any education.

In terms of financial costs, Whitelaw-Jones said the franchise for the West Coast Main Line had to re-tendered due to a spreadsheet error in a bidding process, which cost taxpayers around £60m.

He added spreadsheet problems caused stress for employees: "We see that from time to time there's one analyst, one individual who built this model and actually the only one person who understands it. What does it mean for that individual? It means long working hours, late nights, incredible pressure, and of course, mistakes get made."

Whitelaw-Jones explained spreadsheets were used for a variety of purposes such as budgeting, forecasting, financial reporting, capital investment decisions, pricing decisions and operation analysis.

"There isn't very much you can point to in terms of business decision making that doesn't involve spreadsheets," he said. "What the data confirms is this is happening in businesses all over in this country and by extension all over the world."

To reduce the risk in spreadsheet modelling, Whitelaw-Jones suggested companies adopt a modelling standardisation, such as the FAST Standard, an open industry standard supported by a number of accountancy and financial firms.

The report also highlighted 20 principles for good spreadsheet practice, a paper published by the Institute of Chartered Accountants in England and Wales last year.

This article appeared in our April 2015 issue of The Actuary.
Click here to view this issue
Filed in
04
Topics
Risk & ERM

You might also like...

Share
  • Twitter
  • Facebook
  • Linked in
  • Mail
  • Print

Latest Jobs

New Fast-Growing Team - Actuarial Systems Development

London (Greater)
Excellent Salary Package
Reference
143762

Actuarial Pension Consultant – Scotland/Remote – Up to £90,000 plus bonus

Edinburgh / Glasgow / Remote working
Up to £90,000 + Bonus
Reference
143761

Part Qualified Pensions Actuary– Specialised Pensions Consultancy - Scotland/Remote - Up to £70,000

Edinburgh / Glasgow / Remote working
Up to £70,000 + Bonus
Reference
143760
See all jobs »
 
 

Today's top reads

 
 

Sign up to our newsletter

News, jobs and updates

Sign up

Subscribe to The Actuary

Receive the print edition straight to your door

Subscribe
Spread-iPad-slantB-june.png

Topics

  • Data Science
  • Investment
  • Risk & ERM
  • Pensions
  • Environment
  • Soft skills
  • General Insurance
  • Regulation Standards
  • Health care
  • Technology
  • Reinsurance
  • Global
  • Life insurance
​
FOLLOW US
The Actuary on LinkedIn
@TheActuaryMag on Twitter
Facebook: The Actuary Magazine
CONTACT US
The Actuary
Tel: (+44) 020 7880 6200
​

IFoA

About IFoA
Become an actuary
IFoA Events
About membership

Information

Privacy Policy
Terms & Conditions
Cookie Policy
Think Green

Get in touch

Contact us
Advertise with us
Subscribe to The Actuary Magazine
Contribute

The Actuary Jobs

Actuarial job search
Pensions jobs
General insurance jobs
Solvency II jobs

© 2023 The Actuary. The Actuary is published on behalf of the Institute and Faculty of Actuaries by Redactive Publishing Limited. All rights reserved. Reproduction of any part is not allowed without written permission.

Redactive Media Group Ltd, 71-75 Shelton Street, London WC2H 9JQ