FORTUNE -- Apparently some really smart people have trouble mastering Microsoft Office.
Early Wednesday morning, in an e-mail that went out to reporters around 2 A.M., Harvard professors Carmen Reinhart and Kenneth Rogoff copped to making an Excel error in their research paper tying high levels of government debt to low levels of growth. The paper, "Growth in Time of Debt," has become a powerful data point for those who argue against government spending even to revive the economy -- Congressman Paul Ryan cited it in his most recent budget -- and is the basis for the two professors' best-selling book This Time is Different.
When it comes to Excel, though, Reinhart and Rogoff aren't all that different. Wall Streeters can relate. Prominent financial blogger James Kwak calls Excel "one of the greatest, most powerful, most important software applications of all time." But perhaps we ask too much of the program, or perhaps of our ability to cut and paste. In the past few years, Excel has been implicated in some of the biggest blunders on Wall Street and in finance in general. Here are some notable Excel victims:
Reinhart and Rogoff in their 2010 paper claimed that when a country's debt hits 90% of its GDP, economic grows slows dramatically. The two Harvard professors said the conclusion was based on looking at the debt levels of dozens of countries going back to the 1800s. But according to a new paper from three economists at University of Massachusetts Amherst, a coding error in the Harvard professors' spreadsheet completely excluded the first five countries in their dataset, including Australia and Canada, from their calculations. The error, along with some other potential mistakes (which the professors refute), caused the professors to conclude that on average, countries in the 90% plus category tended to see their economies shrink -0.1% a year, according to the University of Mass.
Amherst researchers. In fact, the economies grew 2.2%.
In the wake of last year's $6.2 billion JPMorgan Chase (JPM) trading loss, traders have been fired, top executives have been hauled in front of Congress, and the FBI, among other regulators, is investigating. But you know who really needs to be questioned? Bill Gates. According to an internal report on the trading loss released in February, the model that was supposed to monitor and limit the amount of risk the bank's London traders were taking was "operated through a series of Excel spreadsheets, which had to be completed manually, by a process of copying and pasting data from one spreadsheet to another." One key measure was added when it should have been averaged. The result: Risk officers at JPMorgan believed the credit derivatives bets were half as risky as they actually were. So, I guess, CEO Jamie Dimon can pass $3.1 billion off on Excel. The rest is still on him.
About a year before MF Global went bust, consultants hired by the firm determined it needed to improve the "end user computer tools such as Excel spreadsheets" that the commodities broker used to monitor risk and how much money it had in its customers accounts, and to make sure that some of that money didn't end up in the account being used by CEO Jon Corzine to bet on whether or not Europe was about to implode. Those upgrades were never made.
When Barclays sent over its offer to buy up Lehman Brothers in the immediate wake of the firm's September 2008 collapse, it did so with an Excel spreadshet. The makers of the spreadsheet, which detailed Lehman's assets and what Barclays was willing to buy, hid, rather than deleted, nearly 200 cells. But when a junior law associate at Cleary Gottlieb Steen & Hamilton converted the Excel file to a PDF and e-mailed it over to the bankruptcy court, the hidden parts of the spreadsheet reappeared. The result: Along with the parts of Lehman Barclays wanted, the British bank was also forced to swallow losses on an additional 179 toxic deals it never intended to buy.
Last year, a miscalculation in Utah's office of education understated the number of students who would enroll in the state's public schools and led to a $25 million budget shortfall. The state's superintendent eventually attributed the error to a "faulty reference in a spreadsheet," and two of the state's top finance officials were forced to resign.
We should have seen the financial crisis coming. Back in 2003, the giant mortgage guarantor made an error in an Excel spreadsheet when transitioning to a new accounting regulation. The result: an error that made Fannie look $1.3 billion more profitable than it actually was. The company was forced to later restate its results.
A tribe of Native Americans entered the wrong row into the cell of the Excel spreadsheet that contained the formula to compute the net present value of the Island of Manhattan, mistakenly leading them to believe that what was to become New York City was only worth $24, which they accepted in beads and trinkets. Just kidding. The error was made in Lotus.
Don't expect a rival offer for Dell.
FORTUNE -- We are now 10 days away from the end of Dell Inc.'s "go-shop" period, during which the company can solicit superior bids to the existing $13.65 per share offer from Michael Dell and Silver Lake Partners. I continue to be highly skeptical that such an offer will materialize.
Just take a look at those known to have signed nondisclosure agreements in exchange for MOREDan Primack - Mar 13, 2013 12:28 PM ET
Microsoft worried that equity stake would have upset others.
FORTUNE -- There weren't too many surprises in Dell Inc.'s announcement that it has agreed to be taken private for $24.4 billion. Except for one: Microsoft's $2 billion investment will come as a loan, instead of as equity.
A source familiar with the situation tells me that the software giant was worried about other customers thinking that Microsoft (MSFT) had incentive to value MOREDan Primack - Feb 5, 2013 10:42 AM ET
Dell going private for $24.4 billion.
FORTUNE -- Dell Inc. (DELL) this morning announced that it has agreed to be acquired for $24.4 billion, or $13.65 per share.
The purchasing group would include private equity firm Silver Lake Partners, company founder and CEO Michael Dell and an investment firm that manages Michael Dell's money (MSD Capital). No specifics yet on how much each one would provide.
Microsoft (MSFT) also would provide a $2 billion MOREDan Primack - Feb 5, 2013 9:25 AM ET
Seattle VC firm tries to reignite.
FORTUNE -- Ignition Partners, a Seattle-area venture capital firm formed in 2000 by a group of ex-Microsoft (MSFT) executives, is reorganizing into a much smaller, more focused organization. In other words, lots of people are on their way out.
Fortune has learned that the new Ignition team will consist of just three senior partners: John Connors, the former Microsoft CFO who joined in 2005; Frank Artale, MOREDan Primack - Jan 24, 2013 3:32 PM ET
Facebook is unlocked. So who held, and who sold?
FORTUNE -- Approximately 271 million shares of Facebook (FB) stock were "unlocked" yesterday, under a provision that had prevented certain investors from selling shares until 90 days after the company went public. And, as happens after most lockup expirations, Facebook took a tumble – down 6.27% to finish trading at $19.87 per share. For context, the IPO price on May 18 had MOREDan Primack - Aug 17, 2012 9:53 AM ET
Early Yammer investor discusses $1.2 billion sale to Microsoft.
FORTUNE -- Microsoft (MSFT) today made official what we've all known for weeks: It has agreed to acquire Yammer, the San Franicsco-based enterprise social networking company, for $1.2 billion in cash.
After the deal was formerly announced, the following tweet popped up from George Zachary, who led the original investment in Yammer for Charles River Ventures:
That's a big claim, considering that Zachary has been a MOREDan Primack - Jun 25, 2012 3:14 PM ET
Is Microsoft-Yammer still happening?
FORTUNE -- It's been nearly a week since word first leaked that Microsoft (MSFT) has agreed to acquire Yammer, the San Franicsco-based enterprise social networking company that many had viewed as a 2013 IPO candidate. So where's the announcement?
This isn't the sort of thing that Microsoft could, or would want to, keep under wraps. The deal reportedly is worth around $1.2 billion, and helps Microsoft fill a large MOREDan Primack - Jun 19, 2012 4:32 PM ET
America's biggest companies smashed records for earnings in 2011. Too bad the party can't last.
FORTUNE -- Given the sluggish recovery and a strapped consumer, you'd expect to see corporate America trudging along, not racing for glory. In fact, the Fortune 500 are thriving as a group. Unlike the U.S. economy, they've shown quicksilver agility, rapidly shifting their product mix and producing more goods at little new cost. This nimbleness belies MOREShawn Tully, senior editor-at-large - May 7, 2012 12:00 PM ET
By Don Dodge, contributor
Facebook yesterday announced that it will pay $1 billion to acquire Instagram -- a company that is less than two years old, has no revenue and about a dozen employees. Remember, acquisitions are about what the acquirer can do with the company in the future, not some multiple of revenues or profits today. So why is Instagram worth $1 billion?
Facebook acquired Instagram for about $30 per user, or $1 billion. ($30/user X MOREApr 10, 2012 9:56 AM ET
|4 federal agencies to shut Friday|
|Mailbox comes to the iPad|
|Wall Street weathers the storm|
|Chrysler jabs Tesla over loan repayment|
|6 things you don't know about the Xbox One. (Really)|