Thursday, April 19, 2018

Alphabet Soup: Google is Alpha, but where are the Bets?

In my last two posts, I looked first at the turn in the market against the FANG stocks, largely precipitated by the Facebook user data fiasco and then at the effect of the blowback on Facebook's value. I concluded that notwithstanding the likely negative consequences for the company, which include more muted revenue growth, higher costs (lower margins) and potential fines, Facebook looks like a good investment, with a value about 10% higher than its prevailing price. I argued that changes are coming from both outside (regulators and legislation) and inside (to protect data better), and these changes are unlikely to be just directed at Facebook. It is this perception that has probably led the market to mark down other companies that have built business models around user/subscriber data and in these next posts, I would like to look at the rest of the stocks in the FANG bundle and the consequences for their valuations, starting with Google in this one.

The One Number
The value of a company is driven by a myriad of variables that encompass growth, risk and cash flows, which are the drivers of value. In a typical intrinsic valuation, there are dozens of inputs that drive value but there is one variable, that more than any other, drives value and it is critical to identify that variable early in the valuation process for three reasons:
  1. Information Focus: We live in a world where we drown in data and opinion about companies and unfocused data collection can often leave you more confused about the value of a company, rather than less. Knowing the key value driver allows you to focus your information collection around that variable, rather than get distracted by the other inputs into value.
  2. Management Questions: If you have the opportunity to question management, your questions can then also be directed at the key variable and what management is doing to deliver on that variable. 
  3. Disclosure Tracking: If you are invested in a company and are tracking how it is performing, relative to your expectations, it is again easy in today's markets to get lost in the earnings report frenzy and the voluminous disclosures from companies. Having a focus allows you to zero in on the parts of the earnings report that are most relevant to value.
In short, knowing what you are looking for makes it much more likely that you will find it. But how do you identify the key driver variable? In my template, I look for two characteristics:
  1. Big Value Effects: Changing your key driver variable should have large effects on the value that you estimate for a business. One of the benefits of asking what-if questions about the inputs into a valuation is that it can allow you to gauge this effect. 
  2. Uncertainty about Input: If an input has large effects on value, but you feel confident about it, it is not a driver variable. Conversely, if you have made an estimate of input and are uncertain about that number, because it can change either due to management decisions or because of external forces, it is more likely to be a driver input.
If you accept this characterization, there are two implications that emerge. The first is that the key value driver can and will be different for different companies; a mechanistic focus on the same input variable with every company that you value will lead you astray. The second is that there is a subjective component to your choice, and the key value driver that I identify for a company can be different from the one you choose for the same company, reflecting perhaps the different stories that we may be telling in our valuations. In my just-posted Facebook valuation, I believe that the key variable is the cost that Facebook will face to fix its data privacy problems and it manifests itself in my forecasted operating margin, which I project to fall from almost 58% down to 42%, in the next five years. Note that revenue growth may have a bigger impact on value, but in my judgement, it is the operating margin that I am most uncertain about. I will use this post to value Google and highlight what I believe is the driver variable for the company.

The Alphabet Story
If Facebook is the wunderkind that has shaken up the online advertising business, Google is the original disruptor of this business and is by far the biggest player in that game today. It is ironic that the disruptor has become the status quo, but until there is another disruption, it is Google's targeted advertising model, in world, and its search engine and ad words that dominate this business. Google has had fewer brushes with controversy, with its data, than Facebook, partly because its data collection occurs across multiple platforms and is less visible and partly because it does have a tighter rein on its data. 

1. A Short History
Google has been a rule breaker, right from its beginnings as a publicly traded company. It used a Dutch auction process for its initial public offering, rather than the more conventional bank-backed offer pricing model, and while it has had a few stumbles, its ascent has been steep:

The secrets to its success are neither hard to find, nor unusual. The company has been able to scale up revenues, while preserving its operating margins:

The most impressive feature of Google's operations has been its ability to maintain consistent revenue growth rates and operating margins since 2008, even as the firm more than quadrupled its revenues.

2. The State of the Game
To value Google, we start with the numbers, but in order to build a story we have to assess the landscape that Google faces.
  1. A Duopoly: The advertising business, in general, and the digital advertising business, in particular, are becoming a duopoly. In 2017, the total spent on advertising globally was $584 billion, with digital advertising accounting for $228.4 billion. Google's market share in 2017 was 42.2%, and Facebook's market share was 20.9%. Even more ominously for the rest of their competitors, they got bigger during the year, accounting for almost 84% of the increase in digital advertising during the course of the year.
  2. Google is everywhere: Google's hold on the game starts with its search engine, but has been enriched by its other products, Gmail, with more than a billion users, YouTube, which dominates the online video space and Android, the dominant smart phone operating system. If you add to this Google Maps, Google shared documents and Google Home products, the company is everywhere that you are, and is harvesting information about you at each step. During the last week, a New York Times reporter downloaded the data that Facebook had on him and while what he found disturbed him, both in terms of magnitude and type, he found that Google had far more data on him than Facebook did.
  3. Alphabet is still mostly alpha, very little bet: While Google's decision to rename itself Alphabet was motivated by a desire to let it's non-advertising businesses grow, the numbers, at least so far, indicate limited progress. In fact, if there is growth it has so far come from the apps, cloud and hardware portion of Google, rather than the bets themselves, but Nest (home automation), Waymo (driverless cars), Verily (life sciences) and Google Fiber (broadband internet) are options that may (or may) not pay off big time.

Google 2017 10K

The bottom line is that Google has changed the advertising business  and dominates it, with Facebook representing its only serious competition. It's large market share should act as a check on its growth, but Google has been able to sustain double digit growth by growing the digital portion of the advertising business and claiming the lion's share of that growth, again with Facebook. The wild  card is whether the data privacy restrictions and regulations that are coming will crimp one or both companies in their pursuit of ad revenues. As digital advertising starts to level off, Google will have to look to its other businesses to provide it a boost.

3. The Valuation
As with Facebook, I was a doubter on the scalability of the Google story, but it has proved me wrong, over and over again. In valuing Google, I will assume that it will continue to grow, but I set the revenue growth rate at 12% for the next five years, below the 15% growth rate registered in the last five, for two reasons. The first is that digital advertising's rise has started to slow, simply because it is now such a large part of the overall advertising market. The second is that data privacy restrictions, if restrictive, will take away one of Google's network benefits. I do think that the profitability of Google's businesses will stay intact over time, with operating margins staying at the 27.87% recorded in 2017. With those key assumptions, I value Google at $970, close to the price of $1030 that it was trading at on April 13.
Download spreadsheet
As with my Facebook valuation, each of my key inputs is estimated with error, and capturing that uncertainty in distributions yields the following outcomes:
Crystal Ball used in simulation
No surprises here. The median value is about $957 and at a stock price of $1.030, there is a 65% chance that the stock is over valued. As with Facebook, there is a positive skew in the outcomes, and that skew will get only more positive, if you build in a bigger payoff from one of the bets. I have never been a Google shareholder, and that has cost me lost returns over time, but this is as close as I have ever been to owning the stock. My only concern, assuming that Google goes to $950 or lower  in the near future would be that since I already own Facebook, I will be over invested in digital advertising's future success

