What Equity Analysts Need To Do About “606”

One of the most substantial recent changes in public company accounting is ASC 606: Revenues from Contracts with Customers. The changes affect a wide range of public filers, from SaaS companies to real estate managers, to fast food franchisors. This post will focus on what analysts can do to efficiently see what has changed in their coverage universe. For the accounting enthusiasts who want to know more about the changes themselves, we recommend KPMG’s 1,100-page implementation guide.

As the implementations have been rolling in the filers’ SEC filings, we find that two Doc Searches can help analysts find the adjustments provided by the companies.

For income statement changes, we use IN:TABLE search for revenue within 200 words of “606.” In Sentieo, analysts can search specific company documents, docs from several companies (tickers entered manually or in a saved watchlist), or general search (which can be modified by factors such as market cap, headquarters location, specific filing forms, sector, and many others).

For balance sheet changes, we use IN:TABLE search for equity, within 200 words of 606.

Using these searches enabled us to find what we need, in a fraction of the time that older search methods require. Here are some of our findings.

Intuit (INTU), parent of QuickBooks and TurboTax, went from a loss to almost break-even in its third quarter under the new standard.

SaaS company AutoDesk (ADSK): we see that both revenues and the closely watched ARR numbers are affected.

Dunkin’ Brands (DNKN), franchisor of Dunkin and Baskin Robbins, analyzed the applicability of 606 to its revenue streams (franchise fees, advertising fund fees, products, rents), and Sentieo provides a detailed breakdown.

Our balance sheet search mentioned above picked up some notable changes, too.

Commercial real estate broker and manager Jones Lang LaSalle (JLL) saw several changes in its balance sheet, notably the creation of several new line items related to the adoption of 606.

SVB Financial (SIVB), parent of Silicon Valley Bank, also reported major changes in its accounts receivable and its deferred revenues on its balance sheet.

Finally, telecom Sprint Corporation (S) saw balance sheet adjustments in a few categories, including the addition of $1.2 billion of customer contract acquisitions on the Assets side, and a $1.3 billion swing from negative accumulated earnings to positive.

If you’d like to learn more about how using Sentieo can help your process, get in touch.

First Steps of Income Statement Analysis: A Look at Cheesecake Factory, Inc. (CAKE)

A picture is worth a thousand words — or maybe around $2 bn (which happens to be CAKE’s market cap). Three of Sentieo’s core functions are table extraction, plotting and record management. In this blog post, we demonstrate how analysts use these convenient functions to visualize a company’s financials in minutes.

CAKE, like many other restaurant companies, reports its Income Statement in a non-standard format: there is no all-encompassing COGS. Instead, we see different line items with different cost buckets, such as food costs, labor costs, and occupancy costs. In its earnings release 8-K, CAKE also calculates each of these line items as a percentage of sales.

Using Sentieo’s Time Series Function, we will build a time series containing the major operational line items: food costs, labor costs, and “other” operating expenses.

 

After the extraction, we can review the numbers by document by clicking ”Next’ (always check to see if the numbers are a 6-9-12 month summation, or just the Q4 is a 12-month. See the boxes in the lower left that help the adjustments). From here, one can open the source document, export to Excel, or open in the Plotter charting engine — after checking the numbers. For companies that change formats, you can enter the correct number in the columns on the left field. We do this here for Q1 and Q2 2015 as the numbers appear without a “%” signs.

The corrected numbers for 2015 look like this:

After we have made sure that the numbers look good (all are coming from quarterly columns, all are in the same percentage format), we open the data in Plotter.

Since all numbers are given as a percentage of sales, we can merge the Y-axes from the chart settings.

To get a better idea for the underlying cost trends, we are muting the quarterly numbers for each series, and adding a 4-quarter moving average. We can also customize colors, line format and line thickness.

Here we can see the longer term trends. While food and occupancy costs have stayed relatively steady (as a percent of sales), we can see that labor expenses have been moving up.

 

We are now ready to save, tag, and share the chart with the team.

The chart is now a part of our CAKE Notes, and can be commented on, added to full theses, or to other Notes inside Sentieo’s Notes Records Management System.

 

