July 27 2020 - Shopify, Valued 1.7x Higher Than Their Total Addressable Market

Summary

Total of 7,583,817 retail e-commerce websites, with Shopify averaging 0 per store in subscription solutions revenue.

Estimated FY20 retail e-commerce sales of .2 trillion, with Shopify generating roughly 1.55% of GMV in revenue.

With a 100% market share in both, Shopify would generate roughly billion in subscription solutions and billion in merchant solutions.

After accounting for gross margins, revenue falls to billion (80%) and billion (38%) respectively.

Market capitalization of 8 billion, representing 68x sales, 1.7x higher than TAM, and 4x higher than gross profit from TAM.

Company Overview (1)

Founded by German-born Canadian entrepreneur Tobias Lütke in 2004, Shopify (SHOP) is an e-commerce platform that enables merchants of nearly any size to quickly and easily setup an online store and begin selling their products. They generate revenue through two separate segments -- high margin subscription solutions and low margin merchant solutions. Both of these are described in deeper detail later in the article, but here is a brief overview of what each of these two segments are.

Source: SEC Filing

Subscription solutions is their recurring subscription component with revenue generated from variable platform fees, typically as a monthly subscription, theme and app store purchases, and domain registrations. This is their most profitable segment with a phenomenal 80% gross margin.

Merchant solutions is their success-based component with revenue generated principally through payment processing fees from Shopify Payments. In addition to Shopify Payments, revenue in this segment is also collected from transaction services, referral fees, Point-Of-Sale ("POS") hardware, Shopify Capital, Shopify Fulfillment Network, and collaborative warehouse fulfillment solutions. The collective revenue in this segment is directionally correlated with the level of Gross Merchandise Volume ("GMV") processed through the Shopify platform.

Article Overview (2)

It's likely no secret, given my previous two articles Shopify's Road To 0 and Shopify's Hyper Bubble Put In Perspective, that I'm not super bullish on the company. Granted, with a 8 billion market cap in conjunction with trailing revenue of .73 billion and a 5 million net loss, it's a bit difficult to argue otherwise. However, I have already gone over the valuation concerns to the point of exhaustion, and this article will focus entirely on fundamentals.

As noted in the previous section, Shopify's revenue is broken into two separate segments, and my goal is for every reader to have a solid fundamental understanding of both by the end. Here I will not only break down where the revenue comes from for each, along with a variety of other financial metrics, but also attempt to estimate the total addressable market for each along with some reasonable projections.

Ordered Sections

  • 1 - Company Overview
  • 2 - Article Overview
  • 3 - Retail E-Commerce Market Overview
  • 4 - Alexa's Link To GMV
  • 5 - Understanding The Data
  • 6 - Retail E-Commerce Market Breakdown
  • 7 - Shopify's Earnings Highlights
  • 8 - Shopify's Subscription Solutions
  • 9 - Shopify's Merchant Solutions
  • 10 - Conclusions

Retail E-Commerce Market Overview (3)

Due to the fact that the overwhelming majority of Shopify's revenue comes from its online stores, whether directly through subscription solutions or relative to sales through merchant solutions, a great starting point would be to determine just how large this market is. Using data compiled by BuiltWith we can not only determine its total size but more specifically narrowed by cohort.

Their market control among the top ranked cohorts is significantly more beneficial to merchant solutions, while their global market share is significantly more beneficial to subscription solutions. The reason for this is a confirmed connection between a websites Alexa rank and its sales, which will be explained in further detail later in the article.

As a final reminder, subscription solutions are linearly correlated with the quantity of stores on the Shopify ecosystem while merchant solutions are directionally correlated with the GMV of those stores, specifically any GMV processed directly through Shopify.

Source: BuiltWith [Top 10k]

Source: BuiltWith [Top 100k]

Source: BuiltWith [Top Million]

Source: BuiltWith [Entire Internet]

Alexa's Link To GMV (4)

There's a fantastic article by Robert J. Moore that tries to answer an important question -- How Many E-Commerce Companies Are There? Unfortunately the article is about six years old, completely ancient by tech standards, but it's still incredibly relevant in many respects and takes advantage of proprietary data to give us a unique look into the relationship between Alexa Rank and GMV. For example he uses anonymized statistics taken directly from many of these stores in conjunction with Alexa to generate a rough translation between site ranking and revenue generated while confirming the results. Here are two of the charts generated from said analysis, along with its conclusions.

E-Commerce Alexa Revenue FullSource: RJmetrics

E-Commerce Revenue By Alexa RankSource: RJMetrics

E-Commerce Revenue Alexa ConclusionsSource: RJMetrics

