Federal Reserve Economic Data: Your trusted data source since 1991

The FRED® Blog

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

Visualizing the Fed’s new monetary policy tools

First, let’s introduce some of the monetary policy terms we’ll be using here:

  • Federal Open Market Committee (FOMC): The seven members of the Board of Governors; the president of the Federal Reserve Bank of New York; and, on a rotating basis, the presidents of four other Reserve Banks. Nonvoting Reserve Bank presidents also participate in deliberations and discussion.
  • Federal funds rate (FFR): The interest rate at which depository institutions and Federal Home Loan Banks borrow and lend reserve balances to each other overnight.
  • Interest on reserve balances (IORB): Interest paid on reserves that banks hold in their accounts at a Federal Reserve Bank.
  • Overnight reverse repurchase agreement (ON RRP): An overnight transaction in which the Federal Reserve sells a security to an eligible counterparty and simultaneously agrees to buy the security back the next day.

The FOMC sets the stance of monetary policy by adjusting the target range for the FFR. To ensure the target range is transmitted to market interest rates, the FOMC uses the IORB as the primary tool and the ON RRP facility as the supplemental tool. The graph above shows that the Fed has successfully transmitted its desired policy stance to financial markets: The effective FFR has been within the upper and lower limits of the target range set by the FOMC—that is, the blue line stayed between the red and green lines.

Let’s look at these two “administered” rates* that the FOMC has used to steer the FFR within the target range:

  1. Banks earn interest on reserve balances (IORB) on the funds they place in their reserve accounts at the Fed. Because the IORB rate serves as a reservation rate for banks, and banks can arbitrage the difference between IORB and other short-term rates, it is an effective tool for guiding the FFR.**
  2. The Fed offers a broad set of large financial institutions the opportunity to deposit funds at the Fed overnight (with a security held as collateral) in the overnight reverse repurchase agreement (ON RRP) facility. Many of these financial institutions do not have access to interest on reserves. The Fed announces the capacity of the facility and an offering rate. Institutions then place bids that include the amount of their deposit and the minimum interest rate they would receive from the Fed. As long as the total amount of funds that institutions bid is less than the Fed’s set capacity, institutions’ full bid amounts are placed in the facility and the funds earn the ON RRP offering rate. However, if there is more demand than capacity, the Fed sorts the bids by their rates, lowest to highest, and awards funds to institutions in that order. The bid rate for the last institution to be accepted into the facility (once capacity is reached) becomes the award rate for all institutions. The Fed has set a large capacity, though, and the ON RRP offering rate has been the award rate in all auctions to date. As with the IORB rate, institutions use the ON RRP offering rate to help them arbitrage other short-term rates. Because it is set below the IORB rate, it serves as a supplementary rate and acts like a floor for the FFR.

The graph above shows the Fed’s new implementation tools in action. After the Great Financial Crisis, the Fed held the target range for the FFR at 0 to 25 basis points until December 16, 2015 (a date known as “liftoff”). Since then, the FOMC has adjusted the target range up and down several times, including a recent return to the range of 0 to 25 basis points on March 15, 2020, in response to the economic effects of the COVID-19 pandemic. When the FOMC moved the target range, the administered rates were also adjusted, and the FFR (green line) moved simultaneously.

The Fed determined the appropriate IORB rate (red line) and ON RRP offering (and, hence, award) rate (blue line) to keep the FFR in the target range. Over time, the administered rates have been adjusted relative to the range and relative to each other over time. The settings of the Fed’s administered rates are always determined to keep the FFR within the target range. For example, at liftoff, the IORB rate was set at the top of the range and the ON RRP offering (award) rate at the bottom of the range. But, over time, as market pressures moved the FFR toward the top of the target range, the Fed moved the IORB rate a bit lower and within the target range. This is visible in the next graph: Before June 16, 2018, the IROB rate (labeled as “interest rate on excess reserves”) is not visible because it lies beneath the upper limit of the federal funds target range. As the Fed lowered the IORB rate to move the FFR toward the middle of the target range, the IORB rate becomes visible and the FFR moves down in the range. The Fed has made two similar adjustments,  moving the IORB rate lower relative to the upper limit of the target range. The ON RRP offering rate, acting as a floor, has remained at the bottom of the range over most of this period, with the award rate being a touch below the lower limit a few times.