From here, we are ready to dig in deeper in the corporate documents to see what has been going on. Click here for interactive chart.

See how these, and many other tools on the platform, can make your research process more efficient: request a free trial here.

How to Analyze Changes to Executive Pay Structures with Advanced Document Search Features

“Show me the incentive and I will show you the outcome”  – Charlie Munger

This classic quote from Berkshire Hathaway’s nonagenarian Vice Chairman is something that fundamental investors need to always keep in mind when analyzing companies. Is your CEO paid to grow sales at any cost? Will she amass generational wealth if she sells the company?

Thankfully, these questions can be answered by a careful review of various SEC filings regarding compensation, and, especially, by noting changes compared to prior years. Analyzing pay is not used only by buy-side and sell-side analysts: compensation consultants, and, increasingly, activist shareholders and political groups have been scrutinizing executive pay. Looking for changes in company filings is easy in Sentieo’s document search which allows users to compare filings to any other filing, filed at any time with the SEC.

For example, here we are looking for changes in Colgate Palmolive’s omnibus executive compensation plan that was previously filed five years ago. We have selected the “All Changes” option in Redlining Mode and compare the recent 8-K filing to a custom-selected 8-K filing from five years ago that we located easily in through our Document Search.

 

The 100 Best Twitter Accounts for Finance

Last year, we published our first annual list of the top Finance twitter handles. About a year later, we’ve come back with an update to the dataset.

As a financial research platform built for modern analysts, Sentieo incorporates data from the financial realm of Twitter into its product as part of a curated news stream for each ticker. The 2018 list of handles to follow spans people and organizations with an eye for equities, who offer thoughtful insight and tweet often.

We used a data-driven approach coupled with curated selection to uncover the very best, and we go into more detail on our methodology below. Without further ado here are the top 100 Finance Twitter handles to follow in 2018:

