JPMorgan Chase suffered a mammoth trading loss last year as a result of a huge position in credit derivatives that was put on by a trader in its chief investment office. But the bank's report on the $6 billion loss last month laid a portion of the blame on a very common problem: an error in a spreadsheet.

A spreadsheet that calculated the Value at Risk of the chief investment office's portfolio contained an error in a formula that had the effect of lowering the Value at Risk, according to the report.

The risks involved in employing Excel spreadsheets are well-known. Users can make mistakes as they key in data, enter formulas or combine multiple spreadsheets. As spreadsheets circulate through the company, other users can add errors as they make changes. There's also the possibility a user could deliberately introduce inaccuracies.

Continue Reading for Free

Register and gain access to:

  • Thought leadership on regulatory changes, economic trends, corporate success stories, and tactical solutions for treasurers, CFOs, risk managers, controllers, and other finance professionals
  • Informative weekly newsletter featuring news, analysis, real-world case studies, and other critical content
  • Educational webcasts, white papers, and ebooks from industry thought leaders
  • Critical coverage of the employee benefits and financial advisory markets on our other ALM sites, PropertyCasualty360 and ThinkAdvisor
NOT FOR REPRINT

© 2024 ALM Global, LLC, All Rights Reserved. Request academic re-use from www.copyright.com. All other uses, submit a request to [email protected]. For more information visit Asset & Logo Licensing.

Susan Kelly

Susan Kelly is a business journalist who has written for Treasury & Risk, FierceCFO, Global Finance, Financial Week, Bridge News and The Bond Buyer.