This shows that using the top million websites is a fantastic metric to predict a companies revenue given its correlation with Alexa ranking. Moreover it's clear that the vast majority of meaningful sales is going to come from this cohort. While there are certainly a number of businesses generating six figures outside of this range, you can see how rapid the exponential decrease is and anything further out is extremely unlikely to be generating anything meaningful, with the top 10k e-commerce websites making up roughly 34% of total revenue. What does this mean for Shopify in particular? This is where their merchant solutions shine given it's a direct reflection of how successful the businesses on their platform are, the better Shopify does in the top million (and above) the greater their merchant solutions revenue will be.

Understanding The Data (5)

When looking at the previously shown market distribution images, shown in section three, you'll likely notice there are two separate usage distributions given; one in the pie chart and another listed below that. While BuiltWith does explain where these numbers come from, it unfortunately appears to be outdated as the numbers don't match up as they describe. However, while waiting on an official response, I ended up just working out how the numbers are determined myself.

Determining Total Sites & Detections

 
s1.Pi.com s2.Pi.com s1.Rho.com s2.Rho.com Gamma.com Site Domain Pi Pi Rho Rho Gamma Total Sites 1 1 2 2 3 Total Detections 1 2 3 4 5 Total Sites 1 1 2 2 3
  • Sites can be measured as the number of separate parent domains the platform has been detected on. This is an important distinction because more than one platform can be detected on a single site and, perhaps more importantly, all subdomains of a given parent domain are considered to be one site.
  • Detections can be measured as the number of unique stores found across the entire cohort, including subdomains. As opposed to sites being limited to the parent domain, detections extend to the fully qualified domain.
  • Summary is that each unique URL can have any number of platforms detected on it, but no more than one of each. To qualify as a new site it must have a unique parent domain. For example 500 subdomains, each with its own unique store, but all sharing the same parent domain, will contribute +500 to detections but never more than +1 to sites.
  • Shopify has an important quirk to keep in mind in that every single free trial is given their own subdomain on MyShopify. Simply put, every trial store will be considered one additional Shopify detection without changing the total number of sites due to each one sharing the same parent domain. This will be used for further analysis later.

Determining Market Share

 
Numerator Platform Total Sites Platform Total Sites
Denominator Cohort Total Sites Cohort Size
Alternate Name Market Share Cohort Share
  • Market share is generally the most important metric as it tells us precisely what the market share is specifically among all unique parent domains. The ratio is calculated based on unique store sites relative to the total sites within the given category.
  • Cohort share is not very useful in and of itself, but in conjunction with market share we can use this to determine exactly how many "duplicate sites" each platform has. This is the ratio of platform detections relative to the total size of the cohort. For every "Top N" categories, "N" is the divisor (e.g top 10k has a 10k divisor) while on the "Entire Internet" category it uses total detections as a divisor

Retail E-Commerce Market Breakdown (6)

Given the previously described data, we can now build a table describing what the market looks like for any given cohort. Note that due to each subsequent cohort including all previous ones, we will be discarding total sites from all previous cohorts. For example, the top 100k category shows 5,547 Shopify sites detected but this includes the 529 from the top 10k cohort, so it should be 5,018. This will keep each cohort separately contained rather than building on top of one another, providing a much more accurate picture of each.

Everything shown below uses data from BuiltWith along with a lightweight program to separate each cohort into its own container, as described earlier. You can find both the data used and source code here for reference.

Top 10k
Rank   #1 #2 #5 #9
Sites 2,509 529 225 169 91
Market Share 100% 21.08% 8.97% 6.73% 3.63%
  • This is by far the most important cohort for Shopify and they have a commanding 21.08% market share, even higher at 24.71% if you include Shopify Plus. Remember that merchant solutions thrives relative to GMV and the overwhelming majority of global e-commerce is in the top million, with the top 10k in particular contributing 34% of the total.
10k-100k
Rank   #1 #2 #3 #4
Sites 21,044 5,018 3,111 2,830 1,299
Market Share 100% 23.85% 14.78% 13.44% 6.17%
  • You can see here that Shopify continues to command a strong market lead among its competitors in the second most important cohort for GMV. They have also doubled their market share for Shopify Plus over the previous cohort. Between the two Shopify controls 30% of all e-commerce websites within this cohort, more than double Woo in second place.
  • As an interesting side note, BigCommerce isn't listed but it's right behind Shopify Plus at 1,211 market share in this cohort. They are also not far behind in the top 10k at 56 sites, for a combined total of 1,267 sites in the top 100k as compared to Shopify Plus at 1,390.
