Filing Flows › Companies › Shopify › Analysis traps
Shopify (SHOP): analysis traps
Where its figures could mislead a reader, and what to check before taking them at face value · Data: Q3 2026, to Sep 30, 2026, filed Nov 3, 2026; rules v1.1
Shopify (SHOP): 1 rule of 10 triggered on the filings to Sep 30, 2026: stock compensation added back = no economic cost. 1 to review; 3 with insufficient data; 2 not applicable. Each is a question to verify, with the normal explanation that would produce the same figures.
Check these first
Stock compensation added back = no economic cost Triggered · severity medium · confidence high
Stock compensation was $449M, 3.9% of revenue, in FY2025; buybacks were $0 (0.0× the SBC) and buybacks did not cover it. 'Adjusted' figures that add SBC back treat pay in shares as free; the cost is borne by every shareholder as dilution, or by the cash spent to buy the shares back.
Innocent reading: A young company paying in equity while it scales; intensity falls as revenue grows.
A precise DCF value = the true value To review · confidence high
The DCF's point value is 23.25 a share (price 143.75); 66% of it is the terminal value, a number about years no one has seen. Moving operating margin by ±3 pts alone takes it from 18.99 to 27.51; across every method the research ran the range is 10 to 220. The value is a range; the decimals are not information.
Innocent reading: A stable, mature business with a narrow range of outcomes, where the point value is a fair summary.
Every rule
A01 FCF growth = the business improved Not triggered confidence medium
Free cash flow rose $410M to $2.0B; working capital and lower capex explain 26% of it, so most of the gain is in operating cash flow itself.
The figures and how they are read
| Fiscal year before | FY2024 |
| Fiscal year | FY2025 |
| Operating cash flow, year before | $1.6B |
| Operating cash flow | $2.0B |
| Capex, year before | $19M |
| Capex | $26M |
| Free cash flow, year before | $1.6B |
| Free cash flow | $2.0B |
| Change in FCF | $410M |
| Change in capex | $7M |
| Working capital: change in its cash contribution | $108M |
| Of which: capex cut | 0.00 |
| Of which: working capital released | $108M |
| Share of the increase that need not repeat | +26.3% |
| Operating cash flow before working capital: change | 309000000.00 |
FCF = operating cash flow − cash capex; ΔFCF = ΔOCF − ΔCapEx; the working-capital part is the change in the cash-bridge items (receivables, inventory, payables, accruals), with the sign of the cash flow statement
Source: FY2025 (cash flow statement, fiscal year) · FY2024 (cash flow statement, fiscal year before)
A07 Stock compensation added back = no economic cost Triggered severity medium · confidence high
Stock compensation was $449M, 3.9% of revenue, in FY2025; buybacks were $0 (0.0× the SBC) and buybacks did not cover it. 'Adjusted' figures that add SBC back treat pay in shares as free; the cost is borne by every shareholder as dilution, or by the cash spent to buy the shares back.
The figures and how they are read
| Fiscal year | FY2025 |
| Stock compensation | $449M |
| Revenue | $11.6B |
| SBC / revenue | +3.9% |
| Buybacks | 0 |
| Buybacks / SBC | 0.0 |
| Diluted shares, year before | 1,301.5M shares |
| Diluted shares | 1,305.0M shares |
| Diluted shares: change | +0.3% |
SBC / revenue from the cash flow statement's add-back; the diluted weighted share count year over year; buybacks from the financing section
Source: FY2025 (stock compensation, buybacks and the diluted share count, fiscal year)
What would explain it innocently
- A young company paying in equity while it scales; intensity falls as revenue grows
- Buybacks at prices below intrinsic value make up for the dilution over time
- A one-off grant (an acquisition, a founder award) rather than a steady level
What to look for in the filing
- The share count after the latest buybacks (the next 10-Q's cover)
- The price paid for the buybacks against the shares' value
- Unvested awards outstanding
What would show the trap does not apply
- The diluted share count falls over two years with buybacks at least equal to the stock compensation
- Stock compensation falls as a share of revenue in each of the next two years
Look again: next filing.
B02 Receivables growing = future cash is certain Not triggered confidence medium
Receivables grew 51% against revenue 34% in Q1 2026; DSO 13 against a median of 12: collections are keeping pace with sales.
The figures and how they are read
| Quarter | Q1 2026 |
| Revenue, year over year | +34.3% |
| Receivables, year over year | +51.2% |
| Quarter before | Q4 2025 |
| Revenue y/y, quarter before | +30.6% |
| Receivables y/y, quarter before | +46.2% |
| Days sales outstanding | 13.5 |
| DSO, median of eight quarters | 12.1 |
| Receivables | $449M |
| Revenue | $3.2B |
receivables and revenue against the same quarter a year earlier; DSO = receivables / quarterly revenue × days, against the median of the eight quarters before
Source: Q1 2026 (receivables and revenue) · Q1 2025 (the same quarter a year earlier)
B08 Adjusted profit = economic profit Insufficient data
no reconciliation table read from the releases yet and fewer than three quarters with both an adjusted and a GAAP EPS
C02 Low net debt = no refinancing risk Insufficient data
no debt figure could be read from the balance sheet (the filing may tag it in other lines)
D03 EPS growth = profit growth Insufficient data
no quarter with EPS, net income and diluted shares for both this year and last
E02 Low P/E at a cyclical peak = undervalued Not triggered confidence medium
Net income of $2.1B is not at a cyclical high against the last eight years (median $320M, best $2.9B): the P/E of 87.3× is on a normal year.
The figures and how they are read
| market value | $185.5B |
| net income ttm | $2.1B |
| pe ttm | 87.30 |
| net income median fy | $320M |
| pe mid cycle | 580.70 |
| net income peak fy | $2.9B |
| years | FY2018 / -65.0; FY2019 / -125.0; FY2020 / 320.0; FY2021 / 2915.0; FY2022 / -3460.0; FY2023 / 132.0; FY2024 / 2019.0; FY2025 / 1231.0 |
| down years in window | 3 |
P/E on the trailing twelve months' net income against the P/E on the median net income of the last eight fiscal years (a mid-cycle stand-in); 'at a peak' = this year's profit at or above 90% of the best year and at least 1.3× the median
Source: Q3 2026 (net income, trailing twelve months)
E07 A precise DCF value = the true value To review confidence high
The DCF's point value is 23.25 a share (price 143.75); 66% of it is the terminal value, a number about years no one has seen. Moving operating margin by ±3 pts alone takes it from 18.99 to 27.51; across every method the research ran the range is 10 to 220. The value is a range; the decimals are not information.
The figures and how they are read
| dcf value | 23.25 |
| price | 143.75 |
| terminal value share | +66.3% |
| swing by input | Operating margin / ±3 pts / 18.99 / 27.51; Revenue growth (each year) / ±5 pts / 20.2 / 26.81; WACC / ±1 pt / 21.46 / 25.41; Tax rate / ±5 pts / 21.83 / 24.67 |
| range all methods | 9.66; 220.0 |
the DCF's point value against the share of it that is the terminal value and the value at each input moved by one step (growth ±5 pts, WACC ±1 pt, margin ±3 pts …); the range across every method the research ran
Source: 2026-11-08 (valuation research)
What would explain it innocently
- A stable, mature business with a narrow range of outcomes, where the point value is a fair summary
- The inputs that matter most are themselves well known (a regulated return, a long contract)
What to look for in the filing
- Which input you believe differs from the research's and why
- What the price implies for growth (the reverse DCF on the fair-value page)
What would show the trap does not apply
- The DCF's value is robust to the terminal growth and discount rate (the range's low end is still above the price)
- The company's cash flows over the next three years track the DCF's early years
Look again: next filing.
J06 A bank's low P/E and high profit = safe Not applicable
not a bank
J08 A REIT's low net income = the dividend is unsafe Not applicable
not a REIT
What the statuses mean
Triggered: the filings show the pattern; read the normal explanations and the missing evidence before concluding anything. To review: one quarter or a weak signal; a reader's judgement, not a pattern. Not triggered: the pattern is absent on these figures. Insufficient data: the filings read so far do not hold what the rule needs; this is not a clean bill. Not applicable: the rule is not meant for this kind of company (a bank's working capital, a loss-making quarter's EPS growth). Out of date: the latest filing is more than fifteen months old.
Severity is what the pattern could mean for cash, value or solvency; confidence is how reliable the inputs and the reading are. The two are kept apart.
Record a view
A reader's judgement, grounds, what would change it and the next review; kept in the browser (needs JavaScript).
Every rule and the companies it triggers on → Shopify: cash flow → Earnings quality score →
Each rule reads the company's own filings by a fixed formula and says what would explain the same figures innocently. A triggered rule is a question to verify, not a finding of manipulation, and not a view on the stock. Missing data is shown as missing, never as clear. Not investment advice.