A Corsair Valuation (NASDAQ:CRSR) – Post-IPO Update

In this blog post I take a shot at valuing Corsair (NASDAQ:CSRS) using a discounted cash flow valuation method. The calculation suggest an equity value ranging from US$1.62 to US$2.76B.

corsair logo

The Corsair Touch

Corsair Gaming Inc. is an American computer gaming components, peripherals, and systems company founded in 1994 as Corsair Microsystems by Andy Paul, John Beekley, and Don Lieberman. While originally selling processor cache and later system memory modules, soon Corsair started gravitating towards the DIY computer enthusiast market segment.

Over the past two decades Corsair has significantly diversified its product portfolio. Starting with flash memory and power supplies in 2006, Corsair is now a market leader in a wide range of product categories including computer chassis, gaming peripherals, cooling solutions, and streaming gear.

What enables Corsair to become so successful is what I’ll call the “Corsair Touch”. The Corsair Touch describes how Corsair enters a product category and finds a way to become successful. The Corsair Touch consists of a couple of key ingredients.

  1. Hire or develop experts who are technically proficient and deeply involved with the enthusiast community. The experts have a finger on the pulse when it comes to market trends. Not only can they anticipate new market trends, they also know how to integrate the new trends in future products. Corsair is rarely first to move with a new trend, but more often than not they make the right move.
  2. Enter any new market with a high-end product to win over the enthusiasts and establish a credible brand reputation. Then expand with more affordable offerings to gain market share. However, always stay clear of the low-end price-sensitive segment.
  3. Outsource most if not all manufacturing to lower-cost OEMs in Asia and avoid investing in fixed assets.
  4. Finally, leverage the world-class worldwide distribution and sales engine to push the products to the market

On August 21st, 2020, Corsair Gaming, Inc. filed its IPO prospectus with the SEC aiming to go public on the Nasdaq exchange under the symbol CRSR.

Gathering Information

There are four major value drivers to consider:

  1. Revenue, growth, and duration of growth
  2. Profitability and efficient use of assets
  3. Reinvestment in existing and growth assets
  4. Risk.

We can use the following documents to gather information about Corsair’s value drivers from 2005 to 2020:

corsair financial data

For reference I also collected data from publicly listed peers Logitech, Turtle Beach and Razer using the data service provider Finbox.

corsair comparables data

You can download the excel sheet here: https://hanweiconsulting.com/wp-content/uploads/2020/09/fcffsimpleginzu-corsair-v1.1.xlsx.

Revenue Growth

As mentioned in the opening paragraphs, Corsair has diversified its product portfolio away from the highly commoditized and volatile DRAM memory market. The company has successfully expanded into a wide range of computer components, accessories, and peripherals. You can see this expansion illustrated in a picture included in the IPO prospectus.

Between 2005 and 2010 Corsair is a nimble growth company focused on driving revenue through expanding the product portfolio and riding the organic growth of the PC DIY market. Between 2010 and 2015, the PC DIY market slows down, and Corsair identifies PC gaming as a market segment with above industry growth potential and more favorable margins.

After an unsuccessful IPO in 2010 and 2012, Corsair turns to Francisco Partners and obtains a $75 million strategic investment in the company. The investment is used to execute the growth strategy outlined in the 2010/2012 IPO prospectus:

  1. Achieve Leading Market Position in Each Product Family
  2. Increase Sales of Gaming Peripherals
  3. Leverage Our Scalable Operating and Business Model
  4. Build on Our Existing Infrastructure to Address Growing Opportunities in the Asia Pacific Region
  5. Selectively Pursue Complementary Acquisitions

In 4 years, Corsair doubled its revenue and becomes a $1 billion dollar company. Considering Corsair’s current position, it’s safe to say they absolutely succeeded in each of their strategic goals.

In 2017, Francisco Partners sold its stake in Corsair to EagleTree Capital. From the Press Release we note that the post-acquisition EagleTree aims to “[…] maintain the company’s focus on innovative products, to expand into new markets, and to pursue selective transactions”. This aligns with the growth strategy outlined in the 2020 IPO prospectus:

  1. Advance as the global leader in high-performance gaming and streaming gear.
  2. Continue to develop innovative, market-leading gaming and streaming gear.
  3. Expand into new gear and services that grow our market opportunity.
  4. Leverage our software platforms to sell more gear to existing customers.
  5. Strengthen relationships with end-users by increasing direct-to-consumer sales.
  6. Continue to grow market share globally.
  7. Selectively pursue complementary acquisitions.

