Categories
Ξ TREND

A tiny error with Excel causes losses of 86 million euros to Norway: an employee made a mistake when entering a figure


In the financial world, even the smallest mistakes can have enormous consequences… even more so in an era like ours, dominated by technological automation. And if not, tell the Norwegian Sovereign Fund, which recently faced a loss of around 98 million Norwegian krone (86 million euros) due to… a slip in an Excel document.

The Norwegian Sovereign Fund (an autonomous public body that invests the Scandinavian country’s oil profits to finance its pension system) is known for being one of the largest deposits of wealth in the world: Its assets amount to about 1.5 trillion dollars.

The error

As reported by the Financial Times, an employee (identified only by his first name, ‘Simon’) made a manual error when entering data into an Excel spreadsheet that was used to calculate the fund’s benchmark. Instead of using the correct date (November 1), Simon mistakenly entered the date December 1.

This error in the date affected the composition of the benchmark index that dictates the ideal investment portfolio From the bottom. When the benchmark is calculated incorrectly, investment decisions made based on those calculations can cause the fund to lose money… as happened in this case.

And, due to the error in the date, The incorrect calculation caused the fund to allocate more weight than it should to US government bonds. in its investment portfolio, compared to other bonds or sovereign debts worldwide.

When a fund moves so much money, that even a deviation of just 0.7 basis points in the return has million-dollar consequences

Once the problem is identified (several months later, when they realized the accounts didn’t add up)the error was corrected, but the financial consequences were already significant: what happened forced previously reported profits to be adjusted from 118 billion Norwegian crowns to 117 billion.

The reactions

Patrick du Plessis, the fund’s risk monitoring manager (and therefore also indirectly responsible for what happened), explains that he felt “physically sick” when they explained to him what had happened.

But almost as surprising as this error is the institutional reaction to it by Norges Bank Investment Management (NBIM), the fund’s managing entity. Far from hunting for a scapegoatthe fund’s management opted for a constructive response…

Neither Simon nor Patrick du Plessis were fired. Nicolai Tangen, CEO of the fund, He opted instead to send them a reassuring email.:

These things happen! We run complex operations and what surprises me most is that historically we have had very few if any incidents like this. You are both super professionals and have contributed significantly to the success of NBIM. Don’t let this ruin your weekend. Onward and upward!

Possibly, your weekend wasn’t great, despite everything.

By Owen Cox

Meet Owen Cox, a passionate gamer with a rich history in the world of gaming. From owning nearly every console since the Atari 2600 to indulging in gaming for over two decades, Owen's love for gaming knows no bounds. With experience in gaming retail, he has had the opportunity to immerse himself in the vibrant gaming community and share his expertise with fellow enthusiasts. Additionally, Owen has worked at Deloitte USI, honing his professional skills in a dynamic environment. Currently, as an Inventory Specialist at Best Buy, he continues to contribute to the ever-evolving landscape of technology and gaming.