Case Study 18: How Excel Errors and Risk Oversights Cost JP Morgan $6 Billion

2. July 2024
Kategorien
Subscribe to our newsletter

Case Study 18: How Excel Errors and Risk Oversights Cost JP Morgan $6 Billion

In the spring of 2012, JP Morgan Chase & Co. faced one of the most significant financial debacles in recent history, known as the «London Whale» incident. The debacle resulted in losses amounting to approximately $6 billion, fundamentally shaking the confidence in the bank’s risk management practices. 

At the core of this catastrophe was the failure of the Synthetic Credit Portfolio Value at Risk (VaR) Model, a sophisticated financial tool intended to manage the risk associated with the bank’s trading strategies. 

The failure of the VaR model not only had severe financial repercussions but also led to intense scrutiny from regulators and the public. It highlighted the vulnerabilities within JP Morgan’s risk management framework and underscored the potential dangers of relying heavily on quantitative models without adequate oversight. 

This case study explores the intricacies of what went wrong and how such failures can be prevented in the future. By analyzing this incident, I seek to understand the systemic issues that contributed to the failure and to identify strategies that can mitigate similar risks in other financial institutions. The insights gleaned from this case are not just relevant to JP Morgan but to the broader financial industry, which increasingly depends on complex models to manage risk.

Background

The Synthetic Credit Portfolio (SCP) at JP Morgan was a part of the bank’s Chief Investment Office (CIO), which managed the company’s excess deposits through various investments, including credit derivatives. The SCP was specifically designed to hedge against credit risk by trading credit default swaps and other credit derivatives. The portfolio aimed to offset potential losses from the bank’s other exposures, thereby stabilizing overall performance.

In 2011, JP Morgan developed the Synthetic Credit VaR Model to quantify and manage the risk associated with the SCP. The model was intended to provide a comprehensive measure of the potential losses the bank could face under various market conditions. This would enable the bank to make informed decisions about its trading strategies and risk exposures. The VaR model was implemented using a series of Excel spreadsheets, which were manually updated and managed.

Despite the sophistication of the model, its development was plagued by several critical issues. The model’s architect lacked prior experience in developing VaR models, and the resources allocated to the project were inadequate. This led to a reliance on manual processes, increasing the risk of errors and inaccuracies. Furthermore, the model’s implementation and monitoring were insufficiently rigorous, contributing to the eventual failure that led to massive financial losses.

The primary objective of JP Morgan’s Synthetic Credit VaR Model was to provide an accurate and reliable measure of the risk associated with the bank’s credit derivatives portfolio. This would enable the bank to manage its risk exposures effectively, ensuring that its trading strategies remained within acceptable limits. The model aimed to capture the potential losses under various market conditions, allowing the bank to make informed decisions about its investments.

In addition to the primary objective, the Synthetic Credit VaR Model was expected to provide a foundation for further advancements in the bank’s risk management practices. By leveraging the insights gained from the model, JP Morgan hoped to develop more sophisticated tools and techniques for managing risk. This would enable the bank to stay ahead of emerging threats and maintain a competitive edge in the financial industry.

Don’t let your project fail like this one!

Discover here how I can help you turn it into a success.

For a list of all my project failure case studies just click here.

Timeline of Events

Early 2011: Development of the Synthetic Credit VaR Model begins. The project is led by an individual with limited experience in developing VaR models. The model is built using Excel spreadsheets, which are manually updated and managed.

September 2011: The Synthetic Credit VaR Model is completed and implemented within the CIO. The model is intended to provide a comprehensive measure of the potential losses the bank could face under various market conditions.

January 2012: Increased trading activity in the SCP causes the CIO to exceed its stress loss risk limits. This breach continues for seven weeks. The bank informs the OCC of the ongoing breach, but no additional details are provided, and the matter is dropped.

March 23, 2012: Ina Drew, head of the CIO, orders a halt to SCP trading due to mounting concerns about the portfolio’s risk exposure.

April 6, 2012: Bloomberg and the Wall Street Journal publish reports on the London Whale, revealing massive positions in credit derivatives held by Bruno Iksil and his team.

April 9, 2012: Thomas Curry becomes the 30th Comptroller of the Currency. Instead of planning for the upcoming 150th anniversary of the Office of the Comptroller of the Currency (OCC), Mr. Curry is confronted with the outbreak of news reports about the London Whale incident.