The 7 strategies outlined boil down to 2 standard growth strategies: (1) organic growth through horizontal diversification, and (2) inorganic growth through M&A.

Profitability

Corsair operates a global, scalable, nimble business model utilizing the “Corsair Touch” to respond quickly to new market trends and demands. The facility in Taiwan assembles, tests, packages, and supplies the DRAM, liquid cooling products and pre-built gaming systems. All other Corsair products are produced at third-party, outsourced, factories located in China, Taiwan, and South-East Asia.

The outsourcing operations strategy allows Corsair to leverage the intense competition between suppliers and choose the best quality and best price. This helps maximize customer willingness to pay (increases price) and helps reduce cost, which combined allows Corsair to capture more value.

The DRAM business is still a significant part of Corsair’s overall business and has a big impact on profitability. DRAM is highly commoditized and operating profits are determined by volatility in market demand and supply, as well as timing of purchase. The gaming peripherals typically have a much higher gross margin in the range of 35-40% or higher.

Since 2007, Corsair has steadily increased gross margin by diversifying into higher-margin product categories. That said, Corsair’s gross margin of 24.2% is still well below industry peers Logitech and Turtle Beach’s 35% and higher gross margin. The same can be said about the operating margin. While positive, unlike its industry rival Razer, the operating margin fluctuates between 2% and 6%. This is also below industry peers Logitech and Turtle Beach. Expressed as a percentage of revenue, both Product Development (RD) and SG&A expenses are below the industry peers.

Reinvestment

Looking at the 2018 and 2019 cash flow statements, Corsair has every scent of an early growth company. The cash flow from operations is relatively low compared to the vast amount of cash for investment financed by debt. However, the picture changes if we factor out the recent three acquisitions of Elgato (2018, $46.6 million), Origin PC (2019, $13.8 million) and SCUF Gaming (2019, $136 million). In the 18 months spanning 2019 and the first half of 2020, Corsair spent $126+$10 million in cash on the three aforementioned companies representing 90% of all investment activities. This paints the picture of a company that is primarily looking at acquisitions to fuel future growth rather than reinvesting in existing assets in place.

This can be good or bad news.

It is good news if management believes the current assets in place and operations are well-tuned and ready to provide significant profits as they scale up further. In this case the existing core business becomes the cash cow to fuel the M&A inorganic growth. This offers a well-balanced short-term and long-term perspective for the company.

It is bad news if management believes the current assets in place have no future and the only growth can come from bringing outside products and people to guarantee the future of the company.

Risk

I use weighted average cost of capital (“WACC”) calculation to determine the risk. WACC has the following components: equity and debt.

Cost of Equity

To determine the cost of equity we use the following inputs:

  • Long-term Riskfree rate: US 10Y bond yield = 0.69% (Sept 10, from tradingeconomics.com)
  • Unlevered beta: 1.35 (Sept 10, from Damodaran‘s latest Valuation Spreadsheet)
  • Equity risk premium: 6.4275% (Sept 10, calculated using Damodaran‘s latest Valuation Spreadsheet and Corsair’s revenue per region)

Cost of Debt

To determine the cost of debt we use the following inputs:

  • Long-term Riskfree rate: US 10Y bond yield = 0.69% (Sept 10, from tradingeconomics.com)
  • Interest Coverage Ratio: 2.05, which results in an estimated synthetic rating of B2/B and associated estimated company default spread of 8.25% (Sept 10, from Damodaran‘s latest Valuation Spreadsheet)
  • Average maturity: 4 years (90% of debt is due in 2024)
  • Tax rate: 25% (United States corporate tax rate)

WACC

(in thousands)EquityDebt + Operating LeasesCapital
Market Value (*)$549,610$481,449$1,031,060
Weight in Cost of Capital54.32%46.69%100%
Cost of component14.95%6.71%11.10%
(*) market value of equity is determined by the total purchase price consideration of Eagletree’s acquisition of Corsair detailed on Page 72 in the IPO

The cost of capital is relatively high because the high debt-to-equity (increases relevered beta) and low interest coverage rate (lowers synthetic rating). The easiest way to improve the WACC is to use the proceeds of the IPO to lower the debt. This will not only provide additional free cash flow (less interested to be paid) but also increase debt capacity at more favorable interest rates.