4. The Value Driver
Google's value is driven by revenue growth and operating margins, and changing one or both inputs has a significant effect on value. 
The shaded cells represent the combinations that deliver values higher than the prevailing stock price of $1,030/share. In my judgment, Alphabet's bigger value driver is revenue growth, not margins, and it is on that input, this valuation will rise of fall. It is my view that while data privacy restrictions will translate into much higher costs for Facebook, partly because it has so little structure currently, it will result in lower growth for Alphabet. If the data privacy restrictions handicap Google so badly that it loses a big part of what has allowed it to dominate digital advertising for the next five years, Google's revenue growth and value will drop dramatically. However, Google is just starting to tap the potential in YouTube, and if it is able to position it as a competitor to Spotify, in music streaming, and Netflix, in video streaming, it could discover a new source of revenue growth, with strong operating margins.

YouTube Video

Data Links
Blog Posts on Tech Takedown
  1. Come easy, go easy: The Tech Takedown!
  2. Facebook: Friendless, But Still Formidable!
  3. Netflix: The Future of Entertainment or House of Cards?
  4. Alphabet Soup: Google is Alpha, but where are the Bets?
  5. Amazon: Glimpses of Shoeless Joe!

Monday, April 16, 2018

Netflix: The Future of Entertainment or House of Cards?

For better or worse, Netflix has changed not just the entertainment business, but also the way that we (the audience) watch television. In the process, it has also enriched its investors, as its market capitalization climbed to $139 billion in March 2018 and even after the market correction for the FANG stocks, its value is substantial enough to make it one of the largest entertainment company in the world. Among the FANG stocks, with their gigantic market capitalizations, it remains the smallest company on both market value and operating metrics, but it has almost as big an impact on our daily lives as its larger peers.

The History

This may come as a surprise to some, but Netflix has been publicly listed for longer than Facebook or Google. The difference between Netflix and these companies is that it’s climb to stardom has taken more time.

Don't get me wrong! Netflix was a very good investment between 2003 and 2009, increasing its market capitalization by 33.36% a year and its market capitalization by about $3 billion, during that period. However, it became a superstar investment between 2010 and 2017, adding about $120 billion in value over the period, translating into an annual price appreciation of more than 50% a year.

The fuel that Netflix has used to increase its market capitalization is its subscriber base, as with the other FANG stocks, the company seems to have found the secret to be able to scale up, as it gets larger. That subscriber base, in turn, has allowed the company to increase its revenues over time, as can be seen in the picture below, summarizing Netflix’s operating metrics.

You can accuse me of over analyzing this chart, but it captures to me the essence of the Netflix success story. While Netflix has been able to grow revenues in each of the three consecutive five-year time periods, 2002-2006, 2007-2012 and 2013-2017, that it has been existence, the company has been faced with challenges during each period, and it has adapted.
  1. DVDs in the Mail: In the first five-year period, 2002 through 2006, the company mailed out DVDs and videos to its subscribers, challenging the video rental business, where brick and mortar video rental stores represented the status quo, and Blockbuster was the dominant player. 
  2. The Rise of Streaming: It was between 2007 and 2012, where the company came into its own, as it took advantage of changes in technology and in customer preferences. First, as technology evolved to allow for the streaming of movies, Netflix adapted, with a few rough spots, to the new technology, while its brick and mortar competitors imploded. Second, while Netflix saw a drop in revenue growth that was not unexpected, given its larger base, it also saw its content costs rise at a faster rate than revenues, as content providers (the movie studios) starting charging higher prices for content. 
  3. The Content Maker: In hindsight, the studios probably wish that they had not squeezed Netflix, because the company reacted by taking more control of its own destiny in the 2013-2017 time period, by shifting to original content, first with television series and later with direct-to-streaming movies. The results have upended the entertainment business, but more critically for Netflix, they show up in a critical statistic. For the first time in its existence, Netflix saw content costs rise at a rate slower than its growth in revenues, with operating profit margins, both before and after R&D reflecting this development. 
The State of the Game
We can debate whether Netflix is a good or a bad investment, but there is no argument that the way movies and television get made has been changed by the company’s practices. It is the rest of the entertainment business that is trying to adapt to the Netflix streaming model, as evidenced by Disney’s acquisition of BAM Media and Fox Entertainment. If I were to summarize where Netflix stands right now, here would be my key points:
1. It's a big spender on content: In 2017, Netflix spent billions on the content that it delivers to its subscribers, and the extent of its spending can be seen in its financial statements. The way that Netflix accounts for its content expenditures does complicate the measurement, since it uses two different accounting standards, one for licensed content and one for productions, but it capitalizes and amortizes both, albeit on different schedules, and based upon viewing patterns. The gap between the accrual (or amortized) cost (shown in the income statement) and the cash spent (shown in the statement of cash flows) on content can be seen in the graph below.
Netflix 10K - 2017
In 2017, Netflix spent almost $9.8 billion on content, though it expensed only $7.7 billion in its income statement. If this divergence continues, and there is no reason to believe that it will not, Netflix’s profits will be more positive than their cash flows by a substantial amount. Note that this divergence should not be taken (necessarily) as a sign of deception or accounting game playing. In fact, if Netflix is being reasonable in its amortization judgments, one way to read the difference of $2.14 billion ($9.8 in cash expenses minus $7.66 billion in accrual expenses) is to view it as the equivalent of capital expenditures at Netflix, since it is expense incurred to attract and keep subscribers.
2. An increasing amount of that spending goes to original content: The decision by Netflix to produce some of its own content in 2013 triggered a shift towards original content that has picked up speed since that year. In 2017, the company spent $6.3 billion on original content, putting it among the top spenders in the entertainment business:
Biggest Spenders on Entertainment Content in 2017
The pace is not letting up. In the first quarter of 2018, Netflix introduced 18 new television series and delivered 12 new seasons of existing series, prodigious output by any studio’s standards. There are three reasons for the Netflix move into the content business.
  • The first, referenced in the last section, is to gain more control over content costs and to be less exposed to movie studio price hikes. 
  • The second is that Netflix has been using the data that it has on subscriber tastes not only to direct content at them, but to produce new content that is tailored to viewer demands.
  • The third is that it introduces stickiness into their business model, a key reason why new subscribers come to the company and why existing subscribers are reluctant to abandon it, even if subscription fees go up.