April 16, 2012: JP Morgan provides regulators with a presentation on SCP. The presentation states that the objective of the «Core Credit Book» since its inception in 2007 was to protect against a significant downturn in credit. However, internal reports indicate growing losses in the SCP.

May 4, 2012: JP Morgan reports SCP losses of $1.6 billion for the second quarter. The losses continue to grow rapidly even though active trading has stopped.

December 31, 2012: Total SCP losses reach $6.2 billion, marking one of the most significant financial debacles in the bank’s history.

January 2013: The OCC issues a Cease and Desist Order against JP Morgan, directing the bank to correct deficiencies in its derivatives trading activity. The Federal Reserve issues a related Cease and Desist Order against JP Morgan’s holding company.

September – October 2013: JP Morgan settles with regulators, paying $1.020 billion in penalties. The OCC levies a $300 million fine for inadequate oversight and governance, insufficient risk management processes, and other deficiencies.

What Went Wrong?

Model Development and Implementation Failures

The development of JP Morgan’s Synthetic Credit VaR Model was marred by several critical issues. The model was built using Excel spreadsheets, which involved manual data entry and copying and pasting of data. This approach introduced significant potential for errors and inaccuracies. As noted in JP Morgan’s internal report, «the spreadsheets ‘had to be completed manually, by a process of copying and pasting data from one spreadsheet to another’«. This manual process was inherently risky, as even a minor error in data entry or formula could lead to significant discrepancies in the model’s output.

Furthermore, the individual responsible for developing the model lacked prior experience in creating VaR models. This lack of expertise, combined with inadequate resources, resulted in a model that was not robust enough to handle the complexities of the bank’s trading strategies. The internal report highlighted this issue: «The individual who was responsible for the model’s development had not previously developed or implemented a VaR model, and was also not provided sufficient support«. This lack of support and expertise significantly compromised the quality and reliability of the model.

Insufficient Testing and Monitoring

The Model Review Group (MRG) did not conduct thorough testing of the new model. They relied on limited back-testing and did not compare results with the existing model. This lack of rigorous testing meant that potential issues and discrepancies were not identified and addressed before the model was implemented. The internal report criticized this approach: «The Model Review Group’s review of the new model was not as rigorous as it should have been«. Without comprehensive testing, the model was not validated adequately, leading to unreliable risk assessments.

Moreover, the monitoring and oversight of the model’s implementation were insufficient. The CIO risk management team played a passive role in the model’s development, approval, implementation, and monitoring. They viewed themselves more as consumers of the model rather than as responsible for its development and operation. This passive approach resulted in inadequate quality control and frequent formula and code changes in the spreadsheets. The internal report noted, «Data were uploaded manually without sufficient quality control. Spreadsheet-based calculations were conducted with insufficient controls and frequent formula and code changes were made«. This lack of oversight and quality control further compromised the reliability of the model.

Regulatory Oversight Failures

Regulatory oversight was inadequate throughout the development and implementation of the Synthetic Credit VaR Model. The OCC, JP Morgan’s primary regulator, did not request critical performance data and failed to act on risk limit breaches. As highlighted in the Journal of Financial Crises, «JPM did not provide the OCC with required monthly reports… yet the OCC did not request the missing data«. This lack of proactive oversight allowed significant issues to go unnoticed and unaddressed.

Additionally, the OCC was informed of risk limit breaches but did not investigate the causes or implications of these breaches. For instance, the OCC was contemporaneously notified in January 2012 that the CIO exceeded its Value at Risk (VaR) limit and the higher bank-wide VaR limit for four consecutive days. However, the OCC did not investigate why the breach happened or inquire why a new model would cause such a large reduction in VaR. This failure to follow up on critical risk indicators exemplified the shortcomings in regulatory oversight.

How JP Morgan Could Have Done Things Differently?

Improved Model Development Processes

One of the primary ways JP Morgan could have avoided the failure of the Synthetic Credit VaR Model was by improving the model development processes. Implementing automated systems for data management could have significantly reduced the risk of human error and improved accuracy. Manual data entry and copying and pasting of data in Excel spreadsheets were inherently risky practices. By automating these processes, the bank could have ensured more reliable and consistent data management.

