Federal Reserve Economic Data

The FRED® Blog

Did the U.S. government just achieve a surplus?

A closer look at our national accounts

Almost all governments run deficits, so it’s a big deal when a government achieves a surplus. This graph includes data for all levels of U.S. government (local, state, and federal) on the net result of their lending and borrowing: A net deficit appears below the zero line, and a net surplus appears above the zero line. Notice the sudden jump in the fourth quarter of 2017 that reaches just above zero? This is a seasonally adjusted data series, by the way, so this jump has nothing to do with the regular influx of tax payments as the filing deadline approaches. (And that particular seasonal jump is in the second quarter, anyway.) So what’s going on here?

This jump from deficit to surplus has to do with the 2017 Tax Cuts and Jobs Act. One of its provisions is a one-time tax of foreign corporate earnings from 1986 to 2017. The so-called repatriation tax. This one-time capital transfer from businesses to government is estimated by the Bureau of Economic Analysis to be about $250 billion. Converted to annual rates, this implies a $1 trillion jump in government revenue in the fourth quarter that will not happen again. If we deduct this $1 trillion, the series actually moves downward from the third quarter’s value.

How this graph was created: Search for “net lending,” click on the government series, then select “Add to Graph.”

Suggested by Christian Zimmermann.

View on FRED, series used in this post: AD01RC1Q027SBEA

China’s trade surplus since 2000

The trade balance of a country is defined as the difference between its exports and its imports. When exports are greater than imports, for example, a country runs a trade surplus, which has been the case for China at least for the past 16 years. Thanks to FRED, we can analyze each of the components separately: exports, imports, and the overall trade balance (all as a percentage of GDP).

The graph shows four interesting episodes, marked by the vertical lines.

  1. In 2001, China became a member of the World Trade Organization (WTO) and saw a big increase in both its exports and its imports. Trade remained roughly balanced, however, since the increases of both components were similar.
  2. From 2004 to 2007, China started to build large trade surpluses (from 1.7 percent of GDP in 2004 to 7.5 percent in 2007) mainly driven by an increase in its exports that wasn’t matched by an increase in imports. There are two reasons: Exports in manufacturing increased rapidly, especially machinery, electronic appliances, and transportation equipment. Imports of intermediate goods slowed down, since China began to produce them domestically. (More about this.).
  3. In 2007, the trade surplus started to decline when China’s exports decreased more than its imports. Global demand also went down as a result of the financial crisis that started in the United States and spilled over to the developed countries.
  4. Since 2011, China’s trade surplus has increased. Even though exports are still falling (due to weak global demand), for the past few years imports have decreased, mainly due to lower domestic demand and commodity prices (More about this.)

How this graph was created: Select the first two series listed here for Chinese exports and imports and select “Add to Graph.” For each of the series, choose “Modify Existing Series” to add the third series (GDP) and insert in the formula tab “a/b*100” to calculate exports and imports as a percentage of GDP. For the trade balance (exports minus imports), add the three series listed (exports, imports, and GDP) and modify by using the formula “(a-b)/c*100” to calculate the trade balance as a percent of GDP. To add the vertical lines to denote time periods, click “Add data series” and then “Add trend line.” Set the start date and end date to be the same, set the start value as 0 and the end value as where you want the line to end. For the y-axis positions, choose the right side for exports and imports and the left side for the trade balance.

Suggested by Ana Maria Santacreu and Usa Kerdnunvong.

View on FRED, series used in this post: MKTGDPCNA646NWDB, XTEXVA01CNA667N, XTEXVA01CNA667S, XTIMVA01CNA667N

The federal budget balance as a fraction of GDP

Tracking data from two sources with two different calendars

The FRED Blog has discussed how many weekdays there are per month, quarter, and year. (It may seem trivial, but when you work with data, you need to be precise about federal and local holidays and how weekends shake out in a given month.)

Today, we consider two data sources, each with its own calendar year.

The FRED graph above shows the balance of the federal government budget as a percent of GDP. To calculate the budget balance, we subtract the value of federal net outlays from the value of federal receipts. Because those receipts and outlays change with the overall level of economic activity, we divide their difference by GDP and multiply by 100 to show it at as annual percentage.

And here’s the rub: Federal receipts and net outlays are reported by the Office of Management and Budget (OMB) for the fiscal year, which runs from October of the previous year to September of the current year. But GDP is reported by the Bureau of Economic Analysis (BEA) for the calendar year, which—just to make sure we’re on the same page—runs from January to December. So each organization counts 12 months for each year but starts counting on different dates.

If you want to learn more, keep on reading…

The second FRED graph shows the annual balance of the federal government budget as a percent of GDP using both calendars: Data from the fiscal year is in red, and data from the calendar year is in blue. The lines are very similar in value, meaning that the use of two different calendars has a small impact on the calculation overall. Small though it may be, the difference is largest for the calendar year at the end of a recession. At that time, the automatic stabilizers of fiscal policy have widened the gap between federal revenues and outlays while GDP is starting to rebound.

How these graphs were created: For the first graph, search for and select “Federal Receipts.” From the “Edit Graph” panel, use the “Edit Line 1” tab to customize the data by searching for and selecting “Federal Net Outlays” and “Gross Domestic Product (GDPA).” Next, create a custom formula to combine the series by typing in (((a-b)/1000)/c)*100 and clicking “Apply.”
For the second graph, from FRED’s main page, browse data by “Release.” Search for ”Debt to Gross Domestic Product Ratios” and check the two boxes under “Federal Surplus or Deficit [-] as Percent of Gross Domestic Product.” Last, click “Add to Graph.”

Suggested by Diego Mendez-Carbajo, Maria Arias, and Chris Russell.

View on FRED, series used in this post: FYFR, FYFSDFYGDP, FYFSGDA188S, FYONET, GDPA


Subscribe to the FRED newsletter


Follow us

Back to Top