ESTC Oct18 Q Review (belated)

HUGE thanks to hlygrail who posted a table here which I will steal: https://discussion.fool.com/elastic-estc-ipo-research-and-discus… Haven’t seen you post here in a couple months, hlygrail, but I hope you’re doing well! I have added a column for the Quarter ending October 2018, and some rows. I’ve also added a table for valuation metrics, which I think are worth looking at for any company, especially ESTC since its valuation is so far from the norm.

Company progress metrics


                  7/16    10/16     1/17     4/17     7/17    10/17     1/18     4/18     7/18    10/18
Calculated Billings                                   33.6     51.3                       59.2     88.5

Revenue        $16,572   21,305   23,128   27,172   31,644   37,038   41,681   49,572   56,644   63,575
  (QoQ change%)            28.6%     8.6%    17.5%    16.5%    17.0%    12.5%    18.9%    14.3%    12.2%
  (YoY change%)                                       90.9%    73.8%    80.2%    82.4%    79.0%    **71.6%**

Gross Profit    12,629   16,915   17,948   20,840   24,230   28,078   30,915   35,972   41,087   44,988

OpEx            20,924   23,673   39,591   31,316   33,404   35,204   43,374   55,207   59,502   72,058
  (YoY change%)                                                                                   **104.7%**

Operating Loss  (8,295)  (6,758) (21,643) (10,476)  (9,174)  (7,126) (12,459) (19,235) (18,415) (27,070)

Stock-Based Comp 1,098    1,195   15,087    1,506    2,254    2,770    3,554    4,164    5,665   **11,239**

Customer Count                                                                           5,500    6,300

Cust w ACV > 100k                                                                          300      340

The numbers in bold are numbers I didn’t really love from the Q. I especially hate to see operating costs rising faster than revenue or gross profit. I’m sure the company is investing for continued growth, but this imbalance is just an ugly look in my opinion.

Valuation metrics


                                                        1/15/2019
Shares Outstanding (fully diluted, in mil)                   87.5
Shares Outstanding (ordinary, in mil)                        70.9
Share price as of this post                                 73.68
Cash (in mil) as of this post                               318.6
EV/S (fully diluted) as of this post                         **28.9**
EV/S (ordinary) as of this post                              23.1

Very instructive, in my opinion, to look at both the ordinary and fully diluted share count. In this company’s case, it’s a 23% increase in the share count if you look at fully diluted – the valuation is more than a billion dollars higher than it is at the ordinary share count!. The range of EV/S ratios (mid to high 20’s) makes me want to tread very cautiously with this stock. It’s going to be difficult for shares to appreciate significantly with a valuation that’s already this high and with a lot of dilution potentially coming down the pike.

Conclusion
This company is doing great. It’s impossible to argue with 72% revenue growth, but the valuation is stretched thin, more so than any other stock I follow (though ZS is close). Barring a buy-out, I predict the share price will settle into a range for several quarters. I don’t usually do this, but I am trading in and out with a small position (e.g recently bought at $64 and $66 and sold at $73). I just think when the company is valued this highly, I’ll wait with my money in other great companies (where I feel significant appreciation is more likely), and only buy back in to ESTC if we see a dip. If we don’t, no problem. There are plenty of others.

Bear

35 Likes

Hi Paul,

Great write up.
I did look at 10-Q and found 70.9M shares.
How did you get the 87.5M share count. I couldn’t find this difference in S1 (they had 28M preferred but those are converted to common at IPO and part of 70.9M as far as I can tell.)

BTW - Agree with your conclusion at 87M share count, its too richly valued.

Thanks
Nilvest

I did look at 10-Q and found 70.9M shares.
How did you get the 87.5M share count. I couldn’t find this difference in S1 (they had 28M preferred but those are converted to common at IPO and part of 70.9M as far as I can tell.)

They didn’t give it on their press release. But according to the 10-Q there are 25,393,707 options outstanding as of 10/31. https://www.sec.gov/Archives/edgar/data/1707753/000156459018… From what I remember from Finance school, there’s some calculation you have to do (the treasury method or something) to figure out the number of shares these options will result in (you back out however many shares the company can buy back with the money the company is paid when the options are exercised…or something).

Luckily an analyst asked:

Analyst: And then, here is simple question for Janesh. What’s the fully diluted share count so that we can calculate enterprise value?

Janesh Moorjani: 87.5 I believe when I last checked, but I will confirm that. 87.5, yes.

https://seekingalpha.com/article/4226355-elastic-n-v-estc-ce…

Bear

5 Likes

This is weird. I haven’t seen the diluted share count be as difficult to find with any other company. I just look at the press release and if it isn’t stated in the remarks, I check the financials and the diluted share count is listed for calculating Non-GAAP EPS.

The share count ESTC list is nowhere close to 87.5 million. It wasn’t close to the 70 million mentioned. Don’t have it in front of me, but I believe it was around 43M.

Why wouldn’t Elastic have used the 87.5M in the non-GAAP EPS calc?

Regards,
A.J.

1 Like

This is weird. I haven’t seen the diluted share count be as difficult to find with any other company. I just look at the press release and if it isn’t stated in the remarks, I check the financials and the diluted share count is listed for calculating Non-GAAP EPS.

The share count ESTC list is nowhere close to 87.5 million. It wasn’t close to the 70 million mentioned. Don’t have it in front of me, but I believe it was around 43M.

Why wouldn’t Elastic have used the 87.5M in the non-GAAP EPS calc?

Companies report the weighted average shares for the period which can throw the number of actual shares off my a fair amount if the companies issued a lot of new shares or share equivalents (e.g. options, equity financing, etc.) during the period. If the shares were issued near the end of the period the discrepancy will be larger. Such discrepancies can make a significant difference if one is using EV/S ratios as a guide.

Chris

5 Likes

Thanks Paul.

Thanks for the ESTC update. A few comments.

The expenses rising faster than revenue doesn’t overly concern me at this point due to ESTC having most of their revenue as SaaS revenue. I wish we had quarterly customer counts going back further (i looked but couldn’t find any numbers) because then we could trend their implied CAC (customer acquisition cost) by takings Sales and Marketing expenses and dividing that by the quarterly adds in customer count. If the CAC was dramatically increasing I would be more worried. Just a reminder for others reading this post. SaaS customers will lose more money the faster they are growing until they get pretty big because their expenses to acquire the customer (their CAC) are recognized immediately but the revenue from that customer is recognized over the length of that contract. This is a simplification but good enough for understanding the business.

The SBC was a bit of an eye popper. I’m wondering if a bunch of SBC was tied to completing the IPO or the swifttype acquisition? Definitely worth watching that one.

re: Phoolio, weighted average shares. Just to jump on what chris said. They had something like 30 million shares pre-ipo. They did their IPO and ended up with 70 million shares. They calculate the eps based on the percentage of time during that period they were at 30 million shares and 70 million shares…i.e. they weight it. My numbers might be a little off, but the concept should be right.

-e

3 Likes