Thursday, January 27, 2022

Data Update 3 for 2022: Inflation and its Ripple Effects!

    Inflation numbers have been coming in high now, for more than a year, but for much of the early part of 2021, bankers, investors and politicians seemed to be either in denial or casually dismissive of its potential for damage. Initially, the high inflation numbers were attributed to the speed with the economy was recovering from COVID, and once that excuse fell flat, it was the supply chain that was held responsible. By the end of 2021, it was clear that this bout of inflation was not as transient a phenomenon as some had made it out to be, and the big question leading in 2022, for investors and markets, is how inflation will play out during the year, and beyond, and the consequences for stocks, bonds and currencies.

Inflation: Measurement and Determinants

    As the inflation debate was heating up in the middle of last year, I wrote a comprehensive post on how inflation is measured, what causes it and how it affects returns on different asset classes. Rather than repeat much of that post, let me summarize my key points.

  • Measuring inflation is not as simple as it looks, and measures of inflation can vary depending on the basket of good/services used, the perspective adopted (consumer, producer, GDP deflator) and the sampling used to collect prices. That said, the three primary inflation indices in the US, the CPI, the PPI and the GDP deflator all told the same story in 2021:
    Download historical inflation numbers

    The inflation rate during the course of the year reached levels not seen in close to 40 years, with every price index registering a surge.
  • While news stories focus on reported (and past inflation, it is expected inflation that should drive investment, and measures of these expectations can come from surveys of consumers (University of Michigan) or from the market, as the difference between the treasury bond rate and the inflation-protected treasury bond, of equivalent maturity:
    Download data

    Using the ten-year bond, it is clear that while inflation expectations have inched up in the bond market, but that rise is far more muted than in the actual inflation indices, and consumer expectations of inflation now significantly exceed the bond-market imputed estimate for expected inflation.
  • While the implied inflation in bond rates is low, investors seem to be anticipating higher inflation. Using a measure that the Federal Reserve has developed, I report the percent of investors expecting inflation to be greater than 2.5%, representing one end of the inflation expectation spectrum, and those expecting deflation, representing the other, in the graph below:
    Download data
    As you can see the 93.96% of investors were expecting inflation to be greater than 2.5%, by the end of December 2021, up from 6.74% in December 2020, suggesting a sea change in the market. Conversely, the percent of investors expecting deflation has dropped to a vanishing low number, suggesting that Cathie Wood has little company, in her contention that deflation is the real danger to markets and economies.
The undeniable fact is that inflation came back in 2021, but the question of why it happened, and whether it will stay high, is  hotly debated. To those who believe that it is a spike that will dissipate over time, it is another casualty of COVID, as a combination of virus-driven supply chain issues and government spending to offset shutdowns has driven prices up. In this mostly benign story, inflation will go back down, once these pressure ease, though it is unclear to what level. To others, and especially those old enough to remember the 1970s, it does seem like a return to more unsettled times, with potentially dangerous consequences for the economy and markets.

Interest Rates and Inflation

    Inflation and interest rates are intertwined, and when their paths deviate, as they sometimes do, there is always a reckoning. While we have increasingly given central banks primacy in discussions of interest rates, it remains my view that markets set rates, and while central banks can nudge market expectations, they cannot alter them. Put simply, no central bank, no matter how powerful, can force market interest rates down, if inflation expectations stay low, or up, if investor are anticipating high inflation. 

US Treasuries: A Mostly Uneventful Year

    After a turbulent year in 2020, when COVID shut the global economy down, and interest rates plunged and stayed down for the rest of the year, 2021 was a more settled year, with long term rates rising gradually over the course of the year, but short terms rates staying put:

Treasury Rates Data

While treasury bills continued to yield rates close to zero, rates increased for longer term treasuries, with 2-10 years rates rising much more than rates on the longest term treasuries (20-year to 30-year). For those who track the slope of the yield curve, and I am not one of those who believes that it has much predictive power, it was a confusing year. The treasury curve became steeper, but only at the shortest end of the spectrum, with the slope rising for the 2-year, relative to the 3-month, but not at all, when comparing the 10-year to the 2-year rate. Beyond the 10-year maturity, the slope of the yield curve actually flattened out, with the difference between the 30-year rate and the 10-year rate declining by 0.34%.

Corporate Bonds: No Shortage of Risk Capital

    In my last post, I chronicled the movement in the equity risk premium, i.e. the price of risk in the equity market, during 2021, but the bond market has its own, and more measurable, price of risk in the form of corporate default spreads. Using bond ratings classes to categorize companies, based upon credit risk, I looked at the movement of default spreads during 2021:

Download data

Corporate default spreads decrease across ratings classes, but the decline is much larger for lower rated bonds, with the default spread on high yield bonds registering a drop of 1.25%. Note that the decrease in default spreads, at least for the lower ratings, mirrors the drop in the implied equity risk premium during the course of 2021. Read together, it suggests that private risk capital continued to not just stay in the game, but increased its stake during the course of the year, extending a decade-long run.

Expected Inflation, Interest Rates and Bond Returns

    While day to day movements in interest rates are driven by multiple forces, including the latest smoke signals coming from central banks and investor sentiment, the longer term and drivers of interest rates are fundamental. In particular, if you start by breaking down a long term riskfree rate (like the 10-year treasury bond) into an expected inflation and an expected real interest rate components, you can also reconstruct an intrinsic risk free rate by assuming that the real growth in the economy is a stand-in for the real interest rate and that most investors form expectations of future inflation by looking at the inflation in the most recent year(s):

Download data

In this picture, the actual ten-year treasury bond rate is superimposed against a rough measure of the intrinsic risk free rate (obtained by adding together the actual inflation rate and real growth rate each year) and a smoothed out version (where I used the average inflation rate and real growth rate over the previous ten years). Not only has the intrinsic risk free rate moved in sync with the ten-year bond rate for most of the last seven decades, but you can also see that the main reason why rates have been low for the last decade is not the Fed, with all of its quantitative easing machinations, but a combination of low growth and low inflation. Coming into 2022, though, the intrinsic risk free rate is clearly running ahed of the ten-year treasury bond rate, and if history is any guide, that gap will close either with a rise in the treasury bond rate or a decline in the risk free rate (coming from a recession or a rapid drop off in inflation). 

Unexpected Inflation and Asset Returns

    Note that it is expected inflation that drives interest rates, and that the actual inflation rate can come in above or below expectations. In my post on inflation last year, I drew a contrast between expected and unexpected inflation, arguing that financial assets are affected differently by each component. If expected inflation is high, but it is predictable, investors and businesses have the opportunity to incorporate that inflation into their decision making, with investors demanding higher interest rates on bond and expected returns on stocks, and businesses raising prices on their products/services to cover expected inflation. Unexpected inflation is what catches us off guard, with unexpectedly high inflation leading to a reassessment of pricing (for all financial assets) and an uneven impact across businesses, leaving those with pricing power in a better position than those without that power. 

    To assess how inflation has affected asset returns over time, I broke down the actual inflation rates since 1954 into expected and unexpected components each year, using a brute force assumption that the average inflation rate over the last ten years is the expected inflation rate. (In the last two decades, we have had access to more sophisticated measures of expected inflation, including the difference between the nominal treasury bond and TIPs rates, but not in earlier years). In the graph below, I look at annual returns on stocks, treasury bonds and corporate bonds, with the unexpected inflation numbers also shown:


There are a few aspects of this graph that stand out. With my crude measure of inflation expectations, it looks like it takes time for inflation expectations to shift, during periods of higher or lower inflation, as can be seen in the extended stretches of higher than expected inflation, in the 1970s, and lower than expected inflation in the 1980s. 

    While it is not immediately visible in the graph, returns on stocks and bonds are affected by unexpected inflation, and to illustrate by how much, I broke the 94 years of data into five quartiles, based upon the level of unexpected inflation, with the lowest (highest) quintile representing the years when inflation came in most below (above) expectations, and estimated the annual returns (nominal and real) for stocks, treasuries and corporate bonds in the table below:

With treasuries and corporates, the returns generally get worse, as inflation comes in above expectations, with real returns showing the damage from unexpected inflation. With equities, the sweet spot in terms of returns is when inflation is at or below expectations, and the worst scenarios are when inflation comes in well above expectations.  I also looked at how inflation plays out on equity sub-groupings, on two dimensions, the first being market capitalization and the second being price to book, with the former becoming a stand-in for the vaunted small cap premium and the latter for the value versus growth question.

Over much of the last century, small cap stocks have done better than large cap stocks, when inflation has come in well above expectations, perhaps providing some insight into why the vaunted small cap premium seems have to disappeared over the last two decades of muted inflation. Similarly, the value effect, computed as the premium (or discounted) return earned by low price to book stocks over high price to book, becomes more pronounced during periods when inflation is greater than expected and much less so, during periods when inflation is lower than anticipated.
    Using the same approach with gold and real estate, with the caveat that historical data on the former is more limited, I get the following results:
While gold and real estate both do better than financial assets, when inflation is greater than expected, there is also a clear difference between the two investment classes. Real estate operates more as a neutral hedge, delivering returns that are, for the most part, unscathed by unexpectedly high inflation, but gold is a bet on inflation, delivering the highest returns, when inflation is much greater than expected, and negative returns, when it is lower than expected. Much as I would like to extend this analysis to newer investment classes, there is not enough historical data on crypto currencies or NFTs to allow for the analysis. As I noted in my inflation post in 2021, though, the early evidence is not promising for these new investment categories, at least as inflation and crisis hedges, since they have behaved more like risky equities, at least on a day-to-day basis and during the 2020 crisis, than like gold.

Inflation and Currencies
    Much of this post has been about inflation in the US, and by extension, in US dollar terms, it is worth emphasizing that inflation is a currency-specific phenomenon. While inflation in the US dollar, by dint of its status as the currency in which commodities are priced, can sometimes spill over into other currencies, it remains true that you can have high inflation in one currency, while there is low inflation in other currencies. Inflation differences across currencies play out in two domains, with the first being interest rates in different currencies and the other being exchange rate.
    
Interest Rates across Currencies
    I start every one of my discussions of discount rates with a truism, by stating that the riskfree rate that you start with should reflect the currency in which you have decided to do your valuation. That then becomes the springboard for estimating risk free rates in different currencies, following one of two paths. In the first, you start with government bond rates in the local currency, in different currencies, and adjust those rates for default risk in the local currency government bond. (Government bonds in local currencies do default, and account for a significant proportion of sovereign defaults in the last 50 years). My estimates for the start of 2022 for the currencies where local-currency government bonds are available is below:
Download data

Riskfree rates are highest in currencies, like the Zambian Kwacha or Turkish Lira, where inflation is highest, lower in low-inflation currencies and even negative in currencies, where deflation may be the long term prediction. I am using the default spreads based upon the local currency sovereign ratings for the countries in question, with the government bond rate being the risk free rate only for currencies where the issuing government in triple-A rated. If you dislike this assumption, or do not believe that the government bond rate is a market-set number in a particular market, there is a second approach, where you start with the risk free rate in US dollar or Euros, and adjust it for differential inflation, i.e., the difference in expected inflation between the US and the country in question:
Thus, if the US treasury bond rate is 1.5%, and expected inflation rates in the US and Indonesia are 1% and 4% respectively, the approximate riskfree rate in Indonesian Rupiah will be 4.5% (=1.5% + (4%-1%)) and the more precise riskfree rate in Rupiah will be 4.52% (=1.015*(1.04/1.01)-1). While the expected inflation rate in dollars may be an easy get, it is more difficult to get expected inflation rates in other currencies, but the IMF has estimates for the next five years at this link.

Exchange Rates
    Just as interest rates in currencies are determined, in large part, by inflation differentials, exchange rates over time are also driven by those same inflation differentials. Drawing on one of the oldest relationships in exchange rates, purchasing power parity, you can extract the forward exchange rate in a currency:

Thus, currencies with higher inflation can be expected currency devaluation over time, relative to currencies with lower inflation. As with interest rates, in the short term, there are forces, ranging from central banking intervention to momentum and speculation, that can cause rates to deviate from the inflation script, but in the long term, it is almost impossible to break the cycle.
    Connecting this linkage to the discussion of US inflation in the prior sections, here are the takeaways. If you believe that inflation will stay high, not just in the US, but across the globe, the exchange rate effects will be muted. If, on the other hand, you believe that the inflation shock will vary across countries, your actions will be more nuanced. For the countries where you believe that local inflation will decrease, relative to the US,  the US dollar will weaken against their currencies, augmenting returns you will earn in their markets (stock or bond). For countries, where you see local inflation surging more than you expect to see in the US, the US dollar will strengthen against their currencies, reducing the returns you make in their markets. As with the discussion of asset returns, it is not expected inflation that is the source of exchange rate risk, since you can incorporate those expectations into exchange rates, but unexpected inflation, which, when extreme, can cause significant revaluations of currencies. 

Conclusion
    As with any historical data assessment, I could give you the standard boilerplate disclaimer that past performance is not always a good predictor of the future, but to the extent that the past provides signals, your expectations of how inflation will play out in the coming year will play a key role in your asset allocation and stock selection decisions. If you believe that last year's surge in inflation is a precursor to a long time period when inflation is likely to stay high, and come in above expectations, you should be shifting your holdings away from financial to real assets, and within your equity holdings, towards small cap stocks,  stocks trading at lower pricing multiples (PE, Price to Book) and companies with more pricing power. If, on the other hand, you believe that inflation worries are overdone, and that there will be a reversion back to the low inflation that we have seen in the last decade, staying invested in stocks, and especially in larger cap and high growth stocks, even if richly priced, makes sense.

YouTube Video

Data Links
Blog Post Links

Wednesday, January 19, 2022

Data Update 2 for 2022: US Stocks kept winning in 2021, but…

Leading into 2021, the big questions facing investors were about how quickly economies would recover from COVID, with the assumption that the virus would fade during the year, and the pressures that the resulting growth would put on inflation. In a post at the start of 2021, I argued that while stocks entered the year at elevated levels, especially on historic metrics (such as PE ratios), they were priced to deliver reasonable returns, relative to very low risk free rates (with the treasury bond rate at 0.93% at the start of 2021). At the start of 2022, it feels like Groundhog Day, with the same questions about economic growth and inflation looming for the year, and the same judgment about stocks, i.e., that they look expensive. In this post, I will begin with a historical assessment of stock returns in the recent past, then move on to evaluate the returns that investors can expect to make, given how they are priced at the start of 2022, and end with a do-it-yourself valuation of the index right now.

The year that was.... 

    If equity markets surprised us with their resilience in 2020, not just weathering a pandemic for the ages, but prospering in its midst, US equity markets, in particular, managed to find light even in the darkest news stories, and continued their rise through 2021. Foreign markets, though, had a mixed year, and that divergence is worth noting, since it may provide clues to what may be coming in the next year.

US Equities, in the aggregate

   US equities had a good year, by any measure, with the S&P 500 rising from 3756 at the start of 2021 to end the year at 4766, an increase of 26.90%. While that followed another good year for stocks in 2020, with the index rising 16.25%, from 3231 to 3756, the index took different pathways during the two years:


In 2020, the market was up, but only after it absorbed the after-shocks of the inception of the virus in February and March of 2020. In 2021, the index had a smoother ride, up in nine of twelve months, with only September qualifying a significant drop (with the index down 4.75%). When you augment this price change with the dividends on the index during 2021, the total return on the S&P 500 for 2021 was 28.47%. I report a dataset containing annual returns on stocks, going back to 1928, and to put 2021 in context, I looked at the historical returns on the index:
Download historical returns on US stocks

Looking at the 94 years in this dataset, the returns in 2021 would have ranked 20th on the list, good, but not exceptional. Note, though, that 2021 is the third consecutive year of very good returns on the index, with 2019 delivering 31.21%, and 2020 generating 18.02%, and that the cumulative return over the three years (2019-21) is 98.95%. If you compute cumulative returns, on a rolling three-year time period (1928-30, 1929-31, 1930-32 etc.), the 2019-21 time period would rank 8th on the list of 92 3-year time periods. The table below provides the rankings for returns over 5-year and 10-year periods, and where the most recent three-year, five-year and ten-year cumulative returns would rank on the list:
Download return rankings

In sum, if you have money to invest over the last decade, and you stayed invested, you should count yourself as lucky to have enjoyed one of the great market runs of the last century. Conversely, if you stayed out of the market, for the last decade, you would have committed one of the great investing mistakes of all time, and blaming the Fed or bubble-talk will not bring you absolution.

US Equities, by sub-group

    It has always true that when markets move, up or down, not all sectors and sub-groups are treated equally. I do believe that too much is often made of these differences, as it is generally more the rule than the exception that markets, when they are up strongly, get the bulk of that rise from a small sub-set of stocks or sectors. Using S&P's sector classification, I take a look at how each one did in 2022, looking at the percent changes in market capitalization:

In contrast to 2020, when technology and consumer discretionary firms ran well ahead of the pack, the best performing sectors in 2021 were energy and real estate, two of the biggest laggards in 2020. That can be viewed as vindication, at least in this year, for contrarians, but as a cautionary note for ESG advocates, who assumed that fossil fuel companies were on a death march, based upon their performance over the last decade.

There is no debate more likely to draw heat than the value versus growth debate, and at the risk of being labeled simplistic by value investors, I looked at returns on companies, in 2021, based upon their PE ratios at the start of 2021:


Unlike 2020, where high PE stocks beat low PE stocks decisively, the results in 2021 were mixed, with no clear patterns across the classes. The results are similar if you break stocks down based upon price to book ratios or revenue growth rates. Finally, and in keeping with my fixation on corporate age and life cycles, I broke companies down by company age (measured from the founding year):

Again, unlike 2020, when young companies delivered significantly higher returns than older companies, the best returns in 2021 were delivered by middle aged companies.

For the rest of the world

   While US equities continued to set new highs in 2021, the picture in the rest of the world was not as rosy, as you can see in the table below (with percent returns in US dollar terms):


In US dollar terms, India had the best-performing market in 2021, following a strong 2020, but China, the best performer in the world in 2020 came back to earth in 2021. North America (US and Canada) outperformed the globe, but Latin America was the worst performing region, down more than 20% in US dollar terms. There are many reasons why markets diverge, but here again the contrast with 2020 is worth drawing. In 2020, the COVID crisis played out across markets, increasing the co-movement and correlation across developed markets, with the US, Europe and Japan moving mostly in sync. In 2021, you saw a return to more normal times, with markets in each country affected more by local factors.

The Price of Risk in Equity Markets

    The allure of having the historical data that we do in financial markets, especially in the United States, is that there is information in the past. The danger of poring over this historical data is that a focus on the past can blind us to structural changes in markets that can make the future very different from the past. To get a measure of what equity markets are offering in terms of expected returns, we are better served with a forward-looking and dynamic measure of these returns, and that is the focus of this section.

Implied Equity Risk Premiums

   To understand the intuition behind the implied equity risk premium, it is easiest to start with the concept of a yield to maturity on a bond, computed as the discount rate that makes the present value of the cash flows on the bond (coupons, during the bond's lifetime, and face value, at maturity) equal to the price of the bond. With equities, the cash flows take the form of dividends and buybacks, and in addition to estimating them using future growth rates, you have to assume that they continue in perpetuity. In computing this implied equity risk premium for the S&P 500, I start with the dividends and buybacks on the stocks in the index in the most recent year (which is known) and assume that they grow at the rate that analysts who follow the index are projecting for the next five years. Beyond the fifth year, I make the simplifying assumption that earnings growth will converge on the nominal growth rate of the economy, which I set equal to the risk free rate

If you set the present value of the expected cash flows equal to the index level today, and solve for a discount rate (you may need to use the solver function in Excel, or trial and error), the resulting number is the expected return on stocks, based upon how stocks are priced today, and expected cash flows. This approach is built on the proposition that the intrinsic value of stocks is the present value of the expected cash flows that you generate in perpetuity, from holding these stocks, but it is model agnostic. Put simply, it does not require that you believe in any risk and return model in finance, since it is based on price and expected cash flows. To the critique that analysts can over estimate future earnings and  growth, the response is that even if they do (and there is no evidence that top-down forecasts are biased), it is the price of risk, given expected cash flows.

The Implied ERP - Start of 2022

I have computed the implied equity risk premium at the start of every month, since September 2008, and during crisis periods, I compute it every day.  Over the course of 2021, as the index rose, risk free rates climbed and analysts got much more upbeat about expected earnings for the next three years, the equity risk premium drifted down, to end the year at 4.24%:

Download spreadsheet

Much as I would love to claim that I have the estimated the equity risk premium to the second decimal point, the truth is that there is some give in these numbers and that changing assumptions about earnings and cash flows generates an equity risk premium between 4-5%. The contrast between the behavior f equity risk premiums in 2020 and 2021 are in the picture below, where I show my (daily) estimates of ERP during 2020 on the left, and my (monthly) estimates of ERP for 2021 on the right. 

Download data on ERP by month from 2008-2021

During 2020, the equity risk started the year at about 4.7%, spiraled to almost 8% on March 23, 2020, before reverting back quickly to pre-crisis levels by September 2020. During 2021, you saw equity risk premiums revert back to a more sedate path, with numbers staying between 4% and 5% through the course of the entire year.

Historical Perspective

    As talk of a bubble fills the air, one way to reframe the question of whether stocks are in bubble territory is to ask whether the current implied equity risk premium has become “too low”. If your answer is yes, you are arguing that stocks are over priced, and if the answer is no, that they are under priced. At least on the surface, the current level of the equity risk premium is not flashing red lights, since at 4.24%, it is running slightly above the long term averages of 4.21% (1960 - 2021).

Download past implied ERP

That said, there are two reasons for concern. The first is that the premium is now lower than the average premium since 2008, a period that perhaps better reflects the new global economy. The second and scarier reason is that the 5.75% expected return that is implied in today’s stock prices is close to a sixty-year low:

Download past implied ERP

A pessimist looking at this graph will conclude that expected returns on stocks have become too low, and that we are due for a correction, but that would be more a statement about treasury bond rates being too low than about equity risk premiums. Even if you belong to the camp arguing that low risk free rates are now the norm, this graph suggests that we all need to re-examine how much we, as individuals, are saving for retirement, since the old presumption that you can earn 8-10% investing in stocks will longer hold. Across the United States, defined-benefit pension funds that have set aside funds on this same assumption will face massive funding shortfalls, unless they reevaluate benefit levels or infuse new funds.

A Market Assessment

  If you look at history, it seems difficult to argue against the notion that market timing is the impossible dream, but that has never stopped investors from trying to time markets, partly because the payoff from being right is immense. I have long claimed that I am not a market timer, but that is a lie, since every investor times markets, with the difference being in whether the timing is implicit (with cash holdings in your portfolio increasing, when you feel uneasy about markets, and decreasing, when you feel bullish) or explicit (where you actively bet on market direction). Rather than just give you just my estimate of whether I think the market is under or over valued, I will ask each of you to make your own judgments, while also offering my own. 

    The process of valuing the index starts with an assessment of expected earnings, and with the S&P 500, there is no shortage of either historical data or assessments of the future, on this dimension. Let's start with a look at S&P earnings over time:

Download historical earnings

While COVID wreaked havoc with corporate earnings in 2020, the comeback in earnings in 2021 has been remarkable, with trailing 12-month earnings (October 2020 - September 2021) at 190.34, and estimated earnings for 2021 of 206.38, both significantly higher than the 162.35 that was earned in 2019  (pre-COVID). At the end of 2021, analyst estimates for earnings in 2022 and 2023 reflect their views that the earnings recovery will continue:

I will use the analyst estimates as my expected earnings for the index for the next two years, but assume that earnings growth rate thereafter will move down over the following three years to a stable growth rate (set equal  to the risk free rate). It is true that analysts are often wrong, and in some cases, biased, but the latter is more of a problem with analyst estimates for individual companies, than for market aggregate earnings. However, if you believe that analysts have overestimated earnings, my valuation spreadsheet gives you the option of haircutting those estimates. Conversely, if your contention is that analysts are still playing catch-up, you can increase their estimates by a factor of your choosing.

    Investors don't get value from earnings directly, but do get value from the cash flows flowing from those earnings. As I have noted in prior posts, these cash flows, which used to entirely take the form of dividends, have increasingly shifted, over the last three decades, to stock buybacks. 

While dividends are stickier than buybacks, insofar as companies are more willing to reduce the latter during crisis years like 2009 and 2020, it is also clear, as the comeback in buybacks in 2021 shows. In my base case valuation, I will start with 77.36%, the percent of earnings that companies have returned to shareholders, in dividends and buybacks, in the last twelve months, but I will increase this over time to a cash payout ratio that is consistent with my estimate of stable growth (risk free rate) and the return on equity of 16.10% that S&P 500 companies have earned, on average, over the last decade. (Sustainable Payout Ratio = 1 - g/ ROE; with a 16.10% return on equity and a 2.5% growth rate, the payout ratio in stable growth is 84.47%= 1 - .025/.161).

    On the risk free rate, I start with 1.51%, the 10-year treasury bond rate on January 1, 2022, but I will assume that this rate will drift upwards over the next five years to reach 2.5%. That reflects my view that inflation pressures will push up long term rates in the year to come and has little to do with what the Fed may or may not do with the Fed funds rate. Finally, I build in the expectation that a fair ERP for the S&P 500 should be 5%, higher than the long term historical average of 4.21%, but closer to the average ERP since 2008. On both these macro assumptions, I encourage you to take your own point of view. With these assumptions in place, my valuation for the S&P 500, as of January 1, 2022, is shown below:

Download spreadsheet to value S&P 500 index

Note that even in the two weeks since I did this valuation, there have been material changes in key inputs, with the treasury bond rate rising to 1.87% on January 19, 2022, and the S&P dropping to 4533, down 3.8% from its level at the start of the year. 

In Conclusion

    As with any valuation, I don't believe that I should try to convince you that my valuation is the right one, nor do I have no desire to do so. In fact, I know that my valuation is wrong, with the question being in what direction, and by how much. I would strongly encourage you to take my valuation spreadsheet, change the numbers that I have used on earnings, cash flows, the risk free rate and the equity risk premium to reflect your views, and come up with your own assessment of value. Good investing requires taking ownership of your investment decisions, and trusting this choice to talking heads on TV, market strategists at investment banks or those market gurus who looked good last year is a dereliction of investment duty.    

YouTube Video

Datasets (to download)

  1. Historical returns on stocks, bonds, bills and real estate: 1928 - 2021
  2. Historical implied ERP on the S&P 500: 1960 -2021

Spreadsheet (to value the S&P 500)

  1. Spreadsheet to compute implied ERP on January 1, 2022
  2. Spreadsheet to value the S&P 500 on January 1, 2022


Saturday, January 8, 2022

Data Update 1 for 2022: It is Moneyball Time!

Happy New Year, and I hope that 2022 brings you good tidings! To start the year,  I returned to a ritual that I have practiced for thirty years, and that is to take a look at not just market changes over the last year, but also to get measures of the financial standing and practices of companies around the world. Those measures took a beating in 2020, as COVID decimated the earnings of companies in many sectors and regions of the world, and while 2021 was a return to some degree of normalcy, there is still damage that has to be worked through. This post will be one of a series, where I will put different aspects of financial data under the microscope, to get a sense of how companies are adapting (or not) to a changing world.

The Moneyball Question

When I first started posting data on my website for public consumption, it was designed to encourage corporate financial analysts and investors alike to use more data in their decision making. In making that pitch, I drew on one of my favorite movies, Moneyball, which told the story of Billy Beane (played by Brad Pitt), the general manager of the Oakland As, revolutionized baseball by using data as an antidote to the gut feeling and intuition of old-time baseball scouts.


In the years since Beane tried it with baseball, Moneyball has decisively won the battle for sporting executives' minds, as sport after sport has adopted its adage of trusting the data, with basketball, football, soccer and even cricket adopting sabermetrics, as this sporting spin off on data science is called. Not surprisingly, Moneyball has found its way into business and investing as well.  In the last decade, as tech companies have expanded their reach into our personal lives, collecting information on choices and decisions that used to private, big data has become not just a buzzword, but also a justification for investing billions in companies/projects that have no discernible pathway to profitability, but offer access to data.  Along the way, we have all also bought into the notion of crowd wisdom, where aggregating the choices of tens of thousands of choice-makers, no matter how naive, yields a consensus that beats expert opinion. After all, we get our restaurant choices from Yelp reviews, our movie recommendations from Rotten Tomatoes, and we have even built crypto currencies around the notion of crowd-checking transactions.

Don't get me wrong! I was a believer in big data and crowd wisdom, well before those terms were even invented. After all, I have lived much of my professional life in financial markets, where we have always had access to lots of data and market prices are set by crowds of investors. That said, it is my experience with markets that has also made me skeptical about the over selling of both notions, since we have an entire branch of finance (behavioral finance/economics) that has developed to explain how more data does not always lead to better decisions and why crowds can often be collectively wrong. As you use my data, I would suggest four caveats to keep in mind, if you find yourself trusting the data too much:
  1. More data is not always better than less data: In a post from a few months ago, I argued that we as investors and analysts) were drowning in data, and that data overload is now a more more imminent danger than not have enough data. I argued that disclosure requirements needed to be refined and that a key skill that analysts will need for the future is the capacity to differentiate between data and information, and materiality from distraction.
  2. Data does not always provide direction: As you work with data, you discover that its messages are almost always muddled, and that estimates always come with ranges and standard errors. In short, the key discipline that you need to tame and use data is statistics, and it is one reason that I created my own quirky version of a statistics class on my website.
  3. Mean Reversion works, until it does not: Much of investing over the last century in the US has been built on betting on mean reversion, i.e. that things revert back to historical norms, sooner rather than later. After all, the key driver of investment success from investing in low PE ratio stocks comes from their reverting back towards the average PE, and the biggest driver of the Shiller PE as a market timing device is the idea that there is a normal range for PE ratios. While mean reversion is a strong force in stable markets, as the US was for much of the last century, it breaks down when there are structural changes in markets and economies, as I argued in this post
  4. The consensus can be wrong: A few months ago, I made the mistake of watching Moneyheist, a show on Netflix, based upon its high audience ratings on Rotten Tomatoes, and as I wasted hours on this abysmal show, I got a reminder that crowds can be wrong, and sometimes woefully so. As you look at the industry averages I report on corporate finance statistics, from debt ratios to dividend yields, remember that just because every company in a sector borrows a lot, it does not mean that high debt ratios make sense, and if you are using my industry averages on pricing multiples, the fact that investors are paying high multiples of revenues for cloud companies does not imply that the high pricing is justified.
In short, and at the risk of stating the obvious, having access to data is a benefit but it is not a panacea to every problem. Sometimes, less is more!

The Company Sample for 2022
When I first started my data collection and analysis in 1990, data was difficult to come by, and when available, it was expensive. Without hundreds of thousands of dollars to spend on databases, I started my journey spending about a thousand dollars a year, already hitting budget constraints, subscribing to a Value Line database that was mailed to me on a CD every year. That database covered just 1700 US companies, and reported on a limited list of variables on each, which I sliced and diced to report on about a dozen variables, broken down by industry. Times have changed, and I now have access to extraordinarily detailed data on almost all publicly traded global companies. I am grateful to all the services that provide me with raw data, but I am cognizant that they are businesses that make money from selling data, and I try not to undercut them, or act as a competitor. That is why almost every variable that you will see me reporting on my website represents a computation or estimate of mine, albeit with raw data from a provider, rather than a regurgitation of data from a service. It is also why I report only aggregated data on industries, rather than company-level data.

Regional Breakdown
My data sample for 2022 includes every publicly traded firm that is traded anywhere in the world, with a market capitalization that exceeds zero. That broad sweep yields a total of 47,606 firms, spread across 135 countries and every continent in the world:

The largest slice is Small Asia, where small has to be read in relative terms, since it includes all of Asia, except for India, China and Japan, with 9,408 firms. It is followed by the United States, with 7,229 firms, and then China (including Hong Kong listings), with 7.043 firms. Since many of these firms have small market capitalizations, with some trading at market caps of well below $10 million, the chart below looks at the breakdown of the sample in market capitalization:

The market capitalization breakdown changes the calculus, with the US dominating with $52 trillion in collective market cap, more than 40% of the overall global value, followed by China with $19 trillion in aggregate market capitalization. 

Sector/Industry Breakdown
The most useful way to categorize these 47,606 companies is by industry groupings, but that process does raise thorny questions about what industry groupings to use, and where to put firms that are not easily classifiable. To illustrate, what business would you put Apple, a company that was categorized (rightly) as a computer hardware company 40 years ago, but that now gets more than 60% of its revenues and profits from the iPhone, a telecommunication device that is also a hub for entertainment and services? I started my classification with a very broad grouping, based upon S&P's sector classes:
This should not come as a surprise, especially given their success in markets over the last decade, but technology is the largest sector, accounting for 19.22% of global market capitalization, though industrials account for the largest number of publicly traded firms. One sector to note is energy, which at 4.86% of global market capitalization at the start of 2022, has seen its share of the market drop by roughly half over the last decade. Addressing the legitimate critique that sector classifications are too broad, I created 94 industry groupings for the companies, drawing on the original classifications that I used for my Value Line data thirty years ago (to allow for historical comparisons) and S&P's industry list. The table below lists my industry groups, with the number of companies in each one:
I am sure that some of you will find even these industry groupings to be over-broad, but I had to make a compromise between having too many groupings, with not enough firms in each one, and too few. It also required that I make judgment calls on where to put individual firms, and some of those calls are debatable, but I feel comfortable that my final groups are representative.

The Data Variables
When I first started reporting data, I had only a dozen variables in my datasets. Over time, that list has grown, and now includes more than a hundred variables. A few of these variables are macro variables, but only those that I find useful in corporate finance and valuation, and not easily accessible in public data bases. Most of the variables that I report are micro variables, relating to company choices on investing, financing and dividend policies, or to data that may be needed to value these companies.

Macro Data
If your end game is obtaining macroeconomic data, there are plenty of free databases that provide this information today. My favorite is the one maintained by the Federal Reserve in St. Louis, FRED, which contains historical data on almost every macroeconomic variable, at least for the US. Rather than replicate that data, my macroeconomic datasets relate to four key variables that I use in corporate finance and valuation.
  1. Risk Premiums: You cannot make informed financial decisions, without having measures of the price of risk in markets, and I report my estimates for these values for both debt and equity markets. For debt markets, it takes the form of default spreads, and I report the latest estimates of these corporate bond spreads at this link. In the equity market, the price of risk (equity risk premium) is more difficult to observe, and I start by reporting on the conventional estimate of this measure by looking at historical returns (going back to 1928) on stocks, bonds, bills and real estate at this link. I offer an alternative forward-looking and more dynamic measure of this premium in an implied premium, with the start of 2022 estimate here and the historical values (going back to 1960) of this implied premium here.
  2. Risk free Rates: While the US treasury bond rate is widely reported, I contrast its actual value with what I call an intrinsic measure of the rate, computed by adding the inflation rate to real growth each year at this link
  3. Currency and Country Risk: Since valuation often requires comfort with moving across currencies, I provide estimates of risk free rates in different currencies at this link. I extend my equity risk premium approach to cover other countries, using sovereign default spreads as my starting point, at this link.
  4. Tax Rates: Since the old saying about death and taxes is true, I report on marginal tax rates in different countries at this link, and while I would love to claim that I did the hard work, the credit belongs to KPMG for keeping this data updated over time.
I do update my equity risk premiums for the US at the start of every month on my website, and the country equity risk premiums once every six months. 

Micro Data
I am not interested in reported financial ratios, just for the sake of reporting them, and my focus is therefore on those statistics that I use in corporate finance and valuation. You may find my choices to be off putting, but you could combine my reported data to create your own. For example, I believe that return on assets, an accounting ratio obtained by dividing net income by total assets, is an inconsistent abomination, leading to absurd conclusions, and I refuse to report it, but I do report returns on invested capital and equity. 

Rather than just list out the variables that I provide data on, I have classified them into groups in the table below:
Data on my site

With each of these variables, I report industry averages for all companies globally, as well as regional averages for five groups: (a) US, (b) EU, UK and Switzerland, (c) Emerging Markets, (d) Japan and (e) Australia, NZ and Canada. Since the emerging market grouping is so large (representing more than half my sample) and diverse (across every continent), I break out India and China as separate sub-groups. You can find the data to download on my website, at this link.

Data Timing and Timeliness
Almost all of the data that you will see in my updates reflects data that I have collected in the last week (January 1, 2022- January 8, 2022.  That said, there will be difference in timeliness on different data variables, largely based upon whether the data comes from the market or from financial statements. 
  • For data that comes from the market, such as market capitalization and costs of capital, the current data is as of January 1, 2022.
  • For data that comes from financial statements, the numbers that I use come from the most recent filings, which for most companies will be data through September 30, 2021. 
Thus, my trailing PE ratio for January 1, 2022, is computed by dividing the market capitalization on January 1, 2022, by the earnings in the twelve months ending in September 2021. While that may seem inconsistent, it is consistent with the reality that you, as an investor or analyst, use the most current data that you can get for each variable. As we go through the year, both the market and the accounting numbers will change, and a full-fledged data service would recompute and update the numbers. I am not, and have no desire to be, a data service, and will not be updating until the start of 2023. Thus, there are two potential dangers in using my data later in the year, with the first emerging if the market sees a steep shift, up or down, which will alter all of the pricing multiples, and the second occurring in sectors that are either transforming quickly (disrupted sectors) or are commodity-based (where changes in commodity prices can alter financials quickly).

Estimation Choices
When I embarked on the task of estimating industry averages, I must confess that I did not think much of the mechanics of how to compute those averages, assuming that all I would have to do is take the mean of a series of numbers. I realized very quickly that computing industry averages for pricing and accounting ratios was not that simple. To illustrate why, I present you with a slice of my table of PE ratios, by industry grouping, for US firms, the start of 2022:
PE ratio, by industry, for US companies
Take the broadcasting group, just as an illustration, where there were 29 firms in my US sample. The three columns with PE ratios (current, trailing and forward) represent simple averages, but these case be skewed for two reasons. The first is the presence of outliers, since PE ratios can be absurdly high numbers (as is the case with auto & truck companies), and can pull the averages up. The second is the bias created by removing firms with negative earnings, and thus no meaningful PE ratio, from the sample. The last two columns represent my attempts to get around these problems. In the second to last column, I compute an aggregated PE ratio, by taking the total market capitalization of all firms in the group and dividing by the total earnings of all firms in the group, including money losers. In effect, this computes a number that is close to a weighted average that includes all firms in the group, but if a lot of firms are money-losers, this estimate of the PE ratio will be high. To see that effect, I compute an aggregated PE ratio, using only money-making firms, in the last column. You may look at the range of values for PE ratios, from 7.05 to 24.99 for broadcasting firms, and decide that I am trying to confuse the issue, but I am not. It is the basis for why I take all arguments that are based upon average PE ratios with a grain of salt, since the average that an analyst uses will reflect the biases they bring to their sales pitches. 

The other issue that I had to confront, especially because my large sample includes many small companies, listed and traded in markets with information disclosure holes, is whether to restrict my sample to markets like the US and Europe, where information is more dependable and complete, or to stay with my larger sample. The problem with doing the former is that you create bias in your statistics by removing smaller and risker firms from your sample, and I chose to have my cake and eat it too, by keeping all publicly traded firms in my global sample, but also reporting the averages for US and European firms separately.

Using the Data
I report the data on my website, because I want it to be used. So, if you decide that some  of the data is useful to you, in your investing or analysis, you are welcome to use it, and you don't have to ask for permission. If you find errors in the data, please let me know, and I will fix it. If you are looking for a variable that I do not compute, or need an average for a region that I don't report separately on (say Brazil or Indonesia), please understand that I cannot meet customized data requests. I am a solo operator, with other fish to fry, and there is no team at my disposal. As I mention in my website, this data is meant for real time analysis for those in corporate finance and valuation. It is not designed to be a research database, though I do have archived data on most of the variables going back in time, and you may be able to create a database of your own. If you do use the data, I would ask only three things of you:
  1. Understand the data: I have tried my best to describe how I compute my numbers in the spreadsheets that contain the data, in worksheets titled "Variables and FAQ". On some of the variables, especially on equity risk premiums, you may want to read the papers that I have, where I explain my reasoning, or watch my classes on them. Whatever you do, and this is general advice, never use data from an external source (including mine), if you do not understand how the data is computed.
  2. Take ownership: If you decide to use any of my data, especially in corporate financial analysis and valuation, please recognize that it is still your analysis or valuation. 
  3. Don't bring me into your disagreements, especially in legal settings: If you are in disagreement with a colleague, a client or an adversary, I am okay with you using data from my website to buttress your arguments, but please do not bring me in personally into your disputes. This applies in spades, if you are in a legal setting, since I believe that courts are where valuation first principles go to die.
Conclusion
I would love to tell you that I am driven by altruistic motives in sharing my data, and push for sainthood, but I am not.  I would have produced all of the data that you see anyway, because I will need it for my work, both in teaching and in practice, all year. Having produced the data, it seems churlish to not share it, especially since it costs me absolutely nothing to do so. If there is a hidden agenda here, it is that I think that in spite of advances over the last few decades, the investing world still has imbalances, especially on data access, and I would like it make a little flatter. Thus, if you find the data useful, I am glad, and rather than thank me, please pass on the sharing. 

YouTube

Links