The additional debt capacity can then be used as a source of finance for future acquisitions.

Initial Corsair Valuation

Using Damodaran’s model for DCF valuation, an initial Corsair valuation could look like this.

Revenue growth: 15% 2-5Y CAGR. High growth in the coming 5 years driven by continued aggressive expansion of the product portfolio both organically (new product launches in existing categories) and inorganic (acquire market leading companies).

Profitability: 15% EBIT in Year 10: leverage the lean business model to sell more of the same products with minimum overhead, focus on diversifying the portfolio with high-margin computer peripherals, and drive margin with aggressive direct-to-customer business.

Reinvestment: 2.00x Sales-to-Capital in Year 10: continue the focus of reinvestment on growth assets rather than fixed assets, acquire the right companies to be #1 or #2 player in each entered product category or segment, continue the “Corsair Touch”.

Risk: 5.92% WACC in Year 10: similar to that of mature companies (riskfree rate + 4.5%)

Value of Equity ~ US $3.58B

Valuation Caveats

The initial valuation paints a positive picture of Corsair’s future, its projected cash flows and its value. In this section I want to add more personal side notes to this Corsair valuation and hopefully add perspective.

Revenue Growth

The revenue growth as projected in the Corsair valuation depends on the continued success in the existing product categories and the outstanding success of future product categories and acquisitions. The success essentially depends on the future success of the “Corsair Touch”.

For the “Corsair Touch” to be successful Corsair needs to continue to attract and retain industry experts, and those experts must continue to create value that Corsair customers are willing to pay a premium for. This value not only depends on Corsair but also on the rate of innovation of the OEMs and suppliers who produce the Corsair products. Since Corsair does little own manufacturing it needs a strong and integrated value chain. If the rate of innovation drops significantly and Corsair is no longer able to create products that customers are willing to pay a premium for, it risks being dragged into a price war with lower cost companies.

Additionally, a key strength of the “Corsair Touch” is the global, scalable, nimble business model. For this strength to help fuel growth, Corsair must be able to identify the product categories that have high synergy with the business model. The 2018 Elgato acquisition is a perfect example of this.

Elgato is a market leader in streaming equipment for PC gaming, had a limited high-margin product portfolio of mainstream plug and play equipment, and is operating in a hot and rapidly growing market. The combination “PC”, high-margin”, “plug and play”, “limited portfolio”, and “high growth” is a perfect fit for the “Corsair Touch” model and I have no doubts it will be a success.

Potential targets similar like Elgato could be:

  • Thrustmaster, leader in joysticks, game controllers and steering wheels
  • Hercules, leader in PC-DJ equipment and software
  • Fanatec, leader in sim racing hardware and equipment

SCUF Gaming is a different story as they produce highly customizable game controllers targeted at console gamers. While the high (gross) margin is a plus point, it remains to be seen how the “Corsair Touch” can be levered with these products. After all, Corsair is more known as a “PC Gaming” company and not as a general ‘Gaming” company like their competitor Razor. Also, the “Corsair Touch” does not really cater well to customized products.

Perhaps SCUF Gaming is a way for Corsair to establish itself as more than just a PC Gaming company and expand the product portfolio to all types of gaming. Including PC, console, handheld, mobile, and cloud gaming. That would certainly open up a lot of new avenues for expanding the product portfolio.

Profitability

The profitability case hinges on two main factors. One, leverage the “Corsair Touch” and charge a premium in high-margin product categories. Two, increase the direct-to-customer sales.

I already discussed the first point at length in the previous sections.

In July 2020 Corsair hired Kenji Gjovig as VP eCommerce. Coming from Albertsons Companies he joined to lead the direct to customer ecommerce business. It will be a tough job. As reported in the 2020 IPO prospectus, sales to Amazon accounted for 26.8% of net revenue for the six months ended June 30, 2020, increasing from 17.7% in 2017.

