The Excel Spreadsheet Error That Justified Global Austerity

Ian Becker

An economic report that has been used frequently to justify austerity measures in the U.S. and Europe has one flagrant flaw: an Excel error.  The 2010 report by prominent U.S. economists Carmen Reinhart and Ken Rogoff, titled "Growth In A Time Of Debt," argues that national economies whose public debt rises above 90 percent of GDP are doomed to stagnate. But when a team of economists at the University of Massachusetts, Amherst tried to duplicate the study using the spreadsheet that Reinhart and Rogoff used, they soon saw that the rationale for austerity relied on significant errors. For instance, five countries—Australia, Austria, Belgium, Canada, and Denmark—were mistakenly excluded from the Excel calculations. As Mark Gongloff points out, the coding error, as well as numerous other questionable aspects of the research, changes the report's findings significantly: The most important error appears to be a failure to include years of data that showed Australia, Canada and New Zealand enjoying high economic growth and high debt at the same time. Including all the years of data boosts New Zealand's average economic growth rate under high debt to 2.58 percent, from negative 7.6 percent. Given the small amount of data used in Reinhart and Rogoff's study, this has a huge impact on the overall findings. How influential was the study? As Quartz' Tim Fernholz demonstrates, "Growth In A Time of Debt" was used liberally by U.S. and U.K. lawmakers to argue in favor for the necessity of austerity measures in a time of recession. Check out the abbreviated list below: “It is widely acknowledged, based on serious research, that when public debt levels rise about 90% they tend to have a negative economic dynamism, which translates into low growth for many years.” — European Commissioner Olli Rehn.   “Economists who have studied sovereign debt tell us that letting total debt rise above 90 percent of GDP creates a drag on economic growth and intensifies the risk of a debt-fueled economic crisis.” — House Budget Committee Chairman and former Republican vice-presidential candidate Paul Ryan.   “It’s an excellent study, although in some ways what you’ve summarized understates the risks.”— Former US Treasury Secretary Tim Geithner.    “We would soon get to a situation in which a debt-to-GDP ratio would be 100%. As economists such as Reinhart and Rogoff have argued, that is the level at which the overall stock of debt becomes dangerous for the long-term growth of an economy. They would argue that that is why Japan has had such a bad time for such a long period. If deficits really solved long-term economic growth, Japan would not have been stranded in the situation in which it has been for such a long time.” Lord Lamont of Lerwick, former UK chancellor and sometime adviser to current chancellor George Osborne. According to Dean Baker of the Center for Economic and Policy Research, the economic policies that the report helped justify have pushed the unemployment rate over 10 percent for the Eurozone as a whole, and above 20 percent in Greece and Spain. In other words, says Baker, "This is a mistake that has had enormous consequences."

For a limited time:

Donate $20 or more to In These Times and we'll send you a copy of Let This Radicalize You.

In this new book, longtime organizers and movement educators Mariame Kaba and Kelly Hayes examine the political lessons of the Covid-19 pandemic and its aftermath, including the convergence of mass protest and mass formations of mutual aid. Let This Radicalize You answers the urgent question: What fuels and sustains activism and organizing when it feels like our worlds are collapsing?

We've partnered with the publisher, Haymarket Books, and 100% of your donation will go towards supporting In These Times.

Get 10 issues for $19.95

Subscribe to the print magazine.