Netflix has moved beyond television shows to making straight-to-streaming movies, spending $90 million on Bright, a movie that notwithstanding its lackluster reviews, signaled the company’s ambitions to be a major player in the movie business.
3. Netflix has been adept at playing the expectations game: One feature that all of the FANG stocks trade is that rather than let equity research analysts frame their stories and measure their success, they have managed to frame their own stories and make investors and analysts play on their terms. Netflix, for instance, has managed to make the expectations game all about subscriber numbers, and every earnings report of the company is framed around these numbers, with less attention paid to content costs, churn rates and negative cash flows. After its most recent earnings report in January, the stock price surged, as the company reported an increase of 8.3 million in subscribers, well above expectations.
4. The company is globalizing: One consequence of making it a numbers game, which is what Netflix has done by keeping the focus on subscribers, is that you have to go where the numbers are, and for better or worse, that has meant that Netflix has had to go global, with Asia being the mother lode.

At the end of 2017, Netflix had more subscribers outside the US than in the US, and it is bringing its free spending ways and its views on content development to other parts of the world, perhaps bringing Bollywood and Hollywood closer, at least in terms of shared problems.

In summary, Netflix has built a business model of spending immense amounts on content, using that content to attract new subscribers, and then using those new subscribers as its pathway to market value. It is clear that investors have bought into the model, but the model is also one that burns through cash at alarming rates, with no smooth or near term escape hatch.

The Valuation
In keeping with the focus on subscriber numbers that is at the center of the Netflix story, I will value Netflix with the subscriber-based approach that I used to value Spotify a few weeks ago and Uber and Amazon Prime last year.

Cost Breakdown
The key to getting a subscriber-based valuation of Netflix is to first break its overall costs down into (a) costs for servicing existing subscribers, (b) the cost of acquiring new subscribers and (c) a corporate cost that cannot be directly related to either servicing existing subscribers or getting new ones. I started with the Netflix 2017 income statement:

Since Netflix does not break its costs down into my preferred components I made subjective judgments in allocating these costs, treating G&A costs as expenses related to servicing existing subscribers and marketing costs as the costs of acquiring new subscribers. With content costs, I started first with the $2,146 million difference between the cash content cost and expensed content cost and treated it also as part of the cost of acquiring new subscribers. With the expensed content cost of $7,600 million, I assumed that only 20% of these costs are directly related to subscribers and treated that portion as part of the cost of servicing existing subscribers and that the remaining 80% would become part of the corporate cost, in conjunction with the investment in technology and development. One key difference between the Netflix and Spotify cost models is that most of the content costs are fixed corporate costs for Netflix but almost all content costsare variable costs for Spotify, since it pays for content based upon how its subscribers listen to it, rather than as a fixed fee.

Value of an Existing Subscribers
My decision to treat most of the content content costs as a corporate cost has predictable consequences. The costs associated with individual subscribers are only the G&A costs and 20% of content costs, and the number is small, relative to the revenues that Netflix generates per subscriber:
Download spreadsheet

A strength that Netflix has built, perhaps with its original content, is that it has reduced it's churn rate (the loss of existing customers), each year since 2015. In 2017, the annual renewal rate for a Netflix subscription was about 91%, and that number improved even more across the four quarters. In my subscriber-valuation, I have used a 92.5% renewal rate, for the life of a subscriber, assumed to be 15 years. I will assume that Netflix investments in original content will give it the pricing power to increase annual revenue per subscriber (G&A and the 20% of content costs), which was $113.16 in 2017, at 5% a year, while keeping the growth rate in annual expenses per subscriber at the inflation rate of 2%. I estimate after-tax operating income each year, using a global average tax rate of 25%, and discount it back at a 7.95% cost of capital (estimated for Netflix, based upon its business and geographic mix, and debt ratio) to derive a value of $508.89 subscriber and a total value of $59.8 billion for Netflix’s 117.6 million existing subscribers.

Value of New Subscribers
To value a new subscriber, I first estimated the total cost that Netflix spent on adding new subscribers by adding the total marketing costs of $1,278 million to the capitalized portion of the content costs of $2,142 million, and then divided this amount by the gross increase in the number of subscribers (30.84 million) during 2017, to obtain a cost of $111.01 for acquiring a new subscriber. I then net that number out from the value of an existing subscriber to arrive at a value of $397.88/new subscriber right now; I assume that this value will increase at the inflation rate over time.
Download spreadsheet

I assume that Netflix will continue to add new subscribers, adding 15% to its net subscriber rolls, each year for the first five years, and 10% a year for years 6 through 10, before settling into a steady state growth rate of 1% a year. Discounting the value added by new subscribers at a higher cost of capital of 8.5%, reflecting the greater uncertainty associated with new subscribers, yields a total value of $137.3 billion for new subscribers.

The Corporate Drag
The final piece of the puzzle is to bring in the corporate costs that we assumed could not be directly linked with subscriber count. In the case of Netflix, the  technology & development costs and 80% of the expensed content, that we put into this corporate cost category amounted to $6.13 billion in 2017 and the path that these costs follow in the future will determine the value that we attach to the company.
Download spreadsheet

I assume that technology & development costs will grow 5% a year, but it is on the content cost component that I struggled the most to estimate a growth rate. I decided that the accelerated spending that Netflix had in 2017 and continued to have in 2018 reflect Netflix’s attempt to acquire standing in the business, and that while it will continue to spend large amounts on content, the growth rate in this portion of the content costs will drop to 3% a year, for the next 10 years. Note that even with that low growth rate, Netflix will be consistently among the top five spenders in the content business, spending more than $100 billion on original content over the next ten years. Discounting back the after-tax corporate expenses back at the 7.95% cost of capital, yields a corporate cost drag of $111.3 billion.

The Netflix Valuation: The One Number
To value Netflix, I bring together the value of existing and new subscribers and net out the corporate cost drag. I also subtract out the $6.5 billion in debt that the company has outstanding and the value of equity options granted over time to its employees.
The value per share of $172.82 that I estimate for Netflix is well below the stock price of $275, as of April 14, 2018. My value reflects the story that I am telling about Netflix, as a company that is able to grow at double digit rates for the next decade, with high value added with new users, while bringing its content costs under control. I am sure that your views on the company will diverge from mine, and you are welcome to use my Netflix subscriber valuation template to come to your own conclusions. 

It is worth taking a pause, and considering the differences between Netflix and Spotify, both subscription-based business models, that draw their value from immense subscriber bases.
  1. By paying for its content, both licensed and original, and using that content to go after subscribers, Netflix has built a more levered business model, where subscribers, both new and existing, have higher marginal value than at Spotify, where content costs are tied to subscribers listening to music. 
  2. The Netflix model, which is increasingly built around original rather than licensed content, provides for a stronger competitive edge, which should show up in higher renewal rates and more pricing power, adding to the value per subscriber, both existing and new. 
  3. The Netflix model will deliver higher value from subscription growth than the Spotify model, but it comes with a greater downside, because a slackening of that growth will leave Netflix much deeper in the hole, with more negative cash flows, than it would Spotify. 