The big picture challenge for Corsair is that a lot of their business and products are “amazonable”. The online etailers that survive are those who can carve out a niche or offer a product/service that are “unamazonable”. Corsair must find a way how it can attract customers who are used to the ease of simply adding a Corsair product in their one-click Amazon check out. This can be done, but will not be easy and will not be cheap. An easy way out would be to offer lower prices through the online store, but not only does that impact the profitability, it also impacts the brand value. Offering exclusive products or customized products is another option, but that is incompatible with the “Corsair Touch” business model. High expenditure on advertising and marketing to lure people to the ecommerce platform is expensive and will eat into your margin. Offering better or more personal service compared to Amazon may seem easy to on paper but very quickly becomes expensive. Especially for a company selling worldwide.

Reinvestment

The reinvestment is targeted mostly at M&A. A key challenge with M&A is that for attractive businesses there are usually multiple bidders and multiple bidders often result in a Winner’s Curse. The Winner’s Curse is a tendency for the winning bid in an auction to exceed the intrinsic value of an item. Similarly, many companies who do M&A end up overpaying for acquisitions.

Overpaying for an acquisition basically means you have overestimated the value (value transfer and value creation) of the acquisition. Reasons for this can be overestimating the synergies (“dreams”), underestimating the cost of capital (minimizing the risk premium), exaggerating the residual growth rate in the calculation of the terminal value, and using multiples of “comparables” which are not really similar or simply inflated.

M&A is really difficult and Corsair will need not only a clear acquisition strategy, a strong negotiation strategy (“BATNA, be able to walk away”), but most importantly key people who can identify potential targets and accurately evaluate the value it can create for the business after acquisition.

It is difficult to judge whether Corsair management is doing things right from outside. However, we can look at the transactions detailed in the 2020 IPO prospectus. Specifically, we can look at the goodwill mentioned. Goodwill is the price paid for future cash flow and is calculated as the acquisition price minus the book value of the assets.

  • Elgato (2018): $23.133 million net assets, $23.487 million goodwill
  • Origin PC (2019): $1.499 million net assets, $12.270 million goodwill
  • SCUF Gaming (2019): $63.670 million net assets, $72.642 million goodwill

The obvious standout here is SCUF Gaming as Corsair paid more in goodwill than net assets. In 2019 SCUF Gaming reported net sales of $68.3 million, gross profit of $26.5 million and operating loss of $2 million.

Terminal Value

The terminal value captures the value of a business beyond the forecasted cashflow period. The terminal value often comprises a large portion of the total value of the business. My model uses the perpetuity method which assumes a business will continue to generate cashflows at a constant rate forever.

The obvious caveat is of course that we do not know if Corsair will continue to generate revenues beyond year 10. Perhaps with the rise of cloud gaming or other technologies we soon will not need any of the products Corsair is selling.

My assumption is that Corsair will continue to shift its product portfolio towards new categories and markets and hence I am okay using the perpetuity method in this Corsair valuation.

Corsair Valuation: Sensitivity Analysis

Last step of the Corsair valuation is to do perform a simple sensitivity analysis. In the past I used Crystal Ball to perform my sensitivity analysis but recently I have switched to the ModelRisk excel plugin.

Inputs:

  • CAGR 2-5Y: lognormal distribution (mu=10%, sigma=5%)
  • Profitability: triangle distribution (min=5%, mode=12.5%, max=20%)
  • Sales to Capital ratio: triangle distribution (min=1.5, mode=2.0, max=2.5)

Outputs:

  • Mean value of equity ~ $2.29B
  • 25% percentile: $1.62B
  • 50% percentile: $2.15B
  • 75% percentile: $2.76B

Corsair Valuation: Post-IPO Update

On September 23, 2020, Corsair Gaming was listed on the Nasdaq raising $238 million by offering 14 million shares at $17. The share price dropped on opening day by over 16% to $14.24.

I updated my valuation work sheet with the additional data such as outstanding shares and re-ran the simulation. You can find the information below:

Worksheet download: https://hanweiconsulting.com/wp-content/uploads/2020/09/fcffsimpleginzu-corsair-v1.2.xlsx

Simulation:

As of Sept 24, 2020, Corsair sits around the 15% percentile.

Disclaimer: For all intents and purposes, the content and information below is for entertainment purposes only and should not be considered investment advice.

Markets Aren’t Crashing? (S&P 500 Valuation)

Why aren’t markets around the world crashing to historical lows amidst the global pandemic? In this blog post I take a closer look at the factors driving market valuation and discuss whether the markets are delusional or rational.

