Skip to main content

The FRED® Blog

The equity premium

The equity premium is the difference between the return on a stock and the return on a bond. Typically, it’s positive—meaning stock returns are higher—although it can be negative when the stock market goes through some rough times. Over the long run, it’s definitively positive because bonds are senior to stocks in any liquidation: Bonds carry less risk and, therefore, less yield. Measuring the equity premium is tricky, though. To do it right, you must compare stocks and bonds from firms of similar quality and aggregate over many firms to smooth out anecdotal evidence and small-sample errors. Using broad indexes may also be distorting, as the firm composition may not be comparable between stock and bond indexes.

In the graph above, FRED shows one of the many examples of how you can measure the equity premium with available data, using here the very broad Wilshire 5000 index for stocks and the BofA Merrill Lynch BBB index for bonds. (BBB is a category that may be somewhat representative: not very safe but not very risky, either.) You can experiment on FRED with many other combinations. Again, you’ll find the result is positive most of the time, reflecting the simple investment advice that if saving for the long-run warrants a diversified portfolio of stocks.

How this graph was created: Search for “Wilshire 5000” and choose the total market index. Change units to “Percent Change from Year Ago.” In the “Edit Line” tab, add the second series by search for “BBB effective yield.” Customize the data by applying the formula a-b. Finally, change the frequency to monthly to make the graph less noisy.

Suggested by Christian Zimmermann.

View on FRED, series used in this post: BAMLC0A4CBBBEY, WILL5000IND

To what degree do we have degrees?

Bachelor’s degrees grow more common every year. The Census Bureau estimates, as of 2015, that 32.5% of the U.S. population 25 years or older have at least a bachelor’s degree. Yet, the GeoFRED map shows that the percentages of the vast majority of counties are lower than the national average: Almost 90% of counties are at 29.5% or less.

Looking at the regions with the highest and lowest percentages can give us some important insights. The southern U.S. claims 9 of the bottom 20 counties, which goes up to 16 of 20 if we include Kentucky and Texas. Loving County, Texas, has the lowest percentage: With a population of 112, it has only 3.7% with at least a bachelor’s degree. The top 20 counties are spread throughout the country, 7 of which are from the state of Virginia: Falls Church City and Arlington County, respectively, have 72.8% and 71.2% with at least a bachelor’s degree. This above-average cluster around Washington D.C. is home to many Fortune 500 companies and multiple federal government agencies, including the Department of Defense’s main base of operation, the Pentagon.

How the graph was created: In GeoFRED, select “Tools” and expand the “Choose Data” section. Under “Region Type” select “County,” and under “Data” search for and choose “Bachelor degree or higher.” The map defaults to the most-recent data available. Expand the “Edit Legend” section, change the number of classes to 6, and manually set the interval values.

Suggested by Joshua Berry

Consols: The never-ending bonds

FRED just added an exciting new dataset from the Bank of England: Three Centuries of Macroeconomic Data in the United Kingdom. It provides, among many others, a series on the yields of consols. These are bonds without a maturity date. Pardon? Well, that means there’s no scheduled date for final redemption, until the government decides to pay it back, and coupon payments are made until that time. Consols were first introduced in 1751 at 3.5% and have been in circulation ever since, although interest rates have varied. In 2015, the British government decided to redeem all consols in circulation.

A consol is like a stock, in that it last forever…or until the debtor decides to buy it back. However, consols have a fixed interest rate, while stocks have varying dividends. Consols are also considered to be bonds and thus have seniority over stocks in cases of bankruptcy. Another unconventional debt instrument that comes close to consols is the 100-year mortgage introduced in Japan in the 1980s to try to make homes more affordable.

How this graph was created: Search for “consol” and you should find the series among the first results.

Suggested by Christian Zimmermann.

View on FRED, series used in this post: YCLTUK

Of the people: Federal and local government employment

Here, FRED shows us the total number of U.S. federal government employees over time. Take a minute to examine the graph… For one thing, it sure is spikey. The highest level was during World War II, and the next highest was during the war in Korea. Clearly, war has driven this type of employment. There are also short spikes every ten years, which correspond to temporary hires for the census, including the spike in April 2009. Overall, these spikes have grown as the U.S. population has grown. What may be surprising is that there hasn’t been any significant upward trend, despite substantial population growth—in fact, the U.S. population has more than doubled over this period.

The graph below shows state and local government employment, and the story here is quite different: Except during the recent recessions, both these have grown steadily, despite the fact their growth isn’t affected by wars or the census.

How these graphs were created: Look for the Current Employment Statistics (Establishment Data) releases and select Table B-1. Choose “Federal, except U.S. Postal Service” for the first graph. For the second graph, select the three series shown and add them to the graph.

Suggested by Christian Zimmermann.

View on FRED, series used in this post: CES9091100001, CES9092000001, CES9093000001

To your health! The price of French wine

Today, France celebrates its national holiday. So we take this opportunity to write about… French wine. Oui. FRED does have a price index for French wine. And because prices are always relative to something else, we compare this index with the general price level of consumption goods in France (the blue line). We see that, in relative terms, the price of wine has increased, which sounds bad for the local population. But we can also compare the price of wine with the typical French hourly wage (the red line): There we see that wine has become more and more affordable for the French, which is a reason to celebrate.

How this graph was created: Search for “French wine” and open the graph. In the “Edit Graph” panel, add France’s general price index in the “Customize Data” section. Searching for “France CPI” should do the trick. Once you have both series, apply the formula a/b. In the “Add Line” tab, search again for “French wine” (which may appear among your recently viewed options). Then under “Edit Line 2” add the wage series by searching for “French wage.” Choose the quarterly series for all activities and apply the same a/b formula again. Viola!

Suggested by Christian Zimmermann.

View on FRED, series used in this post: CP0000FRM086NEST, CP0212FRM086NEST, LCWRTT01FRQ661N

Subscribe to our newsletter

Follow us

Twitter logo Google Plus logo Facebook logo YouTube logo LinkedIn logo
Back to Top