The Fed’s toolbox includes two other tools that support effective policy implementation. The discount rate acts a ceiling for the FFR because banks should not be willing to pay more for funds than the rate at which they can borrow from Fed. And, the Fed conducts open market operations – while no longer the primary tool for adjusting the FFR, the Fed uses open market operations periodically to ensure that the reserves in the banking system remain ample.

For more information, see The Fed’s New Monetary Policy Tools.

*An “administered” rate is an interest rate set by a central authority, such as the Fed, as opposed to an interest rate determined in a market.

**These data are listed in FRED as “interest rate on excess reserves.” Since the Fed decided to reduce reserve requirements to zero percent, it has indicated it may change the name to better reflect current use of the tool.

How this graph was created: First graph: Search for and select “Federal Funds Target Range – Upper Limit,” “Federal Funds Rate – Lower Limit,” and “Effective Federal Funds Rate (daily)” and click “Add to Graph.” From the “Edit Graph” panel, use the “Add Line” option to search for “Interest Rate on Excess Reserves” and then select “Add data series.” Adjust the date range to January 1, 2015, to the current date. Second graph: Search for and select “Overnight Reverse Repurchase Agreements Award Rate: Treasury Securities Sold by the Federal Reserve in the Temporary Open Market Operations,” “Interest Rate on Excess Reserves,” and “Effective Federal Funds Rate (daily).” Adjust the date range to January 1, 2015, to the current date. Third graph: Start with the second graph, search for and select “Federal Funds Target Range – Upper Limit,” and “Federal Funds Rate – Lower Limit” and “Effective Federal Funds Rate (daily).” Adjust the date range to January 1, 2018, to June 30, 2020. In all cases, adjust the colors to your liking with the color palette in the “Edit Graph” panel’s “Format” tab.

Suggested by Scott Wolla and Jane Ihrig.

View on FRED, series used in this post: DFEDTARL, DFEDTARU, DFF, IOER, RRPONTSYAWARD

Comparing the minimum wage with the average wage

You’ve likely seen discussions about the minimum wage in the news and in the FRED Blog. We’ve discussed

Today, we approach the topic from a different perspective. In the FRED graph above, the blue line tracks the fraction of the average weekly earnings for a person working full-time at the prevailing federal minimum wage. In other words, it shows how the minimum wage compares with the average wage.*

The blue line shoots upward every time Congress raises the federal minimum wage. And we have added a dashed custom line (in purple) to represent the average value of our calculation between January 1964 and January 2021. With a mean value of 44.45%, the hypothetical minimum-wage weekly earnings hit their high point of 57.39% of the average weekly earnings in February 1968. The low point in the graph was 33.47% in January 2021—the last available data at the time of this writing. For reference, the weekly earnings derived from a $15 per hour minimum wage (currently under discussion by policymakers) would amount to 69% of last month’s average weekly earnings.

*Specifically, the graph compares the average weekly earnings of production and nonsupervisory employees with the earnings of those who  work 40 hours per week at the federal minimum wage. The formula we use is (federal minimum hourly wage x 40 hours / average weekly earnings) x 100. Also keep in mind that minimum wage workers are part of the pool from which the average is taken.

How this graph was created: Search for and select “Federal Minimum Hourly Wage for Nonfarm Workers for the United States.” From the “Edit Graph” panel, use the “Edit Line 1” tab to customize the data by searching for and selecting “Average Weekly Earnings of Production and Nonsupervisory Employees, Total Private.” Next, create a custom formula to combine the series by typing in “((a*40)/b)*100” and clicking “Apply.” Next, use the “Add Line” tab to create a user-defined line. Create a line with start and end values of 44.45. To change the line colors, use the choices in the “Format” tab.

Suggested by Diego Mendez-Carbajo.

View on FRED, series used in this post: CES0500000030, FEDMINNFRWG

Subscribe to the FRED newsletter

Follow us

Back to Top