Now that both companies are listed and traded, it will be interesting to see whether this plays out as much larger market reactions to subscription number surprises, both positive and negative, at Netflix than at Spotify.

In my earlier post on Google, I noted that every company has a value driver, one number that more than any of the others determines value. In the case of Netflix, the key value driver, in my view, is content costs. My value per share is premised not just on high growth in subscribers and continued subscriber value, but also on content costs growing at a much lower rate (of 3%) in the future. To illustrate the sensitivity of value per share to this assumption, I varied the growth rate in content costs and calculated value per share:
To illustrate the dangers to Netflix of letting content costs grow at high rates, note that the company’s equity value becomes negative (i.e., the company goes bankrupt), if content costs grow at high rates, relative to revenue growth, with double digit growth rates creating catastrophic effects. If Netflix is able to cap the costs at 2017 levels in perpetuity, the estimated value per share is approximately $216,  at the base case growth rate of 15%, and if it is able to reduce content costs in absolute terms over time, it is worth even more. In my view, investing in Netflix is less a bet on the company being able to deliver subscriber and/or revenue growth in the future and more one on the future path of content costs at the company.

The Decision
There is no doubt that Netflix has changed the way we watch television and the movies, and it is changing the movie/TV business in significant ways. By competing for talent in the content business, it is pushing up costs for its competitors and with its direct-to-streaming model, putting pressure on movie theaters and distribution. That said, the entertainment business remains a daunting one, because the talent is expensive and unpredictable, and egos run rampant. The history of newcomers who have come into this business with open wallets is that they leave with empty ones. For Netflix to escape this fate, it has to show discipline in controlling content costs, and until I see evidence that it is capable of this discipline, I will remain a subscriber, but not an investor in the company.

YouTube Video

Data Links
  1. Valuation of Netflix - April 2018
Blog Posts on Tech Takedown
  1. Come easy, go easy: The Tech Takedown!
  2. Facebook: Friendless, But Still Formidable!
  3. Netflix: The Future of Entertainment or House of Cards?
  4. Alphabet Soup: Google is Alpha, but where are the Bets?
  5. Amazon: Glimpses of Shoeless Joe!

Tuesday, April 10, 2018

The Facebook Feeding Frenzy: Time for a Pause!

In my last post, I noted that the FANG stocks have been in the spotlight, as tech has taken a beating in the market, but it is Facebook that is at the center of the storm. It was the news story on Cambridge Analytica's misuse of Facebook user data,  in mid-March of 2018, that started the ball rolling and in the days since, not only have more unpleasant details emerged about Facebook's culpability, but the rest of the world seems to have decided to unfriend Facebook. More ominously, regulators and politicians have also turned their attention to the company and that attention will be heightened, with Zuckerberg testifying in front of Congress. That is a precipitous fall from grace for a company that only a short while ago epitomized the new economy.

A Personal Odyssey
My interest in Facebook dates back to the year before it went public, when it was already getting attention because of its giant user base and its high private company valuation. In the weeks leading up to its IPO, I valued Facebook at about $29/share, with a story built around it becoming a Google wannabe. If that sounded insulting, it was not meant to be, since having a revenue path and operating margins that mimicked the most successful tech companies in the decade prior is quite a feat.

That initial public offering was among the most mismanaged in recent years and a combination of hubris and poor timing led to an offering day fiasco, where the investment bankers had to step in to support the priced. The first few months after the offering were tough ones for Facebook, with the stock dropping to $19 by September 2012, when I argued that it was time to befriend the company and buy its stock, one of the few times in my life when I have bought a stock at its absolute low.

Much as I would like to tell you that I had the foresight to see Facebook's rise from 2012 through 2017 and that I held on to the stock, I did not, and I sold the stock just as it got to $50, concerned that the advertising business was not big enough to accommodate the players (Google, the social media companies and traditional advertising companies), elbowing for market share. I under estimated how much Google and Facebook would both expand the market and dominate it, but I have no regrets about selling too early. I did what I felt was right, given my assessment and investment philosophy, at the time.

A Numbers Update
To undersand how Facebook became the company that it is today, let's start with its most impressive numbers, which are related to its user base. At the start of 2018, Facebook had more than 2.1 billion users, about 30% of the world's population:

While the user numbers have leveled off in North America, where Facebook already counts 72.5% of the population in its user base, the company continues to grow its user base in the rest of the world, with an added impetus coming from the scaling up of Instagram, Facebook's video arm. These user numbers, while staggering, are made even more so when you consider how much time Facebook users spend on its platforms:
Collectively, users spent more than an hour a day on Facebook platforms, and that usage does not reflect the time spent on WhatsApp, also owned by Facebook, by its 1.5 billion users.

If you are a value investor, it would easy to dismiss Facebook as another user-chasing tech company and deliver a cutting remark that you cannot pay dividends with users, but Facebook is an exception. It has managed to to convert its user base into revenues and more critically, operating profits.

With its operating margin approaching 58%, if you capitalize its technology and content costs, Facebook outshines most of the other companies in the S&P 500, in both growth and profitability:

What makes Facebook's rise even more impressive is that it has been able to deliver these results in a market, where it faces an equally voracious competitor in Google.

In summary, Facebook has had perhaps the most productive opening act in history of any publicly listed company, if you define production in operating results. It promised the moon at the time of its IPO, and has delivered the sun. In my book on connecting stories to value, I pointed to Facebook as a company that seemed to find new ways, with each acquisition, announcement and earning report, to expand and broaden its story, first by conquering mobile and then going global. By the start of 2016, I had changed my story for Facebook from a Google Wannabe to one that would eclipse Google, with added potential from its user base. While the Facebook story has been one of business success, the company, its users and investors have been in denial about central elements in the story. Facebook's users have been trading information on themselves to the company in return for a social media site where they can interact with friends, family and acquaintances, and their complaints about lost privacy ring hollow. Facebook's strengths are built upon using the information that users provide about themselves to better target advertising and generate revenues, but Facebook and its investors have been unwilling to face up to the reality that the company's high margins reflect its use of third parties and outsiders to collect and manage data, a business practice that is profitable but that also creates the potential for data leakages. (Some of you seem to be reading into my words an implication that Facebook sells user data to third parties to generate revenues. It does not. It processes the data to make it information (its first competitive advantage), uses that information to better target advertising and generates revenues, as a consequence.)

A Story Break, Twist or Change?
If the Facebook story so far sounds like a fairy tale, there has to be a dark twist, and while Facebook's troubles are often traced back to the stories in mid-March 2018, when the current user scandal news cycle began, its problems have been simmering for much longer. Put on the defensive, after the 2016 US presidential elections, for being a purveyor of fake news, Facebook announced in January 2018, that it had changed its news feed to emphasize user interaction over passive consumption of public news feeds. That change, which led to a leveling off in user numbers and a loss of advertising revenues was not well received on Wall Street, with the stock price dropping almost 5%.