On February 19, the S&P 500 index reached a new all-time high of 3386.15. One month later, on March 23, the same index stood 34% lower at 2237.40. All gains since January 2017 wiped out due to the COVID-19 induced fear and uncertainty. Today, April 29, the S&P 500 sits around 2800, still down from it’s peak right before the crisis but far from the market crash everyone seems to be talking about.

The question on some people’s minds seems to be: when will the market eventually crash? Other people claim the earnings headwind is already priced in. Using the DCF method, I value the S&P 500 index and look at the data to try and make sense of this question. I cover three main inputs to value the S&P 500:

  • Equity risk premium: is the implied equity risk premium unusually low or high?
  • Earnings forecast: is the expected growth in future cash flows reasonable?
  • Payout ratio: are the expected returns reasonable?
Valuing the S&P 500 market index
Valuing the S&P 500 market index

Implied Equity Risk Premium

The equity risk premium is the price of risk in equity markets. It can be understood as the premium investors demand for investing in an equity asset. The riskier an asset, the higher the associated risk premium will be.

Although no asset is truly risk free, we could argue that government bonds from first world countries like United States or Germany are risk free in practice because their governments will never default. Similarly, you’ll find that the risk premium for well-established firms in mature markets will be lower than the premium for startups in developing markets.

In valuation and corporate finance, the equity risk premium is an essential input for calculating the cost of equity and cost of capital. Traditional methods employ a backwards looking historical equity risk premium. In modern valuation we prefer to use a forward-looking implied equity risk premium.

The implied risk premium is estimated using current market data such as market capitalization and risk-free rate, and most recently available company earnings reports. In this blog post I outline how to perform the calculation using tools provided by the online data service Finbox.

Historical Perspective

Since my first blog post on how to use Finbox to estimate the implied equity risk premium, I’ve been tracking the implied equity risk premium of a variety of major indices. Below you can find the updated visualization.

As you see in the chart above, the implied equity risk premium for the S&P 500 decreased from near 8% at the end of March to 5.5% at the end of April. I discussed a variety of elements influencing the equity risk premium calculation in times of crisis in a follow-up blog post earlier this month. If you’re interested, I would definitely recommend going through that blog post.

According to Damodaran’s research, historically the equity risk premium for the S&P 500 averages around 4.5%. This is substantially lower than today’s 5.5% to 6.0%. If we consider only the years since the 2007-2008 financial crisis, the historical risk premium hovers around 5% to 6%. Today’s risk premium falls within this range perfectly.

Future Cash Flows

An crucial input to value the S&P 500 is the expected future growth of cash flows. There are a variety of methods to determine this input. You can rely your own expertise to estimate the growth every year. Of course, you can also rely on the forecasts of the managers of the firms you’re tracking. You can also ask analysts to provide estimates. You can use a top-down approach and estimate the growth for the index as a whole, or a bottom-up approach by estimating the growth of each company in the index to derive the overall growth of the index.

In my blog post titled Finbox Implied Equity Risk Premium Follow-Up I outline a particular method of estimating the growth of future cash flows using Finbox. There are two key inputs:

  1. For each company in the index, the expected growth in net income in the first year
  2. For each company in the index, the expected compound annual growth rate of net income for the next five years

The growth estimates are provided by industry analysts and aggregated by Finbox. In the charts below you can find the estimates over time.

index 1y net income growth tracker finbox
index 5y cagr tracker finbox

As you can see, the analyst estimates are slower to adjust to the crisis than the market. One would hope that is the case! The market can be irrational and emotional, but we need analysts to help us make sense of the situation and provide careful, well-founded and rational insight.

Since about a week or so, we see that the analysts have started putting a figure to the impact of the virus. Estimates for Western markets range from near -20% (Europe and UK) to -10% (United States). For China and Japan, the situation is slightly different, and in particular the Chinese situation is an interesting topic (which I will cover in a future blog post).

The bottom-up analyst outlook for the next 5 years remains relatively stable for all markets. The forecast slightly more favorable for the US and European companies and hovers around 4-5% CAGR.

Sustainable Payout Ratio

The last input we need for our discounted cash flow model is the expected return of the excess cash flows generated by the firm to the shareholders. This topic addresses the dividend decision in corporate finance. Simply put, it poses the question whether the excess returns will be reinvested in the firm or returned to the shareholders.