Moreover, allocating experienced personnel and adequate resources for model development and testing would have ensured more robust results. The individual responsible for developing the model lacked prior experience in VaR models, and the resources allocated to the project were inadequate. By involving experts in the field and providing sufficient support, the bank could have developed a more sophisticated and reliable model. As highlighted in the internal report, «Inadequate resources were dedicated to the development of the model«.

Conducting extensive back-testing and validation against existing models could have identified potential discrepancies and flaws. The Model Review Group did not conduct thorough testing of the new model, relying on limited back-testing. By implementing a more rigorous testing process, the bank could have validated the model’s accuracy and reliability before its implementation.

Enhanced Oversight and Governance

Enhanced oversight and governance could have prevented the failure of the Synthetic Credit VaR Model. Ensuring regular, detailed reporting to regulators and i
nternal oversight bodies would have maintained transparency and accountability. JP Morgan failed to provide the OCC with required monthly reports, and the OCC did not request the missing data. By establishing regular reporting protocols and ensuring compliance, the bank could have maintained better oversight of the model’s performance.

Addressing risk limit breaches promptly and thoroughly would have mitigated escalating risks. The OCC was informed of risk limit breaches but did not investigate the causes or implications of these breaches. By taking immediate action to address and rectify risk limit breaches, the bank could have prevented further escalation of risks. Proactive risk management is crucial in identifying and mitigating potential issues before they lead to significant losses.

Implementing continuous monitoring and review processes for all models and strategies could have identified issues before they led to significant losses. The CIO risk management team played a passive role in the model’s development, approval, implementation, and monitoring. By adopting a more proactive approach to monitoring and reviewing the model, the bank could have ensured that potential issues were identified and addressed promptly. Continuous monitoring and review processes are essential in maintaining the accuracy and reliability of risk management models.

Comprehensive Risk Management Framework

Developing a comprehensive risk management framework could have further strengthened JP Morgan’s ability to manage risks effectively. This framework should have included clear policies and procedures for model development, implementation, and monitoring. By establishing a robust risk management framework, the bank could have ensured that all aspects of the model’s lifecycle were adequately managed.

Additionally, enhancing collaboration and communication between different teams involved in risk management could have improved the model’s reliability. The CIO risk management team viewed themselves more as consumers of the model rather than as responsible for its development and operation. By fostering collaboration and communication between different teams, the bank could have ensured that all stakeholders were actively involved in the model’s development and monitoring.

Closing Thoughts

The failure of JP Morgan’s Synthetic Credit VaR Model underscores the critical importance of rigorous development, testing, and oversight in financial risk management. This incident serves as a cautionary tale for financial institutions relying on complex models and emphasizes the need for robust governance and proactive risk management strategies. By learning from this failure, financial institutions can develop more reliable and effective risk management frameworks.

The insights gleaned from this case study are not just relevant to JP Morgan but to the broader financial industry, which increasingly depends on complex models to manage risk. By addressing the systemic issues that contributed to the failure and implementing the strategies outlined in this case study, financial institutions can mitigate similar risks in the future.

In conclusion, the London Whale incident highlights the vulnerabilities within JP Morgan’s risk management framework and underscores the potential dangers of relying heavily on quantitative models without adequate oversight. By enhancing model development processes, improving oversight and governance, and developing a comprehensive risk management framework, financial institutions can ensure more reliable and effective risk management practices.

Don’t let your project fail like this one!

Discover here how I can help you turn it into a success.

For a list of all my project failure case studies just click here.

Sources

1) Internal Report of JPMorgan Chase & Co. Management Task Force Regarding 2012 CIO Losses, January 16, 2013

2) A whale in shallow waters: JPMorgan Chase, the “London Whale” and the organisational catastrophe of 2012, François Valérian, November 2017

3) JPMorgan Chase London Whale E: Supervisory Oversight, Arwin G. Zeissler and Andrew Metrick, Journal of Financial Crises, 2019

4) JPMorgan Chase London Whale C: Risk Limits, Metrics, and Models, Arwin G. Zeissler and Andrew Metrick, Journal of Financial Crises, 2019

5) JPMorgan Chase Whale Trades: A Case History of Derivatives Risks and Abuses, Permanent Subcommittee on Investigations United States Senate, 2013