Rank Twitter Handle Popularity Rating Total Followers % of Total Followers
1 John_Hempton 79 24,400 0.32%
2 BarbarianCap 76 21,100 0.36%
3 muddywatersre 73 47,600 0.15%
4 AlderLaneeggs 71 16,400 0.43%
5 CitronResearch 68 60,200 0.11%
6 BrattleStCap 67 18,700 0.36%
7 KerrisdaleCap 65 20,200 0.32%
8 modestproposal1 65 22,700 0.29%
9 marketfolly 65 48,200 0.13%
10 EventDrivenMgr 64 6,698 0.96%
11 ActivistShorts 64 15,400 0.42%
12 Carl_C_Icahn 64 342,000 0.02%
13 LongShortTrader 63 20,000 0.32%
14 DonutShorts 62 10,200 0.61%
15 sprucepointcap 62 10,600 0.58%
16 BluegrassCap 59 16,000 0.37%
17 SIRF_Report 57 8,626 0.66%
18 NoonSixCap 57 8,641 0.66%
19 WallStCynic 57 12,900 0.44%
20 GothamResearch 57 21,900 0.26%
21 herbgreenberg 57 399,000 0.01%
22 Valuetrap13 56 9,514 0.59%
23 valuewalk 56 47,400 0.12%
24 UnionSquareGrp 55 4,922 1.12%
25 PlanMaestro 55 10,200 0.54%
26 ReformedBroker 55 882,000 0.01%
27 SkeleCap 54 6,154 0.88%
28 FatTailCapital 54 6,964 0.78%
29 ShortSightedCap 53 5,642 0.94%
30 footnoted 53 20,200 0.26%
31 Mega_Man_2 52 4,147 1.25%
32 JacobWolinsky 51 5,350 0.95%
33 zerohedge 51 440,000 0.01%
34 FundyLongShort 50 3,585 1.39%
35 MugatuCapital 50 8,890 0.56%
36 DumbLuckCapital 49 4,955 0.99%
37 Hedge_FundGirl 49 5,850 0.84%
38 PresciencePoint 49 9,004 0.54%
39 DavidSchawel 49 30,700 0.16%
40 pmarca 49 671,000 0.01%
41 fundiescapital 48 3,148 1.52%
42 ActAccordingly 48 3,547 1.35%
43 EquityNYC 48 5,223 0.92%
44 nosunkcosts 48 5,674 0.85%
45 MicroFundy 48 7,957 0.60%
46 BergenCapital 48 28,400 0.17%
47 marginalidea 47 1,843 2.55%
48 Keubiko 47 4,542 1.03%
49 Jesse_Livermore 47 37,100 0.13%
50 PainCapital 46 8,446 0.54%
51 EdBorgato 46 8,843 0.52%
52 SmallCapLS 45 2,679 1.68%
53 RodBoydILM 45 3,388 1.33%
54 AlexRubalcava 45 5,828 0.77%
55 LadyFOHF 45 13,000 0.35%
56 activiststocks 45 13,100 0.34%
57 firstadopter 45 33,400 0.13%
58 WarrenBuffett 45 1,310,000 0.00%
59 WSJ 45 14,900,000 0.00%
60 realDonaldTrump 45 39,800,000 0.00%
61 xuexishenghuo 44 2,693 1.63%
62 cablecarcapital 44 3,322 1.32%
63 probesreporter 44 4,082 1.08%
64 GrantsPub 44 25,400 0.17%
65 business 44 4,290,000 0.00%
66 DennyCrane550 43 1,018 4.22%
67 Seventeen_Mile 43 3,484 1.23%
68 StaleyRdCap 43 4,478 0.96%
69 AureliusValue 43 4,660 0.92%
70 Find_Me_Value 43 6,925 0.62%
71 davidein 43 30,800 0.14%
72 maxvision33 42 1,831 2.29%
73 ValueDude 42 1,985 2.12%
74 Fritz844 42 3,321 1.26%
75 plainview_ 42 3,645 1.15%
76 TMTanalyst 42 12,100 0.35%
77 manualofideas 42 17,400 0.24%
78 QTRResearch 42 19,500 0.22%
79 matt_levine 42 59,200 0.07%
80 StrangestTribeX 41 1,324 3.10%
81 LibertyRPF 41 3,500 1.17%
82 AZ_Value 41 3,845 1.07%
83 FCFYield 41 4,562 0.90%
84 GlaucusResearch 41 5,775 0.71%
85 HardcoreValue 41 9,801 0.42%
86 PhilipEtienne 41 10,400 0.39%
87 HedgeyeENERGY 41 11,000 0.37%
88 TigreCapital 40 1,841 2.17%
89 CopperfieldRscr 40 3,336 1.20%
90 covenantlite 40 3,454 1.16%
91 adoxen 40 3,695 1.08%
92 HedgeyeHWP 40 7,934 0.50%
93 mjmauboussin 40 24,500 0.16%
94 TruthGundlach 40 36,400 0.11%
95 bespokeinvest 40 61,100 0.07%
96 UnderwaterCap 39 2,098 1.86%
97 jay_21_ 39 2,303 1.69%
98 schaudenfraud 39 2,808 1.39%
99 JohnHuber72 39 8,949 0.44%
100 mark_dow 39 37,200 0.10%


Methodology

To find the 100 best finance handles to follow on Twitter in 2018, we first developed a curated seed list of ~120 heavy financial users who are active investors and on Twitter. In order to maintain the privacy of these users, we cannot reveal their Twitter handles, but they effectively constitute a panel of experts.

We created a list of all of the Twitter handles that these 120 folks follow on Twitter. We then aggregated this list to find the handles that are most frequently followed across all of the accounts on the seed list. The popularity ranking represents the number of accounts from the seed list that follow the ranked handle. For handles that have the same popularity ranking, they are ranked by the percentage of that handle’s total followers that are on this list (to adjust for larger accounts).

Of course, no list is perfect, there are definitely some false positives and false negatives in here. Overall, though, we think a user interested in staying apprised on equities would be well advised to follow every user on this list.

Note: this list has a decidedly equities-oriented focus, based on the current nature of our product and our interest in information about individual companies. For a more macro/markets oriented list, check out this post from StreetEye.

Assessing Fed Chair Hopefuls With NLP Analysis Of Past Speeches

This article was originally published in Forbes

