Projected Income Statement: Shopify Inc.

Forecast Balance Sheet: Shopify Inc.

balance-sheet-analysis-chart SHOPIFY-INC
Fiscal Period: December 2019 2020 2021 2022 2023 2024 2025 2026
Net Debt 1 -2,455 -5,630 -6,857 -4,140 -4,092 -4,977 -7,092 -9,728
Change - -329.33% -221.79% -160.38% -198.84% -221.63% -242.5% -237.17%
Announcement Date 2/12/20 2/17/21 2/16/22 2/15/23 2/13/24 - - -
1USD in Million
Estimates

Cash Flow Forecast: Shopify Inc.

Fiscal Period: December 2019 2020 2021 2022 2023 2024 2025 2026
CAPEX 1 56.76 41.73 50.79 50.02 39 21.49 29.34 35.85
Change - -26.47% 21.7% -1.52% -22.03% -44.89% 36.51% 22.2%
Free Cash Flow (FCF) 1 13.86 383.2 453.6 -186.5 905 1,541 1,990 2,499
Change - 2,665.77% 18.37% -141.1% -585.34% 70.25% 29.17% 25.54%
Announcement Date 2/12/20 2/17/21 2/16/22 2/15/23 2/13/24 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Shopify Inc.

Fiscal Period: December 2019 2020 2021 2022 2023 2024 2025 2026

Profitability

        
EBITDA Margin (%) 4.52% 16.59% 16.53% 0.77% 11.53% 16.95% 19.26% 21.09%
EBIT Margin (%) 2.26% 14.93% 15.57% 0.11% 11.08% 16.57% 18.51% 19.76%
EBT Margin (%) -6.07% 8.2% 68.1% -64.7% 2.62% 14.64% 15.15% 16.39%
Net margin (%) -7.91% 10.91% 63.2% -61.79% 1.87% 13.15% 13.5% 14.89%
FCF margin (%) 0.88% 13.08% 9.84% -3.33% 12.82% 17.51% 18.43% 19.14%
FCF / Net Income (%) -11.1% 119.94% 15.56% 5.39% 685.61% 133.16% 136.53% 128.57%

Profitability

        
ROA 1.19% 8.73% 27.62% 0.39% 8.59% 13.63% 13.6% 16.25%
ROE 1.34% 10.43% 9.29% 0.49% 10.94% 16.36% 18.7% 20.46%

Financial Health

        
Leverage (Debt/EBITDA) - - - - - - - -
Debt / Free cash flow - - - - - - - -

Capital Intensity

        
CAPEX / Current Assets (%) 3.6% 1.42% 1.1% 0.89% 0.55% 0.24% 0.27% 0.27%
CAPEX / EBITDA (%) 79.64% 8.58% 6.66% 116.65% 4.79% 1.44% 1.41% 1.3%
CAPEX / FCF (%) 409.63% 10.89% 11.2% -26.82% 4.31% 1.39% 1.47% 1.43%

Items per share

        
Cash flow per share 1 0.0625 0.3442 0.396 -0.1078 0.7287 1.279 1.659 2.044
Change - 450.9% 15.06% -127.22% -775.97% 75.55% 29.71% 23.19%
Dividend per Share 1 - - - - - - - -
Change - - - - - - - -
Book Value Per Share 1 2.668 5.353 9.77 6.461 7.047 8.122 9.666 11.91
Change - 100.64% 82.51% -33.87% 9.06% 15.26% 19.02% 23.2%
EPS 1 -0.11 0.259 2.29 -2.73 0.1 0.8854 1.123 1.498
Change - -335.45% 784.17% -219.21% -103.66% 785.4% 26.88% 33.32%
Nbr of stocks (in thousands) 1,159,173 1,226,711 1,256,003 1,272,089 1,286,099 1,292,100 1,292,100 1,292,100
Announcement Date 2/12/20 2/17/21 2/16/22 2/15/23 2/13/24 - - -
1USD
Estimates
2024 *2025 *
P/E ratio 117x 92x
PBR 12.7x 10.7x
EV / Sales 14.6x 11.7x
Yield - -
More valuation ratios * Estimated data

EPS & Dividend

eps-dividend-chart SHOPIFY-INC

Year-on-year evolution of the PER

evolution-chart SHOPIFY-INC

Year-on-year evolution of the Yield

evolution-chart SHOPIFY-INC
Trading Rating
Investor Rating
ESG MSCI
AA
surperformance-ratings-light-chart SHOPIFY-INCMore Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
52
Last Close Price
103.35USD
Average target price
121.09USD
Spread / Average Target
+17.17%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. SHOP Stock
  4. Financials Shopify Inc.