Can Wall Street Do Basic Math?

Robert X. Cringely February 12th, 2009



It is a chart showing the deterioration of major bank market caps since 2007. Prepared by someone at JP Morgan based on data from Bloomberg, this chart flashed across Wall Street and the financial world a few days ago, filling thousands of e-mail in boxes. Putting a face on the current banking crisis it really brought home to many people on Wall Street the critical position the financial industry finds itself in.

before after


Too bad the original chart is wrong.
It is a simple error, really. The bubbles are two-dimensional so they imply that the way to see change is by comparing AREAS of the bubbles. But if you look at the numbers themselves you can see that's not the case.
Take CitiGroup, for example. The CITI market cap dropped from $255 billion to $19 billion - a difference of 13.4X. If we're really comparing the areas of the bubbles, that means 13.4 of those tiny CitiGroup-of-today bubbles should precisely fill the big CitiGroup-of-the-good-old-days bubble. Only they won't. As a matter of fact it would take about 13.4 times as many little bubbles to fill the big bubble as the chart preparer thought or 179.64 little bubbles. Pir squared, remember? This is because the intended comparison wasn't two-dimensional but one-dimensional-the chart maker was intending we compare the DIAMETERS of the bubbles, not their areas.
(looks like JPM fixed their own chart)

There are two more revised graphs:

Bar Chart

Radar Plotting Chart


And there is another bar chart based on the statistics:

bar chart shrinkage in market value of major banks 2007Q2 to 20 Jan 2009
RBS
120
Citigroup
255
Barclays
91
Beutsche Bank
76
Credit Agricole
67
Unicredit
90
BNP Paribas
108
UBS
116
Societe Generale
80
Morgan Stanley
49
Goldman Saches
100
Credit Suisse
75
HSBC
215
JP Morgan
165
Stantander
116