100k-1m
Rank   #1 #2 #3 #4
Sites 134,724 42,772 30,461 10,189 1,805
Market Share 100% 31.17% 22.58% 7.42% 1.34%
  • This is the final cohort with any meaningful sales, it's far more important to them to increase their share in this and previous cohorts than it would be to expand further outside of it. The reason is simply that the global market size for subscription solutions is only around billion, which we will get into shortly.
1m+
Rank   #1 #2 #3 #4
Sites 7,425,540 1,828,367 1,386,807 968,255 642,392
Market Share 100% 24.62% 18.67% 13.04% 8.65%
  • Here we have the final cohort, all websites outside of the top million. The vast majority of online stores reside here and nearly none of them generate meaningful revenue. This cohort is significantly more important for subscription solutions revenue than merchant solutions revenue, a single store in the top 10k can generate more GMV than a million different stores in this cohort.

Shopify's Earnings Highlights (7)

Source: Shopify 19Q1

Source: Shopify 19Q4

Source: Shopify 20Q1

19Q4 Source
Revenue 3.17 million 1.99 million 5.16 million
Cost of Revenue .37 million 3.90 million 1.27 million
Gross Profit 5.80 million 8.09 million 3.89 million
Gross Margin 79.60% 36.68% 100%
Revenue Share 36.26% 63.74% 100%
Gross Profit Share 55.25% 44.75% 100%
Growth YoY 37.10% 53.11% 46.89%
Growth QoQ 10.62% 43.12% 29.34%
20Q1 Source
Revenue 7.61 million 2.45 million 0.06 million
Cost of Revenue .71 million 5.34 million 3.05 million
Gross Profit 9.90 million 7.11 million 7.01 million
Gross Margin 80% 38% 54.68%
Revenue Share 39.9% 60.1% 100%
Gross Profit Share 58.3% 41.7% 100%
Growth YoY 33.5% 56.8% 46.9%
Growth QoQ 2.4% -12.3% -6.9%

Here we can see that total subscription solutions revenue grew to 7.6 million in 20Q1, up 33.5% YoY and 2.4% QoQ. You may also have noticed that total revenue declined 6.9% QoQ and the reason for this becomes clear looking at 20Q1, it's related to merchant solutions. While they note in 20Q1 that merchant solutions revenue accelerated by 57% for the second consecutive quarter, you can clearly see that this increase is YoY and they actually declined 12.30% QoQ. Merchant solutions revenue if you remember is directionally correlated to GMV and you can similarly see its decline of 15.53% from the previous quarter.

Shopify's Subscription Solutions (8)

Overview

Source: TSX Filing

Source: Market Place Pulse

Total Addressable Market

According to BuiltWith, there are a total of 15,563,779 platforms detected across 7,583,817 unique sites. As of July 23 Shopify controls 1,422,815 of these unique sites, meaning that Shopify's growth potential in this area is limited to roughly 5.3x their current share, plus industry growth. Remember that Shopify's revenue in this segment is linearly correlated to the quantity of stores on its platform.

Considering that Shopify generated 7.6 million revenue from this segment 20Q1, we can extrapolate to roughly 4.28 million in potential quarterly revenue, or .98 billion annually. Further applying a 20% industry growth rate we can determine that the maximum upper limit for subscription solutions revenue FY20 is ~.78 billion. This is obviously incredibly small for a total monopoly, it's only 122.32% above their projected FY20 revenue of .15 billion and just over 4% of their 8 billion market cap.

Now of course I'm not suggesting that Shopify is incapable of generating more than this upper limit because, as we have discussed, merchant solutions generates the majority of their revenue. This is despite subscription solutions making up the majority of their gross profit due to margins being twice as high. Rather I am only pointing out that this data suggests they have very little upside in subscription solutions.

Quarterly Store Estimates

Remember that revenue from subscription solutions grows linearly as they increase their quantity of stores, regardless of what its GMV is, so let's use the previously shown financial highlights along with merchant data to see if we can find a connection. Unfortunately, for the first time since IPO, for whatever reason, they did not include the number of merchants last quarter. In any case we can look to historical data to try and find a pattern.

Source: Marketplace Pulse

Because we don't have an official merchant count for 20Q1, we'll have to estimate what it was, and we can't use the current number of 1,422,815 stores due to the quarter ending March 31st, so we'll have to apply a reasonable amount of guesswork. It has been a total of 267 days since they passed one million, adding 422,815 stores since, coming to an average of roughly 1,583 new stores per day. It has also been 114 days since 20Q1 ended so we can simply subtract 180,462 stores from the current count for an estimated total of 1,242,353. However, due to an acceleration of new stores beginning towards the end of 20Q1 it makes sense to revise that number slightly down to 1.15 million.