If Facebook was trying to preempt its critics with this announcement, the Cambridge Analytica story has knocked them off stride. Specifically, a whistle blower at Cambridge Analytica claimed that the company has not only accessed detailed user data on 50 million Facebook users but had used that data to target voters in political campaigns. In the three weeks since, the story has worsened for Facebook both in terms of numbers (with accessed users increasing to 87 million) and culpability (with Facebook's sloppiness in protecting user data highlighted). As politicians, commentators and competitors have jumped in to exploit the breach, financial markets knocked off $81 billion from Facebook's market capitalization. It is unquestionable that Facebook is mired in a mess and that it deserves market punishment, but from an investing perspective, the question becomes whether the loss in value is merited or not. 

The worst case scenario, and some have bought into this, is that the company will lose users, both in numbers and intensity, and that advertisers will pull out. If you add large fines and regulatory restrictions on data usage that may cripple Facebook's capacity to use that data in targeted advertising, you have the makings of a perfect storm, playing out as flat or declining revenues, big increases in operating costs and imploding value. In my view, and I may very well be wrong, I think the effects will be more benign:
  1. User loss, in numbers and intensity, will be muted: It is still early in this news cycle, and there may be more damaging revelations to come, but I don't believe that anything that has come out so far is  egregious enough to cause large numbers of users to flee. We live in cynical times and many users will probably agree with Mark Snyder, a Facebook user whose data had been accessed by Cambridge Analytica, who is quoted as saying in this New York Times article, "If you sign up for anything and it isn’t immediately obvious how they’re making money, they’re making money off of you.” There is some preliminary evidence that can be gleaned from surveys taken right after the stories broke, which indicate that only about 8% of Facebook users are considering leaving and 19% plan significant cutbacks in usage. If this represents the high water mark, the actual damage will be smaller. I will assume that Facebook's push towards more data protections and its larger base will slow growth in revenues down to about 20% a year, for the next 5 years, from the 51.53% growth rate over the last five years.
    Source: Raymond James, reported by Variety
  2. Advertisers will mostly stay on: While a few companies, like Mozilla, Pep Boys and Commerzbank, announced that they were pulling their ads from Facebook, there is little evidence that advertisers are abandoning Facebook in droves, since much of what attracted them to Facebook (its large and intense user base and targeting) still remains in place. Facebook, in an attempt to clean up the platform, may impose restrictions on advertisers that may drive some of them away. For instance, last week, Facebook announced that it would stop accepting political advertisements from anonymous entities and I would not be surprised to see more self-imposed restrictions on advertising. I will assume that there will be more defections in the weeks ahead, mostly from companies that don't feel that their Facebook advertising is effective right now, leading to a loss in revenues of $1.5 billion next year.
  3. Data restrictions are coming, and will be costly: There is no doubt that data restrictions are coming, with the question being about how restrictive they will be and what it will cost Facebook to implement them. Data privacy laws, modeled on the EU's format, will require the company to hire more people to oversee data collection and protection. I will assume that these actions will push up costs and reduce the pre-tax operating margin from 57%, after capitalizing technology and content costs, to 42% over the next 5 years. Pre-capitalization of technology and content, I am expecting the operating margin to drop from 49.7% (current) to about 37-38%,
  4. There will be fines: This is a wild card in this process, with the possibility that the Federal Trade Commission  may impose a fines on the company for violating an agreement reached in 2011, where Facebook agreed to protect user data from unauthorized access. While no one seems to have a clear idea of how much these fines will be, other than that they will be large, there are some who believe that the fines could be as high as a billion dollars. I will assume that the FTC will use Facebook to send a signal to other companies that collect data, by fining it $1 billion.
As I see it, the scandal will lead to lost sales in the near term, slow revenue growth in the coming years and increase costs at the company, making the Facebook story a less attractive one. My estimates of how the story changes will play out in the numbers is shown below:
In summary, the story that I have for Facebook is still an upbeat one, albeit one with lower growth and operating margins. The resulting value is shown below:
Download spreadsheet
The value per share that I obtain, with my story, is abut $181, and on April 3, the date of the valuation, the stock was trading at $155 a share. As always, I am sure that there are inputs where you will disagree with me, and if you do, you can download the spreadsheet and change the numbers that you disagree with. Some of you may be wondering why I have no margin of safety, but as I noted in this post on the topic from a while back, I believe that there are more effective ways of dealing with uncertainty that adopting an arbitrary margin of safety and sitting on the sidelines. In fact, my favored device is to face up to uncertainty frontally in a simulation, shown below:
Simulation run with Crystal Ball, in Excel
This graph reinforces my decision to invest in Facebook. While it is true that there is a 30% chance that the stock is still over valued, there is more upside than downside potential, given my inputs. The median value of $179 is close to my point estimate value, but that should be no surprise since my distributions were centered on my base case assumptions.

Time to Buy?
Every corporate scandal becomes a morality play, and the current one that revolves around Facebook is no exception. Facebook has been sloppy with user data, driven partly by greed (to keep costs down and profits up) and partly by arrogance (that its data protections were sufficient), and is and should be held accountable for its mistakes. That said, I don't see Facebook as a villain, and I don't think that the company should be used as a punching bag for our concerns about politics and society.  I am sure that when Mark Zuckerberg delivers his prepared testimony in a couple of hours, senators from both parties will lecture him on Facebook's sins, blissfully blind to their hypocrisy, since I am sure that many of them have had no qualms about using social media data to target their voters. I hear friends and acquaintances wax eloquent about invasion of privacy and how data is sacred, all too often on their favorite social media platforms, while revealing details about their personal lives that would make Kim Kardashian blush. I am an inactive Facebook user, having posted only once on its platform, but to those who would tar and feather the company for its perceived sins, I will paraphrase Shakespeare, and argue that the fault for our loss of privacy is not in our social media, but in how much we share online. I will invest in Facebook, with neither shame nor apology, because I think it remains a good business that I can buy at a reasonable price.

YouTube Video

Data Links

  1. Valuation of Facebook - April 2018
Blog Posts on Tech Takedown
  1. Come easy, go easy: The Tech Takedown!
  2. Facebook: Friendless, But Still Formidable!
  3. Netflix: The Future of Entertainment or House of Cards?
  4. Alphabet Soup: Google is Alpha, but where are the Bets?
  5. Amazon: Glimpses of Shoeless Joe!

Saturday, April 7, 2018

Come easy, go easy: The Tech Takedown!

If there is one thing that I have learned about markets over the years, it is that they have a way of leveling egos and cutting companies and investors down to size. The last three weeks have been humbling ones for tech companies, especially the big four (Facebook, Amazon, Netflix and Alphabet or FANG) which seemed unstoppable in their pursuit of revenues and ever-rising market capitalizations, and for tech investors, many of whom seem to have mistaken luck for skill. Not surprisingly, some of the cheerleaders who were just a short while ago telling us that nothing could go wrong with these companies are in the midst of a mood shift, where they are convinced that nothing can go right with them. As Mark Zuckerberg gets ready to testify to Congress, amidst calls for both regulating and perhaps even breaking up tech companies, it is time to take a sober look at where we stand with these companies, what the last three weeks have changed and the consequences for investment decisions.

The Rise of Facebook, Amazon, Netflix and Google (FANG)
The outsized attention paid to the FANG (Facebook, Amazon, Netflix and Google) stocks sometimes obscures how young these companies are in the public market place. Amazon, a company that I valued as an online, book retailer in 1998, a year after its listing, is the granddaddy of the group. The Google IPO , remembered primarily because of its use of a Dutch auction, instead of a banker, to set its offering price was in 2004, but you probably completely missed the Netflix IPO two years earlier in 2002, and Facebook, the youngest of the four, went public in 2012. The growth in market capitalization at these companies is the stuff of investing legend and the table below shows how they have almost tripled their contribution to the overall market capitalization of the S&P 500 between 2012 and 2017 (with all numbers in billions of US $):

At the end of the 2017, Amazon, Google and Facebook were three of the ten largest market capitalization companies in the world.

The role that the FANG companies have played in driving US equities can be best seen with a different lens, by looking at the total change in the market capitalization of the S&P 500 and how much of that change can be attributed to the rising values of just these four companies:

To add weight to these numbers, consider these facts. The four companies that comprise FANG added almost $1.7 trillion in market capitalization over these five years and accounted for one-sixth of the increase in value for the entire index. Put simply, if you were a large-cap US portfolio manager and you held none of these stocks between 2013-2017, it would have been very, very difficult, if not impossible, to beat the S&P 500 over this period.

A Reversal in Fortunes for the FANG stocks
It is the sustained success of these companies that has made the last few weeks so trying for investors in them and so unsettling for market watchers. While these stocks went through the same ups and downs that the rest of the market was going through in February, it was in the middle of March that they became the central story, with the revelations from Cambridge Analytica, a data analytics and consulting firm, that they had harvested data on about 50 million Facebook users (a number that has since been increased to 87 million) for use in political and commercial campaigns. The political firestorm that followed has not only hurt Facebook, but the other three companies as well, and the graph below chronicles the damage in the days since the news story was released:

The numbers are staggering, at least in absolute terms. Collectively, the FANG stocks  lost $282 billion in market capitalization between March 15 and April 2 and contributed significantly to the drop in US equity markets over that period. To put that in perspective, the market capitalization lost in just these four companies in about two weeks was greater than the total value all crypto currencies (Bitcoin and all its relatives) as of the start of April of 2018, perhaps suggesting that we have been letting ourselves get distracted by penny change, when dollars are at stake. It is also interesting that while much of the attention has been directed at Facebook, which lost 15% of its value in just over two weeks, the three other stocks each lost about 12% of their value.

Speaking of perspective, though, investors in these four stocks should consider another fact before they complain too much about being punished by the market. Even with the losses through April 2 incorporated, the collective market value of these companies remains about $400 billion higher than it was a year ago, on April 3, 2017. 

The bottom line is that two weeks of market pull backs cannot take away from the longer term success at these companies. If this is what failure looks like, I would love to see more of it in my portfolio.

The Fang Story Line
To understand both the rise and recent pullback, let's look at what these four companies have in common. As I see it, here are the salient features:
  1. Scaling Success: Each of these companies has been able to keep revenue growing rapidly, even as they scale up and acquire larger market share. In effect, they have been able to deliver small company growth rates, while becoming monoliths.
    This success of these companies at delivering high growth, as they have become bigger, have some led some to rethink long-held beliefs about the limits of growth.
  2. Bigger Slice of a Bigger Pie: All four of these companies have also been able to change the businesses that they have entered, increasing the size of the total market by attracting new customers, while also changing the way business is run to their benefit. With Google and Facebook, that business is advertising, with Netflix, it is entertainment, and with Amazon, it is just about any business it enters, from retailing to entertainment to cloud services. In each of these businesses, they have not only made the pie bigger but also increased their slice of it, quite a feat!
  3. Promise of Profitability: Alphabet and Facebook are money-making machines, with very high profit margins; Facebook's margins are among the highest among large market capitalization companies and Google's are in the top decile.
    Amazon has lagged on profitability historically, but it seems to be showing progress in the last few years, and Netflix still struggles to generate decent profit margins. The low margins that these companies show are deceptively low because they are low, after expensing what would be business building or capital expenditures in most other companies - $22.6 billion in technology and content at Amazon and almost $8 billion in content costs at Netflix. 
If, in 2008, you had described the trajectories that these companies would go through, to get to where they are today, I would have given you long odds on it happening. To the question of how they pulled it off, I would point to three factors;
  1. Centralized Power: These companies are more corporate dictatorships, than corporate democracies. All four of these companies continue to be run by founder/CEOs, whose visions and narratives have focused these companies; Brin and Page, at Alphabet, Zuckerberg, at Facebook, Bezos at Amazon and Hastings at Netflix, have unchallenged power at these companies, and the only option that shareholders who disagree with them have is to sell and move on. 
  2. Big Data: While big data is often a buzz word thrown into conversations where it does not belong, these four companies epitomize how data can be used to create value. In fact, you can argue that what Google learns from our search behavior, Facebook from our social media interactions, Netflix from our video watching choices and Amazon from our shopping carts (and Alexa) is central to these companies being able to scale up successfully and change the businesses they are in. Google and Facebook use what they learn about us to allow companies to target their advertising, Netflix develops content that reflects our watching preferences and Amazon uses our shopping history and Prime membership to run circles around its competitors.
  3. Intimidation Factor: There is one final intangible in the mix and that is the perception that these companies have created in regulators, customers and competitors that they are unstoppable. Advertisers facing off against Google and Facebook increasingly settle for crumbs off the table,  convinced that they cannot take on either company frontally, the entertainment business which once viewed Netflix as a nuisance has learned not only to live with the company but has adapted itself to the streaming world and Amazon's entry into almost any business seems to lead to a negative reassessment of the status quo in that business.
In short, if you were an investor in any of these companies until three weeks ago, the story that you would have used to justify holding them would have been that they were juggernauts headed for global domination, and valued accordingly.

Story Break, Recalibration or Tweak?
If you have read my prior posts on valuation, you know that I am a great believer that stories hold together valuations, and that it is changes to stories that change valuation. It is still early, but the question that investors face is whether what has happened in the last three weeks has changed the story dynamics fundamentally at these companies.  At the very minimum, we have at least noticed that the strengths that we noted in the last section come with accompanying weaknesses
  1. CEO heads cannot roll: Unlike traditional companies facing crises, where CEOs can be offered by a board of director as a sacrificial offering to calm investors, regulators or politicians, the FANG companies and their CEOs are so intertwined, with power entrenched in the current CEOs, this option is off the table. Even if Mark Zuckerberg performs like Valeant's Michael Pearson did in front of a congressional committee next week, he will still be CEO for the foreseeable future, an advantage that having voting shares and controlling more than 50% of the voting rights gives him.
  2. The Dark Side of Sharing: I don't know what we, collectively as users of these companies' products and services, thought they were doing with all of the information that we were sharing so willingly with them, but until the last few weeks, we were able to look the other way and assume that it would be used benevolently. The Facebook fiasco with Cambridge Analytica has pushed some of us out of denial and perhaps into a reassessment of how we share data and how that data is used. It has also created a firestorm about data sharing and privacy that may result in restrictions in how the data gets used.
  3. No Friends: When other companies feel threatened by your success and growth, it should come as no surprise that many of them are cheering, as you stumble. From Elon Musk shutting down Tesla's Facebook presence] to Tim Cook castigating Google and Facebook for misusing data, there seems to be a desire to pile on. Musk has far bigger problems at Tesla than it's Facebook page, and Cook should be careful about throwing stones from a glass house, but watching the FANG companies squirm is evoking joy in the boardrooms of its competitors.
So, what now? As I see it, there are three ways to read the tea leaves, with the effects on value ranging from very negative to non-existent.

  1. Second Thoughts on Sharing: It is possible that the news stories about how exposed we have left ourselves, as a consequence of our sharing, will lead us to all to reassess how much and how we interact online. That would have significant consequences for all of the FANG stocks, since their scaling success and business models depend upon continued user engagement. 
  2. Tempest in a teapot: At the other end of the spectrum, there are some who argue that after the Zuckerberg testimony, the story will blow over and that not only will the companies revert back to their old ways, but that they will continue to accumulate users and grow revenues, while doing so.
  3. Data Protections: The third possibility lies somewhere between the first two. While the news stories may have little effect on how people use these companies' products and services, there may be new restrictions on how the data that is collected from their usage is utilized by the companies. That would include not only privacy restrictions, similar to those already in place in the EU, but also regulations on how the data is collected, stored and shared. In addition, the companies themselves may feel pressure to change current business practices, which while profitable, have left data vulnerabilities. 
I don't buy into either of the first two scenarios. I think that we are too far gone down the sharing road to reverse field, and that while we will have a few high profile individuals signal their displeasure by abandoning (or claiming to abandon) a platform, most of us are too attached to Google search, our Facebook friends, watching Black Mirror on Netflix and the convenience of Prime to throw them overboard, because our privacy has been breached. In fact, I would not be surprised if Facebook usage has gone up in the days since the crisis, rather than down. 

I also think that assuming that these stories will pass with no effect is a mistake, since there are changes coming to these firms, from within and without, that will have value consequences. To illustrate, Facebook has already announced that it will stop using data from third party aggregators to supplement its own data in customer targeting, because of data concerns, and I am sure that there are more changes  coming, many of which will increase Facebook's costs and crimp revenue growth, and through those changes, the value that we attach to Facebook. I also believe that you will see more restrictions on the use of data and that these rules will also have an effect on costs, growth and value. Rather than extend this post further, by looking at the impact of these changes, I will be using my next post to update my stories and valuations of Facebook, Amazon, Netflix and Google. If you want a preview, suffice to say that I am back to being a Facebook shareholder, that I am close to becoming a Google shareholder for the first time and that Amazon and Netflix remain out of my reach. 

YouTube Video

Blog Posts on Tech Takedown
  1. Come easy, go easy: The Tech Takedown!
  2. Facebook: Friendless, But Still Formidable!
  3. Netflix: The Future of Entertainment or House of Cards?
  4. Alphabet Soup: Google is Alpha, but where are the Bets?
  5. Amazon: Glimpses of Shoeless Joe!

Friday, March 23, 2018

Spotify Loose Ends: Pricing, User Value and Big Data!

In my last post, I valued Spotify, using information from its prospectus, and promised to come back to cover three loose ends: (1) a pricing of the company to contrast with my intrinsic valuation, (2) a valuation of a Spotify subscriber and, by extension, a subscriber-based valuation of the company, and (3) the value of big data, seen through the prism of what Spotify can learn about its subscribers from their use of its service, and convert to profits.

1. The Pricing of Spotify
I won't bore you by going through the full details of the contrast that I see between pricing an asset and valuing it, since it has been at the heart of so many of my prior posts (like this, this and this). In short, the value of an asset is determined by its expected cash flows and the risk in these cash flows, which you can estimate imprecisely using a discounted cash flow model. The price of an asset is based on what others are paying for similar assets, requiring judgments on what comprises similar.  My last post reflected my attempt to attach an intrinsic value to Spotify, but the pricing questions for Spotify are two fold: the companies that investors in the market will compare it to, to make a pricing judgment, and the metric that they will base the pricing on.

Let's start with the simplest version of pricing, a one-on-one comparison. With Spotify, the two companies that are likeliest to be offered as comparable firms are Pandora, a company that is in the same business (music streaming) as Spotify, deriving its revenues from advertising and subscription, and Netflix, a company that is also subscription-driven, and one that Spotify would like to emulate in terms of market success. Since Spotify and Pandora are reporting operating losses, there are only three metrics that you can scale the pricing of these companies to: the number of subscribers, total revenues and gross profits. I report the numbers for all three companies in the table below, in conjunction with the enterprise values for Pandora and Netflix:
For Pandora and Netflix, the numbers for users and revenues/profits come from their most recent annual reports for the year ending December 31, 2017, and for Spotify, the numbers are from the prospectus covering the same year. To use the numbers to price Spotify, I first estimate pricing multiples for Pandora and Netflix. and then use these multiples on Spotify's metrics:
To illustrate the process, I price Spotify, relative to Pandora and based on subscribers, by first computing the enterprise value/subscriber for Pandora (EV/Subscriber= 1135/74.70 = 15.19). I then multiply this value by Pandora's total subscriber count of 159 million to arrive at a pricing of $2,416 million for Spotify. I repeat this process for Netflix, and then repeat it again with both companies, using revenues and gross profit as my scaling variables. The table of pricing estimates that I get for Spotify explains why those who are bullish on the company will try to avoid comparisons to Pandora and encourage comparisons to Netflix. If, as is rumored, Spotify's equity is priced at between $20 and $25 billion, it will look massively over priced, if compared to Pandora, but be a bargain, relative to Netflix. As you can see, each of these comparisons has problems. Spotify not only has a more subscription-based revenue model than Pandora, yielding higher overall revenues, but its more global presence (than Pandora) has insulated it better from competition from Apple Music. Netflix has an entirely subscription-based model and generates more revenues per subscriber, while facing less intense competition.  The bottom line is that the pricing range for Spotify is wide, because it depends on the company you compare it to, and the metric you base the pricing on. That may come as no surprise for you, but it will explain why there will wide divergences in pricing opinion when the stock first starts to trade, resulting in wild price swings. If you are not adept at the pricing game, and I am not, you should stay with your value judgment, flawed though it might be. I will consequently stick with my intrinsic value estimate for the equity in the company.

2. A Subscriber-Based Valuation of Spotify
Last year, I did a user-based valuation of Uber and used it to understand the dynamics that determine user value and then to value Amazon Prime. That framework can be easily adapted to value Spotify subscribers, both existing and new. To value Spotify's existing subscribers, I started with the base revenue per subscriber and content costs in 2017, made assumptions about growth in each item and used a renewal rate of 94.5%, based again upon 2017 numbers (all in US dollar terms):
Download spreadsheet
Note that revenues/subscriber grow at 3% a year, faster than the growth rate of 1.5%/year in content costs, reducing content costs to 70% of subscriber revenues in year 10, consistent with the assumption I made in the top down valuation in the last post. The value of a premium subscriber, allowing for the churn in subscriptions (only 43% make it through 15 years) and reduced content costs, is $108.65, and the total value of the 71 million premium subscriptions works out to about $7.7 billion.

To estimate the value of new users, I first had to estimate how much Spotify was spending to acquire a new user. To obtain this value, I took the total marketing costs in 2017 (567 million Euros or $700 million) and divided that by the number of new subscribers added in 2017:
Cost of acquiring new user = 700 / (71 - 48*.945) = $27.30
While the number of premium subscribers grew from 48 million to 71 million, I reduced the former value by the churn reported (5.5% of subscribers canceled in 2017). The value of new subscribers then can be computed, assuming that the number of net subscribers grows 25% a year from years 1-5, 10% a year from years 6-10 and 1% a year thereafter (The weakest link in this calculation is the churn rate, which as some of you pointed out is measured in monthly terms. I read this section of the prospectus multiple times to get a better sense of renewal and cancellation rates and here is what I get out of that reading. If the true monthly churn rate is 5.5%, the annual churn rate should more than 50%, meaning that 25 million of the 48 million subscribers that Spotify had at the start of the year left during the year. I don't think that happened, because the total subscribers would not have jumped to 71 million. My guess is that the monthly churn rate reflects how new subscribers become established subscribers, with many trying the service for a month, dropping it, and then coming back again. The annualized churn rate is probably closer to 15%-20% overall and much lower for established Spotify subscribers. I considered using a lower renewal rate in the early years and increasing it in later years, but gave up on it since my information is still hazy. I do believe that will be a key factor in whether Spotify can deliver value, and while the trend lines on the churn rate are good, they need to make their subscribers as sticky as Netflix has made its subscribers.)
Download spreadsheet
In valuing the cash flows from new users, I use a 10% US$ cost of capital, the 75th percentile of global companies, reflecting the higher risk in this component of Spotify's value, and derive a value of about $13.6 billion for new users. (I thank the readers who noticed that I was misestimating my subscriber count, starting in year 2. The numbers should now gel, with the growth rate in net subscribers matching up.)

Spotify does get about 10% of its revenues from advertising, and I will assume that this component of revenue will persist, albeit growing at a lower rate than premium subscription revenues; the revenues will grow 10% a year for the next ten year and content costs attributable to these revenues will also show the same downward trend that they do with premium subscriptions. The value of the advertising revenues is shown to be about $2.9 billion:
Download spreadsheet
The final component of value is mopping up for costs not captured in the pieces above. Specifically, Spotify has R&D and G&A costs that amounted to 660 million Euros in 2017 (about $815 million), which we assume will grow 5% a year for the next 10 years, well below the growth rate of revenues and operating income, reflecting economies of scale. Allowing for the tax savings, and discounting at the median cost of capital (8.5%) for a global company, I derive a value for this cost drag:
Download spreadsheet
The value for Spotify, on a user-based valuation, can then be calculated, adding in the cash balance (1,5091.81 million Euros or $1,864 million) and a cross holding in Tencent Music that I had overlooked in my DCF (valued at 910 million Euros or $1,123 million), and netting out the equity options outstanding (valued at 1344 million Euros or $1660 million):
Download spreadsheet
The operating asset value is slightly lower than the value that I obtained in my top-down DCF (by about a billion), and there are two reasons for the difference. The first is that I did not incorporate the benefits of the losses that Spotify has to carry forward (approximately $1.7 billion) in my subscriber-based valuation, with the resulting lost tax benefit at a 25% tax rate, of about $300 million. The second reason is that I used a composite cost of capital of 9.24% on all cash flows in top down valuation, whereas I used a lower (8.5%) cost of capital for existing users and a higher (10% cost of capital) for new users; that translates into about $600 million in lower value. The value of equity in common stock, the number that will be most directly comparable to market capitalization on the day of the offering, is $19.6 billion.

3. The Big Data Premium?
There is one final component to Spotify's value that I have drawn on only implicitly in my valuations and that is its access to subscriber data. As Spotify adds to its subscriber lists, it is also collecting information on subscriber tastes in music and perhaps even on other dimensions. In an age where big data is often used as a rationale for adding premiums to values across the board, Spotify meets  the requirements for a big data payoff, listed in this post from a while back. It has exclusivity at least on the information it collects from its subscribers on their musical tastes & preferences and it can adapt its products and services to take advantage of this knowledge, perhaps in helping artists create new content and customizing its offerings. That said, I do no feel the urge to add a premium to my estimated value for three reasons:
  1. It is counted in the valuations already: In both my top down and user-based valuations, I allow Spotify to grow revenues well beyond what the current music market would support and lower content costs as they do so. That combination, I argued, is a direct result of their data advantages, and adding a premium to my estimated valued seems like double counting.
  2. Decreasing Marginal Benefits: The big data argument, even if based on exclusivity and adaptive behavior, starts to lose its power as more and more companies exploit it. As Facebook reviews our social media posts and tailors advertising, Amazon uses Prime to get into our shopping carts and Alexa to track us at home, and uses that data to launch new products and services and Netflix keeps track of the movies/TV that we watch, stop watching and would like to watch, there is not as much of us left to discover and exploit.
  3. Data Backlash: Much as we would like to claim victimhood in this process, we (collectively) have been willing participants in a trade, offering technology companies data about our private lives in return for social networks, free shipping and tailored entertainment. This week, we did see perhaps the beginnings of a reassessment of where this has led us, with the savaging of Facebook in the market. 
The big data debate has just begun, and I am not sure how it will end. I personally believe that we are too far gone down this road to go back, but there may be some buyers' remorse that some of us are feeling about having shared too much. If that translates into much stricter regulations on data gathering and a reluctance on our part to share private data, it would be bad news for Spotify, but it would be worse news for Google, Facebook, Netflix and Amazon. Time will tell!
YouTube Video

Data Links