Our third article on the Fed leverages third-party political trend data as well as powerful Sentieo opinion mining to break down past speeches from top contenders for the Fed Chair. We discuss possible 2018 scenarios and delve deeper into the surprising results we come across. Brush up on the previous articles and see what’s coming up next in our series using the FedSpeak lexicon here:

Sentiment Analysis Of FOMC Statements Reveals A More Hawkish Fed
Why Is The Fed Still Raising Rates? The Yellen Effect
Assessing Fed Chair Hopefuls With NLP Analysis Of Past Speeches
Predicting The FOMC Statement With Beige Book Sentiment Data

From left, Gov. Jerome Powell, Former Vice Chairman Stanley Fischer, Federal Reserve General Counsel Scott Alvarez, and Federal Reserve Chair Janet Yellen, speak together following a Board of Governors meeting. (AP Photo/Andrew Harnik)

We set out to analyze the historical speeches of the top Fed candidates with Sentieo’s natural language processing capabilities and in the process, we learned something interesting. It doesn’t matter.

The Federal Reserve is not a one-woman organization and while the chair tends to drive policy, the minutes reveal that the entire committee weighs in on decisions. Some subtle changes over the course of this year have changed the makeup of the FOMC into a more hawkish committee. Furthermore, the composition of the FOMC will change when four of the regional bank presidents and voting members rotate out for their peers.

Earlier this year, Daniel Tarullo resigned. And just a little over a month ago, Stanley Fischer, a longtime central banker, resigned from Fed Board of Governors. In their place, Donald Trump has nominated Randal Quarles, a monetary hawk who favors a rule-based approach to monetary policy, as vice chair for bank supervision. Unfortunately, transcripts of Mr. Quarles views on monetary policy are not readily available, so he is not included in the quantitative analysis.

Read More

Why Is The Fed Still Raising Rates? The Yellen Effect

This article was originally published in Forbes

Our second investigation of the Fed’s sentiment discusses the impact Chairwoman Yellen has had on the Federal Reserve since her rise to the Chair in 2014. We created and utilized our ‘FedSpeak’ lexicon to delve into the correlation between the Fed’s intentions and Yellen’s speeches before colleagues, Congress, and the press. Read the previous article and see what’s coming up next in our series here:

Sentiment Analysis Of FOMC Statements Reveals A More Hawkish Fed
Why Is The Fed Still Raising Rates? The Yellen Effect
Assessing Fed Chair Hopefuls With NLP Analysis Of Past Speeches
Predicting The FOMC Statement With Beige Book Sentiment Data

Federal Reserve Board Chairwoman Janet Yellen speaks during a news conference following a meeting of the Federal Open Market Committee September 20, 2017 in Washington, DC. Yellen announced that the Fed will not change interest rates this quarter. This is one of the last meetings before Chair Janet Yellen’s four-year term ends in February.

The Federal Reserve conducts the nation’s monetary policy under a mandate from Congress to promote maximum employment, stable prices, and moderate long-term interest rates in the U.S. economy.

The Fed began its current round of rate hikes in 2015, and the Fed Funds target rate now stands at 1.25%, up from 0% two years ago.

Read More

Sentiment Analysis Of FOMC Statements Reveals A More Hawkish Fed

This article was originally published in Forbes

This piece kicks off our new series on the analysis of the Federal Reserve using Sentieo’s natural language processing power and flexible Doc Search technology. We will focus on bringing interesting ideas and surprising revelations derived from thousands of public federal reserve documents. Join us as we scrutinize meetings, congressional testimonies, and press conferences with some truly impressive technology; and see what’s coming up next in our series:

Sentiment Analysis Of FOMC Statements Reveals A More Hawkish Fed
Why Is The Fed Still Raising Rates? The Yellen Effect
Assessing Fed Chair Hopefuls With NLP Analysis Of Past Speeches
Predicting The FOMC Statement With Beige Book Sentiment Data

The Federal Reserve System’s Federal Open Market Committee (FOMC) meets eight times a year, at 2 p.m. Eastern Time in the basement of a nondescript, Washington, D.C. office building. The terse statements released after those meetings drive the direction of global financial markets and the meeting minutes are carefully scrutinized carefully by the media.

We parsed recent statements and minutes since 2012 using Sentieo’s natural language processing and sentiment analysis and found some interesting trends.

