My broker (IB) has “Company Fundamentals” for most instruments. It has a lot of info like financial statements, ratios, and includes analysts ratings (there are 12 following SHOP). A link is provided to their Tip Ranks page. There’s details on estimates, high , low, median, mean. I used mean estimates. Here is what’s listed
Year Rev (E)* Actual Adj net income (E)* Actual
2015 $ 196MM $ 205MM $ (10.7)MM $ (7.7)MM
2016 381MM 389MM (12.6)MM (10.3)MM
2017 660MM 673MM 5.3 MM 15.2 MM
2018 1,057MM 33.8 MM
2019 1,475MM 77.7 MM
2020 1,955MM 163.9 MM
- I used the “mean” analyst est column
The data shows out to 2022 but I discount that becasue it’s just too far to predict.
On the revenue side they’re TTM is $952MM from checking M*. They need 4Q18 to be $328MM to make the estimate, +47% YoY and +21½% sequentially. IB has the 4Q18 Rev estimate at $328MM, so seems legit :-). IB also showing next 3 quarters at $308 to $373MM.
On the adj net side they’re needing $22.4MM to make analysts $33.8MM. In the 3Q report, guidance says this…
For the full year 2018, Shopify currently expects:
Revenues in the range of $1.045 billion to $1.055 billion
GAAP operating loss in the range of $95 million to $97 million
Adjusted operating profit in the range of $8 to $10 million, which excludes stock-based compensation expenses and related payroll taxes of $105 million
For the fourth quarter of 2018, Shopify currently expects:
Revenues in the range of $315 million to $325 million
GAAP operating loss in the range of $15 million to $17 million
Adjusted operating income in the range of $16 million to $18 million, which excludes stock-based compensation expenses and related payroll taxes of $30 million
So the analysts are expecting a beat for 4Q18. You know what happens if they just “meet”…even on the high end it seems.
I’m also aware of “analysts models” and know that Mr. Tobi could keep expenses higher for longer. To that end here’s the estimates of CapEx going forward with past years actual - again mean analysts estimates for future…in $ millions…
2015 16.5MM
2016 26.2MM
2017 20.0MM
2018 30.6MM
2019 38.4MM
2020 47.9MM
So no slowdown here
R&D remains 22% of sales…huge but I don’t know how that compares to others.
Analysts must see a future slow down in another astounding number… Sales & Marketing expense almost 35% of sales now.
Joe
Not Scared