That could also be of interest for you

Case Study 31: BDO’s Third Way – The Accounting Network Trying to Stay Independent While Learning to Live With Private Capital

11. May 2026

For a while, BDO looked like the firm that might give the professional services industry a clean counter-narrative. Grant Thornton had moved into private equity-backed consolidation. Baker Tilly US had accepted external capital. Moore Global had member firms benefiting from sponsor-backed growth. But BDO seemed to be drawing a line. In October 2025, BDO announced

Read more

Case Study 30: Afileon – How Private Capital Enters a Protected Profession Without Owning It

6. May 2026

For decades, the German tax advisory market was not simply fragmented. It was deliberately engineered to remain so. More than 100,000 licensed tax advisors operating across roughly 55,000 firms created a system that prioritized independence, continuity, and professional judgment over scale. Ownership was tightly restricted to qualified professionals, effectively excluding external capital and preventing the

Read more

Case Study 29: When the Firm No Longer Owns Its Talent – PwC vs Unity

27. April 2026

Professional services firms have long operated on a simple but rarely questioned assumption. They do not just employ talent. They contain it. Over decades, partners build client relationships inside the firm, convert those relationships into revenue, and accumulate economic value through profit participation, deferred compensation, and retirement structures that can reach several million dollars. The

Read more

Case Study 28: Forvis Mazars – One Brand, Two Firms, and the Structural Experiment That Runs Against the Industry

21. April 2026

When Mazars and FORVIS officially launched Forvis Mazars in June 2024, the headline numbers made the story look familiar. The new organisation entered the market with roughly $5 billion in combined revenue, around 40,000 professionals, operations in more than 100 countries and territories, and close to 1,800 partners, immediately placing it among the new entrants

Read more

Case Study 27: Baker Tilly and Private Equity – When a Network Starts Becoming a Platform

14. April 2026

Originally published April 2026, updated May 2026. Baker Tilly presents itself as a global firm, and by most external measures, it looks like one. The network operates in more than 140 territories, employs more than 50,000 people, and generates global revenues exceeding $5 billion, placing it among the largest accounting and advisory organisations worldwide, while

Read more

Case Study 26: Accenture – The Success Story That Was Never Meant to Happen

8. April 2026

In boardrooms across the professional services industry, one reference point appears with almost ritualistic regularity whenever the idea of separating audit and consulting is raised: Accenture. The story is compelling precisely because it is so clean. A consulting arm breaks away from an audit-dominated structure, frees itself from regulatory constraints, accesses capital markets, and emerges

Read more

Case Study 24: PwC’s “Monday” – How a $20bn Spin-Off Fell Apart

29. March 2026

In June 2002, inside PricewaterhouseCoopers, something unusual had already taken shape. The firm was no longer discussing whether to separate its consulting business. It had already done the structural work required to make that separation real. Registration documents filed with regulators described a fully constructed corporate entity, with defined governance, ownership structures, and a legal

Read more

Case Study 23: The Fragmentation of a Global Firm – How Private Equity Is Reshaping Grant Thornton

23. March 2026

Originally published March 2026, updated May 2026. For most of its history, Grant Thornton operated through the standard global professional-services model: a network of legally separate member firms sharing a brand, methodologies, and network infrastructure, but not functioning as a single worldwide partnership. Grant Thornton International itself states that its member firms are separate legal

Read more

Case Study 22: The $600 Million Failed EY Split (“Project Everest”)

19. March 2026

In 2022 and 2023, Ernst & Young pursued the most ambitious restructuring attempt in modern Big Four history: a plan, code-named Project Everest, to separate most of its consulting business from its audit and assurance business. The logic was straightforward. Audit independence rules constrained cross-selling and limited growth in advisory. A split promised to unlock

Read more

Case Study 21: The Australian Securities Exchange (ASX) $250 Million CHESS Blunder

6. January 2025

The Australian Securities Exchange (ASX) embarked on an ambitious journey to replace its 25-year-old Clearing House Electronic Subregister System (CHESS) with a state-of-the-art, blockchain-based platform.  Initially envisioned as a groundbreaking project to enhance efficiency, security, and scalability, the CHESS replacement project quickly turned into a cautionary tale.  The initiative faced repeated delays and escalating costs

Read more