Mistakes made when handling spreadsheets can result in exorbitant financial losses and irreparable damage to the reputation of the companies involved.
Spreadsheets have become indispensable in the business world, helping companies organize and manage their finances and daily operations. However, this powerful tool is not exempt from human error.
In this article, we'll explore four emblematic cases where Excel errors generated devastating financial consequences.
Fannie Mae - $1.1 Billion Error
In 2003, Fannie Mae, a U.S. mortgage company, discovered a $1.136 billion error in total shareholder equity.
When implementing new accounting standards, it's common for companies to face challenges with the complex calculations required by the new system. And that's exactly what happened.
Unexpectedly, Fannie Mae's finance team relied solely on spreadsheets to perform the calculations needed to comply with the new system, but they didn't realize the spreadsheets contained formatting errors.
KODAK - $9 Million Error
In 2005, Eastman Kodak Company added $9 million to its third-quarter loss due to a spreadsheet error. The loss after adjustment was $1.038 billion.
The error was caused by just one employee who miscalculated the severance cost for 15,000 job terminations.
JPMorgan Chase - $6.2 Billion Loss
In 2012, JPMorgan Chase lost at least $6.2 billion due to a spreadsheet error. This was one of the most expensive spreadsheet errors of all time. The bank's London office was conducting a series of complex derivatives trades that resulted in mounting losses.
Initially, one factor that contributed to the disaster was the use of a new risk calculation model (VaR) that had not been properly tested.
Furthermore, the model operated through a series of Excel spreadsheets that depended on the manual process of copying and pasting data between them. This led to an underestimation of risk by half.
Barclays Capital - Excel Formatting Error
In 2008, an Excel formatting error had catastrophic consequences for Barclays Capital. During the financial crisis that year, the company purchased 179 commercial contracts from the bankrupt Lehman Brothers without realizing many of them were worthless.
The error occurred because some rows in an Excel spreadsheet containing 1,000 rows and 24,000 cells were hidden rather than deleted. These rows contained contracts that BC had no interest in acquiring.
However, when the company sent a PDF file formatted for the bankruptcy court, all the information hidden in the Excel spreadsheet was revealed in the new file. The value of the financial loss was not disclosed and was never recovered by the company.
What Can Companies Learn From These Cases?
Spreadsheet errors are frequent and can occur for various reasons, such as lack of standardization in data entry or absence of proper reviews and validations. As we've seen, the cost of these mistakes can be astronomical.
Additionally, the use of spreadsheets creates version control issues, leading to inconsistencies and data errors when working with multiple versions of the same file.
However, with Mitra, companies have the opportunity to overcome such challenges. The software offers advanced automation and data integration features, enabling the automation of manual processes and improving efficiency.
By using Mitra, companies increase data accuracy, minimize errors, and optimize their processes. In this way, instead of spending time troubleshooting spreadsheet problems, organizations can focus on business objectives, growing and thriving.
Read also: What are the risks of using spreadsheets for financial control?