For the most recent statement 9/20, the strongest topic continued to be inflation, as highlighted in the unfiltered word cloud shown here.

The intensity was roughly equivalent to the prior statement, as the Fed continues to be vexed by an inflation shortfall versus expectations. Based on the statements alone, this analysis would suggest that Fed intentions have barely changed.  However, when we apply sentiment analysis to the words in the documents using the Loughran-McDonald context-specific lexicon, which assigns a simple positive or negative value to words based on the financial services industry context, the 9/20 statement occurs as much more hawkish.

Read More

Wells Fargo Cross-Sell, Senator Elizabeth Warren And Unstructured Financial Data

On August 31, 2017, Wells Fargo (WFC) announced it completed an expanded third-party review of retail bank accounts which increased the number of potentially unauthorized consumer and small business accounts to 3.5 million from 2.1 million. In addition, an additional 528,000 accounts had potentially unauthorized online bill pay enrollments.

Nearly a year ago on September 20, 2016, WFC CEO, John Stumpf, testified in front of the Senate Banking Committee regarding the “cross-selling” scandal which also cost 5,300 employees their jobs. WFC never provided the “cross-sell” metric in a table format in public filings, and as a result the data cannot be derived from legacy financial research platforms.

During the hearing, Senator Elizabeth Warren highlighted:

  • The word “cross-sell” appeared in every transcript from 2012 through 2014.
  • Stumpf first mentioned “cross-sell” in 2010 AR, highlighting he picked the target 8. He picked the target 8 because it rhymed with great.
  • The correlation between the WFC stock price and the number of times “cross-sell” was mentioned.
  • All 12 printed transcripts were submitted as evidence.

Read More

Sentieo Document Search Weighs In On The Elliott / Arconic Battle

This article was originally published in Forbes.

Earlier this year, Elliott Management, a $31 billion activist hedge fund led by legendary manager Paul Singer, fought a long drawn out battle with Arconic, a metals engineering and manufacturing spinoff of aluminum giant Alcoa. Among the issues to arise from this fight was a particularly nasty corporate governance revelation about a hidden pension liability that takes effect upon a change in control.

At Sentieo, we watched from the sidelines with interest as the story developed, leaning on our indexed repository of public financial documents to uncover the material facts of this case. Our analysis revealed that potential “corporate governance risk” is a hidden aspect of equity investing that even sophisticated investors like multi-billion dollar hedge funds may not have adequate tools to assess.

Here are the facts (throughout the article below we’ve provided links to source documents in our Sentieo public document viewer):

On November 23, 2015, Elliott filed a 13D with the SEC which indicated that it had built a position of over 5% in Alcoa with the intention to influence the company’s management and board of directors.

On February 1, 2016, the company, still known as Alcoa, announced its intention to appoint three Elliott nominees to its board of directors. In November of 2016, the former Alcoa split into the new Alcoa, a pure-play aluminum producer, with the remains of the old company becoming Arconic, specializing in lightweight metals engineering and manufacturing for customers in aerospace and automotive.

Exactly one year later, Elliott Management published a letter to Arconic pointing out that their attempts to privately coax management into making improvements had not succeeded and they felt the need to move their arguments into public view.

Read More

Announcing Our Partnership With 7Park For Alternative Data!

We’re pleased to announce that we are one of 7Park Data’s launch partners for their new API product. Starting today, 7Park customers who also use Sentieo can access their data in Plotter and Mosaic. 7Park’s data offerings available via API include web and mobile app traffic data, retail purchase data, and more.

The combination of 7Park data in Sentieo’s alternative data suite makes discovering alpha opportunities possible without hiring a quant. 7Park Data can be easily added to a chart or statistical analysis including other sources of alternative data, financial metrics like revenue or stock price, and your own data. Examples displaying how this data can be used are presented below.

In the words of one of our customers:

“Sentieo gave me a way to make sense of the data without having to spend budget on a full-time quant. Several points of my returns have been inspired.”

Contact your Sentieo Customer Success rep or e-mail us at hello@sentieo.com to get a demo of how this product can generate investment ideas for you. If you are not a current Sentieo customer, you can request a trial here.