In theory, a company aims to maximize shareholder wealth. If the company has interesting and highly profitable projects lined up, then reinvesting excess returns into those projects is preferred. However, if the company has no interesting projects then the company should return the cash to the shareholders such that the shareholders can invest it in other companies that may have interesting projects.

There are two ways companies can return cash to the shareholder: dividends and buybacks. Each method has its advantages and disadvantages, and it’s up to the management of the company to determine what’s best for their situation. Collectively, we can capture the returns to the shareholders as a Payout Ratio. The payout ratio for the S&P 500 currently sits around 88%. That means for every $100 in net earnings, S&P 500 firms return $88 to the shareholders.

In this discounted cash flow model, we employ a sustainable payout ratio based on the stable growth rate after year 5 and the trailing twelve months return on equity.

We can argue at length whether it is reasonable to assume companies will eventually return to the shareholder every dollar they can’t reinvest (and whether the cash that gets reinvested actually creates value for the shareholder), but what we all assume is that the payout ratio is a decision made by the company management. The management is accountable to the shareholders, and this dynamic ensures the payout ratio will be reasonable considering the company’s performance. If the payout ratio would be impacted by external forces, e.g. government mandating a maximum payout ratio of 70%, then the value of the index would drop very rapidly.

Bringing It All Together

Let’s bring together the different inputs.

  • At 5.5%, the implied equity risk premium for the S&P 500 is higher than the historical equity risk premium for US equity markets, but sits right in the middle if we consider the risk premium since 2008.
  • At -9.52% for the next year, the Finbox aggregated analyst earnings forecasts for the S&P 500 firms are quite downbeat. This reflects a major impact of the coronavirus on supply and demand.
  • The sustainable payout ratio assumes companies will return excess returns to shareholders if management does not have interesting projects to invest in

Based on the findings above, it certainly looks like investors are making a reasonable attempt at valuing the market. The equity risk premium implies investors don’t find stocks any riskier than they were pre-crisis. The earnings forecasts that drive the discounted cash flow model are not implying a straight up catastrophe, but are definitely downbeat. Lastly, the payout ratio implies investors expect firms will return cash to the shareholders reasonably.

Of course, the above is merely my opinion. Perhaps you find equity risk greatly underestimated, or find the analyst forecast too positive considering the circumstances, or expect payouts to substantially change in the coming years. In the table below I’ve added a couple of scenarios to value the S&P 500 with different assumptions.

Equity
Risk Premium
Y1 Growth
Forecast
5Y CAGR
Forecast
Sustainable
Payout Ratio
S&P 500
Valuation
5.41%-9.52%4.64%95.89%2863.32
7%-9.52%4.64%95.89%2190.51
5.41%-20%4.64%95.89%2834.18
5.41%-9.52%1.00%95.89%2439.10
5.41%-9.52%4.64%75.00%2285.78
Alternating assumptions that drive different S&P 500 valuation

Also, you can use the excel document below to experiment yourself. It contains the latest data on April 29, 2020, as provided by Finbox API. Simply adjust the assumptions on the last sheet and see how the intrinsic value estimate changes.

(PS: the answer to the question whether markets today are delusional or rational is of course that they are both and neither at the same time *wink*)

S&P 500 Intrinsic Valuation Using Finbox

In the previous blog post we used the Finbox API service to calculate the implied equity risk premium of the S&P 500. Using the Finbox API service we can also do an intrinsic valuation of the S&P 500.

Background

We live in extraordinary and challenging times. The novel Coronavirus (SARS-CoV-2) and related disease (COVID-19) has been spreading around the world for almost three months now. People around the world are urged or forced to stay at home to help governments and communities get the virus under control. The coronavirus will undoubtedly have a lasting impact on our lives.

The virus has already made severe impact on businesses around the world. First, when the Hubei province in China shut down, many global supply chains were also shut down. Now, as more people around the world are no longer able to go to work, many businesses are suffering from a steep decline in demand. For example, the tourism and airline industries have come to a complete halt as people stay at home. A lot of businesses may go under and a lot of people may lose their jobs. And without people earning money to spend, businesses will see a further decline in sales.