2019 Q1

  • Total of 860,000 unique stores.
  • Revenue of 0.5 million in subscription solutions.
  • MRR contributed .2 million towards that revenue.
  • Average store revenue of 3.37 quarterly, .45 monthly.
  • Average store MRR of .40 quarterly, .13 monthly.

2020 Q1

  • Total of 1,150,000 unique stores.
  • Revenue of 7.6 million in subscription solutions.
  • MRR contributed .4 million towards that revenue.
  • Average store revenue of 3.13 quarterly, .38 monthly.
  • Average store MRR of .17 quarterly, .06 monthly.

Next Quarter Projections

Due to the relatively stable nature of average store contributions, we can use the previously established data to provide projections for 20Q2 as well. In this case, because the fiscal quarter ended 24 days ago, I've revised the total number of stores down from 1.42 million to 1.35 million.

2020 Q2 (Projections)

  • Total store count of 1,350,000.
  • Average store quarterly revenue of 0.00.
  • Average store quarterly MRR of .00.
  • New store growth of 17.39% QoQ, 87.76% YoY.
  • Revenue of 6 million in subscription solutions.
  • MRR contribution to revenue of .5 million.

Shopify's Merchant Solutions (9)

Overview

Source: Market Place Pulse

Source: TSX Filing

This segment isn't as simple as subscription solutions because it's not linearly tied to the quantity of new stores, but rather their sales volume. Moreover the revenue is split between many more areas and, like subscription solutions, the company provides little breakdown within the segment. However, we do know from company statements, highlighted in the TSX filing image above, that merchant solutions revenue is directionally correlated to GMV so let's see if we can find a pattern.

Source
Merchant Solutions Revenue (Millions) 0.00 8.93 4.98 1.99 2.39
Total GMV (Billions) .90 .80 .80 .60 .40
Revenue / GMV 1.51% 1.51% 1.52% 1.56% 1.62%
Total GPV (Billions) .90 .80 .20 .90 .30
Revenue / GPV 3.67% 3.60% 3.63% 3.62% 3.87%

Perfect! Every single quarter from 19Q1 to 20Q1 is almost entirely within a tenth of a percent, with 1-2 very minor exceptions, and for both GMV and GPV. You would typically expect GMV to be far less important, but note that Shopify charges a flat 2.0%, 1.0%, or 0.5% fee, depending on the subscription plan, for all third party payment processors, which is in addition to whatever fees the third party charges. Using Shopify Payments has a flat charge of .30 per transaction and a processing fee of 2.9%, 2.7%, or 2.4%, again depending on the subscription plan.

Total Addressable Market

This is something that can both be easily determined while being simultaneously useless without context. The simplest starting point is of course the projected retail e-commerce GMV across the globe in FY20. In order to get this we can look to Statista, also referenced by Shopify.

Whoa! No denying that .2 trillion is one big number. Don't get too excited just yet though, remember that we've previously established Shopify generated roughly 1.55% of GMV in revenue. While still an incredibly large number, it drops all the way down to .20 billion. This is of course a phenomenal improvement over FY19 merchant solutions revenue of 5.9 million, but it's still only 55.2% of their current market cap and still requires a 100% monopoly on all retail e-commerce sales, which is obviously not even a remote possibility.

Shopify included internal TAM estimates in their 19Q3 investor deck, but it unfortunately does not separate between subscription solutions and merchant solutions and only gives a specific number for SMB's -- billion.

Source: Investor Deck 19Q3

Shopify Payments Runs On Stripe

While this is typically presented as a Shopify product, they don't actually process payments themselves, they use financial services company Stripe for this. The license can be found 

0
0
0
0
0
0
0 0 134
Submit comment
    No comments yet

Sept 12 2019 - Shopify: A Reality Check

Mar 26 2020 - Shopify In A Global Depression

Sept 21 2021 - Competitors Can't Match Shopify's Flywheel

Apr 27 2020 - SHOP: Will Shopify Profit From Coronavirus?

Mar 5 2020 - Shopify: An Infinite Amount Of Land

Feb 230 2020 - Shopify Soars On Improved Merchant Offerings

Apr 29 2021 - Shopify: More Sustainable Growth Ahead

Jan 28 2020 - Pinterest's Different Kind Of Social Media Play

Submit media
Enter your nickname

Show

Show

Enter your email address and we will send you an email explaining how to change your password or activate your account.

Back to login form

Close