Fidelity didn't lose $1.3B, they miscalculated by $1.3B. The same with the other numbers you quote. Spreadsheets are error prone, but they still make sense for a lot of use cases.

https://www.cio.com/article/2438188/eight-of-the-worst-sprea...