Stock markets around the world have also dropped significantly. The Dow Jones dropped more than 35% from 29,551 points on February 12, 2020, to 19,174 points on March 20, 2020. Similarly the S&P 500 Index fell almost 32% from 3386 points on February 19, 2020, to 2305 points on March 20, 2020. The German DAX Index fell over 38% from 13,789 points on February 19, 2020, to 8,442 on March 18, 2020. Fueled by an oil price war, we’re looking at the “fastest bear market” ever.

(source: schwab.com)

From February 26, 2020, NYU Stern professor Mr. Aswath Damodaran began covering the impact of the virus on the markets on his blog and YouTube channel:

  • 26/02: A Viral Market Meltdown: Fear or Fundamentals? (blog, youtube)
  • 09/03: A Viral Market Meltdown Part II: Clues in the Debris! (blog, youtube)
  • 16/03: A Viral Market Meltdown III: Pricing or Value? Trading or Investing? (blog, youtube)
  • 23/03: A Viral Market Meltdown IV: Investing for a post-virus Economy (blog, youtube)
  • 31/03: A Viral Market Meltdown V: Back to Basics! (blog, youtube)
  • 08/04: A Viral Market Meltdown VI: The Price of Risk (blog, youtube)
  • 24/04: A Viral Market Update VII: Mayhem with Multiples (blog, youtube)
  • 13/05: A Viral Market Update VIII: A Crisis Test – Value vs Growth, Active vs Passive, Small Cap vs Large! (blog, youtube)
  • 04/06: A Viral Market Update IX: A Do-it-Yourself S&P 500 Valuation (blog, youtube)
  • 19/06: A Viral Market Update X: A Corporate Life Cycle Perspective (blog, youtube)
  • 02/07: A Viral Market Update XI: The Flexibility Premium (blog, youtube)
  • 23/07: A Viral Market Update XII: The Resilience of Private Risk Capital (blog, youtube)
  • 20/08: A Viral Market Update XIII: The Strong (FANGAM) get Stronger! (blog, youtube)
  • 05/11: A Viral Market Update XIV: A Wrap on the COVID market, premature or not! (blog, youtube)
Damodaran S&P 500 intrinsic valuation

In the third blog post, Damodaran provided an updated intrinsic valuation of the S&P 500 index ranging between $2,547.91 (20%) to $2,986.04 (80%).

Using the same Finbox tools we used in our previous blog post, we can also do an intrinsic valuation of the S&P 500.

Data Gathering

To value the S&P 500 index we need the following data inputs:

  • Long-term risk-free rate: 10Y US bond yield (Wikipedia)
  • Company information (Finbox API)
    • Current market capitalization (marketcap)
    • Dividends paid LTM (total_div_paid_cf)
    • Stock buybacks LTM (common_rep)
    • Stock issues LTM (common_issues)
    • Net income LTM (ni)
    • Book value of equity FY (total_equity)
S&P500 company data provided by Finbox.com API service
S&P500 company data provided by Finbox.com API service

To estimate the current value of the S&P 500, we want to use the most up to date information available. That’s why for most metrics we use the last twelve months data points.

Dividend and Buyback Computation

After gathering the raw data, we normalize by weighing the current S&P 500 index against the S&P 500 total market capitalization.

From S&P 500 raw data to index unit adjusted data points

At the moment of writing, March 23, 2020, the index units adjusted data points are:

  • Earnings: $142.92
  • Dividends: $57.44
  • Buybacks: $81.50
  • Issuances: $138.94
  • Cash to Equity: $138.95 (dividends + buybacks)
  • Net Cash to Equity: $129.52 (dividends + buybacks – issuances)

S&P 500 Valuation Inputs

  • Base Earnings: $142.52
  • Base Net Cash Yield: $129.52
  • Expected Y1 earnings growth: PERT distribution (min -25%, mode -5%, max 5%)
  • Expected Y2 to Y5 earnings growth: triangle distribution (min 4%, 7%, 10%)
  • Expected long term riskfree rate: triangle distribution (min -0.51%, mode 0.89%, max 1.5%)
  • Sustainable payout ratio in Y5: 1-g/ROE
  • Equity risk premium: triangle distribution (min 5%, mode 7.18%, max 9%)

S&P 500 Intrinsic Valuation

In the chart below you can find a histogram plot of the S&P 500 intrinsic value. It ranges from $2,001.58 (25%) to $2,425.66 (75%) with a mean of $2,211.15.

S&P 500 intrinsic valuation
S&P 500 intrinsic valuation (March 23, 2020)